Reconciliation: transaction matching
Simulated valuesThe exact identifier resolves first. The rest is scored by reference, date, amount and relationship between entities.
Variables
- scorematch score between payment and title
- wₖweight of attribute k (reference, amount, due date, store)
- simₖsimilarity of attribute k, between 0 and 1
Objective
Match each payment to the right title and isolate what is ambiguous.
Constraints
- Exact identifier takes priority.
- Pairs with intermediate scores go to human review.
- Duplicates and incomplete data become pending items and do not enter collections.
Practical example
A payment with no identifier, with the same amount and date as a title from the same store, gets a high score; if two titles are candidates, it goes to review.
Business implication
Automatic reconciliation covers what is clear and hands the analyst only what is doubtful.
Assumptions and limitations
The weights and threshold in the tour are explanatory and must be calibrated with operations.