You don't need a joint bank account to share rent, utilities, and groceries. A single spreadsheet both of you can edit handles the whole thing: who paid, what you agreed to chip in, and who owes whom.
Who paid the electric bill, and who owes whom for the groceries? A sheet answers that faster than memory does.
Four tabs get you going: Rules, Plan, Actuals, and Settlements. Add a Summary tab if you want totals in one place, but that's optional. Settle on the split before anyone types in a payment. Arguing about percentages after the money moved is much worse than deciding them up front.
Here's the distinction that keeps everything sane. The budget says what you expect. The ledger says what happened. The settlement log says who still owes whom. Log expenses weekly, then square up together once a month.
Choose the expense split before building the sheet
Fair isn't the same as equal, and couples mix the two up constantly. Pick a method that fits your incomes, how much each of you actually uses things, and how much recordkeeping you can both stomach.
| Split method | Works well when | Cost or friction |
|---|---|---|
| 50/50 | Incomes and usage are fairly similar | Simple, but it weighs harder on the lower earner |
| Income-based | Shared costs should track take-home pay | You have to agree on which income figure counts |
| Per-person | The cost follows heads, like groceries | Fits household consumption, not fixed rent |
| Usage-based | One person clearly uses more of a service, car, or utility | Someone has to estimate usage reasonably |
| Room-size | Bedrooms or private space differ materially | Feels fair for housing, but shared areas still need a rule |
| Nights-stayed | One partner is away often or misses nights at home | Needs real dates, and fixed bills don't always fit it |
| Hybrid | Different categories deserve different treatment | Practical, but write down every exception |
Pick one definition of income and stay with it. After-tax take-home, gross income, a fixed monthly amount, some other agreed base. Any of these works. Consistency matters more than finding some universal formula. NPR's discussion of finances for unmarried couples describes a fixed contribution model built on take-home pay, which is one common version of this.
A quick proportional example. Partner A earns $62,000 and Partner B earns $38,000. A covers 62% of shared costs, B covers 38%. On a $500 shared bill, the targets come out to $310 and $190.
Write the rule in the Rules tab. Something like: Shared costs include rent, electricity, internet, groceries, and agreed subscriptions. Personal costs include solo meals, individual memberships, gifts, and personal debt. If it isn't written down, it isn't a rule. It's a memory, and memories split unevenly.
Revisit the agreement after a raise, a job change, a move, or a new recurring bill. Changing the method halfway through a month without saying so is just asking for an argument with numbers in it.
Build one shared workbook
Google Sheets is the easy choice when both of you need to edit live. Excel runs the exact same structure if you share the file some other way.
Thing is, a shared sheet is a record, not a wallet. It won't move money, and it won't make anyone pay.
| Tab | What to store there | When to update it |
|---|---|---|
| Rules | Names, income basis, category rules, default split, and review triggers | At setup and after a change |
| Plan | Month, category, planned amount, and optional shared savings goal | At the start of each month |
| Actuals | Date, category, description, amount, payer, split, receipt, and notes | As expenses happen |
| Settlements | Date, sender, receiver, amount, related month, and paid status | Whenever money changes hands |
| Summary | Planned totals, actual totals, variances, target shares, and net balances | Formula-driven |
Use dropdowns for categories and payer names if your spreadsheet supports them. Otherwise Partner A, A, and someone's actual first name become three separate people, and your totals quietly stop adding up.
Sharing deserves a second of thought, too. The only people who need edit access are the ones entering expenses. A public edit link sitting on a file full of income figures and receipts is a bad idea.
Add simple formulas
Boring formulas are a feature, not a flaw. When a number looks wrong, you can actually check a plain SUM without decoding anything.
Say B2 and C2 hold each partner's take-home income, D2 holds total income, and E2 holds Partner A's share. Expense rows start at row 10, with planned amounts in column B and actual amounts in column C.
| Purpose | Formula | Meaning |
|---|---|---|
| Total income | =SUM(B2:C2) |
Adds both incomes |
| Partner A share | =IFERROR(B2/D2,0) |
A's percentage |
| Partner B share | =1-E2 |
Whatever percentage is left |
| Total planned | =SUM(B10:B16) |
Planned category amounts |
| Total actual | =SUM(C10:C16) |
Actual category amounts |
| Category variance | =C10-B10 |
Positive means spending is over plan |
| Partner A target | =C10*E10 |
A's share of the actual cost |
| Partner B target | =C10-F10 |
B's remaining share |
Format the share cells as percentages. Want a 50/50 category? Type 50% straight into that row's split column instead of leaning on the income-based default. That's how rent follows income while groceries stay even, if that's your agreement.
For a planning view, pull the target from the planned amount instead: =B10*E10. Keep planned and actual figures in separate cells so they never blur together.
Here's the variance idea made concrete. The plan shows $300 for utilities, the bill lands at $320, so you enter $320 in Actuals and the variance reads $20 over plan. If you'd rather have positive numbers mean money left over, flip it to =B10-C10. Pick one direction and never mix the two.
Enter actual expenses as they happen
Treat Actuals as a transaction ledger, not a second guess at the plan.
- Enter one row per shared purchase, with the date, category, description, and full amount.
- Mark who paid. The payer field describes the original purchase, never a later reimbursement.
- Apply the agreed split percentage for that category. Override the default only when both partners approve the exception.
- Add a receipt link or a short note whenever the amount might get questioned. A shared folder for receipt photos works fine.
- Record reimbursements in Settlements. Never enter one as a second grocery, utility, or rent expense.
Yes, this feels fussy at first. You're writing down the full purchase, the payer, the split, and then the reimbursement later, which looks like recording everything twice, and honestly that little bit of duplication is the entire point. It's what lets you tell a real expense apart from money that merely moved between two people.
Update the ledger weekly, then compare it against bank or card statements before the monthly review. A few minutes a week keeps the month from turning into an archaeology project.
Example of the settlement math
Here's the proportional example as it looks on the sheet:
| Item | Amount |
|---|---|
| Partner A income | $62,000 |
| Partner B income | $38,000 |
| Partner A share | 62% |
| Partner B share | 38% |
| Shared bill | $500 |
| Partner A target | $310 |
| Partner B target | $190 |
| Partner A pays the full bill | $500 |
| Partner B reimburses Partner A | $190 |
A paid $190 more than the agreed target. B sends $190, and the row gets marked settled. Done.
Once several bills pile up, skip the chase-the-coffee routine. Run the net for the month and settle the difference in one payment. One note on those income figures: they're only the basis you chose. Your Rules tab should say whether you're working from monthly take-home, annual income, or something else entirely.
Review and settle once a month
Put a short monthly appointment on the calendar. Thirty minutes covers a sheet this simple.
Turns out the formula is rarely the hard part. Deciding whether an unfamiliar charge belongs in the shared column is.
- Compare planned and actual totals by category.
- Confirm unusual charges against receipts or statements.
- Work out each person's target share and total paid.
- Record one net settlement when you can.
- If a recurring category keeps missing its target, change next month's plan.
The request itself can be plain: "You paid $190 below your target share for this month's shared expenses. Please send $190, and I'll mark it settled when it arrives."
Save the payment date and confirmation in Settlements. A bank transfer or payment app does the moving. The spreadsheet keeps the record.
Keep privacy and exceptions clear
Only the people entering expenses need edit access. If your spreadsheet tool supports protected ranges, lock the formula cells and leave the input cells editable. Never store passwords, security codes, or full bank account numbers in the file. Amounts and dates belong there. Credentials don't.
Shared savings trip people up more than groceries ever do. Give a savings goal its own row and write down its purpose, who actually holds the money, what it can be used for, and how contributions get handled if plans change. A few written lines now beat a tense conversation later.
Refunds go in as negative amounts, in the original category. Deposits, moving costs, and large one-off purchases deserve categories of their own. If a personal item gets paid from shared money by accident, pull it out of shared spending and record the repayment separately.
One boundary worth stating plainly. A spreadsheet can document payments and an agreement, but it doesn't settle ownership of a home, vehicle, furniture, or other property. State rules vary, so consider local legal advice when a large asset is involved. This record is for clarity. It isn't tax or legal advice.
Common questions
Equal and proportional splits
Neither method is automatically fairer. A 50/50 split is easy to run and easy to explain. An income-based split eases the relative burden on the lower earner, which matters when incomes diverge. Give either arrangement a month or two, then ask the question that actually counts: does it still feel workable in practice?
The variance column
With Actual - Planned, positive means spending exceeded the plan. Negative means you came in under.
Joint accounts
Unmarried couples don't need one. One person pays the bill, the other reimburses, and the spreadsheet documents both the original expense and the settlement. That's the whole loop.
One-off purchases
Agree on the rule before buying, not after the receipt exists. A shared purchase can be split by income, equally, by usage, or reimbursed after the receipt gets checked.
Start with this month's numbers
Decide early whether you'll duplicate a monthly tab and archive the old ones, or keep a single Actuals ledger with a Month column. To be honest, either approach works fine. What doesn't work is both at once, because two records that disagree are worse than one imperfect record.
Then just start. Create the file, enter the current income figures and recurring shared bills, and choose the split for each category. Log the first actual payment when it happens, and put any reimbursement in Settlements, not Actuals. That first settled row is the moment the system starts paying for itself.