To match UPI collections to your daily sales, put the UPI total from your sales sheet next to the total from the UPI credit report for the same day, work out the difference, and explain each non-zero difference as a late settlement, a refund or a wrong amount. Whatever you cannot explain goes into a leftovers list so it does not vanish into next week's numbers.
What are the two figures I am comparing?
The first is what your own sales sheet says was collected by UPI that day, usually taken from the QR provider's app or from your till tally. The second is what actually arrived, taken from the QR provider's credit report or your bank statement. Settlement timing depends on your provider and bank, so check how yours works before treating a one-day lag as an error.
Example: a week at a sweet shop
Say a sweet shop notes its UPI sales each evening and compares them with the credit report. Difference means report minus sheet.
| Day | Sheet UPI | Credit report | Difference | Reason |
|---|---|---|---|---|
| Monday | ₹8,400 | ₹8,400 | ₹0 | Matches |
| Tuesday | ₹6,250 | ₹6,250 | ₹0 | Matches |
| Wednesday | ₹7,100 | ₹6,600 | −₹500 | One payment settled late |
| Thursday | ₹5,900 | ₹6,400 | +₹500 | Wednesday's late payment arrived |
| Friday | ₹9,300 | ₹9,300 | ₹0 | Matches |
| Saturday | ₹14,800 | ₹14,350 | −₹450 | Refund for a returned box |
| Sunday | ₹11,200 | ₹11,200 | ₹0 | Matches |
The week's sheet total is ₹62,950 and the report total is ₹62,500. The gap of ₹450 is the Saturday refund. Wednesday and Thursday cancel each other, so the late settlement left no lasting gap.
How do I find the reason for a difference?
- Look for the same amount on the next day's report. A match means a late settlement.
- Look for a refund or reversal line on the report on that day.
- Compare individual payments, not just totals, if the difference is not a round number. A typed-in wrong amount often shows as a small odd figure.
- Check whether a customer paid twice and you refunded one.
Which formulas make this faster?
In Excel or Google Sheets, put the sheet figure in column B, the report figure in column C and the difference in D.
- Daily difference in D2: =C2-B2
- Week total difference: =SUM($C$2:$C$8)-SUM($B$2:$B$8)
- Flag days that need a look in E2: =IF(D2=0,"OK","Check")
What goes in the leftovers list?
Anything unexplained after a week: date, amount, what you checked, and your guess. Review that list every Sunday. Items that stay on it for more than a couple of weeks deserve a message to your QR provider or bank, using their official support route. A leftover that is never written down tends to turn into a habit of ignoring small gaps.
A few shops also take UPI payments in the evening after the shutter is down, such as a customer paying for tomorrow's order. Decide a cut-off time and keep to it, so that a payment is counted on one day only and does not appear in two days' sheets.
Is it worth doing daily?
Daily takes five minutes and keeps the cause fresh. Weekly is workable if the shop is small and the differences are rare. During festival weeks, when Saturday numbers are several times larger than usual, it is worth doing daily again.
Where does an app help?
When you upload your bank statement to SpendixAI, the UPI credits arrive as rows you review before saving, so the report side of this comparison is already on screen. The daily sales sheet remains yours, because the app does not read SMS or import statements from UPI apps.
A closing checklist
- One line per day on each side.
- Differences are explained within a day or two.
- Leftovers are written down, not rounded away.
- Refunds appear in both places.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

