Homechevron_rightExcel Templateschevron_rightMonth-End Close Tracker
Month-End Close Tracker
Stop managing your close in a shared email chain or a messy to-do list. This ready-to-use Excel template gives your finance team a single place to track every task, own every deadline, and report progress to management — all without any setup. Open the Settings sheet, enter your team names and close start date, and you're live in under two minutes. What's inside: The Dashboard updates automatically as your team logs progress. See total tasks, completion rate, and a live RAG status for each workstream at a glance. Overdue tasks surface instantly with a days-overdue count — no more chasing people for updates. The Task List comes pre-loaded with 75 tasks across five workstreams: Accounts Receivable, Accounts Payable, Payroll, Journals & Accruals, and Reporting. Every row turns green when complete, amber when in progress, and red when overdue or blocked. Assign owners from a dropdown, log notes, and track completion dates as you go. Built for teams of 4–10, typical close cycles of 3–5 days. Pre-loaded tasks include sub-ledger closes, intercompany reconciliations, payroll journals, accruals schedules, variance analysis, management accounts preparation, and CFO sign-off — the full close cycle, out of the box. No macros. No add-ins. Works in Excel 2016 and Microsoft 365. Download once, use every month.
inventory_2What's included
- check_circle75 pre-loaded finance close tasks (AR, AP, Payroll, Journals, Reporting)
- check_circleLive dashboard with workstream health and overdue alerts
- check_circleOwner Summary — per-person assigned/complete/% tracking
- check_circleAutomatic due date calculation from your close start date
- check_circleStatus dropdowns with colour-coded conditional formatting
- check_circlePre-filled demo data (Meridian Finance Ltd) so you can see it in action
- check_circleHow to Use guide sheet for quick onboarding
- check_circleCompatible with Excel 2016+, Excel 365, Google Sheets
One-time payment · no subscription