Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Invoice and Packing List on Same Form. Double-click the downloaded file to extract all files.
  2. Open the template "invoice-and-packing-list-on-same-form.xlsx" or "invoice-and-packing-list-on-same-form-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Invoice and Packing List on Same Form

Invoice and Packing List on Same Form (c4078)

c4078 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open invoice-and-packing-list-on-same-form-uis.xlsx.

Invoice and Packing List on Same Form (UIS Edition)

Invoice and Packing List on Same Form - UIS edition

Download Invoice and Packing List on Same Form (c4078)

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

327 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.82 MBDownload

Detail

A shipping packing list is also called delivery docket, it shows what goods included on shipment, also serve as a bill of lading. It is naturally close related to invoices. In this sample template we demonstrates how to create a packing list and an invoice within one same form.

The packing slip template here on Invoicing Template shows you how to create a standalone pack list template. With the help of Uniform Invoice Software, you can easily loaded an existing invoice using the packing list template, and thus to print the packing list for shipment using the packing list template. If you always have the need to print both an invoice and a packing list at the same time, then consider to have both documents - invoice and packing list, on the same form, as shown in this sample.

In this template sample, we will use c4074 Simple Invoice Template for Letterhead Paper as the basic template, and add a packing list to the same form on the "Invoice" worksheet, so that when an invoice is printed a corresponding packing list will be printed too.

To archive this goal, we first have to copy the existing invoice design to create a new form, and then modify the new form to make it suitable for packing lists. And finally, we modify the definition of the printable form, to have Excel print both documents (the invoice and the packing list) at the same time.

Let's see the detailed procedures and steps involved in this customization.

  1. First, backup the template that you want to customize. It seems redundant that we repeat this in every tutorials targeted to simple invoice template customizations. But it is important and highly recommended that you do so. Baking up data frequently saves you a lot time and efforts when the newest version of data is lost.
  2. Open the template.
  3. Switch to design mode by clicking the "Design Mode" button on the "Invoice" worksheet.
  4. Pull down the name box located on the left-end of the formula bar. On the end of the name list you'll find "Print_Area". Click to select it.
  5. Excel select all the cell defined by the "Print_Area" name. This is the printable area that is printed when you print the current worksheet.
  6. On Excel "Home" ribbon tab, click "Copy" in the "Clipboard" group. This copies the entire printable invoice form to the clipboard.
  7. Choose an empty area underneath the existing printable form. In this sample, our original printable area is defined at D2:L47, so we click and select D50, this will be our starting cell of the new packing list form.
  8. On Excel "Home" ribbon tab, pull down "Paste" in the "Clipboard" group and then choose "Paste All".
  9. Now the key step - pull down "Paste" in the "Clipboard" command group again, chose "Paste Link" in the "Other Paste Option" section. This will create a simple formula for each cell in the paste destination section. The simple formula retrieves data from the original printable form (the invoice form), fill it in the packing list section. This way, if we you fill in the invoice data, either manually or loading an existing invoice from database by using Uniform Invoice Software, the data of the packing list is automatically filled.
  10. Till now our new packing list form has exactly the same format and content as the invoice. Modify it to make it meets your requirements of packing slip. For example, change the title from "Tax Invoice" to "Delivery Docket".
  11. In this sample, we also clear the "Price" and "Amount" column, and then expand the "Description" column.
  12. With this sample template, we also cleared the bottom section that details "Freight", "GST", "Total Incl. GST" etc., as they are usually not required on a packing list.
  13. Add your notes and declarations to the form, usually bottom of the form.
  14. It is also common to add fields for manually singed. For example, we added "Signed", "Sign Date", "Print Name" and "Print Date".
  15. Once the design of the packing list is finished, select all the cells inside the packing list. Lock all the cells.
  16. Now once again, select "Print_Area" from the name box on the left end of the formula bar. This selects the original printable area.
  17. Now push down the CTRL key on the keyboard, drag mouse to select the new packing list area - in this sample, it is D50:L92.
  18. Release keyboard CTRL key.
  19. With both the invoice and packing list form selected, from Excel "Page Layout" ribbon choose "Print Area", and then "Set Print Area". This define the new printable form. As you can see, the print area could be discrete area that contains multiple ranges.
  20. Go to Excel menu File / Print Preview. Make sure the worksheet will be printed on 2 pages.
  21. Exit design mode once you have done the customization.
  22. Save the template.

Now when you click Print to print an invoice, Uniform Invoice Software will print two documents, one invoice and one packing list. However the "Extract" feature will encounter problems if you choose the exact an Excel-format worksheet - but the PDF formatted invoice and packing list work just fine. Feel free to take a look of our pdf invoice template gallery too.

To overcome the drawback of having to always print the two documents (invoice and packing list) at the same time (well, someone see this as drawback, others may find it handy), place the packing list on another worksheet. This way, the packing list worksheet can have its own "Print_Area" definition, and thus could be printed separately. We'll address this with another tutorial.

Like other form designs here on InvoicingTemplate.com, Invoice and Packing Slip on Same Form is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

Template#c4078
NameInvoice and Packing List on Same Form
CategorySales Invoice Template
Release DateWednesday, July 6, 2016
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns4
Lines20
Line Height (Points)15.00
Print Area$D$2:$M$47,$D$50:$L$92
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top40.32
Bottom23.04

Sample Templates