Cash Book
Daily cash in, cash out, and closing balance — the shop diary, minus the diary.
Add entry
Opening
₹0.00
Cash in
₹0.00
Cash out
₹0.00
Closing
₹0.00
Loading…
What is a cash book?
A cash book is the daily register of every rupee that comes into and goes out of the cash drawer, kept in date order with a running balance. Many shops know it as the rokad bahi or rojnamcha: cash sales collected on one side, payments for tea, transport, wages and small purchases on the other, and the day's closing balance carried forward as the next morning's opening. It is the simplest of the books of accounts and often the first one a business keeps.
Cash is the asset that goes missing most easily. When the closing balance in the book is compared with the notes and coins actually in the drawer each evening, a shortfall shows up the same day, while the person on the counter still remembers what happened. A cash book also gives your CA a record that supports cash sales and cash expenses at year-end, and it supplies the cash figure your balance sheet and cash flow statement need.
Cash still pays for many small daily expenses in Indian shops, but income tax rules restrict large cash payments and receipts, and a business expense paid in cash above the permitted limit can be disallowed. Your CA can tell you the current limits. A dated cash book with a description against each entry is what you will need if a cash expense or a cash deposit into the bank is ever questioned. Record petty cash spends as they happen rather than in one lump at month-end.
What the cash book keeps track of
Automatic carry-forward
Each day starts from everything recorded before it, so you never copy yesterday's closing figure by hand.
Colour-coded entries
Cash in shows in green with a plus sign and cash out in red with a minus, each with the time it was entered.
Negative balance flag
If the closing balance drops below zero it turns red, a sign that an entry is missing or wrong.
Full-book CSV
Exports Date, Type, Description, In, Out and a running Balance column for Excel, Google Sheets or your CA.
Feeds your statements
The Balance Sheet and Cash Flow Statement tools can pull cash totals from this book on the same device once you allow them to use the workspace.
Safe deletes
Deleting an entry asks for confirmation first, and the balances for every later day recalculate straight after.
How to use the free cash book
- 1Under Add entry, pick the date. It starts at today, and you can choose an earlier day for a missed entry.
- 2In Category, choose Cash in (+) for money received or Cash out (−) for money paid.
- 3Type the amount and a short description such as day sales, tea or auto fare, then click Add entry.
- 4Use the Day picker to view any date; the cards show that day's Opening, Cash in, Cash out and Closing balance.
- 5To correct a mistake, click Delete on the entry, confirm, and add it again with the right figures.
- 6Click Export CSV to download the whole book with a running balance after every entry.
End-of-day cash book routine
- Count the cash in the drawer before closing and compare it with the day's Closing figure.
- Record cash you deposit in the bank as Cash out with a description such as Deposited to bank.
- Enter money the owner takes home as Cash out marked drawings, so the shortfall is explained.
- Write who was paid and why in the description, not just the amount.
- Add a missed entry under its real date so the balances for that day and after stay correct.
- Export a CSV at month-end and give it to your accountant along with the bills for cash expenses.
Related tools for your shop accounts
Frequently asked questions
Automatically. The opening balance of any day is the running total of all earlier entries; the closing balance adds that day's cash in and subtracts cash out.
Yes — everything stays in your browser on your device. No signup, no cloud. Export the full book as CSV any time.
Yes — pick any date when adding an entry and when viewing. Balances recalculate across the whole book.
There is no separate opening balance field. Add a Cash in entry for the amount you are starting with, dated the day before your first day, with a description such as Opening balance. It then appears as the opening balance on your first day, and every later day carries it forward automatically.
There is no edit option. Click Delete on the wrong entry, confirm, and add it again with the correct date, type, amount and description. The opening and closing balances for that day and every later day recalculate as soon as the entry is removed and added back.
The screen shows one day at a time. For a monthly or yearly total, export the CSV and add up the In and Out columns in Excel or Google Sheets, filtering by the Date column. The Balance column gives the running balance after each entry, so the last row of a month shows that month's closing cash.
Keep this book for notes and coins only, so its closing balance can be checked against a count of the drawer. UPI, card and bank transfer receipts land in your bank account, and adding them here would make the drawer count look short. When you deposit cash into the bank, record it as Cash out.