Guide

The daily day book: cash, UPI and settlements for a small business

One page a day, kept the same way every day, answers most of the questions an owner asks about money — and most of the ones an accountant asks too.

A day book is one page per business day: everything that came in, split by how it came — cash, UPI, card, bank transfer — against everything that went out, and what should be left in the drawer.

Keep money that did not arrive today on lines of its own — a company account settled at month end, a delivery-app payout, a customer’s udhar — and close the page by counting the drawer against the book, writing down any difference with a reason.

This guide explains the rules in plain words for owners. It is not tax advice: rates and forms change by notification, and your own case may differ. Confirm with the official source linked below or with your chartered accountant before you act on it.

Day book, cash book, bank book: which is which

BookWhat it recordsThe question it answers
Day bookEvery transaction of the day, in order, whatever the methodWhat happened today?
Cash bookOnly cash in and out, with a running balanceHow much cash should there be?
Bank bookMoney through the bank: UPI, card settlements, transfers, chequesWhat should the bank statement show?
Ledger or khataA running account per customer or supplierWho owes whom, and how much?

For a small business the day book can do the first three jobs at once — if every line carries its method. That single column is what lets the cash total and the bank total fall out of the same page.

The columns

ColumnExample
Time13:42
WhatBill 1045 · Milk from Sharma Dairy · Advance to Ravi
In or outIn
MethodCash, UPI, card, bank transfer, company account, app payout, khata
Amount₹1,240
ReferenceThe bill number, the UPI reference, the voucher number
WhoThe person who took or paid it

Why every method gets its own line

  • Cash is the only money you can count tonight.
  • UPI lands in the bank, not in the drawer. Check it against the bank app or the payment soundbox, never against the drawer.
  • Card payments reach the bank later, usually less the bank’s fee, so the card total and the bank credit rarely match to the rupee.
  • A company account — credit to a business customer, a hotel’s city ledger — is a sale today and money on another day.
  • Delivery-app payouts arrive later, after the platform’s commission and deductions, and are never cash.
  • Khata or udhar is a sale with no money yet. It belongs in the customer’s account, not in the drawer total.

Mix any of these into “cash” and the drawer will look short or over by exactly that amount — and somebody gets blamed for a difference that is only a bookkeeping one.

Keep it on the business date

A restaurant that shuts at 1 am, or a hotel with a night desk, should keep the day book on its business date, not the calendar: a bill at 00:30 belongs to the evening that took it. Decide the cut-off once — for example 4 am — and keep to it, or every late night splits its money across two pages.

Closing the day

  1. Stop billing for the day, or note the time the page was closed.
  2. Count the cash by denomination and write the count down.
  3. Expected cash = opening float + cash in − cash out (expenses, refunds, advances, cash taken to the bank).
  4. Compare the count with the expected cash. Write the difference and, if you know it, the reason.
  5. Check the UPI total against the bank app, and the card total against the terminal’s settlement slip.
  6. Leave tomorrow’s float in the drawer; bank or lock away the rest, and record it as money moved, not money spent.
  7. Sign the page. Somebody else initials it the next morning.

A worked example

Sales today, by methodAmountIn the drawer tonight?
Cash₹18,450Yes
UPI₹24,300No
Card₹6,200No
Company account (billed, paid later)₹4,500No
Khata (udhar)₹1,150No
Total sales₹54,600
Cash paid out todayAmount
Milk — Sharma Dairy₹1,240
Vegetables₹1,410
Auto fare, supplies run₹150
Advance to Ravi (comes back off his salary)₹1,000
Total cash out₹3,800

The drawer

Opening float₹2,000
+ Cash sales₹18,450
− Cash paid out₹3,800
Expected in the drawer₹16,650
Counted₹16,600
Differenceshort by ₹50

Of ₹54,600 of sales, only ₹18,450 is in the drawer tonight. UPI and card are for the bank to confirm; the company account and the khata are money still to come. And the advance to Ravi is not an expense — it comes back off his salary.

Expenses: on the day, with a bill

  • Write every expense the day it happens: what, how much, how it was paid, and the bill or voucher number.
  • Put each in a category — stock, salary, rent, utilities, fuel, maintenance — so the month can be compared with the last.
  • A delivery taken on credit is a supplier bill, not an expense paid; the payment later is the money going out.
  • An advance to staff is money out, not a salary expense: it comes back off a payslip.
  • The owner’s personal spending from the drawer is drawings, not a business expense. Write it down as such.

Three income-tax rules that make the record matter

The Income-tax Act, 2025 replaced the 1961 Act from 1 April 2026 and carried forward three rules that a day book with a method on every line helps you keep:

  • Receiving cash. No person may receive ₹2,00,000 or more in cash from one person in a day, for a single transaction, or for transactions relating to one event or occasion (section 186; it was section 269ST). The penalty is a sum equal to the amount received (section 451). A wedding order or a banquet paid in cash is where this bites.
  • Paying cash. When payments to one person in a day add up to more than ₹10,000 and are not made through a bank or a specified online mode, the expense is not allowed as a deduction (section 36(4); ₹35,000 for hiring goods carriages; it was section 40A(3)). Pay suppliers by UPI or bank above that line.
  • Keeping books. A business must keep books of account if its business income exceeds ₹1,20,000 or its turnover exceeds ₹10 lakh in any of the three preceding years — ₹2,50,000 and ₹25 lakh for an individual or HUF (section 62; it was section 44AA). A day book is the daily part of those books.

The weekly and monthly look

  • Cash differences by person and by day of the week — a pattern is a question, a one-off usually is not.
  • UPI and card totals against the bank statement.
  • Company accounts and khata balances by age.
  • Delivery-app payouts matched to the orders they pay for.
  • Expenses by category against last month.

How Nivasik handles this

The day book is in Nivasik’s reports, built from the same bills, payments and expenses the rest of the product records — nobody types it twice.

  • A day book: what came in by cash, UPI and card, against what went out, and what is left.
  • It runs on the property’s business date, so a 00:30 bill belongs to the night that took it; a shop’s day follows the calendar with a 4 am cut-off, and a day nobody ended is closed for them.
  • Company-account and delivery-app settlements are kept apart from the drawer.
  • Expense categories — salary, maintenance, fuel, rent, stock, utilities and more — each with its payment method.
  • Vendors, supplier bills and what you owe them; purchase orders.
  • A cash drawer per counter, with shift close and a day-end report.
  • Advances booked as money out on the day they are handed over, and taken off the payslip.

What it does not do

  • It records UPI and card payments; it does not take them. There is no payment gateway or card-terminal link, so check UPI against your bank app.
  • Tally gets an import file (CSV), not a live connection.

Expenses and vendors are in the Pro plan at ₹4,999 per property a month; a counter’s cash drawer and day-end report come with POS at ₹1,499 per outlet a month. Every plan starts with a 45-day free trial — see pricing.

Questions people ask

What is the difference between a day book and a cash book?

A day book records every transaction of the day, whatever the method. A cash book records only cash, with a running balance. If every day-book line carries its method, the cash book falls out of it.

Should UPI payments go in the cash book?

No. UPI money lands in the bank, so it belongs with the bank book and is checked against the bank app — not against the drawer.

What should I do about a cash shortage?

Write it down the same night, with the amount, the time and anything you know. One shortage is usually a mistake; the same shortage on the same shift every week is a pattern worth looking into.

Is a staff advance an expense?

No. It is money out that comes back off a payslip. Book it as an advance on the day it is handed over.

Is keeping a day book required by law?

The Income-tax Act, 2025 requires books of account once business income or turnover crosses the limits in section 62. A day book is the simplest daily part of them, and it is the record that shows which money came in cash and which by UPI.

Sources

  1. The Income-tax Act, 2025 (No. 30 of 2025) — Gazette of India, 21 August 2025. Sections 36(4)–(6), 62, 186 and 451.
  2. The Income-tax Act, 2025 comes into force — Press Information Bureau, 1 April 2026.
  3. The Finance Act, 2026 (No. 4 of 2026) — Gazette of India, 30 March 2026. Checked for amendments to the sections above; none found.

Last reviewed: , by the Nivasik Team. Found something out of date? Write to support@nivasik.com and we will correct it.

Let the day book write itself from the bills.

Try Nivasik free for 45 days. We set up your counters, payment methods and expense categories with you. No card.