Free Excel Invoice Template
Prefer Excel? This beats a spreadsheet invoice template: enter your items and the totals and tax calculate for you, then download a finished PDF — no formulas, no signup.
Your business
Bill to
Invoice details
Items
Tax & totals
Notes & payment
Style
Prefer a downloadable template?
Free blank templates you can fill in offline — or use the generator above for a polished PDF in seconds.
Pre-configured
This page is set up for excel invoice — adjust anything you need.
No signup
Fill it in and download a clean PDF instantly. No account, no watermark.
100% private
Runs entirely in your browser — your data and logo never leave your device.
What to include on a excel invoice
- No formulas to set up or break
- Automatic totals, tax and discounts
- Logo and brand accent
- A polished PDF instantly
- Your details saved locally
An Excel invoice is a small spreadsheet app — build it once, properly
Excel is the strongest of the DIY invoice formats because the math is native. A solid build: input cells for client and invoice details; an items range where Amount = Qty × Rate; SUBTOTAL or SUM for the subtotal; a tax cell referencing a single rate cell (not hard-coded into formulas); and a total that sums the parts. Protect the sheet, leaving only input cells unlocked, and save as a template (.xltx). For each invoice, fill, then export File → Save As → PDF with the print area set. Excel will never forget the tax or mis-add a column — but it also won’t stop you from reusing an invoice number.
Formulas worth stealing
- Amount per line: =IF(A2="","",B2*C2) — stays blank on unused rows
- Subtotal: =SUM(D2:D21) over the amounts column
- Tax: =ROUND(Subtotal*TaxRate,2), with TaxRate as a named single cell
- Total: =Subtotal+Tax−Discount+Shipping, each a visible cell
- Due date: =InvoiceDate+30 for Net 30, formatted as a date
- Sheet protection on, input cells unlocked — formulas survive the client edit-request era
The honest limits of Excel invoicing
Excel handles one invoice beautifully and a business badly: numbering is manual, client details re-enter every time (or live in a second sheet you maintain), payment status needs its own tracker, and the PDF export needs print-area discipline. If you send more than a handful of invoices a month, a purpose-built tool pays for itself in avoided friction — use Excel where it wins, as your books and ledger.
FAQ
- What should a excel invoice include?
- A free invoice generator does the same job as an Excel template without the spreadsheet fiddling — fill it in and download a clean PDF.
- How do I add tax to an Excel invoice?
- Keep the rate in its own cell (e.g. named TaxRate, holding 0.0825), then compute =ROUND(Subtotal*TaxRate,2). Never bury the rate inside formulas — when the rate changes you’ll update one cell instead of hunting through the sheet, and the invoice can display the rate it actually used.
- Can Excel generate invoice numbers automatically?
- Not safely without macros — and macro-enabled invoice files trip spam filters and IT policies. The realistic options: keep a running log sheet where the next number is =MAX(range)+1, or accept manual numbering with discipline. Purpose-built tools auto-increment; that’s one of the real reasons to graduate.
More invoice templates
- Proforma Invoice Generator
- Freelance Invoice Template
- Contractor Invoice Generator
- Construction Invoice Template
- Photography Invoice Template
- Cleaning Invoice Template
New to invoicing? Read how to make an invoice.