Button

Select

All On

Select All On to include all the bank statements in the grid in the import.

All Off

Select All Off to exclude all the bank statements in the grid from the import.

Field

Value

Import

Toggle Yes to include the bank statement in the import and No to exclude the bank statement from the import.

Bank Code

Select the bank for which you are importing the reconciliation.

Statement Date

The Current Statement Date is updated with the latest bank statement transaction date when importing the bank statement.

Last Statement Date

The Last Statement Date is updated with the Current Statement Date when importing a bank statement with a statement transaction date that is later than the Current Statement Date.

Template Code

Select the rules template that applies to the bank statement you are importing.

Import File Name

In the Import File Name field, you must specify the location of the bank statement file which applies to the format you are importing.

Select the Finder and point to the correct location where the bank statement import file resides.

Clear Existing Recon Data

If a previous reconciliation exists you can select to clear the reconciliation from the work file before importing the new statement.

Clear Only Posted Entries

If you have selected the Clear Existing Recon Data option select this option if you only wish to clear entries that have been posted to the Cashbook reconciliation from the work file.

Match Amounts

If you want the matching process to also match by amount for the entries that were not matched by reference number when importing the reconciliation, toggle this option on. Although the import will take a bit longer, the actual result of such a match will be much more accurate.

Match By

Option to match entries by Reference, Reference|Description, Description, Description|Reference during bank statement import.

Match with Error

If you want the matching process to reconcile entries with the same Reference but different amount and assign the Import Status Matched With Error to the entries select this option.

If you want the entries with the same Reference but different Amount not to be reconciled and to be assigned the No Match Import Status do not select this option.

Later than Statement Trans. Date

Later than Statement trans. Date option works in conjunction with the Match Amounts option.

If you do not select the Later than Statement trans. Date option when selecting Match Amounts only Cashbook entries that have an entry date earlier and equal to the date of the entries on the bank statement will be considered in the matching process when matching by amount.

Match Un-reconciled Only

If you want the matching process to only consider un-reconciled transactions in the Cashbook, select this option.

Use AR/AP Ref/Cheque

This will match the bank statement reference to the extended Vendor Cheque and Customer Reference fields.

Remarks

You can enter remarks regarding the reconciliation which you are importing and save these remarks to the template.

Bank Filter

If your bank statement import format supports a bank code filter enter the bank code you want to import.

Button

Select

Import

Select the Import button to import the bank statement files.

RecXpress

Once the bank statements are successfully imported the RecXpress button is enabled.