Home › Templates › Month-End Close Checklist Template
Month-End Close Checklist Template
A working close checklist with 32 standard tasks across ten areas. It calculates due dates in business days, flags overdue items, and reports progress by area.
Free. Excel .xlsx format, no macros, no registration.
Contents
| Tab | Purpose |
|---|---|
| Instructions | Purpose, steps, a guide to each tab, the colour key and a list of every built-in check with its result. |
| Inputs | Period end, status date, and a progress summary overall and by area. |
| Schedule | The checklist: area, task, owner, due date, status, preparer and reviewer. |
| Journal Entry | Register of recurring month-end entries with amount, support and posted status. |
| Reconciliation | Balance sheet account reconciliations: ledger balance, supporting balance, difference and status. |
| Lists | Areas, owners and statuses used in the dropdowns, and holidays. |
Features
- Due dates are set in business days after period end, skipping weekends and the holidays you list.
- Tasks past due at the status date are highlighted, and tasks completed late are counted.
- A target close date shows whether the plan fits your close calendar.
- The summary reports percent complete, overdue tasks, unposted entries and unreconciled accounts, overall and by area.
- Tasks, areas and owners are fully editable. Capacity is 100 tasks, 30 recurring entries and 40 reconciliations.
Instructions
- On the Lists tab, set your areas and owners.
- On the Schedule tab, adjust the task list, owners and due days.
- Update status as work is completed.
- Use the Journal Entry and Reconciliation tabs to track recurring entries and account reconciliations.
- Review the summary on the Inputs tab.
Notes
To start a new month, change the period end date and reset the statuses, completion dates and posted flags.
Related calculators
- Accrued Interest CalculatorCalculate interest accrued on a loan or note for a number of days, on a 365-day or 360-day basis.
- Prepaid Expense Amortization CalculatorCalculate the monthly expense, the amount recognized to date and the remaining prepaid balance for a cost paid in advance.
- Depreciation Schedule CalculatorBuild a depreciation schedule by straight-line, double declining, 150% declining or sum-of-the-years-digits, with a partial first year.
More accounting templates
- Depreciation Schedule TemplateFixed asset register with monthly depreciation, disposals, roll-forwards by class, journal entries and general ledger reconciliation.
- Loan Amortization Schedule TemplatePayment-by-payment amortization with extra principal, journal entries for payment, accrued interest and the current portion, and a lender reconciliation.
- Bank Reconciliation TemplateTwo-sided bank reconciliation with outstanding items, book adjustments and the adjusting journal entry.
- Accounts Receivable Aging TemplateInvoice-level aging with customer totals, allowance calculation, journal entry and control account reconciliation.
- Prepaid Expense and Accrual Schedule TemplatePrepaid amortization and accrued expense schedules with both journal entries and ledger reconciliations.
- 13-Week Cash Flow Forecast TemplateWeekly receipts and disbursements for one quarter, with closing cash, minimum balance alerts and forecast-to-actual tracking.
Need a version built for your process? Request a custom template quote.
To report an error or request a calculator or template, send feedback.
Templates are provided for general information. They are not accounting, tax or legal advice. Review the formulas and results before relying on them.