A simple small-business cashbook: how to keep one in 10 minutes a day
Why keep one
Most small businesses that run out of cash were profitable on paper. A cashbook shows what you actually have today, which customers pay late and where the money goes. It is also the first thing your accountant will ask for.
The columns
| Date | Description | Category | Mode | In | Out | Balance |
|---|---|---|---|---|---|---|
| (date) | Sale to (customer) | Sales | UPI | (amount) | (previous + in − out) | |
| (date) | Shop rent | Rent | Bank | (amount) | (previous + in − out) |
Keep the "Mode" column (cash, UPI/card, bank) so you can check each against its own balance.
A 10-minute daily routine
- Enter every sale and expense from today (bills, receipts, payment app history).
- Check today's closing cash in hand against the cash balance.
- Note anything unpaid in a separate follow-up list.
Once a week, match the bank and payment-app entries with your statement. Once a month, total each category.
Common mistakes
- Mixing personal and business money. Record what you take for yourself as "Owner's drawings".
- Recording only cash. Digital payments are most of the money for many shops now; include them.
- Batching a month at once. Small items get forgotten. Daily is easier than monthly.
- No receipts. Keep a photo of every bill in one folder named by month.
- Too many categories. Start with 6 to 8 and add only when you need to.
Starter checklist
- Opening balances for cash, bank and payment app
- Category list (sales, purchases, rent, wages, utilities, transport, drawings, other)
- A daily time slot
- A receipts folder
- A weekly count
Frequently asked questions
What is a cashbook?
A dated record of all money received and paid, with a running balance, used to know how much cash a business has at any time.
Do I need accounting software for a cashbook?
No. A notebook or a spreadsheet works. Software helps when you need invoices, tax returns or several users.
How often should I update my cashbook?
Daily, with a weekly check against cash in hand and bank statements.
Official sources
Not accounting or tax advice. Record-keeping rules differ by country; ask a local accountant what you must keep and for how long. Last checked 11 Oct 2026.
Get free deadline reminders. Free: one short email every Wednesday listing the GST, TDS and ITR due dates coming up. Unsubscribe anytime.
Subscribe free on Gumroad (email only, no payment).
Or put every date in your calendar now: free India tax deadline calendar (Google Calendar, Outlook, phone; .ics + spreadsheet).
If you want a ready-made tool
If you'd rather start from a ready sheet with a running balance, cash/UPI/bank split, month summary by category, a weekly plan and a customer follow-up tab: Small Business Weekly Planner + Cashbook (paid, Google Sheets/Excel). It is an organiser, not accounting software.
Unadhi Guides are free, independent explainers. Not an official government publication. We correct errors as soon as we find them: write to mininglife7@gmail.com.
Partners earn 50% on every sale until 11 Nov 2026 (launch month; 30% after). Nothing to buy: become an Unadhi affiliate (free to join) and share our tools.