Short Answer: Large unmatched counts mean many transactions on one or both statements didn’t pair; click 'Unmatched' and compare date, description, and amount to identify mismatches.
PreRequisites
-
Intercompany reconciliation report open
-
Access to source statements or transaction details as needed
Steps
-
Click the 'Unmatched' tab under the summary cards to list unmatched rows.
Unmatched transaction rows are displayed. -
Review each unmatched row’s 'Entity A' and 'Entity B' columns to spot differences in date, description, or amount.
You identify candidate mismatches for investigation. -
Use 'Download report' to export data for offline comparison if needed.
You have a file for deeper analysis. -
After correcting source data or resolving exceptions, click 'Run new reconciliation' to re-evaluate matches.
A new run will update matched/unmatched counts.
Troubleshooting
-
Unmatched rows show identical amounts but remain unmatched.
LikelyCause: Differences in other fields (dates, descriptions), small rounding differences, or hidden metadata mismatch.
Action: Open the row detail (chevron >) to compare full fields; correct source entries if required and re-run reconciliation. -
Unmatched count unexpectedly high after a recent data change.
LikelyCause: Source statements or feeds changed since the last reconciliation.
Action: Confirm the source data is current and re-run reconciliation using 'Run new reconciliation'.