Reports overview

Reports pulls together figures from every part of Tenvara: tickets, time, contracts, licences, devices, patching, backup, security, Microsoft 365 and monitoring. It has three jobs:

• Tell you how the business is doing: recurring revenue, margin, utilisation, billable hours and SLA performance on one dashboard.
• Answer your own questions: the report builder turns any of that data into a filtered, grouped table or chart that you can save, share, export or have emailed on a schedule.
• Show customers what you did for them: a branded monthly PDF per customer, made on a schedule and emailed, published to the customer portal, or both.

The Reports sidebar#

Open Reports from the rail (or press g then r). The sidebar starts with the pages you build and send from:

• Overview: the internal dashboard described below.
• Dashboards: dashboards you lay out yourself, with TV dashboards as a second tab for wall screens. See Dashboards and your Home layout and TV dashboards.
• Report builder: templates and saved reports. See The report builder.
• Customer reports: every monthly customer report, with its Templates tab. See Monthly customer reports.
• Business reviews: the review packs you prepare for customers. See Business reviews.
• Presentations: slide decks made from a customer's figures, from a business review or a security review to a backup assurance or project close deck. See Presentations.

Below them, the ready-made reports are grouped by what they are about:

The sidebar ends with your own Dashboards and Saved reports (yours and the ones colleagues shared) for one-click access, and a Reports settings link for administrators. A group only shows when its module is on and you may see what it reports on. Reports is a module itself: a new install starts with the service desk, and Reports appears on the rail once it is switched on in Settings > Modules.

Sales figures (leads, pipeline, won and lost deals, activities) are reported from the builder and the Sales meeting dashboard: see Forecast and sales reports.

Who sees what#

Reports has its own permission area, Reports. View lets someone open and run reports and download customer reports. Manage adds templates, saved reports, schedules and sending.

Money and people figures need a second permission area, Finance. Revenue, cost, margin, profitability, recurring revenue and staff utilisation are only shown to people with Finance view, and scheduling a report that contains them needs Finance manage. By default administrators manage Finance and technicians and read-only users have none.

A few more rules:

• Someone who can see tickets but not Reports still gets the Reports area, but only the Service desk reports.
• A module switched off in Settings is left out of every report, dataset and template. Nothing appears as an empty section in its place.
• Every figure is worked out in your business hours' time zone (Settings > Ticket setup, the Business hours tab), so "last month" means your calendar month.

Reading the overview#

The overview covers one period, chosen with the period button at the top right: This month, Last month, Last 30 days, This quarter, Last quarter, This year or two dates of your own. Use the customer switcher in the top bar to narrow it to one customer.

Tiles#

Each tile compares the period with the one of the same length before it, and clicking a tile opens the same figure in the report builder:

MRR, margin and utilisation need Finance view. Billable hours and SLA need service desk view. Someone with neither sees a page pointing them to customer reports and the builder instead of empty tiles.

Recurring revenue#

The line is MRR over the last twelve months (right-hand scale). The columns are each month's movement: New, Expansion and Reactivated above the line, Contraction and Churned below it. Above the chart are the period's totals, with:

• Churn: churned MRR over starting MRR. Revenue churn also counts contraction.
• Net revenue retention: starting MRR plus expansion, less contraction and churn, over starting MRR. New customers never flatter it.

Click a month to open its movement per customer in the builder.

Under it, Margin trend shows cost, margin and margin % for each of the last twelve months, with the total margin over the year.

Utilisation, hours and SLA#

• Utilisation per person shows billable and non-billable time as a share of each person's expected hours, with your target as a dashed line. Expected hours come from each person's working pattern in Scheduling, less bank holidays, office closures and approved leave. In a period that is still running, only the days up to today count, so the figure means something mid-month.
• Billable and non-billable hours shows time logged each week.
• SLA breaches per week splits missed first response and resolution targets by week.

Profitability per customer#

Each customer's revenue for the period, split into cost and margin, biggest first, with margin % beside it. Customers running at a loss show in red. How revenue and cost are worked out is on Rates, costs and targets.

Tables and export#

Below the charts are sortable tables for profitability per customer, utilisation per person and the latest 50 SLA breaches. Details on a chart jumps to its table, and Export downloads a table as CSV.

Note: If anyone logged time without a cost rate, a warning lists them with a link to set one. Their time costs nothing until you do, which makes margins look better than they are.

Service desk reports#

The reports in the Service desk group keep their own pages and filters. Each has a period switcher and filters such as customer, technician, queue or priority.

• Tickets: tickets opened, resolved and still open, first response time and response and resolution SLA met, per customer.
• Time: billable and non-billable time by customer, technician or contract, with Export CSV.
• Satisfaction: ratings on resolved tickets and chats, per technician, customer, queue or month, with the comments.
• Net Promoter Score: every survey round, the score per customer (lowest first) and each answer.

Wall screens, recognition and other tools' data#

More parts build on the same figures:

• TV dashboards: wall screens for the office or a customer's reception, made from widgets, rotated by a playlist and shown on a screen paired with a code or a display link. They are the second tab of Reports > Dashboards. See TV dashboards.
• Presentations: a deck for a meeting, made from a customer's figures (a business review, a monthly report, Microsoft 365 and security reviews, backup assurance, a hardware refresh plan and more), that you can present, download and publish to the portal. See Presentations.
• Team: leaderboards, kudos, badges, goals and one-to-one check-ins, in the People group of the Team area. See Goals, kudos and leaderboards.
• Data from other tools: backups from Datto BCDR, Cove and Veeam, security agent counts and any other tool's figures as a dataset, all usable in the report builder and in billing. See Data from other tools.