Invoice template for Excel
An Excel invoice template is a spreadsheet with formulas that multiply quantity by rate for each line, add a subtotal, apply sales tax and show the total due. You type the items and Excel does the math.
What formulas does an Excel invoice need?
A handful of formulas cover almost every invoice. The table assumes quantity in column C, rate in column D and line totals in column E, with items in rows 12 to 21.
Copy the line total formula down every item row. Format the money columns as Currency so they show two decimal places, and wrap the tax formula in ROUND, such as =ROUND((E22-E23)*D24,2), so tax is rounded to the cent before it is added to the total.
| Cell | What it shows | Formula |
|---|---|---|
| E12 | Line total for row 12 | =C12*D12 |
| E22 | Subtotal | =SUM(E12:E21) |
| E23 | Discount, with the percent in D23 | =E22*D23 |
| E24 | Sales tax, with the rate in D24 | =(E22-E23)*D24 |
| E25 | Total | =E22-E23+E24 |
| E27 | Balance due after a deposit entered in E26 | =E25-E26 |
How do I keep the formulas from breaking?
Lock the formula cells so a stray keystroke doesn't overwrite them. Select the cells you type into, open Format Cells, clear the Locked box on the Protection tab, then turn on Review, Protect Sheet. Now only the input cells can change.
Save a copy of the file for each new invoice instead of overwriting the last one, and name it with the invoice number. Before you send, use File, Save As or Export and choose PDF, and check that the print area fits on one page.
Is Excel better than an online invoice generator?
Excel is a good fit if you already live in spreadsheets, want custom columns, or like keeping a log of every invoice in one workbook. The tradeoff is upkeep: formulas can break, and you still send, track and follow up on every invoice yourself. The free generator does the math and creates the PDF with nothing to maintain.
If you outgrow both, a free Invoicefy account saves clients and reusable items, emails invoices with automatic reminders, and exports invoices, clients and payments to CSV files that open in Excel.
| Excel template | Online generator | |
|---|---|---|
| Cost | Free template; needs Excel or a compatible app | Free in the browser |
| Math | Formulas you maintain | Calculated for you |
| Custom columns | Add anything you want | Standard invoice fields |
| Tracking many invoices | Possible with a log sheet | One invoice at a time |
| Getting a PDF | Export to PDF yourself | Download a PDF |
Questions people ask
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. Simple formulas like SUM, multiplication and ROUND work the same way.
Add a Taxable column with Y or N for each line, then total the taxable lines with SUMIF, for example =SUMIF(F12:F21,"Y",E12:E21), and multiply that by the tax rate. Check which items your state taxes.
Excel keeps every decimal behind the value it displays. If tax is shown rounded but added unrounded, the total can be a cent off. Wrap the tax formula in ROUND to two decimals.
Not across separate files on its own. Many people keep a log sheet in one workbook with each invoice number, client, date and amount, and take the next number from it. See Invoice Numbering: How to Number Invoices (With Examples).
No, send a PDF. A spreadsheet can be edited, can expose your formulas and may not open well on a phone. Keep the .xlsx for yourself.
Skip the template next time.
Save your clients and items in a free Invoicefy account, send a link by email or text, and let reminders follow up.
