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


MonthCashbook BalanceGeneral LedgerVariance
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

or calling us on 09 583 2455