Bank statements

ICICI and SBI card statements to Excel for a couple sharing bills

Convert a joint-use ICICI or SBI card statement into a clean sheet, tag who spent what, and work out a fair settle-up figure with a worked ₹ example.

Editorial illustration for ICICI and SBI card statements to Excel for a couple sharing bills

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.

DescriptionAmount in ₹Who
SAMPLE SUPERMARKET3,200.00S
SAMPLE PHARMACY860.00A
SAMPLE SALON1,500.00B
SAMPLE ELECTRICITY BILL2,400.00S
SAMPLE RESTAURANT1,940.00S

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
SPENDIXAI JOURNAL

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

Explore your reports