Logistics & shipping

Freight forwarding spreadsheets

Shipment status that shows where a container actually is, clearance turnaround you can put in front of an agent, and demurrage you see before the invoice arrives

Get your Excel job done

100% satisfaction guarantee — refunded in full if the file is not what you needed.

A forwarder's tracking sheet almost always has the same shape: a reference, a carrier, an ETA and an actual arrival. It answers one question — was this late — and it answers it after the fact. The questions that change an outcome are all in the middle. How long did clearance take. Who is holding the documents. How many days has this box been sitting without moving. What is accruing while it does.

None of that needs new software. It needs the milestones recorded and everything else derived from them, which is a day of work on a file you already have. That is what we do here: we take your sheet or your portal export, add the columns that were never captured, and build the derivations on top so nobody has to maintain a status column that goes stale the moment someone is on leave.

What we build

The engagements that come up most in this sector

Multi-milestone shipment tracking

  • Booking, documents to agent, cleared, gated in, sailed, arrived, delivered — with every leg duration and the current stage derived rather than typed

Clearance turnaround by agent

  • Time from documents sent to release, with query time separated from the agent's own working time, so the conversation stops being about whose fault it is

Demurrage and detention exposure

  • Tiered daily rates against free days, accruing live on containers still out rather than arriving weeks later as an invoice you cannot now avoid

Consolidation across forwarders

  • One register fed by exports from several forwarders and carrier portals, with their column names mapped onto one consistent set

How it works

No call required, though you can book one

Send the file. Your current tracking sheet, or an export from your forwarder or carrier portal. An anonymised copy with the same structure works just as well if the cargo details are sensitive.

Say what should be different. One or two sentences. “I want to see which shipments have not moved in a week” is a complete brief.

You get it back within 24 hours. Working in your file, with your column names. One round of changes included, and a full refund if it is not what you needed.

Start from a free template

Five of them, and each is a working file

Built around your data

  • Your lanes, carriers and milestone names
  • Fed from your forwarder or carrier exports
  • Delivered within 24 hours

Questions we get asked

Specific to this work

Do you need access to our TMS or forwarder portal?

No, and we would rather not have it. Everything we build works from an export — the CSV or Excel file your portal already produces. That keeps the credentials where they belong and means the sheet keeps working if you change provider.

Our shipments tranship. Can that be tracked properly?

Yes. Either a second set of sailed and arrived columns for the onward leg, or one row per leg linked by the booking reference. If you want per-leg carrier performance, separate rows are the only honest option, because one row cannot fairly attribute a delay to two carriers.

We handle air and road as well as ocean. Is that a problem?

No. The milestones generalise — documents, cleared, departed, arrived, delivered — so the same structure covers all three with different column names. Mixing modes in one register is usually better than three registers, because the ageing question is identical.

How do you handle demurrage rates that differ by port and contract?

The rate lives in a lookup table keyed on charge type, port and day range, never inside a formula. Adding a contract is adding a row, which means the person who negotiated it can maintain it.

What does it cost?

A one-off job is $49 and comes back within 24 hours. If the file needs regular work there are monthly plans. Everything is covered by a full refund if it is not what you needed.