Zoho CRM Reports and Dashboards: A Complete Beginner's Guide
Accessing the Reports Module
Reports in Zoho CRM are found under the Reports tab in the main navigation menu. If Reports is not visible, your profile may not have access — ask your CRM administrator to enable reports access on your profile. See the Zoho CRM user permissions guide for profile configuration.
The Reports module organises reports into folders. Zoho CRM ships with a set of default report folders — one per standard module (Leads Reports, Deals Reports, Activities Reports) — plus a folder for reports you create yourself. Custom reports you build can be saved to any folder and shared with other users.
Building a Tabular Report Step by Step
A tabular report is the simplest report type — a flat list of records with selected fields displayed as columns. It is the right choice when you need a specific list of records with precise field data, rather than grouped aggregates.
- Click “New Report“ in the Reports module. Select the module the report will draw from — Deals, Contacts, Leads or any other module. You cannot change the source module after the report is created.
- Select report type: Tabular. Tabular is the default. It gives you a flat list with one row per record.
- Choose your columns. The column selector shows every field available on the module. Select five to ten fields that answer your specific question. For a deals list: Deal Name, Account Name, Deal Owner, Stage, Amount, Close Date. Avoid selecting every field — narrow columns make reports easier to scan.
- Apply filters. Filters limit which records appear. For open deals: filter Deal Stage not equal to Closed Won and not equal to Closed Lost. For this week’s activities: filter Activity Date between [start of week] and [end of week]. Filters are the mechanism that makes a generic report useful for a specific question.
- Set sort order. Sort by the most relevant field — Amount descending for a deals list shows the highest-value deals at the top. Close Date ascending shows the most time-sensitive deals first.
- Save and name the report. Give it a specific name that describes exactly what it shows: “Open Deals — This Quarter by Value” rather than “Deals Report 1”. Specific names make the Reports folder navigable as it grows.
Summary Reports: Grouping and Aggregating Data
Summary reports group records by a field value and show aggregate metrics for each group. They answer questions like: how much total deal value sits at each pipeline stage, how many calls did each rep log this week, or what is the average deal size by lead source.
Building a summary report follows the same steps as a tabular report, with two additional configuration choices: the grouping field (which field to group records by — Deal Stage, Deal Owner, Lead Source) and the aggregate functions (sum, count, average, minimum, maximum applied to numeric fields within each group).
A summary report grouping deals by Stage with a Sum of Amount and Count of Deals gives you a pipeline breakdown: each stage appears as a row, with the total pipeline value and deal count at that stage. This is the most commonly used report in any active Zoho CRM installation.
Matrix Reports: Two-Dimensional Analysis
Matrix reports add a second dimension to the summary report structure — both rows and columns represent grouped data, with aggregate values in each cell of the grid. They answer questions that require two simultaneous dimensions: revenue by rep by month, deal count by stage by territory, or activity volume by type by week.
A matrix report showing Deal Owner as the row grouping and Close Month as the column grouping, with Sum of Amount as the aggregate, gives you a grid where each cell shows one rep’s expected revenue in one specific month. This is the report most sales managers want for monthly revenue planning.
Building a Dashboard
A dashboard assembles multiple report widgets — charts, summary tables, key metrics — into a single view. Dashboards display live data: every time you open a dashboard, Zoho CRM recalculates all widget values from current records.
Creating Your First Dashboard
- Go to Reports → Dashboards. Click “Create Dashboard”. Give it a descriptive name: “Sales Management — Weekly View”.
- Add a component. Click “Add Component” and select the report you want to visualise. Zoho CRM offers several visualisation types for each report: charts (bar, line, pie, funnel), KPI metric cards, target meters, and table widgets.
- Choose the right chart type for each metric. Pipeline by stage displays well as a horizontal bar chart — the bars make stage comparisons immediately visible. Revenue trend over time displays best as a line chart. Deal count by source displays well as a pie or donut. KPI cards display single numbers (total open pipeline value, deals closing this month) as large-format metric boxes.
- Arrange your components. Dashboard components can be dragged and resized. Put your most important KPI cards at the top left — the position the eye goes to first. Put trend charts in the middle section. Put action lists (overdue tasks, stalled deals) at the bottom right where they are always visible but not the first thing a manager sees.
- Share the dashboard. Click the Share button on the dashboard and select the users or roles who should see it. You can also set a dashboard as the default home screen for a specific role — so every sales manager logs in to see their pipeline dashboard before anything else.
Dashboard Widget Types
| Widget Type | What It Shows | When to Use |
|---|---|---|
| KPI Metric Card | A single large number — total pipeline value, open deals count | Any metric where the number itself is the key information |
| Bar Chart | Comparative values across categories — pipeline by stage, revenue by rep | Comparing a metric across a defined set of categories |
| Line Chart | Trend over time — weekly activity volume, monthly close rate | Any time-series data where direction matters as much as value |
| Pie / Donut | Proportional breakdown — deals by lead source, revenue by product | Showing the proportion of a whole; works best with 4-6 segments |
| Funnel Chart | Drop-off between sequential stages — lead to contact to deal | Sales funnel and conversion rate visualisation |
| Target Meter | Progress toward a goal — quota attainment, monthly target | Any metric with a defined target value |
| Table Widget | A compact report table embedded in the dashboard | Action lists like overdue tasks or stalled deals |
Scheduling Reports and Dashboard Exports
Zoho CRM can email reports to any user or group on a defined schedule — daily, weekly or monthly. This is the most practical way to get management reporting in front of people who will not log into the CRM regularly to check their dashboard.
To schedule a report: open the report, click the schedule icon, set the frequency and the recipient list. The report arrives as a CSV or PDF attachment in the recipient’s email at the scheduled time. Scheduled reports work on all report types and on all paid plans.
Common Reporting Mistakes and How to Avoid Them
- Building reports before the data is reliable. A pipeline report built on a CRM where reps have not been consistently updating stages shows management a picture that does not reflect reality. Establish activity logging and stage update discipline before relying on reports for decisions.
- Too many dashboard widgets. A dashboard with 15 components shows everything and highlights nothing. A dashboard with five to seven carefully chosen components — each answering a specific management question — gets checked daily. Start with the minimum and add components when a specific question comes up that the dashboard does not answer.
- No filters on activity reports. An activities report showing all activities ever logged in the CRM is not useful for weekly management reviews. Apply a date filter (this week, this month) to every activity report so it shows relevant recent data.
- Duplicating reports instead of using filters. Creating a separate report for each rep is unnecessary maintenance overhead. Build one report that includes all reps and use the built-in filter controls on the dashboard to slice by rep when needed.
For help designing a reporting structure that gives your management team the visibility they need, the ABR consulting team can configure your reports and dashboards as part of a broader CRM implementation or optimisation engagement.
Frequently Asked Questions
What is the first report I should build in Zoho CRM?
How do I create a report in Zoho CRM?
Can I share Zoho CRM reports with people outside the CRM?
What is a KPI widget on a Zoho CRM dashboard?
Can ABR build our CRM reports and dashboards for us?