Shopping

UPI cashback status sheet: pending, credited and expired

A UPI cashback pending tracker sheet with columns for offer, payment date, promised amount, status and follow-up date, plus colour rules and expired counts.

Editorial illustration for UPI cashback status sheet: pending, credited and expired

A UPI cashback status sheet needs five columns: the offer, the payment date, the promised amount, a status (pending, credited or expired) and a follow-up date. Colour the rows by status so pending ones stand out, and count expired offers separately instead of deleting them. Then you can see at a glance what was promised, what arrived and what you are still waiting for.

How should the sheet be laid out?

  • Column A, Offer: a short name such as 'recharge offer'.
  • Column B, Payment date.
  • Column C, Promised amount, in rupees.
  • Column D, Status: Pending, Credited or Expired.
  • Column E, Follow-up date: when you will check again.

Use a dropdown for the status column so you do not mix 'credited' with 'Credited'. In Google Sheets and Excel, data validation lets you restrict the cell to a list of the three words.

What does a filled-in sheet look like?

OfferPayment datePromisedStatusFollow-up
Grocery offer4 Mar₹20CreditedDone
Recharge offer6 Mar₹15CreditedDone
Bill pay offer9 Mar₹50Pending23 Mar
Food offer12 Mar₹40ExpiredClosed
Fuel offer15 Mar₹30CreditedDone
Shop offer20 Mar₹10Pending3 Apr

How do you colour pending and credited rows?

Select the rows and add a conditional formatting rule that uses a custom formula. For a green fill when credited, the formula is =$D2="Credited". For amber on pending, =$D2="Pending". To flag follow-ups that are overdue, use =AND($D2="Pending",$E2<TODAY()) with a red fill. This last rule needs the follow-up cells to hold real dates, not text. Both Excel and Google Sheets accept these formulas.

How do you total the sheet?

  • Credited: =SUMIFS($C$2:$C$200,$D$2:$D$200,"Credited") gives ₹65 here.
  • Pending: =SUMIFS($C$2:$C$200,$D$2:$D$200,"Pending") gives ₹60.
  • Expired: =SUMIFS($C$2:$C$200,$D$2:$D$200,"Expired") gives ₹40.
  • Offers count: =COUNTIF($D$2:$D$200,"Expired") gives 1.

The three amounts add up to the ₹165 promised. Only ₹65 has actually arrived, which is roughly 39 paise of every rupee promised in this invented sheet.

How do you count expired offers honestly?

An offer expires when its window passes without a credit, or when the terms were not met. Do not delete it, and do not leave it as pending forever. Change the status to Expired and keep the promised amount in the sheet. Your 'received versus promised' ratio is the honest measure of how reliable these offers are. If you remove the expired ones, every offer looks like it paid out.

What should you do when a row stays pending?

On the follow-up date, look at the app's reward or offer history first, then your bank statement. If it is still missing, contact support with the payment date, the amount and the UPI transaction ID from the payment receipt. Keep that ID in a notes column on the row, since support teams commonly ask for it. Write down any reference number they give you, then set a new follow-up date.

Freeze the header row so the column names stay visible, and sort by follow-up date once a week so the oldest pending offers rise to the top.

When should you move beyond a sheet?

A sheet is plenty for this. The payments themselves live in your bank statement, which SpendixAI can import with a review step before saving, and the credited cashback can be entered as a small credit by hand. Keep the status sheet only for what is still pending.

A weekly five-minute check

  1. Sort by status and look at the pending rows.
  2. Check your account for credits that match them.
  3. Mark any matched rows as Credited.
  4. Mark any offer past its window as Expired.
  5. Reset follow-up dates for what is still pending.
SPENDIXAI JOURNAL

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

Explore your reports