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 Separate Worksheet. Double-click the downloaded file to extract all files.
  2. Open the template "invoice-and-packing-list-on-separate-worksheet.xlsx" or "invoice-and-packing-list-on-separate-worksheet-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 Separate Worksheet

Invoice and Packing List on Separate Worksheet (c4080)

c4080 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-separate-worksheet-uis.xlsx.

Invoice and Packing List on Separate Worksheet (UIS Edition)

Invoice and Packing List on Separate Worksheet - UIS edition

Download Invoice and Packing List on Separate Worksheet (c4080)

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.

338 KBDownload

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

2.82 MBDownload

Detail

This shipping packing slip template is designed for small business that sells and ships goods. Unlike our previous designs of pack list templates for shipping goods, this template implement the packing slip form in a separate form but within the same Excel template as the invoice form.

On InvoicingTemplate.com we've already released several samples of packing list templates. For example, the basic Packing List Template (cn010), which demonstrates how to modify an existing invoice form to create a packing list template; and Invoice and Packing List on Same Form (c4078), which puts the packing list (named Delivery Docket) and invoice on the same "Invoice" worksheet, so that the packing list and invoice is printed at the same time whenever you issue the "Print" command; and General Waybill (c3010), which also implements a general purpose packing slip / waybill in a standalone Excel spreadsheet template.

This template differs from our existing packing slip template in that we put the packing slip (waybill) in a separate worksheet, but within same Excel template as the invoice form. The advantages of this approach is that - you don't have open another template for the purpose of printing a packing slip (like what we implemented in c3010 and cn010), or you don't have to always print an invoice and a packing list together (like c4078). Since we place the packing list form in a separated worksheet, we can define its own "Print_Area", and print the number of copies as needed - for example, print one invoice, and then print 2 copies of packing list.

In this sample, we use Invoice and Packing List on Same Form (c4078) as the basic invoice template, move the packing list to a separate form. The main steps are illustrated below.

  1. Remember to back up the template before modifying it.
  2. Open the template and switch to design mode by clicking the "Design Mode" button on the "Invoice" worksheet.
  3. Click the "+" button (i.e. the "New Sheet" button) next to worksheet names on the bottom of the Excel window.
  4. Excel adds a worksheet which is automatically named "Sheet1".
  5. Click the worksheet name "Sheet1" twice to rename it. In this sample, we name it "Packing List".
  6. Activate the "Invoice" worksheet by clicking its worksheet name.
  7. Drag your mouse to select the entire packing list form, ranging from D50 to L91.
  8. Press "CTRL+C" on keyboard to copy the selected area.
  9. Activate the packing list worksheet.
  10. Click the cell B5 (You can choose another cell. This is just the starting cell of our new packing list form).
  11. Click the "down arrow" of the "Paste" command in the "Clipboard" group of the "Home" ribbon tab. Click "Keep Source Column Width". Excel pastes the formats of the original form, and shows lots of "#REF" errors - simply ignore the errors for now.
  12. Click the "down arrow" of the "Paste" command again. Click "Paste Link". Now all cell values are pulled from the original packing slip form. The worksheet shows lots of "0" (zero) values since many cells in the original form have no content. To hide the zero values:
    • Click the "File" menu and then choose "Options".
    • Choose "Advanced" in the left pane.
    • In the "Display options for this worksheet" section, uncheck the "Show a zero in cells that have zero value".
    • Click OK.
  13. With the "Packing List" worksheet is still activated and the new packing list form is selected, go to the "Page Layout" ribbon tab, click "Print Area" and then "Set Print Area".
  14. Go the "Invoice" worksheet, select the entire form for the invoice. In this case, it is D2:L47. From the "Page Layout" ribbon tab, click "Print Area" and then "Set Print Area". This redefines the printable area of the "Invoice" worksheet to exclude the packing list below it, since we'll no longer want to print one invoice and one packing list together. However don't remove the packing list form under the invoice form, since the cells on the "Packing List" worksheet is referencing to it. However you can hide the entire packing list form under the invoice form.

    You can also go through the steps detailed in Invoice and Packing List on Same Form (c4078), but place the new packing list form on a separate sheet. This way, you'll avoid the packing list form under the invoice form altogether.

  15. Exit design mode.
  16. Save the template by clicking the "Save" command on Excel quick access toolbar.

Packing list and invoice are closely related business documents, yet there are significant differences between the two, in both the recipients of the document, the contents each document show include. A packing list is designed to aid recipients of the shipment in confirming that all items that were supposed to be included in the shipment have actually arrived. While slip designs vary somewhat, most will include a description of each item included, as well as the quantity of each item shipped. On the other hand, an invoice goes to the person responsible for paying the bill. The invoice is the bill for purchasing from your company and the notice to the customer to pay you.

While a packing slip can provide a great deal of detail, it normally does not serve as a bill of lading or an invoice. Some businesses choose to include a copy of the invoice with the shipment, but that can create confusion if the customer has already paid for the items. With our templates and the help from Uniform Invoice Software, you can easily create a packing list or way bill with several mouse clicks. Feel free to download the full functional trial version and see how it works for you.

Like other form designs here on InvoicingTemplate.com, Invoice and Packing Slip on Separate Worksheet 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#c4080
NameInvoice and Packing List on Separate Worksheet
CategorySales Invoice Template
Release DateSunday, July 10, 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$A$2:$L$47
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top40.32
Bottom23.04

Sample Templates