When two people spend on the same card, the statement answers how much was spent but not by whom. Get the rows into one line per purchase, add a column for who, and a few SUMIFS formulas will show each person's share and what is left to settle between you.
Start by cleaning up the rows
Card statements often wrap long descriptions onto a second line, and conversions turn that wrap into a row with no date and no amount. Put the date in column A, the description in B and the amount in C, then in D2 use =IF(A2="","",B2&IF(AND(A3="",B3<>"")," "&B3,"")) and fill down. Filter out the blanks. Compare the total with the statement before you add anything else.
How do we tag who spent what?
Add a column E called Who. Use A and B for the two of you and S for shared. If one of you has an add-on card and your statement separates it, use that as a clue; if it does not, do not guess later from memory. Agree to tag within a day or two of the purchase, or the details are gone.
| Description | Amount in ₹ | Who |
|---|---|---|
| SAMPLE SUPERMARKET | 3,200.00 | S |
| SAMPLE PHARMACY | 860.00 | A |
| SAMPLE SALON | 1,500.00 | B |
| SAMPLE ELECTRICITY BILL | 2,400.00 | S |
| SAMPLE RESTAURANT | 1,940.00 | S |
How do we work out the settle-up?
Use =SUMIFS($C$2:$C$200,$E$2:$E$200,"A") for the first person's own spending and the same with B and S. Here A is ₹860, B is ₹1,500 and shared is 3,200 + 2,400 + 1,940 = ₹7,540. Half of shared is ₹3,770 each. Then A's total share is 860 + 3,770 = ₹4,630 and B's is 1,500 + 3,770 = ₹5,270. Together that is ₹9,900, which equals 860 + 1,500 + 7,540.
If the card is in A's name and A paid the whole ₹9,900 bill, then B owes A ₹5,270. If you split shared costs in a different ratio, say by income, change the half to your agreed percentage in the same formula. Agree the ratio once, out loud, rather than recalculating it in your head each month.
What if one of us forgets to tag?
Make a rule: untagged rows stay in an Unsorted pile and are counted as shared until someone claims them. Use =COUNTBLANK($E$2:$E$200) to see how many rows are waiting. Looking at the number together once a week is easier than a long argument at month end.
When a sheet stops being enough
SpendixAI can take the card statement as a file, let you review the rows before saving, and keep corrections as history. It is one personal workspace on Pro, not a team or approvals tool, and it is not a bill-splitting app, so the settle-up arithmetic above stays in your sheet or your head.
Can we add a fairness column for months with unequal spending?
Yes, and it helps to keep it separate from the raw total. Add a column called Split to give each shared row a percentage for A, for instance 60 percent on a month when A earns more. Then use =SUMPRODUCT(($E$2:$E$200="S")*$C$2:$C$200*$F$2:$F$200) to get A's weighted share of shared costs, with the percentage as a decimal such as 0.6 in column F. Say shared costs are ₹7,540 and A's agreed split is 0.6: A's part is 7,540 x 0.6 = ₹4,524 and B's is the remaining ₹3,016. Whatever ratio you pick, write it at the top of the sheet so the next month's argument is shorter.
Month-end routine for two
- Paste and clean the statement together on one evening
- Tag leftover rows, shared by default
- Read off the three totals
- Settle up and note the date in the sheet
Useful ideas start with a clearer picture of your own spending.
Explore your reports

