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.

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.xlsxThese 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
- Free Invoice Generator
- Profit Margin and Markup Calculator
- Break-Even Point Calculator
- Business Loan Calculator
- Factor Rate to APR Calculator
- MCA Cost Calculator
- Cash Runway Calculator
- Payroll Cost Calculator
- Restaurant Food Cost Calculator
- Contractor Bid Calculator
- Small Business Cash Flow Template
- All free tools