Free template · Invoicing
Proforma invoice format (free Excel download)
One Excel file with a domestic proforma invoice sheet and an export proforma invoice sheet. Fill in the buyer, items, rate and GST, and the amounts and totals are calculated for you.
- Free, no sign-up
- Domestic and export sheets
- Excel, Google Sheets & LibreOffice
Template preview
- Buyer
- Sample Customer Pvt Ltd, Pune · Payment: 100% advance
| Description | HSN | Qty | Rate | Amount | GST 18% |
|---|---|---|---|---|---|
| MS bracket 40 mm | 7326 | 100 | 120 | 12,000 | 2,160 |
| Total | 100 | 12,000 | 2,160 |
Preview with sample data
What it includes
- A domestic sheet and an export sheet in one file
- Proforma number, date and validity date
- Seller and buyer details with GSTIN
- Items with HSN or HS code, quantity and rate
- GST amount and total calculated automatically on the domestic sheet
- Currency, Incoterm and port fields on the export sheet
- Payment terms, bank details and a signature line
How to use it
- Pick the domestic or export sheet and add your details and the buyer's.
- List the items with quantity, rate and GST percentage, and set the payment terms and validity.
- Check the total, print or save as PDF, sign it and send it to the buyer.
What is a proforma invoice?
A proforma invoice is a bill you send before the sale is complete. It tells the buyer what you plan to supply, in what quantity, at what price and on what terms. The buyer can check it, approve the order and, if needed, pay an advance or arrange a bank or import permit. When the goods are dispatched or the service is done, you replace it with a proper tax invoice.
That last point matters. A proforma invoice is a preliminary document, not a demand for GST and not a record of a completed supply. This free proforma invoice format in Excel has one sheet for domestic sales and one for export, and works in Excel, Google Sheets and LibreOffice. You can also copy the table into Word if your team prefers that.
When do you need a proforma invoice?
- Advance payment: the buyer will pay only after seeing a formal document with the total amount.
- Custom or made-to-order goods: you want the price and specifications agreed in writing before you start.
- Approvals at the buyer's end: purchase teams often need a document to raise an internal purchase order or release funds.
- Exports: overseas buyers commonly ask for one to arrange payment, a letter of credit or an import permit before the goods ship.
- Samples and goods sent on approval: a proforma can describe the goods and their value when no sale has happened yet.
Proforma invoice vs tax invoice vs quotation
The three documents are often mixed up, so here is the simple difference:
- A quotation is an offer of price. The buyer has not yet agreed to buy. See our quotation format.
- A proforma invoice is a firm-looking bill issued ahead of supply, usually after the buyer shows interest or places an order.
- A tax invoice is issued for the actual supply. It is the document that carries the tax and the one a registered buyer uses to claim input tax credit. See our GST invoice format.
A proforma invoice does not replace the tax invoice. Mark it clearly as “proforma invoice” and, as a good habit, add a line such as “This is not a tax invoice”. Because it is not a tax invoice, buyers generally cannot claim input tax credit on it. Check the current GST rules with your chartered accountant.
What a proforma invoice format should contain
- The words “proforma invoice”, clearly shown at the top.
- A number in your own running series, the date and a validity date.
- Name, address and GSTIN of the seller.
- Name, address and GSTIN of the buyer (or country and tax ID for an export).
- A clear description of each item, with HSN or SAC code, quantity, unit and rate.
- The taxable amount, the GST rate and amount (domestic), and the total.
- Payment terms, such as advance percentage and due date, and your bank details.
- Delivery terms, and a signature or stamp from the authorised person.
Export proforma invoice format
An export proforma invoice carries a few extra details that overseas buyers and their banks look for:
- The currency of the price, such as US dollars, and the unit price in that currency.
- The Incoterm agreed with the buyer, such as FOB or CIF, which says who pays freight and insurance.
- The port of loading and port of discharge or final destination.
- The HS code of the goods and the country of origin.
- Your IEC and your bank's SWIFT code so the buyer can send payment.
How GST applies to an export, for example under a Letter of Undertaking or on payment of IGST, and which documents a particular bank or country asks for, depends on the case. Confirm the details with your CA or freight forwarder before you send the document.
Tips for using proforma invoices without confusion
- Number proformas in a series separate from your tax invoices, so the two never get mixed up.
- Always set a validity date. Prices change, and the date protects you.
- When the goods go out, issue the tax invoice and write the proforma number on it, so your records link up. Send a delivery challan if the goods move before the final invoice.
- Record any advance you receive against the proforma, and adjust it on the final invoice.
- If the order changes, issue a new proforma rather than editing an old one that the buyer has already approved.
- If you have to correct a tax invoice later, use a credit note or debit note.
Stop retyping the same document
A spreadsheet works when you send a few proformas a month. As orders grow, retyping party names, GSTINs and item details slows you down and invites mistakes. Mera Udyog keeps GST invoices, stock and customer records in one app, so you raise the bill from the same place you manage the order. See GST billing software and inventory management software for how it works.
This template is a general format and not legal or tax advice. Rules change, so verify the current requirements with a professional or the latest GST notifications.
Questions
Good to know
What is a proforma invoice?
A proforma invoice is a preliminary bill a seller sends before goods are supplied or services are done. It lists what will be sold, the quantity, the price and the terms, so the buyer can approve the order, arrange payment or clear paperwork. It is not a tax invoice.
Is a proforma invoice the same as a tax invoice?
No. A tax invoice is the document issued for an actual supply and is the one the buyer uses to claim input tax credit. A proforma invoice is an offer or advance request. It is normally replaced by a tax invoice once the goods are dispatched or the service is delivered.
Can I claim GST input tax credit on a proforma invoice?
Generally no. Input tax credit is claimed on a valid tax invoice, not on a proforma invoice. Confirm the current conditions with your chartered accountant or the latest GST notifications.
What should a proforma invoice contain?
The words proforma invoice, a number and date, seller and buyer details with GSTIN where applicable, a description of goods or services with HSN or SAC code, quantity, rate, tax and total, payment terms, validity date and bank details. For exports, add the currency, Incoterm, ports and HS codes.
What is a proforma invoice used for in exports?
Overseas buyers often ask for one to arrange a letter of credit, bank transfer or import permit before shipping. It states the goods, price, currency, Incoterm and payment terms. Check the exact documents your buyer's bank and customs authority require.
Can I get this proforma invoice format in Excel and PDF?
The download is an Excel file with a domestic sheet and an export sheet. Open it in Excel, Google Sheets or LibreOffice, fill it in and use Print to save it as PDF. To use it in Word, copy the table across.
Done with paperwork?
Mera Udyog handles attendance, salary, quotations, invoices and HR records for you. Try it free for 7 days.
7-day free trial · No credit card needed