Download our FREE cashbook and sales and purchase ledgers spreadsheet template and use it to ‘track’ where your business’ money is coming in and going out.
If you don’t have financial control of your business it will fail.
The first step to gaining financial control means that you must ‘track’ what is going on when it comes to your business’ money.
Very simple businesses can get away with a ‘single entry’ system but for the vast majority monitoring where your business’ money is coming and going will require a ‘double entry’ bookkeeping system which tracks debits and credits.
Whether your business’ turnover is £100 or £100 million – or whether you do your bookkeeping yourself, or outsource this task to your bookkeeper or accountant – the underlying principles are exactly the same.
And by the way what is going on in this spreadsheet is exactly what is happening in the background of any accounting software like Xero, SAGE or Quickbooks!
HOW Do I Use This Template To Create a Simple Cashbook in Excel?
If your business is very straight forward and you want to use or just understand a ‘single entry’ bookkeeping system use the ‘Cashbook’ worksheet.
To use or again simply understand a ‘double entry’ system use the ‘Ledger cashbook’ and ‘Ledgers’ worksheets.
So download the FREE cashbook and sales and purchase ledgers spreadsheet template and complete the columns in the appropriate worksheet(s).
DOWNLOAD NOW