Blog · Board and management reporting · Finance and FP&A teams
Financial controller KPIs measure close timeliness, reconciliation exceptions and accounting correction rates. Build a scorecard from close logs and finance exports, with explicit definitions and a worked reconciliation.
A useful KPI for a financial controller measures close speed together with accounting control quality. Start with close duration, the share of required reconciliations approved on time, unresolved differences and the rate of original journal entries requiring correction. Each result needs a defined population, a cutoff and a route back to the underlying records.
Company revenue growth and profitability belong in the broader financial KPIs package. A controller's operational scorecard answers a different question: how reliably did finance produce the numbers that everyone else uses?
The controller needs to know whether the close met its release date, whether required reconciliations received review, and whether unresolved items could change reported results. A fourth question concerns rework: which accounting processes repeatedly produce corrections?
The relevance of journal authorization and period-end adjustments is reflected in PCAOB AS 2201, paragraphs .26-.27, in its auditing standards booklet. Those paragraphs describe elements of the period-end reporting process in an audit context. They do not prescribe the scorecard or numerical targets below.
| Question | Measure | Source file | Responsible owner |
|---|---|---|---|
| When were results approved? | Elapsed close days | Close milestone log | Controller |
| Did required review finish on time? | On-time reconciliation rate | Required reconciliation register and approvals | Accounting managers |
| What remains unresolved? | Open count, age and absolute difference | Reconciliation exception export | Account owners |
| Where did accounting require rework? | Original-entry correction rate | Journal register and correction log | Accounting process owners |
Agree on definitions before setting targets. A deadline is a management choice based on the business calendar and reporting needs. There is no universal close duration or correction rate that proves good control.
For reconciliation timeliness, start with the full register of required reconciliations, including those nobody completed. A register containing only submitted work excludes missing items from the denominator and flatters the result.
Keep reconciliation ID, account, entity, reporting month, due date, preparer, reviewer, approval date and status. For open differences, retain an exception ID, opening date, amount, currency, owner and resolution reference. Count distinct records at their intended level: a reconciliation may contain several exceptions.
For journals, retain original journal ID, posting period, workstream and entry type. Link each confirmed error correction back to the original entry. An ordinary reversing accrual is not automatically an accounting error. Count the affected original once even when correcting it requires several entries.
This is the same discipline behind a useful KPI definition: a named measure with an explicit calculation and decision attached.
An illustrative US distributor reports September 2026 results. The period ends September 30, 2026, and the controller approves the management package on October 7, 2026. The company measures elapsed calendar days, excluding the period-end date, so close duration is seven days.
The reconciliation deadline is October 5, 2026. The following table shows the entire required population at the October 7 snapshot. Each reconciliation has at most one unresolved difference in this example; age means calendar days since that difference was identified.
| Reconciliation ID | Workstream | Approved by deadline? | Open difference? | Open age (days) | Absolute unresolved difference (USD) |
|---|---|---|---|---|---|
| R01 | Cash | Yes | No | 0 | 0 |
| R02 | Receivables | Yes | No | 0 | 0 |
| R03 | Inventory | No | Yes | 4 | 12,000 |
| R04 | Fixed assets | Yes | No | 0 | 0 |
| R05 | Accrued expenses | No | Yes | 6 | 8,000 |
| Total | 3 approved on time | 2 open | 20,000 |
The controller documents the two exceptions when approving the package. Whether an unresolved item permits release depends on the company's policy and the item's significance; approval does not make the difference disappear.
On-time reconciliation rate = Reconciliations approved by deadline / Required reconciliations
Open reconciliation rate = Reconciliations with an unresolved difference / Required reconciliations
The on-time rate is 3 / 5 = 60.0%. The open rate is 2 / 5 = 40.0%. One open item is older than five calendar days, and absolute unresolved differences total 12,000 + 8,000 = $20,000. These amounts identify balances needing explanation; they are not established losses or confirmed misstatements.
With the table in columns A:F, headers in row 1 and detail in rows 2:6, use these Excel formulas:
=COUNTIF(C2:C6,"Yes")/COUNTA(A2:A6)
=COUNTIF(D2:D6,"Yes")/COUNTA(A2:A6)
=COUNTIFS(D2:D6,"Yes",E2:E6,">5")
=SUM(F2:F6)
Format the first two results as percentages. Microsoft's guide to counting worksheet values explains that COUNTIFS counts rows meeting all specified conditions. Validate that IDs are present and unique before using their count as the denominator.
The journal export assigns every original entry to one owning workstream, preventing duplicate counting across accounts. The correction window runs through the same October 7 snapshot.
| Owning workstream | Original posted journals | Distinct originals requiring error correction |
|---|---|---|
| Cash | 25 | 1 |
| Receivables | 20 | 0 |
| Inventory | 15 | 1 |
| Fixed assets | 20 | 0 |
| Accrued expenses | 20 | 0 |
| Total | 100 | 2 |
Original-entry correction rate = Distinct original entries requiring error correction / Original posted entries in scope
The rate is 2 / 100 = 2.0%, rounded to one decimal place. It measures observed rework within the defined window, not the percentage of all entries that are ultimately correct.
Reconcile the five required IDs to the approved close checklist. Three on-time approvals plus two remaining reconciliations equal the five required items. Keep late completion separate from an unresolved difference: a late reconciliation could still be fully resolved at the snapshot.
Tie the journal denominator to the filtered source register: 25 + 20 + 15 + 20 + 20 = 100. Tie the two affected originals to two distinct IDs in the correction log. Check that every correction belongs to the original posting cohort and that ordinary scheduled reversals are excluded.
The immediate agenda is the older accrued-expense exception, the inventory difference and the causes of the two corrections. Assign an owner and resolution date to each. Compare recurring patterns across closes using the same observation window; a longer window naturally gives more time to discover errors.
Use management reporting for the monthly package receiving these results, and financial analytics when the next question concerns their effect on profit or cash.
Covirage is not affiliated with Microsoft.
Bring a close log, reconciliation register and journal correction export to Covirage with their IDs and cutoff dates intact. Covirage maps the columns; its tools compute and check the measures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See Covirage for finance teams for the supporting finance workflow.
There is no single measure that captures the whole role. Pair close duration with reconciliation completion and unresolved exceptions. Speed shows when results become available; the supporting quality measures show what remained unresolved when management received them.
Define a cohort of original posted entries and count the distinct originals requiring an error correction within a stated observation window. Separate scheduled accrual reversals and routine estimate updates from genuine errors. Retain the correction reason and link to the original entry.
Either convention can work if it is stated and applied consistently. Calendar days measure elapsed time directly; business days reflect the working calendar. Keep the same start event, approval event, holiday policy and treatment of reopened periods across comparisons.
No. An exception rate depends on which reconciliations were required and how reviewers identified differences. Missing work can make the score look better. Use the metric to direct investigation, alongside evidence of preparation, independent review and appropriate follow-up.