taken from the
To use this facility, the View all bank statements option on the Setup - Preferences - Data Parameters menu option must be selected.
If the View all bank statements option on the Setup - Preferences - Data Parameters menu option is not selected, the Batch Entry Mode for the Bank Reconciliation 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.
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. It is important to select the correct dates to include transactions (the dates must correspond with those dates for which you need to do the bank reconciliation) when you save the bank statement transactions as a file. 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 wish to reconcile your cash book with a printed bank statement which, is received by post or fetched from your bank or financial institution, click here.
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 Using a Bank Statement File:
Import the Bank Statement
or Download the Bank Statement from your bank or
financial institution in the Tools - Bank Online
menu option for the bank account you need to reconcile. The following is an
imported or downloaded Bank Statement:
Close or exit the Online Banking screen.
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 Reconcile Bank
Account screen displaying the name of your current account will be displayed
listing all the transactions Receipts and Payments Journals or batch for the
selected Cash Book for the selected period i.e. These entries represent your
unreconciled items.
If you have more than one transaction with the same reference number (deposit or cheque number), you may click on the Consolidate speed button or icon.
Click on the 
speed button or icon to display the bank statement transactions. The screen will
split in 2 sections. The top section will display the details of the Receipts
and Payments batches while the bottom half of this screen will display the
details of the transactions displaying on the bank statement.
You need to select the items and transactions
appearing the top half of this screen with the bank statement transactions in
the bottom half of this screen. To do this you need to select the item and click
on the reconciled field. You may also use the Up or down arrows and the space bar
on your keyboard to mark an item or transaction as reconciled or not.
Click on the 
speed button or icon. The reconciled transactions on this screen will be removed
and only the transactions or unreconciled items will be displayed.
If any unreconciled items or transactions on this Reconcile Bank Account screen transactions or items are as follows:
Bank Statement Transactions (Bottom half of
this screen): - These unmarked transactions are not yet entered in your cash
book (receipts or payments journal or batch). You need to exit this screen and
enter the unmarked items or bank statement transactions in the cash book as
follows:
No difference should be displayed on the bottom
right-hand corner of the Reconcile Bank Account screen. If any differences are
displayed, you need to find these differences and correct
them.
Reconcile Bank Account screen (Top Half of
this screen): - These unmarked items or transactions, which is not selected,
represent outstanding deposits (receipts) and outstanding cheques (payments).
These transactions will be reported in the bank reconciliation statement and
should be displayed on the next bank statement.
Click on the 
close button
to close or exit the Bank Reconciliation screen.
Click on the Reports - Bank Reconciliation menu
option to generate a bank reconciliation report. This
report will reflect the deposits and payments (cheques) and will reflect if
there are any differences. If this report does not reflect any differences
between the Cash Book and the Bank balance is in balance as at a specified date.
This report will also enable you to determine whether bank charges and other
debits or credits appearing on you bank statement are recorded in your cash book
for the selected period.
- Sort the reference descending from the last number or
last alphabetic character to the first.
- Sort the reference ascending from the first number or
last alphabetic character to the last.
- Sort the dates descending from the first date to the
last date in the selected period.
- Sort the dates ascending from the last
date to the first date in the selected period.
- Sort the description descending from the first to the
last.
- Sort the description ascending from the last to the
first.
- Sort the description descending from the smallest amount to
the highest amount.
- Sort the description ascending from the highest amount
to the smallest amount.
- Lists the unreconciled items first and then the
reconciled items.
- Lists the reconciled items first and then the
unreconciled items.
If you click and on any of these column headings, you may drag it to the left or the right of the adjacent columns.
If the View all bank statements option on the Setup - Preferences - Data Parameters menu option is not selected, the Batch Entry Mode for the Bank Reconciliation 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.
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. It is important to select the correct dates to include transactions (the dates must correspond with those dates for which you need to do the bank reconciliation) when you save the bank statement transactions as a file. 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 wish to reconcile your cash book with a printed bank statement which, is received by post or fetched from your bank or financial institution, click here.
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 Using a Bank Statement File:
Import the Bank Statement
or Download the Bank Statement from your bank or
financial institution in the Tools - Bank Online
menu option for the bank account you need to reconcile. The following is an
imported or downloaded Bank Statement:
Close or exit the Online Banking screen.
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 Reconcile Bank
Account screen displaying the name of your current account will be displayed
listing all the transactions Receipts and Payments Journals or batch for the
selected Cash Book for the selected period i.e. These entries represent your
unreconciled items.
If you have more than one transaction with the same reference number (deposit or cheque number), you may click on the Consolidate speed button or icon.
Click on the
speed button or icon to display the bank statement transactions. The screen will
split in 2 sections. The top section will display the details of the Receipts
and Payments batches while the bottom half of this screen will display the
details of the transactions displaying on the bank statement.
You need to select the items and transactions
appearing the top half of this screen with the bank statement transactions in
the bottom half of this screen. To do this you need to select the item and click
on the reconciled field. You may also use the Up or down arrows and the space bar
on your keyboard to mark an item or transaction as reconciled or not.
Click on the
speed button or icon. The reconciled transactions on this screen will be removed
and only the transactions or unreconciled items will be displayed.
If any unreconciled items or transactions on this Reconcile Bank Account screen transactions or items are as follows:
Bank Statement Transactions (Bottom half of
this screen): - These unmarked transactions are not yet entered in your cash
book (receipts or payments journal or batch). You need to exit this screen and
enter the unmarked items or bank statement transactions in the cash book as
follows:
-
Debits - amounts displayed in red font colour enter these
transactions in the payments journal or batch .
-
Credits - amounts displayed in black font colour - enter the
transactions in the receipts journal or batch.
- Once all these transactions are entered or if any errors are found at this stage and it is corrected, you need to access the Reconcile Bank Account screen again and select or mark any corresponding transactions. Once this is done, no differences should be displayed on the bottom right-hand corner of this screen.
No difference should be displayed on the bottom
right-hand corner of the Reconcile Bank Account screen. If any differences are
displayed, you need to find these differences and correct
them. Reconcile Bank Account screen (Top Half of
this screen): - These unmarked items or transactions, which is not selected,
represent outstanding deposits (receipts) and outstanding cheques (payments).
These transactions will be reported in the bank reconciliation statement and
should be displayed on the next bank statement. Click on the close button
to close or exit the Bank Reconciliation screen. Click on the Reports - Bank Reconciliation menu
option to generate a bank reconciliation report. This
report will reflect the deposits and payments (cheques) and will reflect if
there are any differences. If this report does not reflect any differences
between the Cash Book and the Bank balance is in balance as at a specified date.
This report will also enable you to determine whether bank charges and other
debits or credits appearing on you bank statement are recorded in your cash book
for the selected period.
| Icon | Description |
 |
If you click on this icon or speed button, it will
consolidate all entries in the selected Cash Book with the same reference
number. If an entry is selected for which other entries exists with the
same reference number, all these entries will be displayed in a different
colour (blue). The total amount of all these entries with the same
reference number, will be displayed as a Posted Payments item or Unposted
Payments item or Posted Receipts item or an Unposted Receipts item. If you click on this icon or speed button again to set it off, all entries will be listed as individual entries with the same reference number will not be consolidated. |
 |
This option will automatically reconcile all payments and
receipts for a specified period. 
If you select the Reconcile by Reference field, you will not be able to select the date from and to. |
 |
This option will automatically unreconcile all reconciled
payments and receipts for a specified period. 
If you select the UnReconcile by Reference field, you will not be able to select the date from and to. |
 |
This option allows you to search for transactions by
reference, amount and date. If you click on this icon or speed button, a
screen where you may enter any of the following to search for an item,
will be displayed on the bottom of the reconciliation screen:
|
 |
If you click on this icon or speed button, the Bank Account Recon Options screen will be displayed on which you may generate a bank reconciliation report. The Bank Account Recon Options screen may also be accessed on the Reports - Reconciliation menu option. |
- Sort the reference descending from the last number or
last alphabetic character to the first. - Sort the reference ascending from the first number or
last alphabetic character to the last. - Sort the dates descending from the first date to the
last date in the selected period. - Sort the dates ascending from the last
date to the first date in the selected period. - Sort the description descending from the first to the
last. - Sort the description ascending from the last to the
first.- Sort the description descending from the smallest amount to
the highest amount. - Sort the description ascending from the highest amount
to the smallest amount. - Lists the unreconciled items first and then the
reconciled items.
- Lists the reconciled items first and then the
unreconciled items.If you click and on any of these column headings, you may drag it to the left or the right of the adjacent columns.
