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.