Cashbook transaction data, reflecting the 'liability', is imported from a company's internal administration systems

The imported transactions are associated to specific accounts and reflect the movement of bank transactions and balances

Transaction data imports are performed by using a predefined transaction import definition (based on a SQL query)

• These definitions are configured on the Setup>Cashbook Import Definitions screen

Navigate to Transactions>Import Cashbook Transactions to select the import definitions to run

• You will be navigated to the Dashboard to monitor the progress of the imports

The bank will proved bank transaction confirmation feedback, reflecting the 'asset'

This data confirms that bank transactions have taken place in a certain account

Bank statements are received on a daily basis and imported in order to reconcile all transactions

Bank Reconciliation has been designed to read and process Bank Statements from all the major South African Banks as well as a number of international banks. See the list here

• Navigate to Transactions>Import Bank Transactions to import a statement

• Single File Upload allows you to import a single file at a time located in a folder the user has access to

• Multiple File Upload imports all allowed file types from a predefined folder. This folder is set up on the Domain Group

  • The files are sorted and imported sequentially

  • Processed Files are removed from the folder to ensure they cannot be imported again

• You will be navigated to the Dashboard to monitor the progress of the imports

Every statement imported undergoes the following validations

• Statement number is sequential/bigger than the previous statement number

• Opening Balance = previous closing balance

• Opening Balance + sum(transactions on statement) = closing balance

In some cases the transaction reflected on the Bank side is aggregated from detail transaction data

This additional detailed data can be imported into Bank Recon and allows the user to use underlying bank transaction detail when performing reconciliations

• For more information on this process see here

Transaction detail data imports are performed by using a predefined bank transaction import definition (based on a SQL query)

• These definitions are configured on the Setup>Bank Details Import Definition screen

Navigate to Transactions>Import Bank Details Transactions to select the import definitions to run

• You will be navigated to the Dashboard to monitor the progress of the imports