How to Create an Invoice in Excel (2026) — Free Template & Guide

Excel is a popular choice for invoicing because most people already have it. With the right setup, you can create a reusable invoice template with automatic calculations. This guide walks you through exactly how to do it.

Step-by-step: Create an invoice in Excel

Step 1: Set up your header

Open a new Excel worksheet. In the top section, add your business name, address, phone, and email. Reserve a cell for your logo (Insert → Pictures). On the right side, add fields for Invoice Number, Invoice Date, and Due Date.

Step 2: Add a 'Bill To' section

Below the header, create a 'Bill To' section with fields for your client's name, company, address, and email.

Step 3: Build the line items table

Create a table with these columns: Description, Quantity, Unit Price, Amount. Format the Amount column to multiply Quantity × Unit Price automatically.

• Select your first Amount cell (e.g. D10)
• Enter the formula: =B10*C10
• Copy this formula down for as many rows as you need

Step 4: Add subtotal, tax, and total formulas

Below the items table, add these calculations:

• Subtotal: =SUM(D10:D25) — adjust the range to match your rows
• Tax (e.g. 10% GST): =Subtotal_Cell*0.10
• Total: =Subtotal_Cell+Tax_Cell

Step 5: Add payment details and notes

Below the totals, add a section for payment instructions (bank name, account number, BSB/routing number, PayPal, etc.) and any notes or payment terms.

Step 6: Format and save as a template

Apply your colour scheme, adjust column widths, and set the print area to fit one A4 page (Page Layout → Print Area → Set Print Area). Save as an Excel Template (.xltx) so each new invoice starts from a clean copy.

Excel invoice limitations

Excel works, but it has real drawbacks for invoicing:

• Formatting breaks easily when you add or remove rows
• Getting it to print neatly on exactly one A4 page requires careful margin and scaling setup
• No mobile support — editing on a phone is difficult
• Easy to accidentally overwrite a formula and get wrong totals
• You need Excel installed (it's not free for everyone)

A faster alternative: browser-based invoice generator

If you want a professional PDF invoice without the Excel setup, a browser-based invoice generator takes less than 60 seconds:

1. 1Go to pdfbillbuilder.com
2. 2Fill in your details — the totals calculate automatically
3. 3Click Download PDF
4. 4Done — a clean, professional invoice ready to send

It works on any device, never misaligns, always fits one A4 page, and requires no software at all.

When to use Excel vs an online invoice generator

• Use Excel if: you need complex custom calculations, you already have an elaborate spreadsheet workflow, or you need to integrate invoicing with other financial models
• Use an online generator if: you just need clean, professional PDF invoices quickly with no setup time