Skip to content
The title slide and first slides of the Monthly Close Checklist template

Monthly Close Checklist

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 16, 2026

Every slide (5)

Overview

Closing the books is the same list of chores every month, and the chores slip when nobody owns them. Every step on this list carries an area, a person responsible, a deadline and a status. A step that is late and unfinished turns its whole row red. The sample is an October close for a small studio, with thirteen steps from downloading statements to locking the month.

The Reconcile tab lines up each statement balance against the books and marks the account Matched or Check, with the difference beside it. The Sign-Off tab records who prepared, reviewed and approved the month and shows the share of steps done, blocked steps and the net unreconciled amount. Duplicate the workbook each month and reset the statuses.

Useful for

  • Give a part-time bookkeeper and an owner one shared close list
  • Show an accountant which accounts were reconciled and when
  • Keep a signed record of each month's review

What's included

  • 4 tabs: Checklist, Reconcile, Sign-Off, How to use
  • Checklist: a table
  • Reconcile: a table
  • Sign-Off: a table with 4 summary figures
  • 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

What is a month-end close?

It is the routine of reconciling accounts, entering missing items and reviewing reports so a month's figures are final before the next month starts.

What steps should be on a close checklist?

Bank and card reconciliations, receivables and payables review, payroll, depreciation, accruals and a final report review. Add or remove steps to suit your business.

How long should a monthly close take?

Small businesses often finish in a few days, depending on how clean the records are. Due dates on each step show where the time goes.

  • #bookkeeping
  • #monthly-close-checklist
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More bookkeeping templates

See all 6

Also in Finance

All finance templates
Get this template

Preparing your template…