A good close checklist isn't a to-do list. It's a schedule with owners, reviewers and evidence.
A month-end close checklist template lists every close task with an owner, a reviewer, a working-day deadline, a status and a link to the evidence. Build it in Excel with a period-end date cell, calculate due dates with WORKDAY, flag overdue tasks automatically and track percentage complete, then review it after every close to remove or add tasks.
Put the period-end date in a cell named PeriodEnd and a list of public holidays in a range named Holidays.
Due date from the working day number. Working day 0 is the period end itself; working day 1 is the first working day after it:
=WORKDAY(PeriodEnd,F2,Holidays)
For pre-close tasks, use negative numbers: WORKDAY(PeriodEnd,-2,Holidays) gives two working days before period end.
Overdue flag:
=IF(AND(H2<>"Done",H2<>"Reviewed",TODAY()>G2),"OVERDUE","")
Percentage complete, counting reviewed tasks only:
=COUNTIF(H2:H300,"Reviewed")/COUNTA(C2:C300)
Self-review check, so nobody reviews their own work:
=IF(D2=E2,"SAME PERSON","")
Use data validation for the Status column so the formulas always match the text.
Before period end: confirm the close calendar, send cut-off reminders, chase outstanding expense claims and approvals.
Day 1-2:
Day 3-4:
Day 5 onwards: management accounts, variance commentary and the reporting pack. See the month-end reporting pack.
Each task should leave something a reviewer or auditor can see: a reconciliation, a journal number, a report. The evidence link column turns the checklist into an audit trail. A task isn't finished until the reviewer marks it Reviewed.
After each close, spend fifteen minutes on three questions: which tasks were late and why, which tasks added nothing, and what went wrong that no task covered. Update the template before next month. For deeper changes, see how to shorten the month-end close.
UK teams often call this the "month-end close checklist" or "close timetable"; US teams use "close checklist" or "close calendar". Keep separate holiday lists if you close entities in different countries.
Reviews every balance sheet reconciliation with an on-device AI and 20 review tests, flags vague and wrong-account reconciling items, and builds a risk-ranked review queue. Runs in your browser on your own computer: nothing is uploaded.
12 questions on how strong your close controls are. Free to use online.
The Month-End Close & Controls System tests the trial balance against the sum of reconciled balances, keeps every open item on one exception dashboard and blocks sign-off while exceptions remain open. Excel, no macros, one-time price.
Enough to cover every journal, reconciliation and review that happens each month. Group minor steps under one task rather than leaving them out.
Yes. Separate columns for owner and reviewer make it clear who is accountable and prevent self-review.
For most small and mid-sized teams, yes, if it has clear owners, deadlines and evidence links. See close software vs Excel for when to move on.
Last updated 28 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.