Overview
This application allows you to:
•Reconcile bank statements and cashbook transactions
•Upload Bank Statements directly from bank in multiple currencies.
•Reconciliation process can be automatically done by the system
•Journal entries can be automatically created for bank and interest charges and other transactions on the bank statement.
•When capturing a journal from a statement line for journal lines where VAT is applicable, users will be able to specify the VAT type (input/output VAT). The system will default the VAT type based on the sign of the statement transaction (debit/credit) although users can override it.
•If you are using the translation functionality, descriptions and comments will be translated to your selected language.
Rules Applied
•Bank reconciliations are based on a specific period in DeltaERP.
•Multiple reconciliation batches may be captured for the same reconciling period for each bank account.
•Import bank statement function is only available for specific banks.
•When deleting a bank statement, all items are unallocated, and the entire statement is deleted.
Typical Users
Risk Factors
Function
When opened you will view the following:
Select the bank account you need to do the reconciliation for using the drop-down functionality.
The 
button will allow you to reselect a bank.
The 
button allows you to start a new recon for the selected bank.
Complete the fields and click on the 
button to continue.
The 
button allows you to import a bank statement as downloaded from your bank account.
Select the file you wish to import from the save location or drag and drop the file onto the screen.
You can also select the bank statement format and use the 
button to export a template which can be completed and imported.
The default tab displayed (Tabs, Tiled of Single) is parameter driven and can be changed.
All the cash book items and bank statement items will be displayed in the display screen. The source of each item can be seen under the 'Source' column.
To reconcile a cashbook item with a bank statement item, you need to select all cashbook lines to be reconciled and then select the bank statement line they must be reconciled with.
At the top of the screen are three fields:
•Cashbook - shows the total of all the cashbook lines selected
•Statement - shows the total of all the bank statement lines selected
•Total - shows the difference between the bank and cashbook lines selected, must be a 0(zero) balance to reconcile
The total amount has to be a 0 (zero) balance to be able to allocate the items against each other.
If the difference is zero select the 
button, or right click in the grid and select the Allocate option, to reconcile the items.
The items will be removed from the screen. When the screen is blank, all items have been reconciled.
The 
button will automatically search for matching reference numbers and amounts between the cashbook and bank lines and reconcile these items. Lines which may, for example, only have matching amounts but not reference numbers will not be reconciled, this will have to be captured manually, as explained above.