Detailed Field Information Related Information Examples & Tutorials

Transaction Type

Transaction types give you the ability to categorize transactions for accounting and reporting. Through the Transaction Type form you set options to control calculations, breakdown payments, assign a specific operator and a sales person, designate a contact plan to run, and set the commission rate. You may view and modify existing transaction types in Collect! and create your own new ones. By setting up transaction types for the way you do business, you can automate many basic aspects of posting and processing your transactions.

Click to view details.
Transaction Type form

The Transaction Type form displays many settings that can be used to manage posting financial transactions to your accounts.

tip.gif Please refer to Transaction Type Basics for steps to access this form.

Predefined Transaction Types

Collect! provides many pre-defined transaction types in the Demonstration database for basic types of transactions you may expect to handle. You can copy any of these to the Masterdb database.

Transaction types are divided into groups of 100. The actual "centenary" markers are used as a header for the group. Although these markers have no settings, you can reference the description when building reports. This a handy way to provide a title for a group of transactions on your reports.

The following list contains all the transaction types provided for you by Collect!. Each one of these transaction types has its own settings. These are set in the Transaction Type for that specific Code, (e.g. 102, 303 etc.) You can modify these if you need to or add your own, depending on your business needs. You should seriously consider how your business operates before making any changes to the existing system.

100 PRINCIPAL AND INTEREST

101 Payment By Check
102 Payment By Cash
103 Closing Fee received
104 Money Order
105 Returned NSF Check
106 Payment of Agency NSF Fee
107 Check Payment Taken By Phone
110 Monthly Payment
150 Down Payment
151 Payment Plan Payment
160 Monthly Billing Amount
193 Payment Plan Initial Discount
194 Judgement Principal - don't modify - used internally
195 Original Judgement Interest - don't modify - used internally
196 Original Principal - don't modify - used internally
197 Original Interest - don't modify - used internally

200 LEGAL EXPENSES

201 Legal Fees
202 Taxable Cost

300 FEES AND OTHER EXPENSES

301 NSF Charge due Agency
302 Closing Fee
303 Locate Fee
310 Service Charge
320 Payment Plan Late Fee
321 Down Payment
350 Service charge
351 Late Fee - don't modify - used internally
397 Client Fee - don't modify - used internally
398 Debtor Fee - don't modify - used internally
399 Collection Fee - don't modify - used internally

400 INTEREST

401 Interest Adjustment
402 Accrued Compound Interest
495 Additional Judgement Interest
499 Total Accrued Interest - don't modify - used internally

500 ADJUSTMENTS

501 Adjustment by Client
502 Adjustment by Court Order
599 Adjustment through Upgrade - don't modify - used internally

600 INTERNAL EXPENSES

601 Agency Internal Expenditure

Top of page.

Code

This field shows the Code for this Transaction Type. The Code identifies the type of transaction you are posting. Whenever you post transactions, you pick the Code from the list of Transaction Types and all the settings for that type are copied into the Transaction form.

These codes are organized in groups of 100 with the "centenary codes", i.e. 100, 200, 300 etc. reserved as titles for the group.

- 100 PRINCIPAL
- 101-199 Principal and Interest

- 200 LEGAL
- 201-299 Legal Expenses

- 300 OTHER
- 301-399 Other Expenses

- 400 INTEREST
- 401-499 Interest Adjustments

- 500 ADJUSTMENTS
- 501-599 Other Adjustments

- 600 INTERNAL EXPENSES
- 601-699 Agency Internal Expenses

Please note that you should leave codes 100, 200, 300, 400, 500 and 600 as titles for each group. This conveniently divides your types and Collect! uses these in trust reports as column headings. Use codes 101, 201, 301, 401, 501, 601 as the starting codes for transaction types you want to list in each group. You can also create your own groups and codes and then create reports to reference transactions posted with these codes.

tip.gif Please note that Collect! uses the following transaction types internally so they should not be deleted or modified.

194 Judgement Principal
195 Original Judgement Interest
196 Original Principal
197 Original Interest
351 Late Fee
397 Client Fee
398 Debtor Fee
399 Fee for Agency Commission

Top of page.

Description

This is a brief description of the Transaction Type. For codes 100, 200, 300, 400, and 500, the Description should be the title you want to see in your Trust Account Report for the section that lists transactions in each group.

Top of page.

Copy Description To Transaction

Switch this ON with a check mark so that whenever you post a transaction of this Transaction Type, the Description will automatically be copied to the transaction's Description field.

Top of page.

Financial Type

The Financial Type setting determines the financial category of each transaction. Financial types can be Payment, Principal, Interest, Fee, Legal, Misc, Other, Adjustment, or Internal. The dotted radio button in this column sets the transaction's financial type. This is very important for processing money amounts when a transaction is posted. The money amount of the transaction will be allotted to the financial area you choose here, that is, Payment, Principal, Interest, Fee, Legal, Misc, Other, Adjustment or Internal.

Top of page.

Payment

Place a dot in this radio button to flag this Transaction Type as a Payment. Transactions will be posted as payments to the debtor's account and will be totaled in the Paid field on the Debtor screen as well as being calculated in financial statements and reports.

Top of page.

Principal

Place a dot in this radio button to flag this Transaction Type as Principal. Transactions will be posted as principal to the debtor's account and will be totaled in the Principal field on the Debtor screen as well as being calculated in financial statements and reports.

Top of page.

Interest

Place a dot in this radio button to flag this Transaction Type as Interest. Transactions will be posted as interest to the debtor's account and will be totaled in the Interest field on the Debtor screen as well as being calculated in financial statements and reports.

Debtor's total interest is Original Interest plus any Accrued Interest minus any positive transactions posted to the debtor's Interest account.

Top of page.

Fee

Place a dot in this radio button to flag this Transaction Type as a Fee. Transactions will be posted as fees to the debtor's account and will be totaled in the Fees field on the Debtor screen as well as being calculated in financial statements and reports.

Fees = all transactions posted to the debtor's Fee account.

To charge a fee, post the amount as a debit to the debtor's Fee account. To post a debtor payment to cover a fee, post the amount as a credit to the debtor's Fee account.

Top of page.

Legal

Place a dot in this radio button to flag this Transaction Type as a Legal Fee. Transactions will be posted as legal fees to the debtor's account and will be totaled in the Legal Fees field on the Debtor screen as well as being calculated in financial statements and reports.

Top of page.

Misc

Place a dot in this radio button to flag this Transaction Type as Miscellaneous. Transactions will be posted as miscellaneous transactions to the debtor's account and will be totaled in the Miscellaneous field on the Debtor screen as well as being calculated in financial statements and reports.

Top of page.

Other

Place a dot in this radio button to flag this Transaction Type as an Other type. Transactions will be posted in the Other category on the debtor's account and will be totaled in the Other Charges field on the Debtor screen as well as being calculated in financial statements and reports.

Top of page.

Adjustment

Place a dot in this radio button to flag this Transaction Type as an Adjustment. Transactions will be posted as adjustments to the debtor's account and will be totaled in the Adjustments field on the Debtor screen as well as being calculated in financial statements and reports.

Adjustments = all transactions posted to the debtor's Adjustment account.

Posting a credit to the account reduces the debtor's Owing. A debit increases the debtor's Owing.

Top of page.

Internal

Place a dot in this radio button to flag this Transaction Type as Internal. Transactions will be posted to the debtor's account for tracking purposes. However, the amount will not affect either the Debtor's totals or the Client's Commission or Return.

tip.gif The Internal transaction type is used for tracking internal agency expenses connected with a particular account. These expenses are borne entirely by the agency and do not affect either the Debtor or Client financials in any way.

Top of page.

Enter Amount On Posting

If you place a dot in this radio button, when each transaction is posted, the user must fill in the amount of the transaction.

Top of page.

Payment Breakdown

This function enables you to post payments broken down into to Fees, Interest, Principal, Legal, Misc and Other. Place a dot in this radio button to select this option.

When you enable Payment Breakdown, additional fields become visible where you can select the order that you want to use for distributing the payment amount. By default, Collect! posts to Fees, then Interest, and finally to Principal. You can change this order and optionally add additional breakdown order for Legal, Misc and Other financial types. Please refer to the section below on Payment Breakdown and Compound Interest for further details.

Top of page.

Use Dollar Amounts

When you place a dot in the radio button to select this option, four additional fields appear, labeled To agency, Direct, Commission and Tax. In the appropriate field, enter the dollar amount of the transaction (as a number from 1 to 100.). When the user posts a transaction of this Transaction Type, the dollar amount will automatically be copied to the correct field on the transaction.

tip.gif Remember that a positive amount is a credit to the account!

Top of page.

Percent Of Principal

When you place a dot in the radio button to select this option, four additional fields appear, labeled To agency, Direct, Commission and Tax. In the appropriate field, enter the Percent of Principal of the transaction (as a number from 1 to 100.) When the user posts a transaction of this Transaction Type, Collect! will calculate the correct percentage and the amount will automatically be copied to the correct field on the transaction.

tip.gif Remember that a positive percent is a credit to the account!

Top of page.

Percent Of Owing

When you place a dot in the radio button to select this option, four additional fields appear, labeled To agency, Direct, Commission and Tax. In the appropriate field, enter the Percent of Owing of the transaction (as a number from 1 to 100.) When the user posts a transaction of this Transaction Type, Collect! will calculate the correct percentage and the amount will automatically be copied to the correct field on the transaction.

tip.gif Remember that a positive percent is a credit to the account!

Top of page.

Percent Of Interest

When you place a dot in the radio button to select this option, four additional fields appear, labeled To agency, Direct, Commission and Tax. In the appropriate field, enter the Percent of Interest of the transaction (as a number from 1 to 100.) When the user posts a transaction of this Transaction Type, Collect! will calculate the correct percent of any Accrued Interest and the amount will automatically be copied to the correct field on the transaction.

tip.gif Remember that a positive percent is a credit to the account!

For example, we created a 499 Transaction Type with Account Interest, 'Percent of interest' turned on, and -100 in the To Us field. This takes any current Accrued Interest on the account and posts it as a transaction.

tip.gif Combining this with the Edit Contact Event to roll forward the 'Calculate interest from date' in the Financial Detail form, you can create interesting and very powerful automation effects. For an example, please refer to Help topic, Accrued Interest - Tracking Month by Month.

Top of page.

Percent Of Payment

When you place a dot in the radio button to select this option, four additional fields appear, labeled To agency, Direct, Commission and Tax. In the appropriate field, enter the Percent of Payment of the transaction (as a number from 1 to 100.) When the user posts a transaction of this Transaction Type, Collect! will calculate the correct percentage based on the value in the Payment Amount field in the Debtor's Financial Details and the amount will automatically be copied to the correct field on the transaction.

tip.gif Remember that a positive percent is a credit to the account!

Top of page.

Payment Order

These fields are visible only when you have selected " Payment breakdown." These fields allow you to choose the order in which Collect! will apply the payment amount to the debtor's account when a transaction of this Transaction Type is posted. Select the down arrow to view a pick list where you can choose Fees, Interest, Principal, Legal, Misc or Other. You can also select a blank [-] from the pick list to limit your breakdown to fewer than the six financial type categories.

1

Select the down arrow next to this field to choose the first category to pay off when applying payments of this Transaction Type to the debtor's account.

2

Select the down arrow next to this field to choose the second category to pay off when applying payments of this Transaction Type to the debtor's account. Select a blank [-] to limit your breakdown to your first choice.

3

Select the down arrow next to this field to choose the third category to pay off when applying payments of this Transaction Type to the debtor's account. Select a blank [-] to limit your breakdown to your first two choices.

4

Select the down arrow next to this field to choose the fourth category to pay off when applying payments of this Transaction Type to the debtor's account. Select a blank [-] to limit your breakdown to your first three choices.

5

Select the down arrow next to this field to choose the fifth category to pay off when applying payments of this Transaction Type to the debtor's account. Select a blank [-] to limit your breakdown to your first four choices.

6

Select the down arrow next to this field to choose the sixth category to pay off when applying payments of this Transaction Type to the debtor's account. Select a blank [-] to limit your breakdown to your first five choices.

Top of page.

Dollar Amounts

You can enter amounts in this area when you select "Use dollar amounts." Enter the actual dollar amount in the appropriate field. Collect! will use this amount whenever you post a transaction of this type.

tip.gif Remember that a positive dollar amount is a credit to the debtor's account.

Top of page.

To Agency

You can enter amounts in this field when you have chosen to enter an actual dollar amount or percent for this Transaction Type. Enter an amount or percent that will automatically be copied to the To Agency field when creating a transaction of this Transaction Type.

Top of page.

Direct

You can enter amounts in this field when you have chosen to enter an actual dollar amount or percent for this Transaction Type. Enter an amount or percent that will automatically be copied to the Direct field when creating a transaction of this Transaction Type.

Top of page.

Commission

You can enter amounts in this field when you have chosen to enter an actual dollar amount or percent for this Transaction Type. Enter an amount or percent that will automatically be copied to the Commission field when creating a transaction of this Transaction Type.

tip.gif The Commission tab contains many fields for setting commission rates if you want to set them at the Transaction Type level. Please see Commission and Tax Calculations below.

Top of page.

Tax

You can enter amounts in this field when you have chosen to enter an actual dollar amount or percent for this Transaction Type. Enter an amount or percent that will automatically be copied to the Tax field when creating a transaction of this Transaction Type.

tip.gif The Tax tab contains many fields for setting tax rates if you want to set them at the Transaction Type level. Please see Commission and Tax Calculations below.

Top of page.

Processing

Several switches can be set to determine how you will handle the reporting aspects when transactions of this Transaction Type are posted.

Top of page.

Write To Notes

Switch this ON with a check mark if you want Collect! to write a note to the debtor's Notes whenever a transaction of this type is posted.

Top of page.

Omit From Client Statement

Switch this ON with a check mark if you want Collect! to exclude transactions of this type when the client statement is generated for each period. You can override this when a particular transaction is being posted, if needed.

Top of page.

Omit From Daily Cash Report

Switch this ON with a check mark if you want Collect! to exclude transactions of this type when you print your Daily Cash report. You can override this when a particular transaction is being posted, if needed.

Top of page.

Use Confirmation Delay

Switch this ON to delay reporting transactions posted with this Transaction Type. This is useful for allowing time for a check to clear. The number of days delayed is taken from the Payment Posting Options form. Please refer to Transaction Confirmation Delay for details.

Top of page.

Use Control File

Switch this ON with a check mark to tell Collect! to run a control file whenever a transaction is posted using this Transaction Type. When this switch is enabled, a "control file" field becomes visible where you can enter the name of the control file you want to use.

tip.gif Collect! expects the control file to be in the {database}\control folder.

Top of page.

Control File

Enter the name of the control file you want Collect! to run whenever a transaction is posted using this Transaction. You can enter up to 7 alpha-numeric characters in this field. Collect! will add the ".ctf" extension.

The control file you enter here will be automatically entered into the "Control file" field whenever you create a transaction using this Transaction Type.

This field is only visible when the "Use control file" switch is enabled.

tip.gif Collect! expects the control file to be in the {database}\control folder.

Top of page.

Display

Several switches can be set to determine what fields you display when posting a transaction of this Transaction Type and to automatically generate invoice and receipt numbers.

Top of page.

Invoice Number

Switch this ON with a check mark if you want Collect! to automatically assign an Invoice Number to transactions of this type.

Invoice Numbers need these requirements:

1. This switch must be turned ON with a check mark.

2. The transaction must be posted as "Fees."

3. The amount posted must be a negative amount (debit) To Agency or Direct, or must be a positive (credit) Commission amount.

If these conditions are not met, Collect does not assign an Invoice Number even if the switch is ON.

tip.gif The Invoice Number is determined by adding one to the highest numbered invoice already in Collect!. You can change an existing Invoice Number so that Collect! will start at a number of your choice.

Top of page.

Receipt Number

Switch this ON with a check mark if you want Collect! to automatically assign a Receipt Number to transactions of this type.

Receipt Numbers need these requirements:

1. This switch must be turned ON with a check mark.

2. The transaction must be posted to the Payment account.

3. The amount posted must be a positive payment (credit) To Agency.

If these conditions are not met, Collect will not assign a Receipt Number even if the switch is ON.

tip.gif You can also generate receipt numbers for payments to Commission if you switch ON "Generate on Commission Field."

tip.gif The Receipt Number is determined by adding one to the highest numbered receipt already in Collect!. You can change an existing Receipt Number so that Collect! will start at a number of your choice.

Top of page.

Generate On Commission Field

Switch this ON with a check mark if you want Collect! to automatically assign a Receipt Number to transactions of this type.

Receipt Numbers will be generated if:

1. The "Receipt Number switch is also ON."

2. The transaction must be posted to the Payment account.

3. The transaction must be posted as a positive amount (credit) to Commission.

Top of page.

Hide To Us

Switch this ON with a check mark to hide the "To Us" field whenever this Transaction Type is selected.

Use this switch if you want to organize your transaction types according to Direct or To Us payments. This function simplifies work for the user, as they don't have to decide whether to post the transaction in the To Us or Direct field.

tip.gif Switch ON both the "Hide To Us" and "Hide Direct" to force the User to post to Commission. This is useful, at times, for posting fees and prepayment amounts.

Top of page.

Hide Direct

Switch this ON with a check mark to hide the "Direct" field whenever this Transaction Type is selected.

Use this switch if you want to organize your transaction types according to Direct or To Us payments. This function simplifies work for the user, as they don't have to decide whether to post the transaction in the To Us or Direct field.

tip.gif Switch ON both the "Hide To Us" and "Hide Direct" to force the User to post to Commission. This is useful, at times, for posting fees and prepayment amounts.

Top of page.

Commission And Tax Calculations

Several switches can be set to determine how you will handle calculations relating to transactions of this Transaction Type. You can set several rates and also apply the rates to different financial types.

Please refer to Help topic, Commission and Help topic, Tax for details.

tip.gif Rates set in these areas are used when a transaction of this Transaction Type is posted. These rates override the debtor's Commission Rate or Rate Plan which would ordinarily be used to calculate commission for a payment.

Top of page.

Don't Calculate Commission

Switch this ON with a check mark to tell Collect! NOT to calculate commission whenever a transaction of this type is posted. You can override this when a transaction is being posted, if needed.

Top of page.

Don't Calculate Tax

Switch this ON with a check mark to tell Collect! NOT to calculate tax whenever a transaction of this type is posted. You can override this when a transaction is being posted, if needed.

Top of page.

Operator

Select the down arrow, or press F2, to view the list of Operators. A choice in this field forces the transaction to be posted to the Operator ID selected. This is useful for transactions that you don't want included in the standard Operator commission reports. For example, payments to precollect accounts should probably be assigned to either the system or to management, to avoid inclusion in any particular operator's Transaction Summary Reports.

Top of page.

Sales

Select the down arrow, or press F2, to view the list of Operators. A choice in this field forces the transaction to be posted to the Sales ID selected. This is useful for transactions that you don't want included in the standard Operator commission reports. For example, payments to precollect accounts should probably be assigned to either the system or to management, to avoid inclusion in any particular operator's Transaction Summary Reports.

Top of page.

Run Contact Plan

Select the down arrow, or press F2, to view the list of Contact Plans. Select a contact plan to run when a Transaction of this Type is posted. The contact plan displayed is this field will run automatically as the transaction is saved. This is useful for setting up custom contact schedules that depend on the type of payment or debit posted.

POST PAYMENT SEQUENCE

When you post payments with contact plans, the sequence of events is as follows.

1. A transaction record is created.

2. Debtor totals are recalculated.

3. The default Payment Posting Contact Plan is run, if there is one set up in Payment Posting Options.

4. The Transaction Type specific Contact Plan is run.

tip.gif This plan is run AFTER any Contact Plan you set up in the Payment Posting Options form. This means that you can use this Transaction Type contact plan to set up a custom schedule for promised payments received or NSF checks.

Top of page.

Delete

This button is visible only on the list of all Transaction Types. Select this to delete the highlighted item from the list.

Top of page.

Edit

This button is visible only on the list of all Transaction Types. Select this to open and modify the highlighted Transaction Type.

Top of page.

New

This button is visible only on the list of all Transaction Types. Select this to open a new blank Transaction Type form.

Top of page.

Help

Select this button for help on the Transaction Type form and links to related topics.

Top of page.

Cancel

Select this button to ignore any changes you may have made and return to the previous form.

Top of page.

OK

Select this button to save any changes you have made and return to the previous form.

<<

Select this button to navigate to the previous record in the database.

>>

Selecting this button to navigate to the next record in the database.

Top of page.

Payment Breakdown And Compound Interest

When you use Compound Interest you MUST post the Original Principal amount as a Transaction Type 196. When posting payments, transaction types MUST have the Payment Breakdown option set so that Collect! can, by default deduct, fees first, then accrued interest, and finally principal. You may adjust this payment breakdown order when creating your Payment Breakdown transaction types. Please be sure you know what you are doing if you deviate from the default order, i.e. Fees, then Interest, then Principal.

Results of the payment disbursement will be reflected in several areas of the Financial Detail form accessed by selecting the Principal or Interest field on the Debtor form.

tip.gif Selecting the Owing field will display the Debtor Financial Summary. Selecting the other financial fields will display the Debtor Transaction Summary.

tip.gif Compound interest calculations produce a running balance of principal, interest, fees and adjustments. When using Compound Interest, you MUST post transactions using Payment Breakdown. Payment breakdown also works with Simple Interest as well as Compound Interest.

Top of page.

See Also

- Transaction Type Basics - Introduction/Accessing
- Transaction Type Samples
- How To Start Using Collect!
- How To Setup Transaction Types
- How To Post A Transaction
- How To Copy Records

Top of page.

Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.

Please click this link to send us your comments: helpinfo@collect.org