When UPI sales made on Sunday reach your bank on Monday, the sale and the credit belong to two different dates. Record both in your sales sheet: the sale date for what you sold, and the credit date for when the money arrived. Then Sunday's UPI sales never look missing, and you can see at a glance what is still on its way.
Why do day-end totals look wrong after a weekend?
If you compare Sunday's UPI total with Sunday's bank credits, they will not match when your provider settles later. The same thing happens before a bank holiday. Nothing is lost; the money is in transit. The mistake is using one date column for two different facts.
How quickly money reaches you depends on your provider and your arrangement, so ask them for their settlement timing and write it down. The example below is made up.
A made-up weekend with a holiday
Say Saturday's UPI sales were ₹11,400 and Sunday's ₹15,250. Monday is a bank holiday, with ₹9,800 of UPI sales. The provider sends Saturday's and Sunday's money together on Tuesday, and Monday's on Wednesday.
| Sale date | UPI sales | Credit date | Credit amount | Still to arrive |
|---|---|---|---|---|
| Saturday | ₹11,400 | Tuesday | ₹26,650 (with Sunday) | Nothing |
| Sunday | ₹15,250 | Tuesday | Included above | Nothing |
| Monday (holiday) | ₹9,800 | Wednesday | ₹9,800 | Nothing |
Check: 11,400 plus 15,250 is 26,650. On Sunday night, the sheet shows ₹26,650 sold and nothing credited. On Monday night, ₹36,450 sold and nothing credited. On Tuesday night, ₹36,450 sold and ₹26,650 credited, so ₹9,800 is in transit. By Wednesday the gap is zero.
How do I set up the sheet?
Use two small blocks on the same sheet, or two tabs.
- Sales block: A is the sale date, B is the UPI sales for that day taken from your app or soundbox history.
- Credits block: C is the credit date (from the bank statement), D is the amount credited, E is a note such as covers Saturday and Sunday.
- Put a check date in a cell, say G1, where you enter the date you are checking as of.
- In G2, the in-transit amount: =SUMIFS($B$2:$B$200,$A$2:$A$200,"<="&$G$1)-SUMIFS($D$2:$D$200,$C$2:$C$200,"<="&$G$1)
That formula adds all UPI sales dated up to your check date and takes away all credits dated up to the same date. The remainder is money sold but not yet credited. If your provider deducts any charge, the credited amount will be lower than sales, so keep a separate column for charges deducted and compare after adding it back.
What should I do on the day itself?
- At closing, enter the day's UPI total from the app history under the sale date.
- Next morning, open the bank statement and enter any credit under its credit date, noting which sale dates it covers.
- Check the in-transit figure. It should be roughly the sales of the last day or two, based on your provider's timing.
- If it keeps growing, or a day's sales never show up as credited, move to the trace steps and raise it with your provider.
What about the weekly total?
For a week that ends on Sunday, the sales are right, but credits will lag by a day or two. Either accept that the last day or two of every week will be in transit, or choose a check date a couple of days after the week-end for the bank side. Many shops simply report sales by sale date and credits by credit date and show the in-transit line between them.
Quick end-of-week checks
- Sales by sale date add up to the week's total in the day sheets.
- Every credit in the bank statement is matched to at least one sale date.
- In-transit is within what your provider's timing says it should be.
- Any credit with no matching sale goes on a query list.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
