Home Intercompany Reconciliation Why are most transactions unmatched and how do I investigate them?

Why are most transactions unmatched and how do I investigate them?

Last updated on Apr 24, 2026

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

  1. Intercompany reconciliation report open

  2. Access to source statements or transaction details as needed

Steps

  1. Click the 'Unmatched' tab under the summary cards to list unmatched rows.
    Unmatched transaction rows are displayed.

  2. 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.

  3. Use 'Download report' to export data for offline comparison if needed.
    You have a file for deeper analysis.

  4. After correcting source data or resolving exceptions, click 'Run new reconciliation' to re-evaluate matches.
    A new run will update matched/unmatched counts.

Troubleshooting

  1. 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.

  2. 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'.

Note: The screenshot does not show the source statement screens; you may need access to source systems to correct data.