When you use a wallet for canteen payments, recharges and small top-ups, a failed payment can show up in the export looking just like a successful one. If you total the sheet as it is, you will think you spent more than you did. Add a filter on the status column, check the total against your wallet balance, and the numbers will make sense again.
What does a failed row mean?
It means the payment did not go through, so the money should not have left your wallet. Sometimes an amount is shown as held for a short time and then returned. The export may still list the attempt, and if you tried again, the retry is a second row with the same amount.
Set up a filter in two minutes
- Open the export in Google Sheets or Excel.
- Click anywhere in the header row, then turn on Filter (Data then Create a filter in Sheets, Data then Filter in Excel).
- Open the drop-down on the status column and untick Failed and Pending.
- Look at the rows that remain and total the amount column.
In Sheets you can also see the sum of selected cells in the bottom corner. A formula is more reliable once you set it up: =SUMIFS($D$2:$D$300,$B$2:$B$300,"Payment",$C$2:$C$300,"Success") if type is in column B, status in C and amount in D.
Prove it with your wallet balance
A wallet is a small bank account, so you can test your sheet. Opening balance plus what came in, minus what went out, equals the closing balance. Say you started the month with ₹350 and your export shows:
| Type | Status | Amount in ₹ |
|---|---|---|
| Top-up | Success | 1,500 |
| Top-up | Failed | 500 |
| Payment | Success | 1,180 |
| Payment | Failed | 220 |
| Cashback | Success | 40 |
Only successful rows count. Money in is 1,500 + 40 = ₹1,540. Money out is ₹1,180. So the closing balance should be 350 + 1,540 - 1,180 = ₹710. If your wallet shows ₹710, the sheet is right. If you had counted the failed top-up and failed payment, you would have been off by ₹500 and ₹220.
What if the numbers still do not match?
- Look for Pending rows; they are neither in nor out yet
- Check the month boundary, since a payment late on the last day may land on the next day's date
- See whether the wallet balance in the app includes money held for a payment in progress
- Check whether you have two wallets or two accounts mixed into one file
Where does this fit in my pocket money tracking?
Wallet spending is only a part of your month. If you also pay by UPI from a bank account, track that on a separate tab so you are not mixing sources. SpendixAI has a free plan where you upload bank statements as PDF, CSV or Excel and check the rows before saving, so you can remove a failed row yourself. You choose the account before importing, and it does not read your SMS.
Should I keep the failed rows at all?
Yes, in the file, but not in the total. A failed row can be useful later: if a top-up failed and your balance still dropped, the row is your proof of when you tried. Mark the row grey or add a column called Counts with Yes or No, and leave the data where it is. Deleting rows feels tidy now and leaves you with no evidence when the money has not come back after a week.
If a failed payment did take money from your balance and has not been returned, note the date, the amount and any reference, and contact the wallet's support. A sheet row with those details makes that conversation much shorter.
Remember
- Filter out Failed and Pending before totalling
- Keep cashback and refunds in their own lines
- Test the total against your wallet balance
Useful ideas start with a clearer picture of your own spending.
Explore your reports

