Use this free Google Sheets template setup for couples to track shared expenses. Add columns for Date, Description, Amount, Category, Split %, Person 1 Share, Person 2 Share, and use formulas like SUMIFS for totals and QUERY for category summaries, drawn from editorial examples on expensesorted.com, addtosheets.com, and relayfi.com.

This approach helps U.S. couples handle joint budgets, uneven income splits, recurring bills like rent and utilities, and reimbursements without paid apps. Start with a blank sheet, input expenses such as $1,200 rent or $150 groceries, apply splits, and review weekly. Real-time edits let both partners update simultaneously with edit access.

Recommended Columns for Couples Budget Tracker

Essential columns capture shared expenses, individual contributions, and balances for couples. Editorial examples suggest these for clear tracking.

Start with core columns:

  • Date: Entry date, like 01/15/2026.
  • Description: Item details, such as "February rent" or "grocery run at Costco".
  • Amount: Total cost, e.g., $1,200.
  • Category: Group like "Rent", "Groceries", "Utilities", "Travel", or "Reimbursement".

Add split columns for shares:

  • Split %: Percentage for proportional splits, such as 60% for Person 1 and 40% for Person 2 based on income (expensesorted.com). For equal splits, use 50%/50%.
  • Person 1 Share: Formula-calculated, e.g., =C2 * (split percentage for Person 1).
  • Person 2 Share: Similar formula for the other partner.

For income-based tracking, include separate columns or a second sheet with:

  • Person 1 Income: Monthly or weekly totals.
  • Person 2 Income: Same for the partner (addtosheets.com).

Handle reimbursements by marking the row as "Reimbursement" in Category or a new Split Type column, assigning 100% to the payer and 0% to the other (expensesorted.com). This flags IOUs clearly, like Person 1 paying $300 for dinner with Person 2 owing full reimbursement.

Example row for rent: Date 02/01/2026, Description "Rent", Amount $2400, Category "Rent", Split % "60/40", Person 1 Share $1440, Person 2 Share $960.

A Balance column sums ongoing owes, using =SUMIFS for Person 1 Share minus their income contributions. This setup supports equal splits, income-proportional (e.g., higher earner pays more), or usage-based (e.g., one drives more, covers gas).

Key Formulas for Expense Splits and Summaries

Copy-paste these editorial example formulas to automate calculations. Test them in your sheet, as ranges like A2:D100 adjust to your data.

For individual shares:

  • Person 1 Share: =IF(E2="Equal", C2/2, IF(E2="60/40", C2*0.6, C2)) - Adjust percentages for your split rule (relayfi.com).

For category totals with conditions, like travel expenses:

  • =SUMIFS(B2:B100, D2:D100, "Travel", F2:F100, "Yes") sums amounts where category is Travel and another condition matches (relayfi.com).

For full category summaries:

  • =QUERY(A2:D100, "SELECT C, SUM(D) GROUP BY C LABEL SUM(D) 'Total'") lists each category and its total spend (relayfi.com).

Running totals for Person 1 balance:

  • =SUM(G$2:G2) - SUM(IncomeSheet!B$2:B2) assuming G is Person 1 Share and a separate Income sheet.

These keep totals dynamic. For reimbursements, a simple =IF(D2="Reimbursement", "Pending", "") flags open items.

Step-by-Step Setup in Google Sheets

  1. Go to sheets.google.com and click Blank to start a new spreadsheet. Name it "Couples Budget 2026".

  2. Row 1: Enter headers - Date (A), Description (B), Amount (C), Category (D), Split % (E), Person 1 Share (F), Person 2 Share (G), Balance (H).

  3. Input sample data in rows 2-5: e.g., Row 2: 01/15/2026, Utilities, $180, Utilities, 50/50, leave F/G blank for formulas, $0.

  4. Add formulas: In F2, =C2 * 0.5 for equal split (edit for your %). Copy down. In H2, =SUM($F$2:F2) for running Person 1 balance.

  5. Create a second sheet named "Income": Columns A: Month, B: Person 1 Income, C: Person 2 Income. Link to main sheet balances.

  6. Format: Bold headers, currency for amounts, data validation for Category (dropdown: Rent, Groceries, etc.) via Data > Data validation.

  7. Test with real entries like $75 date night (Person 1 pays upfront, mark 100%/0%).

This draws from editorial setups on expensesorted.com for real-time collaboration - both partners see live changes with edit access.

Sharing the Template with Your Partner

Joint access requires edit permissions for updates.

Click the green Share button in the upper right. Add your partner's email, select Editor (for adding/editing data), and click Send. They get an email link to access (addtosheets.com).

For security, use specific emails over public links. Both can edit rows simultaneously, with changes appearing live (expensesorted.com).

Verify access: Partner opens the sheet and adds a test row. Revoke via Manage access if needed.

Weekly Review Workflow and Common Mistakes

Set a routine: Every Sunday evening, spend 10 minutes reviewing - compare balances, confirm reimbursements, add recurring bills like $120 utilities (expensesorted.com).

Steps:

  1. Pull up the sheet together (in-person or Google Meet).
  2. Scan new entries, run QUERY summary.
  3. Settle balances: "Person 1 owes $45 from groceries".
  4. Note rules, like "Groceries always 50/50".

Common mistakes:

  • Forgetting weekly reviews - balances drift without check-ins.
  • Mismatched permissions - viewer access blocks edits.
  • Untracked reimbursements - always use 100%/0% rows.
  • No backups - File > Version history for changes.

Update cadence: Daily for active spenders, weekly for most couples.

When a Google Sheets Template Works vs. When to Consider Apps

Sheets work well for simple tracking and records - free, customizable, no account needs beyond Google. Ideal for couples with 10-50 monthly entries, joint rules, and manual reimbursements via Venmo/Zelle after proof.

Tradeoffs: Aspect Google Sheets Dedicated Apps
Cost Free Often subscription
Tracking Manual entry, formulas Auto-imports possible
Payments None; link externally Built-in requests
Records Export to PDF/CSV App exports
Collaboration Real-time edits Notifications

Use sheets if you prefer control, no app logins, and documentation for disputes. Consider apps for automated reminders or group requests beyond two people. Always keep receipts scanned or linked for proof.

FAQ

How do I handle uneven income splits in the template?
Add Person 1/2 Income sheets, set Split % to income ratio (e.g., 60/40), and calculate shares as Amount * ratio (addtosheets.com).

What if one partner pays upfront for reimbursement?
Mark Category "Reimbursement", Split % 100%/0%, track in Balance until settled (expensesorted.com).

Can multiple people edit at once?
Yes, with edit access, changes appear live for collaborators (expensesorted.com).

How often should we review the sheet?
Weekly 10-minute check-in keeps it current (expensesorted.com).

Are there limits to sharing Google Sheets for budgets?
Sharing works via email invites; check current Google help for details, as features evolve.

Does this template handle group travel or family expenses?
Yes, add rows for flights/hotels, use Split % for per-person or proportional; scale columns for more people.