Cash Book Template (Free Template)
Use this cash book template to record every shilling in and out of your business with a running balance. A clean cash book is the foundation of knowing whether you are actually making money.
| Date | Description | Money in (KES) | Money out (KES) | Balance (KES) | Category |
|---|---|---|---|---|---|
| 13/06/2026 | Sales | 50,000 | . | 50,000 | Sales |
| 13/06/2026 | Supplier payment | . | 20,000 | 30,000 | Stock |
| 13/06/2026 | Rent | . | 15,000 | 15,000 | Rent |
| ... | ... | ... | ... | ... | ... |
Example rows shown. Download the CSV for a blank version to fill in, or open it in Excel or Google Sheets.
How to use the cash book template
- 1Record every transactionEnter every payment in and out as it happens. Nothing is too small to record.
- 2Keep a running balanceAfter each line, update the balance. This is your cash position at any moment.
- 3CategoriseTag each entry (sales, stock, rent, wages) so you can see where your money goes.
- 4Reconcile to cash and M-PesaYour cash book balance should match your actual cash and M-Pesa. A gap means something was missed.
- +Record transactions daily, while you remember them.
- +Keep business and personal money separate.
- +Categories turn a list of transactions into useful insight.
Frequently asked questions
A cash book records every payment in and out of your business with a running balance. It is the foundation of your bookkeeping and tells you your real cash position at any time.
Everything: sales, supplier payments, rent, wages, withdrawals and any other money in or out. Categorising each entry lets you see where your money actually goes.
A cash book tracks cash moving in and out. A profit and loss statement shows whether you made a profit over a period. You build the profit and loss from the categorised cash book.
No. Keep them separate. Mixing personal and business money makes it impossible to tell whether the business is profitable and complicates your records for KRA and lenders.
Veira records your sales and payments automatically and categorises them, so a clean cash book and the reports built on it come from your real trade rather than manual entry.
Veira records sales, stock and payments automatically, so this runs itself. From KES 2,999 a month, with a free terminal.