Packing Slip – Free Excel Template

[vc_row][vc_column][vc_column_text]If you run a business that has heavy communication between the seller and the shipment department or the warehouse where the goods are stored, download this Free Packing Slip Excel Template to make this communication much simpler. You can save time by storing all the products and customer details to create unlimited packing slips and manage them all in one file.

Sample Packing Slip
Sample Packing Slip

In general, a Packing slip carries all the details of the particulars in any shipment. It is an important tool to streamline the shipment process. Once prepared a packing slip is sent to the shipping department to help them construct the shipment with all the items mentioned in the packing slip.

FEATURES

  1. Create a packing slip for your small business
  2. Customize it to your need
  3. Reduce friction between seller and warehouse
  4. Save time by storing customer and product data

REQUIREMENTS

  • Microsoft Excel for Windows (2010 and above)
  • Microsoft Excel for Mac (2011 and above)

DOWNLOADS

Click the link below to download the

FREE TEMPLATE

FREE TEMPLATE WITH SAMPLE DATA

HOW TO USE THE TEMPLATE

INITIAL SETUP

  1. Enter Business Information in Settings sheet
  2. Enter Products in Products sheet
  3. Enter Customers in Customers sheet
  4. Change Logo in Packing Slip sheet
  5. Customize fields in the Packing slip sheet

CREATING PACKING SLIP

  1. Make a copy of Packing Slip sheet
  2. Rename it with Package #.
  3. Follow instructions in Packing Slip sheet
  4. To create another packing slip, make a copy of the original Packing slip sheet and rename it as PACKING #4.

[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_separator][/vc_column][/vc_row][vc_row][vc_column][vc_tta_accordion style=”flat” active_section=”” no_fill=”true” collapsible_all=”true” title=”Support Articles”][vc_tta_section title=”Printing or Exporting to PDF” tab_id=”1614001193156-d423f42f-3932″][vc_column_text]After reviewing and making sure everything looks good, it’s time to print or export.

Press Ctrl+P to preview print.

Print Preview and Print Invoice

The page is set up to be print-friendly. So, you should be able to just print as it is.

To export to PDF, select the Export menu option.

Export to PDF Menu Option

In the following window, choose a location in your computer to store the PDF file and give a name to it. Tip: use your receipt number in the file name. Save all your receipts with the Receipt Number in the PDF file name in the folder. Thus, you will be able to easily identify a specific PDF if needed in the future.[/vc_column_text][/vc_tta_section][vc_tta_section title=”How can I change the colors, fonts or other formatting?” tab_id=”1614001193184-92d4793f-903a”][vc_column_text]All the formatting options are available to you. Just select the cells you need to modify format and use Excel’s default formatting options (in the Home ribbon) to change fonts, colors, appearance, number format or alignment.

Excel Formatting Options to customize the invoice

If you change the font size or font, you can adjust the column widths and/or row heights to ensure that the print view is good.[/vc_column_text][/vc_tta_section][/vc_tta_accordion][vc_separator][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]

Our Premium SMALL BUSINESS Templates

[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column]

  • Invoice Manager
  • Sales Pipeline Manager (CRM) thumbnail
[/vc_column][/vc_row]

Leave a Reply

Your email address will not be published. Required fields are marked *