In a household where two people pay the electricity bill, the cylinder and the grocery order from their own wallets, failed attempts and retries make spending look larger than it was. Merge both exports on one tab with a column for who paid, then total only the settled rows, and you will see what the household really spent.
The usual confusion
One of you tries to pay a bill, the payment fails, and the other gets nervous and pays it too. Or one person retries three times. Now the export shows several rows for one bill and you each remember a different number. The status column is the tie-breaker.
Build one combined tab
- Copy each person's export onto a new tab, one below the other.
- Add a column called Owner and type your initials against each block.
- Make sure the columns line up: date, type, status, amount.
- Sort by date so a failed attempt and its retry sit near each other.
A worked example
| Owner | What | Status | Amount in ₹ |
|---|---|---|---|
| A | Electricity bill | Failed | 2,340 |
| A | Electricity bill | Success | 2,340 |
| A | Mobile recharge | Success | 399 |
| B | Grocery order | Success | 1,860 |
| B | Grocery order | Pending | 780 |
Counting everything gives 2,340 + 2,340 + 399 + 1,860 + 780 = ₹7,719. Settled rows are 2,340 + 399 + 1,860 = ₹4,599. The difference, ₹3,120, is the failed electricity attempt of ₹2,340 plus the pending ₹780. With owner in column A, status in C and amount in D, per-person settled spending is =SUMIFS($D$2:$D$300,$A$2:$A$300,"A",$C$2:$C$300,"Success") and the same with B.
That gives A ₹2,739 and B ₹1,860, which together make ₹4,599.
What if a bill was paid twice successfully?
That is a genuine duplicate and the status column will not help. Two successes for the same bill on the same day, one from each of you, are the pattern to look for. Sort by description and date, find the pair, and raise it with the biller or the wallet, keeping both receipts. Do not delete either row from your sheet until it is resolved; mark it Disputed instead.
What about a wallet balance that dropped but the bill is unpaid?
Check the status of the row and your wallet's balance after a day or two. Do not assume. Record the date, amount and any reference the export gives, then follow up through the wallet's support route.
For household records beyond wallets, SpendixAI offers one personal workspace on Pro with statement import, budgets and bills. It is not a team workspace or a bill-splitting app, so a shared sheet like this stays useful alongside it.
How do we keep it up without nagging each other?
Pick one evening a week, say Sunday after dinner, and spend ten minutes together on the sheet. One of you pastes the new rows from both wallets while the other reads out anything marked Failed or Pending. Decide on the spot who will chase what, and write the name in a Follow up column. Because it is a standing slot rather than a surprise conversation, nobody feels checked on. If a bill is due that week, look at that row first, whatever else is in the file.
At month end, copy the settled totals into a small summary at the top of the sheet: A's wallet, B's wallet and the household total. Three numbers are easy to remember and easy to compare with last month.
Weekly five-minute check
- Paste the new rows from both wallets
- Scan for Failed and Pending and agree who follows up
- Look for any bill paid twice
- Read the two settled totals
Useful ideas start with a clearer picture of your own spending.
Explore your reports

