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

Small Business 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

Owners and bookkeepers use this small business year-end checklist to close the year in an orderly way. The Plan tab is a timeline of tasks with owner, start and end dates and percent done. The Reconciliation tab compares each statement balance with the books and flags differences. The Stock tab values the counted items. The Status tab counts tasks in each area and the accounts that still differ.

Add tasks early and set a realistic date with one person in charge of each task. Work through reconciliation first, because later steps depend on right balances. Count stock on a quiet day and write unit costs the same way every year. Send the finished workbook to your accountant along with the bank statements.

Useful for

  • Close the books with a dated plan and named owners
  • Find accounts that do not match the books
  • Value and record a year-end stock count

What's included

  • 5 tabs: Status, Plan, Reconciliation, Stock, How to use
  • Status: a dashboard with 4 summary figures
  • Plan: a Gantt timeline
  • Reconciliation: a table
  • Stock: 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 Plan 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 jobs close out the books for a small business?

Reconcile every account, enter late invoices and bills, count stock, confirm payroll totals, send forms to employees and contractors, and give the books to your accountant. The Plan tab turns these into dated tasks.

How do I reconcile my bank account?

Compare the ending balance on the statement with the balance in your books. Look for items in one but not the other, such as late charges or fees. Enter what is missing until the difference is zero.

When should I count inventory?

Many businesses count at year-end, on a quiet day, after stopping sales or noting what sold. Count each item twice if you can. Record the count and unit cost in the Stock tab for your accountant.

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

Also in Finance

All finance templates
Get this template

Preparing your template…