Company Invoice Template in Excel: Setup and Tips

How-to basics · Updated November 19, 2026

Yes. You can make a reusable company invoice template in Excel by laying out your business and customer details, adding an itemized table, and using formulas to calculate line totals, tax, and the amount due. In Microsoft Excel for Microsoft 365 on Windows, save a clean copy as an Excel Template (.xltx) so each new invoice starts with the same design without overwriting the original.

What an Excel company invoice template does

An invoice template is a structured document for requesting payment and recording what a company supplied. Excel is useful when invoices contain repeatable line items and you want calculations to update automatically. It is also easy to adjust the layout, add a company logo, or make a version for a particular service.

A spreadsheet is not automatically an invoicing system, however. It will not necessarily send reminders, track whether a customer paid, prevent duplicate invoice numbers, or determine which tax rules apply. Those tasks require a consistent process or dedicated software. Treat the workbook as a document that helps prepare an invoice, not as proof that every accounting or local invoicing requirement has been met.

A practical template should make the essentials easy to find: who is billing, who is being billed, what was supplied, when payment is due, and how the customer can pay. Use clear labels rather than relying on color or position alone, so the invoice remains understandable when printed or viewed on a phone.

Information to include on the invoice

Start with the information your company and customers need to identify and settle the bill. Requirements differ by location, industry, and transaction, so verify any mandatory details with an appropriate local source or accounting professional. Common fields include:

  • Company details: legal or trading name, mailing address, email, phone number, and logo if useful.
  • Customer details: the customer or business name and the billing address or contact information needed for your records.
  • Invoice identifiers: a unique invoice number, issue date, and due date. Use a numbering method that your business can maintain without accidental duplicates.
  • Itemized charges: description of each product or service, quantity or hours, unit price, and line amount.
  • Payment details: accepted payment methods and clear instructions, plus a short note about payment terms if applicable.
  • Totals: subtotal, any applicable discounts or taxes, and the final amount due.

For example, a consulting company might describe a line as “Project planning, 4 hours” rather than “Services.” Specific descriptions help the customer check the bill and help your company understand it later. Do not put sensitive payment-card details in a workbook; use an appropriate payment service instead.

Build the template in Excel

Before formatting, decide what information belongs on every invoice and which fields change from one customer or job to another. A simple one-sheet layout is usually easier to maintain than a workbook with many decorative tabs. In Excel for Microsoft 365 on Windows, create a blank workbook and build the page in a top-to-bottom order:

  1. Put the company name and contact details near the top, leaving room for a logo if you use one.
  2. Add labeled cells for the customer, invoice number, invoice date, and due date. Keep the labels visible when the document is printed.
  3. Create a line-item table with columns for description, quantity, unit price, and line total. Leave several blank rows for typical invoices.
  4. Place the subtotal, tax or other applicable charge, and total due below the table. Label each amount clearly.
  5. Add payment instructions and any relevant note at the bottom, then set up the page for printing or PDF export.

Use the Home tab’s number-format controls to display prices consistently as currency and quantities in a suitable format. Avoid merging cells throughout the data table: merged cells can make selecting, sorting, and adjusting the layout harder. Use bold text, borders, and restrained shading to distinguish headings and totals instead. If your invoices are usually one page, check the preview rather than shrinking text until it becomes difficult to read.

When the layout is ready, keep an untouched master. In Excel, choose File > Save As and select Excel Template (*.xltx) as the file type. Open the template to create a new invoice, then save that invoice as a regular workbook or export it as a PDF. On Mac, the Save As dialog and file-location choices can look different, but choose the Excel Template format if it is available. Excel for the web has different template and file-management options; for a dependable reusable master, use the desktop app or keep a clearly labeled blank workbook and make a copy before editing.

Calculate line items and totals

Formulas reduce arithmetic errors, but only if their cell references match the layout. In this example, rows 16 through 25 hold items: column A is description, B is quantity, C is unit price, and D is line total. For the first item, with quantity 3 in B16 and unit price 40 in C16, enter this in D16 and copy it down for the other item rows:

=B16*C16

The example returns 120. If row 17 has quantity 2 and a unit price of 15, the corresponding formula in D17 returns 30. The formula multiplies the quantity by the unit price; it does not decide whether the description, rate, or quantity is correct.

With line totals in D16:D25, put this formula in D26 for the subtotal:

=SUM(D16:D25)

For the two example items, the subtotal is 150. Blank item rows do not add to the sum, which makes the table convenient for invoices with different numbers of charges.

For an illustrative tax calculation, assume the tax rate is entered as 8% in F27 and the subtotal is in D26. In D27, calculate the tax amount with:

=D26*F27

The example tax amount is 12. This is arithmetic only, not a recommendation about what rate or taxable base applies. Confirm the correct treatment for the transaction with a qualified professional or relevant authority.

With the subtotal in D26 and tax amount in D27, enter this formula in D28 for the total:

=D26+D27

The example total due is 162. If the invoice also needs discounts, deposits, or other charges, decide how they should be shown and calculated before adding formulas; do not hide an adjustment inside a vague total. After entering formulas, test the workbook with a small example and check the displayed result against a hand calculation.

Make the workbook clear and reusable

Good formatting makes an invoice faster to review, but visual polish should not obscure the figures. Use a readable font, consistent date and currency formats, and a strong visual distinction for the final amount due. Keep the customer-facing page focused on the transaction. Internal notes such as job codes or staff comments belong in a separate internal record, not on the copy sent to a customer.

Before saving the master, remove example customer information and sample amounts. Consider using input cells with a light fill and formula cells with a different fill, accompanied by a small legend. This helps the person preparing the invoice know which cells to edit. You can protect formula cells to reduce accidental edits, but worksheet protection is not a substitute for access controls or a secure storage location.

Print preview is an important check. Choose File > Print to see how Excel lays out the page. Confirm the customer address, table, totals, and payment instructions are all visible, and that no extra blank page has appeared. Page layout settings can vary with printer drivers and paper sizes. Exporting a PDF is often useful because it preserves the appearance of the invoice when sent, while the editable workbook remains an internal working file.

Numbering, sending, and tracking invoices

Give each invoice a unique identifier and keep a record of which numbers have been issued. Excel does not automatically coordinate numbering across separate copies of a template. A formula that generates a number from the current date may still create duplicates when two people prepare invoices or when a file is copied. A controlled sequence maintained in a central log is often safer for a small team; businesses with many invoices may need software that manages numbering and status centrally.

A simple workflow can reduce mistakes:

  • Make a new copy of the master for each invoice and enter the customer and transaction details.
  • Check quantities, prices, dates, payment instructions, and calculations against the underlying order or agreement.
  • Assign the next available invoice number and record it in the company’s chosen tracking system.
  • Save the editable file in an appropriately restricted company location and create a PDF for delivery if that suits your process.
  • Record when the invoice was sent and later update its payment status in a separate log or accounting system.

Use a file name that is easy to search, such as a consistent combination of invoice number and customer name. Be careful with names or other personal information in file names if files are stored in shared folders. An invoice marked “paid” in a spreadsheet is only as reliable as the person updating it; reconcile payment status with the company’s actual records.

Common mistakes and practical safeguards

One frequent problem is overwriting a formula while entering an amount. Separate input and calculation cells, visually distinguish them, and test a fresh copy after making changes to the template. Another is copying a previous invoice and forgetting to replace an old due date, customer address, or line item. A final review against the order or work record is more dependable than assuming the copied document is correct.

Tax errors can arise when a user treats a sample rate as universal or applies a rate to the wrong items. The spreadsheet can multiply a number, but it cannot establish the tax rules for a particular location or transaction. Similarly, a payment term typed into the invoice does not by itself establish that the term is appropriate. Confirm business requirements independently rather than relying on a template’s example text.

Protect the workbook from accidental loss with regular backups and sensible access permissions. Avoid emailing an editable workbook when the recipient only needs a final invoice, unless there is a clear reason to share the working file. Do not store bank logins, full card numbers, or unrelated confidential customer data in the invoice template. When using cloud storage or a shared drive, apply the company’s normal data-handling rules.

Excel versus invoicing software

Excel can be a practical low-cost choice for a freelancer or small company that sends a modest number of straightforward invoices and already has access to Microsoft 365. A basic template has no separate per-invoice charge, though the spreadsheet still takes time to build, check, and maintain. It is flexible, but the business is responsible for tracking sent invoices, payments, reminders, and revisions.

Dedicated invoicing or accounting software may be more useful when several staff members create invoices, the volume is high, customers need online payment options, or the company needs recurring bills and automated reminders. Features and prices vary by provider, so compare the actual plan limits, transaction charges, integrations, data export, and support before choosing. Some businesses use Excel for a draft or analysis and accounting software for the official invoice record.

Excel is not inherently inaccurate, and software is not automatically compliant simply because it is specialized. The key comparison is whether the process reliably produces correct, identifiable invoices and maintains records in a way suitable for the business. If requirements become hard to manage manually, that is a useful signal to review alternatives with an accounting professional.

Frequently Asked Questions

Does Excel have a company invoice template?
Excel may offer templates through its start screen or online template gallery, depending on the app version and account. You can also build a simple layout yourself and save it as an .xltx template. Review any downloaded template carefully before using it.

How do I make an invoice number in Excel?
Enter a unique number in a labeled field and maintain a central record of numbers already issued. A formula in a copied file cannot reliably prevent duplicates across multiple users or workbooks, so use a controlled numbering process.

Can Excel automatically calculate tax on an invoice?
Yes. A formula can multiply a taxable subtotal by a rate entered in a cell. The calculation does not determine which items are taxable or which rate applies; confirm those details for your situation before sending the invoice.

How do I save an Excel invoice as a PDF?
In Excel for Microsoft 365 on Windows, use File > Export and choose the PDF option, or use File > Save As and select PDF as the file type. Review the print layout first. Menu details can vary in Excel for Mac and Excel for the web.

Should I send the Excel file or a PDF?
A PDF is often preferable when the customer needs a fixed, readable invoice rather than editable formulas and cells. Keep the workbook as your working copy, and follow your company’s recordkeeping and security procedures for both files.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.