The Month-End Close Checklist for Small Finance Teams (Free Excel Template)
Every month you close the books from memory. It mostly works — until someone is on leave, a prepayment release gets forgotten, or you find out on day nine that nobody reconciled the second bank account. Then you are re-opening a period you thought was finished, and the numbers you sent the board were wrong.
A written checklist fixes that, and it does not need to be a system: one Excel sheet with tasks, owners, due days and a status dropdown is enough. Below is the task list in order, the formulas that track progress, and the free template. (For matching a statement to a ledger, see the bank reconciliation guide; for explaining the numbers, variance analysis.)
Download the template first
hisab-month-end-close-checklist.xlsx — free, no signup. What is inside it, accurately:
- 20 tasks, grouped across: Cash & bank, Revenue, Receivables, Payables, Payroll, Fixed assets, Prepayments, Inventory, Tax, Intercompany, Review, Reporting, Close.
- Six columns: #, Task, Owner, Status, Due day, Notes.
- Status is a Data Validation dropdown with four options: Not started, In progress, Done, N/A.
- A Progress % cell counting tasks marked "Done" over the total.
That is the whole thing — deliberately small, because a checklist you fill in beats a 200-row workbook you abandon in month two. Two companions cover the reporting step: the profit and loss template and the balance sheet template.
Why write it down at all
Consistency: an unwritten close quietly changes shape — a task gets skipped once, then never comes back. Handover: when the usual person is away, the checklist is the handover document. Audit trail: owners, dates and notes record that the work was done, so when an auditor asks "who reconciled this, and when", the answer is a cell.
The close, in order
The task set below follows Intuit's published Month-end close checklist for QuickBooks. It is a vendor document — no accounting body we could find publishes a canonical month-end list — so adapt it rather than obeying it.
It opens with a "Gather this info first" section listing exactly: total income/revenue; accounts receivable; bank accounts and statements; expense receipts and supplier invoices; petty cash totals; inventory total. Get those six on your desk first. Then the ten steps, in Intuit's order:
| # | Step (Intuit's wording) | Covers |
|---|---|---|
| 1 | Create a closing schedule | Owners, dates, sequence |
| 2 | Record sales | Income, revenue, receivables |
| 3 | Reconcile expenses | Vendor statements, supplier invoices, payables |
| 4 | Record petty cash | Cash tin, small reimbursements |
| 5 | Record customer invoices and payments | Cash application |
| 6 | Review assets and liabilities | Loans, accrued expenses, deferred revenue, equipment |
| 7 | Reconcile bank statements | Bank and card accounts |
| 8 | Count inventory | Physical vs book |
| 9 | Reconcile income and payroll | Payroll cost, deductions, liabilities |
| 10 | Prepare financial reports | P&L, balance sheet, cash flow, KPIs |
What each step means in practice
One departure: the template puts bank reconciliation early rather than at step 7, because everything downstream depends on cash being right. Reorder to suit your business — the value is a fixed sequence. Five things the step names do not tell you:
Reconcile every account, not just the main one — cards and petty cash included. Each needs a closing statement balance, an adjusted balance after deposits in transit and outstanding cheques, and a difference of zero. Our bank reconciliation template prints "RECONCILED" or "OUT BY amount".
Cut-off is one question: was the good delivered or the service performed before period end? Invoices dated in the period for work not yet done belong in deferred revenue — Intuit's step 6. Then post receipts and pull an aging; if it lands as a pivoted layout that will not sort, cleaning messy data covers unpivoting.
The invisible tasks need their own rows. Goods received but not yet invoiced belong in the period as an accrual, so work from the goods-received log or open purchase orders — the invoice pile is by definition missing the ones you want. Same for releasing this month's portion of each prepayment. Nothing prompts either one; only the checklist asks.
Tax and intercompany early, not last. Reconcile the VAT/GST or sales-tax control accounts now, not the week the return is due, and agree intercompany balances before closing — an unagreed difference blocks consolidation.
Add a review layer before reporting. Zoho Books' Academy guidance on closing the books runs: update the general ledger, calculate ledger totals, take a preliminary trial balance, add adjustments such as depreciation, prepare a new trial balance, run variance analysis, then generate the statements. Then the pack — P&L, balance sheet, cash flow, KPIs — and the last line: lock the period. What that is called differs by system, so check your software's docs.
One thing to keep straight: zeroing out revenue and expense accounts does not belong in a monthly checklist — that is a year-end step (see the FAQ).
Assigning owners and due days
Owner must be a person, never a team — "Finance" is not an owner. If one person does the whole close, put your own name against all 20; it still tells a stand-in nobody else is covering.
Due day should be relative — day 1, day 2, day 3 — not a date, which keeps the sheet reusable: copy it, rename the tab, clear the statuses, and the due days still hold. A workable shape: inputs and sales on day 1; bank, card and AP reconciliations on day 2; accruals, prepayments, depreciation and payroll on day 3; inventory, tax and intercompany on day 4; trial balance, variance analysis, reporting and period lock on day 5.
Tracking it in Excel
Build the Status dropdown
Building your own sheet? The path on Windows desktop Excel:
- Type the status options in a single column with no blank cells — ideally inside an Excel table, because dropdowns based on a table update automatically as you add or remove items.
- Select the cells to restrict (the Status column).
- Data tab > Data Validation (in the Data Tools group).
- On the Settings tab, in the Allow box, choose List.
- Click in the Source box and select the list range, excluding header rows — or type entries separated by commas, e.g.
Not started,In progress,Done,N/A. - Tick In-cell dropdown, plus Ignore blank if empty cells are allowed. Optionally set an Input Message or Error Alert on their tabs, then click OK.
In Excel for the web it is Data tab > Data Tools > Data Validation; on Mac, on the Data tab, under Tools, select Data Validation or Validate. One caveat: validation cannot be changed while the workbook is shared or the sheet is protected, so set it up before you protect.
The Progress % formula
Say Status sits in D2:D31 and task names in B2:B31 (adjust to your row count). Completed tasks: =COUNTIF(D2:D31,"Done").
The obvious percentage is =COUNTIF(D2:D31,"Done")/COUNTA(D2:D31), formatted as Percentage — but it has two failure modes. An empty status range returns #DIV/0!. And COUNTA counts error values and empty text "" as non-empty, so formulas returning "" inflate the denominator. Both disappear if you count the task-name column and wrap the division:
=IFERROR(COUNTIF(D2:D31,"Done")/COUNTA(B2:B31),0)Use that form: the denominator becomes the number of tasks that exist. COUNTIF(range, criteria) takes exactly two arguments, both required, and text criteria must be quoted. It is case-insensitive, so "done", "Done" and "DONE" all match.
For one person's progress, switch to COUNTIFS with owners in C2:C31: =COUNTIFS(D2:D31,"Done",C2:C31,"Priya"). It allows up to 127 range/criteria pairs, and every additional range must have the same number of rows and columns as the first. COUNTIF, COUNTIFS and COUNTA all work in Excel for Microsoft 365, 2024, 2021, 2019 and 2016, plus the Mac equivalents.
Checkboxes, if everyone is on Microsoft 365
Select the range, then Insert > Checkbox. A checkbox is the values TRUE and FALSE with checkbox formatting, so it flows straight into formulas — Microsoft's example is =IF(A1,"Checked","Unchecked"). Spacebar toggles selected boxes; Home > Clear > Clear Formats keeps the TRUE/FALSE values, while Delete removes the boxes (twice if any are checked). Progress becomes =IFERROR(COUNTIF(D2:D31,TRUE)/COUNTA(B2:B31),0).
The catch: Microsoft documents Insert > Checkbox for Excel for Microsoft 365 and Microsoft 365 for Mac only. If anyone is on a perpetual licence (2019, 2021) or in Excel for the web, keep the dropdown as the primary mechanism — which is why the template ships with it. Microsoft does not document how a 365-made checkbox behaves in an older build, so do not assume it degrades gracefully.
How to know the close is genuinely done
"Progress 100%" is not the finish line. Four gates: every reconciliation prints zero or "RECONCILED"; the balance sheet balances (the balance sheet template prints "OK - balanced" or "OUT BY amount"); every material variance has a written explanation; and the period is locked.
What actually makes a close slow
No statistics here: the one credible benchmark for monthly close cycle time is behind member gating, and the day counts circulating on vendor blogs do not trace back to a study we could read. So — causes, in the order we would fix them.
1. Waiting for inputs. Move input-gathering to day 0 — the last working day of the month — and make chasing the missing supplier invoice a named task, not a shared hope.
2. Manual re-keying. Exporting the ledger, pasting it in and fixing the layout every month is where hours go. Built-in Excel handles it: Power Query re-runs the same import-and-clean steps on next month's export with one refresh.
3. Reconciliation by eyeball. A COUNTIFS match column beats ticking 400 lines by hand — its limitation is that amount-only matching cannot handle one deposit covering several invoices, or descriptions that differ between the two sides. Fuzzy matching in Excel covers the description problem.
4. Rebuilding the same report. Build the pack once with live formulas against a pasted export — the P&L template's Transactions sheet exists for this, with a worked SUMIFS example.
5. No sequence, and no test for "done". Otherwise you find the cash error after building the P&L, and ambiguous tasks stay ambiguous.
All of that works with nothing but Excel and a written list. Read on only if the re-keying in points 2 and 4 is what you want to stop doing by hand.
Where HISAB 360 fits
Points 2 and 4 repeat identically every month, which is where HISAB 360 helps: a paid Excel add-in with an AI chat panel that applies the work to your live workbook.
- Pulling actuals. It connects to QuickBooks Online, Xero, Zoho Books, Odoo, FreshBooks and Sage with full read and write, dropping invoices, bills, payments, journals, ledgers and reports into the sheet. See connecting QuickBooks and Xero to Excel.
- Reconciliation. Its AI bank reconciliation matches on amount and date tolerance, handles many-to-one deposits and fuzzy descriptions, flags duplicates and produces a report — the cases plain
COUNTIFScannot cover. - Reports and PDFs. Ask in plain English and it writes and applies formulas, Power Query steps, PivotTables, data-model measures or charts; it also extracts tables out of PDF statements into a structured range.
What it does not do. HISAB has no scheduling and no automated emailing — it will not run your close on day 3 or send the pack to your director, and there is no continuous background sync. Nor does it track checklist status; the template above is the tracker. It is Windows desktop Excel only (not Mac, not the web), connecting a ledger means authorising it via OAuth, and any write back should be reviewed before approval and reconciled afterwards.
Pricing: $7/month or $60/year if you bring your own AI provider key, $10/month for HISAB AI Basic, $20/month for HISAB AI Plus, or $199 perpetual. Credit top-ups are $4.99 and $12.99, where 1 credit is 1 cent of AI usage. There is a 15-day free trial of every feature plus 50 HISAB AI credits, no credit card required, once per machine — there is no permanently free tier, so after the trial it is paid. Detail on pricing and features.
Start this month
Download the month-end close checklist, put a real name in every Owner cell, and set relative due days. Run one close without changing anything, then add the tasks you found missing. By month three you will have a close that survives someone being away.
Frequently asked questions
How many tasks should a month-end close checklist have?
Enough that nothing is unwritten, few enough that you finish it. Our template ships 20 across the thirteen categories listed above, which suits a small single- or few-entity business. Add rows for what is specific to you rather than starting from a hundred-row list.
How long should a month-end close take?
We will not give you a number. The one benchmark owner with real data publishes it to members only, and the day counts quoted on vendor sites do not trace back to a study anyone can read. Judge yourself against your own trend instead.
What is the correct formula for a progress percentage?
=IFERROR(COUNTIF(D2:D31,"Done")/COUNTA(B2:B31),0), where D is Status and B the task name, formatted as Percentage. Counting the task-name column as the denominator avoids two problems: an empty status range causing #DIV/0!, and COUNTA treating formula-produced "" as non-empty and inflating the total. COUNTIF is case-insensitive, so "done" and "Done" both count.
Should I use checkboxes or a dropdown for status?
A dropdown, unless the whole team is on Microsoft 365. Native in-cell checkboxes via Insert > Checkbox are documented only for Excel for Microsoft 365 and Microsoft 365 for Mac, so a file opened in Excel 2019 or 2021 should rely on a Data Validation list. A dropdown also records In progress and N/A, which TRUE/FALSE cannot.
Do I close revenue and expense accounts to zero every month?
No. Zeroing revenues and expenses is a year-end step that readies the ledger for the next financial year — those accounts close to retained earnings at fiscal year end. Monthly, you post adjusting entries and lock the period.
Which tasks are easiest to forget?
Accruals for goods received but not invoiced, and prepayment releases. Both are invisible by nature: no document arrives to prompt you, so if the checklist does not ask, nothing does. Give each its own row with a named owner.
Try HISAB 360 on your own workbook
HISAB 360 is an AI assistant inside Excel for accountants and finance teams — it writes macros, Power Query and formulas from plain English, and connects two-way to QuickBooks, Xero, Zoho Books, Odoo, FreshBooks and Sage. The 15-day trial is the full product, no card required.