Posted on 27 January 2025
Free Commercial Invoice Template for Customs in Excel, Google Sheets, Word and PDF
- Free commercial invoice template available to download in Excel, Word, PDF and Google Sheets
- Products sheet fills HS code, country of origin, unit and net weight on every line
- Shows the invoice total and a customs value estimate on a FOB or CIF basis
- 22-point Customs Check flags missing Incoterms, origins, weights and signatures before the goods ship
A commercial invoice template is a ready-made form for the document an exporter issues when goods cross a border. It lists the seller, buyer and consignee, each item’s HS code, country of origin, quantity, weight and value, plus the Incoterm and currency, so customs can assess duty and the buyer can pay.
Last updated: November 10, 2026
What it is
A commercial invoice template for goods shipped across a border. It lists the parties, the goods, HS codes, origin, weights, Incoterms and the values customs reads.
When you need it
Every time goods with a commercial value leave the country, whether they are sold, sent as samples or replaced for free.
What's inside
A printable commercial invoice, a Products list, a 22-point Customs Check, a customs value estimate and an Invoice Register.
Formats
Excel, Google Sheets, Word and PDF. The Word and PDF files are a one-page form plus a continuation sheet.
Want to see it filled in first?
Make your own copy of the filled sample in Google Sheets.
What Is a Commercial Invoice Template?
Your cartons are on the dock. The carrier asks for one document before anything moves.
Not the packing list. Not the quote. The commercial invoice.
A commercial invoice template is a ready-made form for the document an exporter issues when goods cross a border. It names the seller, buyer and consignee, describes each item with its HS code, country of origin, quantity, weight and value, and states the Incoterm and currency, so customs can assess duty and the buyer can pay.
You will also hear it called a customs invoice, a commercial invoice for customs, an export invoice or an international shipping invoice. Carriers publish their own versions too. The fields barely change.
the quote
the deal
the sale, declared
duty assessed
the bill settled
And what isn't it? It isn't the sales contract. The purchase order or sales agreement holds the deal, and the commercial invoice records the sale that came out of it. It isn't a quote either. That is the proforma's job. And a template isn't a legal form: some countries publish their own, such as the Canada Customs Invoice.

Commercial Invoice vs Proforma Invoice vs Packing List vs Certificate of Origin
Four documents often travel in the same envelope. Each one answers a different question for a different reader.
| Document | The question it answers | When it is issued | Who relies on it |
|---|---|---|---|
| Commercial invoice | What was sold, to whom, and for how much? | When the goods ship | Customs, the buyer, the bank |
| Proforma invoice | What will this cost if you order? | Before the sale is final | The buyer, for approval or a letter of credit |
| Packing list | What is in each carton, and how heavy is it? | When the goods are packed | The carrier and warehouse staff |
| Certificate of origin | Where were the goods made? | When a trade agreement or buyer asks | Customs, for preferential duty |
The proforma asks for the order, the packing list counts the boxes, and the commercial invoice declares the sale.
Which Commercial Invoice Format Fits Your Shipment?
Pick the file by what happens next to it.
| If your situation is... | Use this | Where to find it |
|---|---|---|
| You ship goods abroad and want the totals worked out | The commercial invoice template Excel workbook, no macros | Excel file |
| You share the file with a forwarder or a colleague | The same workbook, online | Google Sheets copy |
| You fill it in by hand, or a carrier wants a printed copy | A blank commercial invoice template Word form with a continuation sheet | Word or PDF file |
| You export goods on a regular basis and need export-only fields | A dedicated export commercial invoice template | A separate download |
| You haven't agreed the order yet | A proforma invoice template | A separate download |
| You are buying the goods, not selling them | A purchase order template | A separate download |
| You deliver goods locally, with no border | A delivery note template | A separate download |
What Does the Commercial Invoice Template Contain?
Whether you open the Excel version or the commercial invoice template Word form, these are the fields customs, carriers and buyers look for.
| Field | What goes in it | Why it matters |
|---|---|---|
| Exporter / shipper | Name, address, phone, tax ID such as an EIN, ABN or EORI | Names who is responsible for the export |
| Consignee | Who receives the goods, with their tax ID | Where the goods go and who clears them |
| Invoice number, date, PO, currency | Unique number, issue date, buyer's order number, for example USD | Links the invoice to the deal and fixes the currency |
| Incoterm and named place | For example CIF Sydney | Says who pays freight and insurance, and where risk passes |
| Transport details | Mode, carrier, air waybill or bill of lading number, ports | Ties the invoice to the transport document |
| Reason for export | Sale, sample, gift, repair, return, replacement | Customs treats each one differently |
| Description of goods | What it is, what it is made of, what it is for | Vague descriptions cause holds |
| HS code | 6 to 10 digits per line | Sets the duty rate and any controls |
| Country of origin | Where each item was made, per line | Decides tariffs and trade agreement benefits |
| Quantity, weights, packages | Per line net weight, plus total gross weight and carton count | Must match the packing list |
| Unit value and line value | Price per unit and quantity times price | The base for duty |
| Charges | Discount, freight, insurance, packing, other | Customs adds or removes them by country |
| Declaration and signature | A signed statement that the invoice is true | Makes someone answerable for the numbers |
The field that matters most is the one people copy from last time: the HS code. The World Customs Organization says the HS uses six-digit codes at its core. A four-digit guess or an outdated code can change the duty rate, or hold the shipment while customs asks questions.
What the Enerpize Commercial Invoice Template Includes
The old file was a sales invoice with a new title. It had no HS code, no origin and no weights. We rebuilt it around the fields carriers print on their own forms, then added what a blank form can't do: catch problems before the goods leave. It runs on formulas, with no macros, and yellow cells are the only ones you type in.
A Product List That Remembers
Enter each product once on the Products sheet: SKU, description, HS code, origin, unit and net weight. On the invoice, pick the SKU and type the quantity and price. The rest fills in, so the HS code on invoice 40 matches invoice 1. The sheet also counts the digits in each code and flags anything outside 6 to 10.

Two Totals, One Invoice
The buyer pays the invoice total. Customs values something else. The template shows both: the invoice total, and a customs value estimate on a FOB or CIF basis, depending on the destination you pick. In our sample, the gap is 1,245.00 USD of freight and insurance.

A Customs Officer Before the Customs Officer
The Customs Check sheet runs 22 checks against the invoice: exporter and consignee details, Incoterm with a named place, HS code length, origin on every line, gross weight against net weight, freight under C and D terms, the US EEI limit and a signed declaration. Each one reads PASS, REVIEW, FIX, NOTE or N/A. FIX means fix it before the goods ship.

A Free Line That Still Has a Price
Sending a replacement or a sample? Customs still wants a value. Set the line to "No charge" and it stays on the invoice at its real value, but drops out of what the buyer pays. Six replacement bowl sets worth 58.80 USD are declared in the sample, and billed at zero.
Every Export Invoice in One List
Copy each invoice into the Invoice Register and add payments as they arrive. The register works out the balance, marks Paid, Part Paid, Unpaid or Overdue, and counts days overdue.

Incoterms 2020 and What They Do to Your Commercial Invoice
Two letters and a place name decide who pays for the ship, and what belongs on your invoice. Here are the 11 Incoterms 2020 rules.
| Rule | Main carriage paid by | What to show on the invoice |
|---|---|---|
| EXW Ex Works | Buyer | Goods only. The buyer collects. |
| FCA Free Carrier | Buyer | Goods, handed to the buyer's carrier. |
| FAS Free Alongside Ship | Buyer | Goods, alongside the vessel. Sea only. |
| FOB Free On Board | Buyer | Goods, loaded on the vessel. Sea only. |
| CFR Cost and Freight | Seller | Goods plus freight to the port. Sea only. |
| CIF Cost, Insurance and Freight | Seller | Goods, freight and insurance you buy. Sea only. |
| CPT Carriage Paid To | Seller | Goods plus carriage to the named place. |
| CIP Carriage and Insurance Paid To | Seller | Goods, carriage and insurance you buy. |
| DAP Delivered at Place | Seller | Goods plus delivery to the named place. |
| DPU Delivered at Place Unloaded | Seller | Goods plus delivery and unloading. |
| DDP Delivered Duty Paid | Seller | Goods, delivery, and import duty you pay. |
The Customs Check reads your Incoterm. Under CFR, CIF, CPT, CIP, DAP, DPU or DDP, it asks you to show freight. Under CIF and CIP, it also asks for insurance, because those two rules oblige the seller to buy cover.
⚡ Tip: Always write the named place: "CIF Sydney, Australia", not just "CIF". An Incoterm without a place leaves cost and risk open.
Commercial Invoice Sample: A Filled Template to Copy
Want to see a finished one before you start? Make your own copy of the filled commercial invoice sample in Google Sheets. It follows a fictional exporter, Cedar Street Supplies in Tacoma, shipping kitchenware to a Sydney importer by sea on 9 November 2026. The images on this page use the same sample data.

How to Read the Sample
Start at the lines of this commercial invoice sample. Seven of them, 1,656 units, 14 cartons. Net weight is 1,274.20 kg and gross weight is 1,378.00 kg, so packaging adds about 104 kg.
10,130.80
58.80
150.00
1,335.00
11,257.00
Now look at the customs value. Australia values imports FOB, so the 1,180.00 freight and 65.00 insurance stay out. The estimate is 10,070.80 USD. Ship the same invoice to the UK, which adds freight and insurance, and it becomes 11,315.80.
Finally, the Customs Check reads "Ready after review". The two REVIEW lines are worth a look. All seven lines use 6-digit HS codes, so a broker may ask for more digits. And one code, 7323.93, totals 6,148.80 USD across three lines, above the 2,500 USD EEI limit for US exports.
Commercial Invoice Formulas
Every formula is built into the commercial invoice template Excel file. Here is what each one does, with a number from the sample.
Line Value
Line Value = Qty x Unit Value | =IF(AND(ISNUMBER(G25),ISNUMBER(K25)),G25*K25,"")
Line 1: 120 saucepan sets x 38.50 = 4,620.00 USD.
Invoice Total
Invoice Total = Goods Billed − Discount + Freight + Insurance + Packing + Other
10,072.00 − 150.00 + 1,180.00 + 65.00 + 90.00 = 11,257.00 USD. That is what the buyer owes.
Customs Value Estimate
FOB basis = Goods Declared − Discount + Packing | CIF basis = FOB basis + Freight + Insurance
10,130.80 − 150.00 + 90.00 = 10,070.80 on a FOB basis. Add the 1,245.00 of freight and insurance and the CIF basis is 11,315.80. It is an estimate for planning. Your broker or customs confirms the value.
How to Use the Commercial Invoice Template
The first invoice takes about 20 minutes. The next one takes five, because the products are already there.
1- Enter Business Details
Add your company, address, tax ID or EORI, default currency, weight unit and signatory on Settings. Say whether you export from the United States, which turns on the EEI check.
⚡ Tip: Use your legal name as it appears on your export registration, not your shop name.
2- Build the Products List
Add each product with a plain description, HS code, country of origin, unit and net weight per unit. Why here? Because one correct entry beats fifty retyped ones.
⚡ Tip: Type HS codes as text, such as 0901.21, so Excel keeps the leading zero.
3- Add Billing and Shipping Information
Fill in the consignee, and the buyer if different. Then the invoice number, date, PO, currency, payment terms and reason for export.
⚡ Tip: If the consignee is a warehouse, name the importer of record under Sold To.
4- Set the Terms of Sale
Pick the Incoterm and type the named place. Then pick FOB basis or CIF basis for the destination, using the table on Settings.
⚡ Tip: Copy the Incoterm from the purchase order, word for word.
5- List the Goods
On each line, pick the SKU, then enter quantity and unit value. Set Charged to "No charge" for samples and replacements.
⚡ Tip: Keep freight out of the unit price. Show it once, in the Freight box.
6- Review the Customs Check
Fix every FIX, decide on every REVIEW. The overall status reads "Ready to print" when nothing is left.
⚡ Tip: A REVIEW is a question, not an error. A 6-digit HS code may be fine for your broker.
7- Save and Share
Print the Commercial Invoice sheet or save it as a PDF, sign it, and attach it to the shipment. Then copy row 7 into the Invoice Register.
⚡ Tip: Carriers often ask for three signed copies. Keep one for your records.
Common Commercial Invoice Mistakes
Customs rarely calls to say thank you. It calls when something on the invoice doesn't add up.
✕ Vague descriptions
Why it matters: "Kitchen items" tells customs nothing about what to classify.
Fix: Say what it is, what it is made of and what it is for: "Stainless steel saucepan set, 3-piece".
✕ A short or guessed HS code
Why it matters: A 4-digit code can't be classified, and a wrong one can change the duty.
Fix: Use 6 digits at least, and the full destination code when your broker asks.
✕ An Incoterm with no place
Why it matters: "CIF" alone doesn't say where cost and risk pass.
Fix: Write the rule and the place: "CIF Sydney, Australia".
✕ Declaring free goods at zero
Why it matters: A replacement still has a value for duty.
Fix: Enter the real value and mark the line "No charge".
✕ Freight buried in the unit price
Why it matters: Customs can't remove freight it can't see, so you may pay duty on it.
Fix: Show freight and insurance as separate charges.
Importance of Commercial Invoice Template
Why does one page carry so much weight? Because the codes on it are read the same way almost everywhere. The World Customs Organization says the Harmonized System is used by more than 200 countries and economies, and over 98% of merchandise in international trade is classified in terms of the HS.
So what? A code you type in Tacoma is read in Sydney, Toronto and London. Get it right once, on the Products sheet, and it travels with every invoice.
Customs Clearance
Customs reads it to decide what the goods are, where they come from and what they are worth. Missing fields mean questions, and the cartons wait.
Proof of Transaction
It records what the two parties agreed. Reach for it in a dispute or an insurance claim.
Payment and Letters of Credit
When a buyer pays by letter of credit, the bank checks the invoice against the credit's terms. A description or Incoterm that doesn't match can hold the payment.
Financial Record-Keeping
Each export invoice is a sale in your books. The register in the template keeps 500 of them in one place, with balances and days overdue.
Regulatory Compliance
Some goods need more than a price. US exports on the Commerce Control List need a Destination Control Statement on the commercial invoice. The template prints it when you switch it on.
Commercial Invoice Spreadsheet vs Software
A spreadsheet is a fine place to start. It gets harder when you ship every week.
| What you need | Commercial invoice template | Enerpize |
|---|---|---|
| Cost | Free | Free trial, then a paid plan |
| Product details | Products sheet, typed once | Products and services with stock, selling price and purchase price |
| Customs fields | HS code, origin, Incoterm, weights built in | Invoice custom fields you add yourself |
| Totals and charges | Discount, freight, insurance, packing | Item and invoice discounts, shipping fees, deposits |
| Payment tracking | Register you update by hand | Invoice list filtered by Overdue, Due, Unpaid and more |
How Enerpize Handles Export Invoicing
What happens on invoice 50? With a spreadsheet, you copy, paste and hope. Enerpize keeps the product, the invoice and the payment connected. The screens below use sample data.
Products: Set Up Once, Picked Every Time
Each product carries a code, a selling price, a purchase price and its stock, with "In Stock" and the available quantity on the list. It is part of inventory management, so shipping 120 saucepan sets lowers the stock you can sell next.

Invoices: Lines, Discounts and Shipping Fees
Add items with unit price, quantity, discount and tax, then open the Shipping Details tab to add shipping fees. The invoicing software totals it all. In the sample, a 100% line discount carries the free replacement, and the total matches the template's 11,257.00.

Invoice Custom Fields: Room for Export Details
Need an Incoterm, port or package count on every invoice? Invoice Custom Fields let you add fields such as dropdowns, single lines, numbers and decimals, and show them on prints, listings and reports.

Sales Settings: Layouts and Shipping Options
Sales Settings holds printable invoice layouts, price lists, and shipping and delivery options with methods, fees and handling rules.

Invoice List: Who Has Paid
Every invoice shows its amount and status, and the list filters by Overdue, Due, Unpaid, Draft and Overpaid. No register to update by hand.

Commercial Invoice Requirements for the United States
Shipping into the US and shipping out of it follow two different rulebooks. A US commercial invoice template has to serve both.
For goods entering the US, 19 CFR 141.86 lists what the invoice must show. That includes the purchase price of each item in the currency of the purchase, all charges itemized by name and amount, including freight, insurance and commission, and the country of origin. The invoice and its attachments must be in English, or carry an accurate English translation.
For goods leaving the US, Electronic Export Information is filed in AES unless an exemption applies. 15 CFR 30.37(a) exempts goods from one exporter to one consignee where the value under an individual Schedule B number is 2,500 USD or less. Items on the Commerce Control List also need the Destination Control Statement on the commercial invoice under 15 CFR 758.6. EAR99 items don't.
What to add:
- "Yes" for exporting from the United States in Settings
- The 10-digit Schedule B or HTS code where your broker asks for it
- The ITN in Package Marks and Notes once you have filed
- The Destination Control Statement, only for items controlled under the EAR
⚑ Practical note: The EEI check groups lines by the HS code you typed. The rule also separates US-origin and foreign-origin goods under the same code. In the sample, the US-made saucepans alone, at 4,620.00 USD, are over the limit.
Commercial Invoice Requirements for the United Kingdom
Here is the twist for UK buyers: freight counts.
HMRC's guidance on delivery costs to include in the customs value, last updated 15 April 2026, says to include the cost of transport, insurance, and loading and handling, up to the place the goods enter the UK. By sea, that is the UK port of importation. Anyone moving goods to or from Great Britain also needs an EORI number that starts with GB.
What to add:
- CIF basis as the customs value basis
- Freight and insurance as separate charges, never inside the unit price
- The buyer's GB EORI under the consignee's tax ID
- Your own EORI in Settings if you trade with the UK often
⚑ Practical note: Under DAP or DDP, your freight runs to the buyer's door. Only the part up to the UK border belongs in the customs value. Ask your carrier to split the charge.
Commercial Invoice Requirements for Australia
One number decides the paperwork: AUD 1,000.
The Australian Border Force says an Import Declaration is required when goods have a combined value over AUD 1,000. At AUD 1,000 or less, a Self-Assessed Clearance declaration generally applies. Commercial invoices are among the documents it lists. Its fact sheet on the value of imported goods says the customs value does not include freight and insurance from the place of export to Australia, but does include overseas packing and inland freight before export.
What to add:
- FOB basis as the customs value basis
- Packing as its own charge, because it stays in the value
- The importer's ABN under the consignee's tax ID
- The port of loading, which marks where the FOB value stops
⚑ Practical note: Our sample ships CIF Sydney for 11,257.00 USD, but the customs value estimate is 10,070.80. The 1,245.00 of freight and insurance stays out.
Commercial Invoice Requirements for Canada
Canada has its own invoice form. Do you have to use it? Not always.
CBSA Memorandum D1-4-1 on invoice requirements allows three options for commercial shipments: a commercial invoice with all the information in its Appendix A, a commercial invoice with the buyer, seller, price and description plus a Canada Customs Invoice for the rest, or a completed Canada Customs Invoice. Invoices can be in English or French. On value, Memorandum D13-3-4 says a transport charge from the place of direct shipment is not added when invoiced separately, and can be deducted when it is inside the invoice price.
What to add:
- FOB basis as the customs value basis
- The place of direct shipment as the port of loading
- Package count and marks, which Appendix A asks for
- The Related Parties answer, filled in every time
⚑ Practical note: This template is a commercial invoice, not the CI1 form. D13-3-4 doesn't cover insurance, so ask your broker how to treat it before you rely on the estimate.
Who Can Use the Commercial Invoice Template?
Small Exporters and Wholesalers
Ten products, five buyers, two international shipping runs a month. The commercial invoice template Excel file keeps HS codes and the country of origin per product, so you stop retyping them, and the register shows who still owes you.
Trading and Distribution Businesses
Buying in one country and selling in another? A business in international trade can pair this invoice with a purchase order on the way in and a delivery note on the way out.
Importers Checking Supplier Invoices
Receiving goods? Run your supplier's invoice through the same checks. A missing origin is cheaper to fix before the ship sails than at the port.
Commercial Invoice Glossary
| Term | What it means |
|---|---|
| HS code | The Harmonized System code that classifies goods. Six digits are shared worldwide. |
| Customs value | The value customs uses to work out duty. |
| FOB basis | Customs value without freight and insurance after export. |
| CIF basis | Customs value including freight and insurance to the border. |
| EORI | The registration number for moving goods in or out of the UK or EU. |
| EEI and ITN | US export data filed in AES, and the number you get back. |
Key Takeaways
- A commercial invoice for customs declares the sale: parties, goods, HS codes, origin, weights, Incoterm and values.
- HS codes have six digits at their core, and the system covers over 98% of merchandise trade, according to the WCO.
- The invoice total and the customs value can differ. In our sample, 11,257.00 USD becomes 10,070.80 on a FOB basis.
- The US, Canada and Australia leave international freight out of customs value. The UK adds it back up to the border.
- Free goods still need a value. The sample declares 58.80 USD of replacements and bills them at zero.
- US exports need EEI when one Schedule B number is over 2,500 USD from one exporter to one consignee.
- Australia requires a full Import Declaration above AUD 1,000.
- Run the 22-point Customs Check before every shipment, and fix every FIX before the cartons leave.
Frequently Asked Questions
Do you always need a commercial invoice for international shipping?
For goods with a commercial value, yes. Carriers ask for one on almost every international shipment of goods, including samples, gifts and replacements. Shipments of documents only usually don't need one. When in doubt, include it, because a missing invoice holds the shipment.
What is mandatory on a commercial invoice?
The exporter and consignee, an invoice number and date, a clear description of each item, its HS code, country of origin, quantity, unit value and total, the currency, the Incoterm and a signed declaration. Some countries add more, such as an EORI in the UK.
Is a commercial invoice legally binding?
It is evidence of the sale and the basis for the customs declaration, so false information can lead to penalties. The sales contract or purchase order is what binds the two parties. The signed declaration on the invoice makes the signer answerable for its accuracy.
Can you use a proforma invoice for customs clearance?
Some carriers and customs authorities accept a proforma when there is no sale, such as for samples. For a sale, customs expects the final commercial invoice. Check with your carrier before shipping on a proforma alone.
Who prepares the commercial invoice?
The exporter or seller, because they know the goods, the price and the terms. A forwarder or broker may prepare it on their behalf, but the exporter stays responsible for what it says.
How many copies of a commercial invoice do I need?
Carriers often ask for three signed copies, one original and two copies, plus one for your records. Many accept electronic invoices instead, so check when you book.
Should freight and insurance be shown on a commercial invoice?
Yes, as separate charges. US rules ask for all charges to be itemized by name and amount, and showing them separately lets customs in FOB-basis countries leave them out of the dutiable value.
Is a commercial invoice proof of payment?
No. It shows what is owed, not what was paid. Use a receipt, a bank record or a client statement as proof of payment. The template's Invoice Register tracks what each buyer has paid and what is still open.
New to invoicing in general? The complete guide to invoices covers the basics, and the free invoice generator makes a domestic invoice in minutes.
About the Author
Omar El Bahr is a Senior Digital Growth Specialist at Enerpize, where he leads SEO, content strategy, and organic growth across international markets. He is a Forbes Communications Council contributor and has written for Entrepreneur on business communication and digital strategy.
Disclaimer
This template and the information on this page are for general guidance only and are not legal, customs or tax advice. Customs rules, thresholds and forms differ by country and change over time, so confirm your position with a licensed customs broker or the customs authority. The customs value in the template is an estimate, and the template is not an official customs form.
