Skip to content

Invoice Template for Excel

This free invoice template for Excel does the arithmetic for you: enter a quantity and a rate, and the amount, subtotal, tax and total due update on their own. It's a single sheet that prints on one page and opens in Excel, Google Sheets, Numbers or LibreOffice.

Download .xlsxOr edit online

Free to download. No sign-up, no email required.

Let the formulas do the adding.

What's in the Excel invoice template

  • One sheet named Invoice

    Everything sits on a single tab: your business details at the top, the invoice number and dates beside them, and a Bill to block below.

  • Line amounts that calculate

    Each Amount is Qty × Rate. Type a quantity and a rate, and the line totals itself.

  • A tax-rate cell

    Enter your rate once, such as 8.25%, and Tax follows from it. Leave it at zero if you don't charge tax.

  • Subtotal and total due

    Both are formulas, so the figure at the bottom always matches the lines above it.

  • US dollar formatting

    Money cells show dollars and cents. For another currency, select the cells and change it in Format Cells.

  • A one-page print area

    The sheet is set to print on a single page, so the PDF comes out as one tidy page.

  • Notes and payment terms

    Space for a thank-you and the terms your client needs to pay on time.

Download the template.

Free, with no sign-up and no email required. Prefer to fill it in online? The generator works out the totals, adds your logo and downloads it as Word, Excel or PDF.

Edit online instead

  • Invoice template for Excel

    .xlsx file · 8 KB · Free

    • Amounts, subtotal, tax and total calculate themselves
    • Shaded cells show what to fill in
    • A 10-line item table and a tax-rate cell
    • Prints on a single page

    Opens in Microsoft Excel, Google Sheets, Apple Numbers and LibreOffice.

    Download .xlsx

How to use it in Excel.

  1. Step 1: Open it in Excel

    Download invoice-template.xlsx and open it. If Excel shows a Protected View bar, select Enable Editing.

  2. Step 2: Fill in the details

    Type your business and client details, the invoice number and the dates. Then add a description, quantity and rate on each line.

  3. Step 3: Set your tax rate

    Enter your rate in the tax-rate cell, or leave it at 0%. Subtotal, Tax and Total due update as you type.

  4. Step 4: Save as PDF

    Choose File > Save As (or File > Export) and pick PDF. The print area already fits on one page.

A sample invoice to start from.

Copperline Print & Sign billing Sugar Maple Bakehouse, on Net 15 terms. Open it in the generator and every line is yours to edit.

Open this sample
Line items on a sample invoice to start from, issued Oct 12, 2026
ItemAmount
Business cards, 16 pt matte
Boxes of 500, two names
2 × $48.00
$96.00
Menu cards, 8.5 x 11 in
Double-sided on heavy cover stock
250 × $0.85
$212.50
Vinyl banner, 3 x 6 ft
Hemmed edges and grommets
1 × $135.00
$135.00
Window decal
Opening hours in cut vinyl
1 × $95.00
$95.00
Design changes
Menu price updates, hourly
1.5 × $65.00
$97.50
Subtotal$636.00
Sales tax (8.25%)$52.47
Balance due$688.47

Notes. Your menu files are saved on our side, so a reprint with new prices takes a day, not a week.

Terms. Payment is due within 15 days of the invoice date. A 1.5% monthly late fee may apply to overdue balances.

Tips for people who invoice in Excel.

  • Type in the inputs, not the totals

    Amount, Subtotal, Tax and Total due are formulas. Typing a number over one stops it calculating, so if that happens, copy the formula back from a neighboring row or start from a fresh download.

  • Keep each invoice on its own tab

    Right-click the sheet tab, choose Move or Copy, tick Create a copy and rename the new tab with the invoice number. A year of invoices then lives in one file.

  • Preview before you print

    If you add rows, open File > Print to check the page. Reset it with Page Layout > Print Area > Set Print Area if anything spills over.

The same invoice, four ways.

Three free designs and a taste of Pro. Switch at any time, or browse all 48.

Excel invoice templates, answered.

Which cells calculate automatically?

Amount on each line (Qty × Rate), Subtotal, Tax and Total due. Tax uses the rate in the tax-rate cell, so that's the only number you change for it.

How do I change the currency from US dollars?

Select the money cells, press Ctrl+1 (Cmd+1 on a Mac) to open Format Cells, choose Currency and pick your symbol. The formulas stay the same.

How do I add more line items?

Insert new rows inside the items table rather than below it, so the Subtotal includes them. Then copy the Amount formula down into the new rows.

Does it work in Google Sheets?

Yes. In Google Sheets, choose File > Open > Upload and the formulas keep working. The file also opens in Apple Numbers and LibreOffice Calc.

When is the online generator easier than Excel?

When you want your logo and a designed layout without adjusting print settings. The free invoice generator does the same math, adds your logo and makes the PDF in one step.

Is this template free to use?

Yes. Open it in the invoice generator, replace the sample details with your own and download a PDF. No sign-up, no watermark.

Can I add my own logo and colours?

Yes. Upload your logo, choose a design and pick an accent colour, or enter your own hex value. 3 designs are free; Pro unlocks all 48.

Related templates.

All templates

Send it. Get paid. Automatically.

Pro turns the invoice you just made into one that delivers itself, takes payment and follows up.

Try Pro free for 14 daysSee pricing

  • Send and track

    Email a payable link and see the moment it's opened.

  • Get paid online

    Card and bank payments, recorded against the invoice.

  • Reminders on autopilot

    Polite follow-ups that stop when you're paid.

PAID IN FULL • THANK YOU •

Your next invoice, done.

Start from this sample, make it yours, and download a polished PDF in under a minute.

Use this templateSee all features