Order Reconciliation for Partial Distributor Deliveries

A practical six-state quantity ledger for reconciling a distributor order delivered in several shipments, resolving receiver discrepancies and closing backorders with clear ownership.

Distributor staff verify goods while reviewing an order change.

To reconcile partial deliveries against a distributor order, keep ordered, allocated, dispatched, received, outstanding and cancelled quantities in separate, auditable states; link every shipment and receipt to the original order line; and close only when every carton in the net quantity has a documented disposition. A 1,000-carton order arriving in two shipments can show 900 dispatched, 880 received and a finance question about completion. The gap is not one missing number; it is a failure to separate these quantity states.

Work line by line in one base unit. A documented disposition is accepted receipt, accepted replacement, approved credit, approved cancellation or approved write-off. Dispatch proves goods left the warehouse; it does not prove receipt or revenue.

Build an order quantity ledger with six states

The labels matter less than the boundaries between them. Use the same definitions across sales, warehouse, distributor receiving and finance.

Six quantity states for a line
State What it means Example in cartons
Ordered Quantity on the approved version before later cancellations. 1,000
Cancelled Quantity formally removed by an approved amendment or cancellation, with a reason and timestamp. 100
Allocated Stock reserved or planned for quantities not yet dispatched. This is not a cumulative total. 400 after the first dispatch
Dispatched Quantity that left the supplier or brand warehouse on a shipment. 500 in shipment 1
Received Quantity the distributor receiver accepted into saleable stock, excluding damaged or rejected units. 480 in shipment 1
Outstanding Net quantity not yet accepted, including unshipped balance and open receipt discrepancies. 420 after shipment 1 receipt
Order quantity ledger showing six states for partial distributor deliveries
Six states to track per line.

Allocated quantity is a reservation or plan. Do not add it to dispatched or received to prove completion. If quantities are captured in cartons and the receiver counts pieces, convert to one base unit before comparison and keep the conversion factor with the record. See Order Unit Conversion: Prevent Carton and Piece Errors.

Worked example: reconcile a partial order delivered in two shipments

Suppose a brand confirms an order for 1,000 cartons of one SKU. Before dispatch, the distributor cancels 100 cartons because a promotion is postponed; the cancellation is approved in writing. The net quantity is 900 cartons. Shipment 1 dispatches 500. The receiver accepts 480 and records 10 damaged and 10 not on the truck. Outstanding after receipt is 420: 400 cartons still to be dispatched and 20 cartons in an open receipt discrepancy.

Shipment 2 dispatches 400 and the receiver accepts 400. The open balance is now 20 cartons, all receipt discrepancy. The brand approves a 20-carton credit. Accepted receipt stays at 880; the credit resolves the remaining balance. The line is reconciled when the credit is approved, posted to the right records and linked to the original line.

Hypothetical quantity ledger for one line
Stage Ordered Cancelled Net quantity Allocated, open Dispatched, cumulative Received accepted, cumulative Outstanding Open receipt discrepancy
Confirmed 1,000 0 1,000 1,000 0 0 1,000 0
Cancellation approved 1,000 100 900 900 0 0 900 0
Shipment 1 dispatched 1,000 100 900 400 500 0 900 0
Shipment 1 received 1,000 100 900 400 500 480 420 20
Shipment 2 dispatched 1,000 100 900 0 900 480 420 20
Shipment 2 received 1,000 100 900 0 900 880 20 20
20-carton credit approved 1,000 100 900 0 900 880 0 0

The ledger does not treat dispatch as receipt. It also does not convert every short receipt into a backorder. The 20-carton gap becomes a replacement, credit or write-off only after evidence and approval.

Changing an order is a separate process. If quantities or dates change after confirmation, use an amendment with a new approved version rather than editing the receiving ledger. See Order Changes After Confirmation: Manage Distributor Amendments.

Resolve receiver discrepancies with evidence

A receiver discrepancy is the difference between dispatched and accepted received quantity for a shipment. Check four records: the approved line, the dispatch note, the receiver’s gate-in or goods-received note, and any damage or rejection report. Count at SKU and batch level in the base unit.

  • Separate short, damaged, rejected and mis-shipped quantities. Damaged stock may be physically present but not accepted for sale.
  • Do not overwrite the dispatch quantity. Add a receipt record and a disposition.
  • Confirm whether delivery was to the distributor’s main warehouse or a sub-location, and record where the accepted units were booked.
  • Keep photographic or count evidence with the shipment record where the receiver reports a short.
  • Assign one resolution per unit, with an owner and a date: replacement, credit, cancellation or write-off.

How to reconcile and close a partial distributor order

  1. Confirm the approved version, net quantity, cancellations and base unit.
  2. Record each dispatch and each accepted receipt separately against the original line.
  3. Compare dispatched and accepted received quantities at SKU and batch level; log short, damaged, rejected and mis-shipped units.
  4. Assign one disposition per unresolved unit: replacement, credit, cancellation or write-off, with an owner and date.
  5. Close the line only when ordered equals cancelled plus accepted receipt plus approved credit, approved cancellation or approved write-off, and outstanding and open discrepancy are zero.
  6. Post the closing entry to the original line so the audit trail links shipments, receipts and resolutions to the confirmed version.

For review questions, ask which state is being reported: planned allocation, dispatched, accepted received or resolved. Ambiguity between these states, not the missing 20 cartons, is what keeps a partial delivery open.

Frequently asked questions (FAQ)

Should dispatched quantity be treated as complete delivery?

No. Dispatch proves goods left the warehouse. Completion requires accepted receipt or another approved disposition, such as a replacement, credit or write-off.

Is allocated quantity added to received quantity to prove completion?

No. Allocation is a reservation or plan for undispatched quantity and is not a cumulative total. Only accepted receipt and approved dispositions close the line.

When is a partial delivery considered reconciled?

When ordered quantity equals cancelled plus accepted receipt plus approved credit, approved cancellation or approved write-off, and both outstanding quantity and open receipt discrepancy are zero.

Put this guide into practice

This general-purpose worksheet is a starting point. Adapt its fields, responsibilities and rules to your business process.