Days to close is the headline, but on its own it rewards speed over accuracy.
Useful month-end close KPIs cover speed, quality and control: working days to close, tasks completed on time, post-close adjustments, reconciliations completed and reviewed on time, aged unreconciled items, manual journal volume and review rejections. Define each one precisely, calculate it from your close checklist and journal data the same way every month, and review the trend.
Working days to close is the number of working days after period end until the management accounts are signed off. With the period end in PeriodEnd, the sign-off date in SignOff and holidays in Holidays:
=NETWORKDAYS(PeriodEnd+1,SignOff,Holidays)
If sign-off happens on the third working day after period end, the result is 3. Agree in writing what "closed" means: management accounts issued, ledger locked, or both.
Tasks completed on time is the share of checklist tasks done by their due date. With due dates in G, completion dates in I and task names in C of your close checklist:
=SUMPRODUCT((I2:I300<>"")*(I2:I300<=G2:G300))/COUNTA(C2:C300)
The first condition stops blank completion dates counting as on time.
Post-close adjustments are journals posted to the period after it was declared closed. Count them and total their absolute value. With a journal export showing period in B, posting date in C and amount in D:
=COUNTIFS(B:B,PeriodName,C:C,">"&SignOff)
This counts journal lines. To count journals, count unique journal numbers in a pivot of the same filtered rows.
Rising post-close adjustments usually mean the close is being rushed or reviews are weak.
Review rejections are reconciliations or journals sent back by the reviewer. A few show reviews are real; many show preparers need support or clearer guidance.
Prior-period errors found: anything corrected in this period that belonged to an earlier one.
=SUMIFS(C:C,B:B,"<"&PeriodEnd-60)
If items can be positive or negative, add a helper column with =ABS(C2) and sum that instead, so they don't net off.Keep one row per month and one column per KPI. Each month, paste the figures from the checklist and journal exports, then chart the last twelve months. A simple layout:
Add a target row at the top and conditional formatting that highlights any month worse than target.
For practical ways to move these numbers, see how to shorten the month-end close.
The KPIs are the same in the UK and US. US teams more often say "days to close"; UK teams may say "close timetable" or "reporting day". Keep the holiday list right for each country you close in, or working-day counts won't compare.
Reviews every balance sheet reconciliation with an on-device AI and 20 review tests, flags vague and wrong-account reconciling items, and builds a risk-ranked review queue. Runs in your browser on your own computer: nothing is uploaded.
12 questions on how strong your close controls are. Free to use online.
The Month-End Close & Controls System tests the trial balance against the sum of reconciled balances, keeps every open item on one exception dashboard and blocks sign-off while exceptions remain open. Excel, no macros, one-time price.
It depends on your size, systems and group structure. Set a target from your own current baseline and improve it steadily, while watching post-close adjustments.
They show whether a fast close is also an accurate one. A falling days-to-close figure with rising adjustments means quality is suffering.
Five to eight is usually enough: one or two for speed, two or three for quality and two or three for control.
Last updated 28 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.