Reporting guide · Dashboards and KPIs
Zoho Analytics: building sales, finance and management dashboards
Zoho Analytics pulls data from Zoho CRM, Zoho Books, Zoho Inventory and other sources into one place, refreshes it on a schedule and turns it into dashboards each manager can open on a laptop or phone. The software part is quick. The thinking goes into choosing the few numbers that matter, writing one definition both teams accept, and deciding who sees what. This guide covers both halves, with a sample dashboard layout and a KPI dictionary you can copy.
We reply within 1 business hour · No obligation
Also Zoho Creator Registered, Zoho Catalyst, AWS and Shopify Partner
Quick takeaways
- Most "reporting problems" are definition problems: two teams counting revenue differently.
- Zoho Analytics has ready connectors for Zoho CRM, Books and Inventory, and lookups between CRM and finance data are created for you.
- How often data refreshes depends on your Analytics edition. Hourly sync is an Enterprise feature for the Books connector.
- Start with one dashboard per role and fewer than ten KPIs each. Add more only when someone asks for them.
Why do disconnected reports leave managers guessing?
Because every report is a snapshot from one app, taken at a different time, by a different person. The sales head exports the pipeline on Monday. Accounts shares receivables on Wednesday. Stock comes from a godown spreadsheet on Friday. By the time someone combines them for the review meeting, the numbers disagree and the first half hour goes on arguing about which one is right.
Signs your business has outgrown export-and-paste reporting:
- Someone spends a day or more each month preparing the management pack.
- "Revenue" means booked deals to sales and invoiced amounts to finance.
- Nobody can answer "which customers are both growing and paying late?" without a fresh spreadsheet.
- Branch or regional heads get the same report as everyone else and filter it themselves.
- Managers ask for numbers on WhatsApp because opening the report is slower.
Connecting the sources and agreeing the definitions fixes all of these. That combined job is what our Zoho Analytics team in Bangalore is usually asked to do.
How does Zoho Analytics connect to CRM, Books, Inventory and other sources?
Through connectors. For Zoho apps you authorise the connector once, choose the modules, and Zoho Analytics imports the data into a workspace and keeps it in sync. Setting up the Zoho Books connector, for example, also creates a set of ready-made reports and dashboards you can keep or delete.
- Zoho CRMLeads, deals, accounts, activitiesNative connector
- Zoho BooksInvoices, payments, bills, customersNative connector
- Zoho InventoryItems, stock, sales and purchase ordersNative connector
- Files and databasesExcel, CSV, cloud databasesImport or scheduled sync
- WorkspaceTables joined by lookups, query tables for business logicZoho Analytics
- DashboardsShared by role, on web and mobileZoho Analytics
Sample architecture. Your sources and their connector types decide the real design.
What links the data together
When Zoho Books (Zoho Finance) data is added to a Zoho CRM workspace, Analytics creates the lookups between CRM and finance modules automatically, so a deal can be traced to the invoice and the payment. Data from outside Zoho needs a shared key, such as a customer code or GSTIN, that you agree on and keep clean in both systems.
Several Zoho Books organisations
Group companies can import more than one Books organisation into a single workspace when they share a base currency, with an organisation ID on every record. Zoho's help page notes that blending several finance organisations with CRM data is not yet supported, so plan group-level dashboards with that in mind.
Dashboards by role
Which dashboards should sales, finance, operations and HR get?
Six dashboards cover most companies. Tap a card to see the widgets we usually start with and the source app behind each one. These are starting layouts, not a client's live reports.
Starting layouts we adapt per company. Widgets depend on which Zoho apps you use and how they are set up.
What does a good management dashboard look like?
One screen, read top to bottom in under a minute. Headline numbers first, trends next, and the exception lists that need action at the bottom. Here is the layout we sketch with owners before building anything.
Wireframe only. Bars show layout, not data.
KPI picker
Which KPIs belong on your first dashboard?
Go through ten common KPIs and keep the ones your management meeting actually discusses. Each card names the Zoho app the number comes from. Send the list to us and we will sketch the dashboard around it.
Keep under ten. Every extra KPI is one more number someone has to define and maintain.
How do you define KPIs so sales and finance agree?
Write a KPI dictionary before building charts. One row per number: what it means, how it is calculated, which app and fields it uses, how often it refreshes, and who owns it. When a number looks wrong, the owner checks the definition first, not the chart.
| KPI | Definition | Source and fields | Refresh | Owner |
|---|---|---|---|---|
| Bookings | Value of deals moved to Closed Won in the period, before tax | Zoho CRM: Deals, Amount, Closing Date, Stage | Every few hours | Sales head |
| Invoiced revenue | Sum of invoice sub-totals excluding GST, less credit notes, by invoice date | Zoho Books: Invoices, Credit Notes | Daily | Finance head |
| Days sales outstanding | Receivables at period end divided by revenue for the period, times days in the period | Zoho Books: Invoices, Payments | Daily | Finance head |
| Stock below reorder | Items where available stock is under the reorder level for that godown | Zoho Inventory: Items, Warehouses | Daily | Purchase lead |
| On-time dispatch | Share of sales orders shipped on or before the expected shipment date | Zoho Inventory: Sales Orders, Shipments | Daily | Operations head |
Sample definitions. Your CA and department heads should agree the final wording.
How should data preparation, refresh schedules and access be handled?
Prepare the data once, in the workspace
Clean-up belongs in query tables and formula columns inside the workspace, not in each chart. Typical work: mapping inconsistent product names to one category, converting deal stages to probabilities, joining CRM owners to finance records, and excluding test or internal records. When the logic sits in one place, every chart that uses it stays consistent.
Match the refresh to the decision
For the Zoho Books connector, Zoho's help page lists these sync intervals by edition. Check the current page for other connectors.
| Sync interval | Available from | Good for |
|---|---|---|
| Daily | Basic and above | Finance, HR and monthly reviews |
| Every 3, 6 or 12 hours | Standard and above | Sales and collections tracked through the day |
| Every hour | Enterprise only | Operations that react within the shift |
Control who sees what
Share dashboards with users or groups, and apply filters per user so a regional manager sees only their region's numbers in the same dashboard. Keep salary and margin data in separate views with narrower sharing. Review the sharing list every quarter, especially after people change roles.
A simple rule we use: nobody gets edit access to a shared dashboard unless they also own a KPI on it. Everyone else views.
Which reporting needs are native, configured or custom?
| Requirement | Zoho app | Type | Depends on |
|---|---|---|---|
| Pipeline and sales reports | Zoho Analytics with Zoho CRM | Native connector | Consistent stages and owners in CRM |
| Revenue, receivables, cash | Zoho Analytics with Zoho Books | Native connector | Books edition and clean customer records |
| Stock and order fulfilment | Zoho Analytics with Zoho Inventory | Native connector | Reorder levels and godowns set up |
| CRM to invoice to payment view | Zoho Analytics | Configuration | Finance data in the CRM workspace |
| Business rules (margin, category mapping) | Zoho Analytics query tables | Configuration | Agreed KPI dictionary |
| Data from an ERP or factory system | Zoho Analytics database or file connectors | Third-party | Access to the other system and a shared key |
| Charts inside a Zoho Creator or portal app | Zoho Analytics embedding | Custom | Embedding setup and access rules |
If the source apps themselves need work first, the right place to start is our Zoho CRM setup, Zoho Books configuration or Zoho Inventory rollout. Clean finance data matters most here; our Zoho Books GST and e-invoicing guide covers how to set it up right.
How do we roll out Zoho Analytics in a company?
In small rounds, one role at a time, so each dashboard is in use before the next is built.
- Report inventoryCollect every report people build by hand today, who reads it and what decision it feeds.
- KPI dictionaryAgree definitions, sources and owners. This is the step that prevents later arguments.
- Connect and prepareSet up connectors, choose sync intervals and build query tables for the business rules.
- First dashboardUsually the owner's management view, reviewed in one real meeting before changes.
- Role dashboardsSales, finance, operations and HR views with user filters and sharing.
- Hand-overTraining in English, Tamil, Kannada or Malayalam, a change process for new KPIs, and a quarterly access review.
For delivery details, see our Zoho Analytics implementation service. Weighing other BI tools? Our Zoho Analytics and Power BI comparison covers that decision.
Tired of building the management pack by hand?Request a business reporting assessment and hear back the same working hour.
Book my free Zoho fit assessmentWho reviewed this, and what should you check yourself?
Elite Tech Corp is a Zoho Advanced Partner with 300+ Zoho projects delivered since 2021. Our Zoho team checked the connector and sync details in this article against Zoho Analytics help pages in November 2026. Zoho changes edition limits and pricing from time to time, so confirm users, rows and sync options on Zoho's current pricing page before you buy.
Official references:
FAQ
Questions about Zoho Analytics dashboards
Send us one report you build by hand every month. We will show you how it would look as a live dashboard.
Book my free Zoho fit assessmentCan CRM and Books data sit on the same Zoho Analytics dashboard?
Yes. When Zoho Books data is added to a Zoho CRM workspace in Zoho Analytics, the lookups between CRM and finance modules are created automatically, so you can follow a deal through to its invoice and payment. Blending several Books organisations with CRM data is not yet supported, according to Zoho's help page.
How fresh is the data from Zoho apps in Zoho Analytics?
It depends on the edition and the connector. For the Zoho Books connector, daily sync is available from Basic, every 3, 6 or 12 hours from Standard, and hourly only on Enterprise. Check Zoho's current help page for the connectors you plan to use.
Do we need Zoho Analytics if Zoho CRM and Zoho Books already have reports?
Not always. The built-in reports are enough when each team only looks at its own app. It becomes worth adding once managers need several apps on one screen, shared definitions, scheduled delivery or role-based views for managers.
Can each regional manager see only their own numbers?
Yes. You can share one dashboard and apply user filters so each person sees only their region, branch or team. Sensitive data such as salaries or margins is better kept in separate views with narrower sharing.
Can Zoho Analytics pull data from systems outside Zoho?
Yes, through file imports, cloud database and other connectors, or APIs. Each outside source needs a shared key, such as a customer code, that is kept consistent in both systems, or the joins will not hold.
How many KPIs should a first dashboard have?
Fewer than ten for each role. Start with the numbers your management meeting already discusses, write a definition for each, and add new ones only when someone owns them.
How long does a Zoho Analytics rollout take?
A first management dashboard on clean Zoho data can be in use within a few weeks; role dashboards follow in rounds. Messy source data or outside systems add time. We share a plan with dates once we have seen your current reports.