Logistics dashboards, built on numbers you can trace

On-time performance, transit against quoted, clearance turnaround and cost per lane — each figure traceable back to the shipments behind it

Get your Excel job done

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

Most logistics dashboards fail in the same way: they look convincing and nobody can reproduce a number. A carrier disputes an on-time figure, somebody opens the file, and the percentage turns out to come from a pasted value nobody can trace to a shipment. The dashboard stops being used within a quarter, and the review goes back to being a conversation about impressions.

We build the other kind. Every figure is a formula over a register of individual shipments, so any cell can be followed back to the rows that produced it. That constraint is what makes a dashboard survive its first disagreement — and a dashboard that survives a disagreement with a carrier is worth more than one that looks better.

What we build

The engagements that come up most in this sector

Carrier and forwarder scorecards

On-time delivery, transit against quoted, damage and invoice accuracy, weighted into one number with the weights on a visible tab so the carrier can argue with the weighting rather than the arithmetic

Lane cost and performance

All-in cost per container by lane and carrier, cost per transit day, and how the spread between best and worst has moved over time

Clearance and dwell analysis

Where the days actually go between arrival and delivery, split by port, agent and entry type

Exception reporting

The shipments that need attention today, ranked by how long they have been stuck, delivered to an inbox rather than waiting on a dashboard nobody opens

How it works

No call required, though you can book one

Send the data. An export covering a few months of shipments. Column names do not matter and neither does tidiness — cleaning it is part of the work.

Say which decision it should support. A dashboard built to answer a question beats one built to show everything. “Which carrier do we drop at renewal” is a good brief.

You get it back within 24 hours. In Excel or Google Sheets, with every figure traceable to its rows. One round of changes included.

Start from a free template

Five of them, and each is a working file

Logistics templates

Related services

Built around your data

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

Get your Excel job done

Questions we get asked

Specific to this work

Excel, Google Sheets or Power BI?

Sheets or Excel, unless you already run Power BI. A dashboard people can open, filter and argue with beats one that needs a licence and a gateway — and for shipment volumes under a few hundred thousand rows the difference in capability is not the constraint anyone thinks it is.

How much history do you need?

Three months is usually enough to show a pattern; twelve is better if you want seasonality. Less than three and the numbers move too much between refreshes to be worth acting on.

Can it refresh automatically?

Yes, when your source can be reached — a shared folder, a scheduled export, a Sheets import from another file. Where it cannot, we build it around a paste-in-place sheet, which is unglamorous and does not break.

Will it work if our data is messy?

It has to, because it always is. Inconsistent carrier names, blank dates, the same port spelled three ways — normalising those is most of the build, and it is done in the sheet so you can see and correct the mapping.

What does it cost?

A one-off dashboard is $49 and comes back within 24 hours. If it needs regular work as data arrives, there are monthly plans. Full refund if it is not what you needed.