From Quote to Signed Contract: Managing 3PL Pricing as a Team

The number is only half the job

Ask most operators how they price a contract and they'll describe a calculation: volumes in, FTEs and cost pools derived, a rate card out. That's the part everyone focuses on, and rightly so — get it wrong and nothing else matters. But talk to the same operators about where deals actually slow down, and the answer is rarely the maths. It's the handoffs.

It's the version of the model that got emailed to the commercial lead, edited, and emailed back — while the estimator kept working on their copy. It's the rate that changed somewhere between the first draft and the version that went to the customer, and nobody can say who changed it or why. It's the proposal that took half a day to assemble by hand because the numbers live in one place and the customer-facing document lives in another. None of that is a costing problem. It's a workflow problem — and it's where margin, and time, quietly leak out.

Where the spreadsheet workflow breaks

A spreadsheet is a brilliant calculator and a terrible collaboration tool. The moment more than one person is involved in a quote, four cracks appear:

• No single source of truth. The instant a file is copied or emailed, there are two versions — and no reliable way to know which one is current. "Final", "final v2" and "final USE THIS" is a filing system every 3PL will recognise.
• No record of who changed what. When a rate moves between drafts, the spreadsheet keeps the new value and forgets the old one. There's no trail, so a challenged number turns into a memory test.
• Access is all-or-nothing. To let a colleague see one quote, you hand over the whole workbook — every customer, every rate, every margin. There's no way to pull one person into one deal.
• The proposal is a manual rebuild. The customer never sees the model; they see a document someone assembled by hand from it. Every rebuild is a chance for the presented price to drift from the costed one.

Individually these are annoyances. Together, on a live tender with a deadline, they're how a good price becomes a late, unclear, or slightly-wrong one.

One pen per quote

The simplest fix is also the most overlooked: only one person should be able to edit a quote at a time. Concurrent editing is the root cause of most version chaos — two people changing the same model in parallel, then trying to reconcile it afterwards. Nobody does that on purpose; it happens because a spreadsheet has no concept of "who holds the pen right now".

A structured pricing workflow makes that explicit. A quote has one current holder. They can edit; everyone else sees it read-only, live, with no risk of overwriting the numbers. When the estimator is ready to hand it to the commercial lead for review, they pass the pen in a click — and now the lead can edit while the estimator watches. There's never a second copy, because there's never a second editor. The reconciliation problem doesn't get solved; it stops existing.

An audit trail you can actually use

"Why is this rate $0.65?" is the question that decides tenders — and its harder cousin is "why did it change?" A structured system records every create, every delete, and every field edit as it happens: the old value, the new value, who made the change, and when. Not as a favour to the auditors, but as a working tool for the team.

When a margin looks different on Thursday than it did on Monday, you don't reconstruct it from memory or diff two spreadsheets cell by cell. You open the change log for that quote and read it: labour rate lifted from the review, insurance figure entered, a storage line reactivated. The story of the price is written down as the price is built. That's the difference between defending a number and guessing at it.

Tasks: how the work actually moves

Pricing a contract is a sequence of asks. "Can you confirm the insurance figure?" "Finance needs to sign off the margin." "Chase the customer for the updated volumes." In a spreadsheet world those asks live in email and someone's head, disconnected from the quote they belong to.

Attaching tasks to the quote itself changes the shape of the work. The ask sits where the work is, so context never gets lost. And it doubles as the access model: being assigned a task on a quote is what grants a person visibility of it — the right people get pulled into the right deals, without opening the whole system to everyone. The invitation and the permission are the same action.

Roles: the right access, not all-or-nothing

A commercial team isn't flat. An estimator, an account owner, a business manager and an approval director all touch a quote, but they don't all need the same powers. A structured workflow uses access levels — from Super Administrator down to Approval Director — so people can do their part of the job and no more. It's the opposite of handing over the whole workbook: measured access that matches the role, which is what makes it safe to bring more of the team into pricing in the first place.

From approved to signed

The last mile is the one spreadsheets abandon entirely. Once a price is agreed internally, it still has to become a document the customer will read, then a commitment they'll accept. Done by hand, that's a rebuild and a risk: the presented figures can drift from the costed ones, and acceptance lives in a separate email thread nobody can find later.

A connected workflow closes the loop. The customer-facing proposal and the internal pack are generated straight from the quote — branded, consistent, and always matching the numbers behind them. They're emailed from the same place the quote lives. And when the customer accepts, that acceptance — signature and all — is captured against the quote, so the path from draft to signed contract is one continuous, recorded line rather than a scatter of files and inboxes.

Why the workflow is a commercial edge, not just tidiness

It's tempting to file all of this under "good housekeeping" — nice to have, not a difference-maker. It isn't. The workflow is where three commercial advantages are won or lost. Speed: a quote that moves cleanly from estimator to review to customer, with no rebuild and no merge, is a quote you can turn around while the tender is still warm. Trust: when a customer or your own board challenges a number, a legible trail turns a defensive scramble into a thirty-second answer. Continuity: when pricing lives in a system rather than in one estimator's workbook, the business keeps the ability to price even when people move on.

The maths is what makes a price right. The workflow is what lets a whole team produce it, defend it, and close it — again and again, without the number ever getting lost on the way to the signature.