Free Excel invoice template with the formulas done
This free Excel invoice template does the arithmetic for you: line amounts, subtotal, tax, and total all come from four short formulas listed below. The CSV download opens directly in Excel with the columns already named, and everything on this page is free with no email required. Set it up once, save it as .xlsx, and reuse it forever.
What goes on a excel invoice
| Field | What goes there |
|---|---|
| Business identity block | Rows 1 to 3 of the sheet: name, email, phone. Merged cells look nice but complicate sorting, so plain left aligned text works better. |
| Client and job reference | Client name, address, and any PO number in rows 5 to 7, above the table where imports and prints expect them. |
| Invoice number | Use a year prefix like 2026-031. Excel will happily autofill 2026-032 down a log sheet when you track invoices in one workbook. |
| Issue and due dates | Enter real dates and Excel can compute one from the other: with the issue date in B8, =B8+30 in the due date cell gives you Net 30 automatically. |
| Line item rows | Rows 10 through 17 in the layout below. Keep them contiguous so the SUM range never misses a row. |
| Amount column formula | =B10*C10 in the first amount cell, then drag the fill handle down. Quantity times rate, no mental math. |
| Subtotal cell | =SUM(D10:D17), placed directly under the amount column. |
| Tax rate and tax amount | Keep the rate in its own cell, for example 8.25% in C19, and compute =D18*C19. When the rate changes you edit one cell, not a formula. |
| Total due | =D18+D19, bold, currency formatted. This is the number the client pays. |
| Payment details | Bank info or a payment link in the last rows. Text, not formulas, so nothing breaks when copied. |
The line-item table
| Description | Qty | Rate | Amount |
|---|---|---|---|
| Social media management, April | 1 | $650.00 | $650.00 |
| Blog posts, 1,200 words each | 4 | $150.00 | $600.00 |
| Email newsletter setup | 1 | $275.00 | $275.00 |
How to use this template
- Open the CSV. Download the CSV below and double click it. Excel opens it with Description, Qty, Rate, and Amount as headed columns, ready for your rows.
- Add the line math. In the first Amount cell type =B2*C2 and press Enter, then drag the corner fill handle down the column. Every line now multiplies quantity by rate on its own.
- Build the totals block. Under the last line, add Subtotal with =SUM(D2:D9), a tax row that multiplies the subtotal by a rate cell, and Total as the sum of those two. Adjust the ranges to match your row count.
- Format it like money. Select the Rate and Amount columns and press Ctrl+Shift+4, the $ key, for currency format. Widen the Description column by double clicking its header edge.
- Save as .xlsx before anything else. File > Save As and choose Excel Workbook. If you save back to CSV, every formula is replaced by its current value and the template stops calculating. Export the client copy with File > Save As > PDF.
Get paid faster
Keep an invoice log tab
Add a second sheet listing number, client, date, amount, and paid date. Autofill handles the numbering, and =SUM on the amount column shows the year's billing at a glance.
Terms live next to the due date
Put Net 15 or Net 30 in the cell beside the computed due date. When a client asks why the date is what it is, the answer is already printed.
Flag overdue with conditional formatting
Home > Conditional Formatting on the log's due date column, highlighting dates older than today with no paid date. Your follow-up list builds itself every morning.
Small invoices deserve short terms
Anything under about $500 can be due on receipt. Net 30 exists for accounts payable departments, not for a two hour job.
Grab the CSV and it opens straight into Excel with the columns already named; the blank PDF is there when you want to send a job without touching a spreadsheet.
Frequently asked questions
What formula totals an invoice in Excel?
=SUM(D2:D9) totals the Amount column if your line items sit in rows 2 through 9. Each line amount is its own formula, =B2*C2, quantity times rate. Adjust the letters and rows to wherever your columns actually live.
How do I add sales tax in Excel?
Give the rate its own cell and reference it: with the subtotal in D10 and 8.25% in C11, the tax is =D10*C11 and the grand total is =D10+D11. Never hardcode the rate inside a formula, because rates change and buried numbers get forgotten.
Can Excel auto-number my invoices?
Not out of the box, but a log sheet gets you close. Type 2026-001 and 2026-002 in two cells, select both, and drag the fill handle: Excel continues the sequence. Or build the label with a formula like ="INV-"&TEXT(ROW()-1,"0000") on a numbered list.
Why did my formulas turn into plain numbers?
The file was saved as CSV. That format stores only displayed values, so formulas, formatting, and extra sheets are all stripped without much warning. Keep the working template as .xlsx and use CSV only for moving raw data around.
When does a spreadsheet stop being enough?
When you are retyping the same client details weekly, chasing three overdue invoices from memory, or invoicing from a job site. Staxen exists for that point, for trade contractors specifically: Ivy the Invoicer sends, reminds, and reconciles to QuickBooks at $59 per month per AI employee, $149 per month for all three.
Start free with Staxen: your first job is on us, no card required.