Couples can set up a monthly shared budget using a Google Sheets template with income tracking, categorized expenses, a Split % column for proportional contributions based on income ratios, and a weekly 10-minute check-in, as outlined in expensesorted.com's family budget guide. This approach helps U.S. couples splitting rent, utilities, groceries, and recurring bills, especially with uneven incomes, through lightweight spreadsheet workflows.
Start by listing both partners' monthly incomes in a summary tab. Categorize expenses like housing needs and groceries. Assign a Split % to each line item based on income shares. Track planned versus actual spending. Review weekly to log updates and confirm contributions. This keeps records clear for reimbursements without needing apps.
Choose a Split Method for Your Shared Expenses
Couples often weigh equal splits against proportional ones for shared costs. A 50/50 split works when incomes match closely, but it can create imbalance if one partner earns significantly more. For example, sources note that equal splits lead to one partner spending a higher percentage of their income on household bills.
Consider proportional splits based on income ratios for fairness with uneven earnings. In one editorial example from innermostwealth.com, if total monthly expenses are $6,500 and Partner A provides 62% of household income, they contribute 62% or $4,008. Partner B, with 38% of income, covers 38% or $2,492. This keeps each partner's expense share closer to their income proportion: 21% for Partner A and 34% for Partner B.
To calculate, divide each partner's income by total household income for their ratio, then apply it to expenses. An example from jakelee.co.uk shows Person 1 with 60% income share paying 60% of a $500 bill: (500 / 100) times 60 equals 300. The other transfers their share monthly. Tradeoffs include more math upfront for proportional splits versus simplicity of 50/50, but proportional reduces resentment over time when incomes differ.
Discuss upfront: agree on which expenses qualify as shared (rent, utilities, groceries) versus individual. Document the chosen method in your sheet for reference.
Set Up Columns and Structure in Google Sheets
Use Google Sheets for its free sharing and edit permissions. Create tabs for "Income Summary," "Planned Expenses," "Actual Expenses," and "Balances."
In the Income Summary tab, add columns: Partner Name, Monthly Income, Total Household Income (=SUM of incomes), Income % (=individual income / total). This auto-calculates ratios like 62% or 38%.
For expense tabs, include these columns per expensesorted.com's template structure: Date, Category, Description, Planned Amount, Actual Amount, Split %, Partner A Share (=Actual Amount A’s Income %), Partner B Share (=Actual Amount B’s Income %), Paid By (dropdown: Partner A, B, or Joint), Balance (running total of owed/reimbursed).
Match categories to your spending using a 50/30/20 structure from sheetgo.com: 50% needs (rent, utilities, groceries, healthcare), 30% wants (dining out, clothing), 20% savings or debt. Add a Split % column next to expenses for custom overrides, like 100% joint for rent or 50/50 for streaming services.
Share the sheet: Click Share > enable "Editor" access for both partners with their email. Set update cadence: log expenses weekly. Common mistake: mismatched categories leading to overlooked spending; review and refine monthly.
Summary tab formulas pull totals: =SUM(Actual Expenses!E:E) for total actuals, with charts for visual planned vs actual.
Add a Receipt and Documentation Workflow
Clear records prevent reimbursement disputes. Scan receipts immediately using a phone app or built-in scanner, then upload to a shared Google Drive folder named "Receipts - [Month Year]."
Link each expense row to its receipt: In the Description column, hyperlink the Drive file (right-click cell > Insert link). Log weekly: Note payee, amount, date, and photo link.
For reimbursements, use the Balance column to track who owes what. Example script: "I paid $150 groceries; receipt linked. Per our 62/38 split, you owe $57." Partner transfers via their bank app and marks "Paid" in the sheet.
Export monthly: File > Download > PDF for records. Keep for personal reference.
Establish Review Cadence and Rules
Consistency keeps budgets on track. Schedule a weekly 10-minute check-in every Sunday evening or Monday morning, per expensesorted.com. Use this script: "Review last week's expenses, confirm splits, update balances, and plan ahead."
Monthly, reconcile: Compare planned vs actual totals, adjust next month's targets. Example rules to agree on:
- Update expenses within 48 hours of purchase.
- Reimbursements due by end of week.
- Joint decisions for expenses over $100.
Set boundaries: Assign responsibilities, like Partner A logs utilities, Partner B groceries. If one travels, note "nights stayed" adjustments to splits. Document rules in a "Rules" tab for quick reference.
This cadence builds habits without overwhelming schedules.
FAQ
How do you calculate proportional splits based on income?
Divide each partner's income by total household income for their %. Apply to shared expenses: (expense amount / 100) times their %. Example from jakelee.co.uk: (500 / 100) times 60 = 300.
What's a simple column setup for couples in Google Sheets?
Date, Category, Actual Amount, Split %, Partner A Share, Partner B Share, Paid By, Balance. Add Income % from summary tab, per expensesorted.com.
How often should couples review their shared budget?
Weekly 10-minute check-ins every Sunday or Monday, plus monthly reconciliation, as in expensesorted.com's guide.
When is 50/50 better than income-proportional splits?
When incomes are similar, for simplicity. Proportional suits uneven incomes to balance burden percentages.
Do you need an app, or is a spreadsheet enough?
A shared Google Sheet handles tracking, splits, and records for most couples. Apps add features but are optional.
How to handle receipts for shared expenses?
Scan and link to Drive folder, note in sheet row. Track reimbursements in Balance column for proof.
Next, duplicate a blank Google Sheet, add the columns above, input your incomes, and test with last month's expenses. Refine splits and rules over the first month.