Packing List That Calculates CBM and Chargeable Weight
This is a shipping packing list, not a suitcase checklist. It tells your forwarder, customs, and warehouse what is in each carton, what it weighs, and how much cube it takes, so a quote, an inspection, and a receive all run off the same numbers.
The version most suppliers send back is a carton count and nothing else. This Excel template adds the numbers a freight forwarder is going to ask for anyway: total CBM and air chargeable weight, both calculated from the outer carton dimensions you enter.
What is in the packing list template
| Field | What goes in it |
|---|---|
| Carton no. | A single carton or a range such as 1-40. |
| SKU / Description | What is inside that carton range. |
| Qty per carton | Units in each carton. Keep it consistent within a range. |
| Cartons | How many cartons the range covers. |
| Total unitsauto | Quantity per carton multiplied by cartons. |
| Net / gross kg per carton | Net is the goods; gross includes the packaging. |
| Total net / gross kgauto | Per-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
Related reading
- Allocate freight cost across SKUs. Split one freight bill using the weights and cube from this list
- How to calculate landed cost. The inbound stack this packing list feeds
More free templates
Purchase Order Template
Standardised PO with automatic line totals, HS code fields, Incoterms, and payment terms.
Commercial Invoice Template
Customs-ready invoice with per-line HS codes, country of origin, Incoterms, and a declaration block.
Supplier Evaluation Matrix
Weighted scorecard comparing up to four suppliers across eight criteria, with automatic ranking.
Inventory Tracking Template
Per-SKU stock sheet that calculates safety stock, reorder point, days of cover, and reorder alerts.
Dropshipping Profit & Loss Template
Month-by-month P&L that turns orders, product cost, ad spend, and fees into net profit and margin automatically.
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.