Cards and UPI

Refund follow-up log: a template for pending refunds

A spreadsheet template to track pending refunds: columns for order, amount, promised date, reference and outcome, with formulas for overdue refunds and totals.

Editorial illustration for Refund follow-up log: a template for pending refunds

A refund follow-up log is a sheet with one row per pending refund and nine columns: order, order date, amount, promised date, reference, contact made, outcome, days overdue and status. Two formulas then show what is overdue and how much money is still owed to you.

Set up the columns

ColumnHeadingWhat to enter
AOrder or itemWhat you returned or cancelled
BOrder dateThe date of the original purchase
CAmount (₹)The amount you expect back
DPromised byThe date the seller or app promised
EReferenceReturn or ticket number
FContact madeDate and channel of your last follow-up
GOutcomeWhat they said
HDays overdueFormula
IStatusPending or Received

Format B and D as dates, and use only the words Pending and Received in column I. Consistent words let the formulas count correctly.

The formulas

In H2, days overdue, which stays blank once the refund is received:

  • =IF(I2="Received","",MAX(0,TODAY()-D2))

Reading it: if the status is Received, show nothing. Otherwise subtract the promised date from today, and show zero if the date is still ahead. Copy it down. Then, anywhere on the sheet, the total still owed to you:

  • =SUMIFS($C$2:$C$200,$I$2:$I$200,"Pending")

The amount that is pending and past its promised date:

  • =SUMIFS($C$2:$C$200,$I$2:$I$200,"Pending",$D$2:$D$200,"<"&TODAY())

And the number of overdue refunds:

  • =COUNTIFS($I$2:$I$200,"Pending",$D$2:$D$200,"<"&TODAY())

These work in Excel and in Google Sheets.

A sample of three rows

Order or itemAmount (₹)Promised byContact madeStatus
Running shoes2,89915-11-202617-11-2026, chatPending
Mixer grinder3,45020-11-2026None yetPending
Phone case39910-11-202612-11-2026, emailReceived

If the shoes and the grinder are pending, the total owed is 2,899 + 3,450 = ₹6,349. The phone case is received, so it is excluded. If today is after the 15th, the overdue amount is the shoes, ₹2,899.

How often should you follow up?

  • Check the sheet weekly, on a fixed day.
  • Follow up two days after the promised date, not before.
  • Write the date and channel in column F every time you contact someone.
  • If a second follow-up brings no reply, note that and use a different channel.

The sheet is also your proof. A line that says 17-11, chat, agent promised a callback is much stronger than a feeling that you asked.

Which refunds deserve a row?

Log anything above an amount you decide, say ₹200, and any refund where the seller gave a date beyond a few days. Small instant refunds do not need a row, and a log full of them becomes a chore you stop doing. The point is to catch the ones that can quietly disappear: expensive returns, cancelled bookings, and anything where an agent promised to call back.

For bookings, write the cancellation time and any cancellation fee separately, so the refund you expect is the amount after that fee and not the original price.

What belongs in a note about the outcome?

  1. What the seller said, in a short line.
  2. The name or ID of the person who replied, if shown.
  3. The new date promised, if it changed.
  4. What you plan to do next.

Can the same sheet track other money owed to you?

Yes, with a small change. Add a column for who owes it, so the same rows can hold a cancelled booking, a deposit waiting to be returned or an insurance reimbursement. Keep the Pending and Received wording, and the formulas keep working. Just keep personal loans to friends elsewhere, because the follow-up tone and the timing are different.

When a sheet is not enough

If you want the receipt, the return slip and the statement credit in one place, SpendixAI keeps receipts with their transactions, and a refund imported from a card statement appears as a credit you can categorise. A simple sheet like the one above is still a good way to start.

SPENDIXAI JOURNAL

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

Explore your reports