All free templates

Free Commercial Invoice Template for Excel

The commercial invoice is the document customs uses to decide what your goods are, where they came from, and what they are worth. Duty is assessed from it. A vague or incomplete one is the single most common reason a shipment sits at the border.

Download the Excel template.xlsx · no email, no signup · free to use commercially

This 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

FieldWhat goes in it
SKUYour product code, matching the PO and packing list.
Description of goodsSpecific: what it is, material, and use. Never "samples" or "goods".
HS codeSix digits minimum, per line. It sets the duty rate.
Country of originWhere it was made, per line — not where it shipped from.
Qty / UnitThe quantity being invoiced and the unit it is priced in.
Unit pricePrice per unit in the settlement currency.
AmountautoQuantity 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

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.

No credit cardSetup in minutesCancel anytime