Use a Google Sheets template with monthly tabs, a summary dashboard, split percentage columns, and Editor sharing for a mobile-friendly couples budget tracker. This setup works on the Google Sheets app for iOS or Android, letting both partners add expenses like rent, groceries, or utilities from phones with real-time updates visible instantly.
U.S. couples can track shared expenses, uneven income splits, recurring bills, and reimbursements without paid apps. Start with essential columns for date, description, amount, category, who paid, split percentage, and running balance. Create tabs for each month like "Jan 2026" and a summary sheet that pulls data dynamically. Share via Google account with Editor access for collaboration.
This approach suits couples handling joint budgets, IOUs, or proportional shares based on income. It keeps records clear for discussions on separate accounts or contribution rules.
Recommended Columns for Couples Shared Budget
Tailor columns to couples' needs, including even splits, uneven shares, or full reimbursements. Editorial templates from Expensesorted.com suggest adding a "Split %" column next to expenses for proportional shares, such as 60/40 based on income.
Use these core columns in each monthly tab:
| Column | Purpose | Example |
|---|---|---|
| Date | When expense occurred | 2026-01-15 |
| Description | What was bought | Grocery run at Costco |
| Amount | Total cost | $125.50 |
| Category | Type of expense | Groceries |
| Paid By | Who covered it | Partner A |
| Split % (Partner A) | Their share | 60% |
| Split % (Partner B) | Their share | 40% |
| Balance (Partner A) | Running total owed | -$25 (negative if overpaid) |
| Balance (Partner B) | Running total owed | +$25 |
For reimbursements, set one split to 100% and the other to 0%, as noted in an Expensesorted.com roommate template. This flags who owes whom without separate rows.
Calculate shares with simple formulas. In a "Share A" column: =IF(F2<>"", D2*F2, "") (assumes F2 is Split % as decimal like 0.6). Track balances by adding or subtracting shares from a prior balance cell. For category consistency, use exact matches like "Groceries" everywhere - mismatches like "Food" vs. "Groceries" break sums, per Spreadsheetpoint.com guidance.
Add categories relevant to couples: Rent, Utilities, Groceries, Dining Out, Subscriptions, Gas, Entertainment, Reimbursements. This setup handles recurring bills and one-offs.
Setup Steps for Mobile-Friendly Template
Create the template in Google Sheets for free mobile access via the app.
-
Open Google Sheets on desktop or mobile. Start a new blank sheet named "Couples Budget 2026".
-
Add monthly tabs: Right-click the bottom tab > Insert sheet. Rename to "Jan 2026", "Feb 2026", etc. Enter headers in row 1 across all tabs.
-
Input sample data in columns A-I starting row 2. Format Amount as currency (Format > Number > Currency).
-
Add formulas for automation:
- Share for Partner A (column G):
=IF(F2<>"", D2*F2, "")(assumes F2 is Split % as decimal like 0.6). - Running balance for Partner A (column I, row 2):
=-G2. For row 3+:=I2 - G3. - Similar for Partner B.
- Share for Partner A (column G):
-
Create a Summary tab: Insert new sheet, rename "Summary". List categories in column A. Use SUMIF for totals, e.g.,
=SUMIF('Jan 2026'!D:D, A2, 'Jan 2026'!D:D)for "Groceries".
For dynamic month selection, as in a Spreadsheetpoint.com expense tracker, enter month name in Summary cell C3 like "Jan 2026". Reference data with INDIRECT: =SUMIF(INDIRECT(C3&"!D:D"), A2, INDIRECT(C3&"!D:D")). Charts on Summary update automatically when changing C3.
Format for mobile: Freeze row 1 (View > Freeze > 1 row), use bold headers, and short descriptions. Test on the Sheets app - tap cells to edit, swipe tabs.
Set update cadence: Add expenses daily or weekly to keep balances current.
Sharing and Collaboration for Couples
Google Sheets enables real-time edits from phones, ideal for couples.
Click the Share button (top right). Enter your partner's Google account email. Set to Editor - allows adding rows, editing cells, and seeing live changes. Both see color-coded cursors for who's typing.
As described in Spreadsheetpoint.com and Expensesorted.com, Editor access supports simultaneous updates. Partner A adds a grocery receipt; Partner B sees it instantly and adjusts the split.
On mobile, open the shared link in the Sheets app. No extra apps needed. Revoke access anytime via Share settings.
Common Mistakes and Fixes
Avoid these pitfalls for reliable tracking.
-
Inconsistent categories or tab names: "Groceries" vs. "Food" or "Jan2026" vs. "Jan 2026" breaks SUMIF formulas. Fix: Standardize names across tabs before formulas, as Spreadsheetpoint.com and Expensesorted.com note - exact matches required.
-
Wrong permissions: Viewer or Commenter blocks edits. Fix: Confirm Editor access; test by having partner add a row.
-
No regular check-ins: Balances drift without reviews. Fix: Schedule 10-minute weekly updates, like Sunday evenings, per Expensesorted.com family template suggestions.
-
Overcomplicating formulas: Start simple; add INDIRECT later. Mobile entry is easier without nested functions.
-
Forgetting receipts: Note where stored (e.g., shared Google Drive folder). Snap photos via phone camera, link in Description.
Backup monthly by downloading as Excel (File > Download).
When This Template Works vs When to Consider Apps
This spreadsheet suffices for most couples:
| Scenario | Use Spreadsheet | Consider Apps If |
|---|---|---|
| 2 people, simple splits | Yes - free, real-time, mobile | Group grows beyond 2 |
| Track only, manual payments | Yes - balances show IOUs | Need auto-payments or scans |
| Recurring bills, reimbursements | Yes - with categories and balances | Frequent cash/Venmo needs reminders |
| Uneven income shares | Yes - custom % columns | Complex rules or 10+ categories |
It excels for documentation: Export to PDF for records. Pair with receipt photos and payment app screenshots pasted into cells.
Switch to apps if needing built-in requests, scans, or notifications - but spreadsheets handle core tracking without blurring records and payments. For larger groups or travel, evaluate based on update habits.
FAQ
How do I access this on mobile?
Download the Google Sheets app (free on App Store/Google Play). Open the shared link - full edit access, including formulas and charts.
What if our splits are uneven by income?
Use Split % columns: Enter 60% for higher earner, 40% for other. Formulas auto-calculate shares, as in Expensesorted.com examples.
Do categories need to match exactly?
Yes - SUMIF requires exact text matches. Pick one term like "Groceries" and use it everywhere.
How often should we update?
Daily for accuracy, or weekly 10-minute check-ins to review balances, per editorial templates.
Can we track reimbursements?
Yes - set 100%/0% splits or negative amounts in Description. Balances show who owes what.
Is this tax advice?
No. For U.S. taxes, keep records for shared expenses but consult IRS guidance or a professional - rules vary by situation.
Next, build your sheet: Copy these columns into a new Google Sheet, share with your partner, and add last month's data to test balances.