Skip to content
Khataby Lacspace
Running a shop

Counting a day that came in as both cash and UPI

Half the money is in the drawer and half is on a phone. Closing a day properly means checking both against what you sold, separately.

6 min read

Cash and UPI reconciled into one day's takingsIn the drawer₹ 8,450counted by handUPI, on the phone₹ 11,300read off the appDay’s takings₹ 19,750one number, two places it came from

In short

  • Check cash against cash and UPI against UPI. A single combined total hides every mistake inside it.
  • The payment method has to be on the bill for this to work at all.
  • A cash difference and a UPI difference have completely different causes, which is why separating them is the whole point.
  • Do it daily. A difference found today is a question; found next month, it is a mystery.

Ten years ago, closing a shop meant counting a drawer. The number in your hand either matched the day's sales or it did not, and if it did not you knew immediately that something had gone wrong at the counter. It was a good system, and its usefulness came entirely from the fact that there was only one place money could be.

Now there are two, and a great many shops have responded by giving up on the check altogether — adding the drawer and the phone together, comparing the sum to the day's sales, and shrugging at any difference. That is understandable and it throws away the thing that made the old routine work.

One number at the bottom, two places it came from. The two have to be checked separately before they are added.A cash drawer total and a UPI total on a phone, both feeding down into one day's takings figure.In the drawer₹ 8,450counted by handUPI, on the phone₹ 11,300read off the appDay’s takings₹ 19,750one number, two places it came from
One number at the bottom, two places it came from. The two have to be checked separately before they are added.

Why the combined total tells you nothing

Suppose your records say the day was ₹19,750, your drawer holds ₹8,200 and your phone shows ₹11,300. Combined, that is ₹19,500 against ₹19,750 — a shortfall of ₹250, which most people would shrug at.

Separated, it is a different story. UPI matches exactly, because it always does — an electronic record and an electronic record cannot disagree unless a sale was recorded under the wrong method. So the entire ₹250 is a cash difference, and cash differences have real causes: change given wrong, a purchase paid out of the till without being recorded, a sale rung up incorrectly. Now you have somewhere specific to look, on the day it happened, while somebody still remembers.

The five-minute version

  1. 1

    Count the drawer before you look at any screen

    Count first, then compare. If you read the expected figure first, you will find it — everybody does, and it is not dishonesty, it is how counting works.

  2. 2

    Take the UPI total from the payment app

    The day's received figure from the app itself, not from your memory of notifications.

  3. 3

    Compare each against its own total

    Cash sales against the drawer, UPI sales against the app. Two comparisons, not one.

  4. 4

    Note the credit given, separately again

    Money that did not arrive today is not a shortfall — it is a balance. If it is not recorded as credit, it will look like a cash difference and you will spend an evening looking for it.

  5. 5

    Write down anything unexplained, and move on

    You are not going to solve every difference tonight. Recording that there was one, and how much, is what turns a series of shrugs into a pattern you can eventually see.

What each kind of difference usually means

What you seeUsual cause
Cash short by a small amount, most daysChange given wrong, or small purchases made from the drawer without being recorded as an expense.
Cash short by a large amount, one dayA specific event: a sale not rung up, a payment taken and not recorded, or money removed. Worth following the same day.
Cash overUsually a sale recorded at the wrong price, or a payment against an old credit balance that was not applied to the khata.
UPI shortAlmost always a sale recorded as cash that was actually paid by UPI. Check the bills near the amount of the difference.
UPI overA payment received that was not a sale — a customer clearing an old balance, or money from something else entirely.
A difference you find today is a question somebody can still answer. The same difference found in November is just a hole.

Common questions

How do I reconcile UPI payments at the end of the day?

Total the UPI sales your records show for the day, then compare that against what your payment app shows received. They should match. Any difference is usually a sale marked cash that was actually UPI, or a payment that came in for something other than a sale.

Why does my cash never match exactly?

Small differences are normal and usually come from change given wrong or a small purchase paid out of the drawer. What matters is the size and the direction. A few rupees either way is noise; the same shortfall every day, or a large one on a single day, is a pattern worth following.

Should I record UPI payments as cash to keep it simple?

No. It is simpler for about a week and then it costs you the ability to check anything. Once cash and UPI are mixed into one figure, a difference in your drawer cannot be distinguished from a difference in your phone, and you lose the only diagnostic you had.

What if a customer pays partly in cash and partly by UPI?

Record it as what it was: part cash, part UPI, against the same bill. It takes a moment longer at the counter and it keeps both of the day's totals correct, which is the point of recording the method at all.

Khata is free to use

Billing, khata, stock and reports on your phone. No card, nothing to cancel.

See what you get

UPIcashdaily closingreconciliation

Read next

All articles