Free Proforma Invoice Template (Excel, PDF & Online Format Generator)

By Alex Miller, Lead Product Engineer at TalkInvoice AI — Architect of the TalkInvoice AI mobile billing engine (iOS & Android v1.0.15), specializing in neural voice-to-entity extraction and small-business payment workflows.

Need a free proforma invoice template in Excel, Word, or a print-ready PDF right now? Use our interactive calculator below (or open our dedicated full-screen Proforma Invoice Generator at /talkinvoice-ai/proforma-invoice-generator) to select a B2B Services, Customs Export, or Contractor Deposit preset, customize your line items with live tax and freight calculations, and download an Excel (.xlsx) workbook with locked formulas, Word (.docx), or PDF in one click.

Format of a Proforma Invoice: The 7 Required Layout Zones

The format of a proforma invoice closely mirrors a standard commercial invoice so that corporate procurement teams, banks, and customs officials can verify every cost component before the transaction is finalized. However, a proper proforma invoice format must include specific validity and non-tax disclaimers so it is never confused with a final VAT/GST demand.

Every professional proforma invoice template is organized into seven structured layout zones:

Zone 1 — Document Header & Proforma Reference: Prominently display 'PROFORMA INVOICE' in bold typography at the top right, paired with a dedicated proforma reference ID (e.g., PI-2026-104) rather than your final invoice ledger number.
Zone 2 — Issue Date, Expiration Date & PO Reference: Unlike a final invoice that displays a payment due date, a proforma format states an 'Expiration / Valid Until Date' (typically 14 or 30 days from issue) alongside the buyer's Purchase Order (PO) number.
Zone 3 — Supplier (Exporter) & Buyer (Consignee) Blocks: Full legal company names, street addresses, contact emails, and tax/customs identifiers (EIN, VAT ID, EORI number, or GSTIN).
Zone 4 — Commercial & Customs Metadata Bar (For Goods): Currency code (USD, EUR, GBP, CAD), Incoterms 2020 (e.g., EXW, FOB, CIF, CIP, DDP), Country of Origin, and Net/Gross weight.
Zone 5 — Itemized Line-Item Table: Separate columns for Item #, Description (plus 6-to-10 digit HS Tariff Code for exports), Quantity, Unit Price, and Line Total.
Zone 6 — Financial Calculation Summary: Right-aligned rows for Net Subtotal, Discount (if applicable), Estimated Tax / VAT %, Freight / Shipping / Insurance, and Total Proforma Amount.
Zone 7 — Pre-Payment Instructions & Non-Tax Declaration: Bank wire coordinates (IBAN/SWIFT/Routing) or payment instructions, plus the mandatory declaration: 'This Proforma Invoice is for preliminary approval, prepayment, or customs valuation only and is not a final tax invoice.'

Format of a proforma invoice diagram showing the 7 layout zones for Excel and PDF templates — Visual blueprint of a standard Proforma Invoice format showing header metadata, seller/buyer blocks, line-item math, and validity terms.

Proforma Invoice Format in Excel: Cell-by-Cell Formula Blueprint

If you are building or customizing a format for proforma invoice in Excel (or Google Sheets), using dynamic cell formulas prevents embarrassing addition errors when updating quantities or tax rates. When you click 'Download Excel' in our calculator above, the file pre-populates these exact spreadsheet formulas for you.

Here is the standard cell-by-cell structure for a clean Excel proforma invoice sheet:

Excel Row / Cell Range	Field Label in Template	Recommended Excel Formula / Content
Cells A1:E2	Document Title Header	PROFORMA INVOICE (Bold 18pt, merged header banner)
Cells B4 & B5	Issue Date & Valid Until Date	B4: `2026-11-02` \| B5: `=B4+14` (Automatically adds 14 validity days)
Row 11 (A11:E11)	Table Column Headers	`Item #` \| `Description / HS Code` \| `Qty` \| `Unit Price` \| `Line Total`
Rows 12–16 (Col E)	Line Item Subtotal Formula	In Cell E12: `=C12*D12` (Multiplies Quantity × Unit Price; fill down to E16)
Cell E18	Subtotal (Net)	`=SUM(E12:E16)` (Sums all individual line totals automatically)
Cell E19	Estimated Tax / VAT Amount	`=(E18-E20)*0.08` (Calculates 8% tax on net subtotal after discount)
Cell E21	Total Proforma Amount	`=E18-E20+E19+E22` (Subtotal − Discount + Tax + Freight/Shipping)

3 Proforma Invoice Template Formats: Which One Do You Need?

Not every business needs customs tariff codes on their proforma bill. Choosing the right template format keeps your document concise and easy for the buyer to approve:

1. Standard B2B Service & Consulting Proforma Template: Designed for software agencies, consultants, architects, and freelancers collecting an upfront retainer or waiting on corporate Purchase Order approval. Focuses on clear deliverable descriptions, hourly or flat rates, validity dates, and bank/card payment instructions.
2. Commercial Export & Customs Proforma Template: Designed for cross-border shipments of physical goods. Adds dedicated fields for Harmonized System (HS) tariff codes, Country of Origin, Incoterms 2020 (FOB, CIF, CIP, DDP), freight/insurance breakdown, net/gross weight in kg, and package dimensions.
3. Contractor Deposit & Equipment Pre-Order Template: Designed for HVAC, electrical, plumbing, and construction contractors who require upfront funds to order specialized materials before mobilization. Clearly separates equipment pre-order costs from site mobilization labor.

Excel Proforma Templates vs. Mobile Voice Quoting (TalkInvoice AI)

Desktop Excel templates are great when you are sitting at an office desk, but they become a bottleneck when you need to send a proforma quote from a job site, trade show floor, or client meeting—and when the client approves, you have to copy-paste every row into a separate final invoice file.

Workflow Step	Excel / Word Proforma Template	TalkInvoice AI Mobile App (iOS & Android)
Creating the Proforma	3–6 minutes typing cells & checking formulas on laptop	10 seconds by speaking client, items, tax & validity into your phone
Converting to Final Tax Invoice	Manual copy-paste into a new invoice spreadsheet	1-Tap 'Convert to Invoice' with automatic sequential numbering
Collecting Upfront Payment	Client must manually type your IBAN / bank details	Embedded Stripe & PayPal QR code right on the PDF
Tracking Expiring Quotes	Manual checking of saved spreadsheet folders	Real-time status tracking for Draft, Sent, Approved & Converted quotes

Frequently Asked Questions

How do I create a proforma invoice format in Excel?

You can download a ready-to-use Excel proforma invoice with pre-built formulas instantly using the 'Download Excel (.CSV with Formulas)' button at the top of this page. It includes structured columns for Item Description, Quantity, Unit Price, dynamic `=C*D` line totals, `=SUM()` subtotal, tax calculation, freight, and validity terms.

Should I send a proforma invoice in Excel or PDF format?

You can build and edit your numbers in Excel or in our live calculator, but you should always send the final document to your client as a locked PDF. A PDF preserves your exact layout on phones and desktops and prevents accidental modification of unit prices or bank wire details.

What is the difference between a proforma invoice template and a regular invoice template?

A proforma invoice template is titled 'PROFORMA INVOICE', uses a preliminary reference code (like PI-2026-104), includes an expiration/validity date instead of a final accounting due date, and carries a footer disclaimer stating that it is not a final tax invoice.

Does a customs proforma invoice template require HS codes and Incoterms?

Yes. When shipping commercial samples, replacement parts, or export orders internationally, customs authorities use the proforma invoice to assess duties and clearance. Including the 6-to-10 digit HS code, Country of Origin, Net/Gross weight, and Incoterms 2020 prevents customs holds.

Official Documentation & Tax References

U.S. International Trade Administration: Pro Forma Invoices & Export Documentation (U.S. Department of Commerce (Trade.gov))
GOV.UK: Invoices — What They Must Include (UK Government (GOV.UK / HMRC))