How do I investigate a large Unmatched difference in the reconciliation?

Short Answer: Open the 'Unmatched' tab, inspect high-value rows, check Reference/Identifier and amount mappings via 'View format', fix source files and re-run reconciliation.

PreRequisites

1. A completed reconciliation run

2. Access to the report and source files

Steps

1. Open the Vendor Reconciliation report and select the 'Unmatched' tab.
   Unmatched transactions and the Unmatched card totals are visible.

2. Sort or filter to find the largest unmatched amounts using '+ Add filter'.
   High-value unmatched items are easier to locate.

3. Open the source files for those rows and confirm the identifier and amount values are present and correctly formatted.
   You can see whether values are missing, formatted differently, or duplicated.

4. Open 'View format' to verify 'Reference / Identifier' and amount mappings and correct them if necessary.
   Mappings reflect the actual source columns.

5. Fix the source files by adding missing identifiers, deduping, correcting signs and re-run the reconciliation.
   Unmatched totals should reduce after successful re-run.

Troubleshooting

1. Many items are unmatched because identifiers differ slightly across files.
   LikelyCause: Formatting differences prefixes, whitespace, different invoice numbering.
   Action: Normalize identifiers in the source files with consistent prefixes and remove spaces or select additional identifier columns in mapping.

2. Unmatched list contains duplicate rows from the same source.
   LikelyCause: Duplicate transactions in uploaded files.
   Action: Deduplicate the source files before upload, then re-run reconciliation.

Note: Large Unmatched differences are often caused by missing or mis-mapped identifiers, duplicate entries, or files not uploaded for the period.