Can a shared Google Sheet really run a monthly couples budget? It can. Use it to plan shared bills, record actual spending, calculate each person's share, and track reimbursements. You don't need an app just to keep the record straight.
Keep personal spending out unless you both agree it belongs. Thing is, the spreadsheet only works if the rules are clear. Agree on the expense boundary and the split method first, before any numbers go in.
Decide what belongs in the shared budget
Name the expenses you want to manage together. Rent, utilities, groceries, and agreed recurring bills usually belong in the shared ledger. Hobbies, clothing, gifts, and personal debt can stay separate. Both of you draw that line, not one of you.
Do this before entering a single number.
| Split method | How it works | Works better when | Watch for |
|---|---|---|---|
| 50/50 | Each partner pays half | Incomes and spending patterns are similar | The same dollar amount can feel very different to each partner |
| Income-proportional | Each partner pays according to their income share | Incomes differ | You need current income figures and a consistent income basis |
| Category-based | Different categories use different rules | You want rent proportional but groceries equal | More rules require better documentation |
| Yours-mine-ours | Each partner contributes an agreed amount to shared costs | You want predictable shared funding and separate personal money | The contribution may need regular review |
With proportional splitting, one decision comes first: net or gross income. Pick a basis and stick with it. If Partner A earns 60% of the household income, A covers 60% of a $500 shared bill, which is $300, and Partner B covers the remaining $200.
That example is simple on purpose. If A paid the whole bill, B's reimbursement is $200, not half. Half would be wrong here.
Custom percentages can override the default anywhere. Rent might be proportional while a streaming subscription is 50/50. Write each rule into the sheet itself, not only into memory.
Create the workbook structure
Build four tabs inside one Google Sheets file:
| Tab | What it holds |
|---|---|
Income Summary |
Partner names, monthly income, and income shares |
Shared Expenses |
Planned amounts, actual charges, split percentages, and receipts |
Balances |
Totals showing who paid more or less than their share |
Rules |
Your expense boundary, split method, timing, and exception rules |
One workbook is a sensible starting point, and honestly it's enough at the start. Avoid a separate tab for every category. That usually makes monthly reconciliation slower.
Add the income and expense formulas
Put the income inputs in Income Summary first.
- Add
Partnerin A1,Monthly incomein B1, andIncome sharein C1. - Enter the two names in A2 and A3.
- Enter each partner's chosen income figure in B2 and B3.
- Label A4
Total household income, then enter=SUM(B2:B3)in B4. - Enter
=IFERROR(B2/$B$4,0)in C2 and copy it to C3. - Format C2:C3 as percentages.
Use one income basis for both partners. One take-home figure sitting next to one gross figure means the percentages aren't describing the same thing.
Set up Shared Expenses with these columns:
| Column | Purpose |
|---|---|
| Date | Date the expense was charged or paid |
| Category | Housing, utilities, groceries, and similar groups |
| Description | Payee or short explanation |
| Planned | Expected amount |
| Actual | Amount that posted |
| Split type | Proportional, 50/50, custom, or reimbursement |
| Partner A % | A's share for this row |
| Partner B % | B's share for this row |
| Partner A share | Formula-calculated amount |
| Partner B share | Formula-calculated amount |
| Paid by | Partner A, Partner B, or Shared account |
| Partner A paid | Amount A paid |
| Partner B paid | Amount B paid |
| Partner A balance | Amount A paid minus A's share |
| Partner B balance | Amount B paid minus B's share |
| Receipt link | Link to the saved receipt |
| Status | Open, Paid, or No reimbursement |
For a normal proportional row, set G2 to ='Income Summary'!$C$2 and H2 to ='Income Summary'!$C$3. Override those cells whenever a category runs on a different rule. The two percentages need to total 100%.
Add these formulas in row 2, then copy them down:
I2:=IFERROR(E2*G2,0)J2:=IFERROR(E2*H2,0)L2:=IF(K2="Partner A",E2,IF(K2="Shared account",I2,0))M2:=IF(K2="Partner B",E2,IF(K2="Shared account",J2,0))N2:=L2-I2O2:=M2-J2
A positive balance means that partner paid more than their assigned share. A negative balance means that partner owes money.
Take a $150 grocery bill that A pays under a 62/38 split. A's share is $93, B's share is $57, and B's balance lands at negative $57. The row shows the reimbursement clearly.
Over in Balances, total the two balance columns with =SUM('Shared Expenses'!N2:N) and =SUM('Shared Expenses'!O2:O). Use data validation for the Paid by column. Protect the formula columns, I:J and L:O, and leave the entry cells editable.
Share the file only with your partner's account. Editor access makes sense if you'll both enter transactions. Google's Drive sharing guidance covers the available access controls.
Keep planned and actual spending separate
Treat planned and actual as two different facts. Planned is the target. Actual is what the bill or purchase cost. Never overwrite a planned amount after a bill changes, because that gap is what makes the monthly review useful.
A summary area can use =SUM('Shared Expenses'!D2:D) for planned spending and =SUM('Shared Expenses'!E2:E) for actual spending. Subtract actual from planned to see the remaining amount or the overage.
If one ledger stores several months, add a Month column or filter by date before you sum. May and June will blur together otherwise. A single monthly file is simpler when you don't need a long history.
Build a receipt and reimbursement workflow
Create a shared Google Drive folder named Receipts - [Month Year]. Save a clear photo or PDF for each shared charge, then connect that file to the matching row. Blurry photos aren't much better than none.
The routine is small:
- Record the date, payee, amount, and category.
- Add the receipt link in the
Receipt linkcell. - Check that the split percentages total 100%.
- Mark the row
Openuntil the reimbursement is complete. - Change the status to
Paidafter the transfer is confirmed.
A receipt supports the row. It doesn't replace the row. Keep private account numbers and unrelated personal details out of the description.
When you need the money back, the message can be one line: "I paid $150 for groceries. Your share is $57, and the receipt is linked." The sheet remains the record of the calculation and its status.
Use a short review cadence
Turns out, a small review is easier to repeat than a large financial meeting.
| Cadence | What to do |
|---|---|
| Weekly, about 10 minutes | Add missing transactions, attach receipts, and resolve unclear categories |
| Monthly | Compare planned with actual spending and settle open balances |
| When income or bills change | Update future split percentages or planned amounts |
Settle balances on a schedule you both accept. Weekly transfers keep amounts small. A monthly settlement may be easier for recurring bills.
Review unusual charges before marking them paid. Both partners get a chance to correct a category or split while the transaction is still familiar.
Write down the rules for exceptions
Use the Rules tab for decisions that would otherwise get re-argued every month. It should state what counts as shared, whether income means gross or take-home pay, how personal charges are handled, when reimbursements are due, and which unusual purchases need both partners' approval.
If an expense is personal, exclude it from the shared totals. When a personal charge hits a shared account anyway, record a separate reimbursement rather than hiding it inside groceries or utilities.
Income changes go into the summary for future rows. Leave a closed month's figures alone unless you're correcting a clear error. Past reimbursements stay understandable that way.
One extra note about shared-account rows. The formulas above treat each partner's assigned share as paid when Shared account is selected. They track the expense allocation, not who funded the account. Add a separate deposit column or tab if that distinction matters to you.
Common questions
Should every shared expense use income percentages?
No. Use the method you both agreed to. A couple might run proportional rent, 50/50 groceries, and separate personal purchases all in one system.
What if one partner has irregular income?
Choose a contribution rule you can update consistently. An agreed fixed amount or a category-based split often works better than changing percentages after every payment.
Can a spreadsheet replace a payment app?
For recordkeeping, yes. A spreadsheet can track expenses, calculate shares, link receipts, and record reimbursements. Paying is a separate step. A payment app may be convenient, but the system doesn't require one.
What should happen when a refund arrives?
Record the refund as a negative amount and add a note showing where the money went. If it changes an earlier reimbursement, update the balance and explain the adjustment right in the row.
Build the four tabs, enter one recent month of shared charges, and test a single grocery row from start to finish. Then schedule your first 10-minute review before adding more categories.