You do not need software to match a handful of bills to your bank entries. As a student with a monthly pocket money or stipend, you probably have fifteen to thirty small entries, and the quickest way to match them is to sort both lists by amount and read them side by side. Here is how to make that nearly automatic.
Why sorting by amount works so well
Small shops, photocopy counters and canteens produce repeating amounts like ₹20, ₹49 and ₹249. If you sort by date alone, these blur together. If you sort by amount, identical figures sit next to each other and the date or time on the bill separates them in seconds.
The method in five steps
- Copy your statement entries for the month into one sheet: date, narration, amount.
- List your bills in another sheet: date, shop, amount.
- Sort both sheets by amount, smallest to largest.
- Walk down the two lists together and tick the rows that agree on amount and date.
- Mark whatever is left over on each side: entries without a bill and bills without an entry.
If your sheet app supports it, add a column of ticks using a formula such as =IF(COUNTIFS(Bills!$C$2:$C$200, C2)>0, "bill exists", "no bill") on the statement sheet, which tells you whether any bill carries that amount. It does not check the date, so use it only as a first sweep.
A worked example with made-up entries
Say your monthly allowance is ₹6,000, and the week shows these entries.
| Date | Statement entry | Bill found |
|---|---|---|
| 3 Nov | ₹249 canteen | Yes |
| 3 Nov | ₹249 print shop | Yes |
| 5 Nov | ₹60 stationery | No |
| 7 Nov | ₹899 book | Yes |
| 8 Nov | ₹249 canteen | No |
Sorted by amount, the three ₹249 entries sit together. Two have bills with times printed on them, so you separate the canteen and the print shop. The third ₹249 on 8 November has no bill. The week's total across all five entries is 249 plus 249 plus 60 plus 899 plus 249, which comes to ₹1,706, roughly a quarter of the ₹6,000. Two unmatched entries out of five is normal for small spends and does not need alarm.
What if the bill is smaller than the entry?
That is a clue, not an error. A canteen may add a service charge; a shop may round up; or you may have paid for a friend. Write the difference beside the entry. If you paid for a friend, note who owes you, even if you do not plan to ask.
Should I keep every tiny bill?
Not necessarily. Keep bills for things with a warranty, for anything someone else reimbursed, and for anything you may need to explain to your family or a scholarship office. For tea and photocopies, a bill is rarely needed; the statement entry plus a short note is enough.
Using an app when you are ready
SpendixAI has a free plan where you can upload statements as PDF, CSV or Excel, review rows before saving and add cash expenses by hand. Receipts stay with their transactions. It does not connect to your bank, never asks for net-banking logins, and does not read SMS. It will not decide which bill goes with which entry, so the sorting skill above still applies.
Mistakes to avoid
The commonest error is matching on amount alone and ignoring the date, which pairs a canteen bill from the first week with an entry from the last. The second is deleting a bill as soon as you tick it, leaving no way to check later. Keep the photos until the month is closed and you have compared your totals with the statement.
A quick checklist before the month ends
- Sort both lists by amount and tick the rows that agree.
- Write a note beside every entry with no bill.
- Add cash spends by hand.
- Total the month and compare it with your pocket money.
- Move warranty bills into their own folder.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


