Partners don't need a single percentage for every shared bill. Separate shared costs from personal spending first. Then choose 50/50, income-based, usage-based, or hybrid rules, category by category.

The math is easy to check. Two partners earning $60,000 and $40,000 a year land on a 60/40 proportional split. A $2,000 shared bill then comes to $1,200 and $800.

Usage can change one row on its own. If one person clearly uses more of a measurable service, record the agreed proxy in the sheet. Google Sheets will calculate the split and show who paid. It won't move money between accounts, though. That part stays manual.

Choose the split per expense

Fair doesn't always mean equal dollars. When you both use an expense the same way, 50/50 is the easy call. Income proportions earn their keep when equal dollars would squeeze one budget harder than the other.

Expense Rule to consider What to write down
Rent or mortgage 50/50, income-based, or hybrid Whether income differences or the housing choice affect the rule
Utilities Income-based or usage-based How usage will be estimated
Groceries 50/50, per-person, or usage-based Which meals and personal items count
Shared subscriptions 50/50 when both people use them Whether add-ons stay personal
One-off purchases Agreed split or reimbursement Who approved the purchase and who keeps the item

One percentage rarely fits every bill. Housing might run on income proportions, a jointly used subscription on 50/50, and electricity on a usage proxy. Three rules, one sheet, no conflict.

Use the simplest rule you can explain out loud.

Define shared spending before doing math

Do this before any math. Decide what actually counts as shared. Rent, utilities, common groceries, and a subscription you both use usually go in the shared bucket, while clothing, hobbies, gifts, and personal debt usually stay out, unless you both decide otherwise.

Put four plain-language rules in a Rules tab: shared categories, personal categories, approval for one-off purchases, and reimbursement timing. Cover the awkward cases too. Someone away for a month, an income change, a disputed bill. Each one needs an answer in advance.

A percentage without a definition behind it creates confusion later. Keep the definition sitting right beside the number.

Calculate an income-based split

Everything starts with one choice: which income number counts.

Gross pay works. Take-home pay works too, or any other measure you agree on. Whatever you pick, use the same basis for both partners. Settle how bonuses, freelance income, commissions, and temporary job gaps get treated before anyone types in a percentage.

The formulas are simple:

Partner A percentage = Partner A income / combined income

Partner B percentage = Partner B income / combined income

Multiply each bill by the share it deserves. The two results should add up to 100 percent.

Run the example. $60,000 against a combined $100,000 gives Partner A 60 percent and Partner B 40. On a $2,000 expense, that's $1,200 and $800.

Write the basis down. Otherwise an old percentage can keep running long after the incomes behind it have changed.

Use usage-based rules carefully

Usage rules live or die on clear measurement. Pick the proxy before the bill arrives, not after, and write the choice down.

Say you agree on occupied space as the proxy for a utility. Partner A is assigned 600 of 1,000 square feet, so the agreed allocation is 60 percent. A $150 bill then produces shares of $90 and $60.

That's a rule, not a meter reading. Keep the distinction visible in the notes.

Groceries are their own puzzle. Separate shared meals from personal purchases if that matters to you. One partner's specialty items can stay personal while common ingredients follow the rule you both chose. If the tracking gets harder than the savings, simplify it.

Thing is, perfect precision turns ordinary household spending into constant bookkeeping. A rough proxy both people accept often beats an exact system nobody maintains.

Build a Google Sheets shared budget template

A useful tracker needs fewer columns than most people expect. Keep the percentage, the calculation, the payer, and the explanation on the same row. That's the whole trick.

Date Category Description Amount Partner A % A share B share Paid by Notes
10/01 Housing Rent $2,000 60% =D2*E2 =D2*(1-E2) A Income-based rule
10/05 Utilities Electric $150 55% =D3*E3 =D3*(1-E3) B Usage proxy

Those formulas assume the amount is in column D and Partner A's percentage is in column E. Type 60%, not 60. The formulas expect a decimal share.

Set the sheet up like this:

  1. Create a Rules tab and an Expenses tab. On Rules, log each category, split method, percentage, usage method, and review date.
  2. Add the expense columns from the table above. Keep entries consistent in the Paid by column, such as A and B.
  3. Enter the agreed percentage on every row. A 50/50 expense gets 50 percent; proportional or usage-based expenses get their own numbers.
  4. Fill the share formulas down the sheet. At the bottom, total each partner's obligation with =SUM(F2:F100) and =SUM(G2:G100).
  5. See how far ahead Partner A is with =SUMIF(H2:H100,"A",D2:D100)-SUM(F2:F100). A positive result means Partner B owes A; a negative result means A owes B.
  6. Protect the formula columns with Data > Protect sheets and ranges, leaving input cells editable. Share the file only with people who should see or change the records.

If the sheet grows past 100 entries, widen those ranges. Keep receipts in a shared folder, and note the receipt name or location beside each expense.

Put the agreement in writing

No formula settles an argument about fairness. Write each decision in ordinary language, right beside the percentage.

Shared: rent, utilities, and groceries used together. Personal: purchases one partner has agreed to cover alone. Approval: discuss an unusual purchase before making it. Reimbursement: record the payer, amount, date, and repayment status.

A note like "Utilities use 55/45 based on our agreed office-usage proxy" does real work. That single line explains the number months later, when the reason isn't obvious anymore.

Treat the sheet as a record, not a vault. No passwords, bank credentials, or full account numbers in it. Payment can run through a bank transfer, cash, or another separate method, and you mark the reimbursement only after it's confirmed.

Review the budget before it gets stale

Stale numbers come from skipped reviews. A quick weekly update catches missing entries. A longer monthly conversation handles unusual costs, income changes, and shifts in usage.

Check Action
Recurring bills Confirm every expected charge is entered
Payer Compare the sheet with receipts or payment records
Split percentage Check whether the written rule still applies
Reimbursements Mark completed payments and leave disputed amounts visible
Receipts Add the file name or storage location

Test a new rule for one month before treating it as permanent. After a month or two, ask whether the setup feels fair in practice, not just whether the percentages add up.

To be honest, a tidy split on paper can still leave one person short on cash after a job change, a move, or a new work schedule. That's precisely the kind of thing a review should catch.

Handle exceptions directly

Strict math has edge cases. A partner with no current income gets a zero contribution from a proportional formula. Correct arithmetic. Still not a complete agreement.

Set a temporary rule instead. Pause contributions, use a fixed amount, or have the higher earner cover more for a defined period. Record the arrangement and the date you'll revisit it.

If a lease, security deposit, property ownership, or cohabitation agreement is involved, the written contract and applicable state law may matter more than the spreadsheet. For enforceable terms, seek advice from a qualified professional.

Common questions

Can partners use one split percentage for everything?

You can, though you don't have to. One number is easier to maintain. Category-specific rules just reflect income, use, or ownership more closely when a single percentage doesn't fit.

Is an income-based split always fairer than 50/50?

No. Income proportions can reduce unequal budget pressure, but some partners prefer equal dollars, and housing and lifestyle choices were often made together. Talk through the goal before picking the formula.

Can a usage split and an income split be combined?

Yes. One method for rent and another for a variable bill works when both partners agree on the reason and the measurement. Record each rule separately.

What if one partner disagrees with the percentage?

Write down both concerns and test one approach for a month. Real costs, cash flow, and the time it takes to maintain the rule should drive the final call.

Can Google Sheets replace a payment app?

For tracking, calculations, receipts, and reimbursement records, it holds up. It doesn't transfer money or confirm payments on its own. That takes a separate payment method.

Create the Rules tab today, add your recurring categories, and enter the first month's actual bills in Expenses. Then schedule the first review, before anyone has to guess what they owe.