Report this item to Etsy

Commercial Invoice Template Excel | Packing List & Pro Forma Invoice | HTS Code, Incoterms, CBM | Import Export Shipping Documents

NowPrice:$5.25

Original Price: $7.00

Loading

25% off

•

Sale ends in 1 day

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Digital download
  • Digital file type(s): 1 ZIP

Make your commercial invoice and packing list in minutes, from one product list.

Type each product once: description, HTS code, country of origin, price, unit weight and carton size. Then build an invoice by typing a SKU and a quantity. The description, HTS code, origin and price fill in, the totals add up, and the packing list builds itself with carton numbers, net and gross weights and CBM.

Made for small businesses that import or export goods: online sellers buying from overseas factories, small manufacturers shipping abroad, and anyone who has to send a commercial invoice and packing list with a shipment.

WHAT'S INSIDE

• Commercial Invoice: one page, ready to print. Seller, buyer, consignee, importer of record, notify party and manufacturer. Date and place of sale, Incoterms® 2020 rule and named place, currency, ports, carrier, B/L and container. Line items with SKU, description, HTS code, origin, quantity, unit and price. Itemized discount, packing, inland freight, international freight, insurance, commissions and other charges, then the invoice total. Declarations and a signature block.
• Packing List: made from the same lines. Cartons, running carton numbers (1–50, 51–80…), net and gross weight, carton size and CBM, with totals in kg and lb and in CBM and cubic feet.
• Pro Forma Invoice: a quotation version with its own lines, a valid-until date, estimated freight and insurance, deposit and balance.
• Product Master: room for 200 products, with an HTS format check, an "Example - verify" status for codes you haven't confirmed yet, and an optional column for the extra invoice details some goods need under 19 CFR 141.89.
• Parties & Settings: every party typed once, Incoterms® 2020 and currency dropdowns, payment terms, insurance rate and print mode.
• Shipment Log: one row per invoice, with the total, cartons, weight, CBM, B/L, port, entry number and status.
• Start Here: quick start, color guide, and a table of the U.S. invoice requirements in 19 CFR 141.86 with where each one is in the kit.

FEATURES

• Built around the U.S. commercial invoice requirements in 19 CFR 141.86, by a U.S. customs professional
• Insurance worked out for CIF and CIP from your rate (or type your own amount)
• Line checks flag a SKU that isn't on your list or a price in the wrong currency
• "Clean print" setting: input cells print white, so the documents look professional
• Prints on one page, Letter or A4
• Optional "Special information (19 CFR 141.89)" block that prints only when a product needs it
• All 11 Incoterms® 2020 rules in the dropdown
• 4 files: Light and Dark Mode, each with sample data (a home-goods importer buying mugs from China) and Blank
• Formulas are protected so they can't be typed over (no password; you can unprotect any time)
• No macros and no add-ins
• Same sample business and shipment numbers as the other importer kits (PO Tracker, Landed Cost Tracker, Freight Tracker)

COMPATIBILITY

Made for Microsoft Excel; Google Sheets not yet tested. Built and checked in Microsoft Excel for Mac (Microsoft 365), with no macros or add-ins.

HOW IT WORKS

1. Buy the listing and download the zip file.
2. Open the Example file to see it working, then start your own copy from the Blank file. Read the "Start Here" tab first.
3. Enter your parties and products, then type SKUs and quantities on the Commercial Invoice.

PLEASE NOTE

• This is a digital download. No physical item will be shipped.
• This is an organizing tool, not legal or customs advice. It does not classify your goods, value them or work out duties. Work with a licensed customs broker.
• The sample HTS codes are examples only. Confirm the codes for your own products.
• License: one business. You may share your filled-in copy and the documents you make with your employees, bookkeeper, freight forwarder or customs broker. Please don't resell or redistribute the file.
• Because this is a digital file, returns aren't accepted. If anything doesn't work, message me and I'll help.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

Shoppers with similar taste loved these

Show more
Show more
Listed on Nov 16, 2026