A daily cash-closing routine for a kirana shop
Daily cash closing means proving how the opening cash became the closing cash. It is not simply counting the drawer. A proper close separates cash sales, UPI sales, udhar, payments received, expenses, supplier payments and owner withdrawals. Ten disciplined minutes each evening can reveal an entry mistake while the day is still easy to remember.
Use the same routine even on a quiet day. Skipping low-sales days creates gaps that later make weekly totals unreliable. The goal is not a perfect report for an accountant; it is a clear explanation for every rupee moving through the counter.
Start with an opening cash figure
Record the cash physically available when the business opens. This is the change float plus any cash intentionally carried forward, not the bank balance or yesterday’s sales total. Count notes and coins. If the owner adds ₹2,000 from personal money to make change, record it as owner funds introduced rather than sales.
Keep the opening amount stable where practical. A regular float of ₹3,000 makes unusual differences easier to notice. If the previous close ended with ₹8,400 and you removed ₹5,400 for safe keeping, today should open with ₹3,000. Both the removal and the opening figure need records.
Do not assume the morning cashier received the amount that the evening cashier remembers. A shift handover should count and sign or confirm the cash.
Record each type of activity separately
Cash sales increase the drawer. UPI sales increase a digital account and should not increase expected cash. Udhar sales create a customer balance but bring in no cash today. A cash payment against old udhar increases the drawer, while a UPI payment increases the bank or wallet balance.
Cash expenses reduce the drawer. UPI expenses reduce the digital account. Supplier payments need the same distinction. Owner withdrawals, staff advances and cash moved to a bank deposit are not shop expenses unless they genuinely represent a business cost.
During the day, use clear payment-mode choices. An entry marked cash when the customer paid by UPI creates two differences at close: expected cash is too high and expected UPI is too low.
Calculate expected closing cash
Use this formula:
Opening cash + cash sales + cash udhar collections + other cash received − cash expenses − cash supplier payments − owner withdrawals − cash deposited = expected closing cash.
Then count physical cash and compare. Do not include UPI sales or fresh udhar sales in this calculation.
Keep tender effects in mind. If a customer gives ₹500 for a ₹463 bill and receives ₹37 change, the cash sale is ₹463. The drawer rises by ₹463, not ₹500. Modern billing normally records the net sale, but rushed manual notes can capture the tender incorrectly.
Worked example: finding a ₹300 difference
A kirana shop opens with ₹3,000. During the day it records:
- Cash sales: ₹12,450
- UPI sales: ₹8,100
- New udhar sales: ₹2,300
- Cash collected from old udhar: ₹1,500
- UPI collected from old udhar: ₹900
- Cash expenses: ₹650
- Cash paid to a supplier: ₹4,000
- Owner cash withdrawal: ₹2,000
Expected cash is:
₹3,000 + ₹12,450 + ₹1,500 − ₹650 − ₹4,000 − ₹2,000 = ₹10,300.
The physical count is ₹10,000, so cash is short by ₹300. The owner reviews events while they are fresh. A ₹300 staff tea-and-transport payment was made in cash but recorded as UPI. Correcting the payment mode reduces expected cash to ₹10,000 and removes the difference. No fake “cash adjustment” is needed.
UPI is checked separately: ₹8,100 sales + ₹900 old-udhar payment − any UPI expenses. Bank notifications are useful evidence, but the actual transaction list is more reliable than screenshots.
Investigate differences in a fixed order
When cash differs, do not immediately blame theft or add a balancing entry. Check:
- Was opening cash counted correctly?
- Is any sale recorded under the wrong payment mode?
- Was an expense or supplier payment omitted?
- Was change calculated or entered incorrectly?
- Was cash collected from udhar left unrecorded?
- Did the owner or staff remove cash without an entry?
- Was cash moved to another drawer, safe or bank deposit?
- Is a duplicate or cancelled sale still included?
Count physical cash again by denomination. Compare large bills and unusual transactions. If the difference remains, record it transparently as a cash shortage or overage according to your accounting practice, with a note and reviewer. Never alter a real sale to force the total.
Track repeated small differences. A ₹20 shortage every day becomes ₹600 in a month and may indicate change handling or unrecorded petty expenses.
Close UPI and bank activity too
Compare the day’s UPI entries with the merchant or bank transaction list. Match amount, time and status. “Payment processing” or a customer screenshot is not the same as settled money. Watch for reversed or failed transactions.
If multiple QR codes or bank accounts are used, close each one separately. Staff may confirm a payment in one phone while the business report expects another account. Name accounts clearly in the ledger.
UPI fees or settlement adjustments should be recorded according to the provider statement. Do not reduce a sale silently because the settled amount differs; record the sale and the fee separately where appropriate.
Review udhar and expenses before locking the day
Check that every credit sale has a customer and that every old-balance payment reduced the correct customer. An unassigned udhar entry is a future loss because no one knows whom to collect from. Confirm unusually large expenses, refunds or discounts.
Review owner withdrawals separately. Household cash taken from the drawer is not rent, transport or purchase expense. Misclassifying it makes profit appear lower and hides how much the owner is drawing.
Once the day is reviewed, record the actual close, difference if any, reviewer and time. Carry only the approved float to the next day. Move excess cash using a recorded safe or bank transfer.
Make the routine workable for staff
Use a one-page checklist near the counter. Assign responsibility for the opening count, transaction entry and closing review. If shifts change, close the first shift before handing over. Restrict deletion of final entries and require a note for corrections.
The process should be quick enough to follow every day. A complicated spreadsheet that nobody completes is weaker than a six-line routine completed consistently. Start with cash, UPI, udhar, expenses, withdrawals and difference; add detail only when the business needs it.
Practical takeaway
Every evening, count cash, compute expected cash, compare UPI transactions, verify udhar customers, review expenses and record any difference with a reason. Never include UPI or fresh credit sales in expected physical cash. Investigate before posting an adjustment.
Use today’s actual numbers to run the worked formula. If the difference is not zero, follow the fixed investigation order while staff still remember the day. Then connect the routine to UPI and cash reconciliation and separating household money so the closing figure remains meaningful after cash leaves the shop.