Excel templates / Invoice

Invoice template

Line amounts, subtotal, discount, tax and total due work themselves out, with the due date from your payment terms.

Download the invoice template (.xlsx). Free, no sign-up. Works in Excel 2010 and later, Excel for Mac, Excel on the web, Google Sheets and LibreOffice.

How to use it

  1. Put your business details in A3 to A5 and the client’s in A9 and A10.
  2. Set the invoice number, date and payment terms in D3 to D5. The due date in D6 follows.
  3. List the work in rows 13 to 20: a description, a quantity and a unit price. Set the discount and tax rate in D23 and D24 (0% if you don’t charge tax).

How it works

Learn the skills behind it

Functions used: SUM, IF, ROUND.

More free templates