Cash Book Format for Indian Shops: The Simple Daily System (2026)

Ramesh runs a hardware store in Kota. For years his "accounts" were a spiral notebook and a steel cash box, and most evenings the two roughly agreed — roughly. Then came a stretch where the box kept falling short. ₹2,000 one week. ₹3,500 the next. Once nearly ₹6,000 on a single busy Saturday. He started suspecting a staff member.

He was wrong. When he finally sat down and rebuilt one week entry by entry, the gaps were ordinary. ₹1,200 of loading and tempo charges paid in cash and never written down. Three UPI payments he had counted in his head as cash in the box. A ₹5,000 advance to his helper that lived only in his memory. Nothing was stolen.

His cash book — the running record of money in and money out — simply had holes. And every hole showed up as "missing" cash at closing. Once he started recording every rupee the moment it moved, and marked whether it came as cash or UPI, the box matched to the rupee within a week. The shortfall was never a theft problem. It was a bookkeeping problem wearing a theft costume.

Ramesh is a composite based on real Accountune customers in the hardware and retail trades. Names and identifying details changed; the outcome is representative of our verified customer cohort.

Accountune is a cloud-based GST billing, inventory and accounting platform built in Jaipur since 2017 and used by 12,000+ Indian small businesses. This guide explains the cash book for small business owners the way a shop actually needs it — a simple daily cash book that matches your cash box — not the way a commerce textbook teaches it.

What is a cash book, and what format should a small business use?

Quick answer: A cash book is a daily record of all money coming into and going out of your business — cash and UPI — with a running balance you match against the cash box each evening. For an Indian shop, the simplest working format has six columns: date, particulars, money in, money out, mode, and balance. The easiest way to keep one is billing software like Accountune, which builds the cash book automatically from every bill and expense you record.

What a cash book actually is (and what it isn't) {#what-it-is}

A cash book is a running record of every rupee that enters and leaves your business, kept day by day, showing the cash balance at the close of each day. It is not the debit-and-credit exercise you may remember from a commerce class. For a shopkeeper, it is simply the answer to one question: how much money moved today, and how much should be sitting in the box right now?

In most Indian shops this record already has a name — the rokad bahi. The old cloth-bound register in the drawer is a cash book. So is a WhatsApp note, an Excel sheet, or the running total inside your billing software. The tool changes; the job does not.

One thing trips people up. A cash book is both a diary and a running total at the same time. It lists each transaction in order, and it keeps a live balance, so you never have to add up the whole day to know where you stand. That is why it sits at the centre of a shop's books while everything else — sales registers, ledgers, GST returns — builds on top of it.

What a cash book is not: it is not a record of credit. When you sell on udhaar, no money has moved, so nothing enters the cash book yet. It records the payment only on the day the customer actually pays. It is also not the academic single, double, or triple-column format built to double as a formal ledger. Those exist for accountants preparing final statements. A shop needs something plainer.

The cash book format an Indian shop actually needs {#format}

Skip the textbook. The right cash book format for small business in India needs to do one job well — tell you how much cash should be in the box right now. The single-column, double-column and triple-column formats you will find on most search results were designed decades ago to double as ledger accounts, with debit and credit sides. A shop owner counting a cash box at 9pm does not need that. The format below does the whole job with six columns.

The one rule that makes this format work: only Cash-mode entries change the Balance column. A UPI sale is still money in, so you record it in the "In" column and mark the mode as UPI — but it landed in your bank, not your drawer, so it does not touch cash-in-hand. Do this, and your Balance column always equals what should be physically in the box.

Here is a normal morning at Ramesh's hardware store, opening with ₹4,000 cash in hand.

Notice the UPI rows. The ₹1,200 sale and the ₹5,000 supplier payment are recorded, but the Balance does not move for them, because no cash left or entered the box. At close, the box should hold ₹8,370 in cash. Your bank, separately, is up ₹1,200 and down ₹5,000 from UPI. Two numbers, both correct, never mixed. This single habit is what most shortfall problems come down to.

How to maintain a daily cash book, step by step

Here is how to maintain a cash book for a shop, start to finish:

1. Open the day with yesterday's closing cash-in-hand.

2. Record every transaction as it happens — amount, particulars, and mode (cash / UPI / card).

3. Move the balance only for cash entries; leave it unchanged for UPI and card.

4. Close each evening by counting the box and matching it to the balance.

The method is simple; the discipline is doing it live at the counter, not catching up at the end of the week.

Why the modern cash book must track UPI, not just cash {#upi}

UPI is money that reaches your bank account instantly, not cash that sits in your drawer. That distinction is the entire reason the old all-cash rokad bahi has stopped tallying for most shops. According to NPCI, UPI processed close to ₹29.90 lakh crore in May 2026 alone — a typical counter now takes cash, UPI and card within the same ten minutes.

Here is where it goes wrong. A customer pays ₹1,200 by UPI. The owner, mid-rush, mentally files it as "sale done" and later remembers it as cash. Now the cash book says there should be ₹1,200 more in the box than there actually is. At closing, the box looks short by ₹1,200, and the owner starts wondering who took it. Nobody took it. The money is safely in the bank; it was just written in the wrong place.

The fix is the Mode column. Every entry carries one extra fact — how the money moved — and that one fact keeps your cash and your bank from bleeding into each other. Record the UPI sale as money in, mark it UPI, and leave cash-in-hand alone. At month-end, the same mode tags make your bank reconciliation and your GST reporting accurate, because you can see exactly which sales were cash and which were digital.

A paper register can do this if you add a mode column and stay disciplined. It is one more thing to remember on a busy day, which is exactly why it slips.

The evening ritual: matching the cash book to the cash box {#reconcile}

Every shop should end the day with one small ritual: count the box, and check it against the daily cash book. The maths is simple. Opening cash-in-hand, plus cash received, minus cash paid, equals the cash that should be in the drawer. Count the notes and coins. If the two agree, close up. If they don't, something went unrecorded, and it is far cheaper to catch it tonight than to hunt for it at year-end.

When the numbers don't match, the gap almost always comes from one of a handful of ordinary leaks:

1. Petty cash not written — tempo charges, tea, packaging, a quick repair paid from the drawer and forgotten

2. UPI counted as cash — a digital sale recorded in the cash column, the single most common cause

3. A credit sale marked as cash — udhaar written as if the customer paid on the spot

4. A staff advance or personal withdrawal — money taken from the box that never made it into the book

5. Wrong change given — a genuine counting error at the counter

Tracing the gap is boring but reliable: work backwards through the day's cash entries and compare each against what you remember. This is exactly how Ramesh found his ₹6,000 — not a thief, but a stack of unwritten tempo bills, two miscounted UPI sales and one forgotten advance. The register was not lying. It was just incomplete, and an incomplete cash book always reports the shortfall as if it were cash gone missing.

Software shortens this hunt dramatically. Because every sale and expense is already recorded with its mode and a timestamp, a tool like Accountune lets you scroll the day's entries and spot the odd one out in minutes, instead of reconstructing the day from memory.

Petty cash: the small payments that quietly break your books {#petty-cash}

Petty cash is the small, day-to-day money you spend straight from the drawer — tea, auto fare, loading charges, a courier, some string and tape. Each amount is tiny, which is exactly why it never gets written down, and exactly why it adds up to the mysterious gap in your cash book at month-end. A ₹40 here and a ₹120 there is invisible on any single day and very visible across thirty of them.

The trouble with petty cash is behavioural, not technical. No bill forces you to record it. A supplier payment leaves a paper trail; a ₹60 tea round does not. So the discipline has to come from a habit: capture the expense the moment it happens, before the next customer walks in.

Across our onboardings, the shops that reconcile cleanly almost all share one thing — they record petty expenses on the spot, not at the end of the week. The ones who "note it later" are the ones whose books never quite tally. The gap between the two is rarely more than a few seconds per expense; it is just a few seconds that has to actually happen.

This is one place software earns its keep. Recording a cash expense in Accountune takes about fifteen seconds — open the app, tap add expense, enter the amount, pick a category, done — which is short enough that it survives a busy counter. Every one of those small payments then lands in the same cash book as your sales, and the month-end mystery quietly disappears.

Cash book vs day book vs ledger vs cash flow, cleared up {#vs}

These four terms get used as if they mean the same thing. They don't, and mixing them up is why so many shop owners feel lost the moment their CA speaks. Here is the plain-language difference.

A day book (also called a journal) is the full diary of your day, cash or credit. A ledger takes those entries and files them by account, so you can see everything one customer owes on a single page. A cash flow statement zooms out to a whole period and answers a bigger question — did the business generate cash this month, or burn it?

The cash book sits underneath all three. Keep it clean and daily, and the day book, ledger and cash flow all fall out of it with far less effort. This is precisely what online accounting software does — it maintains the cash book from your transactions and then generates the rest automatically, so you are not building four records by hand.

Is keeping a cash book mandatory? What the law requires {#mandatory}

For most growing shops, yes. Under Section 44AA of the Income Tax Act, 1961, read with Rule 6F of the Income Tax Rules, 1962, a business must maintain proper books of account once it crosses a size threshold — and a cash book is the very first record those rules name. For an individual or HUF running a business, that duty kicks in when income exceeds ₹2,50,000 or turnover exceeds ₹25,00,000 in any of the three preceding years.

The penalty for ignoring it is real but bounded. Under Section 271A of the Income Tax Act, failing to keep or retain the required books can attract a penalty of up to ₹25,000, though it may be waived if you can show a reasonable cause. There is a quieter cost too: with no proper books, an Assessing Officer can estimate your income under a best-judgment assessment, which usually lands higher than what you would have declared. Books of account, including the cash book, must be retained for six years from the end of the relevant assessment year.

On the GST side, Section 35 of the CGST Act, 2017 separately requires every registered person to keep true and correct accounts of all inward and outward supplies, stock and tax — so a clean daily record of money moving through the business supports both your GST filing and your income-tax return.

One recent change matters here. The Finance Act, 2025 explicitly permitted digital record-keeping under Section 44AA, confirming that accounting software and cloud platforms are a valid way to maintain the prescribed books, including the cash book. In plain terms: the law no longer expects a paper register. A well-kept digital cash book is not a shortcut around the rules — it is the rules, done more reliably.

Paper, Excel, or software: keeping the cash book without the daily grind {#software}

There is no single right tool, only the right tool for your stage. Paper still works for the smallest setups. Excel is a step up. Software takes the daily grind off the table entirely. The honest way to choose is to be clear-eyed about where each one breaks.

Paper rokad bahi is fine if you do very few entries a day, work alone, take almost no udhaar, and are not GST-registered. Past that point, it starts to cost you: pages tear, entries get skipped in a rush, and there is no mode column stopping cash and UPI from mixing. Only one person can hold the register at a time.

Excel fixes the durability problem and gives you formulas, but you still type every single entry by hand, a wrong cell quietly breaks the running total, and nothing about the sheet stops the cash box from going out of sync. It works until your volume outgrows the patience for daily data entry.

Billing software removes the entry step, because the cash book is built from bills you are already creating. This is where a tool like Accountune fits a shop rather than an accountant. Every invoice you cut posts to the cash book as a receipt with its mode; every expense you log posts as a payment; the opening balance, each transaction and the closing balance sit on one clean screen. When the box does not match at night, you trace every entry in minutes instead of rebuilding the day from memory. Petty expenses take about fifteen seconds to capture, and your CA can view the books remotely at filing time. It runs in the cloud, so the same live data is on your phone, tablet and desktop with an automatic backup — no register to lose. You can start on the automatic bookkeeping Free plan, or move up from ₹799/year, with a 4-day trial and no card.

The point is not that software is always the answer. It is that once you take more than a handful of payments a day across cash and UPI, keeping the cash book by hand becomes the expensive option — not in software fees, but in the hours and the shortfalls you never quite explain.

Common questions, answered {#conversational}

What's the simplest cash book format for a small shop? Six columns: date, particulars, money in, money out, mode, and running balance. Record cash and UPI both, but let only cash entries change the balance, so it always equals the physical cash in your box.

Rokad bahi kaise banate hain? Roz subah opening cash likho, phir din bhar har paisa aane-jaane pe entry karo — amount, mode (cash ya UPI), aur running balance. Sirf cash wali entry se balance badlega. Raat ko box gino aur balance se milao.

How do I record a UPI payment in my cash book? Enter it in the money-in column and mark the mode as UPI. Do not add it to your cash-in-hand balance, because the money went to your bank, not your drawer. Recording it any other way is what makes the box look short.

Why is my cash box short almost every week? Usually one of four things: petty cash spent and not written, a UPI sale counted as cash, an udhaar sale marked as paid, or a staff advance taken from the drawer. It is almost never theft; it is almost always an unrecorded entry.

Is a cash book the same as a ledger? No. A cash book records money moving in and out with a running balance. A ledger regroups all your transactions by account, so you can see everything one customer owes or one expense adds up to. The cash book feeds the ledger, not the other way round.

What's the easiest way to keep a cash book without writing everything by hand? Use billing software that builds it for you. Accountune posts every sale and expense to the cash book automatically, tags the mode, keeps a live closing balance, and lets you trace any mismatch in minutes — on a Free plan or from ₹799/year.

Start with the format that fits you today. The six-column layout above works on paper or in Excel, and you can download a ready-to-print cash book format to begin tonight. If you would rather not write every entry by hand, Accountune builds the same cash book automatically from your bills and expenses — cash and UPI tagged, closing balance always ready, and any mismatch traceable in minutes. Free plan or from ₹799/year, 4-day trial, no card.