How-to guides
Proforma invoice template you can copy into Word or Excel
A proforma invoice tells a buyer what they will get and what it will cost before you ship or start work. Below: what it is, what goes on it, and three templates to copy.
What is a proforma invoice?
A proforma invoice looks like an invoice but is sent before the sale is complete. You write down what you intend to deliver, at what price and on which terms. The buyer agrees or asks for changes, and only then do you ship, start work or take payment.
Two things set it apart:
- It is a promise of terms, not a demand for payment. Many buyers treat it as a request to prepay, but it is not the bill that closes the deal.
- It is usually not an accounting document. In many places the final invoice is the one that goes into the books and the tax return. The proforma is a working paper. Rules differ by country, so check yours.
When do you send a proforma invoice?
- Before an advance payment. The buyer wants a document to attach to a bank transfer or to approve internally.
- For custom orders. You buy materials or start production only once the customer has agreed the details and paid something.
- For international shipments. Buyers and customs brokers often ask for a preliminary document that describes the goods and their value. What exactly is needed depends on the country, the goods and the carrier. Ask your customs broker and check the destination country's rules. None of this is customs or tax advice.
- When a quote is not enough. A quote says "this is what we could do." A proforma says "this is the exact order, ready to pay."
How is it different from a quote and a commercial invoice?
| Quote | Proforma invoice | Commercial or final invoice | |
|---|---|---|---|
| When | Before the buyer decides | After the buyer agrees, before delivery | At or after delivery |
| Purpose | Offer a price | Fix the order and terms, request prepayment | Record the completed sale |
| Binding | An offer, usually valid for a set period | Terms you expect to honor | Yes: the bill itself |
| Can change | Freely | If the order changes, issue a new version | Corrections are formal |
| Used for books and tax | No | Often no | Yes, in most places |
What should a proforma invoice include?
| Field | What to write |
|---|---|
| Title | "Proforma Invoice" in large letters. Add "This is not a tax invoice" if your market needs it. |
| Number and date | A unique number such as PF-[0001] and the issue date. |
| Validity | How long the prices hold, for example "valid until [date]". |
| Seller | Legal name, address, contact, tax or registration number, bank details. |
| Buyer | Legal name, billing address, contact person, tax number if relevant. |
| Reference | The buyer's purchase order or your quote number. |
| Line items | Description, quantity, unit price, discount, tax, line total. |
| Totals | Subtotal, shipping, tax, total, and the currency. |
| Payment terms | Advance amount or percentage, due date, accepted methods, bank details. |
| Delivery terms | Date or lead time, shipping method, who pays freight and insurance. |
| Notes | Anything that affects the price, such as the exchange rate used. |
| Signature | A name and signature line, if the buyer must confirm. |
Basic proforma invoice template (copy and paste)
Paste this into Word or Excel and replace everything in [brackets]. Rebuild the items table as a real Word or Excel table.
PROFORMA INVOICE
| Document | Fill in |
|---|---|
| Proforma No. | [PF-0001] |
| Date | [date] |
| Valid until | [date] |
| Your reference | [PO number or quote number] |
| Party | Seller | Buyer |
|---|---|---|
| Company | [Name] | [Name] |
| Address | [Address] | [Billing address] |
| Contact | [Email · phone] | [Person · email] |
| Tax number | [Number] | [If needed] |
| # | Description | Qty | Unit price | Discount | Tax | Amount |
|---|---|---|---|---|---|---|
| 1 | [Item or service] | [0] | [0.00] | [0%] | [0%] | [0.00] |
| 2 | [Item or service] | [0] | [0.00] | [0%] | [0%] | [0.00] |
| Totals | Fill in |
|---|---|
| Subtotal | [0.00] [currency] |
| Shipping | [0.00] |
| Tax | [0.00] |
| Total | [0.00] [currency] |
Payment terms: [advance of X% / full prepayment] due by [date]. Pay by [bank transfer / card / other] to: [bank name · account · SWIFT or routing number]. Please quote [PF-0001] as the payment reference.
Delivery terms: [lead time or date]. [Shipping method]. [Freight and insurance paid by seller or buyer].
This proforma invoice is a preliminary document and not a tax invoice. A final invoice will be issued [on shipment / on delivery / on completion].
Accepted by: [name] · [signature] · [date]
Variant 2: proforma for goods shipped abroad
Add this block under the buyer details. Your customs broker or carrier will say which lines they need.
| Export block | Fill in |
|---|---|
| Ship to | [name · address · country] |
| Country of origin | [country] |
| Product code or HS code | [code per line, if your broker asks for it] |
| Net / gross weight | [kg] |
| Packages | [number · type] |
| Incoterms and place | [term · named place] |
| Reason for export | [sale / sample / other] |
Variant 3: proforma for a service with a deposit
Replace delivery terms with a schedule.
| Service block | Fill in |
|---|---|
| Scope | [what is included, in two or three lines] |
| Start date | [date after deposit is received] |
| Deposit | [X% = amount] due by [date] |
| Balance | [amount] due [on completion / on date] |
| Not included | [what would be charged separately] |
How do you create a pro forma invoice step by step?
- Start from the order. Copy the items exactly from the quote or the buyer's purchase order.
- Number it. Use a separate series such as PF-0001, so it is never confused with a final invoice.
- Add both parties. Legal names and addresses, as on the final invoice.
- List items and totals in a stated currency.
- Write payment and delivery terms and a validity date.
- Send it as a PDF and ask the buyer to confirm by reply or signature.
- Keep it with the order, next to the quote.
Does Excel have a pro forma template? And what about Word?
Both Word and Excel offer invoice templates in the new-file gallery: search for "invoice". Names change between versions. Change the title to "Proforma Invoice", add the validity date and the payment and delivery terms from the table above, and you have a proforma. Or paste the template above, then build the item table with Insert → Table in Word, or type the rows into Excel and let a SUM formula add up the total.
How do you turn a proforma into the final invoice?
- Copy the line items from the proforma and update quantities to what was actually shipped or done.
- Give the invoice its own number from your invoice series, and put the proforma number in the reference line.
- Show the advance you already received as a deduction, so the "amount due" is the balance only.
- Add the tax details your country requires on a final invoice; your accountant knows them.
- Keep both documents. The signed proforma records what was agreed.
Can you do this in NeuroCRM?
NeuroCRM's built-in document templates are Quote, Invoice, Agreement and Certificate of completion. The Documents panel of a deal has a Generate document button that builds a PDF from the deal's line items and your saved company details.
To make a proforma:
- Add the items to the deal.
- In the Documents section, open the Templates tab (admins only), create the built-in templates if you have not yet, then add a new template of type Invoice. Name it "Proforma invoice" and put your own heading, validity line and terms into it. The template is HTML with placeholders for the deal, contact, company, your company details and the items. Keep the built-in Invoice template as it is; if you edit it instead, every invoice PDF generated from it will carry the proforma wording.
- Open the deal, press Generate document in its Documents panel and pick your proforma template.
- If the customer must confirm, send the PDF for an online signature: the customer draws the signature on a page opened from a link.
When the advance is due, Financials → Invoices → Create invoice on the same deal makes an invoice with a payment link. The button appears only after you connect your own payment provider (Stripe for dollar or euro invoices); until then the panel shows Set up provider. A payment that arrives another way, such as a bank transfer, is logged against that invoice with Record payment. Write the proforma number into the invoice description, since the invoice and the template PDF are created in two separate places.
The deal's line items fill every PDF you generate from a template. The payment-link invoice in Financials is filled in separately: it suggests the deal amount, so you can change it to the advance or add items there. The trial lasts 14 days with unlimited users; after that a seat is $13 per month, or $10.40 when you pay yearly (pricing). For a longer walk through quotes and invoices, read CRM with invoicing.
What NeuroCRM does not do here
- It is not bookkeeping software: the proforma PDF, the invoice and the payment sit on the deal, but there is no general ledger, so your accounts are kept in a separate tool.
- Every built-in English template prints a single list of items with one total, so a deposit line or a split between advance and balance has to be added to your own template.
- Generated documents are PDFs built from an HTML template, so editing one needs a little HTML.
- The signature is drawn on screen by the customer; do not assume it meets the signature rules of every country.
- It does not tell you what your customs office or tax authority needs on a proforma.
FAQ
What is a proforma invoice?
It is a preliminary invoice sent before delivery or completion. It states the goods or services, the price and the terms, and it is usually not the document that goes into your books.
How to create a pro forma invoice?
Copy the order into a document with your title, a proforma number, both parties, line items and totals, payment terms, delivery terms and a validity date. Save it as PDF and send it for confirmation.
Does Excel have a pro forma template?
Excel offers invoice templates in its new-file gallery, and you can turn one into a proforma by changing the title and adding validity, payment and delivery terms. Template names differ by version, so search for "invoice".
What is the format of a proforma invoice in Word?
There is no fixed format. Use a title, number and date, seller and buyer blocks, an item table, totals, payment and delivery terms, and a note that it is not a final invoice.
Is a proforma invoice a legal requirement?
It depends on the country and on what you ship. For cross-border shipments ask your customs broker, and ask your accountant about domestic tax treatment.
How this article was made: written by the NeuroCRM team with AI assistance; product claims were checked against NeuroCRM code and help docs; prices are from the published pricing as of the update date.