Yes—you can make a commercial invoice template in Microsoft Excel by setting up seller and buyer details, shipment information, and a line-item table with quantities, unit prices, and totals. For an international shipment, also include customs-relevant details such as country of origin, goods descriptions, currency, and the applicable delivery terms; check the destination country and carrier requirements before using the file.
What a commercial invoice is used for
A commercial invoice records a sale of goods and gives customs authorities and shipping providers information about a shipment. It commonly identifies the exporter and importer, describes the goods, and states their quantities and values. Customs authorities may use the information to assess duties and taxes, check import controls, and match the paperwork to the shipment. A carrier may also ask for an invoice when arranging an international shipment.
It is not simply a domestic sales invoice with a different heading. A domestic invoice may focus on payment terms and sales tax, while an export commercial invoice needs sufficiently clear shipment and product information for the relevant customs process. Some destinations, goods, or shipping services have additional documentation rules, and a spreadsheet template does not replace a required government or carrier form.
It is also different from a packing list. The invoice states the goods and their declared values; a packing list focuses on how the goods are packed, such as the number of cartons, package contents, and weights. Businesses often prepare both because the documents serve different purposes.
Information to include in the Excel template
Organize the form so a reader can identify the parties, shipment, and goods without having to infer missing details. A practical template can include these fields:
- Invoice details: invoice number, issue date, and, if useful, a purchase-order or customer reference.
- Seller and buyer: legal or business names, addresses, and contact details. Identify the exporter and importer clearly.
- Shipment parties: consignee, ship-to address, and any other party the carrier or destination process requires. The buyer and consignee are not always the same.
- Transport information: shipment date, transport method, tracking or booking reference when known, and the relevant port or place details if requested.
- Delivery terms: the agreed Incoterms rule, its named place, and the version when applicable. For example, stating only “CIF” may be less clear than naming the rule and the relevant port or place.
- Goods table: clear product descriptions, quantities and units, unit prices, line totals, and the invoice currency. Add product codes, HS codes, or other identifiers when required and verified.
- Customs details: country of origin for each product when relevant, package count, net and gross weights, and any declarations or references required for that shipment.
- Payment and declaration: payment terms or method if useful, and a declaration or signature field if the destination, carrier, or company procedure calls for one.
Keep the description specific. “Parts” or “samples” may not tell a reviewer what the goods actually are. A description such as “stainless-steel water bottle, 750 ml” is more informative, provided it accurately describes the product. Do not assume a particular HS code, country of origin, or customs value: verify those details using reliable product and transaction records and the rules that apply to the shipment.
How to set up the workbook
In Excel for Microsoft 365 on Windows, create a new workbook and use a clearly separated header area for the invoice information and a table for the goods. One workable layout is to place the title and invoice number near the top, seller and buyer blocks below, shipment fields next, and the goods table starting around row 15. The exact cell positions are your choice; the example below uses rows 16 through 35 for up to 20 line items.
- Put one label and its value in separate cells for details such as invoice date, seller, buyer, consignee, currency, and delivery terms. This makes updates easier than typing everything into one large text box.
- Use a row of column headings for the goods table. For example: item or reference, description, HS code, quantity, unit price, line total, and country of origin.
- Reserve a summary area beneath the table for the subtotal and any other amounts that genuinely apply. Do not add a tax or freight charge merely because a sample invoice includes one.
- Enter a unique invoice number and use a consistent naming and filing method so the spreadsheet, sent invoice, and shipment records can be matched later.
For the example layout, use columns A through G for the goods table: A for item reference, B for description, C for HS code, D for quantity, E for unit price, F for line total, and G for country of origin. Enter headings in row 15 and goods on rows 16 to 35. If your business needs units of measure, package counts, or additional references, add columns without making the form so wide that it becomes difficult to read or print.
Calculate line totals and the subtotal
Excel can calculate arithmetic totals, but it cannot determine whether the underlying quantity, price, currency, customs value, or product classification is correct. Enter and review those source details carefully. For the example, assume the invoice currency is shown in a separate header field and all unit prices use that same currency.
With quantity in D16 and unit price in E16, enter this formula in F16 for the first product line:
=D16*E16
If D16 contains 12 and E16 contains 25, the line total in F16 is 300. With quantity in D17 and unit price in E17, enter =D17*E17 in F17; a quantity of 4 at a unit price of 18.75 returns 75. These figures are illustrative only. Copy the line-total formula down the other item rows, changing the row references as needed.
With the line totals in F16:F35, enter this formula in the subtotal cell, such as F36:
=SUM(F16:F35)
For the two example lines above and no other amounts, the subtotal is 375. The remaining blank rows contribute nothing. If your invoice includes freight, insurance, discounts, or another charge, show each amount clearly and follow the transaction terms and applicable requirements rather than silently folding it into a product line. Whether an amount belongs in a customs value can depend on the shipment and rules involved.
To format amounts, select the relevant price and total cells and use Home > Number to choose a suitable number format. Set decimal places and currency display consistently with the invoice currency. A currency symbol alone may be ambiguous for currencies that share a symbol, so state the currency code, such as USD or EUR, in a visible header field. Formatting changes how a number appears; it does not convert one currency into another.
Make the template readable and reusable
Use a plain, print-friendly layout. Bold the column headings, apply borders to distinguish the goods table, and keep labels close to their values. Avoid merged cells inside the item table because they can make sorting, editing, and copying formulas harder. A distinct invoice number and a visible currency label help prevent mix-ups when several invoices are open at once.
For larger tables, turn the item range into an Excel table using Insert > Table, and confirm that the range includes the heading row. Tables can make structured lists easier to filter and extend, but check that any formulas, print layout, and copied template behave as intended. If you use a fixed 20-row form instead, protect the formula cells only if users understand how to enter additional items or expand the form.
Before sending a copy, decide whether the recipient needs an editable workbook or a fixed document. To create a PDF in Excel for Microsoft 365 on Windows, use File > Export > Create PDF/XPS Document, then review the output. On Mac, use File > Save As and select PDF, or use the available PDF option in the print dialog. Menu wording can vary slightly by release. Check that all columns and the totals appear on the page; in Windows, Page Layout > Print Area > Set Print Area can define the portion to print. Use print preview before sharing.
Check requirements before relying on a template
There is no single Excel layout that guarantees acceptance for every international shipment. The required fields and supporting paperwork can depend on the destination, the goods, the transport provider, and the type of transaction. Controlled, restricted, or specially regulated goods may need permits or additional declarations. A destination or carrier may also specify a particular electronic submission process or form.
Check the current instructions from the carrier and the relevant customs or trade authority. Ask the buyer or importer which information they need, particularly for product classification, origin, and delivery terms. Make sure the declared description and values match the commercial records and other shipment documents. When a classification, valuation, origin, or regulatory question is uncertain, get qualified guidance rather than guessing. Excel can help present data; it cannot validate a customs declaration or establish that a shipment complies with the law.
Some invoices include a declaration that the information is true and correct, plus a name, role, date, or signature. Do not assume every shipment requires the same declaration or a handwritten signature. Include the wording and signature fields requested by the applicable procedure, and have an authorized person review the finished document.
Common spreadsheet mistakes to avoid
- Mixing currencies: Use one clearly stated invoice currency for the displayed totals, or label separate currencies explicitly. A symbol format does not perform exchange-rate conversion.
- Using vague descriptions: Identify the goods accurately enough for a reader to understand what is being shipped. Do not copy a generic description just to complete a field.
- Confusing origin with dispatch location: The country from which a parcel is sent is not automatically the product’s country of origin. Check the basis required for the transaction.
- Overwriting formulas: Keep calculated cells distinct from cells where users enter quantities or prices. Review totals after inserting, deleting, or rearranging rows.
- Leaving irrelevant sample data: Remove example products, addresses, and amounts before reuse. A copied workbook can retain old values that do not belong to the new shipment.
- Sending an unreadable printout: Check page breaks, column widths, and repeated headings when the invoice spans multiple pages. Do not shrink text until it is illegible just to force everything onto one sheet.
Excel template versus PDF or invoicing software
An Excel template is useful when shipments are occasional, the invoice structure is stable, and a person can review each document. It is flexible: users can add fields, calculate line totals, and keep shipment-specific versions. Its limitations are manual data entry, the risk of editing formulas, and the possibility that two people create different versions of the same template.
A PDF is often better for sharing a finalized invoice because its layout is less likely to shift when opened on another device. A PDF is not a substitute for the editable source record, and some shipping workflows require data entered through a carrier or customs portal instead. Dedicated invoicing, enterprise resource planning, or shipping software may be worthwhile for frequent shipments, multiple users, inventory integration, or repeated compliance checks. Those systems can reduce duplicate entry, but their output still needs review against the shipment and current requirements.
For a small number of shipments, a sensible workflow is to maintain a clean Excel master, save a separate copy for each invoice, check the data and formulas, and export the approved version to the format the recipient or carrier accepts. Keep the editable workbook and final document together with the related order and shipping records according to your business retention practices.
Frequently Asked Questions
Does Excel have a commercial invoice template?
Excel may offer invoice templates through its template options, but availability and suitability can vary. Check every field and calculation before using one for international trade; a general invoice template may omit shipment or customs information required for your case.
Can I use an Excel invoice for customs?
Sometimes, if the carrier and destination process accept the document and it contains the required information. Confirm the current requirements for the particular shipment. A spreadsheet does not replace a mandated customs form or electronic filing.
What is the difference between a commercial invoice and a pro forma invoice?
A commercial invoice generally records an actual sale and accompanies goods being shipped. A pro forma invoice is commonly a preliminary or indicative document, such as a quotation for a proposed shipment. The specific purpose and acceptable use depend on the transaction and the recipient’s requirements.
Should a commercial invoice show tax?
Do not add a tax line automatically. Whether tax applies, how it should be presented, and what belongs in a customs value depend on the transaction and relevant rules. Confirm the correct treatment with an appropriate professional or authority when unsure.
Should I send the Excel file or a PDF?
Ask the recipient or carrier what format it accepts. A PDF can preserve the approved page layout, while the workbook is useful for editing and keeping calculations. Some workflows require information to be entered in a portal rather than submitted as either file.
Related
- Can You Rename Columns in Excel? Explained
- Replace Words in Excel: Find and Replace Guide
- Randomize Numbers in Excel: Methods That Work
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Shortcut to Move Between Tabs: Windows and MacIn Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet tab, or…
- Google Sheets: How to Copy Conditional Formatting RulesYes. In Google Sheets, copy a cell or range with the conditional formatting you want, select the destination,…
- Emergency Contact List Template for Excel: Set It Up SafelyAn emergency contact list template in Excel is a worksheet with one row per person or service and…
- Conditional Formatting Text in Excel: Rules and ExamplesTo conditionally format text in Excel for Microsoft 365 on Windows, select the cells, then choose Home >…
- How to Apply Data Validation to an Entire Excel ColumnIn Excel for Microsoft 365 on Windows, select the column by clicking its letter, then choose Data >…
- Excel Power Query: Enable Background RefreshTo enable background refresh in Excel for Microsoft 365 on Windows, open Data > Queries & Connections, right-click…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.