First page of the Month-End Close Checklist Template (Excel)Excel workbook preview

Month-end close

Month-End Close Checklist Template (Excel)

Month end close checklist in Excel: 51 tasks in 13 phases with owners, reviewers, workday due dates, overdue flags and a live close summary per phase and owner.

Excel workbook · 20 KB General finance practice

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

A month end close checklist lists every task that has to happen before the books for a month are final, who does it, who reviews it and by which working day. Auditors, new finance leaders and lenders ask for one because a close that lives in people's heads cannot be checked, delegated or sped up. This workbook gives a controller a complete, ready checklist for a mid-size company with manufacturing, subscriptions and foreign subsidiaries.

The Close Checklist sheet holds 51 tasks in 13 phases with owners, reviewers and due workdays. Due dates come from the period end and a holiday list with WORKDAY, so the calendar rolls forward each month. The Summary sheet shows progress per phase and per owner and the workday the close finished. Quarter-end tasks for SEC registrants cite the free eCFR text and Form 10-Q instructions, and the retention task cites IRS guidance.

Who it is for

The controller who was asked by a new CFO or the auditor for a written close checklist and has only a list in someone's head.

What is inside

  • 51 close tasks in 13 phases, from pre-close to the post-close retrospective
  • Owner, reviewer and due workday on every task, with due dates calculated by WORKDAY from the period end
  • Company holiday list that every due date skips
  • Status dropdown with colours, overdue dates in red and a days-late formula
  • Summary sheet with tasks, done, N/A, open, overdue and % complete per phase, plus open and overdue tasks per owner
  • Close metrics: target close date, last completion date, the workday the close finished and whether the target was met
  • Quarter-end tasks for SEC registrants citing 17 CFR 240.13a-14, 240.13a-15(d) and the Form 10-Q deadlines
  • 16 blank formatted rows for your own tasks and a How to use sheet

How to use it

Enter your period end date and company holidays on the Close Setup sheet, then replace the owners with your own people.

Files

  • XLSXmonth-end-close-checklist-template.xlsx20 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Based on general finance practice, not on one published standard. A template to adapt, not legal, tax or accounting advice.

Questions about this template

What should a month end close checklist include?

It should cover cut-off, cash and bank reconciliations, receivables, payables, payroll, inventory, fixed assets and prepaids, accruals, intercompany and consolidation, tax, account reconciliations, flux review, reporting and sign-off. Each task needs an owner, a reviewer and a due day. This template lists 51 such tasks in 13 phases so nothing depends on memory.

How many days should a month end close take?

There is no fixed rule. The right target depends on the number of entities, systems, manual journals and reviewers involved. Set your own target workday on the Close Setup sheet, track the actual finishing workday on the Summary sheet, and use the retrospective task to remove the causes of late tasks.

Do the due dates update when the month changes?

Yes. Each task has a workday number counted from the period end. Change the period end date on the Close Setup sheet and every due date recalculates with the WORKDAY function, skipping weekends and the company holidays you list on the same sheet. Clear the status and completion dates at the start of each close.