Free download · no email required
Excel workbook (.xlsx) with formulas that total themselves. Opens in Excel, Google Sheets, or Numbers.
Download the checklist (Excel)The month-end close is the routine that turns a month of raw transactions into numbers someone can trust. Done well it is boring and repeatable. Done badly it is a scramble that produces figures nobody believes. The difference is almost always a checklist: a fixed running order so the same steps happen in the same sequence every period, and nothing gets skipped because the person doing the close was interrupted halfway through.
This template lays out the close as a sequence of tasks grouped by area, with an owner column, a target working day, a status column, and a notes field. It is deliberately generic so it works whether you are closing one set of books or thirty client files. Import it into your spreadsheet tool, delete the rows that do not apply to a given client, and save a copy per client so each one carries its own quirks.
What the checklist covers
The order matters. Reconciliations depend on every transaction being posted first, so the sequence moves from data entry, to reconciliation, to adjustments, to review, to lock.
- Cash and bank. Reconcile every bank account and the petty cash float to its statement, then investigate anything still uncleared from prior months.
- Receivables and payables. Post all customer invoices, supplier bills, and expense claims, then reconcile each ledger to its aged listing so the control accounts agree.
- Accruals and prepayments. Accrue for goods and services received but not yet invoiced, and release the month’s share of prepaid costs.
- Fixed assets. Post depreciation, and record any additions or disposals in the period.
- Tax and payroll. Reconcile the VAT or GST control account, and post the payroll journal so wage costs and liabilities are complete.
- Review and lock. Compare the profit and loss to budget or the prior month, clear the suspense and balance-sheet accounts, then lock the period and back up the file.
How to use the template
Assign an owner to every row, even if that owner is you. The point of the column is that on a busy month the work can be split or handed over without anyone guessing what is still outstanding. Set the working-day targets to match your reporting deadline: a practice that reports to clients by the tenth of the month works backwards from there.
Use the status column ruthlessly. A half-reconciled bank account marked blank looks identical to one that has not been started. Mark each row “in progress”, “done”, or “n/a” so a glance tells you where the close actually stands.
Where the time really goes
The reconciliations on this list are quick when the underlying data is complete. What stretches a close is missing source documents: the credit-card receipt nobody photographed, the supplier bill still sitting in an inbox, the cash expense remembered three weeks late. Every one of those forces a choice between waiting, chasing, or estimating, and each choice slows the close.
The structural fix is to stop the documents going missing in the first place. Tools that help:
- Hubdoc pulls statements and recurring bills from connected suppliers so they are in the file before close day.
- ExpenseFlow captures receipts, bills, and expense claims as they happen, reads the VAT or GST, codes each one, and posts it into Xero or QuickBooks Online with the source image attached, so by the time you start the close the payables and credit-card work is already done.
- Dext lets clients photograph receipts into a shared inbox you process in batches.
A close built on captured-at-source data is a review exercise, not a data-entry marathon. The checklist stays the same; the rows just take minutes instead of hours.
Common mistakes
- Skipping the balance-sheet review. The profit and loss gets all the attention, but the errors that compound month to month hide in the balance sheet: an unreconciled control account, a suspense balance, a prepayment never released.
- Not locking the period. An unlocked month invites a backdated entry that quietly breaks a reconciliation you already signed off.
- Treating every month identically. Quarter ends carry VAT or GST returns and often a deeper review. Build those extra rows into the quarter-end copy of the checklist rather than remembering them on the day.
Save the template, tailor it once per client, and the close becomes the same calm sequence every month.