Customs-Ready Commercial Invoice With HS Codes Per Line
Customs uses the commercial invoice to decide what your goods are, where they were made, and what they are worth. Duty is assessed from it. A vague or incomplete one is the most common reason a shipment sits at the border.
This Excel template puts HS code and country of origin on every line rather than once for the whole shipment, which is what mixed-origin consignments actually require, and includes the declaration and signature block brokers expect to see.
What is in the commercial invoice template
| Field | What goes in it |
|---|---|
| SKU | Your product code, matching the PO and packing list. |
| Description of goods | Specific: what it is, material, and use. Never "samples" or "goods". |
| HS code | Six digits minimum, per line. It sets the duty rate. |
| Country of origin | Where it was made, per line, not where it shipped from. |
| Qty / Unit | The quantity being invoiced and the unit it is priced in. |
| Unit price | Price per unit in the settlement currency. |
| Amountauto | Quantity multiplied by unit price. |
Mistakes this template is designed to prevent
Describing goods as "samples", "gifts", or "goods"
Customs needs what it is, what it is made of, and what it is for. Generic descriptions invite inspection, and declaring commercial goods as gifts is a misdeclaration.
One country of origin for a mixed shipment
Origin is per line. Consignments combining goods from different countries are routinely held when the invoice claims a single origin.
The Incoterm and the invoice value disagree
If you invoice CIF, the value has to include freight and insurance. A CIF invoice showing an FOB value will be questioned, and the importer of record carries the liability.
Commercial Invoice Template FAQ
Related reading
- How to organize supplier invoices. File the commercial invoice against the PO, not a vendor folder
- How to calculate import duty from China. HS/HTS, Section 301, and entry fees before you declare a value
More free templates
Purchase Order Template
Standardised PO with automatic line totals, HS code fields, Incoterms, and payment terms.
Packing List Template
Shipping packing list that calculates carton counts, CBM, and air chargeable weight from the sizes you enter.
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.