Quick Links

RecXpress SFTP Setup

RecXpress Bank Reconciliation

RecXpress Cashbook Transaction Enquiry

Field

Value

All On

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

All Off

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

Show Selected Only

Show only the Banks that you have selected 'Yes' for.

Bank Code

This is the Bank Code you are going to Retrieve/Process.

Select

Select 'Yes' to include the bank in the Multiple Import.

Retrieve Only

When Retrieve Only is set to 'Yes' it will only retrieve all the statements into the temporary file and not fetch them into RecXpress. When it is set to 'No' the statement will be retrieved and fetched into RecXpress.

Last Statement Date

This is the date of the last statement that was imported.

Process From Date

The date from which transactions are included in the reconciliation process. Transactions dated before this specified date will be excluded from the current reconciliation process.

Process Until Date

The date until which the system will process statements during the reconciliation. Transactions beyond this specified date won't be considered during the reconciliation process.

Cashbook Balance

The balance of your Cashbook

Statement Balance

This is the balance that appears on your statement.

Template Code

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

Import File Name

If you do not have SFTP setup and activated, 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.

If you are using an SFTP connection this file path is setup in C/B Bank Accounts | RecXpress.

Ready To Post

If you want to post the batch this switch must be set to Yes.

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

Select this option if you only wish to clear entries that have been posted to the Cashbook reconciliation from RecXpress.

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.

Later than Statement Trans. Date

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

If you select this option, only Cashbook entries with an entry date later than 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.

Ignore Zero Amounts

Exclude entries with a value of zero.

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

Retrieve/Process

The "Retrieve/Process" button serves a dual purpose. It allows you to both import financial data, such as bank statements, into your system and retrieve any new statements or data from your financial institutions. This button is used when you want to bring in new financial data and reconcile it within your system.

Renumber

Select the Renumber button to number the imported entries that are selected for batch generation according to the number sequences set up for each category.

Batch

After selecting the entries for the batches in multiple banks and ensuring all necessary information for batch generation is supplied, click the "Batch" button to create the Cashbook batch.

Batch List

Select the Batch List button to display the Cashbook Batch List. You can post your multiple batches directly from this screen.

Post RecX

When you're satisfied with the multiple bank reconciliations and new bank statement balances, use "Post RecX" to update your Cashbook Bank Reconciliation and RecXpress History.