A basic invoice template in Excel can be made with invoice and customer details, a line-item table, and formulas for line totals, subtotal, tax, and amount due. In Microsoft Excel for Microsoft 365 on Windows, put item quantities in column C, prices in column D, and use =C13*D13 in E13 to calculate the first line total; then copy the formula down for the other items.
What a basic Excel invoice should include
An invoice is a record of a sale and a request for payment. A useful template makes it clear who is billing whom, what was supplied, how much is owed, and when payment is due. The exact requirements can vary by country, industry, and transaction, so treat a general spreadsheet as a starting point rather than a guarantee that it meets every local rule.
Include the following information where it applies to your business:
- Your business name and contact details, and the customer’s name and billing address.
- A unique invoice number and the date the invoice was issued.
- A description of each product or service, its quantity, unit price, and line total.
- The subtotal, any applicable tax or discount, the final amount due, and the currency.
- Payment instructions, accepted payment methods, and a due date or payment terms.
- Other details relevant to the transaction, such as a purchase order number or service period.
Do not add sensitive information that is unnecessary for collecting payment. For example, a basic invoice normally does not need a customer’s account password or full payment-card number. If you have specific disclosure or record-keeping obligations, check the rules that apply to your business.
A practical worksheet layout
Keep the invoice readable on a single worksheet. One straightforward arrangement is to use columns A through E, with the first few rows for the business and customer details, and the lower half for the items. Put labels in column A or D and the corresponding details beside them. For example, use A4 for “Invoice number,” B4 for its value, D4 for “Invoice date,” and E4 for its value. Use similar paired cells for customer name, address, due date, and payment terms.
Start the item table around row 12. Use A12 for Item or service, B12 for Description, C12 for Quantity, D12 for Unit price, and E12 for Line total. Enter items in rows 13 through 22. Put the subtotal in E24, the tax rate in B25, tax in E25, and the amount due in E26. The spaces between the item list and totals help distinguish the details from the amount the customer needs to pay.
Use a separate invoice number for each invoice and keep the numbering consistent, such as INV-1001, INV-1002, and so on. Avoid relying on a row number or a formula that changes whenever rows are sorted: once an invoice has been sent, its identifying number should remain stable. Save a fresh copy for each customer or transaction so the original template stays blank.
Formulas for line totals and invoice totals
In the layout above, quantity is in C13:C22 and unit price is in D13:D22. With those cells holding the first item’s quantity and unit price, enter =C13*D13 in E13. Copy it down through E22 using the fill handle at the bottom-right corner of E13, or copy and paste the cell. Each row then multiplies its own quantity by its own price. For example, two units at $18 produce a line total of $36.
With the line totals in E13:E22, enter =SUM(E13:E22) in E24 to add them. Suppose the invoice lists two items at $18 each, one item at $45, and three items at $6 each. The line totals are $36, $45, and $18, so this subtotal formula returns $99.
If B25 contains a tax rate entered as a percentage, such as 8.25%, and E24 contains the subtotal, enter =E24*B25 in E25. In the $99 example, the result is $8.1675 before display rounding, or $8.17 when shown as currency with two decimal places. This example only demonstrates spreadsheet arithmetic: whether tax applies, which rate to use, and how rounding should be handled depend on the transaction and applicable rules.
With the subtotal in E24 and the tax amount in E25, enter =SUM(E24:E25) in E26 to calculate the amount due. In the example, the underlying result is $107.1675, displayed as $107.17 with two decimal places. Check the expected calculation and rounding for your own invoicing process, especially if your accounting system rounds each line separately.
Formatting amounts, dates, and labels
Format amounts consistently so a customer can distinguish money from quantities. Select the unit-price and total cells, then use Home > Number Format dropdown > Currency or Accounting in Excel for Microsoft 365 on Windows. Choose the currency that applies to the invoice; a dollar symbol alone does not identify whether the amount is in US, Canadian, Australian, or another dollar currency. If an invoice contains more than one currency, make that distinction unmistakable and do not combine unlike amounts into one total.
Format the tax-rate cell as a percentage and the invoice and due-date cells as dates. The Home tab’s Number Format dropdown includes common date formats. Use a date style that is clear to the recipient: for example, “3 Nov 2026” avoids the ambiguity of numeric dates that can be read differently in different regions. Bold the column headings and final amount, use a restrained fill color for headings, and keep sufficient contrast for printing.
Give columns enough width for descriptions and addresses, and use Wrap Text where a longer description should occupy more than one line. Avoid merging cells throughout the item table: merged cells can make sorting, selecting, and copying data harder. A simple border below the column headings and above the totals is usually easier to maintain than a border around every character-sized cell.
Tax, discounts, and other adjustments
A basic template can handle a single tax rate applied to the subtotal, but that is not appropriate for every invoice. Some transactions may be exempt, involve different tax rates, or require tax to be calculated on a different basis. Do not assume Excel’s result establishes the correct tax treatment. Confirm the applicable rate and method using authoritative guidance or a qualified tax professional.
If you give a discount, show how it is calculated and whether it applies before or after tax. A simple fixed discount can be entered as a separate amount, but the total formula must then include that amount with the correct sign and order of operations. For instance, subtracting a discount from the subtotal before calculating tax produces a different result from subtracting it after tax. Make the invoice labels explicit and verify the calculation rather than hiding an adjustment inside a unit price.
Other possible adjustments include shipping, deposits already paid, or fees agreed with the customer. Add a clearly labeled row for each relevant item, and make sure the amount due reflects whether it is being added or deducted. If the invoice has complicated tax rules, multiple currencies, recurring billing, or many adjustments, a dedicated accounting or invoicing system may be safer than a manually maintained workbook.
Payment terms and invoice dates
State the payment due date or the terms that determine it. A phrase such as “due within 30 days” is useful only if the date from which the period is counted is clear. You can enter a due date manually, which is often the simplest option for a reusable template, or calculate it from the invoice date after confirming the terms you actually use. If a customer has agreed to a different schedule, show that agreement accurately rather than relying on a generic default.
List practical payment instructions, such as the payment methods accepted and any reference the customer should include. Do not place banking details in a workbook shared more broadly than necessary. Before sending an invoice, check the customer’s name, contact details, invoice number, issue date, due date, currency, line descriptions, and payment instructions. A clear invoice reduces avoidable back-and-forth, but it cannot ensure that a customer pays on time.
Printing, saving, and reusing the template
Check the printed or PDF version before sending it. In Excel for Microsoft 365 on Windows, select the invoice range and use Page Layout > Print Area > Set Print Area. Use File > Print to inspect the preview and adjust scaling or orientation if the invoice spills across pages. The Page Layout tab also provides page setup options such as margins and orientation. Keep text legible; shrinking a wide worksheet to one page can make the invoice too small to read.
For a PDF copy in Windows, use File > Export > Create PDF/XPS Document, or use the PDF option available from the print workflow. Excel for Mac and Excel for the web have different menu layouts; on Mac, use the available File export or print-to-PDF options, and in the web app use its print or download options. Check the resulting PDF because page breaks and scaling can differ from the worksheet view.
Keep an untouched master workbook and create a new copy for each invoice. If you want a reusable Excel template file in the Windows desktop app, use File > Save As and choose Excel Template (*.xltx) as the file type. Save completed invoices using a consistent naming scheme, such as the invoice number and customer name, and keep them in an appropriately controlled location. A workbook is easy to edit, so retain the sent version or a PDF copy according to your organization’s record-keeping process.
Common errors and simple checks
Most spreadsheet invoice mistakes are preventable with a short review. Check that formulas extend to every item row, that blank rows are not accidentally included as billable items, and that the displayed total matches the underlying calculation. Test the template with sample data before using it for a real customer. Clear the sample values afterward, but preserve the formulas and formatting.
- Wrong cell references: If a copied formula points to the same quantity or price on every line, check that the row references change as the formula is filled down.
- Numbers stored as text: A quantity or price imported with an apostrophe or unexpected characters may not calculate as expected. Confirm the cells contain numeric values.
- Missing line items: If someone inserts rows below the formula range, the subtotal might not include them. Expand the formula range and retest after changing the layout.
- Unclear rounding: Formatting to two decimal places changes what is displayed, not necessarily the underlying value. Decide how the invoice should round and ensure the displayed line totals and final amount are consistent.
- Overwriting the master: Save a separate invoice copy before entering customer-specific information, and make sure the correct version is sent.
Protecting cells that contain formulas can reduce accidental edits, but worksheet protection is not a substitute for access control or secure storage. If you enable protection, test that users can still enter invoice details and that the intended cells remain editable.
When to use Excel and when to choose another tool
Excel works well for occasional invoices, a small number of line items, and situations where you want control over the layout. It is also familiar to people who already use spreadsheets. Its flexibility is a trade-off: users are responsible for maintaining formulas, preventing accidental edits, tracking invoice status, and keeping records organized.
Invoicing software may be more suitable when you need recurring invoices, automatic reminders, payment links, customer records, multiple tax treatments, or a dependable audit trail. Accounting software can also connect invoicing with bookkeeping, but its features and costs vary. Compare tools based on the tasks you actually need, how they handle your currency and tax situation, data access controls, export options, and whether the workflow fits your business. You can also begin with Excel and move to a specialized system if the volume or complexity grows.
Frequently Asked Questions
Does Excel have a built-in invoice template?
Excel may offer invoice templates through its template gallery, depending on the version and available online templates. You can also create a basic workbook using the layout and formulas above. Review any downloaded template’s formulas, fields, and terms before using it.
How do I calculate tax on an Excel invoice?
For a simple example where the subtotal is in E24 and a percentage tax rate is in B25, enter =E24*B25 in E25. This calculates arithmetic only; verify whether the tax applies and which method and rate are appropriate for your situation.
Can I use the same invoice template for every customer?
Yes, but make a new copy for each invoice and update all customer-specific information. Preserve a blank master, assign a unique invoice number to each issued invoice, and check the saved or exported version before sending it.
How do I save an Excel invoice as a PDF?
On Windows, use File > Export > Create PDF/XPS Document or the PDF option in the print workflow, then inspect the preview and resulting file. The exact options differ in Excel for Mac and Excel for the web, so use the export or print controls available in that version.
Can I send an Excel file directly to a customer?
You can, but a PDF is often easier to view and less likely to have its layout changed accidentally. If you send the workbook, check that it contains only the information intended for that customer and that formulas and sample data are not exposed unintentionally.
Related
- Excel Site Analysis: Methods, Limits, and Examples
- Excel Regression Analysis: Run It and Read the Results
- Excel RAG Analysis: Build a Red-Amber-Green Tracker
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Power Query Filter: How to Filter Rows in ExcelTo filter in Power Query, open the query in Power Query Editor, select the filter arrow in a…
- INDIRECT Excel Function: Examples, Uses, and LimitsIn Excel, INDIRECT converts text into a live cell or range reference; if A2 contains B5, =INDIRECT(A2) returns…
- Excel Formula to Count Cells With Text in Any RangeTo count cells containing text in Excel, use =COUNTIF(A2:A100,"*"), replacing A2:A100 with your range. The asterisk is a…
- Count Days in Excel: Formulas for Dates and WorkdaysTo count calendar days between two dates in Excel, put the start date in A2 and the end…
- Excel Data Table Setup: What-If Analysis and TablesTo set up an Excel what-if data table, create a formula that refers to your model, arrange possible…
- Add a Sort List in Excel: Create a Custom OrderTo add a custom sort list in Excel for Microsoft 365 on Windows, go to File > Options…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.