Invoice Template for Excel

An Excel invoice template that actually does the arithmetic. Enter a quantity and a rate on each line and the amounts, subtotal, tax and total due update themselves. Opens in Excel, Google Sheets, Numbers and LibreOffice Calc.

Download the Excel invoice template

XLSXInvoice template (.xlsx) (8 KB)Eight line-item rows with live formulas. Shaded cells are yours to edit; everything else calculates.

Free to download and use. No sign-up, no email, no watermark.

How to use this invoice template excel

Open the file in Excel, or upload it to Google Sheets. Editable cells are shaded pale yellow with blue text; every unshaded cell is a formula, so leave those alone.
Fill in your details and your client's details in the shaded blocks at the top, then the invoice number and dates.
For each line of work, type a description, a quantity or number of hours, and a rate. The amount column fills itself in. A row with no quantity or rate stays blank rather than showing a zero.
Enter a discount if you are giving one, and a tax rate if you owe sales tax. The tax rate is a percentage field — enter 8.25% as 0.0825, not as 8.25.
Check the total, then print to PDF and send that. File → Save As → PDF in Excel, or File → Download → PDF in Google Sheets. The print area is already set so it comes out as one clean page.

How the formulas work

Each line's amount is quantity multiplied by rate, wrapped so that an empty row shows nothing instead of a zero — a column of $0.00 rows on a sent invoice looks unfinished. The subtotal adds the amount column. Tax is calculated on the subtotal after the discount comes off, not before, which is the ordinary treatment and the one your client will expect. The total is subtotal minus discount plus tax.

Nothing is hardcoded. Change a rate and every figure below it updates, which means you can reuse the same file for a whole year of invoices without ever recalculating by hand. That is the real reason to use the spreadsheet version: not that it saves you a minute of arithmetic, but that it removes the class of error where the lines and the total quietly disagree.

The file ships with two example rows already filled in — a $1,200 fixed fee and 32 hours at $145 — so you can watch the formulas work before replacing them with your own numbers. There is also a short legend at the bottom naming which cells to edit. Delete both once you are comfortable with it.

Example

The example rows that come with the file: a freelance designer billing a fixed-price discovery workshop plus hourly design work, with a retainer credit applied.

Row 16 — quantity 1, rate $1,200.00	Amount = $1,200.00
Row 17 — quantity 32, rate $145.00	Amount = $4,640.00
Subtotal (sum of the amount column)	$5,840.00
Discount (typed in)	$300.00
Tax rate (typed in as a decimal)	0.00%
Tax = (subtotal − discount) × rate	$0.00

Total due = subtotal − discount + tax = $5,540.00

Only four cells in that list were typed: the two quantities, the two rates, and the discount. Everything else is calculated. Change the 32 hours to 40 and the total moves to $6,700.00 without you touching another cell.

The tax rate trips people up more than anything else in the file. It is formatted as a percentage, which means the underlying value is a fraction. Typing 8.25 gives you an 825% tax rate and a total that is obviously wrong; type 0.0825, or type 8.25% including the percent sign and Excel converts it for you.

Tax comes off after the discount here. If your state requires tax on the pre-discount amount — a few do for certain kinds of discount — change the tax formula to reference the subtotal cell directly instead of the subtotal-minus-discount expression.

Limits and things to watch for

The tax field applies one flat rate to the whole invoice. It cannot handle mixed rates, line-level tax, or reverse-charge VAT.
Eight line-item rows. Adding a ninth means copying a row and extending the subtotal range — Excel will not extend it for you, and a subtotal that silently misses the last row is the most expensive mistake this file can produce. Check the range after inserting rows.
Google Sheets converts the formulas correctly, but the print area and page scaling do not always survive the import. Set the print area again before exporting to PDF from Sheets.
The file does no currency conversion and has no exchange-rate logic. It formats as US dollars; change the cell number format if you invoice in another currency.

Disclaimer. This template is a business document, not tax advice. Whether you owe sales tax, at what rate, and on which base varies by state and by what you sell. Confirm with a qualified accountant before relying on the tax line.

Frequently asked questions

Which cells am I supposed to edit?: The shaded pale-yellow ones with blue text. Everything else is a formula. There is a legend at the bottom of the sheet saying the same thing, so you do not have to remember it.
Why is my tax number enormous?: You almost certainly typed the rate as a whole number. The tax field is a percentage, so 8.25% must be entered as 0.0825 or as "8.25%" with the sign. Typing 8.25 on its own means 825%.
Will this work in Google Sheets?: Yes. Upload the .xlsx to Google Drive and open it with Sheets. The formulas convert cleanly. Reset the print area before exporting to PDF, because page scaling does not always carry over.
How do I add more line items?: Right-click a row inside the existing block and choose Insert, so the new row sits within the subtotal range. If you add rows below the last one instead, you must widen the SUM range yourself — otherwise the subtotal quietly ignores them.
Do I send the .xlsx to my client?: No. Export to PDF and send that. A spreadsheet is editable, exposes your formulas, and looks like a working file rather than a finished invoice.