Cash Book Format — Free Excel and App
A cash book records every cash receipt and payment in date order with a running balance.
Small businesses use a cash book to know how much cash is in hand and where it went each day.
Cash Book format preview
| Date | Particulars | Voucher no. | Receipt (in) | Payment (out) | Balance |
|---|---|---|---|---|---|
| 12-Nov-2026 | Cash sale | V-118 | ₹4,200 | ₹18,650 |
The second row is a filled sample.
What each column means
Date
Example: 12-Nov-2026
Particulars
Example: Cash sale
Voucher no.
Example: V-118
Receipt (in)
Example: ₹4,200
Payment (out)
Example: —
Balance
Example: ₹18,650
Please note: Rules on which records you must keep, and in what layout, can differ by state and by business type. Check the requirement that applies to you with your CA or labour consultant before adopting any format.
Cash Book FAQs
What is a cash book?
A register of all cash coming in and going out, with the balance after each entry.
How is the cash balance calculated?
Previous balance plus receipts minus payments.
Should I record UPI and bank payments?
Many businesses keep a separate bank book for those. Record cash in the cash book and non-cash entries in the bank book.
Can I keep a cash book on my phone?
Yes. Recordbook lets you add entries on the go and keep a running balance with a formula column.
Related registers
Daily Sales Register
Format and sample
Expense Register
Format and sample
Udhaar Khata Register
Format and sample
Running a retail & inventory business? See Recordbook for retail & inventory · Recordbook vs Excel