Home

›

›

Invoice Template for Excel and Google Sheets

,

Invoice Template for Excel and Google Sheets

This free invoice template calculates everything for you: each line amount, the subtotal, discount, tax and the total due. The due date is set from the issue date and your payment terms, and the layout prints cleanly to one page, so you can send a professional invoice as a PDF in a few minutes.

Format
Excel, Google Sheets
Opens in
Excel, Google Sheets, LibreOffice and Numbers
Topic
Finance
Publisher
ProTemplates
Price
Free
Invoice spreadsheet line items totals

What’s inside

  • Business and client details blocks
  • Line items with quantity, unit price and automatic amounts
  • Subtotal, discount, tax rate and total due
  • Due date calculated from payment terms
  • Payment details section and print-ready layout

How to use it

  1. Replace the business details with your own and set the invoice number.
  2. Enter the issue date and payment terms in days.
  3. Add one line per product or service.
  4. Set a discount and tax rate if they apply, then save or print to PDF.

FAQ

Is there a version for Word or Google Docs?

Yes, there is a document version with the same layout. The spreadsheet version is better if you want the totals calculated for you.

How should I number invoices?

Use a simple sequence that never repeats, such as INV-0042, INV-0043. Many tax authorities expect consecutive numbers with no gaps.

Can I add my logo?

Yes. Insert the image above the business details; the rest of the layout does not move.