Skip to content
The title slide and first slides of the Individual Tax Organizer template

Individual Tax Organizer

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

People who file their own return or meet a preparer once a year use this individual tax organizer to collect everything first. The Income tab lists each payer with its form type, amount, tax withheld and arrival status. The Deductions tab logs costs you may claim, and the Documents tab tracks the papers a preparer asks for. The Summary adds up income and withholding by form, deductions by category and the documents still missing.

Start in January with last year's return open and list every payer you remember. Mark forms Expected until they arrive, then Received. Keep receipts in a folder and write its name in the Saved in column. Skip account and Social Security numbers; give those to your preparer through a secure channel.

Useful for

  • Prepare one folder of records before a tax appointment
  • Spot a late W-2 or 1099 before filing
  • Compare income and withholding by form at a glance

What's included

  • 5 tabs: Summary, Income, Deductions, Documents, How to use
  • Summary: a dashboard with 4 summary figures
  • Income: a table
  • Deductions: a table
  • Documents: 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 Income 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 records do I need to file my taxes?

Gather every income form you were sent, records of tax already paid, and proof of costs you may claim. Last year's return helps you remember sources. A tax professional or the IRS website can tell you which records apply to your situation.

How do I organize tax documents for my preparer?

Use one list and one folder. Record each payer, form and status in the Income tab, then note where each file is saved. Give your preparer the list and a copy of the folder instead of loose paper.

When should I start collecting tax forms?

Start in January. Many payers send forms by the end of that month, and some brokers and partnerships send later. Mark each as Expected and follow up on anything still missing in February.

  • #tax-tracker
  • #individual-tax-organizer
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…