Free Invoice Template for Excel
Last updated June 2026
Bill a client without fighting layout: this single-sheet .xlsx invoice has From and Bill To blocks, invoice number and date fields, and a line-item table where Amount, Subtotal, Tax, and Total calculate themselves. The print area is preset to one page, so freelancers, contractors, and small businesses can fill it in, export a PDF, and send it the same hour.
Free Invoice Template for Excel
invoice.xlsx · free · no signup
Works in Excel, LibreOffice Calc, and Google Sheets (File → Import).
SHA-256: d07dd0bc2ace79c930cac43f98fc50c7ce4c0152dc44b263f1a2b1da8a19af47
| A | B | C | D |
|---|---|---|---|
| Qty | Description | Unit Price | Amount |
| 4 | Consulting (hours) | $95.00 | $380.00 |
| 1 | Site audit | $250.00 | $250.00 |
| Subtotal | $630.00 | ||
| Tax rate | 8.5% | ||
| Tax | $53.55 | ||
| Total | $683.55 |
What's inside
Sheets
InvoiceThe whole invoice on one sheet: From and Bill To address blocks, invoice number, date and due date, the line-item table, and the Subtotal/Tax/Total stack. The print area is set toA1:F36and fit to one page.
Columns
- QtyHow many units, hours, or items you're billing for. Leaving it blank keeps that row's Amount empty instead of showing $0.
- DescriptionWhat the line is for — one row per service or product.
- Unit PricePrice per single unit or hour. Currency-formatted.
- AmountQty times Unit Price, calculated for you. Add rows between 16 and 30 and the formula is already there.
Formulas that do the work
Each Amount cell multiplies Qty by Unit Price, but returns a blank string when the Qty cell is empty — so unused rows stay clean. It's copied down the full line-item range, rows 16 to 30.
The Subtotal at D32 adds every Amount in the table. Because empty rows resolve to blank rather than zero, the sum stays correct no matter how many lines you use.
Tax at D34 multiplies the Subtotal by the Tax rate you type in D33. Enter the rate as a percent (for example 8.5%) — leave D33 blank for tax-exempt work and Tax stays $0.
The Total at D35 adds Subtotal and Tax. This bold cell is the amount due — it updates the instant you change a quantity, price, or tax rate.
How to use it
Fill in your details
In the From: block at the top left, replace the four placeholder lines with your business name, address, and email. Add your client's details in the Bill To: block below it.
Set the invoice number and dates
Type an invoice number in
F3, the issue date inF4, and the due date inF5. The date cells are already date-formatted, so6/10/2026displays cleanly.List what you're billing
In the line-item table starting at row 16, enter a Qty, Description, and Unit Price per row. The Amount column fills itself in; blank rows stay empty.
Add tax if you charge it
Type your tax rate into
D33as a percent. Subtotal, Tax, and Total recalculate automatically. LeaveD33empty for tax-exempt invoices.Save as PDF and send
The sheet is already set to print on one page. Go to File → Export → Create PDF/XPS Document (or File → Save As and pick **PDF (*.pdf)** from the file-type list), then email the finished invoice to your client.
Compatibility
- Microsoft Excel. Excel for Microsoft 365, Excel 2016 and later (Windows and Mac).
- LibreOffice Calc. Opens directly — formulas, validation lists, and formatting carry over.
- Google Sheets. Upload via File → Import → Upload, or drag the file into Drive and open with Sheets.
The one-page print area is an Excel setting — after importing to Google Sheets, confirm it under File → Print before exporting a PDF. See print on one page for the exact steps.
Frequently asked questions
- Is this invoice template really free?
- Yes, including for paid client work. Bill customers with it, put your own business name at the top, and send as many invoices as you like — no license fee, no attribution line, and no "made with" footer forced onto your billing.
- How do I add my company logo?
- Click Insert → Pictures → This Device, choose your logo file, and drop it near the INVOICE title in the top rows, then drag a corner handle to resize. The print area
A1:F36already leaves header space for it. - How does the tax calculation work?
- Type your rate into the Tax rate cell
D33as a percent. Tax atD34is=D32*D33and the Total atD35is=D32+D34, so both update the moment you change the rate. - Can I add more line items?
- Yes. Right-click a row number inside rows 16 to 30 and choose Insert, then copy the Amount cell from an adjacent row into the new blank row. The
=SUM(D16:D30)Subtotal expands to include the new row automatically. - Will the totals still calculate after a Google Sheets import?
- They will — Amount, Subtotal, Tax, and Total are ordinary formulas that Sheets evaluates natively once you bring the file in through File → Import → Upload. One thing to recheck before sending a PDF: the print area, which Sheets manages from its own print settings.