Skip to content
The title slide and first slides of the Tax Preparer Intake Checklist template

Tax Preparer Intake Checklist

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

Tax preparers and volunteer tax helpers use this intake checklist to start each client file the same way. The Clients tab records the meeting, filing status, dependents, prior return and engagement letter. The Intake grid lists eighteen items down the side and a column for each client, with checkboxes and a count per item. The Interview questions tab holds the questions to ask and the answers given, and the Dashboard summarizes who is ready.

Send the list of items before the meeting so clients know what to bring. During the meeting, tick the grid as papers come across the desk and write the answers to the interview questions. Anything left unticked becomes your follow-up list. Change the item names to fit your clients; a practice with many landlords might add rows for rental records and repairs.

Useful for

  • Run every first meeting from the same list
  • See which clients are still missing papers
  • Record answers to standard interview questions

What's included

  • 5 tabs: Dashboard, Clients, Intake grid, Interview questions, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Clients: a table
  • Intake grid: a grid
  • Interview questions: 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

What do I need to collect from a new tax client?

Typical items include identification, last year's return, wage and interest statements, records of side income, family details and any forms for deductions or credits. The grid lists common ones; add or delete rows to match your clients.

Should I ask for the prior-year return?

It is a useful check on names, carried-over amounts and accounts, so many preparers ask for it. Mark it Requested on the Clients tab until you hold a copy, and the Dashboard counts the gaps.

How do I keep client data safe in a sheet?

Record only the status of each document, never the numbers on it. Keep tax IDs, account numbers and passwords out of the file, and share the sheet only with people who work on the client files.

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

Also in Finance

All finance templates
Get this template

Preparing your template…