Table of contents
Sales teams are, quietly, some of the most prolific builders of internal tools.
Not because they’re especially technical - though some are - but because the gap between “what the CRM shows” and “what I actually need to know right now” is large enough that someone always fills it. Salesforce’s 2024 State of Sales report found that reps spend 70% of their time on non-selling activities — admin, data entry, searching for information.[1] That gap is why they keep building their own tools. Usually with a spreadsheet. Sometimes with a script. Occasionally with something that gets emailed around and slowly becomes load-bearing infrastructure.
Sales reps spend 70% of their time on non-selling activities. The right internal tools give that time back.
Here are the five internal tools every sales team should have, why they keep getting rebuilt from scratch, and what it looks like when they’re done right.
1. What is a sales margin calculator and why does every team build one?
What it is: A tool that takes deal variables - list price, discounts, COGS, partner margin - and shows the actual margin the company makes on a deal before it closes.
Why every team has a version: Reps get asked “can we do 30% off?” in calls all the time. Without a tool, they guess, they go back to the manager, or they over-discount. Someone builds a spreadsheet. The spreadsheet gets emailed around. Three versions emerge. Nobody knows which one is right. The stakes are higher than most teams realize — McKinsey found that a 1% price increase, if volumes remain stable, generates an 8% increase in operating profits for the average S&P 1500 company.[2] When reps guess on discounts because the spreadsheet is out of date, the margin impact compounds fast.
What it looks like done right: A published app at a URL like summit.workapps.run/run/margin-calc. Rep enters deal size, selects discount tier and product mix, sees a real-time breakdown of gross margin, net margin, and whether the deal needs manager approval. One version. Always current.
The sharing problem: The spreadsheet works fine for the person who built it. The issue is that when it lives in someone’s Google Drive, it has formulas that break, values that drift, and no access control. The right answer is to publish it, not protect it.
2. What is a deal scoring tool and how does it improve pipeline accuracy?
What it is: A structured input form that asks reps to assess a deal against qualification criteria - budget, authority, need, timeline, competitive situation - and produces a numeric score with a recommended action.
Why every team has a version: Sales managers build these to standardize pipeline reviews. They usually live in a spreadsheet, get filled out inconsistently, and get used only when a manager is watching.
What it looks like done right: A clean, mobile-friendly form reps can fill out from their phone after a discovery call. Criteria are weighted. The output is a score, a confidence bucket (hot/warm/cold), and a suggested next step. Results write back to the CRM automatically.
The sharing problem: Scoring tools only work when every rep uses the same version, with the same weights, with the same definitions. That requires a single published source - not a spreadsheet that gets copied, modified, and orphaned.
3. Why do sales teams need a dedicated commission and quota tracker?
What it is: A real-time view of where each rep stands against quota, how their closed and pipeline deals affect their commission, and what they need to close to hit their number.
Why every team has a version: Reps build these because the CRM doesn’t show commissions. Finance builds one that’s accurate but nobody can access. The ops team builds one that’s close but uses last month’s data. Everyone has their own version and they all disagree.
What it looks like done right: One tool, connected to live CRM data, that shows each rep their own dashboard - closed won, pipeline at various stages, projected commission at current close rate, and the delta to quota. Finance approves the formula once. Everyone trusts the number.
The sharing problem: Commission tools touch sensitive data. You can’t just paste a link in Slack. You need role-based access: reps see their own data, managers see their team, Finance sees everything. That requires actual permissions - not a shared spreadsheet with hidden tabs.
4. How do you build a battle card tool reps will actually use?
What it is: A structured, searchable reference for how to position your product against specific competitors - objection responses, feature comparisons, pricing differences, win/loss patterns.
Why every team has a version: Product marketing builds battle cards. They usually live in a Google Doc, a Notion page, or a Confluence wiki. Reps don’t use them because they can’t find them in the moment, the search doesn’t work, or they’re out of date. The ROI is measurable when they’re accessible — in Crayon’s State of Competitive Intelligence report, 71% of companies using battle cards reported improved win rates, and 65–68% of all B2B sales opportunities are competitive.[3]
What it looks like done right: A fast, mobile-ready tool where a rep can tap a competitor’s name and immediately see: the top three objections, the recommended responses, the three features they’ll try to make sound comparable, and the two things your product does that theirs doesn’t. Updated quarterly by product marketing. No login required - just a link anyone on the team can bookmark.
The sharing problem: Battle cards fail at the access layer. They need to be fast, frictionless, and findable in the middle of a call. That means a dedicated URL with no-friction access, not a page buried four levels deep in your wiki.
5. What should a sales quote builder tool look like?
What it is: A tool that takes deal parameters and generates a structured, formatted quote - line items, pricing, discounts, terms - that can be sent directly to a prospect.
Why every team has a version: Most CRMs have a quote feature that’s either too rigid or too complex. Ops builds a simpler version in Google Sheets. It works great until someone changes the price list and forgets to update the sheet. Now you have reps quoting last year’s pricing.
What it looks like done right: A form-based tool with the current product catalog, up-to-date pricing, and approval logic for non-standard discounts. Produces a PDF or a shareable link. Connects to the price list in one place so updates propagate automatically.
The sharing problem: Quote tools are only useful if they’re authoritative. That means one canonical version, with live pricing, accessible to every rep. The moment it fragments into copies, you have a compliance problem and a trust problem at the same time.
Why do sales tools keep getting rebuilt instead of shared?
Look at all five of these tools and you’ll notice the same structure:
- Someone on the team builds a version that works for them.
- It solves a real problem, so others want it.
- Sharing it creates a mess: version sprawl, stale data, no access control.
- The team reverts to asking the person who has the “real” version to run it for them.
- That person becomes a bottleneck.
The tools aren’t the problem. The sharing infrastructure is.
Only 28% of sales reps hit quota in 2024 — the lowest figure in six years.[1] The tools reps build for themselves aren’t just productivity shortcuts. They’re survival mechanisms.
Every one of these tools can be built quickly - many already exist in your org in some form. The question is whether they’re published somewhere your whole team can access, trust, and rely on. If they’re not, the tool doesn’t exist in any meaningful sense. It’s just one person’s shortcut.
How do you turn a sales spreadsheet into a shared team tool?
Pick the tool on this list that causes the most friction in your team right now. That’s usually the margin calculator or the commission tracker.
Find whoever built the current version. Ask them: if you could publish this as a real URL your team could bookmark, would it be useful? The answer is almost always yes.
Then publish it. Give it a stable URL. Give it permissions. Tell your team it’s the authoritative version.
That’s how a one-off spreadsheet becomes a team tool. Not by rebuilding it - by giving it a proper home.
Sources
Salesforce. State of Sales, 6th Edition (2024). Survey of 5,500 sales professionals. salesforce.com
McKinsey & Company. “The Power of Pricing.” mckinsey.com
Crayon. State of Competitive Intelligence (2023–2024). crayon.co