Recipe 32 - The Negotiated Account Scorecard: Know Whether Every Major Account Is Producing, Priced Correctly, and Growing
Know Whether Every Major Account Is Producing, Priced Correctly, and Growing
From The Spiral Sales Office Recipe Vault | By Paul Woodley
A negotiated rate agreement answers one question at the moment it is signed: does this account's expected volume justify this rate? What it does not do is update itself when the volume changes, when the rate drifts out of alignment with what the account is actually producing, or when a significant portion of the account's travel starts going elsewhere without anyone noticing.
Recipe 32 runs that review quarterly. It builds a structured scorecard for each major negotiated account that answers three questions: is it producing what it committed, is the rate still correct for the volume being delivered, and where does the pattern point regarding what is coming next?
What This Recipe Makes
A quarterly negotiated account scorecard for each major account in the portfolio, covering performance against commitment, rate fit analysis, pattern read, confidence assessment, three conversation topics for the next review, and a one-line health rating.
- Head Chef: Business Travel Sales Manager with Revenue Manager
- When to Cook It: Quarterly for top accounts; before any renewal conversation; before RFP season
- Ingredients: Account production by month or quarter, current year and prior year; contracted rate and any volume commitment; stay-pattern detail where available; any notes on the account's business, offices, or travel policy
The Six Sections of the Scorecard
- Performance vs Commitment - Actual room nights against whatever volume was assumed or committed when the rate was set. Stated in room nights and in dollars. If no commitment was recorded when the rate was agreed, the prompt says so plainly, because that itself is a finding: a rate set without a documented volume expectation cannot be evaluated against it, and every future renewal should include one
- Rate Fit Analysis - Three specific conditions are flagged:
High volume at a rate set for low volume: the hotel is under-earning but the relationship is strong. This is a renewal opportunity, not a problem to solve quietly.
Low volume at a rate set for high volume: the hotel is over-conceding. This needs either a reprice conversation or a volume conversation before the next renewal.
Volume roughly as expected: the account is performing as designed. The strategy is protect and grow - The Pattern Read - What does the stay pattern tell you about this account? Which nights, which seasons, what length of stay, how far out they book. And critically: what does the pattern suggest about where the unbooked volume from this account might be going?
- The Confidence Assessment - How confident should you be in the conclusions based on the data available? Where is the data thin? What additional information would make the read more reliable and who should you ask for it?
- The Quarterly Conversation Topics - Three specific things to raise with the account's contact at the next review, in priority order, with a clear objective for each. Not a general check-in agenda. Specific topics connected to the scorecard findings
- The One-Line Health Rating and Critique Sentence - A health rating from protect, grow, reprice, or at risk, plus one sentence that could be used to describe this account in a monthly review, honest about where it stands
Why Quarterly Is the Right Cadence
Annual renewal conversations that are not preceded by quarterly reviews produce two problems. The first is that volume changes that should have triggered a rate conversation happen quietly and are discovered only at renewal, when the leverage to address them has partially dissipated. The second is that the renewal conversation has no evidence base beyond the production numbers, and the account manager has no specific topics prepared.
A quarterly scorecard means the renewal conversation is a summary of four documented check-ins rather than a single annual review of numbers. That changes both the depth of the conversation and the trust the account has in the hotel's understanding of the relationship.
Where the Output Goes
The quarterly account review meeting with each named account's contact, where the conversation topics become the agenda. The RFP renewal tiering in Recipe 31, where the health rating feeds directly into the protect, reprice, or release decision. Agenda item ten of the monthly critique, where account health is part of the standing review. The account-penetration work in Recipe 22, where the pattern read surfaces the unbooked volume to pursue in the next ninety days.
The Mirror
For your three highest-volume negotiated accounts: do you know right now whether each one is performing above, at, or below the volume level the rate was set for? If you cannot answer that without pulling a report, the rate and the volume are not being managed in the same conversation. Recipe 32 connects them.
A Note on Data Handling
Confirm what your employer, owner, brand, and management company permit before pasting negotiated account production and rate data into any AI platform. Named account production figures and contracted rate information may be commercially sensitive or subject to confidentiality agreements. When in doubt, use account codes rather than company names and rate ranges rather than specific figures. Every output is a starting position. The rate decisions and the account conversations still belong to you.
Your Next Step
Run Recipe 32 on your top five negotiated accounts before your next quarterly review cycle. Pull production by month, the contracted rate, and any volume commitment on file. Build the scorecard. Identify which accounts are in the reprice or at-risk category before the renewal conversation happens rather than during it. Then arrive at each account review knowing what you need to address.
A negotiated account that is not reviewed quarterly is a rate that is aging without oversight. Recipe 32 is the oversight.
Paul Woodley | The Spiral Sales Office
