How Couples Can Share One Budget Spreadsheet

A shared budget spreadsheet for couples works when it answers three questions without an argument: what did we spend, who paid, and who owes whom. Use one Google Sheet, add a Paid by column and an Owner column (Mine, Yours or Ours), and let each partner log from their own phone. Then a single formula settles up at month end. Here's how to set it up.

Joint, separate or proportional: pick a structure first

Before you build any columns, agree on how shared costs get paid. The spreadsheet just records the deal; it can't make it for you. These are the three common set-ups:

Many couples land on a hybrid: a proportional split for rent, bills and groceries, plus personal money each partner spends without needing to justify it. That's the "yours, mine, ours" model, and it's what the sheet below is built for.

How the proportional split works

Add up both take-home incomes, then divide each by the total. If Sam takes home $5,000 a month and Alex $3,000, Sam covers 62.5% of shared costs and Alex 37.5%. On $3,200 of shared monthly costs, that's $2,000 from Sam and $1,200 from Alex. Both are left with personal money in proportion to what they earn, which is why this split tends to feel fairer than 50/50.

How do couples share one budget spreadsheet?

Here's the set-up, start to finish. If you've never built an expense sheet, the guide to tracking expenses in Google Sheets covers the basics first.

1. One person creates the sheet with two tabs: Expenses and Settings.
2. Add the columns to Expenses: Date, Category, Amount, Paid by, Owner, Notes.
3. Add dropdowns to Category, Paid by (both names) and Owner (both names, plus Ours) with Insert → Dropdown.
4. Put both incomes on Settings and calculate each person's share.
5. Share the sheet with your partner as an Editor.
6. Both of you log every purchase from your own phone, the day it happens.
7. Meet once a month to review and settle up.

The columns that make it work

Paid by and Owner are separate on purpose. Sam might buy Alex's new running shoes (Paid by: Sam, Owner: Alex), or Alex might pay the electricity bill (Paid by: Alex, Owner: Ours). Mixing the two into one column is the most common reason shared sheets stop adding up. "Mine" and "Yours" change meaning depending on who's typing, so use names in the Owner dropdown: Sam, Alex, Ours.

Keep the category list short, seven to ten items. The guide to dropdown categories in Google Sheets shows how to set them up so nobody types "Grocery" one day and "groceries" the next.

The Settings tab

For a 50/50 split, type 0.5 in B4 and B5 and skip the incomes.

The settle-up formula

This is the cell that ends "I think I paid more this month." Assuming Expenses has Date in A, Amount in C, Paid by in D and Owner in E:

If B10 is positive, Alex owes Sam that amount. If it's negative, Sam owes Alex. If Sam paid $1,000 of shared costs and Alex paid nothing, Alex owes 37.5% of $1,000, which is $375.

Personal purchases the other partner paid for need one more line. For example, Sam paid for something Owner: Alex:

=SUMIFS(Expenses!C:C, Expenses!D:D, "Sam", Expenses!E:E, "Alex", Expenses!A:A, ">="&B6) - SUMIFS(Expenses!C:C, Expenses!D:D, "Alex", Expenses!E:E, "Sam", Expenses!A:A, ">="&B6)

Add that to B10 and you have the full monthly balance. For more on date ranges in SUMIFS, see SUMIFS by month in Google Sheets.

Sharing permissions and logging from two phones

In Google Sheets, click Share, add your partner's Google account and choose Editor. Both of you can now add rows at the same time, and each sees the other's entries almost immediately. A few habits keep a shared sheet healthy:

• Protect the formulas. Use Data → Protect sheets and ranges on the Settings tab so a stray tap on a phone doesn't overwrite B10.
• Use version history. File → Version history shows who changed what. It's useful when a total suddenly looks wrong.
• Don't share bank logins. Each partner logs their own purchases; nobody needs the other's banking password, and no app needs either. Our piece on whether it's safe to link your bank to a budgeting app explains why that's worth keeping separate.
• Agree on one currency. If one partner is paid in a different currency, convert before logging so the totals mean something.

The weak point of any shared budget is the logging, not the formulas. If one partner logs everything and the other "will do it later", the settle-up number is wrong and the monthly review turns into a reconstruction exercise.

Voice Sheet is one way to make logging equal. It's an iPhone and Android app that writes each entry as a new row in your own Google Sheet, through Google Sheets sync, with no bank connection and no Voice Sheet database of your entries. Share the sheet from Google Drive, and each partner connects to it from their own phone. The partner who didn't create the sheet should switch Voice Sheet to full access in Settings, so it can see spreadsheets it didn't create. The form is built from your header row, so Paid by and Owner appear as fields with your dropdown options. Either of you can use voice entry (3 a day free, unlimited with Premium) and say "groceries 82.40 ours paid by Sam" instead of typing it.

The monthly money date

A shared budget spreadsheet for couples only pays off if you look at it together. Pick a fixed time, such as the first Sunday of the month, and keep it to 30 minutes:

1. Check the gaps. Scroll the month's rows. Anything missing? Log it now.
2. Compare spending to budget per category. What went over, and was it a one-off?
3. Read the settle-up cell and transfer the amount. Then it's done for the month.
4. Update incomes on Settings if either changed, so next month's split is right.
5. Agree on one change for next month. One, not five.

Keep the tone factual. The sheet shows what happened; it isn't a scorecard. Couples who use a zero-based budget often do this step before the month starts, giving every shared dollar a job together.

If you use Voice Sheet's Personal Finances template, its budget dashboard shows spending against budget per category for the current month and resets on the 1st, which lines up neatly with a monthly money date. The Google Sheets templates page shows the template's Expenses, Income and Monthly Budget tabs; add your Paid by and Owner columns to the Expenses tab, then refresh the form in the app.

One sheet, two phones, no arguments

A shared budget works when the rules are agreed before the spending starts. Pick joint, 50/50 or proportional. Tag every row with who paid and whose cost it is. Let the settle-up cell do the maths, and meet once a month to look at the month together. The spreadsheet stays yours, in your own Google Drive, and neither of you has to hand a bank login to anyone.