Skip to content
Quarterly Estimated Tax Tracker cover: a sample sheet with planned for the year, paid so far and still to pay and a column chart, beside the Dashboard tab

Quarterly Estimated Tax Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

Self-employed workers, landlords and anyone without tax taken from their pay use this quarterly estimated tax tracker to keep up with the four payments in a year. The Payments tab has a line per installment with its due date, planned amount, the date paid, the amount paid, the still-to-pay figure and a status. The Dashboard shows the planned total, the amount paid so far, the amount still to pay and the number of payments made, with a column chart for each payment.

Set each planned amount with a tax professional or from your own estimate, and revise it when your income changes sharply. Record the date you paid even when the payment went out early, so the status and the chart stay accurate. A red row means a payment is past its due date and still not paid, which makes it the first thing to fix.

Useful for

  • Track four estimated payments in one year
  • Record partial payments against a planned amount
  • Spot a late estimated payment before the year closes

What's included

  • 3 tabs: Dashboard, Payments, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Payments: 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 Payments 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

When are the estimated payments due?

For many individuals the four payments fall in mid-April, mid-June, mid-September and mid-January, but the exact dates change from year to year. The due date column is there so you can enter the dates you confirm under current IRS rules for your return.

What happens if I pay less than planned?

Enter the amount you actually paid and the still-to-pay figure shows the gap. Penalties for underpaying depend on your situation, so read the latest IRS instructions or consult a tax professional before the next deadline.

Can I pay early?

Yes. Put the amount on the row for the payment it covers, record the date you paid, and set the status to Paid. The sheet is built around four payments, so an early payment still belongs on its own row rather than being combined with another.

  • #tax-tracker
  • #quarterly-estimated-tax
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tax tracker templates

See all 10

Also in Finance

All finance templates
Get this template

Preparing your template…