Agree the inputs before comparing the methods
Choose a time period, decide which expenses are shared and define the income figure used by the comparison. Both people need to use the same basis and dates. A spreadsheet can calculate a chosen arrangement, but it cannot decide which arrangement is fair for a particular relationship.
In this fictional monthly example, Alex and Blake agree to use $3,000 and $2,000 respectively as their income inputs. Their shared expenses total $2,500. All figures are illustrative; they are not a recommendation about income definitions, account ownership or how much a household should spend.
Compare 50/50 with a 60/40 income split
The combined income input is $5,000. Alex’s proportion is $3,000 ÷ $5,000 = 60%; Blake’s is 40%. Applying those proportions to the same $2,500 shared-expense total gives $1,500 and $1,000.
| Person | Agreed income input | Income proportion | Equal expense share | Income-proportional share |
|---|---|---|---|---|
| Alex | $3,000 | 60% | $1,250 | $1,500 |
| Blake | $2,000 | 40% | $1,250 | $1,000 |
| Total | $5,000 | 100% | $2,500 | $2,500 |
The total household expense does not change when the split changes. Only the assigned contributions change. Keep the selected method and its effective period visible so an old month is not silently recalculated using a later agreement.
Use actual payments to calculate the settlement
Alex paid the $1,800 rent and $100 of utilities. Blake paid the other $80 of utilities and $520 of groceries. Their actual shared payments are therefore $1,900 and $600.
| Expense | Shared amount | Paid by Alex | Paid by Blake |
|---|---|---|---|
| Rent | $1,800 | $1,800 | $0 |
| Utilities | $180 | $100 | $80 |
| Groceries | $520 | $0 | $520 |
| Total | $2,500 | $1,900 | $600 |
For an equal split, Alex paid $1,900 − $1,250 = $650 more than the assigned share, so Blake’s balancing transfer to Alex is $650. Under the income-proportional method, that transfer is $1,900 − $1,500 = $400. Use only the result for the method the couple selected.
Build checks that catch missing or duplicate payments
In a simple summary, place each person’s income in B2:B3, assigned share in C2:C3 and actual payments in D2:D3; place the total shared expenses in H2. For the proportional model, C2 is =IF(SUM($B$2:$B$3)>0,$H$2*B2/SUM($B$2:$B$3),""). For an equal model, each share is =$H$2/2.
Use =IF(C2="","",D2-C2) for the settlement balance, leaving it unresolved when the assigned share is missing. A positive result means that person has paid more than the assigned share in this example. The two balances should sum to zero only when the expense total, assigned shares and actual payments are complete and consistent.
If total income is zero or missing, leave the proportional calculation unresolved and choose an agreed alternative rather than dividing by zero. When a chosen split creates fractions of a cent, reconcile the rounded shares to the expense total. Google’s ROUND function documentation explains the rounding operation; it does not choose a household’s allocation agreement.
Record the transfer without creating a second expense
Once Blake transfers $400 under the proportional example, Alex’s net outlay is $1,500 and Blake’s is $1,000. The rent, utilities and groceries still total $2,500. Recording the settlement as another household expense would incorrectly raise that total to $2,900.
Keep a separate settlement record with the date, sender, recipient, amount and reference. Keep personal purchases outside the shared-expense total unless both people have included them. For a bill paid from a joint account, decide whether your ledger tracks contributions into that account or the final spending; mixing both as expenses can double count the same money.
Download the fictional household expenses CSV
The CSV contains the three expense rows and actual payment values. Use the income inputs in this guide to compare the two methods. For ongoing planning, review the SheetChief Couples Budget and Shared Expense Tracker and the budget planner collection. SheetChief sells these products; confirm the paid template supports your agreed workflow and desired split.
Put this into practice
Budget Planner Spreadsheets, Bill Trackers & Personal Finance Apps
Compare the actual product previews and included files before choosing a paid template.
Sources and further reading
The explanations and worked examples are prepared for SheetChief. These sources support the referenced methods or platform instructions.
Questions, answered
How do I split shared bills proportionally by income?
Using the same agreed income basis for both people, divide each person’s income by the combined total and multiply by the shared-expense amount. Decide the agreement before applying the calculation.
How do I calculate who reimburses whom?
Compare actual shared payments with the assigned expense share. In the example, Alex paid $1,900 against a $1,500 share, so Blake transfers $400 to Alex.
Should a reimbursement transfer increase the household expense total?
No. It settles who funded expenses already recorded. Keep the transfer separate so the original expense is counted once.
Is an income-proportional split always fairer than 50/50?
The arithmetic does not decide that. The two people choose which expenses and circumstances to include and which approach suits their agreement.
Related SheetChief tools
These are our own products. The examples above explain the task; check each Etsy listing to confirm which features and formats are included.
