Quick Summary
A practical guide to building a multi-goal savings tracker in your spreadsheet - with allocation formulas, progress visualization, and contribution management.
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 | 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: goal name, target amount, current balance, remaining (target minus current), progress % (current divided by target), and monthly contribution.
Key Formulas
Remaining: =TargetAmount-CurrentBalance
Progress %: =CurrentBalance/TargetAmount
Overall Progress: =TotalCurrent/TotalTarget
Months to Goal: =IF(MonthlyContribution>0,Remaining/MonthlyContribution,"N/A")
Required Monthly: =(TargetAmount-CurrentBalance)/DATEDIF(TODAY(),TargetDate,"M")
On-Track Check: =IF(CurrentBalance>=(TargetAmount*(ElapsedMonths/TotalMonths)),"On Track","Behind")Allocation Methods
Fixed Amount per Goal
Assign specific dollar amounts monthly. Simple and easy to track.
Percentage-Based
| Goal | Allocation % | Of $650/month |
|---|---|---|
| Emergency Fund | 45% | $293 |
| Vacation | 25% | $163 |
| Car Fund | 30% | $195 |
Adjusts automatically if your total savings amount changes.
Priority-Based
Fund goals in order of priority:
=IF(EmergencyFund<Target1,AvailableSavings,
IF(Vacation<Target2,AvailableSavings,
IF(CarFund<Target3,AvailableSavings,0)))Visual Progress Tracking
SPARKLINE 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
=REPT("█",ROUND(Progress*10,0))&REPT("░",10-ROUND(Progress*10,0))Displays: █████░░░░░ for 50%
Handling Variable Contributions
When you have extra - create a windfall allocation system: 50% to highest priority, 30% to second, 20% to third.
When you fall short - reduce proportionally across all goals, or skip lowest priority that month.
Track variance with planned vs. actual contribution columns:
=ActualContribution-PlannedContributionContribution Log
| Date | Goal | Amount | New Balance |
|---|---|---|---|
| Mar 1 | Emergency | $300 | $8,800 |
| Mar 1 | Vacation | $150 | $1,350 |
| Mar 1 | Car | $200 | $2,700 |
Link log to summary table:
=SUMIF(ContributionLog!Goal,A2,ContributionLog!Amount)This automatically updates current balance when you add contributions.
Multiple Account Tracking
When goals share one account, track allocations virtually:
| 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.
Priority Ordering
Earlier in the list: Emergency fund, debt payoff, essential upcoming expenses.
Middle ground: Planned major purchases, annual expenses (sinking funds), vacation.
Later priorities: Nice-to-have purchases, distant goals, stretch goals.
Worth reviewing quarterly and adjusting allocation percentages based on timeline changes, priority shifts, and available savings.
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