Proportional Shared Expenses Calculator for Couples in Google Sheets

TL;DR: Splitting every shared bill 50/50 feels fair until one partner earns meaningfully more than the other—then it quietly overcharges the lower earner. A proportional split divides each shared expense by income share instead of headcount: whoever earns 53% of household income pays 53% of the rent, not 50%. This guide walks through the formula, a full worked example on real numbers, and how to build it in Google Sheets yourself—or use the ready-made Split Calculator tab.

Why 50/50 splits break down with two incomes

Two people move in together, open a shared spreadsheet, and split every bill down the middle. It works fine when incomes are close. It stops working the moment they aren't.

Say Partner A takes home $3,200/month and Partner B takes home $2,800/month. A 50/50 split on a $1,800 rent means each pays $900. But $900 is 28.1% of Partner A's income and 32.1% of Partner B's income—the lower earner is carrying a heavier relative load for the exact same bill. Over a year, that gap compounds into real financial strain and, often, resentment neither partner can quite name.

A proportional split fixes this by dividing shared costs according to each partner's share of household income, not by headcount. The higher earner pays a larger dollar amount; both partners carry the same percentage of their own income toward shared costs.

The proportional split formula

Three steps, and it's the same math every time:

1. Calculate each partner's income share: Partner Share % = Partner Income / (Partner A Income + Partner B Income)
2. Apply that percentage to every shared expense: Partner's Cost = Expense Amount × Partner Share %
3. Compare against 50/50 to see the gap a flat split would have created: 50/50 Amount = Expense Amount / 2

That's the whole system. No app, no manual negotiation per bill—just one ratio, applied consistently.

Worked example: $3,200 and $2,800 incomes

Partner A takes home $3,200/month. Partner B takes home $2,800/month. Household income: $6,000/month.

Now apply those percentages to four real shared expenses:

Check the math: $1,541.34 + $1,348.66 = $2,890.00 — every dollar of the shared total is accounted for, split by income rather than by count of partners.

Compared to a flat 50/50 split, Partner A (the higher earner) pays $96.34 more per month, and Partner B pays $96.34 less. As a share of their own income, though, both partners are now contributing the same 48.2% of take-home pay toward these four categories ($1,541.34 / $3,200 = 48.2%; $1,348.66 / $2,800 = 48.2%). That equal-percentage outcome is the entire point of proportional splitting—it's not about making the numbers equal, it's about making the burden equal.

Building it yourself in Google Sheets

You don't need a template to set this up—three formulas do it:

1. Income share (put incomes in B2 and B3):

Partner A % = B2/(B2+B3)
Partner B % = B3/(B2+B3)

2. Each partner's share of an expense (expense amount in C-column, A% in a locked reference cell):

Partner A's Share = C2*$B$5   (where B5 holds Partner A's %)
Partner B's Share = C2*$B$6   (where B6 holds Partner B's %)

3. The 50/50 comparison, so you can see the gap at a glance:

50/50 Amount = C2/2
Difference from 50/50 = (C2*$B$5) - (C2/2)

Copy those three formulas down one row per shared expense category, and you have a full proportional split calculator. Total each column at the bottom to confirm Partner A's total plus Partner B's total equals your total shared spending—if it doesn't, a formula reference slipped somewhere.

For the rest of the budget structure this calculator plugs into—income rows, planned-vs-actual tracking, personal allowances—see our broader guide to the couples budget spreadsheet.

What proportional splitting doesn't solve

It's worth being clear about the boundaries here. A proportional split calculator answers "how much should each of us put toward shared bills, given what we each earn?" It does not, by itself:

• Decide which expenses count as "shared" versus personal—that's a conversation, not a formula
• Replace a monthly check-in—see how to combine finances as a couple for the communication side of this
• Track debts, savings, or net worth—those need their own tabs alongside the split calculator

Proportional splitting is one piece of a couples budget, not the whole system.

The ready-made version: the Split Calculator tab

Building the formulas above takes about 20 minutes and works fine for two or three categories. Once you're splitting eight or ten shared expenses every month, re-typing the same three formulas down each row is where small mistakes creep in—a dragged reference that didn't lock, a percentage that's off by one row.

The Sheetfolk Couples Budget Spreadsheet now ships with a Split Calculator tab built for exactly this:

• Pulls both partners' take-home incomes straight from the Monthly Budget tab — enter them there once, and the Split Calculator's income share updates automatically, no re-entering
• It computes each partner's proportional share of income automatically
• List each shared expense once in the Split Calculator's own table (up to 10 rows) and it gets an income-weighted split calculated for both partners, side by side
• A built-in comparison column shows what a flat 50/50 split would have been, so you can see the gap at a glance—like the +$96.34/−$96.34 example above, but for your own numbers

To be clear about what this tab is (and isn't): it's a shared calculator tab inside the same workbook, with formulas that do the proportional math for you. It doesn't include private per-partner tabs, permission controls, or automatic bank imports—you're still entering your own numbers, the same way you would in the DIY version above. What it saves you is re-deriving and re-copying the formulas yourself across every category, every month.

It sits alongside the rest of the workbook—Monthly Budget, Sinking Funds, Debt Tracker, Net Worth, and a Dashboard that rolls everything up. The incomes it uses flow in from the Monthly Budget tab automatically, but the split results flow the other way only if you take them there yourself—the Split Calculator doesn't write its output back into Monthly Budget or the Dashboard, so once you've got each partner's share for a category, you enter that number wherever you're tracking who paid what. If you haven't set up the sinking-funds side of a shared budget yet, the sinking funds tracker guide covers the same monthly-target formula approach used on that tab.

Common mistakes when splitting proportionally

1. Using gross income instead of take-home. Two partners can have very different tax brackets, retirement contributions, or benefits deductions. Splitting by take-home pay reflects what actually lands in each person's account to spend—splitting by gross overstates what the higher earner has available.
2. Forgetting to update after a raise or job change. The whole calculation rests on the two income numbers at the top. If Partner B's take-home rises from $2,800 to $3,300, the split shifts from 53.3%/46.7% to roughly 49.2%/50.8%—and the old percentages will quietly overcharge Partner A until someone notices.
3. Applying it to genuinely personal spending. Proportional splitting is for shared costs—rent, groceries, utilities, joint insurance. Applying the same ratio to a partner's individual hobby spending or personal debt payoff defeats the purpose of having personal allowances at all.
4. Ignoring variable income. If one partner is on commission, freelance, or seasonal income, decide up front whether to use a trailing average or their base pay for the split—then keep it consistent instead of recalculating every month based on whichever number feels fairer that week.
5. Skipping the 50/50 comparison column. It's tempting to just compute the proportional split and move on, but the comparison is what makes the fairness case visible to both partners. Without it, the higher earner just sees a bigger number with no context for why.

Keeping the split current

Incomes change—a raise, a job switch, a move to part-time. When they do:

1. Update both incomes in the two input cells.
2. Every percentage, every partner's dollar share, and every 50/50 comparison recalculates instantly.
3. Revisit the split at your next money date rather than mid-month—consistency matters more than precision here.

TaskDrain works well as the recurring reminder for that monthly review, and if you want a clearer picture of what's actually flowing through the "shared" categories before you split them, running the month through Spendcull first tends to catch spending that should be reclassified as personal before it ever hits the split calculation.

Key Takeaway

A 50/50 split is easy but often unfair once two incomes diverge. A proportional split—income share × expense amount—makes the burden equal instead of the dollar amount, and it only takes three formulas to build yourself. If you'd rather skip re-deriving those formulas across every category every month, the Split Calculator tab in the Sheetfolk Couples Budget Spreadsheet does the same math automatically, living in the same workbook as the rest of your shared budget so the incomes it needs are already there.

Get the Couples Budget Spreadsheet with the Split Calculator tab →

Disclaimer: This post is for informational purposes only and is not financial, legal, or tax advice. Every couple's financial situation is different, and how you split shared expenses is a personal decision between partners. Consult a licensed financial advisor before making major decisions about income splits or household finances. The examples and formulas here are illustrative and should be verified against your own numbers.