Department enablement · Finance

Faster management reporting where every number still traces to its source

If your finance team wants to draft management packs and variance commentary faster but cannot accept a figure nobody can trace, you can commission a bounded pilot on one reporting workflow. I build a source-linked drafting step with your team, add automatic reconciliation checks, and write the preparer, reviewer and approver sign-off steps into it. Nothing posts to the ledger.

This is a good fit if…

  • Your monthly management pack takes days after close because commentary, variance explanations and tables are assembled by hand from ledger and budget extracts.
  • Your controller will not accept AI-drafted text unless every figure links back to a query, report or cell that a reviewer can open.
  • Staff already use an approved AI assistant informally for finance tasks, and you want one controlled way of doing it.
  • You need a pilot that an auditor or audit committee could read and understand.

Look elsewhere if…

  • You need a decision on whether, and how much, to invest in AI across the business. That is a CFO workshop, offered through dipankar.org.
  • You run client engagements as an accounting or advisory firm and need client-level data separation. Use AI enablement for client-service teams, or AI adoption for professional-services firms at firm level.
  • You want regulated financial, tax or audit advice. That stays with your qualified advisers.

What you get

Source-linked reporting workflow, reconciliation checks and reviewer sign-off steps

  • One reporting workflow, such as the monthly management pack or budget-versus-actual commentary, drafted with every figure linked to its source.
  • Reconciliation checks that run before a reviewer sees the draft: totals tie to the trial balance, sub-ledgers tie to control accounts, variances above threshold have an explanation.
  • Preparer, reviewer and approver steps written into the workflow, with what each must check and record.
  • A baseline and pilot measurement of days from close to approved pack and the number of reviewer corrections.
  • A finance team member who can maintain the prompts, checks and templates.

How it runs

  1. 01

    Choose the report and its sources

    You pick one recurring report. We list every figure in it, where it comes from today and who signs it off.

  2. 02

    Baseline the current cycle

    We record how long the last cycles took from close to approval, and how many corrections reviewers made, before anything changes.

  3. 03

    Build the source-linked draft and checks

    I build the drafting step and the reconciliation checks in tools you approve, pairing with a named preparer. Reviewers see the source link beside every number.

  4. 04

    Run real cycles, then decide

    The team runs the workflow on live month-ends alongside the old process until the owner is satisfied. You then decide to adopt, revise or stop.

What needs to be in place

  • A named owner, usually the financial controller or FP&A lead, with authority over the report.
  • Read-only access to the ledger, budget and BI extracts the report uses, under your data policy.
  • An approved AI environment for financial data, or agreement on which one the pilot will use.
  • The current sign-off rules for the report, even if informal.

Not included

  • Posting journals, approving payments or changing anything in the ledger. The pilot is read-only against financial systems.
  • Accounting, tax, audit or investment advice of any kind.
  • Removing human review. Every report still has a named preparer, reviewer and approver.
  • Guaranteed reduction in close time. The pilot reports measured change against the baseline.

Why finance needs a different pilot

Finance teams are not short of ideas for AI. They are short of a way to use it that a controller will sign. Management reporting is the obvious target: after close, someone pulls the trial balance, budget and prior-year extracts, builds the tables, and then writes pages of commentary explaining why marketing spend is over budget and why debtor days moved. The commentary is slow to write and easy to get subtly wrong.

A general-purpose assistant can draft that commentary in minutes. The problem is that the draft looks finished whether or not its numbers are right. In finance, a plausible wrong number is worse than no draft at all. So the pilot is designed around one rule: the model drafts words; your systems supply numbers; a person signs every step.

What the work involves

Source mapping. We take one recurring report and list every figure in it: which ledger account, query, BI report or spreadsheet cell it comes from, and at what point in the close it becomes final. Figures without a reliable source are the first finding.

Source-linked drafting. The drafting step receives figures from your extracts, not from the model’s memory. Each figure in the draft carries a reference back to its source, so a reviewer can open the query or cell beside the sentence that uses it. Text that interprets a figure (“driven by the timing of the annual licence renewal”) is marked as needing confirmation from the budget holder.

Reconciliation checks. Before a reviewer sees anything, automatic checks run: report totals tie to the trial balance, sub-ledger totals tie to control accounts, the period and entity are right, and every variance above your threshold has an explanation. A failed check blocks the draft and says why.

Sign-off steps. The workflow records the preparer, the reviewer and the approver, what each checked, and what each changed. That record is the audit trail.

I have designed and built components of an AI agent stack for regulated financial services, and published a tiered governance model for AI in financial services. That experience shapes where the human approval points sit.

The signature deliverable

You end with a source-linked reporting workflow, reconciliation checks and reviewer sign-off steps. Illustrative example of a sign-off checklist:

StepWhoMust confirmRecorded
Extracts refreshedPreparerPeriod, entity and extract timestamp correctExtract log
Checks passPreparerAll reconciliation checks green or exceptions explainedCheck report
Commentary reviewedReviewerEach explanation confirmed with budget holder or markedTracked changes
Pack approvedApproverTotals tie; material variances explainedApproval record

Illustrative example. The format, not results from a client.

How acceptance is judged

Baseline and pilot are measured the same way: working days from close to approved pack, reviewer corrections per pack, the share of figures with a working source link (the target is all of them), and check failures caught before review. The owner, usually the financial controller, signs off after at least one real month-end where the new workflow ran alongside the old one. The adoption measure is whether the team chooses the new workflow for the next close without being asked.

Ownership and handover

The report, the checks and the templates belong to the finance owner. A named team member pairs with me on the build and maintains the prompts, checks and source map afterwards. The runbook covers how to add a new figure, what to do when a check fails, and how to fall back to the manual process.

Boundaries

This page is about a finance department’s own reporting workflow. If you are deciding whether to invest in AI and how to challenge the value case, that is a CFO workshop at dipankar.org. If you are an accounting or advisory firm handling client data, the controls are about separating clients and partner review: see AI enablement for client-service teams, or AI adoption for professional-services firms for firm-level sequencing. For document-heavy work such as invoice extraction, see document processing and reviewed reporting workflows. For regulated financial-services operations more broadly, see AI engineering and enablement for financial services.

Questions buyers ask

Can the model make up a number?

It can try, which is why the workflow does not let it supply numbers. Figures come from your extracts and queries; the model drafts the words around them. Every figure in the draft carries a link to its source, and the reconciliation checks flag any figure that does not match. A reviewer still reads it all.

Which AI tool will you use?

The one your organisation already approves for financial data, where possible: an enterprise assistant, a spreadsheet add-in, or a model in your own cloud account. If none is approved for this data, the first step is agreeing one with IT and your data protection lead, not working around policy.

Will our auditors accept this?

I cannot speak for your auditors. What the pilot does give them is a documented workflow: sources, checks, named sign-offs and an audit trail of what the model drafted and what reviewers changed. Many teams share the workflow description with their auditors before adopting it.

How is this different from the CFO workshop?

The CFO workshop is about investment: which AI initiatives to fund, how to challenge the value case and how to govern the portfolio. This pilot changes one reporting workflow your team runs every month. If you need the investment decision first, that is offered through dipankar.org.

What happens at month-end if the pilot breaks?

The old process keeps running in parallel until the owner signs off the new one, so a failure costs time, not a missed deadline. The runbook says how to fall back, and what to check before trying again.

Related engagements

Department enablement · Operations

Operations teams

Our team repeatedly reconciles information between systems. How can we change this workflow without losing exception handling?

You get:Process map, reviewed reconciliation pilot and exception-handling runbook

Department enablement · Revenue operations

Revenue operations

How can we improve account research and CRM updates without sending inaccurate or unapproved messages?

You get:Source-backed account brief, CRM update review queue and permission matrix

AI delivery · Document workflows

Document workflows

We need to extract and summarise documents with provenance and exception review. What should a deployable workflow include?

You get:Document pipeline, source traceability, exception queue and evaluated sample set

Industries · Financial services

Financial services

Our financial-services team needs an AI pilot with explicit controls and ownership. Who can provide engineering without claiming to replace legal or compliance sign-off?

You get:Scoped engineering or enablement for regulated workflows

Department enablement · Client service

Client-service teams

How can consultants prepare research and client deliverables faster without mixing client data or publishing unsupported advice?

You get:Client-separated research workflow, evidence ledger and partner review checklist

Department enablement · Customer support

Customer support

Can our support team use knowledge assistants while preserving access controls, current answers and escalation to people?

You get:Permissioned support-assistance pilot, answer-quality sample and escalation playbook

Further reading

Scope a workflow pilot

A short, non-confidential description is enough to start. I read every brief personally and reply within two business days, including when the answer is that I am not the right fit.

Step 1 of 2 · The basics