Generate RecXpress Batches

Generate Cashbook Batches from No Match Entries – By using the RecXpress batch generation feature you can generate Cashbook batches from the imported entries in the No Match display.

Note: You must be in the No Match display mode to generate a batch.

If the entry default information is not automatically assigned to the entry by the Rules Template you have to enter the fields required for batch generation.

Field

Value

Select For Batch

If you want to include the entry in the batch generation process ensure you have toggled Yes in the Select For Batch column.

CB Ref.

If you want a specific Cashbook reference number to be used for the entry, enter the number in the CB Ref. column.

Entry Date

If you want to generate the entry in the Cashbook batch with a different entry date than the bank statement entry date you can over-ride the date in this field (which defaults to the bank statement entry date) with the date you wish to use as the entry date in the Cashbook batch that is generated.

Category

If you change the default category for the entry you will be prompted if you wish to change the Category to which the entry belongs in the Rules Template. You can select the Zoom Arrow in the Category field which will take you to the exact line in the Default Code Category Setup so you can edit the line in the Category without having to leave the RecXpress worksheet.

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.

Generated No.

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 number to assign to the entry.

Entry Description

Enter the description you wish to assign to the entry when the batch is generated.

Source Code

The source code to assign to the entry.

Account Code

The account code to assign to the entry.

Distribution Code

The 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.

Entry Type

Select the entry type, Cashbook, Accounts Payable or Accounts Receivable, to assign to the entry.

Tax Group

The tax group to assign to the entry, in a bank code where tax tracking is on.

Tax Type

The tax type to assign to the entry, in a bank code where tax tracking is on.

Tax Class

The tax class to assign to the entry, in a bank code where tax tracking is on.

Tax Inclusive

To indicate whether the entry amount is inclusive of tax or not, in a bank code where tax tracking is on.

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.

Prepay - Do not auto allocate the amount, create a prepayment.

Auto Allocate (Doc. No.) - Start allocating against the invoices in document number sequence 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 invoices in document date sequence from the oldest invoice date until the unapplied amount has been completely depleted or there are no more outstanding invoices.

Auto Allocate (Due Date.) - Start allocating against the invoices in document due date sequence from the oldest invoice due date until the unapplied amount has been completely depleted or there are no more outstanding invoices.

Equal Amount - Allocate the amount to the first document with an amount equal to the 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.

Comments

The default comments to assign to the entry.

Optional Fields

Select the Batch Header and Batch Detail Optional Fields to assign to the entry.