Commercial Invoice Template Excel | Packing List & Pro Forma Invoice | HTS Code, Incoterms, CBM | Import Export Shipping Documents
NowPrice:$5.25
Original Price: $7.00
25% off
Sale ends in 1 day
Here's what's eligible:
- Your order doesn't match the item description or photos
- Your item arrived damaged
- Your item arrived after the estimated arrival window
- Your item didn't arrive or was lost in the mail
You can only make an offer when buying a single item
Highlights
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
More from this shop
Visit shop-
Digital download
Motorcycle SVG Bundle, 12 Biker Cut Files for Cricut, Rider Dad Svg, Grandpa Gift, Garage Sign DXF, Helmet Decal Svg, Laser Cut, Rider Shirt
Sale Price $3.37
Original Price $4.50
-
Digital download
8-Bit Platformer Sound Effects, 23 Retro Jump, Landing, Door and Switch Sfx for Indie Games, WAV OGG MP3, Royalty-Free
$2.25
-
Digital download
Christmas SVG Bundle, 15 Winter Cut Files for Cricut, Checkered Truck Svg, Ornament Svg, Snowflake Svg, Gingerbread Svg, Laser DXF PNG
Sale Price $3.00
Original Price $4.00
-
Digital download
Undated ADHD Planner, Digital + Printable PDF, Brain Dump, Time Blocking, Focus Log, Dopamine Menu, Hyperlinked Tablet Planner, Letter + A4
Sale Price $4.50
Original Price $6.00
Be the first to leave a review
Shoppers with similar taste loved these
-
Acrylic QR Code Display Sign: Social Media, Four Codes (4.5x9)
$8.95
-
Digital download
craft show bundle, small business bundle, order form template, price list template. scan to pay template, craft fair template
$2.00
-
Digital download
EDITABLE Daily Work Log Excel Template Track Time Projects Priorities Hours Worked Summary accomplishment tracker
$13.79
-
Digital download
Biweekly Paycheck Budget Spreadsheet Bill Calendar Weekly Monthly Budget Planner Expense Savings Debt Tracker Google Sheets Excel Template
Sale Price $12.55
Original Price $20.92
-
Digital download
Small Business Template Bundle, Price List Template, Editable Canva Templates, Business Cards Template Small Business Signs Gift Certificate
Sale Price $0.85
Original Price $1.31
-
Digital download
ELF - Scan to Pay Template, Holographic Glitter Purple Payment Sign, QR Payment Sign, Printable Customer QR Sign DiY Cash App Sign Editable
Sale Price $3.20
Original Price $7.11
-
Digital download
Scan To Pay Sign Template Bundle: QR Code Payment (Canva Editable, Digital Download)
Sale Price $2.74
Original Price $4.99
-
Square dock and business card holder, market stall display, square card reader dock, business card holder, craft markets | Poethan
Sale Price $16.11
Original Price $23.02
-
Digital download
COLIBRI - Scan to Pay Template, Holographic Glitter Payment Sign, QR Payment Sign, Printable Customer QR Sign, DiY Cash App Sign Editable
Sale Price $3.20
Original Price $7.11
-
Digital download
COLIBRI - Editable Price List, Printable Holographics Business Pricing Template, Modern Beauty Price List, Brow Lash Price List Template
Sale Price $2.89
Original Price $6.42
-
Custom Business Acrylic Stamps,Handmade DIY Acrylic Rubber Stamps,Journal Rubber Stamps,Wedding Stamps,Packaging Rubber Stamps
Sale Price $8.58
Original Price $13.20
-
Custom Return Address Stamp | Custom business logo stamp
Sale Price $22.45
Original Price $24.95