Free Excel Invoice Templates

Excel invoice template guide

Invoicing with Microsoft Excel

A spreadsheet is the natural home for an invoice. Quantities multiplied by rates, lines added into a subtotal, tax applied, and a final amount due: Excel does all of it instantly and never makes an arithmetic slip. Our .xlsx template has these formulas already in place.

Who the Excel template is for

Choose Excel if you sell products, bill for many separate items, charge tax, or simply want the math handled for you. Retailers, contractors with materials and labour, caterers, and anyone producing itemised bills will find it quicker than Word. If your invoices are mostly a single paragraph of description, the Word template may feel more natural.

How the formulas work

You do not need to know Excel formulas to use the template, but it helps to understand what is happening so you can adjust it with confidence.

• Line amount is Quantity × Unit price. Type the first two and the third fills itself in.
• Subtotal is a SUM of all the line amounts.
• Tax is Subtotal × Tax rate. Change the rate cell to your local percentage, or set it to 0 if you do not charge tax.
• Total due is Subtotal + Tax, less any deposit or discount you enter.

Cells containing formulas are best left alone. If you accidentally type over one, press Ctrl+Z (or Cmd+Z on a Mac) to undo.

How to edit the Excel invoice template

1. Download and open excel-invoice-template.xlsx. Click Enable Editing if Excel opens it in Protected View.
2. Add your logo and details. Select the placeholder image and delete it, then use Insert → Pictures. Type your business name and contact details into the header cells.
3. Set your tax rate once. Find the tax rate cell and enter your percentage. Save this as your master copy.
4. Enter client details, dates, and the invoice number. Excel formats the date cells automatically; type the date and it will display consistently.
5. Add line items. Type a description, quantity, and unit price on each row. The amount column calculates itself.
6. Need more rows? Right-click a row number inside the items table and choose Insert. The subtotal formula expands to include it. Avoid adding rows below the last item row, as those fall outside the SUM range.
7. Export to PDF. Use File → Save As → PDF or File → Export. Check Page Layout → Print Area if the PDF cuts off any columns.

Compatibility

• Microsoft Excel 2010 and later on Windows and Mac, and Excel for Microsoft 365.
• Google Sheets opens .xlsx files and keeps the formulas. We also offer a native Google Sheets template.
• LibreOffice Calc and Apple Numbers both import .xlsx with formulas intact.

Excel invoicing tips

• Keep one workbook per client with a sheet per invoice, or one file per invoice named by number. Pick a system and stick to it.
• Use Format Cells → Currency on the money columns so amounts always show two decimal places.
• Add a hidden "Payments" sheet to log when each invoice was paid, and you have a simple accounts-receivable tracker.
• Protect the formula cells (Review → Protect Sheet) if other people will fill in the invoice.