Money basics

Auto-Match Receipts to Bank Transactions for a Household of Two

How a married couple can auto-match receipts to bank transactions across two phones and two accounts, with a monthly worked example.

Editorial illustration for Auto-Match Receipts to Bank Transactions for a Household of Two

Matching receipts to bank transactions gets slower, and worse than twice as slow, once two people spend from different accounts, because the same bill can be photographed twice and the same payment can show up in two statements. To make it close to automatic, put every bill and every entry in one list and let one rule do the first pass.

Where couples' lists go wrong

Each of you holds half the evidence. One holds the statement, the other holds the bill photos. Some purchases go on a shared card, some on personal cards, and some on UPI. A quick fix is to merge the data first and match second, and to add one column that says whose account each entry came from.

Build the combined list

  1. Each of you exports or copies your account entries for the month into a shared sheet.
  2. Add a column called Account with a short label for each source, such as A-card, B-card or Joint.
  3. Put every bill photo name into a second sheet with date, shop and amount.
  4. Run the amount-and-date match described below.
  5. Review the unmatched rows together for ten minutes, not alone.

A rule that does the first pass

Match when the amount is identical and the bill date is within two days of the entry. In Excel or Google Sheets, on the entries sheet, a column can hold =COUNTIFS(Bills!$C$2:$C$300, C2, Bills!$A$2:$A$300, ">="&A2-2, Bills!$A$2:$A$300, "<="&A2), which counts bills with the same amount dated up to two days before the entry. The window runs backwards here because the bill usually carries the earlier date than the bank posting.

A worked example with invented numbers

Say a couple has 18 bills and 21 entries in a month.

GroupCountWhat happens
Bills matched by the rule15Accepted after a quick look
Bills with no entry3Paid in cash, add by hand
Entries with no bill6Review together
Entries counted twice0None found

Check the arithmetic: 15 matched bills account for 15 of the 21 entries, which leaves 6 entries without a bill. The 3 unmatched bills are separate, so in total 18 bills equal 15 plus 3. Nothing is missing from the count, and the ten-minute review covers 9 items instead of 39.

How do you avoid counting a purchase twice?

The danger is that you each photograph the same bill, or one of you pays on a card and reimburses the other from a second account, which creates two entries for one purchase. Decide on a convention: the entry on the card that paid the shop is the real expense, and the reimbursement transfer is marked "settlement" so that it is not counted as spending.

Who does what?

  • The partner who is more comfortable with spreadsheets builds the sheet once.
  • Both of you drop bills into the same folder or chat during the week.
  • One person runs the match on a fixed day.
  • Both review the leftovers together.

When a shared sheet is not enough

SpendixAI imports statements as PDF, CSV or Excel for each account you choose, keeps each transaction with its account, and flags possible duplicate imports. Receipts stay with their transactions. Pro covers one personal workspace, so it is not built for two people each keeping approvals, and it does not read your accounts directly; you still check the matches yourself.

A rule for gifts and surprises

Some purchases one partner may not want the other to see in detail, such as a birthday gift. Agree a simple way to handle them: record the amount under a category called Gifts, attach the bill to a private folder, and let the shared list show only the total. That keeps the household figures honest without spoiling anything.

A final checklist

  • One combined list, one Account column.
  • One matching rule, applied the same way each month.
  • Settlement transfers marked and kept out of spending.
  • Leftovers reviewed together.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports