Rounding Robin

Home › Templates › Month-End Close Checklist Template

Month-End Close Checklist Template

A working close checklist with 32 standard tasks across ten areas. It calculates due dates in business days, flags overdue items, and reports progress by area.

Download the Excel template

Free. Excel .xlsx format, no macros, no registration.

Contents

TabPurpose
InstructionsPurpose, steps, a guide to each tab, the colour key and a list of every built-in check with its result.
InputsPeriod end, status date, and a progress summary overall and by area.
ScheduleThe checklist: area, task, owner, due date, status, preparer and reviewer.
Journal EntryRegister of recurring month-end entries with amount, support and posted status.
ReconciliationBalance sheet account reconciliations: ledger balance, supporting balance, difference and status.
ListsAreas, owners and statuses used in the dropdowns, and holidays.

Features

Instructions

  1. On the Lists tab, set your areas and owners.
  2. On the Schedule tab, adjust the task list, owners and due days.
  3. Update status as work is completed.
  4. Use the Journal Entry and Reconciliation tabs to track recurring entries and account reconciliations.
  5. Review the summary on the Inputs tab.

Notes

To start a new month, change the period end date and reset the statuses, completion dates and posted flags.

Related calculators

More accounting templates

Need a version built for your process? Request a custom template quote.

To report an error or request a calculator or template, send feedback.

Templates are provided for general information. They are not accounting, tax or legal advice. Review the formulas and results before relying on them.