Skip to the content
JAI CRM

Reports & analyticsCharts, exports, scheduled mail

Business reports and dashboards that show the rows behind every figure

19 ready-made reports, dashboards you build over 51 record types, and reporting tags that split invoiced sales by region or cost centre. 17 of the 19 reports show each person only what they are allowed to see. From ₹149 per user per month paid annually, or ₹199 billed monthly.

No card needed. From ₹149 per person a month.

Dashboards with charts of sales, receivables and stock.
8 things it doesEvery one in the product today

What is Reports & analytics in JAI CRM?

Reports & analytics in JAI CRM is the suite's reporting and dashboard software. It gives you 19 built-in reports, dashboards over 51 record types, and reporting tags that split invoiced sales by region or cost centre. Each report shows headline figures, a chart and the rows behind them, and can be emailed on a schedule as CSV or PDF.

What does reporting look like in most businesses?

In most small businesses, the numbers are still built by hand. Here is what that usually looks like.

  • The figure only one person can produce

    Someone asks what last month came to. One person opens three lists, exports each one, builds a pivot in a spreadsheet and answers on Wednesday. Next month they build it again, a little differently. Now the two months cannot be compared. Nobody notices, because nobody kept the first one.

  • Two reports, two revenue figures, one long meeting

    Sales by customer says one number. Sales over time says another. The gap is whatever sat in draft invoices that day. An invoice someone was halfway through typing counted as revenue in one report and not in the other. The meeting stops being about the number. It becomes about which spreadsheet is right.

  • A "report" that is just a filtered list

    "Sales by customer" opens a lead list with a grouping applied. You cannot change the period, chart it, export it or send it to anyone. So the first thing anyone does is export the rows and start again in a spreadsheet. That is exactly where they were before the software.

  • Nobody can say which branch brought the money in

    Your chart of accounts (the list of account heads in your books) tells you what you sold, never where. So "what did Delhi invoice last year" means a fortnight of someone tagging old invoices by hand in Excel. The answer arrives long after the decision it was meant to help. The next time someone asks, the fortnight starts again.

  • The salesperson who read the whole company's pipeline

    Their list shows only their own deals. Their report does not. A report written as its own query is the one place where the limit is easy to forget, and a report that shows too much looks exactly like a normal report. Then a schedule emails it to them every Monday. Quietly, and in writing.

What the reports and dashboards do, in plain words

Nothing below is on a roadmap. Every one is in the product today, and a 14-day trial is long enough to check any of it.

The reports

19 reports that do their own sums

A report in JAI CRM answers one question over one period. It is not a list with a grouping applied. Four reports run over CRM, five over sales documents, nine over the books, and one splits sales by a dimension you define yourself. Each report states the permission a reader needs and the module that owns it.

The reports library, each report with the rows behind the number.
Three layers, every time
Every run gives you three things: a strip of headline figures, a series you can chart, and all the rows behind both. The strip holds four figures on 18 of the 19 reports, and three on Sales by reporting tag. The rows matter as much as the chart. People do not trust a total they cannot break down. And an untrusted number is worse than no number, because people argue about it instead of acting on it.
Eight groups, in the order you read them
Business overview comes first, then what you are owed, then what you owe, then direct taxes and the activity log. This reading order is set on purpose, not left to whatever order the code loaded in. Seven groups have reports today. The inventory group is kept aside and shows nothing until a report is added to it.
Filtered twice before you see it
First by the plugin (the part of the product) that owns each report, so a business without procurement is not offered What went out. Then by permission. Someone without the audit right is not offered Who did what, and someone without the TDS right is not offered the TDS register. A report you cannot run is not a greyed-out row. It is simply not in the menu.
One direct-tax report that works both ways
TDS (tax deducted at source), both ways shows what you deducted from suppliers and staff, what has been deposited, what is left to deposit, and what your customers withheld from you. The three kinds are counted separately, and you can group by section, month or party. It totals by bucket instead of listing each entry, so it answers how much, not which challan (tax deposit slip). Every payment report has a tax-withheld column, so receipts and payments show the gross amount against TDS.

Periods

11 periods, and you can re-cut the question on the spot

A period is saved by its name, like "last month", not as two fixed dates. This matters when a schedule runs. "Last month" must mean the month that just ended every time, not the month someone set it up in. Each period has a clear start and end of day.

The eleven
This month, last month, this quarter, last quarter, this year, last year, the last 7, 30 or 90 days, the last 12 months, or your own two dates. A month-by-month series is capped at 120 months. That is longer than most businesses have been running.
Win and loss, five ways, including by pipeline
Split wins and losses by owner, pipeline, reason lost, source or competitor. Nobody asks for the pipeline split until they need it. A dealership that sells cars and also services them wants "5 won in New cars, 12 in Servicing". Grouping by stage cannot give that, because the two processes close on different stage names.
Regroup the rest without leaving the page
Pipeline by stage regroups by stage, owner, source or pipeline. Each payments report regroups by month, mode or party. The TDS register regroups by section, month or party. Who did what regroups by person, record type, action or month. Sales by reporting tag shows the top level, two levels, or every value.
Two chart shapes, and a table for the rest
A line chart where the question is about time: sales over time, what you spend month by month, income against cost. A bar chart everywhere else. The shape is set per report, not per reader, because it belongs to the question. When a chart would get too crowded, the extra items go to the table instead. Charts show 12 customers or items, 15 suppliers or customers on the payables and receivables charts, and 20 rows on the activity chart.

Definitions

What counts as revenue is written down once, not guessed per report

Most arguments about reports are not about maths. They happen when two reports quietly use two meanings of the same word. In JAI CRM, those meanings are named constants (fixed rules) that the money reports take from one shared file. The build (the automatic check before each release) also holds two reports to the same answer.

Drafts, cancelled and void do not count
Draft, cancelled and void documents are not posted. Reversed or written-off amounts carry no receivable, because an ageing report that counts them chases money that is not coming. Once, a rule meant only for quotations (drop cancelled and void, keep drafts) was applied to invoices in two sales reports. So a half-typed invoice counted as revenue in Sales by customer and What sells, while Sales over time left it out.
Two reports are checked to agree
The check suite runs Sales by customer and Sales over time over the same twelve months. If their invoiced totals differ, the build fails. This is not for neatness. They once disagreed, and nobody could tell which one was wrong.
A credit note reverses a sale, it does not delete it
A credit note (a note that cancels part or all of a sale) reduces revenue with a minus sign. It does not add to the invoice count, carry a balance of its own or change the last-invoice date. Counting it as a document would halve the average sale of anyone who returned something. Outstanding comes from what the invoices themselves say is left. It is never invoiced minus collected, because that ignores every credit note and write-off and claims money that is already gone.
A bill of supply is a sale, and bad debt has its own line
A composition dealer (a small business on GST's fixed-rate scheme) raises only bills of supply, and so does anyone selling exempt goods. Counting only tax invoices showed these businesses no revenue at all. That is not a rounding error. It is an empty report. On the cost side, input GST is shown separately from cost, and ITC (input tax credit) eligibility decides which side it lands on. A blocked credit, or a bill with no GSTIN, is money gone like any other. Income against cost subtracts written-off amounts as their own line, so profit is income minus cost minus bad debt.

Who sees what

A report follows the same visibility rules as the list

A report shows each person only the records they may see, just like the list, the board, the pivot, the export and the dashboard tile over the same data. Reports once applied no record limit at all. That bug is now closed, and this section exists to say so. It is worth checking for in whatever software you use today.

Checked per module, once per run
17 of the 19 reports ask the same scope checker the lists ask. The answer is kept for the length of one run, so a report that reads deals three times does not ask three times. User names are looked up once through a cache, not once per row, for the same reason. The two that do not narrow by record are the TDS register and Who did what. They cover the whole business by nature, and each sits behind its own permission.
The limit sits where it has to sit
In What sells, the limit is on the invoice, not the line, because a line is only as visible as the document it sits on. Without this, a salesperson limited to their own invoices could read the whole company's. In the tag report, the documents are limited first and tag links are read only for those documents. So the report cannot count what the lists would not show.
A margin drawn from one set of records
Income against cost once limited its sales queries but not its cost query. So a restricted person saw their own income against the whole company's costs. Now both sides come from the same set of records. A margin drawn from two different sets is worse than no margin at all, because it looks like an answer.
Exporting is a separate right
To run a report you need view access on the module that owns the data. To export it as CSV or PDF you need the export right on that same module, not a general reporting permission. The person who may read receivables on screen is not automatically the person who may carry them out of the building.

Schedules

Reports that reach your inbox on the 1st without anyone asking

A schedule sends a report to you automatically, so you do not have to remember to look. The filters are saved with it. So next month you get next month's answer to the same question, not a re-run of the one it was set up with.

Six frequencies, your hour, your day
Daily, weekly, monthly, quarterly, half-yearly or yearly. Pick any of the 24 hours, and a day of the week or a day of the month. The day of the month is capped at 28, so every month has it. Send CSV, PDF or both. A schedule must name at least one file and at least one valid email address, and it tells you so in those words.
The recipient does not need a login
Pick staff from the team list, or type in any email address, in any mix. The person who wants the monthly figures is very often an accountant or a partner who will never sign in. Making them a user just to send them a PDF is the wrong trade.
It sends the period that just ended
Daily and weekly send the last seven days. Monthly sends last month. Quarterly and half-yearly send last quarter. Yearly sends last year. So a monthly report sent on the 1st is about last month. If you pinned a fixed period, that period is used instead. Quarterly and half-yearly schedules step forward by three and six months in a loop, so they stay quarterly and do not drift a month each time.
The figures stay the creator's
Nobody is signed in when a schedule sends. So it re-checks the permissions of the person who set it up and runs the report as them. You can send a report to someone else, but you cannot use a schedule to widen what it shows. You also cannot schedule a report you are not allowed to read: creating one needs view access on the report's own permission key.

Delivery

What actually arrives in the inbox

A scheduled report email carries the key numbers in the message itself, with the files attached. A bare attachment gets opened once and ignored after that. Both files are built to be used, not just looked at.

The numbers are in the message
The email body shows the headline figures as a neat strip, with the row count. Someone reading on a phone can see whether anything needs attention without opening an attachment. Money and counts use Indian digit grouping, like 1,00,000. The business name and currency come from your own workspace, with rupees as the default.
A PDF that is drawn, not screenshotted
There is no room on the server for a headless browser (a hidden browser that turns web pages into files). A report is just a heading, a strip of totals, a chart and a table, so the PDF is drawn directly. It has the totals strip, a colour bar chart of up to 12 bars and a table of up to 7 columns. Page breaks repeat the header. Once a report passes 400 rows, a footer line says how many more rows are in the CSV.
A CSV a spreadsheet can add up
The CSV holds raw values, not formatted ones. It starts with a UTF-8 byte order mark (a small hidden marker) so Excel opens it with every character intact. On screen, figures carry rupee signs and lakh grouping. In the CSV they are plain numbers, because a column of formatted text does not add up.
Send now, before you trust it
One click runs the schedule straight away and reports a result like "sent to 3 of 4". It tells you plainly when the mail server is in sandbox (test) mode, so nothing actually left the server. An hourly worker picks up to 200 due schedules. Each runs inside its own tenant transaction (a separate step for each business), so one business's failure cannot take the run down. A schedule that fails still gets its next run time set. Otherwise one bad report would block that business's queue forever.

Dashboards

Dashboards anyone can build, with eight tiles ready the first time

The first time you open dashboards, you get a personal one already set up. It has eight tiles: open leads, open deal value, invoiced this month, outstanding, leads by stage, the deal pipeline, your own tasks due, and recent activity. From there it is yours to rearrange. Next to it sit three fixed dashboards: a business overview, a CRM dashboard and a sales dashboard.

Nine kinds of tile on a 12-column grid
KPI (key figure), chart, list, funnel, pivot, activity, calendar, progress and text. Drag any tile anywhere and size it from 1 to 12 in either direction. Charts can be bar, line, area, pie or donut. A KPI tile can compare itself with the same measure last month. A progress tile takes a target and shows the percentage reached.
51 record types, measured by your own fields
A tile can read any registered record type that has a screen and that you are allowed to see. Measures come from that module's number fields: a count, plus a sum and an average of every number, decimal, currency or percent field, your custom fields included. Groupings come from its dropdowns, users, teams, checkboxes, lookups, dates and tags. There is nothing to set up first. It reads what your workspace actually has.
The same 29 filter operators the lists use
Build nested and/or conditions with operators like equals, contains, starts with, between and is empty. Eleven of them are relative dates: today, this week, this month, this quarter, this year, the last 7, 30 or 90 days, the next 7 or 30 days, and overdue. A condition you saved on a list works the same way on a tile.
A tile re-checks who is looking
A data tile re-checks the module permission. Then it builds its query from the business (tenant), the rule that hides deleted records, record scope and its own filters. So two people looking at "open leads" can honestly see different figures. A whole dashboard loads in one call. If one tile fails, it shows its error in its own square instead of breaking the page. Sharing a dashboard with named roles or groups is a separate permission. The person who made it, or the workspace owner, can change or delete it.

Dimensions

Reporting tags: split invoiced sales by region, cost centre or campaign

A reporting tag, or dimension, is a label on a document that answers which region, which cost centre or which campaign. It sits beside your chart of accounts. A label that does not add up is just a label. One that adds up is a dimension. The design follows Zoho's on purpose, because many businesses already know it. Today one report reads tags, Sales by reporting tag, so it splits what you invoiced, not what you spent.

A question, with answers up to five levels deep
North contains Delhi, which contains Dwarka. So a report can show both the smallest area and the total above it. Five levels is the limit, because past five nobody can read the report anyway. Each value stores its full path, so grouping by level two does not climb the tree once per row. Moving a branch updates the path and depth of every value under it in the same transaction (all at once, or not at all).
One answer per dimension, pinned to the document
A document can answer Region and Cost centre at the same time, with up to 20 answers per record in one save. The report counts only one dimension at a time. Otherwise a document with both answers would be counted twice, and the total would be double the sales figure. One limit is worth saying plainly: the answer sits on the whole document, not on each line. So an invoice that is truly half Delhi and half Mumbai must be raised as two invoices to be reported as two.
Mandatory blocks sending, not saving
Make a dimension mandatory and a document cannot be issued without an answer. The message reads "has no Region against it, and that dimension is required before it goes out". It is checked when the document goes out, not when you save. A draft nobody has finished is allowed to be incomplete, and blocking the save would stop someone writing down what they know so far. Mandatory is off by default, so a dimension added in March does not stop invoicing.
"Not tagged" is always a visible row
The untagged row always appears, sorted last however big it is. The summary shows how much sits on documents with no answer, even when that is zero. "None missing" is what a reader most wants confirmed before trusting the rest. A dimension used on real transactions cannot be deleted. Switch it off instead. It stops being offered on new documents, and old reports still add up.

Who opens Reports & analytics, and what for

Swipe through the people who use it every day.

The owner who stopped asking for last month's figures

Set a monthly schedule once on Income against cost and Who owes you. It arrives on the 1st at whatever hour suits you. The four headline figures are in the email body, so your phone answers the question before the attachment opens. If something looks wrong, the CSV underneath has the rows.

The accounts desk between the 1st and the 10th

What you owe, by age, and Receivables ageing use the same five bands: not yet due, 1 to 30, 31 to 60, 61 to 90, and over 90 days. Who owes you splits each customer into not yet due and overdue, with the age of the oldest invoice in days beside it. What came in and What went out each show the tax withheld. TDS, both ways groups by section, month or party. The GST returns are owned by Accounting & finance and linked from the same page, so there is one place to look.

The sales manager who runs a Monday review

Pipeline by stage, regrouped by owner when the question is about people and by source when it is about spend. Win and loss by reason lost or by competitor. Quotation conversion counts a quote as converted when a child document was raised from it, not by its status. So a quote turned into an order by hand still counts, which is how most of them actually happen. It also shows the average days taken to convert.

The regional manager who only ever tags North

A role says which dimensions it may use. A second setting says which of their values this person may use. A granted value brings everything under it, so someone given North gets Delhi and Dwarka without anyone listing them. When the list of answers is shortened, the picker says so: "You are shown the dimensions your role uses, and the values you work with". Without that note, a short list looks like a bug, not a limit someone set. This setting controls what they may tag a document with. What their reports show them is controlled separately, by record scope on the documents. That is the setting to use for reading.

The CA or the partner who will never sign in

Add a plain email address to a quarterly schedule with both files attached. They get the quarter that just ended, every quarter, without anyone exporting anything or remembering to. The figures are the creator's, so what leaves the building is only what the person who set it up was allowed to see.

The person who has to explain what changed

Who did what turns the audit log (the record of every change) into a report. Every change is grouped by person, record type, action or month, with created, changed and deleted shown separately. It reads up to 20,000 audit entries in a period, so for a very busy quarter, ask one month at a time. Reading it needs the audit permission. That is the same one the audit screen asks for, and it also controls the recent-activity strip on the overview.

What is different once you have it

Month-end no longer depends on one person

The figures that took someone two days of exporting and pivoting now arrive by email on a schedule. They cover the period that just ended, in rupees, with the rows attached. Those two days go back into the business. And the figures arrive even when that person is on leave, which nobody plans for until it happens.

One revenue number, and you can check it

Every figure comes with the rows behind it on the same page. What counts as revenue is a named rule the money reports take from one shared file, not a rule each report made up. The build holds two of them to the same answer. Arguments about the number become quick checks of the number, which take a minute, not a week.

Share numbers more widely without showing everything

A sales or pipeline report narrows to the person reading it. A scheduled one narrows to the person who set it up. So a regional manager can get a weekly pipeline report without being handed the company's whole pipeline. And a field team can get their own figures without a second system built to hand them out.

Answer questions your chart of accounts cannot

Which region, which cost centre, which campaign: answered on the document, rolled up five levels, with the untagged row shown, not dropped. "What did Delhi invoice last quarter" stops being a fortnight of tagging old invoices in a spreadsheet. It becomes a report you group by region. Costs cannot be split by dimension yet, so you get revenue by region, not margin by region.

What it works with

On its own it is a better spreadsheet. The value arrives when what it makes is what another part uses, with nobody typing it again.

Sales documents

Five of the 19 reports read documents raised in Sales documents: sales over time, sales by customer, quotation conversion, what sells, and receivables ageing. A bill of supply counts as a sale, just like a tax invoice. A credit note reduces revenue but does not count as a document of its own. About Sales documents

CRM

Four reports read the pipeline: pipeline by stage, the lead funnel, lead sources, and win and loss. Open counts read a deal's outcome, not the stage's name. So renaming "Won" to "Converted" does not quietly make every converted lead count as still open. That once happened, next to a conversion rate showing zero. About CRM

Accounting & finance

Nine reports read the money side: income against cost, what you owe by age, who you owe, what you spend month by month, who owes you, what came in, what went out, TDS both ways, and who did what. The purchase register behind the cost side covers both expense claims and supplier bills. It carries reverse-charge and TDS fields through from the expense record. About Accounting & finance

Accountant

The trial balance (a list of every account's balance), the balance sheet and the general ledger are owned by Accountant and linked from the Reports page. Profit and loss and cash flow are linked from the same place but live in Accounting & finance. Either way, someone looking for a figure starts on one page, not three. About Accountant

Procurement

Switch Procurement off and What went out (every payment to a supplier, by month, mode or party) leaves the menu. It is the one report in the list that the procurement plugin owns. What you owe by age, Who you owe and What you spend month by month belong to Accounting & finance and stay. The list is filtered by the owning plugin before anyone sees it, so nobody is shown a menu row they cannot run. About Procurement

Inventory

Stock valuation, stock ageing, the reorder list and the expiry watch are owned by Inventory and linked from the Reports page. The inventory group inside the report list is kept empty on purpose until a report is added to it. That is better than showing a heading with nothing under it. About Inventory

Take Reports & analytics on its own, or take the lot

Priced per person, per month, in rupees, with GST shown separately. Every plan includes the basics of the whole product: custom fields, roles, reports, documents and notifications. Change plan whenever you like and nothing is typed again.

5 people

CRM + Sales Documents

Leads, customers and deals, with quotations and GST invoices

₹149 per person a month

For 5 people: ₹745 a month, billed as ₹8,940 a year. ₹10,549.20 with 18% GST.

  • Leads, customers, companies and deals
  • Quotations, sales orders and GST invoices
  • Your own mailbox, with replies filed against the record
  • Reports, dashboards and exports
  • 1 GB storage per workspace (organisation)
Start free

CRM + Sales Documents + Subscriptions + Warranty

For a business that bills on a cycle and stands behind what it sells

₹299 per person a month

For 5 people: ₹1,495 a month, billed as ₹17,940 a year. ₹21,169.20 with 18% GST.

  • Everything in CRM + Sales Documents
  • Recurring billing, plans, add-ons and coupons
  • Warranty registration and claims
  • Items and stock, which warranty is held against
  • 1 GB storage per workspace (organisation)
Start free

Every plan, and what is in each Prices in rupees, per person, per month. Parts can also be bought on their own.

Only want Reports & analytics?

Any single part is ₹149 per person a month on the yearly rate, with the settings, reports, documents and notifications that go with it. See every part’s price.

A part you do not buy

Is not in your menu. Not greyed out behind an upgrade message, just not there. That is why the product is sold in parts.

How many people, and can I change it?

You choose when you sign up and change it whenever you like, up or down. There is no minimum number of users and no penalty for going down.

Yearly or monthly?

Both. Yearly works out cheaper per month and is paid once at the start. Monthly costs a little more and stops at the end of any month.

Questions people ask about Reports & analytics

Answered in full. If yours is not here, ask us. A person replies.

Ask us something
What is Reports & analytics in JAI CRM?

It is the reporting and dashboard software inside JAI CRM. You get 19 built-in reports: four over CRM, five over sales documents, nine over the books, and one that splits sales by your own reporting tags. You can also build dashboards over 51 record types. Every report shows headline figures, a chart and the rows behind them, and it can be emailed to you on a schedule as CSV, PDF or both.

Who is JAI CRM's reporting software for?

It suits owners who want last month's figures on the 1st, accounts teams tracking dues and TDS, sales managers running a weekly pipeline review, and regional managers who report by branch. It also works for accountants or partners who never log in but want the numbers by email. It is not a BI tool, so it will not suit a business that needs to write its own queries.

How much does Reports & analytics cost?

It starts at ₹149 per user per month when you pay annually. If you are billed monthly, it is ₹199 per user per month.

Can I build my own reports in JAI CRM?

Partly. You can build dashboards, and every list has a pivot. A dashboard tile reads any of 51 record types. It measures with a count, a sum or an average over any number field, including your own custom fields. It filters with the same 29 operators the lists use. Every list screen also has three views: list, kanban and pivot. Rows, columns and a measure over your own filters answer most one-off questions. What you cannot do is write a query that joins two modules into one table. The 19 named reports do that work.

Who can see which reports?

Only people with the right access. The report list is filtered twice. First by the plugin that owns each report, so a business without procurement is not offered What went out. Then by permission, so someone without the audit right is not offered Who did what. Inside a report, 17 of the 19 apply the same record limits the list applies. The TDS register and Who did what cover your whole workspace, which is why each needs its own permission. Running a report needs view access on the module that owns the data. Exporting needs the export right on that same module.

My accountant has no login. Can they still get the reports?

Yes. A schedule can send to staff picked from the team list and to plain email addresses typed in, in any mix and any number. They get the CSV, the PDF or both. The headline figures are also shown in the body of the email, so they can read the answer on a phone without opening an attachment.

If I schedule a report to someone else, whose figures do they see?

The creator's. Nobody is signed in when a schedule sends, so it re-checks the permissions of the person who set it up and runs the report as them. You can send a report to someone else, but you cannot use a schedule to show them more than you are allowed to see. An old or system schedule with no creator recorded stays unlimited on purpose. There is nobody to narrow it to, and refusing to send would be worse than sending what it has always sent.

Can I get sales reports by branch, region or cost centre?

Yes, with reporting tags. Create a dimension and give it a tree of answers up to five levels deep. You can also limit it to certain modules, or make it mandatory before a document goes out. Sales by reporting tag then splits invoiced value at the top level, at two levels, or by every value. The design follows Zoho's on purpose, because many businesses already know it. It covers invoiced sales only. Purchases, expenses and the profit-and-loss side do not carry dimensions yet.

Can one invoice be split between two regions?

No. A tag answer applies to the whole document, with one answer per dimension per record. So a mixed invoice lands whole in whichever region you tagged, or in "Not tagged", which the report always shows. If the split matters for reporting, raise two invoices. A document can answer several dimensions at once, such as Region and Cost centre, with up to 20 answers in one save. The report counts only one dimension at a time, because counting both would double the sales figure.

What happens to documents nobody tagged?

They show as their own row, sorted last however big it is. The summary always shows how much sits on documents with no answer, even when that is zero. A report that silently leaves them out is worse than one that shows them. "None missing" is what a reader most wants confirmed before trusting the rest of it.

Will Excel open the CSV export properly, and can I add up the columns?

Yes to both. The CSV holds raw values, not formatted ones, so a spreadsheet can add them up. It also starts with a UTF-8 byte order mark, so every character comes through intact. On screen, in the PDF and in the email, money and counts use Indian digit grouping instead.

Where are the GST returns, the P&L and the stock reports?

They live in the modules they belong to and are linked from the Reports page. There are five money reports: profit and loss and cash flow in Accounting & finance, and the trial balance, balance sheet and general ledger in Accountant. There are four tax reports: GST summary, GSTR-1 (your sales return), GSTR-3B (your summary GST return) and the TDS register. There are four stock reports: valuation, ageing, reorder list and expiry watch. Then payroll history. That is 14 links in all. One overlaps: the TDS register is also one of the 19 reports here. So the page shows it twice, once as a link to the TDS screen and once as a report with a period, a chart and an export.

Can I share a dashboard with my team?

Yes, with named roles or groups. Sharing is its own permission, separate from creating a dashboard at all. You can read a shared dashboard if you own it, are the workspace owner, or match its shared roles or groups. A dashboard marked shared with no role or group named is readable by everyone in the workspace, so name them. Anyone else sees "that dashboard is not shared with you". The person who made it and the workspace owner can change or delete it, and a delete must be confirmed before it happens.

Long enough to know, and it costs nothing to find out

Switch on reports & analytics, put a week of real work through it, and see whether it holds. If it does not, walk away. We did not ask for a card.