Invoice Generator 365
English

Free Excel Invoice Template With Built-in Formulas

This Excel invoice template gives you a ready invoice sheet where line totals, subtotal, sales tax and the amount due calculate themselves. Download the blank .xlsx file on this page, fill in your details, and save it as a PDF before you send it. If you would rather skip the spreadsheet, the generator builds the same invoice as a PDF in your browser.

Create your invoice nowDownload Excel templateFree, no sign-up, PDF in a minute

What your Excel invoice should contain

  1. 1Your business name, address, phone or email
  2. 2Customer name and billing address
  3. 3A unique invoice number, such as INV-2026-0147
  4. 4Invoice date in MM/DD/YYYY format and a due date
  5. 5Description, quantity, unit price and line total for each item
  6. 6Subtotal before tax
  7. 7Sales tax rate and amount, stated separately, if you collect tax
  8. 8Total amount due in USD
  9. 9Payment terms, such as Net 30, and how to pay (bank transfer, check, card link)
  10. 10Optional: your EIN (written 12-3456789) and state sales tax permit number

Filled example: a furniture supplier invoicing a café in Indiana

Invoice

From
Cardinal Bench Supply, Indianapolis, IN
To
Maple Row Café LLC, Carmel, IN
InvoiceQtyUnit priceTaxAmount
Solid oak café table, 30 in round4 pcs$285.007 %$1,140.00
Bistro chair, black steel frame16 pcs$94.507 %$1,512.00
Felt floor glides, pack of 164 packs$12.757 %$51.00
Net
$2,703.00
Tax 7 %
$189.21
Total
$2,892.21

How the Excel invoice template calculates

The sheet has one row per item. You type the description, quantity and unit price, and Excel does the arithmetic. These are the formulas behind the cells, so you can check them or rebuild them in your own file.

CellFormulaWhat it does
Line total (E12)=ROUND(C12*D12,2)Quantity times unit price, rounded to the cent
Subtotal=SUM(E12:E26)Adds all line totals
Taxable amount=SUMIF(F12:F26,"Y",E12:E26)Adds only rows marked Y in the Taxable column
Sales tax=ROUND(Taxable amount*Tax rate,2)Applies your combined rate once, to the taxable part
Total due=Subtotal+Sales taxThe amount your customer pays

Enter the tax rate as a percentage cell (7%, not 7). Format money cells as Currency with two decimals so the printed amounts match what Excel actually adds up.

Filling in the invoice template in Excel, step by step

  1. Save a copy of the blank file first and keep the original untouched, so every new invoice starts clean.
  2. Put your business details and logo in the header once, then save that version as your own master file.
  3. Give each invoice the next number in your series and write it into the file name too, for example INV-2026-0147.xlsx.
  4. Add the customer, the dates and the items. Mark each row as taxable or not.
  5. Type the combined state and local rate for the place of delivery, only if you are registered to collect tax there.
  6. Use File, Save As or Export, and choose PDF. Send the PDF, not the .xlsx, so nobody can change the figures.

Sales tax on an Excel invoice in the US

There is no federal VAT. Sales tax is set by the states and, in many of them, by counties and cities as well. Alaska, Delaware, Montana, New Hampshire and Oregon have no statewide sales tax, and among those only Alaska allows local sales tax. State rates run from 2.9% in Colorado to 7.25% in California, and some combined rates pass 10%.

You charge sales tax only where you are registered and the item is taxable. Goods are usually taxable. Most professional services, such as consulting or accounting, usually are not, although some states tax certain services. In the example above, Indiana has a single 7% state rate and no local sales tax, so one rate fits every row.

California, when your prices already include sales tax instead of listing it separately
The price of this item includes sales tax reimbursement computed to the nearest cent.

Excel file or online generator

Common mistakes with Excel invoices

Create your invoice nowDownload Excel templateFree, no sign-up, PDF in a minute

Questions and answers

Does Excel have a built-in invoice template?

Excel offers invoice designs under File, New when you search for invoice, but they vary in quality and often lack a separate taxable column. The template on this page is set up for US sales tax with the formulas already in place.

Is an invoice made in Excel legally valid?

Yes. No federal law prescribes a special invoice format for private sales, so an Excel invoice saved as a PDF is valid as long as it shows the usual details: seller, buyer, number, date, items, tax and total.

How do I number invoices automatically in an invoice template in Excel?

Excel cannot remember the last number across separate files without macros. Most people keep a simple log sheet with one row per invoice, or use the generator, which numbers invoices consecutively.

Should I send the invoice as .xlsx or PDF?

Send a PDF. It looks the same on every device, prints correctly, and the customer cannot change the figures.

Do I have to show my EIN on the invoice?

It is not required on a normal invoice. Business customers often ask for your tax ID on a Form W-9 instead, so you can leave it off the invoice unless a customer asks for it.

How long should I keep my invoices?

The IRS generally asks you to keep records for 3 years, and employment tax records for at least 4 years. State sales tax rules can require longer, so many businesses keep invoices for 7 years.

Related templates

Sources

Sales tax rules depend on your state, what you sell and your registrations, so check your own case with your state tax agency or an accountant.