Field

Value

Bank Code

Select the bank for which you are importing the reconciliation.

Rules Template

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

Current Statement Date

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

Format Name

The bank format (setup in the default rules template) of the bank statement you are importing for the reconciliation.

Remarks

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

Unposted Transactions

The number of unposted transactions you have in your RecXpress Reconciliation Window.

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.

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 Unreconciled Only

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

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.

Use AR/AP Ref/Cheque

Use extended AR/AP reference/cheque numbers instead of the CB reference to match entries by reference.

Match By

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

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.

Last Posting Date

The Posting Date is the date recorded when you last posted RecXpress.

CB Bank Balance

The Cashbook bank balance of the date range selected in the Cashbook bank reconciliation.

Imported

The nett total amount of the bank statement entries imported.

Matched

The nett total amount of the bank statement entries matched successfully to Cashbook entries.

Unmatched

The nett total amount of the bank statement entries not matched successfully to Cashbook entries.

Matched with Error

The nett total variance amount of the bank statement entries matched successfully to Cashbook entries by reference number but the amount differs.

Previously Reconciled

Total previously reconciled amount. Transaction has been manually reconciled in Cashbook before importing the bank statement in RecXpress.

Bank Balance

New Bank Balance (excluding previously reconciled transactions & including ALL imported)

Import File Path

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

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

Button

Select

Import

Select the Import button to import the bank statement file.

Clear

Select the Clear button if you wish to clear the imported reconciliation.

RecXpress

Once the bank statement is successfully imported the RecXpress button is enabled. Select the RecXpress button to proceed to the RecXpress reconciliation.

RecXpress Resources

Solution Center