Imports

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


Comments