Money tips

Merge two people's statements into one household view each month

A monthly routine to combine two bank statements into one household budget: import both, mark transfers between you as non-spending, and read one report.

Editorial illustration for Merge two people's statements into one household view each month

To combine two bank statements into a household budget, import both people's statements for the same month, mark money moved between your own accounts as a transfer rather than spending, categorise everything with one shared list, and read a single combined report. The transfer step is the one that most often goes wrong, and it can inflate your totals by thousands of rupees.

Agree the ground rules first

A statement is private. Each person should send their own statement file to whoever keeps the household record, as a PDF or spreadsheet export, and nobody should share net-banking logins, passwords or OTPs with anyone. Decide together who does the monthly job and what is in scope. If one of you would rather keep some spending personal, agree a personal-allowance line so it stays out of the detail.

The monthly routine

  1. On the same date each month, both people download their statement for the full month, from the 1st to the last day.
  2. Check the first and last date in each file so nothing is missing at the edges.
  3. Import them one after the other, choosing the right account for each file before importing.
  4. Review the rows. Fix categories, and mark transfers between your two accounts.
  5. Open one report for the month, and read it across both accounts.

Why transfers need special care

If one of you moves ₹15,000 into the other's account for the household, that payment appears twice: as money out of the first account and money in to the second, and then again when the second person spends it on rent, groceries or bills. Counting both the transfer and the later spending counts the same money twice.

Say the first person's statement shows ₹48,000 going out, including that ₹15,000 transfer. The second person's statement shows ₹41,000 going out, including ₹2,000 sent back for a shared purchase. These figures are hypothetical. Without any correction, the combined outflow is 48,000 plus 41,000, which is ₹89,000. After taking out the two transfers, the first person's spending is ₹33,000 and the second person's is ₹39,000, so the household spent ₹72,000. The transfers added ₹17,000 of fiction.

StepFirst personSecond personCombined
Money out per statement₹48,000₹41,000₹89,000
Less transfers between you₹15,000₹2,000₹17,000
Spending₹33,000₹39,000₹72,000

Do I need the same categories on both sides?

Agree the awkward ones early: does a petrol fill-up for one person's commute count as transport or as that person's personal spending? Where a payment is for one person, a note or a sub-category keeps it visible without needing a separate list.

Yes. Choose one category list before you start, even if it is short, and apply it to both statements. The combined view only makes sense if Groceries means the same thing on both sides. Spend the first month tidying and naming, and later months get quicker because merchants you have already categorised are remembered.

Where a tracker helps and where it does not

In SpendixAI you choose the account before importing, so each transaction keeps its own account, and the rows are reviewed before they are saved. Statements can be uploaded as PDF, CSV or Excel, and a possible duplicate import is flagged. Pro covers one personal workspace, so it is a way for one person to hold both statements, not a shared approvals tool. The other person sends a file; they do not need to sign in.

A month-end checklist

  • Both statements cover the whole month with no missing days.
  • Every transfer between your accounts is marked and left out of spending.
  • Categories match on both sides.
  • The combined spending equals each person's outflow less transfers.
  • One short note records anything unusual, such as a refund or a payment made for a parent.
SPENDIXAI JOURNAL

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

Explore your reports