You can cut receipt matching from hours to minutes by sorting both lists by amount, matching exact amounts within a two or three day window, and leaving only the awkward ones for hand-checking. Auto-match features in software follow the same logic, so understanding the rules helps you trust, or correct, whatever any tool suggests.
What rules does a good match follow?
- Exact amount first. A receipt of ₹1,249 should pair with a ₹1,249 row.
- Date window next: the bank row posts on the purchase date or up to a few days later.
- Merchant name last. Statements shorten names, so use it to break ties, not as the first filter.
- One receipt, one row. Once a pair is made, remove both from the pile.
How do you do this in a spreadsheet?
Put the receipts on one sheet with date, merchant and amount, and the bank rows on another. In Excel or Google Sheets, add a helper column to the bank sheet that looks up each amount on the receipt sheet. Suppose bank amounts are in column C of Bank and receipt amounts are in column C of Receipts.
- =COUNTIF(Receipts!$C$2:$C$300, C2) in the bank sheet gives how many receipts share that amount.
- A result of 1 is a clean match. 0 means no receipt. 2 or more means you need the date or merchant to decide.
- Filter the helper column for 0 to produce your list of missing receipts.
A worked example
Say a month has 40 bank rows and 30 receipts. After the amount check, 24 rows show 1, 9 show 0 and 7 show 2 or more. The 7 ambiguous rows are probably repeat purchases, such as the same ₹60 tea stall payment on several days. Narrow by date and the 7 drop to 2 that you check against the photos. You end with 29 matched, 2 unsure and 9 to find, around 35 minutes instead of an afternoon.
| Result of check | Count | What to do |
|---|---|---|
| Clean match | 24 | Pair and file |
| Ambiguous, then resolved by date | 5 | Pair and file |
| Still unsure | 2 | Check the photo |
| No receipt | 9 | Ask, or note as no bill |
Add up the first two rows and you get 29 pairs, with 2 unsure, and 9 with no receipt, and 29 plus 2 plus 9 equals 40, every bank row accounted for.
Where does an app help?
An app cannot invent a receipt that was never photographed, but it can keep the receipt and the transaction together. SpendixAI keeps receipts with their transactions, and you pick the account before you import a statement so each row keeps its account. It does not promise automatic matching, so plan on attaching receipts yourself and use the matching rules above to move quickly.
How do you check a match you did not make yourself?
If a tool or a helper proposes a pairing, do not accept it on faith. Open both the receipt and the bank row and confirm the same three things: amount, date within a few days, and a merchant you recognise. Spot-check one in five of the pairs each month. If more than one in twenty is wrong, tighten the rules or go back to matching by hand until you understand why the mistakes happen.
What is a sensible weekly routine?
- Photograph or save bills as you go.
- On a fixed day, match the week's receipts to the week's rows.
- List unmatched rows and chase them within seven days.
- Close the month by checking that the unmatched list is empty or explained.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

