Split Household Supplies by Income in Google Sheets

✨ Community Finance

Published: May 2, 2026

If one roommate earns twice as much as the other, should both chip in identical amounts for trash bags and dish soap? Most roommates never stop to ask. Splitting shared household expenses by income ratio takes the pressure off the lower earner while keeping the apartment stocked.

The fix is straightforward. Instead of halving every receipt down the middle, each person covers a share matching their portion of combined earnings. A basic Google Sheet runs the numbers. Nobody has to renegotiate at the kitchen table every month.

The Math Behind Income-Proportional Splits

Say Person A takes home $2,000 a month and Person B brings home $3,000. Combined, that makes $5,000. Person A earns 40% of the total. Person B brings in 60%. When someone buys a $25 pack of paper towels and laundry detergent, Person A pays $10 and Person B pays $15.

Turns out, this heads off a lot of quiet resentment. Equal splits look fair on paper. But dropping $150 on supplies hits a $2,000 paycheck much harder than a $4,000 one. Proportional math means both roommates give up the same percentage of take-home pay to keep the place running, which stops anyone from feeling shortchanged.

Recommended Spreadsheet Columns

You will want two tabs: one for fixed income percentages and one for everyday receipts. The log itself relies on seven columns to track who paid upfront and what each person owes.

Column	Header	Purpose	Example
A	Date	Date of purchase	2026-03-12
B	Item	Description of household supplies	Dish soap and sponges
C	Total Cost	Receipt total for shared items	$18.50
D	Paid By	Person who covered the bill upfront	Alex
E	Split Type	Proportional split or direct reimbursement	Income
F	Person 1 Share	Amount calculated from Person 1 ratio	$7.40
G	Person 2 Share	Amount calculated from Person 2 ratio	$11.10

Step-by-Step Google Sheets Setup

Build the Incomes tab: Rename your first tab to Incomes. In cell A1, type Person 1 Name, and put their monthly take-home income in B1. Put Person 2 Name in A2 and their income in B2. Total them in cell B3 with =SUM(B1:B2). Add =B1/$B$3 into C1 for Person 1's share, then enter =B2/$B$3 into C2 for Person 2. Format C1 and C2 as percentages.
Set up the Supplies tab: Create a second tab named Supplies and paste the headers from the table above across row 1. Format column C as currency.
Add the calculation formulas: Put =IF(E2="Reimbursement", 0, C2*Incomes!$C$1) into cell F2. Put =IF(E2="Reimbursement", C2, C2*Incomes!$C$2) into cell G2. Proportional items calculate automatically. Anything marked as a reimbursement gets assigned to one person.
Calculate monthly balances: At the bottom of the sheet, sum what someone paid upfront using =SUMIF(D:D, "Alex", C:C). Subtract what they owe with =SUM(F:F). The final number tells you whether Alex is owed money or needs to send cash.
Lock formula cells: Roommates can easily overwrite spreadsheet formulas by pasting receipts into the wrong cell. Highlight columns F and G, click Data, choose Protect sheets and ranges, and restrict editing permissions to yourself. You can review standard permissions in guides on how to protect sheets and ranges to keep shared formulas intact.

Handling Edge Cases and Solo Purchases

Store runs get messy. Someone buys a 24-pack of toilet paper for the bathroom, but they also grab a face wash, a bag of gourmet coffee, and cough drops that nobody else will ever touch. Do not log the entire register total into column C. Pull out the receipt. Circle the communal items, add the sales tax for those specific goods, and record only that subtotal. That extra minute at the kitchen counter saves you from petty arguments later.

Thing is, income splitting gets silly when tastes diverge. If one person insists on buying premium multi-ply bamboo paper towels that cost three times the store brand, the other roommate will probably balk at paying 60% of that luxury. Settle this during a quick house rules chat. Stick to standard store brands for communal supplies, or let whoever wants the upgrade cover the price difference out of pocket.

Equal Split vs. Income-Proportional Split

Neither split method fits every home. The right choice comes down to your income gap and how much financial privacy you want.

Use an income ratio when there is a wide pay gap, such as a full-time professional living with a graduate student or a couple sharing joint household costs.
Use an equal split when earnings sit within 10% to 15% of each other, or when roommates are casual acquaintances who prefer keeping their paychecks private.
Use direct reimbursement when someone buys a single replacement item on short notice and wants immediate settlement through a quick cash app transfer.

Forcing an income split on casual Craigslist roommates can feel intrusive because it requires sharing pay stubs with a stranger. Save proportional sharing for partners, close friends, or housemates who agree that financial equity matters more than privacy.

Keeping Your Balance Updated

Log receipts every Sunday evening so small items like dish sponges and trash bags do not slip through the cracks. Settle the net balance at the end of each month with one bank transfer or payment app request.

Frequently Asked Questions

How should roommates handle a mid-year pay raise?

Update the Incomes tab on the first day of the following month. Leave historical rows alone so older splits reflect earnings at the time of purchase. Future entries will calculate with the new ratio automatically.

Can you use this template for three or four people?

Yes. Add extra rows on the Incomes tab and expand the denominator in the sum formula. Add corresponding share columns for Person 3 and Person 4 on the Supplies tab. The math stays identical.

Should we split based on gross income or take-home pay?

Use net take-home pay. That is the actual money landing in your checking account after taxes, health insurance, and retirement deductions. To be honest, take-home pay reflects real spending capacity much better than a top-line gross salary.