Short Answer: Open 'Matched transaction details' and compare the 'Amount' and 'Amount 2' fields — the report's 'Match basis' uses 'Amount' not necessarily 'Amount 2'.
PreRequisites
- Open the matched pair in 'Matched transaction details'.
Steps
-
Open the matched pair's 'Matched transaction details' modal.
You see side-by-side rows for Side A and Side B. -
Check the 'Match basis' box which shows 'Reference ID + Amount' and the text 'Transactions matched using Identifier and Amount.'
You confirm the report used the 'Amount' column for matching. -
Compare the 'Amount' fields on both sides; then compare 'Amount 2' if present.
If the 'Amount' values differ, that explains the difference; if 'Amount' matches but 'Amount 2' differs, 'Amount 2' is a secondary field and does not affect the match. -
If source data is incorrect, correct the source and use 'Add files & update report' to refresh the report.
Updated data will reflect in totals after the report is updated.
Troubleshooting
-
Totals show 0.00 difference but 'Amount 2' values differ for example 300 vs 320.
LikelyCause: The report used the 'Amount' column for matching/totals and the 'Amount' values match, while 'Amount 2' is an additional field only for reference.
Action: Confirm 'Match basis' and rely on the matched 'Amount' for totals; if you need to match using 'Amount 2', standardize data and re-run the report or unmatch and reprocess with the desired fields. -
Amounts differ and you cannot find which transactions cause the delta.
LikelyCause: Some transactions contributing to totals may be in other match categories Partially matched or Unmatched.
Action: Switch between 'Fully matched', 'Partially matched' and 'Unmatched' tabs and open suspicious matches to locate discrepancies.
Note: The screenshots show 'Reference ID + Amount' as the match basis; rely on those fields when investigating amount differences.