How to Make an Invoice Template (Free) in Word, Excel, Google Docs or Sheets — and When to Switch to Software

To make an invoice template for free, open Word, Excel, Google Docs or Google Sheets (or start from their built-in invoice templates), add your logo and business details, fields for client details, invoice number and dates, a line-item table with quantity, rate and amount (using formulas in a spreadsheet), subtotal, tax and total, and payment terms and methods. Save it as a reusable template, then for each invoice fill it in, update the number, and export as PDF.

Fields to include

• Logo and business name, address, contact, tax ID (if applicable)
• "Invoice" title
• Invoice number, invoice date, due date
• Client name, company, billing address, PO number
• Line items: description, quantity, rate, amount
• Subtotal, discount, tax, total due
• Payment terms and instructions
• Notes/thank-you

(Reference layout: What does an invoice look like?)

Option 1: Google Sheets or Excel (best for calculations)

1. File › New › From template and search "invoice", or start blank
2. Create header rows with your details and invoice info
3. Make a table: Description | Qty | Rate | Amount
4. In the Amount column: =B10*C10 (copy down)
5. Subtotal: =SUM(D10:D20)
6. Tax: =D21*0.18 (replace with your tax rate, or 0)
7. Total: =D21+D22
8. Format currency and add borders
9. Save as "Invoice template"; duplicate it for each new invoice
10. File › Download › PDF to send

Option 2: Word or Google Docs (best for design)

1. Use a built-in invoice template or insert a table
2. Add your logo and details
3. Type line items and totals (calculate carefully or use Word table formulas)
4. Save as a template (.dotx) in Word or "Make a copy" in Google Docs
5. Export as PDF

How to type up an invoice (quick steps)

1. Open your template copy
2. Update the invoice number (next in sequence; see What is an invoice number?)
3. Enter today's date and due date
4. Fill in client details and PO
5. Add line items and check totals
6. Save as PDF named like "INV-1045_ClientName.pdf"
7. Send it (see How to send an invoice)

Free invoice generators and apps

Many invoicing tools offer free plans or free generators: Zoho Invoice, Wave, Invoice Simple-style apps, PayPal and Square invoices, Stripe for payment-linked invoices. Free plans may have limits on clients, branding or features.

When to switch from templates to software

Automate invoicing

Connect bookings, CRM deals or completed jobs to automatically generate invoices, send reminders and record payments (see How to automate business processes and What can Power Automate do?).

Frequently asked questions

How do I make an invoice template?

Create a document or spreadsheet with your business details, client fields, invoice number and dates, an itemised table, totals, taxes and payment terms, then save it as a reusable template.

How can I make invoices for free?

Use Google Docs/Sheets or Word/Excel templates, or free plans of invoicing apps such as Zoho Invoice or Wave.

How do I make a simple invoice?

Include your details, client details, invoice number, date, items with prices, total due and how to pay, then save as PDF and send.

What is the best free invoice template?

Built-in templates in Google Sheets, Excel or Word are good starting points; spreadsheets are best for automatic calculations.

How do I write a billing invoice for payment?

List what was delivered with prices, show the total due and due date, add payment instructions and send it to the client's billing contact.

Should I use a template or invoicing software?

Templates suit occasional invoices; software saves time with numbering, online payments, reminders and accounting sync.