Tax and GST

A customer refund: recording it so sales and bank agree

How to record a customer refund so sales and bank agree: link it to the original sale, note the mode and date, and avoid double counting, with a UPI example.

Editorial illustration for A customer refund: recording it so sales and bank agree

Record a refund as its own entry that points back to the original sale, with the date, the amount and the mode of payment. Do not delete or edit the sale. When the sale stays, the refund sits beside it, and your sales total and your bank statement can both be explained line by line.

What goes wrong when refunds are not recorded properly?

Two things, mainly. If you quietly reduce the sale, your bank shows a payment out that your books cannot explain. If you record the refund but forget the original sale was already counted, sales and refunds both get counted once more than they should, and the two totals drift apart. Either way, the month-end reconciliation shows a gap you spend an hour hunting.

A worked example: an online order refunded by UPI

Say a customer orders two items on your shop's page, one at 1,299 rupees and one at 1,200 rupees, so the order is 2,499 rupees, paid by UPI on 6 March. On 12 March they return the 1,200 rupee item, and you refund that amount by UPI. The numbers here are only illustrative.

DateWhat happenedSales recordBank record
6 MarOrder 2,499 received by UPISale 2,499, order 1042Credit 2,499
12 MarItem returned, refund 1,200 by UPIRefund 1,200 linked to order 1042Debit 1,200
NetWhat the customer finally paid1,2991,299 net credit

Sale of 2,499 minus refund of 1,200 leaves 1,299, and the bank agrees: 2,499 credited and 1,200 debited. Both sides tell the same story without editing anything.

The steps to follow every time

  1. Find the original sale by order or invoice number and note that number on the refund.
  2. Write the refund date, amount and mode: UPI, bank transfer, cash or original payment method.
  3. Record the refund as a separate line, labelled as a refund or a sales return, not as an ordinary expense.
  4. Put the bank or UPI reference of the refund payment on the entry.
  5. Mark the returned item in stock, either back on the shelf or as damaged.
  6. At month end, check that sales minus refunds equals the net you expect.

What about a part refund, an exchange or store credit?

A part refund is the same as above with a smaller amount. An exchange where the customer pays a difference is a return and a new sale, so record the return and the new sale separately, then the top-up. Store credit is different, because no money moved: note it as a credit owed to the customer, and record the use of it when they buy something later.

What about GST and the invoice?

Whether the original invoice needs a credit note or any adjustment, and how that affects your tax return, depends on your registration and the facts. Do not guess. Write down the invoice number and the refund amount, and ask your CA how they want returns documented. The record you keep is what makes the answer quick.

Where a tracker fits

If you track expenses in SpendixAI, a refund you pay out appears as a debit on the statement you import, and you can check it against the row you reviewed before saving. It is not an invoicing or sales tool and does not issue credit notes, so keep the order number and the customer's name in your own sales sheet next to the bank reference.

A short monthly check for refunds

  • List every refund of the month with its original order number.
  • Check that each refund has a matching debit on the bank statement.
  • Check that no sale has been edited after the fact.
  • Look for customers who have been refunded more than once, and see why.
  • Send your CA the list if any refund crosses a month end or a financial year end.

Refunds that cross March into April deserve a note of their own, because the sale and the refund then fall in different financial years. Write both dates clearly and let your CA decide how to treat them.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports