Write a UPI refund in the day's sales sheet as a negative UPI line, on the day the refund was paid, with the original bill number and the reason. It is not a cash expense, because the money left your bank account, not your drawer. That way the UPI total in your sheet matches what the app and bank actually show.
Why a negative UPI line and not an expense?
A refund undoes part of a sale. If you note it as an expense, your sales stay overstated, and if you note it under cash, your drawer will look short by an amount it never held. Put it in the same mode the money moved in. A UPI refund reduces the UPI line, a cash refund reduces the cash line.
A made-up return, step by step
Say bill number 1432 was a shirt for ₹799, paid by UPI on Monday. The customer returns it on Tuesday, and you refund ₹799 by UPI. On Tuesday, UPI sales were ₹9,300 before the refund.
- On Tuesday's sheet, under UPI, write the day's sales: ₹9,300.
- Add a refund line in the UPI column: minus ₹799, with the note bill 1432, original date Monday, size did not fit.
- The net UPI figure for Tuesday is 9,300 minus 799, which is ₹8,501.
- Put the refund's UPI reference number in the note, so you can find it in the app history.
Monday's sheet is left as it was. The sale happened on Monday, the refund on Tuesday, and the two lines are tied by the bill number.
What should a refund record contain?
| Field | Example | Why it matters |
|---|---|---|
| Refund date | Tuesday | The day the money went out |
| Original bill and date | Bill 1432, Monday | Ties the refund to a real sale |
| Mode | UPI | Reduces the UPI line, not cash |
| Amount | ₹799 | Full or part refund |
| Reason | Size did not fit | Shows patterns later |
| UPI reference | From the app history | Lets you prove it was paid |
| Approved by | Owner or manager | Stops casual refunds |
Can I refund to a different number or in cash?
The safest habit is to return the money by the same route and to the same account it came from. A customer who asks you to send the refund to someone else's number, or to give cash for a UPI payment, is asking you to break the trail. Your own policy may allow exceptions, but write each one down with a reason. If cash is given for a UPI sale, record it as a cash refund and mention the original UPI sale.
What about partial returns and exchanges?
- Part refund: record only the amount paid back. A ₹1,200 bill with one ₹300 item returned is a minus ₹300 line.
- Exchange at the same price: no money moves, so note it in remarks but make no sheet entry. If your sheet tracks items, record the swap there.
- Exchange at a higher price: the extra amount paid is a new sale in the mode used.
- Exchange at a lower price: refund only the difference, in the way the customer paid.
Check the week's refunds
Once a week, add up the refund lines. A formula such as =SUMIFS($E$2:$E$500,$C$2:$C$500,"Refund",$D$2:$D$500,"UPI") totals the UPI refunds if E has amounts, C the line type and D the mode. Compare the total with refunds in the app history for the same dates. If the two differ, look for a refund paid from your own phone that you did not note, or one noted twice.
If many refunds cluster around one product or one staff member, that is worth a gentle look. It often points to a sizing, quality or billing problem rather than a bookkeeping one.
Closing checklist
- Refund line is negative and under the mode the money actually used.
- Original bill number and date are written.
- Reason and approver are written.
- UPI reference is noted.
- Week's refunds match the app or bank history.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
