Skip to content
The title slide and first slides of the House Down Payment Tracker template

House Down Payment Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 16, 2026

Every slide (5)

Overview

Saving for a first home is a long project, and a plain account balance does not say how far along you are. Here you enter the price you are aiming for, the down payment percent and an estimate for closing costs, and the sheet turns them into a single dollar goal. Each deposit you log then moves a percent-saved figure up.

The Goal tab also works out your average deposit per month from the first date to the latest and turns it into an estimate of the months remaining and the month you could reach the target. The Timeline tab charts the total saved month by month and shows where the money came from: paychecks, bonuses, refunds, gifts or side income. Change the percents to compare a smaller down payment with a bigger one.

Useful for

  • Plan the savings timeline for a first home purchase
  • Compare 5%, 10% and 20% down payments by the months they take
  • Share the progress of the fund with a lender or a partner

What's included

  • 4 tabs: Timeline, Goal, Deposits, How to use
  • Timeline: a dashboard with 6 summary figures
  • Goal: a table
  • Deposits: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Goal tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What size of down payment should I plan for?

It depends on the loan, the lender and the home price. Type the percent your lender quotes on the Goal tab, and the sheet turns it and the closing costs into a dollar goal.

How are the months left calculated?

The sheet divides what you still need by your average monthly deposit, counted from your first deposit to your latest, and rounds up.

Do I need to include closing costs?

They are separate from the down payment but are due when you close, so the sheet adds them to the goal. Set the percent to zero if you want to track the down payment alone.

  • #savings-tracker
  • #house-down-payment-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More savings tracker templates

See all 22

Also in Finance

All finance templates
Get this template

Preparing your template…