Daily Management

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). These definitions are shown when selecting Transactions>Import Cashbook Transactions. 


Choose a definition(s) and select import.

Once selected the user is navigated to the Dashboard, which returns status information of the process and will indicate if the action was successful or not.

The user can now view the details of the successful of unsuccesful import by selecting the Details link. This can be used for any action on the Dashboard.


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 these bank statements.


Selecting Transactions>Import Bank Transactions will show the import screen.

The user now browses and selects a specific file to import, or can import multiple files from a specific directory that is specified under Admin>Domain Groups. The specific domain group is then selected and the upload directory edited.

Once selected the user is navigated to the Dashboard, which return status information of the process and will indicate if the action was successful or not, and the details can also be viewed like above.

Import Transaction Details

In some cases the transaction reflected in BankRecon is aggregated from detail transaction data.  This additional data containing detail bank transaction information can be imported into BankRecon and allows the user to view underlying bank transaction detail when performing reconciliation.

Transaction detail data imports are performed by using a predefined bank transaction import definition (based on a SQL query), or from transaction detail file. The definitions are shown when selecting Transactions>Import Bank Transactions Details and are set up through Setup>Bank Details Import Definitions. 

Once again the actions will appear on the Dashboard.

Comments