TemplateHub
Home / Templates / Invoice Template
Accounting Templates

Invoice Template

A free, professional invoice template for Excel and Google Sheets. Add your items and the line amounts, subtotal, tax, and total calculate automatically — ready to send in minutes.

Downloads1
FormatXLSX
LicenseFree
AdSense-ready placement

Template Overview

Every business needs to bill clients, and a clean, professional invoice gets you paid faster. This free invoice template works for freelancers, agencies, shops, and service providers of any kind. Fill in your company and client details, list what you're charging for, and the spreadsheet does the maths: each line's amount, the subtotal, an optional tax, and the final total all calculate automatically. Set the tax rate to 0% if you don't charge tax, or enter your rate and the tax amount updates instantly. When you're done, save it as a PDF and send it. It's a simple, reliable invoice you can reuse for every client.

Features

  • Auto-calculates amounts, subtotal, tax and total
  • Editable tax rate (set 0% if not applicable)
  • Clean, professional layout for any business
  • Works in Excel, Google Sheets and LibreOffice
  • Save as PDF and send in minutes

Instructions

  1. Download the file and open it in Excel, Google Sheets, or LibreOffice.
  2. Fill in your company details under 'From' and the client details under 'Bill To'.
  3. Add the invoice number, date, and due date in the box on the right.
  4. List each item with a description, quantity, and rate — the amount fills in automatically.
  5. Set the tax rate (or leave it 0%) — subtotal, tax, and total update on their own.
  6. Save as PDF and send it to your client.

FAQ

Is this invoice template free?

Yes. It is free to download and edit for personal and business use.

Do the totals calculate automatically?

Yes. Line amounts, the subtotal, tax, and the final total are all formula-driven and update as you type.

How do I add tax like GST or VAT?

Enter your rate in the Tax Rate cell and the tax amount and total update automatically. For a full GST invoice with CGST/SGST, use our GST Invoice Template.

Does it work in Google Sheets?

Yes. Upload it to Google Sheets and the formulas carry over.

Related Templates

A free profit and loss statement (income statement) template for Excel and Google Sheets. Enter your revenue and expenses and the gross profit and net profit calculate automatically.

Accounting Templates
Cash Book Template

A free cash book template for Excel and Google Sheets. Record every cash receipt and payment and watch the running balance, totals, and closing balance update automatically — ideal for small businesses and shops.