Use a free Google Sheets template with columns for Date, Description, Category, Amount, Split Type (such as 50/50, proportional, or reimbursement), Split % (for Person 1), Person 1 Share, and Person 2 Share. Apply formulas like =AmountSplit% for Person 1 Share and =Amount(1-Split%) for Person 2 Share to calculate splits automatically, as suggested by expensesorted.com. Share the sheet via an edit link for real-time collaboration between spouses, and review weekly during a short check-in to log expenses and settle balances.

This setup helps married couples in the U.S. track joint household costs like utilities, groceries, rent, and one-off purchases without paid apps. It supports equal splits for similar incomes or proportional shares for uneven earnings, plus simple reimbursement tracking.

Choose Your Split Method Before Building the Template

Married couples often face different income levels or spending habits, so pick a split method that fits your situation before setting up the sheet. Common options include equal splits, proportional splits based on income, and reimbursements for individual purchases.

For equal splits, use 50/50 on all shared expenses. This works when incomes and usage are similar, such as splitting groceries or streaming subscriptions evenly.

Proportional splits adjust shares by income percentage. For example, if one spouse earns 60% of combined income, they cover 60% of bills. Expensesorted.com recommends a Split % column for this, where Person 1's percentage is their income divided by total income.

Reimbursements suit one-off items, like one spouse buying furniture. Mark it as 100% for the payer and 0% for the other, per expensesorted.com's roommate template adaptable for couples.

Decision tree: If incomes are close, go equal. If one earns significantly more and you want fairness, use proportional. For personal purchases from joint funds, track as reimbursement. Discuss and agree upfront to avoid disputes.

Set Up the Core Spreadsheet Template

Start with a new Google Sheet at sheets.google.com. Name it "Couple Expenses 2026" and add two tabs: "Expenses" and "Incomes".

On the Incomes tab, add columns for Person 1 Income and Person 2 Income. Enter monthly or annual figures, such as $4,000 and $6,000. Calculate total income in a cell with =SUM(B2:C2) and Person 1 Split % as =B2/(B2+C2), formatted as percentage. This feeds into the Expenses tab, per addtosheets.com guidance on couple budgets.

On the Expenses tab, set up these columns starting in row 1:

  • A: Date (format as MM/DD/YYYY)
  • B: Description (e.g., "Electric bill")
  • C: Category (use specific terms like "groceries" instead of "eating out" to match real spending, as advised by expensesorted.com)
  • D: Amount (currency format)
  • E: Split Type (dropdown: 50/50, Proportional, Reimbursement)
  • F: Split % Person 1 (pull from Incomes tab or enter manually, e.g., 40%)
  • G: Person 1 Share (=D2*F2)
  • H: Person 2 Share (=D2*(1-F2))

Add a totals row at the bottom with =SUM(G:G) for Person 1 total and =SUM(H:H) for Person 2. Protect formula columns: Select G:H, right-click, Protect range, and set only you and your spouse as editors.

Copy this structure for monthly tabs if preferred, like "Jan 2026".

Add Formulas for Automatic Share Calculations

Formulas keep shares accurate without manual math. In the Split % column (F), link to the Incomes tab for proportional splits: =Incomes!F2 (assuming F2 holds the calculated percentage).

For Person 1 Share (G2): =D2F2
For Person 2 Share (H2): =D2(1-F2)

These come from expensesorted.com's family budget approach. For 50/50, set Split % to 0.5. For reimbursements, enter 1 or 0 in Split % and note "Reimb" in Split Type, as in their roommate template.

Add monthly summaries: In a Summary tab, use =SUMIF(Expenses!E:E,"Proportional",Expenses!G:G) to total proportional shares per person.

Format conditionally: Highlight negative balances (if tracking owed amounts) in red via Format > Conditional formatting.

Test with examples: $200 groceries at 40/60 split yields $80 and $120. This automates fairness for uneven incomes.

Share and Collaborate Securely with Your Spouse

Click the Share button (top right). Enter your spouse's email, select Editor, and notify them. For a template link, choose "Anyone with the link" as Editor, then share - recipients can copy via File > Make a copy.

Google Sheets supports real-time collaboration, so both can edit simultaneously and see live changes, per expensesorted.com. Up to 100 users with edit access can work at once, though Tiller notes limits may apply beyond that for non-owners.

If view-only, use the Request edit button. Protect key ranges (Data > Protect sheets and ranges) to prevent accidental formula overwrites while allowing data entry.

Track changes via File > Version history > See version history. This logs who edited what and when, as covered by addtosheets.com. Ideal for spouses questioning entries.

Tiller Help Center details requesting edits and protections for shared sheets.

Establish a Weekly Review Workflow

Set a recurring 10-minute check-in, like Sunday evenings, to stay current. Expensesorted.com suggests this for families: gather receipts, log new expenses, verify shares, and note owed amounts.

Script:

  1. Open the sheet together.
  2. Add recent items: "Any new bills or groceries?"
  3. Check totals: "Person 1 owes $50; Person 2 owed $30 - settled?"
  4. Adjust Split % if incomes change.
  5. Plan ahead: "Next utilities due - budget enough?"

Export via File > Download > PDF for records. Transfer balances via your bank or cash, noting the date in a Balances tab. This prevents buildup and builds trust.

Common Mistakes and When to Use an App Instead

Avoid vague categories like "misc" which hide spending patterns - use specifics per expensesorted.com. Don't skip protections, as edits can overwrite formulas. Always check version history for disputes.

Forgetting weekly reviews leads to imbalance surprises. Test formulas with sample data first.

Spreadsheets work well for two spouses with no payment needs: free, customizable, private. They suffice for tracking reimbursements and rules without app accounts.

Consider apps for larger groups, receipt scanning, or reminders, but they may add complexity. For couples, a sheet often matches needs without extras. In the U.S., keep records for personal reimbursements; consult a tax pro for any IRS questions, as rules vary.

FAQ

How do I calculate proportional splits based on income in Google Sheets?

Enter incomes in a separate tab, calculate Person 1 % as Income1/(Income1+Income2), and reference it in the Split % column for =Amount*Split% shares, per expensesorted.com.

What's the best way to handle one spouse covering a full expense for reimbursement?

Use Split Type "Reimbursement", set payer's Split % to 1 (100%) and other's to 0; track until settled, as in expensesorted.com templates.

Can both spouses edit the sheet at the same time?

Yes, with Editor access, Google Sheets updates live in real-time for simultaneous edits.

How many people can collaborate on a shared Google Sheet?

Up to 100 with edit access can work simultaneously, per Tiller guidance.

How often should we review the shared expense tracker?

Weekly, such as a 10-minute Sunday check-in to log and balance, as recommended by expensesorted.com.

When is a spreadsheet better than a paid split-bill app for couples?

For simple tracking without payments or scanning, especially with custom splits - free and private for two people.