Why does a single Amazon MTR invoice match multiple Amazon Disbursement lines and how is the difference calculated?

Short Answer: The reconciliation can match one MTR row to multiple disbursement transactions by using the Reference/Identifier and adding disbursement 'Amount' values; the modal shows 'Match basis: Reference ID + Amount' and the Difference subtotal mismatch if any.

PreRequisites

1. Reconciliation run completed and matched groups exist

Steps

1. Open the reconciliation report and find the row that indicates 'Multiple transactions (n)'.
   Grouped row appears in the list showing the combined amount.

2. Expand the group to open 'Matched transaction details'.
   Modal shows 'Match basis' and tables for both sides.

3. Read the 'Match basis' card. It will list 'Reference ID' and 'Amount'. Review the disbursement lines and their amounts for example 521.19 Principal + 93.81 Product Tax = 615.00.
   Subtotal matches the MTR invoice and Difference shows 0.00 if sums align.

4. If the sums do not match, check for excluded lines, mapping errors, or rounding differences and correct source files or filters before re-running.
   After adjusting, re-run reconciliation to update matches.

Troubleshooting

1. Combined disbursement amount doesn't equal the invoice amount.
   LikelyCause: A disbursement row is missing, excluded by filters, or there is a rounding/currency difference.
   Action: Verify the disbursement file contains all necessary tax/fee/principal lines and that filters in 'Records to include' are not excluding them. Fix data and re-run.