Numbers to Judgment
How an FP&A analyst gets from a count to a call, where the hours go, and why an AIly makes that work faster and more accurate.
These are the workflows most mid-size FP&A teams run. They're what we walk into discovery with, so the first conversation is about their work, not about AI. Every box below gets replaced by what Meridian's team actually does.
1The basic loop
Look, organize, form a recommendation is the right shape. Two steps hide inside it, and they're where most of the hours and most of the risk sit:
Most months the output isn't a recommendation. It's an explanation. A recommendation comes when the explanation changes the outlook.
Figure 1. The loop every FP&A workflow repeats. Four of six steps are assembly. Judgment sits at the gates.
2Where the numbers come from
Nobody makes them up, and the analyst doesn't count them. The business counts: every time a client is billed, a payroll runs or a vendor invoice is approved, a system of record captures it. Those systems post to the general ledger. At month-end the controller's team closes the books: they reconcile, accrue and lock the period. The usual benchmark puts that at about six days.
Is their repository populated already? Half of it is. Actuals arrive finished, from the analyst's point of view, and they re-pull them every month. The other half the analyst builds and maintains:
How do they get insight out? Mostly in Excel. They export from the ledger, paste into last month's workbook, re-point the formulas, re-check them, and pivot. Larger teams add a planning tool or a BI layer on a warehouse. In the most recent FP&A Trends survey, 52% of teams still plan in Excel.
Figure 2. From a business event to a number on the analyst's screen. The dashed box is the part the AIly makes permanent.
3The monthly cycle, by role and day
This is the loop from Figure 1 laid across a real month. It's the workflow Meridian's eight analysts run for monthly close, budget-vs-actuals, variance analysis and management reporting.
Figure 3. Close to approved pack. The yellow arrows are the two loops that cost the most: waiting on owners, and review edits that are never kept.
| Step | Where the hours go | Where it breaks | AIly |
|---|---|---|---|
| Pull and tie out | Exporting, pasting, re-pointing formulas | A broken link or a missed account; the base is wrong and nobody knows | Autonomy |
| Compute and flag | Every line, every month, against every threshold | A material line slips through in a busy week | Autonomy |
| Drill and ask | Digging through ledger detail; writing owner emails | Vague questions get vague answers, late | Assistance |
| Write commentary | Writing from blank; re-explaining recurring items | An unconfirmed cause reads as fact; this month contradicts last month | Assist + Aware |
| Review and edit | The Director rewrites the same things each month | The lesson in the edit is lost by next month | Awareness |
| Package and check | Matching numbers across slides, tables and text | A figure in the summary doesn't match the table | Autonomy |
4The forecast loop
Monthly actuals feed the forecast. The forecast is what next month is measured against, and each quarter the approved forecast becomes the board narrative.
Figure 4. The reforecast cycle. The judgment is whether the year has changed.
5Why the AIly makes it faster and more accurate
"I just don't see how it applies to what we do. Our work is numbers-based and requires judgment."
They're right, and that's exactly the case. Judgment happens at a few gates. Everything around those gates is assembly, and assembly is where the month goes. In the 2024 FP&A Trends survey, teams spent only 35% of their time on high-value work like generating insight. An AIly takes on the assembly and prepares the evidence for each gate. The judgment stays with the analyst.
Why David's prompts gave mixed results. A prompt arrives with nothing: no account mapping, no thresholds, no last month, no house voice, no checks. It's the same model with nothing to stand on. The ContAIner is what was missing.
Autonomy
- Speed
- Tie-out, budget-vs-actuals, the materiality scan and the cross-document number match run in minutes, the same way every month.
- Accuracy
- Field audits found errors in at least 86% of the spreadsheets they examined, with 1–2.5% of cells wrong. A check that never gets tired catches what a reviewer misses in close week. It flags; it never fixes.
Awareness
- Speed
- A recurring item is explained once. Prior commentary, corrections and house voice load with every task. A new analyst starts with the team's memory on day one.
- Accuracy
- This month's story is checked against last month's. A Director's edit becomes a standing rule, so the same correction isn't made twice.
Assistance
- Speed
- Owner questions written so they can be answered yes or no, which shortens the wait. Commentary and narrative in the house voice. The analyst edits instead of starting from blank.
- Accuracy
- Every line is labeled as a fact or a hypothesis. An unconfirmed cause can't slip into the pack as fact.
What we measure instead of promising a percentage. Discovery sets the baseline; the pilot measures against it:
- Hours per step, per close
- Days from close to an approved pack
- Owner response time on variance questions
- Director edits per draft, and how many repeat
- Errors caught before review versus after
6How discovery gets the real diagrams
Follow one number. Take one line from last month's management report. Trace it backward to the transactions it came from, then forward to the decision it informed. Ask to watch it happen on screen, during a real close if possible. People describe their work as it should be; their screen shows what it is.
Questions, in the order the number travels
| Stage | Ask |
|---|---|
| Sources | Which systems hold revenue, people cost and vendor spend? Which ones does FP&A pull from directly? |
| Close handoff | On what day are the books final? How do you know? What changes after that? |
| Repository | Where do actuals land when you pull them: a workbook, a planning tool, a warehouse? Who maintains it? |
| Mapping | How do ledger accounts become report lines? Who changes the mapping, and how often does it break? |
| Tie-out | How do you prove the numbers tie? What did the last mismatch cost you? |
| Materiality | Which variances get explained? Is the threshold written down, or known? |
| Owners | Who do you ask why? How do you ask? How long do answers take? |
| Commentary | Walk me through last month's explanation of one line: every step, every click. |
| Review | What does David change in a draft? Does the same edit come back next month? |
| Package | How many places does one number appear in the pack? How do you check they match? |
| Forecast | What drives the forecast? How often does it move, and who decides to reforecast? |
| Judgment | Which calls do you make alone? Which ones need David? Which would you hand off tomorrow? |
Sources
- FP&A Trends Survey 2024: 35% of time on high-value work; 52% plan in Excel.
- Panko, "Spreadsheet Errors: What We Know": errors in at least 86% of spreadsheets in recent field audits; cell error rates about 1–2.5%.
- Numeric, month-end close benchmarks, citing APQC: median close of about six days.