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.

Last Post Date

Tells you when last you posted transactions to the Cashbook.

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 RecXpress before importing a 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 RecXpress.

Ignore Zero Amounts

Exclude entries with a value of zero.

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.

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)

Button

Select

Process Statement

After the statement is retrieved and stored in the designated folder, fetching refers to the action of importing or loading the statement within RecXpress.

Clear

If Clear Only Posted Entries is selected Clear will only delete posted entries from the current reconciliation (in CBRXTMP) and delete only posted from the RecXpress temp file (CBRXTMP). If Clear Only Posted Entries is not selected Clear will delete all entries from the current reconciliation (in CBRIMP) and flag them as "Not in Recon" in the temp file which is visible in the Process Statement popup. These become available to restart the reconciliation.

Note: If there are unposted entries sitting in a RecXpress batch, it will not allow you to clear it. Ensure that you delete the batch before you do the clear.

RecXpress

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

Note: If the RecXpress button is enabled there are existing records in the reconciliation.