Free Packing Slip Template (Excel)
What's in the packing slip template
Two sheets: Order Info (company, ship-to, order/PO number, order date, ship date) and Packing Slip (up to 60 line items: item #, description, PO line ref, qty ordered, qty shipped). Backorder qty calculates automatically on every row.
The PO line ref column links each packing-slip line back to the matching line on your purchase order or invoice - a gap left by generic shipping-document hubs that ship the packing slip with no invoice/PO linkage.
Automatic backorder detection, not just a manual formula tip
Backorder qty is Qty ordered minus Qty shipped, calculated live and highlighted whenever it's greater than zero - built into the file by default, not described as something you have to add yourself.
Ship a partial order by entering less in Qty shipped than Qty ordered: the backorder flag and the summary's total backordered quantity update instantly.
Totals for the whole shipment
The summary below the table adds total quantity ordered, total quantity shipped, and total quantity still backordered across every line - so you don't have to re-total a partial shipment by hand.
How to use it
- Fill in the Order Info sheet: company, ship-to address, order/PO number, order date and ship date.
- List every item on the Packing Slip sheet with its PO line reference, quantity ordered and quantity shipped.
- Check the summary for total quantity ordered, shipped and still backordered across the whole shipment.
Download the free Free Packing Slip Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Inventory Tracker — Small Business
If you're shipping from stock, the paid Inventory Tracker ($14) tracks up to 200 SKUs with live stock levels, margins and reorder alerts that account for your supplier's lead time.
See the full versionFrequently asked questions
Does this handle pallet or multi-box shipments with weight summing?
No. This template covers standard-box packing slips with a PO line reference and backorder quantity - it doesn't sum weight across multiple pallets or boxes.
How does backorder detection work?
Backorder qty = Qty ordered minus Qty shipped, calculated automatically on every row and highlighted whenever it's greater than zero.
Does it link to my invoice or purchase order?
The PO line ref column lets you type in the matching line number from your invoice or PO, so you can cross-reference the two documents - it doesn't auto-import data from a separate invoice file.
Can I use it in Google Sheets?
Yes. Upload the file to Google Drive, open it, then File > Save as Google Sheets. The backorder formulas keep working.
What's the usage license?
Personal use or use within one business. It's not meant to be resold or redistributed as a template product.