Saving for emergency fund, vacation, and car replacement simultaneously requires a system that tracks each goal’s progress while showing the complete picture - one spreadsheet can handle it all.
Skip the setup: The Monthly Budget Template includes integrated savings tracking alongside your budget.
Basic Tracker Structure
Goal Summary Table
| Goal | Target | Current | Remaining | Progress | Monthly |
|---|---|---|---|---|---|
| Emergency Fund | $15,000 | $8,500 | $6,500 | 57% | $300 |
| Vacation | $3,000 | $1,200 | $1,800 | 40% | $150 |
| Car Fund | $10,000 | $2,500 | $7,500 | 25% | $200 |
| Total | $28,000 | $12,200 | $15,800 | 44% | $650 |
Essential Columns
What you need:
- Goal name: What you’re saving for
- Target amount: Total needed
- Current balance: Amount saved
- Remaining: Target minus current
- Progress %: Current divided by target
- Monthly contribution: How much you add monthly
Building this foundation gives you visibility into the complete picture while maintaining clarity on individual targets. The structure scales easily - start with three goals and add more as your situation evolves.
Key Formulas
Remaining Amount
=TargetAmount-CurrentBalanceProgress Percentage
=CurrentBalance/TargetAmountFormat as percentage.
Total Row
=SUM(B2:B5) // Sum of target column
=SUM(C2:C5) // Sum of current columnOverall Progress
=TotalCurrent/TotalTargetThese formulas handle the math automatically once you set them up. When you add a contribution to any goal, all the calculations update instantly - remaining amounts, progress percentages, and totals adjust without any manual work.
Allocation Methods
Fixed Amount per Goal
Assign specific dollar amounts to each goal monthly:
- Emergency fund: $300
- Vacation: $150
- Car fund: $200
Simple. Easy to track.
Percentage-Based Allocation
Allocate based on percentage of total savings:
| Goal | Allocation % | Of $650/month |
|---|---|---|
| Emergency Fund | 45% | $293 |
| Vacation | 25% | $163 |
| Car Fund | 30% | $195 |
Priority-Based Allocation
Fund goals in order of priority:
- Fill emergency fund to target first
- Then fund vacation
- Then car fund
Formula for priority allocation:
=IF(EmergencyFund<Target1,AvailableSavings,
IF(Vacation<Target2,AvailableSavings,
IF(CarFund<Target3,AvailableSavings,0)))The allocation method you choose depends on your personality and priorities. Fixed amounts work well when you have predictable income and want simplicity. Percentage-based allocation adjusts automatically if your total savings amount changes. Priority-based funding appeals to people who want to fully complete one goal before moving to the next.
Visual Progress Tracking
SPARKLINE Progress Bars
Create in-cell progress bars:
=SPARKLINE(Progress,{"charttype","bar";"max",1;"color1","green"})Conditional Formatting
Apply color scales to progress column:
- Red: 0-25%
- Yellow: 25-75%
- Green: 75-100%
Unicode Progress Bar
Text-based progress indicator:
=REPT("█",ROUND(Progress*10,0))&REPT("░",10-ROUND(Progress*10,0))Displays: █████░░░░░ for 50%
Visual elements transform abstract numbers into something tangible. A progress bar at 57% feels different than just reading “$8,500 of $15,000” - the visual representation creates a stronger emotional connection to your progress and makes the spreadsheet more engaging to use regularly.
Timeline Tracking
Months to Goal
Calculate how long until each goal is reached:
=IF(MonthlyContribution>0,Remaining/MonthlyContribution,"N/A")Target Date
If you have a target date, calculate required monthly savings:
=(TargetAmount-CurrentBalance)/DATEDIF(TODAY(),TargetDate,"M")On-Track Indicator
Compare actual progress to expected progress:
=IF(CurrentBalance>=(TargetAmount*(ElapsedMonths/TotalMonths)),"On Track","Behind")Timeline tracking adds another dimension to your savings visibility. Knowing how many months remain until you reach each goal helps with planning, and the on-track indicator provides quick feedback without requiring you to do mental math every time you review your progress.
Handling Variable Contributions
When You Have Extra
Create a “windfall allocation” system:
- 50% to highest priority goal
- 30% to second priority
- 20% to third priority
When You Fall Short
If you can’t make full contributions:
- Reduce proportionally across all goals
- Or skip lowest priority goal that month
Tracking Actual vs. Planned
Add columns for:
- Planned contribution
- Actual contribution
- Variance
=ActualContribution-PlannedContributionLife rarely follows a predictable pattern, so building flexibility into your tracker matters. The variance tracking helps you see patterns over time - maybe you consistently fall short in December but exceed targets in tax refund season. Understanding these patterns helps you set more realistic expectations.
Contribution Log
Transaction Tracking
| Date | Goal | Amount | New Balance |
|---|---|---|---|
| Mar 1 | Emergency | $300 | $8,800 |
| Mar 1 | Vacation | $150 | $1,350 |
| Mar 1 | Car | $200 | $2,700 |
Running Total Formula
Link log to summary table:
=SUMIF(ContributionLog!Goal,A2,ContributionLog!Amount)This automatically updates current balance when you add contributions.
A contribution log creates a history of your savings journey. Beyond the practical benefit of automatically updating balances, the log becomes a record you can look back on - useful for understanding your patterns and for that satisfying moment of seeing how far you’ve come.
Multiple Account Tracking
When Goals Are in Separate Accounts
Add an “Account” column to track where money is held:
| Goal | Account | Target | Current |
|---|---|---|---|
| Emergency | Ally HYSA | $15,000 | $8,500 |
| Vacation | SoFi Vault | $3,000 | $1,200 |
| Car | Main Savings | $10,000 | $2,500 |
When Multiple Goals Share One Account
Track allocations virtually in spreadsheet while actual balance is combined:
| Goal | Allocated | Physical Account |
|---|---|---|
| Emergency | $8,500 | Main HYSA |
| Vacation | $1,200 | Main HYSA |
| Car | $2,500 | Main HYSA |
| Total | $12,200 | Verify against actual |
Include a check that allocations match actual account balance.
The key to multiple account tracking is reconciliation. Your spreadsheet allocations are virtual - the actual money might all sit in one account. Adding a verification check that compares your allocated totals against real account balances catches any discrepancies before they compound into confusion.
Priority Ordering
What Some People Fund First
Some approaches to ordering goals:
Earlier in the list:
- Emergency fund (if not yet funded)
- Debt payoff (if applicable)
- Essential upcoming expenses
Middle ground:
- Planned major purchases
- Annual expenses (sinking funds)
- Vacation
Later priorities:
- Nice-to-have purchases
- Distant goals
- Stretch goals
Adjusting Priorities
Worth reviewing quarterly and adjusting allocation percentages based on:
- Timeline changes
- Goal priority shifts
- Available savings changes
Priorities change. A goal that seemed urgent six months ago might matter less now, while something new has become more pressing. Building in regular review moments - quarterly works well for many people - keeps your allocation aligned with what actually matters to you.
Templates and Starting Points
Using Existing Templates
The Monthly Budget Template includes integrated savings tracking sections where you can monitor multiple goals alongside your budget.
Building Your Own
Start simple:
- List all savings goals
- Add target amounts
- Add current balances
- Calculate remaining and progress
- Determine monthly contributions
- Add formulas to automate
Expand with progress bars, charts, and logging as needed.
Starting simple and adding complexity as needed beats starting complex and getting overwhelmed. Many people abandon elaborate systems after a few weeks. A basic table you actually use outperforms a sophisticated tracker that sits untouched.
Common Questions
How Many Goals Is Too Many?
3-5 active goals tends to be manageable. Beyond that, decision fatigue sets in. Worth considering combining similar goals or narrowing focus.
Should I Include Retirement?
Retirement is typically tracked separately due to different characteristics (employer contributions, tax treatment, long timeline). Include in net worth tracking instead. The Retirement Financial Planning Spreadsheet handles dedicated retirement projections, while the Financial Planning Template covers broader financial goals alongside shorter-term savings.
What About Emergency Fund?
Track emergency fund until fully funded, then move it to a “maintenance” category. Just verify periodically that it’s still adequate.
How Often to Update?
Weekly or monthly, depending on how often you contribute. At minimum, update during regular budget reviews.
Automation Tips
Google Finance for Interest
If your savings earns interest, approximate growth:
=CurrentBalance*(1+APY/12)Automatic Date Updates
Track when each goal was last updated:
=IF(CurrentBalance<>PreviousBalance,TODAY(),LastUpdated)Monthly Auto-Fill
Create a template row that pre-fills expected contributions each month.
Automation reduces friction, and reduced friction means more consistent tracking. Even small automations - like a formula that calculates interest growth or automatically stamps the update date - save mental energy over time. The goal is making your tracker as effortless to maintain as possible.
Managing Changes
What if I need to withdraw from a goal?
Log it as a negative contribution. Progress will adjust accordingly. Note the reason for future reference.
Should goals have target dates?
Helpful for planning but not required. Some goals (like emergency fund) don’t have specific dates.
How do I handle completed goals?
Move to a “Completed” section or archive tab. Keep records for reference and celebration.
What if my total savings capacity changes?
Recalculate allocations based on new available amount. May need to adjust timelines or priorities.
Track Savings Alongside Your Budget
The Monthly Budget Template includes integrated savings goal tracking - monitor multiple targets alongside your regular budget in one place. Works in Google Sheets.
Get the Monthly Budget Template →
Related
- Financial Planning Template - Comprehensive goal planning with projections
- Monthly Budget Template - Integrated savings tracking
- Savings Goal Tracker Spreadsheet
- Multiple Savings Accounts Strategy
- Sinking Funds Explained
Tracking multiple savings goals in one place provides clarity on overall progress while maintaining visibility into each individual target. Start with a basic table, add formulas for automation, and expand with visual elements as your system matures.