01 · Reconcile the files
Upload a BOL and freight-invoice CSV
Sign in as an operator with edit access to the retailer scope. At Inbound shipments, select one Bill of Lading CSV and one freight-invoice CSV. Each file must be under 5 MiB. Choose the required retailer and, if needed, a banner and distribution center, then select Reconcile batch.
BOL columns
bol_number, po_number, item_sku, weight_lbs, freight_class, accessorials, carrier, destination, planned_atInvoice shipment columns
invoice_number, po_number, item_sku, weight_lbs, freight_class, accessorialsFor explicit invoice charge lines, use the columns below. Provide charge_type and charge_amount_cents together; charge_label and charge_disputed are optional. Repeat the shipment row once for each charge line:
charge_type, charge_amount_cents, charge_label, charge_disputedQuayledger matches records on PO + item. Invoice weight may differ by up to 5%; freight class must match exactly, and accessorial codes are compared as sets. Uploading the same PO + item again replaces its current reconciliation rows instead of adding a duplicate.