Template Overview
A cash book is a simple, day-by-day record of the cash coming into and going out of your business. It's one of the most important records a small business or shop can keep, because it tells you exactly how much cash you have at any moment. This template makes it effortless: enter the date, a short description, the voucher number, and the amount received or paid — and the Balance column updates automatically using a running total. Set your opening balance at the top, and the template tracks every transaction, totals your receipts and payments, and calculates your closing balance for you. No accounting software needed.
Features
- Automatic running balance after every entry
- Opening and closing balance calculated for you
- Totals receipts and payments automatically
- Simple columns: date, particulars, voucher, in, out
- Works in Excel, Google Sheets and LibreOffice
Instructions
- Download the file and open it in Excel, Google Sheets, or LibreOffice.
- Enter your opening balance in the cell at the top.
- For each transaction, add the date, a short description, and the voucher number.
- Put money received in the 'Receipt (In)' column and money paid in 'Payment (Out)'.
- The Balance column updates automatically after every entry.
- Check the totals and closing balance at the bottom at the end of the period.
FAQ
Is this cash book template free?
Yes. It is free to download and edit for personal and business use.
Does the balance update automatically?
Yes. The Balance column uses a running-total formula, so it recalculates after every receipt or payment you enter.
What is the difference between this and an expense tracker?
A cash book is a chronological record of cash in and out with a running balance. An expense tracker groups spending by category. Many businesses use both.
Does it work in Google Sheets?
Yes. Upload it to Google Sheets and the formulas carry over.