01
Fill it in the browser
Type into the packing list right on this page — no sign-up. Save it to a free Layers account to keep it.
- Works today Pages, spreadsheets and documents in the browser
Work
ProjectsTasks, sprints and milestones PagesDocs and knowledge base FormsSurveys, quizzes, booking FlowProcesses and mockupsFree Excel template · Export
The packing list is open below — type the cartons and goods. The Excel version totals weights and CBM, fills the commercial invoice from the packing list and keeps a statement of shipments and payments for your buyer.
| PACKING LIST | ||||||||||||||
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. | ||||||||||||||
| Exporter | Sunrise Coconut Products Inc. (sample), Davao City, Philippines | Invoice No. | SCP-EX-2026-031 | Invoice date | 2026-10-15 | Buyer PO No. | NP-PO-7781 | |||||||
| Consignee (buyer) | Nordic Pantry AB (sample), Gothenburg, Sweden | Incoterms 2020 | FOB | Port of loading | Davao, PH | Port of discharge | Gothenburg, SE | |||||||
| Notify party | Same as consignee | Vessel / voyage | MV Example 042E | Container No. | ABCU 123456-7 | Country of origin | Philippines | |||||||
| Marks & numbers | NORDIC PANTRY / GOTHENBURG / C/NO. 1-UP / MADE IN PHILIPPINES | |||||||||||||
| Carton from | Carton to | Cartons | Description of goods | HS code | Qty per carton | Total qty | Net wt/ctn (kg) | Gross wt/ctn (kg) | Total net (kg) | Total gross (kg) | L (cm) | W (cm) | H (cm) | CBM |
| 1 | 400 | 400 | Virgin coconut oil, 500 ml glass bottle | 1513.11 | 12 | 4,800 | 6.60 | 8.40 | 2,640.00 | 3,360.00 | 40 | 30 | 25 | 12.000 |
| 401 | 700 | 300 | Desiccated coconut, fine, 1 kg pouch | 0801.11 | 10 | 3,000 | 10.00 | 10.60 | 3,000.00 | 3,180.00 | 50 | 35 | 30 | 15.750 |
| 701 | 820 | 120 | Coconut sugar, 500 g pouch | 1702.90 | 20 | 2,400 | 10.00 | 10.50 | 1,200.00 | 1,260.00 | 45 | 35 | 25 | 4.725 |
| - | - | - | - | - | ||||||||||
| - | - | - | - | - | ||||||||||
| TOTAL | 820 | 10,200 | 6,840.00 | 7,800.00 | 32.475 | |||||||||
| 820 cartons · net 6,840.00 kg · gross 7,800.00 kg · 32.475 m³ | ||||||||||||||
| Weights OK | ||||||||||||||
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. | ||||||||||||||
| © Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers. | ||||||||||||||
| COMMERCIAL INVOICE | ||||||
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. | ||||||
| Exporter | Sunrise Coconut Products Inc. (sample), Davao City, Philippines | Currency | USD | |||
| Consignee | Nordic Pantry AB (sample), Gothenburg, Sweden | Payment terms | T/T 30 days | |||
| Invoice No. | SCP-EX-2026-031 | |||||
| Invoice date | 2026-10-15 | |||||
| Incoterms | FOB Davao, PH | |||||
| Buyer PO No. | NP-PO-7781 | |||||
| Country of origin | Philippines | |||||
| # | Description of goods | HS code | Quantity | Unit | Unit price | Amount |
| 1 | Virgin coconut oil, 500 ml glass bottle | 1513.11 | 4,800 | pcs | 7.20 | 34,560.00 |
| 2 | Desiccated coconut, fine, 1 kg pouch | 0801.11 | 3,000 | pcs | 3.90 | 11,700.00 |
| 3 | Coconut sugar, 500 g pouch | 1702.90 | 2,400 | pcs | 2.60 | 6,240.00 |
| - | - | |||||
| - | - | |||||
| Packages: 820 cartons · net 6,840.00 kg · gross 7,800.00 kg | Total goods value | 52,500.00 | ||||
| Freight (if in the price) | - | |||||
| Insurance (if in the price) | - | |||||
| TOTAL INVOICE VALUE | 52,500.00 | |||||
| We certify that this invoice is true and correct and that the goods are of Philippine origin. | ||||||
| Authorised signature, name, date | ||||||
| © Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers. | ||||||
| STATEMENT OF SHIPMENTS AND PAYMENTS — for the buyer | ||||||||
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. | ||||||||
| Buyer | Nordic Pantry AB (sample), Gothenburg, Sweden | Statement date | 2026-10-19 | |||||
| Date | Document | B/L or AWB | Invoiced | Paid | Balance | Due date | Days overdue | Status |
| 2026-07-20 | SCP-EX-2026-019 | BL DVO-55102 | 21,840.00 | - | 21,840.00 | 2026-08-19 | Paid | |
| 2026-08-18 | Payment T/T | - | 21,840.00 | - | ||||
| 2026-09-10 | SCP-EX-2026-026 | BL DVO-55870 | 18,920.00 | - | 18,920.00 | 2026-10-10 | 9 | Overdue |
| 2026-10-02 | Payment T/T (part) | - | 10,000.00 | 8,920.00 | ||||
| 2026-10-15 | SCP-EX-2026-031 | BL DVO-56311 | 52,500.00 | - | 61,420.00 | 2026-11-14 | Open | |
| Total balance due | 61,420.00 | |||||||
| Note: payments are applied to the oldest invoice first; "Days overdue" counts from the due date to the statement date. | ||||||||
| © Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers. | ||||||||
Start typing right in the document — no sign-up. It stays in this browser; save it to your free Layers account to keep it, open it on your phone and share it.
What is inside
Carton from–to, HS code, qty per carton, net / gross weight, L×W×H and CBM, with totals and a weight check.
Description, HS code and quantity from the packing list; unit price, freight and insurance by Incoterms.
Invoices, B/L, payments, running balance, due dates and days overdue.
Exporter, consignee, notify party, Incoterms 2020, ports, vessel, container, marks.
Yellow cells are for you to type, blue cells are calculated. Ordinary formulas, no macros — opens in Excel, Google Sheets and LibreOffice. Licence CC BY 4.0 · © Layers (layers.md).
How to use it
1
Exporter, consignee, Incoterms, ports, vessel and container number.
2
One line per carton range with the same goods: from, to, qty and weight per carton, dimensions.
3
Cartons, net and gross weight and CBM must match the booking and the B/L.
4
Unit prices on the commercial invoice; freight and insurance if your Incoterm includes them.
5
Add the invoice and payments to the buyer statement.
What people do next
Share the packing list and invoice with the buyer before loading.
The next document your buyer's customs broker usually asks for.
Honest status: Works today is live now; Coming is not yet.
01
Type into the packing list right on this page — no sign-up. Save it to a free Layers account to keep it.
02
Formulas, checks and print layout in .xlsx — opens in Excel, Google Sheets and LibreOffice.
03
One folder for the team: everyone sees the latest version; comments instead of e-mail threads.
04
Open the .xlsx in the Layers spreadsheet editor with formulas, without Microsoft Office.
In practice yes: the forwarder, customs and, under a letter of credit, the bank ask for it together with the commercial invoice and the bill of lading. It is how cartons and weights are checked against the booking.
The packing list describes how the goods are packed — cartons, weights, dimensions — for the forwarder and customs inspection. The commercial invoice states the price and value for payment and customs duty. Both use the same descriptions and quantities.
CBM = number of cartons × length × width × height in cm ÷ 1,000,000. A 40 × 30 × 25 cm carton is 0.03 m³; 400 of them are 12 m³.
Any of the Incoterms 2020 rules — choose it from the list. Freight and insurance lines are for CIF, CIP and similar terms.
Yes. Use the AWB number instead of the B/L; chargeable weight is the larger of gross weight and volume weight (CBM × 167 kg for air).
No. The packing list is open on this page; sign in free only to save it.
More free Excel templates
The template and the editor are free. Layers is free for teams of up to 20 people.
Templates are starting points. Check figures and rules with your accountant, engineer or the agency concerned. Layers is an independent product.
We use no tracking cookies: the site only remembers the theme and language you choose. Analytics and third-party videos will only be turned on with your consent. About cookies