Account reconciliation
Project Description: Connect finance records, apply matching rules, and use AI to explain unmatched items and prepare investigation notes. Finance staff verify balances, review exceptions and approve how differences are resolved.
Implementation effort
108–424staff hours total
Current workload
—staff hours / month
Net time saved
—staff hours / month
Project difficulty
Moderate
Implementation work
Define matching rules and review requirements16–56h
- Agree three matching rules, materiality and up to ten exception types for the selected reconciliation.
- Specify the evidence needed to clear differences; divide preparer and reviewer responsibilities.
Prepare reconciliation data and reference periods20–80h
- Map fields and identifiers between two datasets; check access, record completeness and control totals.
- Prepare examples from two historical periods with known matches and unresolved differences.
Configure matching and exception explanations28–112h
- Configure deterministic matching and exception routing; produce a reviewable reconciliation output.
- Draft explanations and investigation notes linked to supporting records; keep journal posting manual.
Validate balances and investigation notes32–128h
- Compare results with completed periods; independently reconcile totals and test missing or duplicated records.
- Check explanations against evidence, correct failures and document differences that remain unresolved.
Train preparers and pilot the reconciliation12–48h
- Document preparer/reviewer steps and manual fallback; train up to five initial users.
- Shadow one production run and confirm release criteria with the process owner.
Ongoing work
Maintain reconciliation workflows32–128h / yr
- Review mapping errors and changing exception patterns; update source mappings and investigation prompts.
- Retest after matching-rule, model or export changes; maintain reliable evidence links.
Further projects
- Extend reconciliation support to additional accounts, entities or data feeds.
- Add source-linked investigations for intercompany or bank-account differences.