Department enablement · Operations

Cut the manual reconciliation work without losing control of the exceptions

If your operations staff spend hours matching records between an ERP, a warehouse or logistics system and spreadsheets, you can commission a bounded pilot on one reconciliation workflow. I map the process, build and coach a reviewed AI-assisted matching step with your team, and leave an exception-handling runbook with a named internal owner. It starts with a short workflow brief.

This is a good fit if…

  • Your team re-keys or cross-checks the same records between two or more systems every day or week: orders against shipments, purchase orders against supplier confirmations, stock counts against the system of record.
  • Exceptions are handled by one or two experienced people, and the rules for them live in their heads or in an old email thread.
  • You already pay for an AI assistant or automation platform, but nobody has redesigned an actual operations workflow around it.
  • You want staff to learn by changing their own workflow, not by attending a generic prompt course.

Look elsewhere if…

  • You need an operating-model or investment decision at executive level rather than a change to a daily workflow. That is a leadership workshop, offered through dipankar.org.
  • The workflow is month-end close, management reporting or ledger reconciliation. Use AI enablement for finance teams instead.
  • You already know the integration you need and want it built and maintained. Use AI workflow automation and systems integration instead.

What you get

Process map, reviewed reconciliation pilot and exception-handling runbook

  • One reconciliation workflow redrawn on a single page, with every manual hand-off, data source and decision point visible.
  • A working AI-assisted matching and triage step that proposes matches and sorts exceptions, with a person accepting or correcting each one.
  • An exception-handling runbook that names the categories, the owner of each and what evidence closes it.
  • A baseline and a pilot measurement of cycle time, exception resolution time and wrong-match rate, taken the same way.
  • Staff who ran the pilot can explain the new workflow and adjust it without me.

How it runs

  1. 01

    Workflow brief and process walk

    You name the workflow, the systems and the person who owns it. I sit with the staff who do the work, map every step and collect a sample of real records and exceptions.

  2. 02

    Baseline

    Before anything changes, we measure how long a cycle takes, how many exceptions arise, how they are resolved and how often a match is later found to be wrong.

  3. 03

    Reviewed pilot

    I build the matching and triage step in tools you already approve, with staff reviewing every proposal. We adjust rules weekly from what reviewers correct.

  4. 04

    Runbook, measure and decide

    We measure the pilot against the baseline, write the exception runbook with the team, and you decide to expand, revise or stop.

What needs to be in place

  • One named workflow and an internal owner, usually an operations manager, who has authority to change it.
  • Read access to exports or test copies of the systems involved, under your data policy.
  • Two or three staff who do the work today and can spend a few hours a week on the pilot.
  • An approved AI tool or platform, or agreement on which one the pilot may use.

Not included

  • Automatic write-back to systems of record during the pilot. Proposed matches are reviewed by a person before anything is updated.
  • Executive operating-model design, organisation charts or headcount decisions.
  • Replacement or procurement of your ERP, warehouse or logistics platform.
  • Guaranteed time savings. The pilot reports measured change against the baseline, including no change.

The workflow this pilot is for

Most operations teams have at least one job that is really a reconciliation. Orders in the commerce platform have to agree with what the warehouse shipped. Supplier confirmations have to agree with purchase orders. Carrier invoices have to agree with the rates and the deliveries that actually happened. Somebody exports two reports, lines them up in a spreadsheet, and spends the afternoon chasing the rows that do not match.

The matching is tedious. The exceptions are where the value is: a short shipment, a duplicated order, a supplier who changed a part number. Experienced staff know how to handle each one, but that knowledge is rarely written down. That is why “just automate it” tends to fail. The automated version handles the easy rows and silently mishandles the hard ones.

This pilot changes one reconciliation workflow so that AI does the sorting and the first pass at matching, and people keep control of every exception.

What the work involves

The process walk. I sit with the people who do the work and follow real records through it. The output is a one-page process map showing each source system, each export or re-keying step, each decision and each hand-off. Most teams find at least one step that exists only because two systems use different identifiers.

The exception catalogue. From a sample of recent cycles, we list every kind of exception and how it was resolved. This becomes the backbone of the runbook.

The reviewed matching step. Using the tools you already approve, I build a step that proposes matches between the two sources, flags the rows it cannot match, and assigns each flagged row to an exception category with the evidence it used. A member of staff reviews every proposal. Nothing is written back to a system of record during the pilot.

Weekly adjustment. Reviewer corrections are the training signal. Each week we look at what reviewers changed and tighten the rules, the prompts or the reference data.

I have built AI agents for supply-chain operations, so I know where these workflows usually break: identifiers that drift, partial deliveries, and timing differences that look like errors.

The signature deliverable

You end with a process map, a reviewed reconciliation pilot and an exception-handling runbook. Illustrative example of a runbook extract:

Exception categoryTypical evidenceOwnerCloses when
Quantity short-shippedDispatch note quantity below order lineFulfilment leadBack-order raised or customer credited
Duplicate orderSame customer, items and value within 24 hoursCustomer operationsDuplicate cancelled and logged
Unknown supplier part numberNo match in item masterPurchasingCross-reference added to master data
Low-confidence matchProposed match with conflicting dates or valuesReviewer on shiftAccepted, corrected or escalated

Illustrative example. The categories show the format, not results from a client.

How acceptance is judged

Before the pilot starts, we baseline the workflow using the same measures we will use at the end:

  • elapsed time for one reconciliation cycle
  • number of exceptions and median time to resolve them
  • wrong-match rate: proposed or manual matches later found to be wrong
  • reviewer acceptance rate: how often staff accept the AI proposal unchanged

The internal owner signs off the pilot against those measures. The adoption measure is plain: is the team running the new workflow for real cycles without being prompted? A pilot can conclude that the workflow should be expanded, revised or stopped. Each of those is a legitimate result.

Ownership and handover

The workflow, the runbook and the review queue belong to your operations owner from day one. Staff who ran the pilot are coached to adjust the matching rules themselves. Before I step back, the team runs at least one complete cycle without me, and the runbook is updated from what they find.

When this is the wrong page

If the workflow is financial close, management reporting or ledger reconciliation, the review and sign-off requirements are different. Use AI enablement for finance teams. If the work is about CRM data and account research, see AI enablement for revenue operations. If you already know the integration you want built and maintained, go to AI workflow automation and systems integration. To measure adoption across several teams rather than change one workflow, start with the AI adoption measurement worksheet.

Questions buyers ask

Will the pilot let the AI update our systems directly?

Not during the pilot. The AI step proposes a match, a category or a next action, and a member of your team accepts or corrects it. Write-back can be considered afterwards for the narrow categories where reviewers almost never change the proposal, and only with your owner's approval and an audit trail.

What if our data is too messy for this to work?

Messy data is usually why the workflow is manual in the first place, so the process map makes it visible rather than hiding it. Sometimes the right outcome is a cleaner export or a shared reference table, not more AI. A pilot that concludes the workflow should be fixed upstream is a useful result.

Do we need to buy a new tool?

Usually not. I start from the AI assistant, spreadsheet environment or automation platform you already have approved. If a missing capability genuinely blocks the pilot, I say so in writing with the options, and the purchasing decision stays with you.

How is this different from a COO workshop?

A leadership workshop helps executives decide where AI belongs in the operating model and how to fund it. This pilot changes one workflow that staff run every week, with measurements and a runbook. If you need the executive decision first, the workshop route is through dipankar.org.

Who keeps the workflow running afterwards?

The internal owner you name at the start. The runbook, the matching rules and the review queue are handed to that person and the staff who ran the pilot. I coach them through at least one full cycle without my involvement before the pilot closes.

Related engagements

Department enablement · Finance

Finance teams

We want faster management reporting, but every number and source still needs review. What can safely be piloted?

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

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 · Workflow automation

Workflow automation

We have one repetitive workflow with clear inputs and outputs. Who can implement it with approvals, monitoring and a handover?

You get:Workflow implementation and handover

Free worksheet · Enablement

Adoption measurement

How do we measure repeat use, quality, review effort and useful capacity without claiming that every saved minute is cash?

You get:Editable measurement specification with baseline, comparison and capacity-versus-cash distinctions

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