Invoice and Packing List Template in Excel: What to Include

How-to basics · Updated November 20, 2026

Yes. An invoice and packing list template in Excel can be made as two clearly labeled worksheets in one workbook: the invoice records amounts due, while the packing list identifies the goods and packages being shipped. Use separate layouts, consistent item descriptions and quantities, and simple formulas for totals; check the finished documents against the order before sending or printing them.

What the Two Documents Are For

An invoice is a request for payment and a record of a sale. It commonly identifies the seller and buyer, gives an invoice number and date, describes the products or services, and shows quantities, prices, applicable charges, and the amount due. The exact fields depend on the transaction and the parties’ requirements.

A packing list accompanies a shipment and helps people identify and check its contents. It usually describes the goods, quantities, package count, and sometimes weights, dimensions, or marks that identify cartons. It is not a substitute for an invoice: a packing list generally does not show unit prices or the amount payable. In international trade, a commercial invoice has a distinct role in shipping and customs processes, so do not assume an ordinary sales invoice is sufficient for every shipment.

The two documents can share basic details, such as the seller, buyer, order reference, and product descriptions. Keeping them on separate worksheets makes it easier to tailor each document to its purpose and avoid showing prices on a document intended for packing or warehouse checks.

Suggested Workbook and Worksheet Layout

Create a workbook with worksheets named Invoice and Packing List. Put the shared order details near the top of each sheet, and place the item table below. A practical invoice header can include:

  • Seller name and contact details, and buyer or bill-to details.
  • Invoice number, invoice date, payment terms, and a purchase-order or order reference if applicable.
  • Ship-to address when it differs from the billing address.
  • Currency and any relevant shipping or other charge descriptions.

For an invoice table, use columns such as Item or SKU, Description, Quantity, Unit Price, and Line Amount. Put subtotal, any applicable tax or other charges, and the final amount due beneath the item rows. Keep the currency visible in the column heading or near the totals; a number such as 125.00 is ambiguous without a currency context.

On the Packing List worksheet, consider columns for Package or Carton Number, Item or SKU, Description, Quantity in Package, and optional Net Weight, Gross Weight, and Dimensions. Add the total number of packages and total quantities near the bottom. If the shipment has several cartons, listing the items by carton makes it easier to compare the sheet with the physical shipment. Include weight units and dimension units in headings rather than leaving readers to guess.

Build the Invoice Formulas

In Excel for Microsoft 365 on Windows, enter the labels and item rows first, then add formulas to calculate line amounts and totals. For example, suppose the invoice table uses rows 2 through 21, with Quantity in column C, Unit Price in D, and Line Amount in E. Put this formula in E2 and fill it down through E21:

With quantity in C2 and unit price in D2, enter =C2*D2 in E2. If the row has 3 units at 12.50 each, the result is 37.50.

With line amounts in E2:E21 and the subtotal cell in E22, enter =SUM(E2:E21). If the only populated line amounts are 37.50 and 20.00, the subtotal is 57.50.

Any tax calculation should reflect the rate and rules that apply to the transaction; Excel cannot determine those rules for you. As a purely illustrative example, if E22 contains a subtotal of 57.50 and B24 contains a tax rate entered as 8%, put this in E24: =E22*B24. The result is 4.60. With the subtotal in E22 and tax amount in E24, put =SUM(E22,E24) in E25 for a total of 62.10. Label each amount clearly, and do not add a tax line automatically if it does not apply.

These examples use ordinary cell references, so they work in current Excel versions. If you change the columns or row numbers, adjust the references to match. For a changing number of line items, an Excel table can make the item area easier to extend, but verify that copied formulas and print settings include any new rows.

Build the Packing List Totals

A packing list can use formulas too, even though its main purpose is not billing. Suppose package quantities are in column D, from D2 to D21, and the total-quantity cell is D22. Enter =SUM(D2:D21) in D22. If the listed packages contain 4, 6, and 2 units, the formula returns 12 units. Label the result Total units so it cannot be mistaken for a package count.

Package count may be entered directly when each physical carton is identified individually. If a shipment has cartons numbered 1 through 4, for example, state 4 total packages. Do not calculate package count by adding quantities of products: one carton may contain many items, and an item quantity is not the same thing as a number of cartons.

For weights, agree on a consistent unit and say whether the value is net or gross. Net weight refers to the goods without packaging; gross weight includes packaging. If some lines have no weight entered, a sum can look complete while being incomplete in practice, so confirm every package before relying on a workbook total.

Formatting, Printing, and Saving

Readable formatting is part of a useful template. Use bold labels for document titles and totals, consistent date and currency formats, and enough column width for descriptions and addresses. Avoid relying on color alone to distinguish important information, because documents may be printed in black and white or read by someone who cannot distinguish the colors.

Before sharing, check the print preview for each worksheet. On Windows, use File > Print to review how the sheet will print. Set the print area and page orientation if needed, and avoid shrinking a wide table so much that text becomes unreadable. The Page Layout tab contains print-related options such as orientation and margins. Excel for Mac has comparable print and page-layout controls, though ribbon placement can vary by version; Excel for the web also has printing, but some page setup controls are more limited than in the desktop app.

Save a reusable blank master separately from completed transaction copies. Use a clear file name or invoice number, and export or print a PDF when a fixed, easy-to-view copy is needed. Reopen the PDF or preview it before sending: check that every item row, address, total, and page is present. A spreadsheet can recalculate when edited, while a PDF is less likely to change accidentally after distribution.

How to Choose or Adapt a Template

A prebuilt Excel template can save setup time, but inspect its structure instead of assuming it fits your process. Microsoft Excel may offer templates through its start screen or File > New, and other providers may offer downloadable workbooks. Availability and design vary. Before entering real customer information, check formulas, hidden rows or sheets, print layout, and whether the document includes fields your business does not use.

Choose a template based on the transaction, not on visual appearance alone. Ask whether it can represent your currency, item identifiers, shipping details, discounts or charges, and any fields required by your buyer or internal workflow. An invoice template intended for services may not work well for cartons of physical products. A packing-list layout should make package contents easy to verify, not just look like a second invoice.

Adapt a copy rather than overwriting a clean master. Test it with a small fictional order: enter a few items, check each line extension and the totals, and see whether long descriptions or multiple packages print correctly. If a buyer, carrier, freight forwarder, or other recipient supplies a required format, follow that specification rather than forcing the information into a generic design.

Common Errors and Checks Before Sending

Many spreadsheet mistakes come from mismatched details rather than complicated formulas. A short review against the order and the shipment can catch errors before the documents are sent. Check these points:

  • Invoice and packing list show the same buyer, order reference, item identifiers, descriptions, and shipped quantities where those details overlap.
  • The invoice number and dates are correct, and the amount due agrees with the line calculations and stated charges.
  • The packing list describes what is actually in the packages, with package identifiers and units that match the physical shipment.
  • Currency, measurement units, and net or gross weight labels are explicit.
  • No formula cell was replaced by a typed value, and no item row was left outside the total range.
  • The final print or PDF includes all rows and does not expose internal notes or unrelated worksheet content.

A common misconception is that one document can always serve both purposes. Some businesses may combine information when their customer or process accepts it, but a combined sheet can expose prices to people who only need packing information and can make package checking less clear. Separate worksheets or separate files are often easier to control. Also, a formula producing a plausible total does not prove that the right quantities, rates, or tax treatment were entered.

Privacy and File Handling

Invoices and packing lists can include names, addresses, order details, and commercially sensitive information. Share only the necessary document with the intended recipient, and review the workbook for extra sheets, comments, or notes before sending the Excel file itself. A PDF can be a better choice when the recipient only needs a read-only document, but it should still be sent through an appropriate channel.

Protecting a worksheet from accidental edits can help with a reusable form, but worksheet protection is not the same as secure encryption or access control. Do not treat a protected sheet as a way to keep sensitive data secret. Store the master and completed files according to your organization’s normal access and retention practices.

Frequently Asked Questions

Can I use one Excel template for both an invoice and a packing list?
Yes, you can keep both documents in one workbook, preferably on separate worksheets. They share some order details, but the invoice needs pricing and payment totals while the packing list focuses on physical contents and packages.

Does a packing list include prices?
Usually, a packing list is focused on shipment contents rather than prices. Requirements differ by transaction and destination, so follow the recipient’s or shipping process’s instructions. A commercial invoice used in international shipping is a separate document with its own purpose.

How do I calculate an invoice total in Excel?
Multiply each row’s quantity by its unit price, sum the line amounts for a subtotal, then add applicable charges in separate labeled cells. Check the formula ranges and the transaction’s actual requirements; a spreadsheet formula does not decide whether a charge or tax applies.

Can I print each worksheet on one page?
Sometimes, depending on the number of rows and columns. Check File > Print and the page preview, then adjust orientation, margins, or scaling. Forcing a long list onto one page can make text too small, so multiple readable pages may be preferable.

Should I send the Excel workbook or a PDF?
Send Excel when the recipient needs to work with the data or has requested a spreadsheet. A PDF is often convenient for a fixed copy that is easy to view and print. Confirm the recipient’s preferred format and inspect the final file before sending.

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.