Excel invoice templates that do the math for you: line amounts, subtotal, discount, tax and balance due calculate as you type. They also work in Google Sheets and Numbers.
4.8/5 · 6 reviews on G2 · Our invoice generator is used by 50,000+ people · Updated October 2026What is an invoice template for Excel?
An invoice template for Excel is a spreadsheet invoice with the layout and formulas already built in, so totals, tax and the balance due calculate automatically as you fill in your line items.
Excel is the best format when your invoices have many lines, hours or tax rates. You fill in the yellow input cells, and the grey formula cells work out each line, the subtotal, discount, tax and balance due. The hourly template also totals your hours, the tax invoice template summarises tax by rate, and the GST template switches between CGST + SGST and IGST.
Every template below is an .xlsx file with working formulas. Prefer to edit the layout freely? Get the same designs as Word invoice templates.
Any business billing for products or services. The invoice format most clients expect.
A clean one-page invoice with just the essentials, for quick jobs and small businesses.
Consultants, agencies and service providers billing for sessions, retainers or projects.
Freelancers billing a project, with the quote reference and deposit already paid.
Anyone billing by the hour: a timesheet and an invoice in one.
Requesting an advance payment, or sending buyers and customs a preview before shipping.
VAT or GST registered businesses that need a compliant tax invoice (UK, EU, Australia, Singapore and more).
GST-registered businesses in India issuing a tax invoice under the GST rules.
Download the .xlsx, open it, and save a copy named after the invoice, for example INV-0042-Acme.xlsx.
Your business details, the client, invoice number, dates and currency.
Description, quantity and unit price on each row. The amount appears automatically.
Type the discount and tax percentages. Tax is calculated after the discount.
Enter a deposit or amount paid, and the balance due updates.
Nothing hidden: these are the formulas the templates use, so you can check or extend them.
| Cell | What it does | Example formula |
|---|---|---|
| Line amount | Quantity x unit price, blank if the row is empty | =IF(OR(C15="",E15=""),"",C15*E15) |
| Subtotal | Adds up every line amount | =SUM(F15:F29) |
| Discount | Subtotal x discount % | =F31*F32 |
| Tax | Tax % applied after the discount | =(F31-F33)*F34 |
| Total | Subtotal minus discount, plus tax | =(F31-F33)+F35 |
| Balance due | Total minus amount paid | =F36-F37 |
| Tax by rate (tax invoice) | Adds net amounts that share a rate | =SUMIF($D$15:$D$28,D32,$E$15:$E$28) |
| CGST (GST India) | Half the GST rate when the supply is intra-state | =IF($K$5="Intra-state",F14*G14/2,0) |
Excel works well for a handful of invoices a month. Once you are chasing payments, the gaps show.
| Excel template | Invoicing software (Taskip) | |
|---|---|---|
| Cost | Free | Free plan, paid plans from $12/month |
| Invoice numbering | Manual, easy to duplicate | Automatic and sequential |
| Online payment | Not built in | Clients pay by card or bank online |
| Payment reminders | You send them yourself | Automatic reminders |
| Recurring invoices | Copy and edit each month | Scheduled automatically |
Prefer a Word layout instead? See the Word invoice templates.
All Invoice Templates
Every invoice template in Word, Excel and PDF, plus a filled sample.
Free Invoice Generator
Skip the file: create and download an invoice online.
Invoice Payment Terms
Net 30, 2/10 Net 30 and late fee wording to copy.
Tax Invoice Format
VAT, GST and sales tax invoice rules by country.
Invoice Format Guide
What every invoice must show, with USD and GST samples.
Taskip Invoicing
Online payments, recurring invoices and payment tracking.
Download an Excel invoice template, fill in the yellow cells with your details, the client and each line item, set the tax and discount, and export it as a PDF to send.
Yes. Enter the tax rate and it is applied to the subtotal after any discount. The tax invoice template also handles several tax rates on one invoice.
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets; the formulas keep working.
Type the next number in your sequence in the invoice number cell, and keep a log of numbers used. Never reuse a number. The free invoice generator does this automatically.
Unlock the yellow input cells, then protect the sheet with Review > Protect Sheet. Only the input cells stay editable.
Yes. Free for business use, no signup, no watermark.
Yes. Excel ships with a few invoice templates under File > New, and the free .xlsx templates on this page add ready-made formulas for line totals, discount, tax and balance due, plus versions for services, hours and tax invoices.
Multiply quantity by rate in each line (=B5*C5), add the lines with =SUM(), apply discount and tax as a percentage of the subtotal, and subtract any amount paid to get the balance due. The templates here already contain these formulas, so you only fill in the yellow input cells.
