PalletAuditsTracking pooled pallet shipments in Excel
No WMS? A simple shipment log that's enough for a monthly pallet audit, and how to keep Excel from mangling your numbers.
The log
One row per shipment: ship date, customer, customer location number, BOL, pallets, pallet type. One row per receipt: date, supplier, PO, pallets, pallet type.
Add a column for the date you declared it to the pallet company: late declarations show up at a glance.
Keep the numbers intact
Import CSVs with Data > From Text/CSV and set reference columns to Text. Excel drops leading zeros and keeps only 15 significant digits, which breaks BOL, PO and 18-digit SSCC numbers.
Source
Microsoft: keep leading zeros and large numbers
Find your missing pallets
PalletAudits matches every shipment to a declared transfer and lists what to declare, dispute and recount. Your first audit is free.
Run a free audit See a sampleMore guides
Exporting shipments and receipts from your WMS for a pallet audit
Exporting shipments from SAP EWM for a pallet audit
Exporting outbound deliveries from SAP ECC or S/4HANA (VL06O)
Exporting shipments from Oracle WMS Cloud for a pallet audit
Exporting shipment orders from Infor WMS for a pallet audit
Exporting shipments from NetSuite for a pallet audit
General information, not advice about any specific contract. Your agreement with the pallet company sets the actual fees and deadlines.