Free Packing Slip Template
Our new Packing Slip spreadsheet is for businesses using our sales invoice template that have requested a corresponding packing slip. 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. Also, a packing slip lets you indicate whether the customer should expect multiple boxes and whether items are on backorder.
Packing Slip Template
for Excel, OpenOffice, & Google Docs
THEME-ENABLED
Excel 2010 Version
Get Excel 2010 Version
Microsoft Excel® 2002(XP) or Later
License
View Agreement
(not for distribution or resale)
Questions?
Contact Us >
Get OpenOffice Version
Google Docs Version
This Packing Slip spreadsheet is a simple and easy (and free) tool for printing packing slips. It was designed to work with and compliment our purchase order and sales invoice templates.
If you wanted to get really fancy, you could copy the Packing Slip worksheet into the sales invoice workbook and link up the cells so that when you create a new invoice, most of the packing slip info is updated automatically.
"No Installation, No Macros - Just a simple spreadsheet - An original creation by Dr. Jon Wittwer of Vertex42.com"
Rate and Review this Packing Slip Template
Using the Packing Slip Template
Using the packing slip template is pretty intuitive, but there are a couple things you should be aware of. First, the date in the upper right uses the =TODAY() function which will always display the current date. If you want to save an archival copy of your packing slip, you may want to manually enter the date so that it doesn't change when you open the file again. Second, you can insert rows for more items, but afterwards you should check the Totals to make sure they reference the correct cells.
Comments: The comments block is for including notes to your customer. Instead of making one large cell for the comment block like many other packing slip templates, each line is a separate cell so you can easily add/delete common comments. For example, if you wanted a backorder note to show up automatically when the shipping quantity is less than the order quantity you could use the following formula:
=IF(G38<F38,"Backordered items will ship as they become available","")
Tip: Outside of the printing area, you could list some of the common comments that you use so that you can simply copy/paste the appropriate notes into the comments block.
More Free Packing Slip Templates
You can find quite a few more examples of packing slips in the Microsoft Office template gallery: click here.
