Budget Tracker for Couples
Shared Expense Tracking That Actually Works
Start with one Google Sheet that both partners can edit on their phones. Create columns for date, payer, category, amount, and notes. For example, label rent at $1,850 due on the first, groceries at $420 average per month, and date nights capped at $85. Add a formula that splits totals 50/50 or by income ratio. When one partner logs a $64 Target run on March 12, the sheet instantly shows each person owes $32. Review the sheet together every Sunday night for ten minutes. This habit stopped one couple from arguing over $300 in forgotten Amazon charges in Q1. Keep the sheet simple at first. Add conditional formatting that turns any category over budget red. The result is real-time visibility without logging into another app.
Including Crypto and Investments in Your Budget Tracker
Add a separate tab for holdings. Record purchase dates, cost basis, and current values. If you bought 0.05 BTC at $29,000 in January 2023 and sold at $48,000 in June 2024, the sheet calculates the $950 gain automatically. Under IRS Notice 2014-21 and Publication 550, you can use specific identification to choose which lots to sell. HIFO ordering is permitted with adequate records, so your spreadsheet can list lots by highest basis first. Rev. Proc. 2019-09 and Form 8949 instructions confirm that proper documentation supports this method. Track monthly unrealized gains as a separate line so you never spend money that exists only on paper. Update prices weekly instead of daily to avoid obsession. This single tab turned a vague crypto pile into a budgeted asset for several couples last year. Always run final numbers past a CPA before filing.
Setting Fair Contribution Rules
Stop the 50/50 default when incomes differ. One couple earning $78,000 and $112,000 switched to a 41/59 split. Each month the lower earner transfers $1,190 into the joint account while the higher earner transfers $1,710. The sheet shows running balances so no one wonders who paid last. Track personal fun money separately at $200 per person. This prevents resentment when one partner buys a $45 video game and the other buys $45 shoes. Revisit the ratio every January after tax returns. The same couple adjusted again in 2025 when one received a $9,000 raise. Formulas update instantly. The key is writing the rule in the sheet header so both see it daily.
Tax Season Prep Inside the Same Sheet
Keep a fourth tab for estimated taxes and charitable donations. Log every donation receipt with date and amount. One pair recorded $1,240 in 2024 donations and avoided a surprise $310 bill in April. Pull year-to-date totals into a summary box on the front page. When crypto sales appear, the sheet flags them with the exact proceeds and basis so Form 8949 prep takes minutes instead of hours. Update the sheet on the 28th of each month before statements arrive. This rhythm caught a $180 duplicate charge in February and a mis-categorized $95 dinner in October. The habit costs nothing yet saves real dollars every filing season. Check with a CPA to confirm your specific situation.
Weekly Review That Sticks
Block twenty minutes every Sunday. One partner reads categories while the other types adjustments. Last month this caught a $22 recurring subscription neither remembered starting. End the meeting with one number: total left in the joint account after all known bills. When that number sits above $1,800, the couple green-lights an extra $60 date. The spreadsheet becomes the neutral third party that removes emotion from money talks. Couples who run this review for six straight months report fewer arguments and higher savings rates. The data stays in one place instead of scattered across bank apps and text threads.
📧 Want more like this?
The free 7-day Subscription Cleanse. Daily emails with cancellation scripts and renegotiation tactics.
Frequently Asked Questions
Joint vs separate accounts?
Most couples keep a joint checking account for shared bills and separate accounts for personal spending. Route both paychecks into the joint account first, then auto-transfer a set fun-money amount to each personal account on the first of the month. One couple moved $400 each to personal accounts and left everything else joint. Their spreadsheet shows the joint balance daily so no one questions where the rent money went. Separate accounts reduce fights over small purchases while the joint account keeps big expenses transparent.
How to split expenses fairly
Use income ratios instead of 50/50. If one partner earns 42% of total household income, they contribute 42% of every shared bill. Build a simple formula in the sheet that recalculates the split whenever income changes. A couple earning $6,500 and $8,900 monthly switched to 42/58 and stopped arguing about who paid more for groceries. Update the ratio each January after reviewing W-2s. The sheet makes the math visible so fairness is never a feeling, it is a number.
Discussion templates
Create a fixed agenda in the spreadsheet notes: 1. Review last week’s overspend categories. 2. Confirm upcoming big expenses. 3. Adjust fun-money transfers if needed. One couple prints the sheet summary and sits at the kitchen table with it. They limit the talk to fifteen minutes and end with one agreed change. The template removes the need to decide what to talk about every time and keeps conversations short and productive.
Spreadsheet features needed
Require these columns at minimum: date, payer, category, amount, running balance, and notes. Add dropdown menus for categories so entries stay consistent. Include a monthly summary table that pulls totals with SUMIF formulas. Conditional formatting that highlights anything over budget by more than 10% catches problems fast. One sheet with these features replaced three separate apps for a couple tracking $6,800 in monthly expenses. Keep it under 12 columns so the sheet loads instantly on phones.
Apps vs spreadsheets
Apps hide the formulas and charge monthly fees. A spreadsheet shows every calculation and costs zero after you own Google Sheets. Couples using spreadsheets adjust categories the same day they notice a problem instead of waiting for an app update. One pair switched from a $12.99 app to a custom sheet and found $310 in duplicate subscriptions within the first month. The data stays yours and travels with you when banks change. Spreadsheets win on control and price.
📊 Want to track this ongoing?
Track subscriptions, budgets, and debt payoff with the LedgerLaunchCo Etsy spreadsheet bundle.