Cash book format: free Excel template and worked examples
A cash book is the daily record of every rupee that comes into your shop and every rupee that goes out. Below are the three formats people use most (single column, three column and petty cash), each filled in for one month of a small kiryana shop, plus a free Excel template and a blank sheet you can print.
The Excel file has four sheets: single column, three column, petty cash and a blank sheet. Totals and balances are formulas, so they update as you type.
On this page
What a cash book is
A cash book is a book of original entry: transactions go into it first, on the day they happen. It also works as the cash account in the ledger, so you do not need a separate cash account. Every cash book has two sides:
- Debit side (left), receipts: cash sales, money a customer pays against udhar, cash you bring into the business, cash withdrawn from the bank.
- Credit side (right), payments: purchases paid in cash, rent, bills, salaries, cash deposited in the bank.
Each side has the same columns: date, particulars (who paid or what for), voucher or receipt number, L.F. (ledger folio, the page of the related ledger account) and amount. Credit sales and credit purchases do not go in the cash book, because no cash moved; they go in the customer's or supplier's khata.
Single column cash book format
One amount column on each side, for cash only. This is the format most small shops need. Example: Hassan Kiryana Store starts November 2026 with Rs 15,000 in the drawer.
| Date | Receipts (Dr) | Amount | Date | Payments (Cr) | Amount |
|---|---|---|---|---|---|
| Nov 1 | Balance b/d | 15,000 | Nov 2 | Purchases (wholesaler, cash) | 30,000 |
| Nov 3 | Cash sales | 42,500 | Nov 5 | Shop rent | 25,000 |
| Nov 8 | Aslam (udhar received) | 6,000 | Nov 10 | Electricity bill | 7,800 |
| Nov 15 | Cash sales | 38,000 | Nov 20 | Salary, helper | 18,000 |
| Nov 30 | Balance c/d | 20,700 | |||
| Total | 101,500 | Total | 101,500 | ||
| Dec 1 | Balance b/d | 20,700 |
Receipts add up to Rs 101,500 and payments to Rs 80,800. The difference, Rs 20,700, is the cash that should be in the drawer on 30 November. It is written on the payments side as balance c/d (carried down) so both totals match, then brought down on 1 December as balance b/d. If the drawer holds a different amount, an entry is missing.
Double and three column cash book format
Once the shop has a bank account, a double column cash book adds a bank column next to cash on both sides. A three column cash book adds a third column for discount: discount allowed to customers on the receipts side, discount received from suppliers on the payments side.
| Date | Receipts | Discount | Cash | Bank | Date | Payments | Discount | Cash | Bank |
|---|---|---|---|---|---|---|---|---|---|
| Nov 1 | Balance b/d | 15,000 | 120,000 | Nov 2 | Rehman Wholesale (cheque) | 1,500 | 58,500 | ||
| Nov 4 | Cash sales | 40,000 | Nov 12 | Bank (cash deposited) C | 20,000 | ||||
| Nov 6 | Bilal Traders (cheque) | 1,000 | 49,000 | Nov 18 | Shop rent | 25,000 | |||
| Nov 12 | Cash (deposited) C | 20,000 | Nov 20 | Electricity bill (online) | 7,800 | ||||
| Nov 30 | Balance c/d | 10,000 | 122,700 | ||||||
| Total | 1,000 | 55,000 | 189,000 | Total | 1,500 | 55,000 | 189,000 |
Three things to notice:
- Contra entries. Depositing Rs 20,000 of cash into the bank appears on both sides (cash out, bank in) and is marked C. It is one transaction inside the same book.
- Discount is not balanced. Cash and bank are balanced like the single column book. The discount columns are only totalled: Rs 1,000 goes to discount allowed and Rs 1,500 to discount received in the ledger.
- Bank can go negative. If the account is overdrawn, the bank balance c/d is written on the receipts side instead. Cash can never go below zero.
Petty cash book format (imprest system)
Small daily spending (tea, rickshaw fare, carry bags) clutters the main cash book, so many shops give a fixed float to one person and record it in a petty cash book. Under the imprest system the float is topped up at the end of each period by exactly the amount spent, so it always starts again at the same figure. The analysis columns show where the money went.
| Received | Date | Particulars | Total paid | Refreshment | Packing | Travel | Cleaning | Stationery |
|---|---|---|---|---|---|---|---|---|
| 10,000 | Nov 1 | Cash from main cash book | ||||||
| Nov 3 | Tea and biscuits | 1,200 | 1,200 | |||||
| Nov 7 | Shopping bags | 2,500 | 2,500 | |||||
| Nov 12 | Rickshaw to wholesale market | 800 | 800 | |||||
| Nov 18 | Cleaning supplies | 1,500 | 1,500 | |||||
| Nov 25 | Register and pens | 650 | 650 | |||||
| Total spent | 6,650 | 1,200 | 2,500 | 800 | 1,500 | 650 | ||
| Nov 30 | Balance c/d | 3,350 | ||||||
| 3,350 | Dec 1 | Balance b/d | ||||||
| 6,650 | Dec 1 | Cash from main cash book (top-up) | ||||||
Rs 6,650 was spent, Rs 3,350 is left, and the top-up of Rs 6,650 brings the float back to Rs 10,000 for December. Keep a slip for every payment; the slips should add up to the total spent.
How to balance a cash book
- Add the receipts side and the payments side separately.
- Subtract the smaller total from the larger. For the cash column the receipts side is always the larger.
- Write the difference on the smaller side as balance c/d, dated the last day of the period.
- Total both sides again; they should now be equal. Write the totals on the same line on both sides.
- Bring the balance down on the opposite side as balance b/d, dated the first day of the next period.
- Count the cash in hand. It should equal the balance. For the bank column, compare with the bank statement (a bank reconciliation).
Paper or phone? A paper cash book works, but you balance it by hand and it can get lost or wet. In the Khata365 app each cash in and cash out entry updates the balance as you save it, cash, bank and mobile wallet accounts sit side by side, transfers between them are recorded once, and the month can be exported to PDF or Excel. It works offline and is free on Android.
Questions
What is the format of a cash book?
Two sides: receipts (debit) on the left and payments (credit) on the right. Each side has date, particulars, voucher number, L.F. and amount columns. At the end of the period the difference is written on the smaller side as balance c/d so both totals match.
What is the difference between a single column and a three column cash book?
A single column cash book records cash only. A double column cash book adds a bank column (or a discount column). A three column cash book has cash, bank and discount columns on both sides.
What is the imprest system of petty cash book?
The petty cashier gets a fixed float, for example Rs 10,000. At the end of the period the main cashier pays back exactly what was spent, so the float is back to Rs 10,000.
Can a cash book have a credit balance?
The cash column cannot, because you cannot pay out more cash than you have. The bank column can, when the account is overdrawn.
Do credit sales go in the cash book?
No. A credit (udhar) sale moves no cash, so it goes in the customer's khata. The cash book records it only when the customer pays.
Related
Keep your cash book on your phone
Khata365 records cash in, cash out, udhar and stock in seconds, works without internet and is free on Android.