Short Answer: Fewer matches are typically caused by missing or mismatched Reference / Identifier columns, incorrect header row, or wrong amount mapping between Books and Customer statement.
PreRequisites
- You have run a reconciliation and noticed low matched transaction counts.
Steps
-
Open the results page to confirm the counts on the 'Fully matched', 'Partially matched' and 'Unmatched' cards.
You see the number of transactions and percentages for each group. -
Open 'Configure file - Books' and check that identifier columns like 'Invoice Ref', 'PO No', 'Doc No' are selected.
Identifier columns are properly selected for Books. -
Open 'Configure file - Customer statement' and confirm 'Invoice No.' and 'PO No' or other matching identifiers are selected.
Identifier columns are properly selected for Customer statement. -
If identifiers are present but not matching, inspect sample identifier values in the preview for subtle differences extra spaces, prefixes.
You identify formatting differences and can normalize data before re-running. -
Use 'Add column' in the Configure modal if the identifier you need isn't available in the preview.
The missing identifier column is exposed and can be selected. -
After corrections, re-run reconciliation and check match counts again.
Match counts increase if mapping fixes resolved mismatches.
Troubleshooting
-
Identifier columns appear but values differ by formatting.
LikelyCause: Source data has extra characters, prefixes or different formats.
Action: Clean/standardize the source file prior to upload or adjust which identifier columns are used; use 'Add column' to bring in corrected columns. -
No identifiers available to select.
LikelyCause: Header row set incorrectly so header names are not recognized.
Action: Set the correct header row in the Configure modal until headers align with the preview.
Note: Matching relies on both identifiers and amounts — both must be aligned to find matches.