CRM reporting should answer six questions, and the standard dashboards in HubSpot, Dynamics 365 Sales, Salesforce and Pipedrive answer the first four well without any extra tools: what's in the pipeline, what's moving, what's stuck, and who's doing the work. The fifth (what we won and lost, and why) they half-answer, because "why" depends on someone filling in the reason field. The sixth (what those customers are actually worth) they can't answer, because worth means revenue, margin and payment behaviour, and those live in the accounts system. So "our CRM reporting isn't good enough" is usually one of two things: the fields aren't being filled in, or the question needs the finance data. Both are fixable, and neither needs a new CRM.
What are the six questions?
1. What's in the pipeline? Open opportunities by stage, by owner, by expected close month, in value and count. Weighted by stage probability if you use it. Every CRM does this on its first dashboard.
2. What's moving? Created this month, moved stage this month, closed this month. Velocity: how long deals take from created to closed, by stage. The CRMs all hold the dates; not all of them make the velocity view easy.
3. What's stuck? Opportunities past their expected close date, opportunities with no activity in 14 or 30 days, opportunities that have been in one stage longer than the average. This is the report that changes behaviour and it's the one most teams don't have switched on.
4. Who's doing the work? Activities per rep (calls, emails, meetings), new opportunities created, conversion by stage, by rep and by team. All native.
5. What did we win and lose, and why? Won and lost value and count by month, by source, by product, and by reason. The CRMs hold the field; the report is only as good as the discipline of filling it in.
6. What are these customers actually worth? Revenue invoiced, margin, payment days, repeat rate, by customer and by the source that brought them in. This is the question the MD asks and the CRM can't answer, because invoicing, cost and cash are in Xero, Sage, QuickBooks, Business Central or whatever the finance system is.
What does each CRM answer on its own?
| Question | HubSpot | Dynamics 365 Sales | Salesforce | Pipedrive | Needs finance data? |
|---|---|---|---|---|---|
| 1. Pipeline by stage/owner/month | Yes, standard dashboards | Yes, built-in dashboards and charts | Yes, reports and dashboards | Yes, Insights | No |
| 2. Movement and velocity | Yes, deal velocity and funnel reports | Yes, with some setup | Yes, with reporting snapshots or history tracking | Yes, Insights | No |
| 3. Stuck deals | Yes, filters and reports; needs configuring | Yes, views and dashboards; needs configuring | Yes, reports; needs configuring | Yes, rotting deals feature | No |
| 4. Rep activity | Yes | Yes, plus Sales Insights add-on | Yes | Yes | No |
| 5. Won/lost and reasons | Yes, if the reason field is used | Yes, if the reason field is used | Yes, if the reason field is used | Yes, if the reason field is used | No, but needs field discipline |
| 6. Customer worth (revenue, margin, cash) | No | No (unless Business Central/Finance is integrated) | No | No | Yes |
Source: each vendor's reporting documentation as read 21 September 2026. "Needs configuring" means the report isn't on the default dashboard but the data and the tool are there.
The honest reading of that table: for questions one to five, your CRM is fine. If those reports don't exist, someone needs to build them inside the CRM, and it's a day's work by someone who knows the tool, not a project. For question six, no CRM will do it alone.
Why does CRM reporting feel inadequate when the tool is fine?
Three reasons I see repeatedly, none of which are the CRM's fault:
Fields aren't filled in. Close date, amount, stage, reason lost, source. If reps don't fill them in, the reports show what reps filled in. No reporting tool fixes this; management does, by making the report the thing the pipeline meeting runs from, so an empty field is visible to everyone in the room.
Stages mean different things to different people. "Proposal" in one rep's pipeline is "Negotiation" in another's. A weighted pipeline built on inconsistent stages is fiction. Write the exit criteria for each stage down, once, and put them on the dashboard.
The question being asked is question six. "Which customers are worth having?" "Did that marketing spend produce customers who pay?" "What's the margin on the deals rep X closes?" Every one of those needs the invoice, cost and payment data, and people keep trying to answer them from the CRM because the CRM is where they're sitting.
How do you get the sixth question answered?
Join the CRM to the finance system, on one customer list, in a model that both can feed. In practice:
- A customer key that both systems agree on. This is the whole problem, and it's usually the account number or company registration number stored on the CRM company record. If it isn't stored, that's the first job.
- Won opportunities from the CRM, with source, owner, product and close date.
- Invoices, credit notes, cost of sales and receipts from the finance system, by customer and date.
- A calendar so "revenue in the twelve months after the deal closed" is one measure.
- Measures: revenue by customer, gross margin by customer, debtor days by customer, revenue by original source, revenue by rep who closed the first deal.
That's a two-source build. The CRM side connects natively for Dynamics 365 Sales (Dataverse connector) and Salesforce (Salesforce Objects connector, with API access), and through third-party connectors or the API for HubSpot and Pipedrive. The finance side depends on the system; the routes are in How to Connect Your Accounting Software to Power BI.
Where do you start?
Not with question six. Start with question three, stuck deals, inside the CRM you already have. It's free, it takes a day, and it changes the pipeline meeting within a fortnight because "why has this been in Proposal for 60 days?" becomes a question with a report behind it.
Then, once the CRM data is trustworthy (fields filled, stages consistent), build the join. A single report answering "what are the customers we won last year actually worth?" is a two-source job, which in my published pricing is a Reporting Sprint (£9,500). If your first question is one the CRM alone can answer but you want it out of the CRM and in front of people who don't log in, that's a single-source First Report (see the First Report, £1,950, ten working days, HubSpot, Salesforce and Dynamics 365 Sales all named on the page).
Licence note: Power BI Pro is £10.80 per user per month on Microsoft's UK page as of September 2026, for everyone who opens the report. Some CRM plans include their own reporting seats and some charge for extra dashboards; that's separate.
Common questions
What should a CRM report include?
Pipeline by stage, owner and close month; what's moved and how fast; what's stuck; rep activity; won and lost with reasons. Those five are native to every mainstream CRM. Customer value (revenue, margin, cash) needs the finance system joined in.
Which CRM has the best reporting?
For the five native questions, HubSpot, Dynamics 365 Sales, Salesforce and Pipedrive are all adequate and the differences are in how much configuring you have to do. None of them can answer customer value alone. Pick the CRM on how well your team will use it, not on the dashboards.
Why are our CRM reports wrong?
Almost always because fields aren't filled in or stages aren't used consistently. The report is showing what was entered. Fix the discipline first by running the pipeline meeting from the report, then look at tooling.
Can Power BI connect to our CRM?
Dynamics 365 Sales through the Dataverse connector, Salesforce through the native Salesforce connectors (with API access on your edition), HubSpot and Pipedrive through third-party connectors or their APIs. All four work; the HubSpot and Pipedrive routes need a connector subscription or a developer.
What is pipeline coverage?
Open weighted pipeline divided by the remaining target for the period. A coverage of 3× means you have three times the pipeline you need to hit target, which is the common rule of thumb for a healthy position, though the right number depends on your win rate.
How do we see which customers are actually profitable?
Join CRM won deals to invoices, cost of sales and receipts from the finance system on a shared customer key, in a model with a calendar. Then revenue, margin and debtor days by customer and by source are single measures. It's a two-source build.
Do we need a new CRM to get better reports?
Usually not. If the five native questions aren't answered, that's configuration and discipline inside the CRM you have. If the question is customer value, no CRM answers it alone and switching won't help; the join to finance will.