Import Cashbook Transactions
- 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)
- 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

Import Bank Transactions
- 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

Import Transaction Details
- 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)
- 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

|
|