Cards and UPI

Splitting a shared card bill with flatmates using the statement

Split a shared card bill with flatmates using the statement: tag each line to a person or shared, then compute each share with worked numbers and formulas.

Editorial illustration for Splitting a shared card bill with flatmates using the statement

To split a shared card bill with flatmates, tag every statement line with a name or the word Shared, add up each person's own lines, divide the Shared total by the number of people, and add the two together. Whoever holds the card is repaid by the others. It takes ten minutes once the habit is in place.

What does the tagged statement look like?

Say three flatmates, Aman, Bina and Chirag, share a card held by Bina. This month's lines, all hypothetical, are below.

LineAmount (₹)Tag
Groceries3,840Shared
Wi-Fi bill1,200Shared
Dinner out together2,160Shared
Headphones2,999Aman
Cab rides640Bina
Gym fee1,500Chirag

The statement total is 3,840 + 1,200 + 2,160 + 2,999 + 640 + 1,500 = ₹12,339.

How do I calculate each person's share?

First the shared pot: 3,840 + 1,200 + 2,160 = ₹7,200. Divided by three, each person's share is ₹2,400. Then add each person's own lines.

  • Aman: 2,400 + 2,999 = ₹5,399
  • Bina: 2,400 + 640 = ₹3,040
  • Chirag: 2,400 + 1,500 = ₹3,900

Check: 5,399 + 3,040 + 3,900 = ₹12,339, which equals the statement. Bina paid the bank in full, so Aman owes Bina ₹5,399 and Chirag owes Bina ₹3,900. Bina's own share of ₹3,040 stays with her.

What are the spreadsheet formulas?

Put the amount in column C and the tag in column D, rows 2 to 100. Then:

  • Shared total: =SUMIFS($C$2:$C$100, $D$2:$D$100, "Shared")
  • One person's own lines: =SUMIFS($C$2:$C$100, $D$2:$D$100, "Aman")
  • That person's full amount: =SUMIFS($C$2:$C$100, $D$2:$D$100, "Aman") + ROUND(SUMIFS($C$2:$C$100, $D$2:$D$100, "Shared")/3, 0)
  • Check against the statement: =SUM($C$2:$C$100)

ROUND keeps the share in whole rupees. With uneven numbers, three rounded shares may differ from the pot by a rupee or two, so agree who absorbs that, usually the card holder.

What if one flatmate was away?

Decide the rule before the month starts. For groceries and the like, you might split only between the people who were present. For fixed costs such as Wi-Fi, everyone pays. Create a second tag, such as Shared-AB, for lines split between two people only, and divide those by two.

What happens when a flatmate moves out mid-month?

Do a final split for the days they were there. If the shared pot was ₹7,200 and a flatmate left after the 10th of a 30-day month, you could count their share as 10/30 of their one-third, which is 7,200 / 3 x 10 / 30 = ₹800, and split the remainder between the people who stayed. Agree the method with them before they leave, and collect the money before the keys go back.

A last practical point: round to whole rupees and send each person a single number with the list of lines behind it. People pay faster when they can see exactly what they are paying for, and disputes shrink to one line at a time instead of the whole bill.

Where does an expense tracker fit in?

SpendixAI is not a bill-splitting app, so use a sheet for the split itself. What it can do is hold your own side of the story: import the statement into your workspace, then download the rows as CSV from a report, and paste them into the sheet for tagging. Your own share can then be recorded in your tracker under the right categories.

Settling up

  1. Share the tagged sheet with everyone.
  2. Wait for objections for a day.
  3. Each person transfers their amount to the card holder by UPI.
  4. The card holder pays the bank before the due date.
  5. Keep the sheet; it is the record.
SPENDIXAI JOURNAL

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

Explore your reports