Free Savings Goal Tracker (Excel Calculator, Fillable PDF, Word)

What is on the page

Target and deadline

A number and a month. Vague goals ("save more") have no monthly figure and get skipped the first busy month.

Saved so far

The current balance in the account or bucket for this goal only. Money that is also the emergency fund does not count twice.

Months left

From now to the deadline. The monthly amount is the gap divided by this.

APY and interest

High-yield savings accounts pay 3.5 to 5% in recent years. On a one-year goal interest contributes a few percent; on a five-year goal it is meaningful, and the calculator shows how much.

Planned vs deposited

What you meant to save and what you did. Automatic transfers on payday make the two columns identical, which is the point of them.

Running balance and % of goal

Balance after each month's deposits, interest and withdrawals, and the share of the target reached. The progress bar at the top is colored from this column.

Priority

Which goals get funded first when the budget does not stretch. Emergency fund and hard-dated bills first; wants last.

Budget minus contributions

Positive: spare capacity, add a goal or speed one up. Negative: the plan is unfunded; adjust deadlines or targets until it is zero or better.

Which sheet to use

• Calculator: at the start, to turn each goal into a monthly amount and test whether the date is realistic.
• Monthly tracker: one per goal while you save, especially the big one. The bar is the part that lives on the fridge.
• Multi-goal planner: monthly, to divide the total you can save across everything (the "sinking funds" method) and catch overcommitment before it happens.

Sinking funds: saving for several things at once

Most of what wrecks a budget is not surprise but lumpiness: the annual insurance premium, the holiday, the car that will need replacing in two years. A sinking fund is a small monthly amount set aside for a known future cost so the month it arrives is unremarkable. The multi-goal sheet is that method on one page: each goal has a target, a date and a monthly figure, and the bottom line shows whether the total fits what you can save. Fund them in priority order; when the budget is short, the trip moves out a year before the braces do. Keep them in seperate buckets (most online banks offer sub-accounts) or at least a separate savings account from the emergency fund, and automate the transfers for the day after payday.

How to use the tracker

1. Set the target, the starting balance and the deadline. Divide the gap by the months left; that is the planned monthly deposit.
2. Set up an automatic transfer for that amount on payday into a dedicated account or bucket.
3. Each month, record the deposit, any interest from the statement and any withdrawal; Excel updates the balance and the percentage.
4. Color the bar to the nearest 5%.
5. When a windfall arrives, decide its destination before it lands (gift, bonus, refund) and record it with a note.
6. At the deadline, spend the money on the thing, close the bucket, and start the next goal with the same transfer.

Where to keep goal savings

Money needed within three years belongs in cash: a high-yield savings account or money market fund, where it earns interest, is insured and can't fall in value. Money for a goal five or more years out can take some market risk in a low-cost index fund, accepting that the balance will fluctuate. Certificates of deposit suit goals with a known date (a 12-month CD for next summer's trip). Never keep goal savings in the checking account; it will be spent, and not on the goal. For an emergency fund, the standard target is three to six months of essential expenses in cash, built before the wants.

Editing the Excel versions

In Excel the calculator uses the future-value formulas (PMT with the goal as future value) for the monthly deposit with interest, the tracker carries the balance and percentage forward, and the multi-goal sheet totals contributions against your budget. Add rows inside a table and the totals follow. Find the monthly amount in the budget planner, pay off high-rate cards first with the debt payoff tracker, and watch the balances add up on the net worth worksheet.

Questions

How much should I save each month?

For a specific goal: the target minus what you've, divided by the months to the deadline (the calculator adjusts for interest). As a general rule, 20% of take-home pay toward savings and extra debt payments is a common target; what matters more is that the amount is automatic.

How big should an emergency fund be?

Three to six months of essential expenses (housing, food, utilities, insurance, minimum debt payments, transport), more for a single income, variable income or dependants. Start with a one-month cushion while paying off high-interest debt, then build the rest.

Should I save or pay off debt first?

Build a small cushion first so emergencies don't go on a card, then pay off anything above about 7 to 8% before saving beyond that, then save in earnest. Always take any employer retirement match regardless.

Where should I keep savings for a goal?

High-yield savings or money market for anything within three years; a CD matched to the date for a fixed deadline; a diversified index fund only for goals five or more years away where you can tolerate a dip.

How does interest change the monthly amount?

Modestly for short goals: saving $5,000 in 12 months needs about $417 a month without interest and about $409 at 4% APY. Over five years at 4%, $20,000 needs $333 a month without interest and about $302 with it. The calculator shows both figures.