When the app's UPI total for the day differs from your sheet, check five things in this order: the time cut-off, refunds and reversals, personal payments on the same QR, duplicate entries, and the difference between transaction date and settlement date. The cause is almost always a timing or recording slip, not a missing payment.
A made-up difference of ₹480
Say your sheet shows ₹12,350 of UPI sales for Wednesday, and the app shows ₹12,830. The app is ₹480 higher. Work out which way the difference runs before you start. App higher means some money came in that the sheet missed. App lower would mean the sheet has UPI sales the app does not.
Check 1: the time cut-off
The app counts from midnight to midnight, or whatever its report window is, while your sheet may close at 9 pm. A late sale at 9:55 pm belongs to Wednesday in the app and Thursday morning in your book. Open the app's list for the day and look at the last entries.
In our example, a ₹300 payment came in at 9:55 pm after the sheet was closed. Difference left: 480 minus 300 is ₹180.
Check 2: refunds and reversals
A refund you paid out, or a payment that was reversed, lowers the app's net figure, while the sheet may still show the original sale. If the app list has negative entries or reversed status, match each to a bill. In this example, there are none.
Check 3: payments that are not sales
A customer clearing an old credit balance, a friend returning money, or a supplier's refund can arrive on the shop QR and be counted by the app, but would not be in the day's sales. Look for payments with no bill. Here, ₹180 turns out to be a customer paying off an earlier credit, which you recorded in the credit book. That clears the rest: 300 plus 180 is 480.
Check 4: is the same payment counted twice?
Look for the same amount twice within a minute or two. It may be two genuine sales, or one bill written twice in your sheet. Compare against your bill numbers. A genuine repeat will have two bills. A written-twice entry will have one.
Check 5: transaction date versus settlement date
Some reports are by the date money was settled to the bank, not the date of the sale. If you are comparing a settlement report with a sale-date sheet, you will see differences whenever settlement lags. Check which date your report uses, as shown in its column heading or help page.
- List the app's entries for the day in time order.
- Tick each against a bill in your sheet.
- Any entry with no bill goes into one of three piles: late sale, not a sale, or missed entry.
- Any bill with no entry goes into: paid in cash, paid by another route, or paid but not credited yet.
- Write the cause next to each unmatched item, and the new total once the reasons are applied.
Can a formula do the matching for me?
If you copy the app's list into one sheet, with reference numbers in column A, and your sheet's UPI entries with reference numbers in column E, then in the app list add =IF(COUNTIF($E$2:$E$200,A2)=0,"Not in my sheet",""). Every row marked Not in my sheet is a payment to look at. This works in both Excel and Google Sheets, as long as you wrote the reference number into your sheet at the time of the sale.
When should I ask the provider?
If you have checked all five and still have an unexplained difference, note the date, amount and reference numbers and ask your provider's official support. Keep the difference on an open-items list until it is closed.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


