Skip to content
The title slide and first slides of the Payroll Year-End Checklist template

Payroll Year-End Checklist

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

Business owners, bookkeepers and payroll clerks use this payroll year-end checklist to meet the January deadlines. Each job on the Tasks tab is given an owner, due date and status. The People tab lists every employee and contractor with pay, withholding, form status and an address check. The Filings tab tracks each government deadline. The Dashboard counts open tasks by owner and shows forms still to send.

Begin in early December by asking staff and contractors to confirm their details. Reconcile payroll to the books before preparing any form, because errors found later are harder to fix. Mark a form Ready when it is checked and Sent when it is delivered. Check exact filing dates with the IRS and your state each year.

Useful for

  • Split year-end payroll work between several people
  • Check that every worker has a form and a current address
  • Track each government filing until it is done

What's included

  • 5 tabs: Dashboard, Tasks, People, Filings, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Tasks: a table
  • People: a table
  • Filings: 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 Tasks 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 do for payroll at year-end?

Check employee and contractor details, reconcile payroll to the books, prepare W-2s and 1099-NECs, deliver copies, file with the government and archive the records. This workbook puts each step in a task list with an owner.

When are W-2s and 1099-NECs due?

Both usually have a January deadline, but the exact date can move with weekends and holidays. Check the IRS instructions for the year and write the date into the Filings tab.

How do I track who got their year-end form?

Use the Form column on the People tab. Mark each person Ready when the form is checked and Sent when it is mailed or posted. Add a note for anyone whose address changed.

  • #tax-tracker
  • #payroll-year-end-checklist
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…