Anniversary Sale: pay once, use Taskip forever, save up to 70%.Anniversary Sale: 70% off LTD.
Claim OfferExcel 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 on G2 · Our invoice generator is used by 50,000+ people · Updated September 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) |
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 & Reminder Emails
Emails to send invoices and chase late payments.
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.
