MakePaperwork

Invoice Template for Excel

An Excel invoice already filled in with an example. Change the details here, then download an .xlsx file with working formulas.

The example below is only a starting point: change any line, or clear the form with the bin icon next to Save.

Fully customizable. Rename any label, hide any detail or signature, and add your own fields. The changes carry into the PDF, Word and Excel files.

E-invoice
Download as an e-invoice
More
Convert to

My documents
Colour

For real transactions only. Creating false or misleading documents is illegal and prohibited by our Terms.

An Excel invoice is handy when you want the numbers to keep working after you download it. In the .xlsx file from this page, each line amount is quantity × unit price, and the subtotal and total are formulas. Change a quantity in Excel and the totals follow.

Fill in your business, the customer and the items here, check the preview, then press “Excel”. The file opens in Microsoft Excel, Google Sheets, Apple Numbers and LibreOffice Calc.

What you get in the Excel file

  • Line amounts as formulas. Each amount is calculated from the quantity and the unit price.
  • A subtotal formula. The sum of the line amounts, updated when you change a line.
  • Tax and total. Worked out from your tax rate and shown under the items.
  • Your details. Business, customer, invoice number, dates and payment details at the top and bottom.
  • A print-ready sheet. A clean layout you can print or export to PDF from Excel.

How to make an invoice in Excel

  1. Fill in the form above and check the preview.
  2. Press Excel to download the .xlsx file.
  3. Open it in Excel. To change an item, edit the quantity or the unit price: the line amount and the totals update.
  4. Before sending, export it to PDF from Excel (File, Export, PDF), or press Download PDF here.

Use it in Google Sheets

Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas keep working, and you can download the invoice as a PDF from Sheets.

Track your invoices

Keep each invoice as its own file, named with its number and the customer, for example INV-0042 Greenway.xlsx. To see what has been paid, use My documents on this site, where you can mark each invoice as sent, paid or overdue. Need to change the wording or the layout instead? Download the Word invoice template.

Questions about the Invoice Generator

Does the Excel invoice have formulas?

Yes. Line amounts are quantity × unit price, and the subtotal is a SUM formula, so the totals update when you change a line in Excel.

Can I open it in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets.

Can I add more lines in Excel?

Yes. Insert a row inside the items table and copy the formula from the line above, so the new line is included in the subtotal. Adding the lines here before you download is easier.

Is it free?

Yes. There is no account, no watermark and no limit.

More examples by trade

Guides and tips

Other documents