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.
What your Excel invoice should contain
- 1Your business name, address, phone or email
- 2Customer name and billing address
- 3A unique invoice number, such as INV-2026-0147
- 4Invoice date in MM/DD/YYYY format and a due date
- 5Description, quantity, unit price and line total for each item
- 6Subtotal before tax
- 7Sales tax rate and amount, stated separately, if you collect tax
- 8Total amount due in USD
- 9Payment terms, such as Net 30, and how to pay (bank transfer, check, card link)
- 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
| Invoice | Qty | Unit price | Tax | Amount |
|---|---|---|---|---|
| Solid oak café table, 30 in round | 4 pcs | $285.00 | 7 % | $1,140.00 |
| Bistro chair, black steel frame | 16 pcs | $94.50 | 7 % | $1,512.00 |
| Felt floor glides, pack of 16 | 4 packs | $12.75 | 7 % | $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.
| Cell | Formula | What 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 tax | The 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
- Save a copy of the blank file first and keep the original untouched, so every new invoice starts clean.
- Put your business details and logo in the header once, then save that version as your own master file.
- Give each invoice the next number in your series and write it into the file name too, for example INV-2026-0147.xlsx.
- Add the customer, the dates and the items. Mark each row as taxable or not.
- Type the combined state and local rate for the place of delivery, only if you are registered to collect tax there.
- 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.
The price of this item includes sales tax reimbursement computed to the nearest cent.
Excel file or online generator
- Excel suits you if you already keep your records in spreadsheets and want to adjust columns, add a Taxable flag or a discount row yourself.
- The generator suits you if you want numbering, several tax rates on one invoice, discounts, a paid deposit and a clean PDF without touching formulas.
- Both give you a PDF invoice, which is fully valid for US business and consumer customers because there is no e-invoicing mandate for private sales.
- The generator runs in your browser, needs no sign-up, adds no watermark and keeps your data on your device.
Common mistakes with Excel invoices
- Copying last month's file and forgetting to change the invoice number leaves two invoices with the same number and confuses your customer's payables team.
- Typing over a formula cell with a fixed amount means the total no longer changes when you edit a line, and the invoice shows the wrong amount due.
- Calculating tax on every row without rounding can leave the total one cent off from the sum of the printed figures.
- Charging sales tax on a service your state does not tax, or in a state where you are not registered, collects money you are not allowed to collect.
- Sending the editable .xlsx instead of a PDF lets anyone change the amounts and may show hidden columns or notes.
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
- How long should I keep records?, Internal Revenue Service
- Applying Tax to Your Sales and Purchases, California Department of Tax and Fee Administration
- Taxable Services, Texas Comptroller of Public Accounts
- State and Local Sales Tax Rates, 2026, Tax Foundation
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.
