"Create Proforma Invoices in Excel: Step-by-Step Guide"

Katherine Jul 11, 2026

Creating a proforma invoice in Excel can streamline your invoicing process, especially if you have recurring clients or regular services. A proforma invoice is a draft invoice sent to a client before the work is completed or the goods are delivered. It helps manage client expectations and serves as a basis for the final invoice. Here's a step-by-step guide to create a proforma invoice in Excel.

Excel Proforma Invoice Format | Download Proforma Invoice In Excel
Excel Proforma Invoice Format | Download Proforma Invoice In Excel

Before we dive into the steps, ensure you have Microsoft Excel installed on your computer. For this guide, we'll use Excel 2016, but the process is similar in other versions. Let's get started!

Proforma Invoice Requirements | Download Proforma Invoice In Excel
Proforma Invoice Requirements | Download Proforma Invoice In Excel

Setting Up Your Proforma Invoice Template

Creating a template will save you time in the long run. You can reuse this template for future proforma invoices with minimal adjustments.

How to Create a Business Invoice in Excel - Tutorial
How to Create a Business Invoice in Excel - Tutorial

First, open a new Excel workbook. Then, navigate to the 'Design' tab under 'Page Layout'. Click on 'Margins' and choose 'Narrow' to maximize the space for your invoice. You can also adjust the margins manually if you prefer.

Adding the Header and Footer

Proforma Invoice In Excel Format | Download Proforma Invoice In Excel
Proforma Invoice In Excel Format | Download Proforma Invoice In Excel

Next, add a header and footer to your invoice. Go to the 'Insert' tab, then click on 'Header' or 'Footer' in the 'Text' group. Choose one of the predefined options or design your own. Include your company's name, logo, and contact information in the header. In the footer, you can add page numbers or a disclaimer.

To make your header and footer appear on all pages, go to 'File' > 'Options' > 'Layout & Scrolling'. Under 'Scrolling', select 'Automatically adjust column width' and 'Automatically adjust row height'. This ensures that your header and footer remain visible even if you adjust the page layout.

Designing the Invoice Layout

Proforma Invoice Online Free | Download Proforma Invoice In Excel
Proforma Invoice Online Free | Download Proforma Invoice In Excel

Now, let's design the layout of your proforma invoice. In the first row, enter the following information: 'Invoice No.', 'Date', 'Due Date', and 'Bill To'. In the second row, enter the corresponding fields for each column. You can also add columns for 'PO Number', 'Terms', and 'Payment Methods' if needed.

Below the header, create a table for the invoice items. In the first row, enter the following column headers: 'Item', 'Description', 'Quantity', 'Unit Price', and 'Amount'. You can also add columns for 'Tax Code' and 'Tax Amount' if you need to calculate taxes.

Populating Your Proforma Invoice

Function Of Proforma Invoice | Download Proforma Invoice In Excel
Function Of Proforma Invoice | Download Proforma Invoice In Excel

Once your template is set up, you can start populating your proforma invoice with the relevant information.

In the 'Invoice No.' field, enter a unique invoice number. You can use a simple numbering system, such as INV-001, INV-002, and so on. Alternatively, you can use an Excel formula to generate invoice numbers automatically. For example, you can use the 'TEXT' function to convert a number into a specific format, like "INV-" followed by the number.

A Proforma Invoice Is Sent By | Download Proforma Invoice In Excel
A Proforma Invoice Is Sent By | Download Proforma Invoice In Excel
Make Proforma Invoice In Tally | Download Proforma Invoice In Excel
Make Proforma Invoice In Tally | Download Proforma Invoice In Excel
Pro Forma Invoice - Meaning, Examples, Vs Quotation, Vs Invoice
Pro Forma Invoice - Meaning, Examples, Vs Quotation, Vs Invoice
Proforma Invoice
Proforma Invoice
Proforma Invoice Template for Excel
Proforma Invoice Template for Excel
Proforma Invoice Template | Free Download | Proforma Template for Free
Proforma Invoice Template | Free Download | Proforma Template for Free
Invoice Templates for Freelancers 2025 Guide and Free Downloads
Invoice Templates for Freelancers 2025 Guide and Free Downloads
Free Excel Invoice Templates
Free Excel Invoice Templates
an invoice form is shown with the company name and number, as well as numbers
an invoice form is shown with the company name and number, as well as numbers
Proforma Invoice For Car Sale | Download Proforma Invoice In Excel
Proforma Invoice For Car Sale | Download Proforma Invoice In Excel
Sample Of Proforma Invoice Template For 2023 Business - BestTemplatess
Sample Of Proforma Invoice Template For 2023 Business - BestTemplatess
an invoice form with the words pro forma invoice on it
an invoice form with the words pro forma invoice on it
Free Proforma Invoice Template Word
Free Proforma Invoice Template Word
two invoices with the words how to create an invoice in excel
two invoices with the words how to create an invoice in excel
Proforma Invoice Number Format | Download Proforma Invoice In Excel
Proforma Invoice Number Format | Download Proforma Invoice In Excel
Proforma Invoice In Zoho Books | Download Proforma Invoice In Excel
Proforma Invoice In Zoho Books | Download Proforma Invoice In Excel
an invoice form is shown on the computer screen, and it appears to be filled
an invoice form is shown on the computer screen, and it appears to be filled
Proforma Invoice And Quotation | Download Proforma Invoice In Excel
Proforma Invoice And Quotation | Download Proforma Invoice In Excel
How to Make an Invoice: Step-by-Step Guide (& Free Templates)
How to Make an Invoice: Step-by-Step Guide (& Free Templates)
How to Create Invoice Bill in Excel & Numbers on Mac & PC
How to Create Invoice Bill in Excel & Numbers on Mac & PC

Entering Client Information

In the 'Bill To' section, enter the client's name, address, city, state, zip code, and country. You can also add the client's email address and phone number if you want to include them in the invoice.

If you have multiple addresses for the same client, you can use Excel's 'Data Validation' feature to create a dropdown list. This allows you to select the correct address from a list of predefined options. To do this, select the cell where you want to enter the address, go to the 'Data' tab, then click on 'Data Validation'. In the 'Settings' tab, choose 'List' as the 'Allow' option and enter the list of addresses in the 'Source' field.

Entering Invoice Items

Now, let's populate the invoice items table. In the 'Item' column, enter a unique item number or code for each product or service. In the 'Description' column, enter a brief description of the item. You can also add a more detailed description in a separate column if needed.

In the 'Quantity' column, enter the number of items or the quantity of the service. In the 'Unit Price' column, enter the price for each item or service. Finally, in the 'Amount' column, enter the total amount for each item or service. You can use the 'SUM' function to calculate the total amount for all items.

Customizing Your Proforma Invoice

Now that you have the basics of your proforma invoice set up, you can customize it to fit your business needs.

For example, you can add a 'Subtotal' row, a 'Tax' row, and a 'Total' row to calculate the final amount due. You can also add a 'Notes' section to include any special instructions or terms and conditions.

Adding a Logo and Background Image

To make your proforma invoice more professional, you can add your company's logo and a background image. To add a logo, insert a picture into the header or footer. To add a background image, right-click on the worksheet, select 'Page Color', then click on 'Fill'. Choose the 'Picture' or 'Texture' fill option and select the image you want to use.

You can also adjust the font, color scheme, and other design elements to match your company's branding. To do this, select the cells you want to format, then go to the 'Home' tab. Use the 'Font', 'Font Color', and other formatting options to customize the appearance of your proforma invoice.

Adding a Table of Contents

If your proforma invoice is long and contains multiple sections, you can add a table of contents to help your clients navigate the document. To do this, create a table with two columns: 'Page' and 'Section'. In the 'Section' column, enter the section headers, such as 'Introduction', 'Services', 'Payment Terms', and so on. In the 'Page' column, enter the corresponding page numbers.

To link the table of contents to the corresponding sections, select the cell in the 'Page' column, then go to the 'Insert' tab. Click on 'Hyperlink', then enter the cell reference for the corresponding section. Repeat this process for each section in the table of contents.

Creating a proforma invoice in Excel can save you time and help you maintain a consistent invoicing process. By following this guide, you can create a professional and customizable proforma invoice template that meets your business needs. Happy invoicing!