Free Invoice Template for Excel (Download and Customize)

Excel is on more computers than any dedicated invoicing software, which makes it a reasonable starting point for freelancers and small businesses that are not ready to pay for a separate tool. A well-built Excel invoice template handles the math automatically, keeps your layout consistent, and exports cleanly to PDF for sending. This guide gives you a free template, walks through how to set it up, and explains when it is time to move on to something built specifically for invoicing.

What to include in an Excel invoice template

Before you open Excel, it helps to know every section the finished template needs. A complete invoice has eight pieces, and skipping any of them creates problems down the line.

• Header with your business information. Business name, address, phone, and email. If you have a logo, it goes here in the top left or right.
• Client information. The company or person you are billing, their address, and their billing contact. Even if everything else is digital, some clients need a physical address in the Bill To block for their accounting records.
• Invoice number. Sequential and unique. Never reuse a number, even for voided invoices. Start at 1001 if 0001 feels too new.
• Invoice date and due date. Both, with specific dates rather than just payment terms. "Due: July 5, 2026" is clearer than "Net 15" with no reference date.
• Line items. Each product or service as a separate row with a description, quantity, unit price, and calculated total.
• Subtotal, tax, and total. Use formulas so these calculate automatically. Manual math is where billing errors come from.
• Payment terms and late fee notice. State when it is due and what happens if it is not paid on time.
• Payment instructions. How do you want to be paid? Include the specific details: bank account info, PayPal email, Venmo handle, or whatever method you use. A client who cannot figure out how to pay you will delay.

How to build the Excel invoice template step by step

Open a new Excel workbook and set the page layout to portrait orientation with 0.75-inch margins on all sides. This gives you a clean print area that matches a standard letter-size page. Start building in four blocks from top to bottom.

Block 1: Header

Merge cells A1 through D3 for your business name and contact information. Set the font to 12-14pt bold for the business name, 11pt regular for the address and phone. If you are adding a logo, insert it as a picture (Insert tab, Pictures) and anchor it to the top left or right corner. On the opposite side of the header, add a two-column table with labels (Invoice #, Date, Due Date) in one column and empty cells in the other. These are the cells you update each time you create a new invoice.

Block 2: Bill To

Leave two empty rows for spacing, then add a "Bill To:" label in bold followed by cells for the client's name, company, and address. Keep it simple. Four or five rows is enough for any mailing address.

Block 3: Line items table

This is the core of the template. Create a table with five columns:

• Column A: Description (wide, about 40% of the total width)
• Column B: Qty
• Column C: Unit Price
• Column D: Tax % (optional, set to 0 if you do not charge tax)
• Column E: Amount

In the Amount column, use a formula that multiplies Qty by Unit Price: =B12*C12 (adjust row numbers to match your layout). If you include a Tax column, the formula becomes =B12*C12*(1+D12/100). Copy this formula down for ten or fifteen rows so you have enough line item rows for most jobs.

At the bottom of the table, add three summary rows:

• Subtotal: =SUM(E12:E26) (adjust range to cover your line item rows)
• Tax (if applicable): a flat percentage or zero
• Total: Subtotal plus Tax, in a bold, larger font

Apply a light gray fill to the header row of the table and a slightly darker fill to the Total row. This gives the eye a visual anchor and makes the final number easy to find at a glance.

Block 4: Footer

Below the totals, add a notes section with your payment instructions and terms. Something like: "Payment due by [Due Date]. Late payments subject to a 1.5% monthly fee. Please send payment to [bank details] or [PayPal email]." This is the one section clients actually read when they are about to pay you.

How to use the template without overwriting it

Save the finished file as "Invoice Template.xlsx" in a dedicated folder. Every time you need to create a new invoice, open the template and immediately do File > Save As to create a copy with a client-specific name like "SmithCo-Invoice-1003.xlsx." Fill in the client details, update the invoice number and dates, add your line items, and save.

Before sending, export to PDF. Go to File > Export > Create PDF/XPS. Never send the .xlsx file itself. Excel documents look different depending on the recipient's software version, screen resolution, and printer settings. A PDF locks the layout so your invoice looks exactly the way you built it regardless of what the client uses to open it.

Keeping track of invoices in Excel

A single template file handles one invoice at a time, but if you are sending several invoices a month, you need a way to track which ones are paid and which are outstanding. The simplest approach is a second sheet in the same workbook called "Invoice Log."

Set up five columns: Invoice Number, Client Name, Invoice Date, Due Date, Amount, Status. Every time you send an invoice, add a row. Update the Status column when payment arrives. Filter by Status = "Unpaid" once a week to see what needs a follow-up.

This is manual, and it works fine up to about twenty active invoices. Beyond that, the tracking starts to take more time than it saves, and dedicated invoicing software handles it automatically.

Excel invoice template vs. Google Sheets

The same template structure works in Google Sheets with minor differences. Google Sheets does not have the same PDF export options as Excel, but you can go to File > Download > PDF document to get a clean PDF. The formulas are nearly identical. The main advantage of Sheets is that the file lives in the cloud and you can share a view-only link with clients if they want to check on project billing.

The main downside of both is that they are still manual. You update the template, save a copy, send a PDF, and track payment in a separate log. None of that is automatic, and errors sneak in when you copy-paste a line item from last month and forget to update the date or the amount.

When to stop using Excel for invoicing

Excel is the right tool for occasional invoicing when volume is low and clients are reliable. It starts to cost you time and money when any of the following are true.

You are sending more than ten invoices a month. At that volume, the manual process of copying the template, updating fields, exporting PDFs, and tracking status in a separate log takes a couple of hours a month. That time has a real cost.

You have clients who regularly pay late. Excel gives you no automatic reminders. You write every follow-up email yourself and remember to send them. Invoicing software sends reminders on a schedule you set, which means fewer late payments and fewer awkward emails.

You want clients to be able to pay by card. A PDF invoice requires the client to go to their bank, set up a payment, or mail a check. Every extra step is a reason to do it later. A Pay Now button on a digital invoice, where the client clicks and pays in thirty seconds, cuts the average payment time significantly. The WaffleInvoice free invoice generator adds that button automatically on every invoice.

You need a paper trail for taxes. Excel files can be deleted, renamed, and accidentally overwritten. A proper invoicing tool keeps a timestamped record of every invoice, every payment, and every change, which is worth a lot at tax time or if a client disputes what they owed.

WaffleInvoice covers all of this on the free plan with no invoice limit. If you grow into recurring invoices, automatic reminders, or Stripe payment processing, those are on the Pro plan at $19 a month. You can start with the free tier and upgrade only if you actually need those features. See the pricing page for the full breakdown.

Tips for cleaner Excel invoices

• Use cell borders sparingly. A table outline and horizontal lines between rows is enough. Too many borders make the invoice look cluttered.
• Format currency cells properly. Select the Amount column and the subtotal/tax/total cells, right-click, Format Cells, and set to Currency with two decimal places. This prevents numbers like 500 from showing up where the client expects 500.00.
• Freeze the header rows. If your line item table is long, freeze the top rows (View > Freeze Panes > Freeze Top Row) so you can scroll down and still see the column labels.
• Set print area before exporting to PDF. Go to Page Layout > Print Area > Set Print Area and select only the cells that make up the invoice. This prevents empty rows and blank pages from appearing in the PDF.
• Use conditional formatting on the Status column in your log. Color overdue rows red automatically so unpaid invoices jump out when you open the file.