An invoice order template in Excel is a reusable worksheet for recording what a customer ordered, calculating the amount due, and presenting payment details. You can make one with a header, numbered item rows, and formulas for line totals and the invoice total; keep in mind that an invoice requests payment, while a purchase order is generally a buyer’s request to purchase goods or services.
What an Excel invoice template is for
A spreadsheet template gives you a consistent layout for preparing invoices without retyping the same business details each time. You enter the customer, invoice date, items, quantities, and prices, while formulas handle arithmetic. Excel is useful when you want to adjust the design, keep a simple record of issued invoices, or print or save each completed invoice as a PDF.
The phrase “invoice order” can refer to different documents. An invoice is normally sent by a seller to request payment for goods or services supplied, or as otherwise agreed. A purchase order is normally issued by a buyer to describe an order and its terms. A sales order is a seller-side record of an order, and is not automatically a bill. Before choosing a template, check which document the other party has asked for.
A basic Excel invoice is best suited to straightforward billing. If you need automatic stock tracking, multiple currencies, approval workflows, recurring billing, or a complete audit trail, a dedicated accounting or order-management system may be more appropriate. Excel can still be useful for a small number of invoices, but it does not by itself send, collect, or reconcile payments.
Information to include
A readable invoice lets the customer identify who sent it, what is being billed, how much is due, and how to pay. Exact requirements vary by location, industry, contract, and tax status, so treat a general template as a starting point rather than a guarantee of compliance. Consider including:
- Your business name and contact details, plus the customer’s name and billing address.
- A unique invoice number, invoice date, and payment due date or agreed payment terms.
- A clear description of each product or service, quantity, unit price, and line amount.
- Subtotal, any applicable discount or tax, and the final amount due, with the currency identified.
- Payment instructions, such as accepted payment methods, and a contact for billing questions.
- Relevant order or reference numbers, delivery details, or other information agreed with the customer.
Use clear labels and avoid relying on color alone to distinguish amounts or status. If your business charges tax, confirm the correct rate, treatment, and invoice wording for the transaction with an appropriate tax authority or qualified professional. Do not assume that a formula in Excel determines whether tax applies.
How to build the worksheet
In Excel for Microsoft 365 on Windows, open a blank workbook and set up a single worksheet named Invoice. Reserve the top rows for the seller and customer details, then place the invoice number and dates in a separate area. Put the item table below, with one row per product or service. Leave enough space for a subtotal, tax if applicable, and total. Using distinct cells for labels and values makes the sheet easier to read and update.
For example, use columns A through D for the item table: A for description, B for quantity, C for unit price, and D for line amount. Put the first item on row 10 and allow rows 10 through 19 for up to ten items. In this layout, with quantity in B10 and unit price in C10, enter =B10*C10 in D10 to calculate that item’s amount. Copy the formula down through D19. A blank item row will calculate as zero, which is usually harmless, but you can leave unused rows empty when preparing the final invoice.
Put the subtotal label in C20 and the subtotal amount in D20. With line amounts in D10:D19, enter =SUM(D10:D19) in D20. For a simple example, if the line amounts are 30, 25, and 10, the subtotal is 65. Check that the quantities and unit prices are entered as numbers, not text; text values may not calculate as expected.
If you need a tax calculation, first confirm the applicable treatment. For an illustrative layout only, enter a tax rate as a decimal in C21, such as 0.08 for 8%, and put the tax amount in D21. With the subtotal in D20 and the rate in C21, enter =D20*C21 in D21. A subtotal of 65 at an illustrative 8% rate produces 5.20. Put the grand total in D22; with the subtotal in D20 and tax amount in D21, enter =D20+D21 in D22. That example totals 70.20 before any other adjustments. If discounts, shipping, or tax rules apply, represent them explicitly and verify the calculation rather than treating this simple example as universal.
Make it readable and reusable
Format the sheet so the customer can scan it quickly. Select the relevant cells and use Home > Number Format to apply currency or number formats. Choose the currency that matches the invoice; a currency symbol by itself can be ambiguous when doing business internationally. Format dates consistently, use bold text for headings and the amount due, and apply borders to separate the item table from the totals.
To make the template easier to reuse, keep fixed business details in the worksheet and distinguish them visually from fields that change for each invoice. Add a note or a subtle fill color to entry cells, but remove internal instructions from the customer-facing copy. Protecting formula cells can reduce accidental edits, though sheet protection is not a substitute for a secure records system. Before sending an invoice, review every description, quantity, price, date, and customer detail.
Set the print layout before relying on a paper copy or PDF. In Excel for Microsoft 365 on Windows, use Page Layout > Orientation to choose Portrait or Landscape, and Page Layout > Margins to adjust margins. Select the invoice range and use Page Layout > Print Area > Set Print Area if you want only that area printed. Check the result with File > Print. On Windows, Ctrl+P opens the print screen; on Mac, Command+P is the corresponding shortcut. Menu labels and dialog details can vary slightly across platforms. If the sheet spills onto extra pages, adjust scaling carefully and confirm the text remains legible.
Invoice numbering and recordkeeping
Give each issued invoice a distinct identifier so you and the customer can refer to the same document. A simple scheme might use a year and sequence, such as 2026-001, followed by 2026-002. This is an example, not a required format. Avoid reusing a number for a different invoice, and decide how your business will handle cancelled or corrected documents before sending them.
A template is not an invoice register. Keep a separate, backed-up record of issued invoices, including the invoice number, customer, date, amount, and payment status if those fields help your workflow. Save each issued version with a clear filename, for example, the invoice number and customer name. If you edit a template after sending an invoice, the saved copy should preserve what the customer actually received. A spreadsheet can be changed, so retain records in line with your business procedures and applicable record-retention requirements.
Common mistakes to avoid
Many invoice errors come from confusing a polished layout with a checked transaction. A formula can multiply the wrong cells perfectly accurately, and an invoice with a correct grand total can still contain the wrong customer or quantity. Review the source order, agreement, or delivery record before issuing the document.
- Mixing up document types: Confirm whether the request is for an invoice, purchase order, or sales order before filling in a template.
- Overwriting formulas: Keep formula cells visually distinct and test a copy of the template with sample entries before using it.
- Using inconsistent currency or units: Label currency and units clearly, especially when quantities are hours, packages, or fractional amounts.
- Assuming tax is automatic: A spreadsheet calculates the rate you enter; it does not determine the correct tax treatment.
- Sending the working template: Remove internal notes and check the print preview or exported PDF for clipped text and blank pages.
- Editing an already issued invoice without a record: Keep the version sent and follow an appropriate correction process if details must change.
Excel template versus accounting software
An Excel template offers flexibility and a low setup burden if you already have Excel and issue a modest number of uncomplicated invoices. You control the layout, formulas, and file storage. The trade-off is that you must manage numbering, customer records, backups, payment tracking, and error checks yourself. Formulas can be accidentally changed, and a workbook does not provide the same purpose-built workflow as invoicing software.
Accounting software may be a better fit when you need invoice delivery, payment links, recurring invoices, automatic reminders, tax reports, or a shared ledger. Those features, pricing, and data-handling terms vary by provider and plan, so compare the actual product details. A template downloaded from a third party can also save setup time, but inspect its formulas and remove unfamiliar macros or external links before entering business or customer information. A familiar-looking design is not proof that a workbook is safe or correct.
Frequently Asked Questions
Does Excel have a free invoice template?
Microsoft and other providers may offer downloadable templates, and availability can change. Search Excel’s template options or a trusted provider, then review the layout, formulas, and terms before using a file. You can also create a basic invoice yourself using the steps above.
Is an invoice the same as a purchase order?
No. An invoice is generally a seller’s request for payment, while a purchase order is generally a buyer’s order document. Their purpose and timing differ, so use the document type requested by the customer or supplier.
How do I calculate an invoice total in Excel?
Calculate each line as quantity multiplied by unit price, sum the line amounts for a subtotal, then add applicable tax or other charges and subtract any discounts. Check that the layout and tax treatment match the transaction before sending the invoice.
Can I save an Excel invoice as a PDF?
Yes. In Excel for Microsoft 365 on Windows, use File > Save As or File > Export and select PDF, depending on the available options. Review the print preview and selected sheet or print area first. On Mac, use the available PDF option in the print or save workflow.
Should I use one worksheet for every invoice?
A reusable template plus a separate saved file for each issued invoice is straightforward for a small workflow. If you use one workbook for many invoices, organize records carefully and avoid changing an issued invoice’s saved details. For more extensive tracking, consider a dedicated invoicing system.
Related
- How to Unhide Columns in Excel: Shortcut Key Guide
- Ungroup Worksheets in Excel: Shortcut and Quick Fixes
- Ungroup Cells in Excel: Keyboard Shortcut and Steps
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Current Timestamp: Insert or Update ItTo show the current date and time in Google Sheets, enter =NOW() in a cell. It updates when…
- Merge Cells in Excel: Keyboard Shortcuts and StepsIn Excel for Microsoft 365 on Windows, select the cells and press Alt+H, M, C—one key sequence at…
- Outlook Calendar Template: Create and Reuse EventsTo create a reusable calendar template, make an appointment in classic Outlook for Windows, then choose File >…
- Compare Two Columns in Excel Without Matching RowsTo compare two columns as unordered lists—not by checking cells on the same row—test whether each value in…
- Excel Find Shortcut Key: Search Cells FastIn Excel for Microsoft 365 on Windows, press Ctrl+F to find text or numbers in a worksheet. On…
- Create a New Signature in Outlook 365, Step by StepTo create a new signature in Outlook 365, open the signature settings for your version of Outlook, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.