Five years ago, most kirana stores and small retailers dealt with two payment modes: cash and maybe a bank transfer. Today, a single counter might accept cash, UPI (via multiple apps), a card swipe terminal, and an occasional wallet payment. Each mode settles differently, at different times, with different deductions. Reconciling this daily is the single biggest accounting headache for small Indian businesses in 2026.
Why reconciliation is harder with digital payments
With cash, reconciliation is simple: count the drawer, match it to the day's bills. With digital payments, there are time lags and deductions:
-
UPI settlements typically arrive in your bank account the next business day, though some PSPs settle same-day for a fee. The settlement amount matches the transaction — UPI does not currently charge merchants under the MDR waiver (valid through March 2025 and extended since).
-
Card payments settle in T+1 to T+3 days depending on your acquirer bank. The settlement amount is the transaction value minus the MDR (Merchant Discount Rate), typically 0.4%–1.8% depending on card type and transaction size.
-
Wallet payments (Paytm Wallet, Amazon Pay, etc.) have their own settlement cycles and fee structures, and the rates are not always transparent upfront.
-
Cash is immediate but requires physical counting and has shrinkage risk.
The result: on any given day, the money in your bank account does not match the sales your POS recorded. This gap is normal but must be tracked.
The reconciliation problem, concretely
Consider a retailer who does ₹80,000 in sales on a Monday:
| Mode | Sales value | When it settles | What lands in bank | |---|---|---|---| | Cash | ₹22,000 | Same day (deposited) | ₹22,000 | | UPI (PhonePe, GPay) | ₹35,000 | Tuesday | ₹35,000 (no MDR) | | Card (Visa/MC) | ₹18,000 | Wednesday–Thursday | ₹17,730 (after 1.5% MDR) | | Paytm Wallet | ₹5,000 | Tuesday–Wednesday | ₹4,900 (after 2% fee) |
Total sales: ₹80,000. Total bank receipts over the next few days: ₹79,630. The ₹370 difference is merchant fees — a legitimate business expense, but one that needs to be accounted for, not left as a mysterious shortfall.
Now multiply this by 30 days, add refunds, chargebacks, and the occasional settlement error from the payment processor, and you see why reconciliation breaks.
A practical reconciliation workflow
Step 1: Record sales by payment mode at the point of sale
Your billing software should capture the payment mode for every transaction — not just "paid" but "paid via UPI" or "paid via card." This is the source-of-truth layer. Without this, reconciliation is guesswork.
Step 2: Get settlement reports from each payment processor
Every payment aggregator — Razorpay, Pine Labs, Paytm for Business, BharatPe, PhonePe Business — provides settlement reports, usually downloadable as CSV or Excel. These reports show:
- Transaction ID
- Settlement date
- Gross amount
- Fee/MDR deducted
- Net amount settled
- UTR (bank reference number)
Download these daily or set up automated email delivery if your processor supports it.
Step 3: Match settlements to sales
For each settlement entry, match it back to the original sale in your POS. The matching key is usually the transaction reference ID. A well-designed system does this automatically; most small businesses do it in Excel, which works until it doesn't.
Step 4: Account for fees as expenses
The MDR or platform fee deducted from card and wallet settlements is a business expense. Book it under "Payment Processing Charges" or "Bank Charges" in your ledger. This is deductible for income tax purposes, so tracking it properly saves you money at filing time.
Step 5: Flag and investigate mismatches
Common mismatches and their causes:
- Settlement amount lower than expected: Refund processed by payment gateway that you haven't recorded in POS
- Settlement missing entirely: Transaction failed on the bank side but showed "success" on POS — customer didn't actually pay
- Duplicate settlement: Rare, but it happens — you owe the customer a refund
- Amount mismatch: GST on MDR (if applicable), or a promotional discount applied by the payment app
Investigate and resolve these within the same week. Letting mismatches accumulate turns a 10-minute daily task into a multi-day monthly headache.
The GST angle
Under current rules, MDR on UPI transactions is zero (no GST implications). For card transactions, the MDR is a service provided by the acquiring bank — they issue a tax invoice, and you can claim ITC on the GST component of the MDR if you are a registered taxpayer. Not many small businesses do this, but for a retailer paying ₹15,000–₹20,000 per month in card MDR, the GST credit is worth recovering.
What to look for in your software
If your POS or accounting software does not support multi-mode payment tracking and settlement reconciliation, you will always be reconciling in spreadsheets. Key capabilities to evaluate:
- Payment mode capture at billing: every invoice records how the customer paid
- Settlement import: ability to upload or auto-fetch settlement files from payment processors
- Auto-matching: system matches settlements to invoices by transaction reference
- Fee tracking: MDR and platform fees are automatically calculated and posted to the correct expense ledger
- Mismatch dashboard: a clear view of unsettled transactions, partially settled amounts, and flagged discrepancies
- Bank statement reconciliation: settlements should ultimately reconcile against your bank statement entries
The goal is to get to a point where daily reconciliation takes five minutes of review, not an hour of data entry.
A note on QR code payments
Many small businesses use a personal UPI QR code (linked to their personal bank account) for customer payments. This works for convenience but creates an accounting nightmare: business income lands in a personal account, making it invisible to your business books. If you accept UPI, use a business account with a business QR code. Every major bank and payment app offers this, usually at no cost.