Why are some invoice amounts negative in matched transaction details?

Short Answer: Negative 'Invoice Amount' values usually represent credit notes or refunds; the sign must be present in your source file and correctly mapped as the 'Amount'.

PreRequisites

1. Open the 'Matched transaction details' modal

Steps

1. Open the matched row's details to inspect the Side B 'Invoice Amount' values.
   You see positive and negative invoice amounts e.g., 20.0 and -20.0 listed.

2. Check the original Cashback/Sales/Settlement file to confirm whether the negative value is a credit note or refund.
   Source file shows matching sign for that invoice row.

3. If the sign is incorrect or missing, correct the source file or mapping Amount field and re-run the reconciliation.
   Amounts align and differences update after re-run.

Troubleshooting

1. Totals do not cancel out though positive and negative rows are present.
   LikelyCause: A matching credit or debit is missing on the opposite side or the sign was lost during upload/mapping.
   Action: Confirm both files include the corresponding credit/debit rows with correct signs and re-run reconciliation.

Note: Credit notes often appear with negative invoice amounts; ensure your 'Amount' mapping preserves the sign.