Spreadsheets

Free Invoice Template for Small Business

This free invoice generator Excel workbook is a small-business invoice and payment tracker. You type the client, dates, and line items. The register calculates totals, tax, balance, status, and how long an invoice has been open.

Invoice Register sheet in the LoanQuail free invoice template, showing example invoices, payment status, open balance, and aging buckets.
Preview of the Free invoice template (Excel) workbook. Sample rows are labeled [EXAMPLE].

What this template does

  • Settings stores your business name, address, email, phone, payment details, currency symbol, default tax rate, payment terms, and invoice prefix. You can paste a logo on that sheet.
  • Clients is a list you fill in once. Invoice Register looks up a client by name, so each name needs to stay unique.
  • Invoice Register is one row per invoice. Line Items is one row per product or service, matched to the invoice number.
  • The Invoice sheet is a printable view. Pick the invoice number and print it, or save a PDF.
  • Amount paid and payment date update status (Paid, Unpaid, or Overdue) and aging buckets (Current, 1-30, 31-60, 61-90, and 90+ days).

How to use it

The file works in Microsoft Excel and in Google Sheets. In Google Sheets, upload the workbook to Google Drive and open it there. Cream-colored cells are for you to edit. Grey or tinted cells hold formulas.

1. Enter your business details

On Settings, fill in the cream-colored cells: business name, address, contact details, currency, default tax rate, payment terms in days, and the next invoice number. Leave the logo box blank if you do not want one.

2. Add each client once

On Clients, add a row for each customer. The name you type there is the name you pick on the register. Delete any row whose name starts with [EXAMPLE] before you send a real invoice.

3. Create the invoice and its lines

On Invoice Register, add a row with the invoice number, invoice date, and client. The due date fills in from your payment terms. On Line Items, add one row per product or service using that same invoice number. Quantity times unit price is the line total. Mark Taxable as Yes when the line should use the default tax rate from Settings.

4. Print or save the invoice

Open the Invoice sheet and choose the invoice number. The page fills in your business, the client, the lines, tax, discount, and balance. Print it, or use your spreadsheet's print dialog to save a PDF.

5. Record what was paid

Back on Invoice Register, enter the amount paid and the payment date. Status and aging recalculate. Summary figures at the top total invoiced, collected, open, and overdue amounts.

Who it is for

Use it if you send your own invoices and want one workbook for the invoice and the unpaid balance. It fits a freelancer or a small business that does not want a separate invoicing subscription for a simple bill. It is a bookkeeping aid, not a tax filing.

Download the workbook

The download is direct. There is no email form and no account.

Download LoanQuail-Free-Invoice-Generator.xlsx

These templates are provided as-is for informational purposes and are not financial, tax, or accounting advice.

Frequently asked questions

What is included in the free invoice template?

The workbook has instructions, a settings sheet, a client list, an invoice register, line items, and a printable invoice. Totals, tax, status, and aging calculate from the cells you fill in.

How do I create an invoice in the Excel file?

Enter your business details on Settings, add the client, then add a row on Invoice Register and the matching lines on Line Items. Open the Invoice sheet, choose that invoice number, and print or save a PDF.

Will the template tell me what sales tax to charge?

No. You enter a default tax rate if you want one. The template does not decide tax treatment. These templates are provided as-is for informational purposes and are not financial, tax, or accounting advice.

Can I send this invoice to a customer?

Yes, after you replace the sample rows and check the names, dates, and totals. The file is a starting point. Confirm the figures before you send an invoice.

Other free tools