Hi Neville
Thanks for your feedback but the problem is that the detailed general ledger amt does not balance with the bank statement only the cashbook detailed report balance. So if you look on the trial balance as well it shows the incorrect balance. Would I go through the same process as you described hereunder? I don't understand how come it has done this. I do recall from my previous company that we had a suspense account that we used to enter the trsf between accounts amts and then take them out.
Cindy
- Cashbook Detailed Report (View...General Ledger...Transactions...Cashbook Detailed Report).
- Detailed Ledger Report for the cashbook account (View...General Ledger...Transactions...Detailed Ledger).
You will, most likely, find that the closing balances differ between the two reports and that the closing balance of the Detailed Ledger report agrees with your bank statement.
The bank reconciliation refers to the Detailed Ledger Report (not the Cashbook Detailed Report) when it makes the comparison to the bank balance.
Possible reasons for the two closing balances not agreeing include:
- A non-cashbook journal (i.e. general journal) has been posted directly to the detailed ledger for the cashbook.
- A payment from another cashbook to the cashbook in question has been allocated directly to the general ledger of the cashbook in question. Any inter-cashbook payments must be processed via a clearing account. In other words, the payment must be processed as a cashbook payment journal in the "paying" cashbook and allocated to a designated clearing account (not directly to the "receiving" cashbook account), and a corresponding cashbook receipt journal must be processed in the "receiving" cashbook and allocated to the same clearing account. This will ensure that both the payment and the receipt appear in both the Cashbook Detailed reports.
Please let me know if I have missed the boat completely in my diagnosis and we can look at other possible causes.
Did you like this article? Share it with your favourite social network.