A shared Google Sheets budget should show two things at once: whether the household is staying on plan and whether either partner has fronted more than their agreed share. What should actually go in it?

Use the fields and formulas below as a template you can copy into a blank sheet. It keeps the budget, expense split, and reimbursement record connected without mixing them together.

No paid template is required.

Use four tabs instead of one giant ledger

A single tab gets messy fast. Separate the planning work from the question of who owes whom.

Tab What it does Include
Settings Stores agreed rules and income shares Monthly contribution income, income-based percentages, category list
Transactions Records each purchase once Date, amount, payer, split rule, partner shares, notes
Monthly Budget Compares planned and actual category spending Category, planned amount, actual amount, remaining amount
Settle Up Calculates the reimbursement for a period Amount paid, assigned share, net balance, settlement log

Keep the first version boring. A plain record you both use beats a dashboard you avoid.

Build the transaction tracker

Start with the Transactions tab. Every later total pulls from it.

  1. Create a Settings tab with a row for each income period.

    Use these columns:

    A: Month start
B: Partner 1 contribution income
C: Partner 2 contribution income
D: Partner 1 income share
E: Partner 2 income share

    In D2, enter:

    =IFERROR(B2/SUM(B2:C2),0)

    In E2, enter:

    =IFERROR(C2/SUM(B2:C2),0)

    Use take-home pay or another contribution-income number you both agree on. The key is consistency. If income changes, add a new Settings row rather than overwriting an old one.

  2. Add the main transaction columns.

    Date | Description | Category | Amount | Paid by | Split rule | Partner 1 % | Partner 1 share | Partner 2 share | Settle up? | Notes or receipt link

    Use the same payer labels every time: Partner 1, Partner 2, or Joint. Make Settle up? a Yes or No dropdown.

    Mark Yes only when one partner paid from their own funds and the cost should affect the reimbursement balance. A bill paid from a joint account can still appear in the budget, but it will usually be marked No for settlement.

  3. Enter the percentage for each expense in the Partner 1 % column.

    For an equal split, enter 50%. For an income-based expense, copy the current Partner 1 income share from Settings and paste it as a value. For a personal expense, enter 100% for the person responsible and mark the row No under Settle up?

    That extra paste step feels fussy, but it stops old utility bills from changing after a later income change.

  4. Calculate each partner's assigned share.

    In H2 for Partner 1 share, enter:

    =IF(OR(D2="",G2=""),"",IFERROR(D2*G2,"Check %"))

    In I2 for Partner 2 share, enter:

    =IF(OR(D2="",G2=""),"",IFERROR(D2-H2,"Check %"))

    Format column G as a percentage and columns H and I as currency. Enter 60%, not 60, for a 60 percent split.

  5. Create a Monthly Budget tab.

    Put the first day of the month in B1. List categories such as Housing, Utilities, Groceries, Dining Out, Transport, Household, and Personal in column A.

    If categories start in A3, use this formula in C3 to total actual spending for that category:

    =SUMIFS(Transactions!$D:$D,Transactions!$C:$C,$A3,Transactions!$A:$A,">="&$B$1,Transactions!$A:$A,"<"&EDATE($B$1,1))

    Put the planned amount in column B. In column D, calculate the amount left with =B3-C3.

    Category names must match exactly. "Groceries" and "Grocery" will be treated as two different categories.

Decide what a fair split means before anything is paid

Thing is, a formula cannot make a split fair. It can only apply the rule you agreed to.

Split rule When it can fit What to enter in Partner 1 %
Equal Incomes, use, and expectations are similar 50%
Income-based Take-home incomes differ and you want contributions tied to ability to pay Copy the current Settings percentage
Usage-based One person regularly uses more of a shared cost Enter the documented usage percentage
Per person or nights stayed Guests, travel, or temporary living arrangements affect the cost Divide Partner 1's people or nights by the total
Room-size based You and a partner share a home with roommates and space is part of the agreement Enter the agreed room-size percentage
Personal Only one person benefits from the purchase 100% or 0%, then mark Settle up? as No

For example, if Partner 1's agreed contribution income is $6,000 and Partner 2's is $4,000, the split is 60 percent and 40 percent. A $200 shared bill becomes $120 for Partner 1 and $80 for Partner 2.

Income-based sharing is a contribution rule, not a judgment about either person. Write down any exceptions before they become a receipt-sized disagreement. A note such as Rent and utilities use 60/40; meals out are personal unless agreed; guest groceries split per person is enough.

Keep the monthly budget separate from the IOU

Your Monthly Budget tab answers, "How much did we spend?" The Settle Up tab answers, "Who paid more than their share?" Those are different jobs.

A reimbursement is not a new grocery expense. Log the original grocery purchase once in Transactions, then log the later repayment in the Settlement Log. Otherwise, food spending gets counted twice.

You can use several budgeting styles with the same transaction tracker.

Planning style How it works in a shared sheet Watch for
50/30/20 Uses a rough target of 50 percent for needs, 30 percent for wants, and 20 percent for savings and debt payments It helps with planning but does not decide how bills are split
Zero-based Gives every available dollar a job before the month begins It needs regular updates when plans change
Envelope-style Sets a spending cap for categories such as groceries or dining out It works best when both partners treat the category limit as real

Pick the planning style that makes conversations easier. The split rule still belongs on each expense row.

Settle up at a predictable time

Choose a recurring time to review the sheet, such as the end of the month. Both partners should add missing purchases, review anything unclear, and confirm the reimbursement balance before anyone sends money.

On the Settle Up tab, enter the start date of the review period in B1 and the first date after that period in B2. Then use these formulas for Partner 1:

B4: =SUMIFS(Transactions!$D:$D,Transactions!$E:$E,"Partner 1",Transactions!$J:$J,"Yes",Transactions!$A:$A,">="&$B$1,Transactions!$A:$A,"<"&$B$2)

B5: =SUMIFS(Transactions!$H:$H,Transactions!$J:$J,"Yes",Transactions!$A:$A,">="&$B$1,Transactions!$A:$A,"<"&$B$2)

B6: =B4-B5

B4 is what Partner 1 paid directly. B5 is Partner 1's assigned share. A positive result in B6 means Partner 1 covered more than their share, so Partner 2 owes that amount.

Repeat the calculation for Partner 2 using the Partner 2 payer label and the Partner 2 share column. The two net balances should offset. If they do not, check payer names, settlement flags, and percentage entries before settling.

Turns out, a short settlement log is useful even when repayment happens immediately. Record the period, sender, recipient, date, amount, and a confirmation note.

I see a balance for this month. Can we check the items marked "Needs review" before we settle?

The sheet tracks the agreement. Any actual payment happens separately through the method you both choose.

Share the sheet without sharing everything

Share the sheet directly with your partner's email rather than using an open link if the file includes income details, recurring bills, or receipt records.

Protect formula columns H and I, along with the summary formulas on Monthly Budget and Settle Up. In Google Sheets, use Data > Protect sheets and ranges while leaving your input columns editable.

Protected ranges prevent routine formula edits. They do not make sensitive details private from people who already have access. Keep passwords, bank account numbers, card numbers, and login details out of the spreadsheet.

Receipt links can also reveal more than you expect. A brief note such as Target household items, receipt saved may be enough.

Fix the mistakes that make a shared budget feel wrong

Mistake Why it causes trouble Better approach
Entering 60 instead of 60% The assigned share becomes far larger than intended Format the cell as a percentage and enter 60%
Letting old rows reference a live income percentage Past balances shift when the Settings tab changes Paste the percentage as a value for each expense
Recording a repayment as another expense Spending totals are doubled Log the purchase once and the repayment in Settlement Log
Marking a joint-account bill for settlement The sheet can show a reimbursement that is not really due Mark it No unless you have a separate contribution rule
Using inconsistent payer names SUMIFS formulas fail to match entries Use dropdowns for Partner 1, Partner 2, and Joint

A balance that looks wrong should pause the settlement, not start an argument.

Start with one recent shared bill

Build the four tabs, then enter one recent grocery, utility, or household purchase. Choose the split rule, add the percentage, and confirm that the two assigned shares equal the transaction amount.

That one row will show whether the setup makes sense for both of you. Add the rest of the current month only after the rule feels clear.