Excel workbook previewMonth-End Close Checklist Template (Excel)
3 free downloads per account. Just your email and a 6-digit code.
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.




