Match bank transactions to supporting documents

A bounded workflow.

1. Import authorised transaction and invoice exports.
2. Normalise dates, currency, amounts and document references without discarding original values.
3. Match exact identifiers first, then apply the agreed matching rules.
4. Separate exact matches, partial amounts, duplicates and ambiguous records.
5. Ask the responsible reviewer to confirm the proposed associations.

Synthetic example.

Input: transaction T-01, reference INV-204, amount 1,200.00 GBP; invoice INV-204, amount 1,200.00 GBP.

Output: a proposed match with reference and amount evidence. Transaction T-02, amount 300.00 GBP with no reference and two possible invoices, remains unresolved.

Acceptance: every source row is accounted for; totals reconcile; ambiguous matches remain visible; a reviewer approves the associations. This example is invented for demonstration and contains no client records.

Keep the boundary clear.

The workflow prepares reconciliation evidence. It does not execute payments or treat a matching suggestion as an approved accounting entry. Source availability and accounting-system access are assessed separately.

Define your first step.

Send a brief description of your process and the result you need. Please leave out confidential records. We will agree the data, permissions, scope, acceptance criteria and commercial terms before work begins.