All free templates

Free Packing List Template for Excel

A packing list tells everyone downstream what is physically in the shipment and how it is boxed. Your forwarder quotes from it, customs inspects against it, and your warehouse receives against it. When it is wrong, all three go wrong at once.

Download the Excel template.xlsx · no email, no signup · free to use commercially

The version most suppliers send back is a carton count and nothing else. This template adds the numbers your freight forwarder is going to ask for anyway: total CBM and air chargeable weight, both calculated from the carton dimensions you enter.

What is in the packing list template

FieldWhat goes in it
Carton no.A single carton or a range such as 1-40.
SKU / DescriptionWhat is inside that carton range.
Qty per cartonUnits in each carton. Keep it consistent within a range.
CartonsHow many cartons the range covers.
Total unitsautoQuantity per carton multiplied by cartons.
Net / gross kg per cartonNet is the goods; gross includes the packaging.
Total net / gross kgautoPer-carton weights multiplied by the carton count.
L / W / H (cm)Outer carton dimensions. These drive the volume calculations.

Mistakes this template is designed to prevent

Net and gross weight used interchangeably

Net is the goods alone. Gross includes carton, pallet, and dunnage. Carriers bill on gross, and customs entries often want net. Report both.

Inner dimensions instead of outer

Volume must be calculated from the outside of the carton. Using internal dimensions understates CBM and produces a quote that will be re-rated after measurement.

No link back to the PO

A packing list without a PO number cannot be reconciled against what was ordered. Put the PO number in the header and on every carton label.

Packing List Template FAQ

The template is free. Keeping fifty of them in sync is the problem.

A spreadsheet works until there are eleven versions of it and nobody knows which one the supplier filled in. SupplyAutomate keeps purchase orders, supplier documents, shipments, and landed costs in one workspace that updates as the order moves.

No credit cardSetup in minutesCancel anytime