Download K: Month-End Close Checklist (.xlsx)
What it does
Close calendar for a toll road / InvIT finance team. Working days turn into real dates (skipping weekends and holidays), with status, overdue flags and % complete by area.
Who it is for
Controllers and finance managers who run the close.
How to use it
- Go to 'Settings'. Type the month-end date you are closing (for example 30-Sep-2026) and the 'as of' date (today's date when you update the file). Type your holidays in the list.
- Go to 'Checklist'. Review the sample tasks. Change, delete or add tasks; for each one choose the area, type the owner and reviewer, and the working day: 0 = last working day of the month, 1 = first working day after month-end, -1 = one working day before, and so on.
- As work progresses, change 'Status' (Not started, In progress, Done, Not applicable) and type the completion date.
- Overdue tasks and tasks done late are highlighted. The 'Dashboard' tab shows % complete by area and overall.
- Save a copy for each month (for example Close-Sep-2026.xlsx) to keep an audit trail.
Tabs in the file
| Tab | What it holds |
|---|---|
| Settings | Month-end date, as-of date and holidays. |
| Checklist | Tasks with area, owner, reviewer, working day, due date, status and flags. |
| Dashboard | Progress by area and overall. |
Learn the topic
For computation and reconciliation assistance only; not a substitute for formal statutory audit or legal tax advice. All sample data is illustrative and made up. Rates, limits and rules must be checked against current law and your own agreements before use. No tax saving, audit outcome or compliance result is promised.