Take the list you wrote before the sale, pull the sale-period lines from your card or bank statement, and match each line to a list item. Anything you cannot match is unplanned, and the total of those lines plus any overspend on listed items is your gap. The whole exercise takes about twenty minutes and tells you more than a vague feeling that the sale cost too much.
Which three things do I need on the table?
- The planned list, with a ceiling price for each item and a total ceiling.
- The actual purchases, copied from the statement with date, shop and amount. Use the statement, not memory, because orders placed on different days are paid and delivered on different days.
- A tag column with three values: Planned, Swapped (you bought something else in the same role) and Unplanned.
Add delivery or convenience fees as part of the item they belong to. If an order was cancelled or returned, subtract the refund so that the number reflects what stayed in the house.
What does a worked example look like?
Say the planned list had five items with a total ceiling of ₹10,000, and you bought four of them. These numbers are made up.
| Purchase | Tag | Ceiling | Paid | Difference |
|---|---|---|---|---|
| Running shoes | Planned | ₹3,500 | ₹3,200 | ₹300 under |
| Bedsheet set | Planned | ₹1,500 | ₹1,350 | ₹150 under |
| School bag | Planned | ₹1,800 | ₹1,700 | ₹100 under |
| Earphones | Planned | ₹2,500 | ₹2,800 | ₹300 over |
| Smartwatch | Unplanned | none | ₹4,200 | ₹4,200 over |
| Kitchen organiser | Unplanned | none | ₹900 | ₹900 over |
| Phone cover | Unplanned | none | ₹399 | ₹399 over |
The four planned items cost ₹9,050 against ceilings of ₹9,300, so you stayed ₹250 under on them. The unplanned lines total ₹5,499 (4,200 plus 900 plus 399). Altogether you spent ₹14,549 against a list ceiling of ₹10,000, a gap of ₹4,549. The tablet cover on the list, ceiling ₹700, was never bought, which is a small win worth noting.
How do I total the unplanned buys in a sheet?
If the Paid amounts are in C2 to C20 and the tags are in B2 to B20, this formula adds up everything marked Unplanned: =SUMIF($B$2:$B$20,"Unplanned",$C$2:$C$20). Change the word in quotes to get the Planned or Swapped total. The same formula works in Excel and Google Sheets.
For the gap, put the total ceiling in a cell and subtract it from =SUM($C$2:$C$20). A positive number is overspend, a negative number is money you did not use.
Why do some lines go missing?
Statement lines trail the order. A card may post a purchase a few days after the day you placed it, so a sale that ended on the 25th can have lines dated the 28th. Extend your date range by a week, and watch for refunds that arrive later. If a line looks wrong, open the order history in the shopping app and match the amount.
Can a tracker do the sorting?
It can do the dull part. In SpendixAI you can upload the card statement, review the rows before saving, then filter the sale dates with the Report builder and download a CSV to tag in your sheet. The Planned or Unplanned tag is still your call, because only you know what was on the list.
What to decide after the comparison
- Write the three biggest unplanned items and what pulled you towards them.
- Decide whether any of them should be returned within the shop's window.
- Adjust next year's total ceiling up or down based on this one.
- Keep this comparison next to the next list so you can see whether the gap is shrinking.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

