How to track hauls in a spreadsheet

The columns that earn their place

A haul sheet does not need to be pretty. It needs to answer four questions at a glance: what did I order, where is it, what did it cost, and what do I still have to do. Every column below exists because I got burned by not having it. The ones I removed over time are the ones that only looked useful, like the seller's shop name, which nobody reads once the order is placed.

Keep one row per item, not per order. Orders get split, items arrive at different times, and a per order row hides the item that is holding up the parcel. The order number still goes in its own column so you can filter by order when you need to check a message thread.

A status list that works

Free text statuses turn into twelve spellings of the same thing. Use six values and nothing else: ordered, purchased, seller sent, warehouse received, consolidated, shipped. The agent's own flow uses a similar sequence, so you can map their page to your sheet in one glance instead of interpreting it each time.

Add a seventh value for exceptions, and use it sparingly: problem. That is where an item goes when the seller sent the wrong size, the QC photo showed a defect, or the warehouse cannot find it. Keeping exceptions in one bucket means the sheet shows you a to do list, which is the entire point.

Formulas worth adding

Three formulas carry most of the value. A count of items still in transit tells you whether a consolidation is close. A sum of snapshot prices converted at a single rate keeps the total honest. A days-in-storage column that subtracts the warehouse date from today warns you before the free window closes.

Keep the exchange rate in one cell and reference it everywhere. If you hard code the rate into each row, the sheet stops being comparable the moment the rate moves, and you will not remember which rows used which number. One rate cell, one date next to it, and a note that it is a snapshot rather than a live rate.

• COUNTIF on status for a live pipeline count
• SUMIF on parcel to see each parcel's declared value
• TODAY() minus warehouse date for days in storage
• A rate cell referenced by every converted price
• A conditional format that turns a row red when QC is pending past three days

The weekly review

Ten minutes a week is enough. Filter to problem, clear anything that has been sitting for more than two days. Filter to warehouse received with QC pending, because that is where return windows expire. Filter to consolidated without a tracking number, because that is a parcel that has not actually left.

Then look at the total. If the declared value of everything in one parcel is high, that is the moment to think about insurance and about splitting. The sheet will not make that decision for you, but it puts the number in front of you before the label is bought rather than after.

What not to track

Do not track the seller's shop name, the listing URL or the original title. You will not use them, and they make the sheet wide enough that you stop scrolling. Keep the listing link in a separate note if you need it for a dispute, one line per order, not one column per item.

Do not track a running total of freight per item unless you ship one item per parcel, which you do not. Freight belongs to the parcel, so put it on a parcel tab or a second small table, and keep the item rows about items. Mixing the two is how sheets become unreadable.