Skip to content
The title slide and first slides of the Nonprofit 990 Prep Checklist template

Nonprofit 990 Prep Checklist

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

Treasurers, board chairs and part-time bookkeepers at small charities use this checklist to prepare for the annual information return. The Checklist tab breaks the work into governance, finance, program, people and filing tasks with owners, dates and status. The Figures tab adds up revenue and costs and shows the program share of spending. The Officers and staff tab tracks roles, pay and conflict forms, and the Dashboard shows progress by section.

Begin by confirming the fiscal year end and the filing date, then spread the tasks among board members and staff so no one person holds all of them. Update statuses at each board meeting. When the books are closed, enter the totals on the Figures tab and give the whole workbook to your preparer. Keep a copy each year so the following team begins with a finished list.

Useful for

  • Share the filing work among board members
  • Collect minutes, forms and records before the preparer asks
  • See revenue, costs and program share on one page

What's included

  • 5 tabs: Dashboard, Checklist, Figures, Officers and staff, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Checklist: a table
  • Figures: a ready-to-fill form
  • Officers and staff: 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 Checklist 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

Which records feed a nonprofit annual return?

Expect to need financial statements, bank reconciliations, board minutes, conflict forms, program descriptions, pay for officers and key staff, and grant records. Use the Checklist tab to assign each one an owner.

Who should prepare the return?

Small organizations often work with a nonprofit accountant or preparer. This workbook organizes what that person will ask for. Confirm the right return and due date for your organization in the current IRS instructions.

What is the program share of costs?

It is program spending divided by total spending for the year. Funders and boards often like to see it. The Figures tab calculates it from the numbers you enter, but your preparer decides how costs are allocated on the return.

  • #tax-tracker
  • #nonprofit-990-prep-checklist
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…