Note
Our Salesforce dashboard was missing tens of thousands in partner wins. We rebuilt it in a spreadsheet.
For a growing software company we work with, the leadership team checks one dashboard to see how the partner program is doing: how many referrals came in, how many closed, and how much revenue partners had a hand in. This week we went to add a simple comparison to last year. Instead we found the dashboard had been undercounting for months, and nobody knew.
Josh Weckesser · November 2026 · 6 min read
The numbers did not match
To build that comparison, we copied the same deals into a Google Sheet. The first check was to make the sheet agree with the dashboard. It did not. The sheet found more referrals than the dashboard showed, and close to twice as much revenue from deals where a partner did the implementation work.
The cause was that partners were being recorded in two places. The original method was a separate partner record attached to each deal, and every dashboard report counted those. Later, two simple fields were added to the deal itself: who referred it and who implemented it. They were quicker to fill in, so that is what the team used.
The old records slipped for months, then stopped. Nobody had added one in five weeks. About one in six of this year's partner deals had its partner in the new fields and not in the old records, including a win from the summer. As far as the dashboard was concerned, those partners did not exist, and neither did the revenue they brought in.
Nobody did anything wrong. The team kept recording partners every week. The dashboard just was not looking where they recorded them.
Built-in dashboards have limits
Once we looked closely, there were smaller problems too. None were bugs, exactly. They were limits of the tool.
The rows in one table added up to more than its own total, because a deal with two partners was listed twice. The monthly chart skipped months with no wins, so the trend looked steadier than it was. The year-over-year chart put all of last year next to this year so far, which made this year look far worse than it was. Goals were typed in as fixed numbers, with nothing to say whether the team was ahead or behind for the date.
One of the numbers on the dashboard, revenue from deals where a partner did the implementation, means comparing two fields on the same deal. The standard report builder cannot do that without a workaround, and every workaround is one more thing only an admin understands.
What we built instead
Salesforce is still where deals live. Once a day, one report copies every deal into a Google Sheet. The dashboard is just another tab in that sheet, built from ordinary formulas and the charts that come with Sheets. No add-ons and no extra software to buy.
Across the top are six numbers, each compared with the same date last year and shown in red when the team is behind. Below that are the partner deals created or closed in the last seven days, this year against last year as a running total, wins by month with the empty months left in, a table by partner, and the open pipeline with the sales notes beside each deal. Every deal links back to its record in Salesforce. The working formulas sit on a separate tab, so the people reading it see a dashboard, not a spreadsheet. It took a morning.
We also fixed the source. The old partner records are retired, so there is one way to record a partner, and the Salesforce dashboard was rebuilt to count the same way. Salesforce and the sheet now agree.
Why it works better
Anyone can read how a number is counted. Every number on the dashboard is a formula you can click on. In a Salesforce report the same definition is a filter setting three screens deep, and two people can build two reports that both claim to be the same number.
Changes take minutes. Halfway through the morning the ask changed from progress against a goal to a comparison with last year. That was a few formula edits. In Salesforce it would have meant new reports and a dashboard rebuild, usually waiting in an admin's queue.
If you can describe a comparison, you can build it. Same period last year, best case if every open deal closes, what changed this week. None of them need a workaround.
One source feeds everything. The dashboard, a weekly update and next quarter's board slides can all pull from the same cells, so they never disagree.
Could you just build your own CRM?
Once the reporting lived outside Salesforce, the obvious question was what Salesforce was still doing here. Mostly it was storing deal records and their history. That raises a question that would have sounded absurd two years ago: could a small company just build its own CRM?
For a narrow job like tracking partners, the pieces are simple. A small database, a few forms to add and update deals, and a dashboard like this one. With today's AI coding tools that is days of work, not months.
The more interesting part is the data entry. We already use AI to read a week of email, chat and meeting notes and work out which partner did what on which deal. That is most of what salespeople type into a CRM by hand. Point it at a database, with a person approving each change, and the records would stay more current than most teams manage today.
What you would give up is everything around the data. Control over who sees what. A history you can audit. The connections to billing, marketing and support that are already in place. If your product runs on Salesforce, you are not leaving it anyway. And software you build is software you own, maintain and secure, which we learned the hard way. The database is the easy part.
The takeaway
Keep the system of record. Move the reporting to a place where anyone can read how it counts and change it in minutes. For most growing companies that place is already open in another tab.
The bigger lesson is the one we found by accident. The dashboard had been wrong for months and nobody noticed, because nobody could see how it counted. If you cannot read the definition behind a number, you have no way to know when it stops being true.
If your CRM is not giving you the reports you actually want, or you are not sure the numbers mean what you think they mean, that is a short conversation. Book a call and we will look at what you want to see and the fastest way to get it.
