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

Tax Preparer Client Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Independent tax preparers, bookkeepers who file returns and small practices use this tracker to run a busy season without losing a client in the pile. The Clients tab gives each person or business one row with the work type, stage, documents due date, fee quoted, amount paid and filing date. The Documents tab lists every paper you asked for and when it came. The Dashboard counts clients by stage and sums quoted fees.

Start the season by entering every returning client and setting the stage to Not started. As intake meetings happen, move clients along and record fees. Amber rows show who is waiting on you or who owes you papers, which turns the sheet into a daily call list. Once the season closes, the filed dates and fee totals show how the practice did and what to charge next year.

Useful for

  • See at a glance which clients are blocked
  • Keep fees quoted and fees collected side by side
  • Chase missing documents without rereading emails

What's included

  • 4 tabs: Dashboard, Clients, Documents, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Clients: a table
  • Documents: 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 Clients 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 can I manage clients during busy season?

Give each client one row with a stage and update it every time something happens. A separate list of requested documents shows what is still missing, and the Dashboard counts clients waiting at each stage.

What client information should I store here?

Keep names, work type, dates, fees and notes. Leave out tax ID numbers, account numbers and passwords, and store sensitive records in your secure practice system instead.

Can I track fees and payments?

Yes. Enter the fee quoted and what has been paid. The Fee left column subtracts one from the other, and the Dashboard adds up what is still to collect.

  • #tax-tracker
  • #tax-preparer-client-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…