Splitting groceries by budget share means each person covers a percentage of the shared food bill that matches their share of household income. A 50/50 split doesn't do that. If one person earns 60 percent of the combined income, they pay 60 percent of the grocery total.
Is an even split still fair when the paychecks look nothing alike?
You need a percentage everyone accepts and a rule for what counts as shared food. Without those, the calculator just argues in decimal form.
When income share beats an even split
Equal splits are simple, but they squeeze whoever earns less once the weekly shop is mostly staples the whole house eats. Income share usually fixes that squeeze.
The two formulas you actually need
You get each person's budget share by dividing their income by the household total, then multiplying by 100 so it reads as a percentage. Use one income definition for everyone.
A Google Sheets proportions walkthrough shows the same ratio math if you'd rather let the sheet do it.
- Budget share % = (Individual Income / Total Household Income) x 100
- Amount owed = Total Grocery Bill x (Budget Share % / 100)
Thing is, net pay is usually cleaner. Mixing net for one person and gross for another warps the split.
A $200 receipt, split by income
Person A earns $4,000 a month and Person B earns $2,000, so combined income is $6,000. Person A's share is 66.7 percent. Person B's share is 33.3 percent. On a $200 grocery bill, Person A owes $133.40 and Person B owes $66.60.
If they later add a third roommate, rebuild the percentages from the new combined income instead of leaving 66.7 and 33.3 on the sheet like those numbers still apply, which is what happens when someone moves in mid-month and nobody touches last month's ratio. Recalculate the ratio that same week.
A fixed budget share is the other path if people don't want to share income numbers. Pick something like 55/45 and leave it until someone asks to reopen it.
Set up the tracker in Sheets or Excel
A shared sheet can act as a grocery split calculator once incomes live in a small settings area and every receipt row reads those percentages.
| Column | What to enter |
|---|---|
| Date | Day of the shop |
| Description | Weekly groceries, bulk run, paper goods |
| Total cost | Full receipt |
| Payer | Who paid the store |
| Shared | Yes or No |
| Each person's share | Dollar amount owed on that row |
Turns out you don't need a fancy template. Date, description, total, payer, and a yes/no shared flag will carry most households.
Microsoft's household budget guidance in Excel keeps variable costs like groceries apart from fixed costs like rent, and your grocery tab should do the same. Protect the formula cells after that. In Google Sheets, protected sheets and ranges stop a roommate from wiping the share math while logging a receipt. AutoSum still totals the month fine.
If Shared is Yes, multiply Total cost by that person's budget share. For a personal item, put 100 percent on that person and 0 percent on everyone else so the row still adds to 100 percent.
Draw a line between shared and personal food
Most arguments aren't about 66.7 versus 33.3. They're about the $14 oat milk only one person drinks.
Agree on the line before the first shop:
- House staples go in the split. Personal extras stay on the person who wanted them.
- Log receipts the night of the shop, or park them for one weekly dump. Pick a cadence and keep it.
Frequent overnight guests who eat the house food need a conversation before the ratio silently subsidizes them. A flat guest add-on works if you don't want to rebuild percentages every time.
Settle the month in one pass
At month end, sum each person's share and subtract what they already paid at the store. The difference is the reimbursement. One payment beats a circle of IOUs. If Person A paid the whole $200 and their share is $133.40, Person B owes them $66.60.
To be honest, most fights start when one person paid three times in a row and nobody wrote it down. The shared sheet is the record. The sheet is also how you notice that pattern before it gets ugly.
Pay the balance however you already pay each other. You don't need a split-bill app for this. Open a blank workbook tonight and start there. Enter both incomes and last week's receipt. Live with those percentages for a month, then adjust the ratio in conversation if it still feels off.