To find where a bonus went, list every debit since the credit date, group them by category and sort by size. You will usually see two or three large lines and a long tail of small payments. Do not blame small spending until you have separated bills you were always going to pay, such as a card bill, from fresh spending.
Step by step: trace it
- Note the credit date and amount.
- Download your bank statement and your card statement from that date to today, using the custom date option in your own bank's statement section.
- Put all debit rows into one sheet: date, description, amount, account.
- Give each row a category. Start with the biggest rows; small ones can be grouped later.
- Total each category and sort from largest to smallest.
- Compare the grand total with the bonus.
Do not count a card bill as new spending
A credit card bill payment is not a purchase; it settles purchases from earlier weeks. If you paid ₹21,000 on a card bill from the bonus, the money went to spending that took place before the bonus arrived. Treat it as its own category, and look at the card statement for the actual items. Counting both the bill payment and the card purchases would show the same rupee twice.
A made-up trace
Say a bonus of ₹60,000 was credited on the 8th. By the 15th the debits were as follows.
| Category | Amount | Was it planned? |
|---|---|---|
| Credit card bill payment | ₹21,000 | Settles earlier purchases |
| Overdue dues cleared | ₹6,500 | Yes |
| Festival shopping | ₹11,800 | Partly |
| Travel booking | ₹9,500 | Yes |
| Gifts | ₹4,200 | Yes |
| Food delivery and dining | ₹3,000 | No |
| Small UPI payments | ₹2,600 | No |
| Total | ₹58,600 | Leaves ₹1,400 |
Check the sum: 21,000 + 6,500 + 11,800 + 9,500 + 4,200 + 3,000 + 2,600 = 58,600. The bonus of ₹60,000 minus ₹58,600 leaves ₹1,400. The largest leak is not the small stuff but the shopping, and the half-planned part of it is worth a question.
A pivot table in Excel or Google Sheets does the grouping fast, but a plain formula works too. With categories in column B and amounts in column C, =SUMIFS($C$2:$C$200,$B$2:$B$200,"Shopping") gives the shopping total. Repeat it for each category and sort the totals from largest to smallest.
Which lines should you question?
- Anything over a few thousand rupees that you did not plan, such as a sale purchase
- Payments made because you now had the money, not because the item was needed
- Several orders from the same app in a few days
- Money lent or sent to someone with no record kept
- Bills paid early that could have waited for the due date
What are the usual leaks?
- Bills and dues that had been waiting for the money
- Big-ticket festival shopping and sale purchases
- Travel and booking payments made in a rush
- Lending to friends or family that is not recorded
- Many small UPI payments that add up quietly
Using an app for the trace
If your statements are imported into SpendixAI with the right account chosen, you can filter by the date range since the credit and read the spending by category, and the possible-duplicate-charges report can catch the same amount paid twice to one merchant within two days. Check each category yourself; an unusual merchant may be labelled wrongly.
What to do with what you learn
Pick the single largest avoidable line and decide what you would do differently, such as setting a shopping cap for next festival month. A trace is useful only if the next bonus gets a plan.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

