Deduction Reconciler

Reconciliation

Open deduction claims checked against their matching invoices. Rows are flagged when the claimed amount differs from the expected total by more than $5.00.

Open Claims

7

Flagged Suspicious

4

Total Flagged Amount

$950.00

Claim IDRetailerReasonClaimedUnits ShippedPrice / UnitExpected TotalDifferenceStatusActions
CLM-2002FreshMartAlleged shortage$900.00500$2.50$1,250.00−$350.00Suspicious
CLM-3001TargetShort shipment$900.00300$3.00$900.00+$0.00OK
CLM-3002KrogerPricing error$1,000.00400$2.50$1,000.00+$0.00OK
CLM-3003TargetDamaged goods$450.00150$4.00$600.00−$150.00Suspicious
CLM-3004Whole FoodsShort shipment$700.00200$5.00$1,000.00−$300.00Suspicious
CLM-3005KrogerPricing error$1,050.00350$3.00$1,050.00+$0.00OK
CLM-3006Whole FoodsWrong item$550.00100$4.00$400.00+$150.00Suspicious

Expected total = units shipped × price per unit, from the linked invoice.Add an invoice