.xlsx · formulas included · free

Invoice template for Excel

An invoice spreadsheet that does the math for you. Enter a description, a quantity and a rate; Excel calculates the line amount, the subtotal, the tax and the total. Useful when you invoice regularly or bill several lines per client.

Works in Excel 2016+, Microsoft 365, LibreOffice and Google Sheets

What the spreadsheet includes

  • Seller and client blocks with editable placeholders.
  • Invoice number, issue date, due date and payment terms cells.
  • Twelve invoice lines with quantity, rate and an automatic amount column.
  • Subtotal, tax and total cells with formulas already wired.
  • Notes and payment-instruction blocks below the totals.
  • A print-ready layout on a single sheet.

How the formulas work

  • D11 = B11 * C11 — line amount (quantity × rate).
  • D24 = SUM(D11:D22) — subtotal of every line.
  • D26 = D24 + D25 — total including the tax cell.

For a percentage tax, replace the value in D25 with =D24*0.20 (or your rate). For multiple taxes, add one row per tax and include each row in the total formula.

How to use it

  1. Download and open. Enable editing if Excel opens the file in protected view.
  2. Fill the header. Replace the business and client placeholders, then set the invoice number and dates.
  3. Enter your lines. Type the description, quantity and rate. The amount column fills itself.
  4. Set the tax. Put the tax amount in the tax cell, or use a percentage formula as described above.
  5. Print or export. Select the invoice range as the print area, then print or save as PDF.

Frequently asked questions

Do the Excel formulas update automatically?

Yes. Each line amount is quantity × rate, the subtotal sums the line amounts, and the total adds the tax cell. Change a quantity or a rate and the totals recalculate.

How do I add more invoice lines?

Insert rows inside the line range (rows 11 to 22) so the SUM formula expands automatically. If you add rows below row 22, extend the SUM range to include them.

Can I use a percentage tax instead of an amount?

Yes. Put the taxable amount in one cell and the rate in another, then set the tax cell to a formula such as =D24*0.20. The file ships with a plain tax amount cell so you can choose either method.

Can I print the Excel invoice or save it as PDF?

Yes. Set the print area to the invoice range, then use File → Print or File → Save As → PDF. Check that the page fits on one sheet before sending.

Don’t want to manage formulas?

The generator calculates taxes, discounts, withholding and currency formatting for 155 currencies, in 100+ languages, and gives you a finished PDF.

Related: all invoice templates · Word template · Google Docs template

Invoice Template for Excel — Free .xlsx Download