Bank Reconciliation Reports
This option is used to generate a report to verify that your cashbook balance and the balance of your bank statement as at a specific or selected period is in balance. This is to verify that all transactions are captured in the cashbook and that all bank charges and other debits and credits on your bank statement are accounted for in your cashbook.
This report will display the reconciled Bank Balance which is the closing bank balance, as at a specific date, less outstanding deposits, plus any outstanding cheques not appearing on your bank statement, as at the end of that date.
- The reconciled balance, as at the specified date, should balance with the Bank Balance According to TurboCASH.
- Any difference between the reconciled balance and the balance according to TurboCASH
reflect that entries on your bank statement are not entered into your
cashbook and could also relate in possible errors in your cashbook.
Print Bank Reconciliation Reports
To Generate a Bank Reconciliation Report:
-
Click on the Reports→Reconciliation menu option.
- Keyboard Access: Press the Alt+R+R keys on your keyboard.
- If you are on the Bank Reconciliation screen, you may click on the Report icon.
The Bank Account Recon Options screen is displayed:
-
Send Report To - Select the method (screen, printer, file, e-mail or fax).
-
Select and enter the following:
-
Bank Account - Select the cashbook you wish to reconcile.
-
Include Items Until - Enter or select the date until which you would like to include cashbook transactions to be reconciled with your Bank Statement.
-
Bank Balance - Enter the closing balance of your bank statement.
-
Last total - The last total of the bank account will be displayed.
-
-
Click on the Open button. The Cashbook Reconciliation report will be sent to the medium selected in the Send Report To field.
View Bank Reconciliation Reports
An example of a Cashbook Reconciliation Report will display as follows:
TurboCASH will subtract any unreconciled payments, and add any unreconciled receipts from the bank balance according to the bank statement, thus giving you a reconciled balance.
It will list the Outstanding transactions in the Payments Journal (Cheques), and the Outstanding transactions in the Receipts Journal (Deposits), which are not marked as reconciled items, and which do not appear on your bank statement.
- This report should at all times reflect a 0.00 difference.
If there is a difference between the reconciled balance and the balance according to TurboCASH,
you have an error in either the Payments or Receipts Journals. You
would have to search for the error and correct it. You do need to find
these errors or differences.
— digidan 2006/11/02 17:12




Related Items
Comments & Questions



