A shared Google Sheet can handle most household expense tracking for two spouses. It shows what the expense was, who paid, how much each person agreed to cover, and whether the reimbursement is finished. That's the whole job.
Those are separate facts. Give each one its own column.
Ever seen a sheet where whoever swiped the card somehow ends up owing the entire bill? Keeping the facts apart prevents exactly that common mistake. You don't need a paid split-bill app for a simple system, but you do need one agreed rule and a regular check-in.
Decide what belongs in the shared budget
Settle the household rule before you touch formulas. A spreadsheet will divide any number you hand it. It can't decide whether a new couch or a solo dinner belongs in the joint budget, so pick the method that matches your situation:
| Rule | How it works | Good fit |
|---|---|---|
| 50/50 | Each spouse covers half of an eligible expense | Similar incomes or a deliberate equal-contribution plan |
| Proportional | Each spouse pays an agreed percentage of the expense | Uneven incomes where both want a similar percentage burden |
| Category-based | The rule changes by category | For example, groceries are 50/50 while rent follows income |
| One-person responsibility | One spouse covers 100% and the other covers 0% | A personal purchase or a cost both agreed belongs to one person |
| Reimbursement | One spouse pays from personal funds and receives the other spouse's agreed share later | Shared bills paid from separate checking accounts |
Reimbursement is a payment workflow, not a fairness method. You still have to choose the underlying split.
For an income-based split, divide each person's chosen income measure by combined income. Person 1 earns $4,000 and Person 2 earns $6,000, so the shares land at 40% and 60%. On a $200 expense, that's $80 and $120.
Decide between gross income and take-home income before setting the percentages. Use the same basis for both people, and update the rule whenever your household agreement changes.
Thing is, an income percentage decides how to divide an expense. It doesn't decide whether the expense is shared in the first place.
Create the three Google Sheets tabs
Open a blank spreadsheet and create these tabs:
SetupExpensesSummary
Stick with one dated Expenses tab for now. Monthly tabs look tidy, sure, but duplicated formulas are easier to break, and a single list makes filtering by month much simpler.
Setup tab
Enter these values:
| Cell | Label in column A | Entry in column B |
|---|---|---|
| B2 | Person 1 name | A name, such as Alex |
| B3 | Person 2 name | A name, such as Jordan |
| B5 | Person 1 monthly income | 4000 |
| B6 | Person 2 monthly income | 6000 |
| B7 | Combined income | =SUM(B5:B6) |
| B8 | Person 1 income share | =IFERROR(B5/B7,0) |
| B9 | Person 2 income share | =IFERROR(B6/B7,0) |
Format B5:B7 as currency. Format B8:B9 as percentages.
Then type the real names into the cells, spelled exactly as they'll appear in the Paid By column on the Expenses tab. If the spelling drifts, the formulas that match names later will miss rows.
Expenses tab
These headers go in row 1:
| Column | Header | What to enter |
|---|---|---|
| A | Date | Date the expense occurred |
| B | Description | Electric bill, groceries, or new lamp |
| C | Category | Rent, utilities, groceries, dining, or another specific label |
| D | Paid By | Person 1, Person 2, or Joint account |
| E | Payment Source | Personal or Joint |
| F | Amount | Total cost of the item |
| G | Split Type | 50/50, Proportional, Custom, Reimbursement, P1 only, or P2 only |
| H | Split % (P1) | Person 1's share as a percentage |
| I | Person 1 Share | Formula |
| J | Person 2 Share | Formula |
| K | Reimbursed | Amount transferred toward this expense |
| L | Status | Open, Partly settled, Settled, or Not applicable |
| M | Settled Date | Date the transfer was completed |
| N | Notes | Receipt reference, agreement, or transfer details |
Be strict about column E: it takes only the exact words Personal or Joint, because the balance formulas later match on those labels. Add dropdowns for Split Type and Status. Format column H as a percentage and columns F and I:K as currency, then set a validation rule on H that keeps entries between 0% and 100%.
Add formulas for automatic share calculations
Column H stores the percentage Person 1 agreed to cover. Use these entries:
| Split Type | Entry in H |
|---|---|
| 50/50 | 50% |
| Proportional | =Setup!$B$8 |
| Custom | The percentage you both agreed on |
| P1 only | 100% |
| P2 only | 0% |
| Reimbursement | The underlying agreed split, such as 50% or =Setup!$B$8 |
Watch the reimbursement row. Don't enter 100% just because Person 1 paid the bill; the Paid By column already records who fronted the money. H should hold the percentage that represents responsibility.
In row 2, enter these formulas:
| Cell | Formula |
|---|---|
| I2 | =IF(OR(F2="",H2=""),"",F2*H2) |
| J2 | =IF(OR(F2="",H2=""),"",F2*(1-H2)) |
Copy both down the sheet. A $200 expense with 40% in H produces $80 in I and $120 in J.
Protect columns I and J once you've tested them. Leave the input columns editable.
Here's the detail that sneaks up on people. If every proportional row uses =Setup!$B$8, changing the income figures later will also change old expenses. In a live budget that might be exactly what you want, but it can quietly rewrite your past records. To preserve history, enter the current percentage as a value when you log each row, or keep a separate percentage for each month.
Track reimbursements separately from expense responsibility
This is the part couples usually trip over. The person who swiped a card is not automatically responsible for the whole bill.
Use Paid By for the cash movement. Use Split % for the agreed responsibility.
| Expense | Paid By | Split | Shares | Result |
|---|---|---|---|---|
| $200 shared groceries | Person 1 | 50/50 | $100 and $100 | Person 2 reimburses Person 1 $100 |
| $200 utility bill | Person 1 | 40/60 | $80 and $120 | Person 2 reimburses Person 1 $120 |
| $75 personal purchase | Person 1 | P1 only | $75 and $0 | No reimbursement is due |
| $150 shared item | Person 2 | 50/50 | $75 and $75 | Person 1 reimburses Person 2 $75 |
Enter the actual transfer in Reimbursed, and leave it at zero or blank until money changes hands. If a transfer covers only part of the amount, enter the partial payment and mark the row Partly settled.
Once the transfer is complete, add the date and change the status to Settled. If one transfer covers several rows, allocate the amount across those rows and note the total in column N.
A 100%/0% row means one person owns the expense. It does not simply mean that person paid first.
The sheet records the agreement and the transfer. It doesn't move money.
Calculate the running balance
Add these labels and formulas to the Summary tab:
| Cell | Label | Formula |
|---|---|---|
| A2 | Person 1 net position | |
| B2 | Amount | =SUMIFS(Expenses!F:F,Expenses!D:D,Setup!$B$2,Expenses!E:E,"Personal")-SUMIFS(Expenses!I:I,Expenses!E:E,"Personal")-SUMIFS(Expenses!K:K,Expenses!D:D,Setup!$B$2,Expenses!E:E,"Personal")+SUMIFS(Expenses!K:K,Expenses!D:D,Setup!$B$3,Expenses!E:E,"Personal") |
| A3 | Person 1 owes Person 2 | |
| B3 | Amount | =MAX(0,-B2) |
| A4 | Person 2 owes Person 1 | |
| B4 | Amount | =MAX(0,B2) |
Read B2 this way: positive means Person 2 still owes Person 1, negative means Person 1 still owes Person 2.
The calculation assumes Reimbursed holds the actual transfer amount for each personal-funded expense. When Person 1 paid the original bill, the formula subtracts transfers received by Person 1. When Person 2 paid, it adds transfers Person 1 made to Person 2.
Joint-account purchases stay out of this personal reimbursement balance. They still appear in spending totals. If both spouses contribute to a joint account and you want to compare those contributions, add a separate contribution table rather than mixing account-funded purchases into personal reimbursements.
For category totals, place this formula on the Summary tab:
=QUERY(Expenses!A1:N, "select C, sum(F) where C is not null group by C label sum(F) 'Total'", 1)
It groups the amount column by category. Keep the labels specific, too, instead of putting every unclear purchase under Misc.
You can flag unusually large expenses as well. Select F2:F, open Format, then Conditional formatting, and use =F2>100. Treat $100 as your own review threshold, not a universal rule.
Share the sheet with care
Invite your spouse's Google account directly, with Editor access if you'll both be adding or correcting rows and Viewer access for anyone who only needs to read along, because the permission level you pick here decides what the other person can actually do. Google Sheets permission types and revision history are summarized in Tiller's sharing and permissions overview. For a private household record, skip the open edit link; it exposes more personal information than most couples need to share.
Protect the formula cells in Setup!B7:B9, Expenses!I:J, and the calculated cells on Summary. The menu path is Data, then Protect sheets and ranges, and this range protection walkthrough shows the basic process. That leaves the date, description, category, payer, split, transfer, and notes columns open for data entry. Protection reduces accidental overwrites. It isn't a substitute for careful sharing.
No bank passwords, full account numbers, or Social Security numbers in the sheet. If a number changes unexpectedly, review the edit under File, then Version history, then See version history.
For a reusable blank template, make a separate copy before adding household records. Share the blank copy, not the sheet containing your transactions.
Use a weekly check-in and monthly review
Set a short weekly check-in. Ten minutes is a reasonable target for a small household list, so work through the same moves each time:
- Add new bills, groceries, purchases, and receipts.
- Check the category, payer, payment source, split percentage, and status.
- Review rows marked Open or Partly settled.
- Record any transfer amount and settled date after payment.
- Once a month, review category totals and update the income percentages for new rows if your agreement has changed.
Turns out a settling threshold makes the routine easier. If you both agree, settle balances once they reach an amount such as $50 instead of sending a transfer for every small purchase. Where that line sits is a household rule.
Keep the monthly review focused. Ask which new costs are shared, which are personal, and whether the current split still feels workable. The spreadsheet should make that conversation easier, not replace it.
Fix common spreadsheet problems
| Problem | Better rule |
|---|---|
| The person who paid is assigned 100% automatically | Separate Paid By from the agreed split |
| A raise changes old expense shares | Save historical percentages as values |
| Joint-account purchases create a false debt | Mark the source as Joint and exclude those rows from personal balances |
| A formula is overwritten | Protect formula ranges and check version history |
| Categories are too vague | Use labels such as groceries, utilities, insurance, and dining |
| A transfer is made but not recorded | Enter the amount, date, and status on the related row |
| Monthly tabs contain different formulas | Start with one dated Expenses tab and filter it |
To be honest, the most damaging errors are usually ordinary omissions. A blank payer or missing transfer can make a correct formula look wrong.
Questions couples often ask
Is 50/50 automatically fair?
No single split works for every marriage. Equal shares are simple, and they can fit similar incomes or a deliberate equal-contribution plan. When incomes, usage, or responsibilities differ, a proportional or category-based rule may work better.
How do we split bills based on income?
Each person's income divided by the combined income gives the percentage. Enter it in Split % (P1) on proportional rows, then let the share formulas turn it into dollar amounts.
Should the payer be set to 100%?
No. Put 100% on a person only when that person is responsible for the entire expense. If one spouse paid a shared $200 bill, the payer gets its own column and the agreed split, say 50/50 or 40/60, goes in H.
Can we use the sheet if most bills come from a joint account?
Yes. Mark those rows as Joint so they don't appear as personal reimbursements. If you also want to compare how much each spouse adds to the joint account, use a separate contribution table for that.
Is a spreadsheet enough for two spouses?
It can be, as long as both people can enter transactions, agree on the rules, and record transfers. Consider another tool only if you need features the sheet doesn't provide, such as automated receipt capture or payment requests.
Start with five recent shared expenses, not the whole year. Enter the payer, source, split, and status for each one, then check the balance together. Fix the rule while the examples are still fresh.