How to decide whether a reconciliation workflow is worth automating

Frustration is not a business case

The workflows people most want automated are often the ones they find most irritating, which is a poor predictor of economic value. A quarterly task that takes two hours and infuriates everyone is a worse candidate than a monthly task nobody complains about that quietly consumes eight.

Four factors, in order of weight

1. Recurrence

Every rule built is an asset that pays back once per execution. Daily and weekly workflows repay quickly, monthly repays acceptably, quarterly rarely does, and a one-off never does.

2. Mechanical repeatability

The decisive question is whether the procedure could be written down such that a competent stranger would reach the same answer. If most items need professional judgment, rules cannot carry the workflow and automation will simply relocate the problem.

3. Source complexity

Complexity is a reason to automate only when it is structural. Several independent systems that must agree is structural. One storefront and one ledger with a connector between them is not, and should not be scored as though it were.

4. Reuse across clients

For an accounting firm this is often what makes the economics work. One workflow built once and configured for four clients has a very different return from a single bespoke build, provided each client is genuinely validated rather than assumed identical.

Signals that the answer is no

• Under an hour a month of effort.
• Nearly every item requires accounting judgment.
• No pattern to the exceptions from period to period.
• A one-time cleanup with no recurring process behind it.
• The existing connector already produces a clean close.

What to measure before deciding

Two things, honestly. Actual time spent, measured rather than estimated, across everyone who touches the workflow including reviewers. And exception recurrence: whether the same categories appear each period, which is the strongest single predictor that deterministic rules will hold.

Be careful with projected savings. Automation rarely eliminates a workflow entirely, because review remains. A defensible estimate describes current effort, not future recovery.

A structured version of this

The Fit Score applies this weighting to one workflow and returns a band, the strongest signals, the biggest limiting factor and a next step. It runs entirely in your browser, requires no email, and its top band is deliberately hard to reach.