To use this facility, the View all bank statements option on the Setup - Preferences - Data Parameters menu option must not be selected.
If the View all bank statements option on the Setup - Preferences - Data Parameters menu option is selected, the Reconcile Bank Account screen will be displayed.
Once your receipt transactions have been entered in the Receipts Journal or batch and the payment transactions have been entered in the Payments Journal or batch, for a specific month or period, you may reconcile your cash book (payments and receipts batches) with the bank statement. Before you may start to reconcile the bank statement is received by post or fetched from your bank or financial institution.
If you are registered for online banking, you may download a bank statement from your bank or financial institution or import a bank statement, which is saved in a valid file format on your system. If you reconcile the bank statement, in the Input - Reconcile Bank menu option, you may then select to display the bank statement transactions to reconcile with the unreconciled items for the receipts and payments batches.
If you have any repeating entries setup for your receipts batch and payments batch in the Edit - Repeating Entries menu option, you need to copy them to the normal batch as they will not reflect in the cash book for a specific period when doing the Bank reconciliation. Examples of such entries in the receipts batch would be amounts (debit orders) paid into your bank account on a monthly basis). Examples for the payments batch would be amounts (debit orders) paid out of your bank account on a monthly basis).
TurboCASH allows you to reconcile your Bank Accounts before you update or post your Payments and Receipts Journals to the ledger. This will allow you to easily correct any errors found (edit transactions, insert transactions which is omitted, delete transactions which is entered twice, reverse all the transactions if entered on the incorrect side, etc., when doing the bank reconciliation. You may also enter any transactions (such as bank charges and interest), which is listed in your bank statement but does not appear in your cash book. You may post or update your batches after your reconciliation is completed, unless you are working on a "Client Machine" in a network environment.
To do a Bank Reconciliation in the Batch Mode:
Deselect the View all bank statements option on the Setup - Preferences - Data Parameters menu option.
Click on the 
speed button or icon or click on the Input – Reconcile Bank menu option. You may
also press the 
and 
keys or the 
and 
and keys on your keyboard. The Reconcile Bank Account screen will be
displayed.
Select and enter the following:
Click on the 
button and the Batch Entry (Payments Jnl)
screen of the selected Bank Account will be displayed.
This screen will list all the transactions Receipts and Payments Journals or
batch for the selected cash book for the selected period. These entries
represent your unreconciled items.
Select the bank statement transaction on the list and click the 
button to open the entry screen for the transactions.
You may enter the transactions as you would in the Payments Journal or the Receipts Journal, if necessary and click on the 
button to close the entry screen.
Once this is done, select the next entry and enter the transactions as necessary.
Once you are finished, click on the 
button to close or exit this screen
If the View all bank statements option on the Setup - Preferences - Data Parameters menu option is selected, the Reconcile Bank Account screen will be displayed.
Once your receipt transactions have been entered in the Receipts Journal or batch and the payment transactions have been entered in the Payments Journal or batch, for a specific month or period, you may reconcile your cash book (payments and receipts batches) with the bank statement. Before you may start to reconcile the bank statement is received by post or fetched from your bank or financial institution.
If you are registered for online banking, you may download a bank statement from your bank or financial institution or import a bank statement, which is saved in a valid file format on your system. If you reconcile the bank statement, in the Input - Reconcile Bank menu option, you may then select to display the bank statement transactions to reconcile with the unreconciled items for the receipts and payments batches.
If you have any repeating entries setup for your receipts batch and payments batch in the Edit - Repeating Entries menu option, you need to copy them to the normal batch as they will not reflect in the cash book for a specific period when doing the Bank reconciliation. Examples of such entries in the receipts batch would be amounts (debit orders) paid into your bank account on a monthly basis). Examples for the payments batch would be amounts (debit orders) paid out of your bank account on a monthly basis).
TurboCASH allows you to reconcile your Bank Accounts before you update or post your Payments and Receipts Journals to the ledger. This will allow you to easily correct any errors found (edit transactions, insert transactions which is omitted, delete transactions which is entered twice, reverse all the transactions if entered on the incorrect side, etc., when doing the bank reconciliation. You may also enter any transactions (such as bank charges and interest), which is listed in your bank statement but does not appear in your cash book. You may post or update your batches after your reconciliation is completed, unless you are working on a "Client Machine" in a network environment.
To do a Bank Reconciliation in the Batch Mode:
Deselect the View all bank statements option on the Setup - Preferences - Data Parameters menu option.
Click on the
speed button or icon or click on the Input – Reconcile Bank menu option. You may
also press the and keys or the and and keys on your keyboard. The Reconcile Bank Account screen will be
displayed. Select and enter the following:| Option | Description |
| Bank Account | Select the cash book you wish to reconcile. |
| Include Items Until | Enter or select the date until which you would like to include cash book transactions to be reconciled with your Bank Statement. |
| Bank Balance | Enter the closing balance of your bank statement. |
Click on the button and the Batch Entry (Payments Jnl)
screen of the selected Bank Account will be displayed.
This screen will list all the transactions Receipts and Payments Journals or
batch for the selected cash book for the selected period. These entries
represent your unreconciled items.
Select the bank statement transaction on the list and click the button to open the entry screen for the transactions.
You may enter the transactions as you would in the Payments Journal or the Receipts Journal, if necessary and click on the button to close the entry screen.
Once this is done, select the next entry and enter the transactions as necessary.Once you are finished, click on the button to close or exit this screen
