What's in the template
The report lists stock per client, SKU, warehouse and bin location on a report date, with the quantity received and shipped in the period next to it. The sample rows cover three clients in two warehouses, including two clients sharing the same bin and one SKU split across a pick face and an overflow pallet, which are the situations that usually break a simpler stock list.
The Excel version adds a Net_Movement column and a second sheet, Summary by Client, that counts each client's stock lines and totals their stock on hand, receipts, shipments and net movement. Add a new client name to the summary's first column and its totals fill in.
Columns explained
| Report_Date | The date the stock snapshot was taken, usually the last day of the billing period. |
| Client | The business that owns the stock. Every row belongs to exactly one client. |
| SKU | The client's SKU. Two clients can use similar codes; the Client column keeps them apart. |
| Warehouse | The site the stock is in, for 3PLs running more than one building. |
| Bin_Location | The exact shelf, bin or pallet position. One SKU can appear on several rows, one per bin. |
| Qty_On_Hand | Units of this SKU in this bin on the report date. |
| Received_This_Period | Units received for this SKU into this bin during the period. |
| Shipped_This_Period | Units shipped for this SKU from this bin during the period. |
| Net_Movement | Excel version only: received minus shipped, calculated automatically. |
| Notes | Lot numbers, best-before dates, damage or anything the client should know. |
How to use it for billing
Storage fees usually depend on the space a client occupies: count the distinct bins or pallet positions per client from the Bin_Location column, or use Qty_On_Hand if you charge per unit or volume. Handling fees depend on activity: the Received_This_Period and Shipped_This_Period totals per client give you the inbound and outbound volume. The 3PL storage fee calculator turns those numbers into a monthly invoice amount.
Where a spreadsheet report breaks down
A spreadsheet is only as current as the last time someone typed into it. Received and shipped quantities have to be collected from delivery notes and order lists by hand, and a move from one bin to another has to be edited in two rows. Every manual step is a chance for a client's stock to end up on another client's line, which is the error clients notice first.
Inventory software that records the client on each product produces the same report from the scans themselves. In StockFlow the Client Inventory report shows stock per client, warehouse and bin, lists receipts and shipments per client for any date range, and exports each view to CSV in this same shape. See 3PL inventory management software for how that works.
Related resources
Trusted by small businesses
What our customers say
“Super Kind! Quick replies from their support and very easy fixes, changed the dashboard a bit and customized it. Also gave me 450 items extra on the free plan just for me. Highly recommend and again great service!”
“Best customer service! Stockflow's customer support is fast and extremely helpful. They assisted me with customization of the software to improve my experience as a user.”