DISTRIBUTOR DELIVERY RECONCILIATION WORKSHEET
General operating template. Match quantities in the same unit.
Order ID / distributor / SKU / order version / base unit:
Ordered / cancelled / confirmed outstanding:
Shipment ID / dispatch date / dispatched quantity / receipt date:
Received / accepted / rejected / pending inspection:
Discrepancy reason / evidence / owner / next review date:
Closeout: all shipment records linked? Outstanding quantity agreed? Exceptions owned?
Track each shipment once. Dispatch is not receipt. Do not add quantities measured in cartons and pieces until SKU-specific conversions are confirmed. Do not count a return twice as both a reduced receipt and a separate adjustment. Finance treatment follows company policy.