Month-End Checklist in Excel: Free Template

A month-end checklist in Excel should show every close task, its owner, due date, status, evidence, reviewer, and exception. A useful workbook is more than a list of boxes: it creates a repeatable control that shows what is complete, what is blocked, and whether the financial statements are ready for review.

You can build the template below in a normal Excel table. Keep one protected master, duplicate it for each period, and preserve completed versions rather than overwriting prior evidence.

Recommended checklist columns

Copy-ready month-end task list

Paste the following tasks into the Task column, then tailor them to the company’s accounts, systems, and reporting obligations.

• Lock the transaction cutoff and collect all bank, card, loan, payroll, merchant, and platform statements.
• Record or match valid cash activity through the period end.
• Reconcile every bank and credit-card account.
• Reconcile payment-processor, marketplace, payroll, and transfer clearing accounts.
• Review outstanding checks, deposits in transit, failed payments, and stale items.
• Reconcile accounts receivable detail to the general ledger and review aging.
• Reconcile accounts payable detail to the general ledger and review vendor statements.
• Record payroll, taxes, benefits, reimbursements, and payroll liabilities.
• Review inventory, cost of goods sold, work in progress, and shrinkage where applicable.
• Update fixed assets, disposals, depreciation, and amortization.
• Reconcile loans, leases, interest, principal, and current portions.
• Record prepaid expense and deferred revenue activity.
• Accrue material earned revenue and incurred expenses not yet recorded.
• Review owner, shareholder, related-party, and intercompany activity.
• Review suspense, uncategorized, opening-balance, and unusual accounts.
• Run the trial balance and compare it with prior periods and expectations.
• Review profit and loss, balance sheet, cash flow, and supporting schedules.
• Document significant variances and unusual transactions.
• Confirm required tax, payroll, sales-tax, lender, or management reports are prepared.
• Obtain reviewer approval and archive the final close package.

Build the Excel template

1. Create a sheet named Close Checklist and place the column headers in row one.
2. Convert the range to an Excel table so filters and formulas extend consistently.
3. Add data-validation lists for Area, Status, Owner, and Reviewer.
4. Use real Excel dates for period end, due date, completion date, and review date.
5. Add conditional formatting for overdue, blocked, and completed tasks.
6. Create a summary area that counts tasks by status and owner.
7. Protect formula and reference cells while leaving input fields editable.
8. Save a clean master and copy it into the close folder for each period.

Microsoft’s current Excel guidance supports tables, data validation, and conditional formatting. Menu locations may vary by platform and version, but the control design should remain consistent.

Useful formulas

If the table is named CloseTasks, a completion percentage can divide completed tasks by all nonblank task IDs. In a normal Excel formula, use a COUNTIF for the status “Complete” and divide it by COUNTA for the task IDs. Wrap the calculation in IFERROR so an empty template displays zero.

An overdue flag should test whether status is not Complete, a due date exists, and the due date is earlier than today. A blocked count can use COUNTIF on the Status column. Keep the dashboard simple enough that a reviewer can trace every number back to visible rows.

Status rules

• Not started: work has not begun and the prerequisite is available.
• In progress: the owner is actively preparing the task.
• Blocked: a named dependency prevents completion.
• Prepared: evidence is attached and ready for review.
• Complete: preparation and required review are finished.

Do not mark a task Complete merely because an entry was posted. Completion should include final evidence and the required review. Define the statuses in a separate Instructions sheet so different team members use them the same way.

Design for dependencies

Some tasks cannot finish until others are complete. Cash reconciliation may depend on the statement; revenue review may depend on processor reconciliation; financial-statement review depends on major balance-sheet reconciliations. Add a Depends On column when the close has many handoffs.

For each blocked task, record the dependency, owner, date requested, expected resolution, and financial-statement impact. A red cell alone does not tell management what decision is needed.

Evidence links and version control

Link to the final statement, reconciliation, schedule, report, or memo rather than a temporary download folder. Use consistent file names that include entity, account, period, and version. Restrict sensitive payroll, bank, customer, and employee data to authorized users.

Do not replace prior-period files. Freeze the completed checklist as part of the close package, record late adjustments separately, and explain any reopened period. The workbook should show who changed a status and why, even if that requires a separate change log.

Review checklist

• Every expected task is present for the current entity and period.
• Every completed task has accessible final evidence.
• Every material balance has a reconciliation or supporting schedule.
• Every blocked or overdue task has an owner and resolution date.
• Every unusual adjustment has support and approval.
• Financial statements agree with the final trial balance.
• Preparer and reviewer responsibilities are separated where practical.

Common Excel checklist mistakes

Avoid merged cells, manually colored statuses, free-text owner names, broken links, hidden exceptions, and one workbook reused by overwriting prior months. Do not place sensitive credentials in the file. Avoid formulas that silently exclude newly inserted rows by using an Excel table and testing the copied period before the close begins.

For the underlying process, review the month-end close checklist and reconciled balances. Businesses that want a recurring close can review bookkeeping services.