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
- Put your business details in
A3toA5and the client’s inA9andA10. - Set the invoice number, date and payment terms in
D3toD5. The due date inD6follows. - List the work in rows 13 to 20: a description, a quantity and a unit price. Set the discount and tax rate in
D23andD24(0% if you don’t charge tax).
How it works
D6=D4+D5: The due date: the invoice date plus the payment terms. Dates are numbers of days, so adding 30 moves it 30 days on.D13:D20=IF(B13="","",B13*C13): Each line’s amount: quantity × unit price. IF leaves empty lines blank instead of showing $0.00.D22=SUM(D13:D20): The subtotal of every line. SUM ignores the blank ones.D25=ROUND((D22-D23)*D24,2): Tax on the discounted subtotal, rounded to the cent so the total adds up exactly.D26=D22-D23+D25: The total due: subtotal, less the discount, plus tax.
Learn the skills behind it
- Arithmetic with cell references
- SUM and AutoSum
- Rounding values (not just how they look)
- Date maths: gaps, renewals and month ends
- The IF function
Functions used: SUM, IF, ROUND.