Free template · Excel

Packing List Format: Free Excel Template + Example

A ready packing list layout for factory dispatch and exports. Get the blank Excel format and a filled example, with box numbers, net and gross weights and CBM totalled for you.

Download the Excel template

What is a packing list?

A packing list is the document that shows what is inside each box of a shipment, with no prices. It lists the item, quantity, package numbers, net and gross weight, size and volume. A standard format has three parts. The header carries the shipper, buyer, invoice and PO numbers, and transport details. Then comes a box-by-box table, and a footer with totals and a signed declaration. For exports from India it goes with the commercial invoice, and its item descriptions and HSN codes must match the invoice exactly.

Customs, the freight forwarder, the bank and the buyer's stores all check the cargo against it.

Who prepares the packing list?

The seller prepares it, usually the dispatch or export team that packed the goods.

What each column in the packing list format means

The free Excel file has the same three parts, like our bill of materials format.

Header fields

  • Packing list no. and date: a running number, dated the day of dispatch.
  • Shipper and consignee: names, addresses and GSTINs. Exporters add their IEC.
  • Invoice no. and buyer's PO no.: these tie the boxes to the sale.
  • Transport: mode, transporter, LR and vehicle number, plus the e-way bill number for domestic dispatch.

Table columns

  • Box nos: the box range and package type, such as 1–12 (carton).
  • Description (unit): word for word from the invoice, with the unit.
  • HSN: the same code as on the invoice.
  • Total qty and Qty/box: the total shipped, and units in one box.
  • Boxes: Total qty ÷ Qty/box. Put a part box on its own row.
  • Net and gross kg/box: net is the goods alone. Gross adds the box, crate or pallet.
  • Total net and gross kg: kg/box × Boxes.
  • L×W×H cm: the outside size of one box.
  • Total CBM: L × W × H (cm) ÷ 1,000,000 × Boxes.

Footer

Add total boxes, weights and CBM. Then add a declaration, signature, name, designation, stamp and date.

Where TranZact cuts the retyping

Packing list errors often start with retyping the same items and quantities on every dispatch document. One typo and the documents disagree.

In TranZact, the e-way bill is generated from the GST invoice, not typed in again.

TranZact dispatch facts (as of 22 October 2026)

  • Sales: enquiry, quotation, order timeline, dispatch, e-invoicing and payment.
  • E-way bill from the GST invoice, with the e-invoice (IRN) in the same flow, on all plans.
  • Inventory: stock in, issue, multi-store, reorder and AI stock alerts. Batch-wise stock tracking from Scale+.
  • Accounting stays in Tally, Busy or Zoho Books, with a one-way sync and no double entry.
  • Custom document formats: Dominate plan (see pricing).
  • Live in 2–3 weeks.

One limit: box weights and sizes still come from your scale and tape. Record them in this template.

TranZact is manufacturing AI software built on 7 years of learning from 10,000+ manufacturers.

[[IMAGE {"type":"compare","title":"Dispatch paperwork: retyping vs TranZact","columns":["Retyping by hand","With TranZact"],"rows":[["E-way bill","Typed in separately","Generated from the GST invoice"],["E-invoice (IRN)","A separate step","Same flow as the e-way bill"],["Accounts","Re-entered in Tally","One-way sync, no double entry"],["Box weights and sizes","Scale and tape","Still scale and tape"]]}]]

Book a demo →

Worked example: an engineering unit ships 3 items in 28 packages

A made-up Pune engineering unit ships invoice INV-1189 to a buyer in Bengaluru. The filled Excel example uses the same figures.

Table 1 (Example): header

FieldExample
Packing list no.PL-0457
ShipperExample Engineering Pvt Ltd, Pune, with GSTIN
ConsigneeBuyer's company, Bengaluru, with GSTIN
Invoice and PO no.INV-1189 and PO-4471
TransportRoad: transporter, LR and vehicle no.
E-way bill no.The 12-digit EWB number

Table 2 (Example): box-wise line items and totals

Item (HSN)Box nos. and typeQty per box × boxesTotal qty
Machined steel flange, 1 inch (730791)1–12, carton50 × 12600 pcs
Hex bolt M8 × 40, zinc plated (731815)13–22, carton1,000 × 1010,000 pcs
Gear shaft, EN8, 400 mm (848310)23–28, wooden crate50 × 6300 pcs
Total28 packages10,900 pcs
ItemNet / gross per box (kg)Box size (cm) = CBM per boxLine totals
Flange45.0 / 47.560 × 40 × 30 = 0.072540 / 570 kg, 0.864 CBM
Hex bolt22.0 / 23.240 × 30 × 25 = 0.030220 / 232 kg, 0.300 CBM
Gear shaft150.0 / 168.0100 × 60 × 50 = 0.300900 / 1,008 kg, 1.800 CBM
Total1,660 / 1,810 kg, 2.964 CBM

Work one line through: 600 flanges at 50 per carton make 12 cartons. At 0.072 CBM each, they total 0.864 CBM.

Table 3 (Example): check against the invoice

Before you sign, match every line with the invoice.

ItemInvoice qtyPacking list qtyMatch
Flange600 pcs600 pcsYes
Hex bolt10,000 pcs10,000 pcsYes
Gear shaft300 pcs300 pcsYes
Total10,900 pcs10,900 pcsYes

Check descriptions and HSN codes the same way.

How to fill a packing list, step by step

  1. Start from the sales order or invoice. Copy the buyer, items, HSN codes and quantities.
  2. Pack and number the boxes. Mark each number on its box.
  3. Weigh and measure each box. Use a scale, not a guess. Measure the outside in centimetres.
  4. Fill the table. The template totals boxes, weights and CBM.
  5. Cross-check, then sign. Match the totals with the invoice, then sign, stamp and date.

Export vs domestic packing list

An export format adds these header fields:

  • Exporter's IEC and GSTIN, and the notify party
  • Place of receipt, ports of loading and discharge, and vessel or flight
  • Country of origin and country of final destination
  • Terms of delivery (EXW, FOB, CIF) and payment terms (LC, DA, DP)
  • Container and seal numbers for a full container load (FCL)

Do I need HSN codes on the packing list?

For exports, yes. They must exactly match the invoice and the shipping bill. The packing list isn't a GST document, but it must agree with your GST-compliant export invoice.

Domestic packing list

Within India, goods move on the tax invoice (or a delivery challan) and an e-way bill. A packing list is good practice there, not the main legal document. Put the invoice and e-way bill numbers in its header.

Packing list vs commercial invoice

PointPacking listCommercial invoice
Main jobShows what is in each boxBills the buyer for the goods
Prices and taxesNoYes
Weights, sizes, box numbersYesNot its job
Description and HSNYes, same as the invoiceYes

Can I combine the commercial invoice and packing list into one document?

Yes. The Foreign Trade Policy allows a combined commercial invoice-cum-packing list, and Indian customs accepts it. Keep both the prices and the box-wise details complete.

Common packing list mistakes

  • Descriptions that differ from the invoice. "MS flange 1 in" and "Steel flange 25 mm" read as two products.
  • Estimated weights. They get caught when someone else weighs the cargo.
  • Gaps or repeats in box numbers. Boxes 1–12 and 12–21 count box 12 twice.
  • CBM in the wrong unit. Measure in centimetres, not inches or millimetres.
  • Prices on the packing list. Keep them on the invoice.

Does the packing list need to be signed?

Yes. Sign, stamp and date it, with the signer's name and designation. Customs or banks can reject an unsigned one.

What happens if the packing list doesn't match the actual cargo?

Customs, the bank or the buyer can question or reject it. Fix it before the truck leaves: recount, correct the sheet and sign the new version.

Don't be the bottleneck. Become the AI-Run Factory.

See the sales flow from enquiry to dispatch, with the e-way bill generated from the GST invoice.

Born in India. Building for the world.

Book a demo →

Frequently asked questions

Does a packing list show prices?

No. Prices and taxes belong on the commercial or tax invoice. The packing list shows only what is physically in each package.

How do I calculate CBM for a packing list?

Multiply the box length × width × height in centimetres and divide by 1,000,000 to get cubic metres per box. Multiply by the number of boxes, then add up all the lines. The Excel template does this for you.

What is the difference between net weight and gross weight?

Net weight is the goods alone. Gross weight is the goods plus the box, crate or pallet. Gross must always be higher than net.

Is a packing list mandatory for export from India?

Yes. Indian Customs treats it as a mandatory export document. Its descriptions and HSN codes must match the commercial invoice and shipping bill.

Is the Excel template free?

Yes. Download the blank format and the filled example free, with no sign-up.

Don’t be the bottleneck.
Become the AI-Run Factory.

Book a demo

Born in India. Building for the world.