When two earners save tax together, the risk is not forgetting a payment but attributing it to the wrong person. Use one sheet with an Owner column for every payment, one proof folder per person, and a joint review in January. That way each of you can see what the household has done and what each declaration should carry.
Why couples need an Owner column
A home loan is in both names, an insurance policy is for the spouse but paid by you, children's fees come from a joint account. Who gets to use which payment is a question for your CA, and can depend on how each item is held. The sheet's job is to record who paid, from which account, and in whose name the receipt is.
The columns that matter
- Date and Item
- Owner, meaning the person whose name is on the instrument or receipt
- Paid by, meaning whose account the money left
- Account, such as joint, his, hers
- Amount
- Proof saved, yes or no
A row for a premium might read: 12 July, Life cover, Owner Meera, Paid by Arjun, Joint account, ₹21,000, proof saved. Now no one wonders why the premium is missing from Meera's own statement.
A worked example with two owners
Take made-up annual payments. Arjun: provident fund deduction ₹54,000 through payroll, term insurance premium ₹14,000. Meera: provident fund deduction ₹36,000, a PPF deposit of ₹40,000. Together: children's tuition ₹48,000 from the joint account, receipt in Meera's name.
| Owner | Item | Amount in ₹ |
|---|---|---|
| Arjun | Provident fund deduction | 54,000 |
| Arjun | Term insurance premium | 14,000 |
| Meera | Provident fund deduction | 36,000 |
| Meera | PPF deposit | 40,000 |
| Meera | Children's tuition from joint account | 48,000 |
With the formula =SUMIFS($C$2:$C$200,$A$2:$A$200,"Arjun") you get 54,000 plus 14,000, which is ₹68,000, and with "Meera" you get 36,000 plus 40,000 plus 48,000, which is ₹1,24,000. The household total is ₹1,92,000. Whether the tuition counts for Meera, for Arjun or at all is a CA question.
How do we avoid counting the same thing twice?
- One row per payment, never one per person
- If a payment is split, make two rows that add up to the original
- Compare the sheet with each statement once a month
- Mark anything reimbursed by an employer
When a sheet stops being enough
A sheet works well for a dozen rows. When statements from two or three accounts mean hundreds of lines a year, SpendixAI can help: you upload each statement as PDF, CSV or Excel, pick the account first so each transaction keeps it, and use custom categories with tax-deductible settings. Pro covers one personal workspace, so it is not a team tool for two separate logins. It does not read SMS or connect to banks.
What about payments in a child's name?
Fees and policies for children raise the Owner question sharply. Is the receipt in the parent's name or the child's? Which parent paid? If both contribute, record each person's part as its own row, with the same receipt attached to both. Ask your CA how such items are to be treated; the rule may differ by item and may change. Your sheet's job is to make the answer possible by holding clear, dated rows rather than a single total that hides who did what.
How often should we sit down together?
Three times a year is enough for most households: once in July after the first quarter of payroll and premiums, once in October, and once in January before the last-minute window. Each sitting takes about twenty minutes. Read the per-person totals aloud, check that each has proof, and write down who will make any remaining payment and from which account. The aim is no surprises in March and no argument about who forgot.
January review
- Open the sheet together and read the totals per person.
- Check that proofs exist for every row.
- Take the sheet to your CA with specific questions.
- Decide the last payment date for each item.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

