How to Draft a Performa Invoice Format in Excel, Word, and Google Docs: A Step‑by‑Step Guide
Creating a professional performa invoice is essential for any business that needs to provide a clear, accurate, and legally compliant estimate of goods or services before the final sale. Whether you’re a freelancer, a small retailer, or a large enterprise, mastering the art of drafting a performa invoice in popular tools like Excel, Word, and Google Docs can save you time, reduce errors, and enhance client confidence.
Why a Performa Invoice Matters
A performa invoice is a preliminary bill that outlines the proposed price, terms, and conditions. It is not a demand for payment but serves as a formal quotation. It helps:
- Clarify pricing and delivery details
- Prevent misunderstandings and disputes
- Provide a reference for the final invoice
- Meet regulatory requirements in many jurisdictions
Essential Elements of a Performa Invoice
- Company header and logo
- Invoice number and date
- Customer details
- Itemized list with quantities, rates, and subtotals
- Applicable taxes (GST, VAT, etc.)
- Payment terms and conditions
- Legal disclaimer and signature line
Creating a Performa Invoice in Excel
Step 1: Set Up the Header
Insert your company logo in cell A1, merge cells A1:D1, and center the text. Use Cell A2 for the title “Performa Invoice” in bold, 16‑point font.
Step 2: Define Invoice Details
In cells A3 and B3, enter “Invoice No.” and “Date” respectively. Use Cell C3 for the invoice number and D3 for the date.
Step 3: Input Customer Information
List the customer name, address, and contact details in cells A5:D7. Use bold headers for each field.
Step 4: Create the Item Table
From cell A9, set up columns: Item No., Description, Qty, Unit Price, Subtotal. Apply a light gray fill to the header row.
Step 5: Calculate Totals
Use =SUM(E10:E20) for the subtotal, then apply tax formulas: =Subtotal * 0.18 for GST. Add a grand total row.
Step 6: Add Terms & Conditions
Below the table, in cell A25, write a brief note: “This is a performa invoice and not a final bill.”
Step 7: Format for Print
Set page orientation to Landscape, adjust margins, and use Print Titles to repeat header rows on each page.
Tip: Use Templates
Download a free Excel bill template from billformat.in and customize it to fit your brand.
Creating a Performa Invoice in Word
Step 1: Start with a Blank Document
Open Word, choose “Blank Document,” and insert your company logo at the top.
Step 2: Insert a Table for the Header
Insert a 2‑column table: left column for the logo, right column for “Performa Invoice” title.
Step 3: Add Customer & Invoice Details
Use a 2‑column table below the header: left column for customer details, right column for invoice number and date.
Step 4: Create the Item Table
Insert a 5‑column table for items. Use Word’s Table Styles to apply a professional look.
Step 5: Insert Formulas
Word supports simple formulas: right‑click a cell, choose Formula, and enter SUM(ABOVE) for totals.
Step 6: Add Tax & Total Rows
Below the items, add rows for Subtotal, GST (18%), and Grand Total.
Step 7: Finalize with Terms & Signature
Include a paragraph stating “This is a provisional invoice” and add a line for the authorized signatory.
Tip: Use Word Templates
Word offers free invoice templates; customize them via billgenerate.com for a ready‑to‑use format.
Creating a Performa Invoice in Google Docs
Step 1: Start with a Blank Document
Open Google Docs, click + New, and select Blank document.
Step 2: Insert a Header
Use Insert > Header & page number to add your logo and the title.
Step 3: Build the Item Table
Insert a table with 5 columns. Use the Table Style option for a clean look.
Step 4: Use Formulas
Google Docs supports simple formulas: click a cell, choose Table > Table properties > Formula and enter SUM(ABOVE).
Step 5: Add Tax, Total, and Terms
Below the items, add rows for tax and total. End with a paragraph clarifying the provisional nature.
Tip: Use Google Docs Add‑Ons
Explore add‑ons like recurringinvoice.in for automated recurring invoicing features.
Integrating Performa Invoices with Rental Management Software
If you run a rental business, a performa invoice can be generated directly from your rental management system. Tools like RentInvoice streamline this process by auto‑filling customer details, calculating rental fees, and attaching GST calculations.
RentInvoice: A Dedicated Solution for Rental Businesses
RentInvoice is a cloud‑based platform that offers rent bill creation, rent management, and rental receipt generation. Its key features include:
- Instant pro forma billing for equipment, costumes, and vehicles
- Automatic GST and tax calculations
- Seamless integration with accounting software
- Customizable templates to match your branding
- Mobile app access for on‑the‑go invoicing
Try RentInvoice today and simplify your rental invoicing workflow.
Frequently Asked Questions
1. What is the difference between a pro forma invoice and a performa invoice?
Both terms refer to a preliminary invoice. “Pro forma” is the traditional term, while “performa” is a common variant used in many regions.
2. Do I need to register a performa invoice with tax authorities?
In most jurisdictions, a performa invoice is not a taxable document, but it must include the correct tax details for the final bill.
3. Can I create a performa invoice in Excel without formulas?
Yes, but using formulas ensures accurate totals and reduces manual errors.
4. How do I convert a performa invoice to a final invoice?
Simply replace the “performa” label with “invoice,” update the payment status, and send it to the client.
5. Is it legal to use a performa invoice for large transactions?
Yes, as long as you comply with local commercial and tax regulations.
6. Can I add a payment link to a performa invoice?
Yes, many platforms like recurringbilling.in allow you to embed payment links.
7. How often should I update my performa invoice template?
Review it annually to ensure tax rates and company details are current.
8. Can I use a performa invoice for international clients?
Absolutely. Just adjust currency and tax rules accordingly.
9. What if a client disputes the performa invoice?
Provide a clear breakdown of costs and refer to the agreed contract terms.
10. Is there a free tool to generate performa invoices?
Yes, billgenerate.com offers a free online generator.
Conclusion
Drafting a performa invoice in Excel, Word, or Google Docs is straightforward once you understand the structure and key components. By following the steps above, you can create clear, professional documents that set the stage for smooth transactions and strong client relationships. For rental businesses, leveraging platforms like RentInvoice can further automate the process, ensuring accuracy and compliance at every step.
Mobile App Resources
For on‑the‑go invoicing, explore these mobile apps: