How to Make an Invoice in Excel (With Formulas): 2026 Guide

Quick answer: To make an invoice in Excel, set up a header with your business and client details, an invoice number and dates, then build a line-item table with Description, Qty, Rate and Amount columns. Use =B12*C12 for each line amount, =SUM(D12:D21) for the subtotal, and separate cells for discount, tax and the total due. Lock the formula cells, save a master copy, and export each finished invoice to PDF before sending.

This guide gives you a complete cell-by-cell layout, every formula you need (including tax, discount, due date and balance due), a worked example and tips for keeping a spreadsheet invoice error-free. If you would rather skip the setup, our free online invoice generator already does these calculations and produces a polished PDF.

Why make an invoice in Excel?

Excel's big advantage over a word processor is that it calculates. Change a quantity and the line total, subtotal, tax and amount due all update. That makes an Excel invoice template a good fit for people who bill several line items, apply tax, or like to keep their invoice history in one workbook. The trade-off is maintenance: a single broken formula or a row inserted outside the summed range can produce a wrong total that looks perfectly believable.

Approach	Automatic maths	Setup time	Main risk
Excel template from the gallery	Yes	Low	Hidden formula assumptions
Excel invoice built from scratch	Yes	30–60 minutes once	Formula errors you introduce
Word or Google Docs	No	Low	Typed totals that don't add up
Online invoice generator	Yes	None	Few: fields are validated

The Excel invoice layout we'll build

The formulas below refer to this layout. You can move things around, but update the cell references if you do.

Cell / range	Contents
A1	INVOICE (heading)
A2:A5	Your business name, address, email, tax ID
B4	Invoice sequence number (e.g. 42)
B5	Formatted invoice number
B6	Issue date
B7	Payment terms in days (e.g. 30)
B8	Due date
A9:A10	Bill to: client name and address
A11:D11	Column headers: Description, Qty, Rate, Amount
A12:D21	Ten line-item rows
D23	Subtotal
C24 / D24	Discount rate / discount amount
C25 / D25	Tax rate / tax amount
D26	Total
D27	Amount paid
D28	Balance due

How to make an invoice in Excel: step by step

Step 1: Start a new workbook or template

Open Excel and either start a blank workbook or search the template gallery for "invoice". A gallery template saves time, but click into the total cells and read the formulas before trusting it. The rest of this guide assumes a blank sheet so you understand every cell.

Step 2: Build the header

Type INVOICE in A1 and make it large and bold. Add your business details in A2:A5. In the right-hand area, add labels for invoice number, issue date, terms and due date. Enter the client's legal name and billing address under a Bill to label.

Step 3: Generate the invoice number

Type the sequence number (for example 42) in B4, then put this formula in B5 to create a consistently formatted number:

="INV-"&TEXT(B6,"yyyy")&"-"&TEXT(B4,"0000")

With an issue date in 2026 this returns INV-2026-0042. Increase B4 by one for every new invoice and record each number in a log. Our invoice numbering system guide explains why gaps and duplicates matter, and the invoice number generator can suggest a format.

Step 4: Calculate the due date

Enter the issue date in B6 (or use =TODAY() only while drafting; replace it with a fixed date before sending, because TODAY() changes every day). Enter your terms in days in B7, then in B8 use:

=B6+B7

Format B8 as a date. For Net 30 terms, an invoice issued on 22 October 2026 is due on 21 November 2026. See invoice payment terms explained if you're unsure which terms to offer.

Step 5: Create the line-item formulas

In D12, enter a formula that multiplies quantity by rate but stays blank when the row is empty:

=IF(B12="","",B12*C12)

Copy it down to D21. The simple version, =B12*C12, works too, but it shows 0.00 on every unused row. Format columns C and D as currency or as numbers with two decimal places.

Step 6: Add subtotal, discount and tax

Use these formulas in the summary area:

• Subtotal in D23: =SUM(D12:D21) (SUM ignores the blank text values in empty rows)
• Discount rate in C24 (e.g. 5%), discount amount in D24: =ROUND(D23*C24,2)
• Tax rate in C25 (e.g. 8%), tax amount in D25: =ROUND((D23-D24)*C25,2)
• Total in D26: =D23-D24+D25

Wrapping tax and discount in ROUND keeps the displayed figures and the calculated figures identical to the cent. Whether tax applies before or after a discount, and to which items, depends on local rules. Check with your tax authority or accountant, and use our sales tax calculator to sanity-check the result.

Step 7: Track payments and balance due

If the client paid a deposit, enter it in D27 and put the balance due in D28:

=D26-D27

Make D28 bold and label it Balance due. This is the number the client should pay.

Step 8: Add payment instructions and notes

Below the totals, add your bank details or payment link, accepted payment methods, the due date restated in words, and any late-fee terms from your contract.

Step 9: Protect the formulas

Unlock only the input cells (descriptions, quantities, rates, rates in C24 and C25, dates and client details), then protect the sheet. This stops you from typing over a formula by accident. If you ever copy a rate into many formulas, use an absolute reference such as $C$25 so it doesn't shift when copied.

Step 10: Save a master and export to PDF

Save the blank version as an Excel template or as Invoice-Master.xlsx. For each new invoice, save a copy with the invoice number in the file name, set the print area to the invoice, and export to PDF. Send the PDF, never the workbook.

Worked example: Excel invoice with discount and tax

Row	Description	Qty (B)	Rate (C)	Amount (D)
12	Product photography: half-day sessions	3	450.00	1,350.00
13	Image retouching (hours)	12	85.00	1,020.00
14	Studio prop rental	1	230.00	230.00
23	Subtotal =SUM(D12:D21)			2,600.00
24	Discount 5% =ROUND(D23*C24,2)			130.00
25	Tax 8% =ROUND((D23-D24)*C25,2)			197.60
26	Total =D23-D24+D25			2,667.60
27	Amount paid (deposit)			1,000.00
28	Balance due =D26-D27			1,667.60

The 8% tax rate is illustrative only. The taxable amount here is 2,600.00 − 130.00 = 2,470.00, and 8% of that is 197.60.

Common Excel invoice mistakes

• Rows outside the SUM range. Inserting row 22 for an extra item when the subtotal sums D12:D21 silently leaves it out. Build enough rows up front, or insert rows inside the range.
• Hard-coded totals. Typing a number over a formula once breaks every future invoice made from that file.
• Floating-point pennies. Without ROUND, tax can display 197.60 but calculate as 197.6000001, which occasionally produces a one-cent mismatch.
• Forgetting to change the number and date. Duplicated invoice numbers are one of the most common invoice mistakes.
• Sending the workbook. Other tabs, client lists or notes can travel with the file.

Excel vs Google Sheets for invoices

The formulas in this guide work almost identically in Google Sheets. Sheets adds cloud saving and easy sharing, plus ARRAYFORMULA for filling a whole column at once. Our Google Sheets invoice template guide shows that version. If you are deciding between a spreadsheet and a document editor, see how to make an invoice in Word for the trade-offs.

When to move beyond an Excel invoice

Excel works well until you're sending many invoices a month, chasing several late payments, or need branded layouts for different clients. At that point a dedicated tool saves time. An invoice generator gives you the same automatic subtotal, discount, tax and amount-paid fields without formulas to maintain. Need a field-by-field refresher on what every invoice must show? Read how to write an invoice.

Create your invoice in minutes

Spreadsheets are powerful, but you don't need to build one to send a professional invoice. Open the free invoice generator, pick the structured Corporate invoice template, enter your line items and download a PDF with every total calculated for you.