RecXpress RulesTraining Video

Setup RecXpress Rules Template

RecXpress Resources

Adding Rules Automatically PDF

Solution Center

Training Video

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.

Setup RecXpress Category Rules

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.