These steps can be used to reconcile the cashbook to the general ledger each month.
At all dates the running balance in cashbook MUST match the bank account balance in the general ledger.It is suggested to first reconcile your Cashbook to the GL then reconcile the Cashbook to your bank statement
TABLE OF CONTENTS
Each Cashbook should have it's own GL code and will need to be reconciled separately
Identify any month(s) out of balance
Compare the Cashbook to the Trial Balance Summary
Cashbook
Open the Cashbook (1) and find the last transaction of each month (2), enter these figures into a spreadsheet (see below template).
Trial Balance - Summary
Go to Reports (1) > General Ledger (2) > Trial Balance - Summary (3)
1. Select the correct GL code - Typically it will have a search key of "BANK"
NB: each General Ledger/chart of accounts is different and the number may change
Contact your accountant if you are unsure which GL code this is
2. Select the correct month
3. The report can be exported to Excel as well.
4. Enter the Closing Balance
Spreadsheet example
This is an example - setup in Excel to make your life easier
| Month | Cashbook Balance | General Ledger | Variance |
|---|---|---|---|
| March | |||
| April | |||
| May | |||
| June | |||
| July | |||
| August | |||
| September | |||
| October | |||
| November | |||
| December | |||
| January | |||
| February | |||
| March |
Identify the transaction(s)
Compare the Cashbook report to the Detailed Trial Balance
Cashbook Report
Go to Reports (1) > Cashbook (2) > Cashbook Report (3)
Enter the Bank account being balanced (1) and the date range (2)
Trial Balance - Detailed
Go to Reports (1) > General Ledger (2) > Trial Balance - Detailed (3)
1. Enter the correct GL code
Check and make sure that you are using the correct GL code for the Bank/Cashbook you are reconciling.
2. Enter the correct period
Example:
Didn’t find what you were looking for?
Our Support team are here to help, you can reach us by submitting a support ticket