Shop cash drawer reconciliation compares the notes and coins you count with the cash your records say should remain. Start with opening cash, add cash received, subtract cash paid out, then investigate any difference. This guide gives you a closing checklist, a worked example and the relevant steps in Yojika.
Shop cash drawer reconciliation starts with one boundary
Decide what you are counting: the counter drawer alone, or all business cash including a safe and petty-cash box. Keep the opening count, transaction list and closing count within that same boundary.
Choose a closing time. Finish the current customer transaction before counting, and record any later movement separately. Note the date as DD/MM/YYYY and the time beside your count.
An opening float is the cash kept for change. Count it at opening; do not assume yesterday’s planned float is what actually remained. Money already present at opening must not be added again as today’s receipt.
This routine is useful before busier evenings. Incredible India’s calendar places Navratri from 11/10/2026, making early October a useful time to practise a consistent closing count.
Calculate cash movements, not just sales
Use this cash reconciliation formula:
Expected closing cash = opening cash + cash in − cash out.
| Movement | Effect on the drawer | Record to check |
|---|---|---|
| Cash collected for today’s bills | Add the cash portion | Bill and payment entry |
| Old customer dues collected in cash | Add | Receipt against the old balance |
| Owner adds change money | Add | Dated note of money introduced |
| Supplier or expense paid in cash | Subtract | Payment record and supporting document |
| Cash refund | Subtract | Refund and related sale records |
| Owner takes cash for personal use | Subtract | Dated withdrawal note |
| Cash deposited into a bank | Subtract | Deposit evidence and transfer entry |
| UPI, card or unpaid credit sale | No physical cash movement | Check separately |
If a customer tenders ₹500 for a ₹320 bill and receives ₹180 change, the drawer gains ₹320. Count the net cash retained, not the amount tendered. For a split payment, include only the cash part.
Your daily sales report answers a different question: what was sold? It can include credit sales and digital payments. Cash collected today can also include yesterday’s udhaar. For digital receipts, use the separate guide to matching UPI payments to bills.
Worked example: closing a Pune shop
Consider an illustrative Pune shop that keeps all its business cash in one drawer. Meena starts with ₹2,000, collects ₹8,400 from today’s cash sales and receives ₹1,500 towards an older customer balance.
She pays a supplier ₹2,000, pays a documented delivery expense of ₹300, takes ₹1,000 for personal use and deposits ₹5,000 into the shop’s bank account.
| Closing-sheet entry | Cash in | Cash out |
|---|---|---|
| Opening cash | ₹2,000 | — |
| Today’s cash collections | ₹8,400 | — |
| Older dues collected | ₹1,500 | — |
| Supplier payment | — | ₹2,000 |
| Delivery expense | — | ₹300 |
| Owner withdrawal | — | ₹1,000 |
| Bank deposit | — | ₹5,000 |
| Total, including opening cash | ₹11,900 | ₹8,300 |
Expected closing cash: ₹11,900 − ₹8,300 = ₹3,600.
Her physical count is ₹3,500. Actual minus expected is ₹3,500 − ₹3,600 = −₹100, a shortage to investigate. It does not prove that a sale was missed or that anyone took money.
These are final cash amounts, including any tax already charged on the underlying bills. For ordinary taxable local sales where the supplier and place of supply are both in Maharashtra, CGST and SGST apply; see CBIC’s supply FAQ, question 85. Use the actual invoice amounts for reconciliation. Confirm current product rates and any tax treatment of corrections with your CA.
Count denominations and trace the difference
List each denomination, the number of notes or coins, and its subtotal. Add the subtotals and recount before comparing with the expected balance. Keep personal money outside the count.
If the figures disagree, check:
- Payment method: was a UPI receipt entered as cash, or the cash part of a split payment missed?
- Timing: did a receipt or payout fall after your chosen cutoff?
- Small payouts: is there a delivery receipt, refund or supplier payment still waiting to be entered?
- Withdrawals and deposits: did cash leave the drawer with a clear destination and record?
- Change and duplicates: was change given incorrectly, or a payment recorded twice?
Correct a confirmed mistake using its evidence. If the cause remains unknown, retain the original count, expected balance and difference for follow-up. Ask your accountant how to record a persistent shortage or excess; a made-up balancing sale hides the problem.
Use Yojika’s Cash account as the record side
Open Cash & Bank, select Cash, then choose Statement. Select Today or Custom… for the date you are checking; the statement initially opens on This FY. It shows opening balance, money in, money out and closing balance, and supports Export CSV.
Compare that statement with your physical count only when both cover the same holdings. Moving notes from the drawer to a safe does not reduce total business cash. If the Cash account includes both, count both or keep a separate drawer worksheet.
For a known personal withdrawal, the Cash account’s Adjust balance action lets you choose Reduce, enter the amount, date and a reason. For an actual bank deposit, use Transfer with Cash as the source and the bank account as the destination. Check existing records first so you do not enter either movement twice. Keep normal supplier payments and expenses in their appropriate workflows.
See Yojika’s billing and bookkeeping features, or download Yojika to try the statement workflow. The physical count and explanation of differences remain part of your closing routine.
FAQ
How do I calculate expected closing cash?
Start with counted opening cash, add money physically received, and subtract money physically paid out or removed. Compare that expected amount with the notes and coins counted at the same closing time.
Should UPI receipts be included in my cash drawer count?
No. UPI receipts belong in your digital-payment checks, even when the sale appears in the same sales report. For a split payment, only the cash portion affects the drawer.
What should I do when closing cash is short?
Recount, then check payment methods, change given, refunds, expenses and withdrawals against their records. Keep an unexplained difference visible; do not invent a sale or expense to make the totals agree.
Can I compare one drawer with Yojika’s entire Cash account?
Only if that account represents exactly the cash in that drawer. If it also includes a safe or petty-cash box, count those holdings too or prepare a separate drawer reconciliation.