RecXpress Resources |
To setup a RecXpress Rules Template enter the Rules Template name.
Select the Bank Format Finder and select the relevant bank format from the bank formats available in the bank format list.
All the transaction codes available for the bank format are added to the default code in the various transaction categories to which the transaction codes belong.
Create one template and then export and import into other templates and edit accordingly.
Create one template per bank. This ensures you have the correct matching taking place for that bank.
The rules you setup for your transaction codes can be grouped together by category.
Select the new category icon to create a new category or select an existing category, via the Category Finder, to edit.
Field |
Value |
Category Auto Numbering |
When creating a new category enter the category code, category description and select whether the transaction codes assigned to the category will utilize the auto numbering facility. If you select auto numbering for the category enter a prefix and the next number to be used. The Reset Reference Numbers function, which can be accessed via the File menu, allows for the resetting of the auto numbering sequences that are saved in the RecXpress Template file for the particular bank code. |
Transaction Code |
Select the transaction code for the category line entry via the Transaction Code Finder which will allow you to select any of the transaction codes setup for the bank format. |
Entry Description |
Enter the description of the entry on the bank statement import file. |
Compare Method |
The compare method is used to identify the entry on the bank statement file by the description field. None - If the description of the entry on the bank statement import file is not used to identify the entry in order to assign the necessary defaults. = (Equal) - If the description of the entry on the bank statement import file must be equal to the description in the Compare Description field before the defaults are assigned to the entry. LIKE - If the description of the entry on the bank statement import file must be similar to the description in the Compare Description field before the defaults are assigned to the entry. Equal (?) - If the description of the entry on the bank statement import file must be equal to the description in the Compare Description field but certain characters is not constant and might vary then you can use wild-card characters in the equal compare method. LIKE (?) - If the description of the entry on the bank statement import file must contain within the description a specific character set that is the same as the description in the Compare Description field but certain characters is not constant and might vary then you can use wild-card characters in the Like compare method. |
Compare Description |
The value that the description of the entry on the bank statement import file must be compared against to identify the entry. |
Source Code |
The default source code to assign to the entry. |
Account Code |
The default account code to assign to the entry |
Distribution Code |
The default distribution code to assign to the entry. If the entry amount is equal to the total amount of the detail lines that make up the distribution code, the entry amount will be disbursed to the various lines that make up the distribution code, using the amount setup for each detail line within the distribution code. |
Statement Amount |
The amount of the entry on the bank statement. |
Comments |
The default comments to assign to the entry. |
Tax Group |
The default tax group to assign to the entry, in a bank where tax tracking is on. |
Tax Type |
The default tax type to assign to the entry, in a bank code where tax tracking is on. |
Tax Class |
The default tax class to assign to the entry, in a bank where tax tracking is on. |
Tax Inclusive |
To indicate whether the entry amount is inclusive of tax or not, in a bank where tax tracking is on. |
Auto Number |
To indicate whether the entry should be auto numbered, according to the auto numbering sequence setup for the category, or not. |
Prefix |
If yes is selected in the Auto Number field but you do not want to use the auto numbering prefix and number sequence selected for the category. Enter a Prefix to assign to the individual entry. |
Next Sequence |
If yes is selected in the Auto Number field but you do not want to use the auto numbering sequence selected for the category. Enter the next number in the sequence to assign to the individual entry. |
Entry Type |
Select the entry type, Cashbook, Accounts Payable or Accounts Receivable, to assign to the entry. |
Misc/Vend/Cust |
For a Cashbook entry select the miscellaneous code to assign to the entry. For an Accounts Payable entry select the vendor code to assign to the entry. For an Accounts Receivable entry select the customer code to assign to the entry. |
Auto Allocate |
For Accounts Payable and Accounts Receivable entries, select how to allocate the entry amount to the vendor or customer. Auto Allocate (Doc. No.) - Start allocating against the outstanding invoices from the first invoice number until the unapplied amount has been completely depleted or there are no more outstanding invoices. Auto Allocate (Doc. Date.) - Start allocating against the outstanding invoices from the earliest invoice date until the unapplied amount has been completely depleted or there are no more outstanding invoices. Auto Allocate (Due. Date.) - Star t allocating against the outstanding invoices from the earliest invoice due date until the unapplied amount has been completely depleted or there are no more outstanding invoices. Prepay - Do not auto allocate the amount, create a prepayment. Unapplied Cash - For Accounts Receivable entries do not allocate the amount, create an Unapplied Cash entry. Equal Amount - Allocate the amount to the first document with an amount equal to the bank statement entry amount. Document Number - Allocate the amount to a document with a document number equal to the number contained in the bank statement entry description. |
Button |
Select |
Save |
Save a new or changes to an existing Template Code |
Delete |
Delete a Category or Template Code. |