Order identity

  • PO reference: your internal purchase-order number.
  • Supplier and supplier reference: the supplier’s own order or invoice number.
  • SKU and quantity ordered: one row per SKU keeps partial receipts readable.
  • Date submitted: when the order was actually placed, not drafted.

Promises and changes

  • Acknowledged date: when the supplier confirmed the order.
  • Original promised arrival: keep this unchanged once recorded.
  • Current expected arrival and date confirmed: update these when the supplier revises the date.
  • Dispatch date and tracking reference: where the supplier provides them.

Receipt

  • Delivered date: when the goods physically arrived.
  • Quantity accepted: units that passed your receiving check.
  • Sellable date: when stock was checked, labelled and available to sell.
  • Lead time (days): sellable date minus date submitted, calculated in your spreadsheet.

Exceptions & follow-up

  • Quantity outstanding: ordered less accepted.
  • Exception reason: short shipment, damage, wrong item, delay or other.
  • Next action and follow-up date: who checks what, and when.
  • Notes: supplier messages and evidence references, without personal data.