Reporting for Logistics: Quote to Booking by Lane, and the Accounts Whose Volume Is Slipping

That is normal in forwarding, and it is exactly why company level conversion numbers are useless. The question is never how often you win. It is which lanes you win, which shippers are quietly moving volume elsewhere, and which quotes are being used to benchmark someone else. These reports answer those three.

Quote to booking by lane

Bookings won against quotes issued, per lane and trade, with quote volume shown beside it. It decides where pricing effort goes. A bad number is a corridor with heavy quoting and almost no bookings. The action is either to fix the buying rate on that lane or to stop treating those requests as opportunities and start treating them as benchmarking.

Rate validity expiry

Quoted rates approaching expiry, with account, lane and owner. It decides this week renewal work. A bad number is expiries arriving with no preparation, so a shipper asks for a booking against a stale rate. The action is a standing alert a set number of days before expiry, owned by a named person rather than noticed by whoever is on the desk.

Account volume drift

Each shipper recent volume against their own trailing pattern. It decides which accounts get a call from someone senior. A bad number is several established accounts sliding in the same period, which usually points at a service failure nobody escalated. The action is a direct conversation while the business is still partly yours.

Enquiry response time

Working hours from rate request to quote sent, by lane and desk. It decides staffing and pricing authority. A bad number is requests arriving late in the day and answered next morning. The action is often to delegate pricing authority within limits, because most delays are approvals rather than effort.

Lost quote reasons and spot versus contract mix

A closed reason list plus the shape of each account business. Together they decide carrier negotiation and renewal strategy. A bad number is rate recorded on every loss, or an account whose contract volume has vanished while its spot volume stayed. Both are findings you cannot get from booking totals alone.

Lane conversion is built from records the desk already keeps and it immediately identifies where pricing time is being wasted. Rate expiry is the natural second because it creates work rather than describing it: a dated list, an owner, and a conversation that has to happen. Account drift is the most valuable of the three but it needs shipper records properly merged first, so build it third rather than first.

Forwarding produces a great deal of countable activity. The reports below are the ones that change who gets called, what gets repriced and which carrier conversation happens next.

Lane and trade tagged on every quote rather than only on bookings. Validity dates entered when a rate is quoted. A fixed source list covering agents, referrals, portals and direct. Lost reasons from a closed list. One owner per account. Shipper records merged so a customer booking through two branches appears as a single relationship.

Tagging the lane at quote stage is the step teams skip most often, and it is the one that makes lane conversion possible at all. If lanes are only recorded on the bookings you won, every conversion denominator is missing precisely the quotes you lost, and the report will confidently tell you that you win almost everything.

Cumulative TEU and tonnage charts. Total enquiry counts by month. Booking totals with no lane breakdown at all. Each is easy to produce and none of them names a shipper to call or a corridor to reprice. A weekly report in forwarding has one job, which is to shorten the list of things the desk should do next, and these three lengthen it instead.

HelloGrowthCRM keeps enquiries, quotes, rate validity and accounts in one system so lane conversion, expiry alerts and drift lists come out of daily work instead of a spreadsheet built every Friday. Pricing is $10/user/month billed annually, and a free plan is available while a desk works out which three reports it will genuinely use.

Also worth reading: CRM features, WhatsApp CRM, lead management software, sales automation, CRM by industry, and pricing.