The Negotiation Tools Excel Template Built the Way Procurement Practitioners Actually Prepare
Stop walking into negotiations unprepared. This structured Excel template gives you a complete negotiation planning framework, covering every phase from preparation to close, with built-in ZOPA analysis, AI-powered language prompts, a concessions tracker, and a move planner, all in one workbook.
Instant download · Excel (.xlsx) · Works for any supplier or commercial negotiation · Lifetime access
Your next negotiation is coming.
The preparation isn't.
From scattered prep notes to a structured deal plan, before you walk in the room
Every procurement and supply chain professional negotiates. Price reviews, contract renewals, supplier performance conversations, freight rate discussions. The data is usually available, the relationships are known, but the preparation is rarely structured. Most people walk in with a number in mind and improvise the rest.
A good negotiation planning tool defines your walkaway point, maps the likely moves of the other side, clarifies your ZOPA before the first exchange, and gives you language to use when the conversation gets difficult. It turns a high-stakes meeting into a process you can control.
This template was built by a practitioner, for practitioners. It reflects the negotiation frameworks used in real commercial and procurement settings, not the theoretical models taught in MBA classrooms.
What is our walkaway point?
Define your BATNA and reservation value before any opening offer is made.
What will they ask for?
Map the counterparty's likely moves and positions before the first exchange.
Where is the ZOPA?
Identify the range where both parties can reach agreement before pressure mounts.
What do we say when it gets hard?
AI-powered language prompts give you the right words for each phase of the discussion.
Every module your negotiation team needs, pre-built
Download, customise for your deal, and work through each module before you enter the room. No frameworks to build from scratch. No blank pages.
Negotiation Phases Tracker
Covers every stage from preparation and opening through bargaining to close. Know exactly where you are and what comes next.
Negotiation Tool Chooser
Select the right tactic and approach for your specific deal type. Removes guesswork from strategy selection.
AI Model Prompts
Phase-specific language prompts built to sharpen your communication at each stage. Know what to say when the conversation gets uncomfortable.
Move Planner
Map your planned moves and anticipated counterpart responses before the session. Walk in knowing your next three steps, not just your opening position.
Concessions Tracker
Log every concession made and received in real time. Keep a clear record of what has been traded and what remains on the table.
Zone of Potential Agreement (ZOPA) Analysis
Visualise the overlap between both parties' positions. Identify where agreement is realistic and where pressure is likely to come from.
Every planning module your negotiation needs, in one workbook
A structured visual toolkit means you arrive at every deal with a plan, not just a position.
See the Negotiation Tools Template in action, under 5 minutes
Watch a full walkthrough of the template, from setting up your negotiation phases to using the ZOPA analysis and AI prompts before your next supplier or commercial discussion.
See what you'll be working with
A single, compact workbook that gives you every tool a serious negotiator needs, structured, visual, and ready to use.
Designed for procurement practitioners.
Not negotiation theorists.
End-to-end phase coverage
From preparation and opening through bargaining to close, every phase is mapped. You always know where you are and what the next step requires.
AI-powered language prompts
Phase-specific prompts tell you what to say when the conversation stalls, when the counterpart anchors high, or when you need to reframe a concession.
ZOPA analysis built in
Identify the realistic zone of agreement before you open the discussion. Avoids the common mistake of anchoring outside the range where a deal is actually possible.
Move planner
Plan your offers, anticipate responses, and prepare contingencies before the session. Walking in with three moves planned beats improvising under pressure every time.
Concessions tracker
Record every concession given and received as the negotiation progresses. Stops you losing track of the cumulative cost of small trades made across a long session.
Fully customisable
Adapt every field, label, and section to your specific deal. Works for supplier price negotiations, contract renewals, freight rates, or internal commercial discussions.
From download to deal-ready in four steps
Download the template
Instant access to the Excel workbook after purchase. No installation. No login required.
Customise for your deal
Fill in your deal context, positions, and counterpart details. Tailor labels to your scenario.
Plan moves and ZOPA
Use the move planner and ZOPA analysis to define your positions and walkaway points before the session.
Negotiate and track
Use the concessions tracker and AI prompts live during the negotiation. Record outcomes as the deal closes.
Built for the people who have to
win deals, not just attend them
Walk into your next supplier negotiation properly prepared
Plan your positions, map the ZOPA, and know your walkaway before the first offer is made.
Give your team a consistent negotiation framework across every deal
Replace ad hoc preparation with a repeatable process your whole team can use.
Structure commercial conversations with carriers, 3PLs, and service providers
Apply the same rigour to freight, warehousing, and logistics negotiations as to direct spend.
Deliver structured negotiation preparation for clients on day one
Adapt the template per engagement, show a professional process, and get to outcomes faster.
Every negotiation planning question people ask,
answered before you walk in the room
Practitioners searching for a negotiation template want practical answers to these questions. This tool gives you the structured output to address all of them, with your own deal data, before the session starts.
A negotiation template structures your preparation, positions, ZOPA, concessions, and language, so you negotiate from a plan rather than instinct. Structured negotiators close better deals with fewer concessions.
Map your minimum acceptable outcome and estimate the counterpart's likely walkaway. The overlap is your ZOPA. Enter both positions in the template and the analysis is immediate.
List every concession you can offer, rank them by cost to you, and track what you receive in return. The concessions tracker in this template does exactly that.
A course teaches theory. This template is a working tool you apply to a real deal today. Use it alongside any negotiation training to put frameworks into practice immediately.
Anyone who negotiates with suppliers, carriers, or service providers. Category managers, procurement leads, consultants, and supply chain professionals all benefit from a structured pre-negotiation plan.
Download, open in Excel, and fill in your deal context. Most practitioners complete the preparation modules in under an hour before a standard supplier review.
Built by a practitioner who has lived
the negotiation preparation problem firsthand
Before you buy
What does this negotiation template include?
Six Excel modules: negotiation phases tracker, tool chooser, AI language prompts, move planner, concessions tracker, and ZOPA analysis. Everything in one workbook.
What type of negotiations is this template designed for?
Supplier price negotiations, contract renewals, freight and logistics rates, or any commercial discussion where structured preparation improves your outcome.
Do I need to be an experienced negotiator to use this?
No. The template guides you through the preparation process step by step. It is designed for practitioners at all experience levels, from first-time negotiators to seasoned category managers.
What are AI model prompts and how do I use them?
They are pre-written language suggestions for each phase of the negotiation. Use them as-is, adapt them to your context, or paste them into an AI tool for further refinement.
Can I use this template for multiple negotiations?
Yes. Save a fresh copy for each negotiation. The structure stays the same; you fill in new deal details each time. One purchase, unlimited use.
What format will I receive after purchase?
An instant download link to the .xlsx Excel file, also sent by email. Works on Excel 2016 or later, Windows and Mac, and Microsoft 365.
Is the template customisable for my organisation?
Yes. All fields, labels, and sections are fully editable. Adapt it to your deal type, internal terminology, or team process. The workbook is fully unlocked.
Stop walking into negotiations unprepared.
Download the SCMDOJO Negotiation Tools Excel Template and turn your pre-deal anxiety into a structured, visual plan, today.
Instant download · Excel (.xlsx) · Lifetime access · No subscription
