Home and property

Gas, RO, maid and Wi-Fi: a recurring-costs sheet for flatmates

A single recurring-costs sheet for flatmates covering gas, RO service, maid and Wi-Fi: payer, frequency, each person's share and who pays or buys next.

Editorial illustration for Gas, RO, maid and Wi-Fi: a recurring-costs sheet for flatmates

Shared flats run on small recurring costs: the gas cylinder, the RO service, the maid, the Wi-Fi bill. A single sheet with one row per cost, its payer, how often it comes up, each person's share and a rotation column for who pays next stops these from turning into arguments.

What columns does the sheet need?

ColumnHeadingPurpose
ACostGas cylinder, RO service, maid, Wi-Fi
BAmountWhat you pay each time
CTimes a year12 for monthly, 1 for yearly, about 8.67 for every six weeks
DMonthly equivalent=B2*C2/12
EShare each=D2/3, if three people share
FLast paid byA name from the flatmate list
GNext payerFormula below

Keep the flatmates' names in a small list, for example in I2:I4, and change the 3 in column E to the number of people in your flat.

Can you work out a month with sample numbers?

These amounts are made up; use what you actually pay. Say a cylinder costs ₹1,100 and lasts about six weeks, the RO service is ₹1,800 once a year, the maid takes ₹3,000 a month and Wi-Fi is ₹800 a month.

  • Cylinder: ₹1,100 x 8.67 / 12 = about ₹795 a month.
  • RO service: ₹1,800 x 1 / 12 = ₹150 a month.
  • Maid: ₹3,000 x 12 / 12 = ₹3,000 a month.
  • Wi-Fi: ₹800 x 12 / 12 = ₹800 a month.
  • Total: ₹795 + ₹150 + ₹3,000 + ₹800 = ₹4,745, which is about ₹1,582 each for three people.

Seeing the yearly cost of a "small" item is useful too. The cylinder alone is about ₹9,537 a year in this example.

How does the rotation column work?

Put the names in I2:I4. In column F, type who paid last. In G2 use this formula, which moves to the next name and wraps back to the first:

  • =INDEX($I$2:$I$4, MOD(MATCH(F2, $I$2:$I$4, 0), 3) + 1)
  • MATCH finds the position of the last payer in the list. MOD with 3 wraps from the third name back to the first. INDEX returns the name at the next position.
  • If you add a fourth flatmate, put the name in I5 and change both 3 and the range to 4 and $I$2:$I$5.

When the next payer pays, type their name into F2 and G2 updates by itself.

What about costs that vary, like gas refills?

Use the sheet for the planned figure, and keep the actual receipts as the truth. When an actual cost differs, update B for that item and the sheet recalculates every share. Review once a quarter: prices change, and a maid's salary rises at some point.

Where does my own tracker come in?

Each flatmate should record only their own share in their own tracker. In SpendixAI, a payment you make for the flat can be added by hand, or arrive from a statement, and the shares you receive back can sit in a separate category, so your own cost is the net. It is not a bill-splitting app, so the sheet above does the splitting.

Who owns the sheet?

Give editing rights to everyone, but nominate one person to update the Last paid by column on the day a payment is made. Shared sheets decay when nobody is responsible. Lock the formula columns, or at least colour them differently, so a stray keystroke does not overwrite a share. Check the totals against real bills once a quarter, because that is when drift shows.

Set-up checklist

  • One row per recurring cost, with its real amount and frequency.
  • Monthly equivalent and share columns filled by formula.
  • Names list and rotation formula tested once.
  • A note of the rules the flat agreed.
  • A review reminder every three months.
SPENDIXAI JOURNAL

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

Explore your reports