Skip to content
The title slide and first slides of the Property Tax Tracker template

Property Tax Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Style
Modern
Difficulty
Beginner
Updated
November 15, 2026

Every slide (6)

Overview

Homeowners, landlords and people who hold land use this property tax tracker to stay ahead of county bills. The Properties tab stores the parcel number, assessed value and whether an escrow account pays the bill. The Bills tab lists each installment with its due date, amount billed, payment and balance. The Appeals tab follows any challenge to an assessment, and the Dashboard compares billed and paid amounts for each property in a chart.

Add a bill the day the notice arrives and write the due date straight away. Late rows glow red, so an unpaid installment is hard to miss. When you appeal, record the value you claim and the hearing date, then set the status after the decision. Keep paid bills for several years so you can compare one year against the next.

Useful for

  • Keep due dates for several properties in one list
  • See what is still owed on each parcel
  • Follow an assessment appeal until it is decided

What's included

  • 5 tabs: Dashboard, Bills, Properties, Appeals, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Bills: a table
  • Properties: a table
  • Appeals: a table
  • 1 chart 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 Bills 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

How do I track property tax payments?

Add one row per installment on the Bills tab with the amount billed, then enter the date and amount when you pay. The Balance column shows what remains, and the Dashboard adds it up by property.

What if my lender pays property tax from escrow?

Mark the property as paid through escrow on the Properties tab and log the bill as you receive it. Match the amount against the lender's yearly statement, since escrow payments can differ from the bill.

Can I record an appeal here?

Yes. The Appeals tab keeps the filing date, the assessed value, the value you claim, the hearing and the result. The Gap column shows how far apart the two values are.

  • #tax-tracker
  • #property-tax-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…