List companies
The companies whose report has been released to you, and when each was run.
Report summary
The headline figures, the red flags and what each changes in the deal, what matters for the investment case, and what to ask management.
Pipeline deals
How much of the open pipeline has a customer still talking, and the named deals to question.
Invoices and cash
What was won against what was invoiced and paid, and money owed past its due date.
Customers and team
Reliance on the biggest customers and on individual sales people, how strong the relationship with each big customer is, where the sales come from, and how the deals were worked.
Compare companies
The headline figures of each company side by side.
List deals
Every open, won and lost deal behind a report, with its customer, value, stage and dates. An open deal says what the customer’s emails and meetings showed; a won deal says what was invoiced and paid against it.
List invoices
Every sales invoice over the last three years, with its customer, dates, amounts, what is outstanding and how many days overdue.
List customers
What each customer was invoiced, its share of all invoicing, what it owes, how it pays and its open deals.
Deal activity
The dated emails and meetings with the customer on one deal: when each happened, whether it came from the customer or went to them, and its subject line. It says when the customer last replied. The words of an email are never held.
Revenue quality
How much of the invoicing is repeat business, retention year on year, customers that stopped being invoiced and the biggest falls. Where the company uploaded its customer contracts: how much of the invoicing has a contract in force, which contracts end within twelve months, and what each says about a sale. The revenue bridge from one year to the next, and what rests on each downside case. Contracts are read for their terms, not reviewed as a lawyer would.
Forecast reliability
For each pipeline stage, how often a deal that reached it was really won, against the odds the CRM gives, and the open pipeline weighted both ways. Whether past forecasts came true, quarter by quarter, and how current trading compares with a year before.
Lost deals
Why deals were lost, in the reasons recorded in the CRM, and the stage each was lost at.
Sales cycle
How long deals take to win, by size and by stage, and the open deals that have run far past that.
Dependence on sales people
Each sales person’s share of what was won and of the open pipeline, and the customers only that person deals with. How each sales person’s deals were worked: next step, meeting, more than one contact, chased when quiet.
The same data in Excel: on the Companies and Reports pages in CRM Diligence, Download the data (Excel) gives the deals, invoices, customers and email activity behind a released report as a spreadsheet, for your own model.