Use Google Sheets for couples' shared expenses with separate income columns, a "Split %" column for proportional shares, real-time edit sharing via the "Share" button, version history for tracking changes, and a 10-minute weekly review to stay current. This setup helps U.S. couples handle joint bills, groceries, rent, utilities, travel costs, or reimbursements without apps for simple tracking.

Start with a new Google Sheet. Name tabs like "Expenses," "Incomes," and "Summary." Add columns in the Expenses tab for concrete tracking. Use real-time collaboration so both partners see updates live as they enter data.

Recommended Columns and Sheets for Couples' Shared Expenses

Set up your sheet with dedicated tabs for clarity. One approach uses separate sheets named "Person 1 Income" and "Person 2 Income" to log monthly or weekly earnings, as noted in addtosheets.com guidance on budget tracking for couples.

In the main Expenses tab, include these columns for shared costs:

  • Date: When the expense happened (e.g., 2026-01-15).
  • Description: What it was for (e.g., "February rent" or "Grocery run").
  • Amount: Total cost (e.g., 250).
  • Category: Group like "Rent," "Utilities," "Groceries," "Travel," or "Reimbursements."
  • Split %: Person 1's share (e.g., 60% for uneven income; 50% for equal; 100% for full reimbursement owed to one partner).
  • Person 1 Share: Formula-calculated (e.g., =C2*E2).
  • Person 2 Share: Formula-calculated (e.g., =C2*(1-E2)).
  • Paid By: Who covered it initially (e.g., "Person 1" or "Person 2").
  • Notes: Receipts link, payment confirmation, or details.

For reimbursements, add a split type in Notes or a new column marking it as "Reimbursement" with one person at 100% and the other at 0%, per expensesorted.com examples for expense splitting. Next to expenses, a "Split %" column calculates proportional shares automatically, as in expensesorted.com family budget setups.

Link income totals from their sheets to the Summary tab for running balances. This tracks who owes whom without manual math.

Key Formulas for Expense Tracking and Splits

Formulas update in real-time during collaboration. For Person 1 Share: =Amount * Split% (e.g., in G2: =C2*E2). Person 2 Share: =Amount * (1 - Split%).

Sum totals by category with =SUMIFS. Example from relayfi.com expense tracker: =SUMIFS(B2:B100, D2:D100, "Travel", F2:F100, "Yes") sums amounts (B) where category (D) is "Travel" and another condition (F) matches "Yes."

For category summaries, use =QUERY. Example: =QUERY(A2:D100, "SELECT C, SUM(D) GROUP BY C LABEL SUM(D) 'Total'") pulls categories (C) and totals amounts (D), as shown in relayfi.com.

In Summary, net balance for Person 1: =SUM(G:G) - SUM(their income column). These keep shares accurate for uneven incomes, like 60/40 based on earnings.

Sharing and Permissions Workflow

For couples, secure sharing ensures both can edit without issues. Open the file and click the green "Share" button in the upper right, then grant edit access to your partner, per Tiller's 2020 sharing guide. Note: Steps from 2020; check the current Google Sheets interface for updates.

For view-only access, click "get shareable link," select "anyone with the link can view," and copy it (Tiller). Google Sheets supports real-time collaboration - edit users see changes live, as in expensesorted.com roommate templates.

Avoid public links for finances. Use specific email invites for edit access. Addtosheets.com recommends sharing via the "Share" button for couple budgets.

Tracking Changes and Review Cadence

Google Sheets tracks edits via "File > Version history > See version history." This shows who changed what and when, helping resolve disputes (addtosheets.com).

Hold a 10-minute weekly check-in, like Sunday evenings, to review: Scan new expenses, confirm splits and payments, note reimbursements, and run summaries (expensesorted.com). Steps: (1) One partner pulls up the sheet. (2) Check recent rows. (3) Verify totals match bank statements or receipts. (4) Update incomes. (5) Note any owed amounts.

This cadence prevents buildup, especially for recurring bills or travel reimbursements.

Common Mistakes and When to Use Apps Instead

Couples often over-share by granting edit access too broadly - stick to partner emails only. Another pitfall: Skipping version history reviews, leading to unnoticed errors. Irregular updates cause imbalance confusion.

Spreadsheets work well for low-volume couples with 5-20 expenses monthly, like joint bills or occasional groceries. They suffice when you want free, customizable tracking with formulas and history.

Consider split-bill apps if you need receipt scanning, automated payment requests, or reminders for frequent reimbursements or multi-person trips. Apps separate tracking from paying; use sheets for records alongside. For two people with simple needs, sheets avoid app fees or learning curves.

FAQ

How do I set up proportional splits based on income in Google Sheets?
Add "Person 1 Income" and "Person 2 Income" sheets or cells. Use a "Split %" column (e.g., Person 1 income / total income). Apply =Amount * Split% for shares (addtosheets.com, expensesorted.com).

What's the step-by-step to share a Sheet for couple edits?
Click green "Share" button > enter partner's email > select "Editor" > send. For view-only, use "get shareable link" as "Viewer" (Tiller, addtosheets.com).

Can couples see changes live as they update expenses?
Yes, edit access users see real-time updates during collaboration (expensesorted.com).

How often should we review our shared expense Sheet?
A 10-minute weekly check-in, like Sundays, keeps it current (expensesorted.com).

What columns work best for tracking reimbursements?
Use "Split %" at 100% for the owed person, 0% for others; "Paid By" and "Notes" for proof (expensesorted.com).

When is a Google Sheet better than a split-bill app for couples?
Sheets suit simple, low-volume tracking with custom formulas and no fees. Apps fit if you add scanning or auto-requests.

Next, create your sheet with these columns and test a sample expense. Review weekly to build the habit.