A savings tracker spreadsheet template is a simple worksheet for recording a savings goal, planned deposits, actual deposits, withdrawals, and progress toward a target. In Excel for Microsoft 365 on Windows, set up the columns below and use the formulas provided to calculate a running balance, the amount left to save, and the share of the goal reached.
What the template tracks
A useful tracker separates what you intend to save from what you actually save. A plan can change, so recording both figures makes it easier to see whether a missed contribution is a temporary timing issue or a gap that needs attention. Track withdrawals separately too; otherwise, the running balance may suggest that you are closer to your goal than you really are.
Start with these summary details near the top of a blank worksheet:
- Goal name: for example, car repairs, a trip, or an emergency fund.
- Target amount: the total you are aiming to accumulate.
- Starting balance: money already set aside for this goal.
- Target date: optional, but useful for planning and review.
Then add a transaction schedule with these headings in row 8: Month, Planned contribution, Actual contribution, Withdrawals, Net change, Running balance, Remaining, and Progress. Put the headings in cells A8:H8, and enter one month or contribution period per row starting in row 9. If you prefer to track every deposit, use a date for each row rather than a month.
Set up the worksheet in Excel
In a new workbook, put the summary labels in A2:A5 and their values in B2:B5: goal name in B2, target amount in B3, starting balance in B4, and target date in B5. For example, enter Emergency fund, 3000, 400, and a date you choose. The figures are illustrative, not a recommended savings target. Enter zero in B4 if you are starting from nothing.
Type the eight transaction headings in row 8 and enter the periods in column A. Planned contributions go in B, actual contributions in C, and withdrawals in D. Enter amounts as positive numbers in both C and D; the formula for net change subtracts withdrawals. Leave future actual contributions blank until they happen. For a tidy layout, select A8:H20 and choose Insert > Table, then confirm that the table has headers. A table can make sorting and formatting easier; if you use it, make sure new rows are included as you extend the schedule.
Format B3:B4 and columns B:G as currency using Home > Number. Format B5 and the dates in column A as dates. On Windows, Ctrl+T opens the Create Table dialog when a range is selected; on Mac, use Command+T. The menu route is also available in Excel for Mac, though ribbon arrangement can differ. Excel for the web has a similar Table option, but some ribbon controls may be arranged differently.
Formulas for balance and progress
The formulas below assume the summary values are in B3 and B4 and the transaction headings are in A8:H8. Enter each formula in the indicated row. If you are not using an Excel table, copy the formulas down for the remaining periods. Excel adjusts the row references as you fill down.
With actual contributions in C9 and withdrawals in D9, enter this in E9 to calculate the period’s net change. If the contribution is 250 and the withdrawal is zero, the result is 250.
=C9-D9
With the starting balance in B4 and actual contributions and withdrawals in C9:D9, enter this in F9 for the running balance. If B4 is 400, C9 is 250, and D9 is 0, the result is 650.
=$B$4+SUM($C$9:C9)-SUM($D$9:D9)
With the target in B3 and the running balance in F9, enter this in G9 to show how much remains. If the target is 3000 and the balance is 650, the result is 2350. MAX prevents the remaining amount from becoming negative if you exceed the target.
=MAX($B$3-F9,0)
With the target in B3 and the balance in F9, enter this in H9 to calculate progress as a decimal. With a 3000 target and 650 balance, the result is approximately 0.2167, or 21.67% when displayed as a percentage. The IF check avoids division by zero if the target cell is empty or zero, and MIN caps the displayed progress at 100%.
=IF($B$3=0,0,MIN(F9/$B$3,1))
After entering the formulas in E9:H9, select those cells and drag the fill handle down, or copy and paste into later rows. The running-balance formula sums all recorded contributions and withdrawals from the first transaction row through the current row, so it works even if the worksheet has a period with no deposit. Keep the rows in chronological order so the balance shown at each point reflects the sequence of transactions.
Worked example: a changing monthly plan
Suppose a tracker starts with 400 toward a 3000 goal. In the first month, the planned contribution is 250 and the actual contribution is 250, with no withdrawal. The running balance is 650, 2350 remains, and progress is about 21.67%. In the second month, the plan is 250 but the actual deposit is 300, followed by a 50 withdrawal. The running balance becomes 900: 400 starting balance plus 250 and 300 in deposits, minus 50 withdrawn. The amount remaining is 2100 and progress is 30%.
This example shows why planned and actual amounts should not be confused. Planned contributions describe an intention; only actual contributions and withdrawals change the calculated balance. If a deposit is transferred between accounts, record it once as a contribution to this goal. Do not also enter it as a withdrawal unless money actually leaves the savings balance being tracked.
Make the tracker easier to read
Formatting can make exceptions visible without adding complexity. Select H9:H20 and choose Home > Number > Percentage. For a progress bar, select the progress cells and choose Home > Conditional Formatting > Data Bars. You can also highlight a low or negative net change with conditional formatting, but decide what should trigger attention before applying a rule. A zero contribution might simply mean the plan is monthly and the row records a different date.
Consider adding a notes column if you need to explain unusual activity, such as a one-time transfer or a goal change. Keep notes brief and avoid storing account numbers, passwords, or other sensitive credentials in the workbook. If there are several independent goals, either make a separate sheet for each or add a Goal column and use a separate balance calculation for each goal; do not mix unrelated balances into one running total.
Common problems and how to prevent them
- The balance seems too high: check whether the starting balance has been included twice, or whether an account transfer was counted as both a deposit and a withdrawal.
- Progress shows an error: confirm that the target in B3 is a number greater than zero and that the balance cells contain numeric values rather than text.
- The remaining amount is wrong: verify that the target is in B3 and the running balance is in column F, as assumed by the formulas.
- A new row has no formulas: copy the formulas down or extend the Excel table. Check that the new row is within the table range if you are using a table.
- Withdrawals increase the balance: enter withdrawals as positive amounts in column D. The net-change formula subtracts them; typing a negative withdrawal would reverse the effect.
A tracker is only as accurate as its entries. Reconcile the recorded balance against the account or savings bucket you mean to track at a regular interval. If the account also contains money for other purposes, decide whether the spreadsheet tracks the full account balance or only the portion assigned to this goal, then use that definition consistently.
Spreadsheet, app, or bank feature?
A spreadsheet offers control over categories, periods, and formulas. It is useful when you want a printable plan or a clear record without linking a financial account. Its trade-off is manual entry: deposits and withdrawals will not appear automatically, and missed updates can make the total stale.
A dedicated budgeting app or a bank’s savings feature may offer automated transaction imports, goal labels, or progress displays, depending on the provider and service. Those features can reduce manual work, but availability, fees, privacy practices, and account-linking requirements vary. Check the provider’s current terms and security information before connecting accounts. A plain spreadsheet is a reasonable alternative if you prefer to enter only the figures needed for your goal.
Costs, privacy, and backup
Excel may be available through a Microsoft 365 subscription, a standalone license, an organization, or the web, and the cost and included features depend on the access option. The template itself uses ordinary worksheet cells and basic formulas, so it does not require a paid add-in or a macro. Check Microsoft’s current product information for the terms that apply to your account.
Save the workbook in a location you control and consider keeping a backup, especially if it contains a long transaction history. If you store it in a cloud service, review who can access the file and avoid sharing a link with broader permissions than necessary. A savings tracker does not need bank login details. Treat it as a planning record, not as a substitute for your bank’s official balance or transaction history.
Frequently Asked Questions
How do I make a savings tracker in Excel? Put the goal target and starting balance in summary cells, create columns for planned contributions, actual contributions, withdrawals, running balance, remaining amount, and progress, then add formulas to the calculation columns. The layout and formulas above work in Excel for Microsoft 365.
Can I use this savings tracker for multiple goals? Yes. Use a separate worksheet for each goal if you want a simple setup. For a combined list, add a goal name to every transaction and keep calculations separated by goal; a single running total across all goals would not show each goal’s individual progress.
Should I include interest in the tracker? You can record interest as an additional contribution if you want the spreadsheet balance to match the goal balance, but keep it distinct in your records if that detail matters to you. Interest calculation depends on the account’s actual terms and timing, so use the account statement for the authoritative amount.
How often should I update a savings spreadsheet? Update it when a deposit or withdrawal occurs, or choose a consistent weekly or monthly review schedule. More frequent entries can make reconciliation easier; the best interval depends on how often the account changes and how closely you want to monitor it.
Can I use the template in Google Sheets? The basic layout and these formulas use common spreadsheet functions and can be entered in Google Sheets, though menus and formatting steps differ. In a browser, Google Sheets uses its own menus, such as Format > Conditional formatting, rather than Excel’s ribbon paths.
Related
- PowerPoint: Animate Text One Line at a Time
- Compare Data Between Two Excel Sheets: Methods That Work
- Budget Planner Spreadsheet: Build a Monthly Spending Plan
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Audit Spreadsheet Examples and How to Build ThemUseful Excel audit spreadsheet examples include an expense review log, a bank reconciliation, an inventory count comparison, and…
- Excel Dropdown List: How to Create and Use OneTo create and use a dropdown list in Excel for Microsoft 365 on Windows, select the cells, choose…
- Excel Conditional Formatting Between Two Dates: StepsTo highlight dates between two limits in Excel, select the date cells, choose Home > Conditional Formatting >…
- Google Sheets Conditional Formatting If True: How It WorksYes. In Google Sheets, conditional formatting applies a style when a cell meets a selected condition; for more…
- Excel Wrap Text Shortcut: Keys, Ribbon, and FixesIn Excel for Microsoft 365 on Windows, select the cell or cells and press Alt, H, W—one key…
- How to Present PowerPoint and See Your Speaker NotesTo present PowerPoint while keeping your notes visible, connect your computer to a second screen, set the displays…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.