Sales KPI Dashboard
Sales against goal, the state of the pipeline, appointment outcomes by division, average job size, and a two-month forecast.
Accessing the Report
Reports > KPI > Sales Dashboard
Available Filters
| Filter | Description |
|---|---|
| Date From / to | Scopes the report. Which date each panel uses varies — see below |
| Consultant | Limits to one salesperson |
| Department | Limits to salespeople in one department |
| Division | Limits to selected divisions |
| Function | Limits by division function |
| Work Type | Limits by division work type |
The Division, Function, and Work Type filters appear only for companies that classify their divisions (using more than one function or work type). See Divisions for how these classifications are configured.
The three filters are combined: a project is included only when it matches every filter at once. For example, selecting the Handyman (Internal) and Design Build (Operational) divisions together with the Internal function shows Handyman only — it is the sole division that satisfies both.
Leaving a filter blank places no restriction on that dimension, so it reads as "All". Selecting Internal for Function with Division and Work Type blank gives the entire Internal compartment.
Panels
Sales Information
| Metric | Measured by | Description |
|---|---|---|
| Gross Sales | Close date | Sold amount on won projects, against the budgeted sales goal |
| Direct Margin Dollars | Close date | Sold amount weighted by margin, against the margin goal |
| Closing Ratio | Created date | Won ÷ prospects that are no longer open × 100 |
| Design Agrmt. Sold | Design fee date | Design agreements that sold, out of all agreements in range |
Each of these four is scoped by a different date, which is why their populations differ.
Sales and lead goals come from the annual budget, which is entered per salesperson, per division, per month.
Goals are summed in whole months. A range ending mid-month still includes that entire month's goal, so a mid-month comparison will show actuals against a full month's target. Bear that in mind when reading a partial period.
Pipeline Information
| Metric | Description |
|---|---|
| Total Leads | Projects created in range, against the lead goal |
| Scheduled 1st Appt | Projects whose first appointment is still ahead of them |
| Closing Projects | Projects currently in the Closing stage, with their predicted value |
| Production Backlog | Won projects in production, with unbilled value remaining |
| Purchasing Backlog | Won projects in production, with unbilled value remaining |
First Appt. to Close Cycle Time
Days from the first appointment to the close date, by division, as an average and a median. Covers won projects created in range, excluding cancelled appointments.
Both this panel and Scheduled 1st Appt now identify a first appointment by its subcategory, the same way the Design dashboard does, rather than by guessing from the activity's type and category.
Scheduled 1st Appt previously always read 0. This panel's figures shift slightly — it now includes first appointments that were logged under a different activity type and were being missed. A division showing a negative average means projects closed before their first appointment was recorded, which is a data-entry issue rather than a reporting one.
Total Appointment Summary
Per division: appointments held, how many were won, open, or deferred, the closing percentage, total sold amount, and average margin on the won work.
Average Job Size
Per division: the budgeted average job size alongside the actual average sold amount, average direct margin dollars, and average margin percentage on won projects.
2 Month Sales Forecast
Predicted budget by month for open projects with a predicted close date inside the next two months, shown three ways: the raw predicted budget, that budget weighted by each project's confidence, and the expected margin.
Why Gross Sales differs from other reports
Three places in the system report a year-to-date sales figure, and they will not agree. Each is correct for what it measures:
| Source | Counts |
|---|---|
| This dashboard | Operational full-project divisions, including change orders |
| Sales Total widget (home dashboard) | All divisions with no division filter applied, across the full calendar year |
| Sales & Margin report | Driven from the annual budget — a won project with no budget entry for its salesperson and division is not included |
If you need a single authoritative number, decide first which of those three definitions you actually want. Comparing them directly will always show a gap.
Exporting
Export CSV downloads every panel in one file, with a Section column identifying each.