Directory of Reports in MSPCFO
Reports for MSPCFO
This article is a directory of every report in MSPCFO, grouped the same way as the menu on the left side of the screen. Each entry says what the report shows and when you would use it. Click a report name to open its detailed article.
Before you start
- What you see depends on your plan and permissions. If a report in this list is not in your menu, your MSPCFO plan or user role may not include it. Ask your MSPCFO administrator.
- BETA and ALPHA badges. Some reports carry a yellow BETA or an ALPHA badge in the menu. They are newer reports that are still being refined, so their layout and numbers may change.
- Search the menu. You can type a report name or a keyword (for example "efficiency" or "tickets") into the menu search box instead of browsing.
- Common terms. FFA = fixed-fee agreement (managed services). T&M = time and materials. Shadow billable = what the hours would have billed at your technicians' normal T&M rates. Efficiency = invoiced labor รท shadow billable (above 1.0 means the work was billed at a premium, below 1.0 means the agreement absorbed more work than its price covers). Contribution = revenue minus direct labor and product cost (before overhead).
Dashboards
| Report | Purpose |
|---|---|
| Hello World (Dashboards) | The default home page you see when you log in. It is a set of small reports, called widgets, that give a quick snapshot of how your MSP is doing: revenue, recurring revenue, health checks, projects closing this month and more. |
| Agreement Specifics (Dashboards) | A ready-made dashboard for looking at one client's agreements in detail. It combines widgets that break down FFA efficiency and show where tickets and serviced equipment are concentrated for that client. |
| My Dashboards | Build your own dashboards from the widget library and arrange them the way you like. You can make one of them your personal home page in place of Hello World. Use Create Dashboard at the bottom of the menu section to start one. |
Favorites
Favorites is not a report. It is your personal shortcut list. Click the star on the filter line of any report you use often and it appears under Favorites at the top of the menu. You can drag favorites to reorder them. Each user has their own list.
Custom Reports
This section appears only when your company has custom reports set up. It lists reports built for your company with the columns and filters you chose, so you can rerun them with one click.
Risk Assessment
These reports help you spot risk in your client base, receivables and staffing early, especially when the business environment is changing.
| Report | Purpose |
|---|---|
| Client Risk By Market | Groups clients by industry or market and shows how much of your revenue depends on each one. Use it to see whether you rely too heavily on a market that may be volatile. |
| Client Risk By Ticket Count | Compares each client's ticket volume across two periods. A sudden rise or fall in tickets can point to a client having problems or starting to disengage. |
| Days Receivable By Client By Type | Shows how long each client takes to pay, split by type of work (agreement, project, T&M, product). Use it to find slow payers and see which kinds of billing are collected slowest. |
| Outstanding Invoices Risk | Compares days receivable and outstanding invoices across two periods, so you can see whether collections are getting better or worse and which clients are driving the change. |
| Staffing Utilization | Shows how fully your team's available hours are being used over time. Use it to judge whether you are over- or under-staffed before you hire or reassign people. |
| Ticket Entry Times | Shows when during the day and week tickets come in. Use it to match staffing and shift coverage to the times your clients actually need help. |
Members
Reports about the people on your team: what they billed, how efficiently their time was used, and their individual profit and loss.
| Report | Purpose |
|---|---|
| Billing by Period | Each member's billing across several months side by side. Use it to see trends in each person's billed time and revenue. |
| Billing by Month | Each member's billing for one month, broken down by type of work. Use it for a month-end review of who billed what. |
| Billing by Member | One member (or all members) across a range of months. Use it to look closely at one person's billing history. |
| FF Agreements | Hours each member worked on clients' fixed-fee agreements. Use it to see who carries the managed-services workload and for which clients. |
| FF Tickets | The fixed-fee tickets worked in one month, with hours by member. Use it to find the tickets that used the most agreement time. |
| FF Ticket Analysis | A close look at one fixed-fee ticket: who worked on it, when, and how many hours, compared with what those hours would have billed. |
| FF Projects | Member and client billable hours, actual hours and the matching revenue on fixed-fee projects for one month. |
| FF Project Analysis | Shows how one fixed-fee or not-to-exceed project's labor revenue was earned, member by member and month by month, compared with shadow billable. The headline figure is the project's lifetime efficiency, which tells you whether the project was priced well. |
| Efficiency | Hours, shadow billable, invoiced labor and efficiency for each member over a date range. Sort by any column to compare members. |
| Work Report | The detailed list of time entries behind MSPCFO's labor numbers: one row per entry with the member, client, agreement, project, ticket, hours, rate and revenue. Use it to find exactly which entries are behind a number you see in another report. |
| Time Entry Anomalies (ALPHA) | Flags time entries that look unusual: very long entries, possible duplicates, and time logged outside business hours or on weekends. A summary by member shows who has the most flagged entries. You can adjust the thresholds; corrections are made in your PSA. |
| P&L by Period | A P&L for one client or all clients over a date range, organized by each member's role. Shows revenue, cost and margin for FFA, project, T&M and internal technical work, plus client, administrative and internal hours, lost time and utilization for each member. |
| Profit & Loss | A month-by-month P&L for one member over a date range: revenue, cost, profit and margin for FFA, project, T&M and internal technical work, with total, administrative, internal, sales, client and potential hours and the member's utilization rate. |
| Bonus | Bonus amounts for one member or all members, calculated from the bonus plans set up in Payroll > Member Bonuses. |
| Utilization Hours | Shows how much of each member's available working time was captured as logged time, and where that time went (utilized, non-utilized, billable, non-billable). It is a capacity and time-capture report and shows no revenue or cost. |
| Timeliness (BETA) | Measures how promptly each member enters their time, based on the delay between doing the work and logging it. Entries are scored against thresholds you can set, so you can spot people who log time late. Late time entry makes every other report less accurate. |
P&L
Profit and loss reports by client, project and team lead.
| Report | Purpose |
|---|---|
| Client | A month-by-month P&L for one client or all clients: revenue, cost of goods sold, contribution and hours, with labor and product broken out. Its key measure is contribution per hour, the return on every hour you spend on the client. It also shows FFA hours, effective rate, shadow billable, efficiency and cost per hour, and highlights in red or green any metric that moved more than 15% against the trailing six months. |
| Project | The same measures as the Client P&L, totalled for a date range and shown by project and client. Sort by any column to find your most and least profitable projects. |
| Team Lead | The same measures as the Client P&L, totalled for a date range and grouped by each client's service team lead. Use it to compare the client portfolios each team lead manages. |
| Contribution By Product | Revenue, cost and margin for every product line item you invoiced. Use it to see which products and product categories are profitable and which are not. |
| Contribution per Hour by Month | Each client's contribution per hour, month by month, across your whole relationship with them: agreements, projects, products, T&M and block time. Use it to see which clients are becoming more or less worth the time you spend on them. |
Segments
| Report | Purpose |
|---|---|
| Client | Ranks your clients on a metric you choose (contribution per hour by default) and splits them into five equal groups, called quintiles. You can see each quintile's totals or every client in it, and click a client to open their P&L. The lower half shows how each quintile's revenue splits between products, projects, T&M and FFA. Use it to find your best and worst clients. |
| Market | The same as the Client segment report, but ranks your industry markets (for example Healthcare, Manufacturing or Legal) instead of individual clients. Use it to see which kinds of client give the best return on your team's time. |
FFA (Fixed-Fee Agreements)
Reports about your managed-services agreements: hours, pricing, profitability and changes.
| Report | Purpose |
|---|---|
| Monthly Tracking | A bar chart of FFA hours (or the difference from expected hours) for every client in one month. Use it to see at a glance which clients took more agreement time than usual. |
| Client Tracking | A bar chart of FFA hours by month for one client or all clients over a date range. Use it to see whether a client's agreement workload is rising or falling. |
| Monthly Efficiency | A chart of each client's FFA efficiency for a chosen month. Use it to see which agreements are priced well against the work done and which are under water. |
| Components | Shows how each line on an agreement invoice was split between product revenue and labor revenue, with the product cost behind it, for one month. It is an audit report: when agreement figures on the Client P&L or efficiency reports look wrong, this report shows where they came from. |
| Agreement Profitability | Shows which agreements make money once cost is included. For each agreement, grouped by agreement category, it gives labor and product revenue and cost, contribution, margins, contribution per hour, effective rate and efficiency. Use it to find agreements whose labor cost is higher than their labor revenue. |
| Agreement Adjustments | A "what-if" report. Change pricing and costing choices to see how they would affect your key agreement profitability and pricing measures before you make the change for real. |
| Agreement Changes (BETA) | Compares each client's recurring agreement amounts between two billing periods (by default, the last bill and the amounts on the next bill). Use it to see increases, decreases, new and cancelled agreements before invoicing. It covers monthly-billed agreements only. |
| Agreements Modeling | Plan future agreement labor revenue. Adjust each client's user (or node) count or change the managed-services price by a percentage, and the report shows the projected revenue next to your current revenue. |
Efficiencies
Reports that explain why an agreement is or is not priced well against the work it takes.
| Report | Purpose |
|---|---|
| Agreement Drill Down | Shows each client's agreement efficiency and breaks it into the levers behind it, using node (device) counts: revenue per node, tickets per node, hours per ticket and your billable rate. Use it to see whether the problem is the price, too many tickets, tickets taking too long, or rates that are too low. |
| Agreement User Drill Down | The same as Agreement Drill Down, but for agreements priced per user. It uses user counts instead of node counts: labor revenue per user, tickets per user, hours per ticket and shadow billable per hour. |
| Efficiency by Agreement | Hours, shadow billable, invoiced labor and efficiency for each client, agreement and member over a date range. Sort by any column. |
| Efficiency by Client | The same measures as Efficiency by Agreement, with one row per client. Use it to rank clients by how well their agreements are priced. |
| Efficiency by Month | Each client's efficiency month by month over a date range. Use it to see whether a client's efficiency is improving or getting worse. |
| Efficiency Components | Takes an agreement's efficiency apart into its pieces so you can see where price and work have drifted apart. Use it alongside the drill-down reports to explain an efficiency number to a client or your team. |
| Load by Board (BETA) | Shows how the workload is spread across your service boards (queues in Autotask) compared with a utilization target you set. Use it to see which boards are overloaded or have spare capacity. |
| Metrics by Month | A grid with one client per row and one month per column for a measure you choose, such as contribution, contribution per hour, effective rate, efficiency, labor or T&M margin, billable agreement hours, or recurring revenue and its margins. Cells are shaded so unusually good or bad months stand out. |
| Service Metrics | Gathers the figures you need to complete the Service Leadership Service Executive QBR, a quarterly benchmarking survey for MSPs: agreements, users, devices (configurations), tickets and contract changes. Each figure can be opened to see the records behind it. |
Projects
| Report | Purpose |
|---|---|
| Status (BETA) | An overview of your active projects and their current status and progress. Use it to spot projects that need attention before they run over. |
Revenue
| Report | Purpose |
|---|---|
| Revenue | Analyzes your revenue several ways. One side shows month-over-month change in recurring and non-recurring revenue. The other shows recurring revenue movement between two months (next month or a later one): growing clients, declining clients, new clients and lost clients. |
| New Revenue (ALPHA) | Focuses on new recurring revenue: how much was added over a period, which clients it came from, and how many new clients you won. You can set a minimum amount so small changes are left out. |
| Revenue by Type | Shows how your revenue splits between recurring (MRR) and non-recurring revenue, overall in charts and for each client in a table. |
| Recurring Revenue Movement | Month by month, shows how your recurring revenue moved: how many clients stopped billing, how much recurring revenue that represented, and what share of your client base it was, alongside growth from existing clients. "Stopped billing" means a client billed last month and not this month. That is a one-month test, so some of those clients resume billing later. (This report was previously called Recurring Revenue Churn by Month.) |
Tickets
| Report | Purpose |
|---|---|
| Ticket Backlog | Shows whether your open-ticket backlog is growing or shrinking, by board and over time, by comparing tickets opened with tickets closed. |
| Ticket Benchmark | Compares your ticket performance with other MSPs: time spent per ticket, time to resolution and first-touch resolution. Use it to see where your service desk is ahead of or behind the industry. |
| Ticket Concentration | Shows where your fixed-fee service-desk time goes, by board, service type, sub type and item. For each group it shows how many tickets were worked, the hours spent and the share of all FFA hours. Use it to find ticket categories worth automating, handling through self-service, repricing or fixing at the root. |
| Ticket Metrics Trend (BETA) | Monthly service-desk workload and speed for each board: ticket volume, billable hours, hours per ticket, and median response time, resolution time and labor cost per ticket. Use it to see whether a board is getting busier, slower or more expensive over time. |
| Too Many Tickets | Finds the clients and ticket types that generate many more tickets per node (device) than your other clients. These are often the clients and problems worth a closer look. |
| Tickets Take Too Long | Finds the clients and ticket types where each ticket takes much more time than it does for your other clients. |
Lookup
The Lookup section is not made of reports. It holds the settings tables that tell MSPCFO how to read your PSA data: how to classify agreements, products, clients, members and work. Keeping these up to date makes every report accurate. The Health Checks below tell you when something here needs attention.
The tables are: Aggregate Clients, Agreement Types, Agreement Additions, Billing Cycles, Billing Statuses, Boards, Business Groups, Configuration List, Client Types, Configuration Updaters, Days per Month, Fixed Fee Projects, Fixed Fee Tickets, Health Check Exclusions, Internal Clients, Inventories, Locations, Market Risk Groups, Members, Member Licenses, Options, Products, Product Lines (ALPHA), Suggestions, Team Roles, Time Statuses, User Additions and Work Types.
Payroll
| Report | Purpose |
|---|---|
| Hourly Cost | The hourly cost of every member, calculated from the Wage History table. MSPCFO uses this cost to work out labor cost and margin in every P&L and profitability report. (Previously called Hourly Rate.) |
| Member Bonuses | Where you set up bonus programs for individual members. The Members > Bonus report calculates bonuses from these settings. |
| Wage History | The monthly salary or hourly rate for each member over time. Values entered here override the salaries coming from your PSA. |
Health Checks
Health Checks list data, either in your PSA or in MSPCFO settings, that is missing or looks wrong and should be fixed so your reports stay accurate.
| Report | Purpose |
|---|---|
| Agreements | Flags product agreements with unusually high margins (often a sign of missing product cost) and agreement categories that have not been given an agreement type in Lookup > Agreement Types. |
| Clients | Lists clients that have no industry or market set in your PSA. The market is needed for the Market Segment and Client Risk By Market reports. |
| Products | Lists new product categories that still need to be set up in Lookup > Products, so their revenue and cost are classified correctly. |
| Projects | Lists projects with work logged after the estimated end date in your PSA. These projects may need their dates updated or may be running over. |
| Wage and Rates | Four checks on labor cost data: members with missing labor costs, cost multipliers set to zero, unusually high rates and unusually high multipliers. |
Other areas of the menu
| Area | Purpose |
|---|---|
| Pathways | Step-by-step guided analyses that walk you through a business question. Current pathways include Client Churn Risk, which ranks your active clients by signs of relationship strain and shows how much recurring revenue sits behind them, and Inefficient Clients, which finds your underperforming clients, explains the root causes, estimates the hours and revenue you could recover, and points to the ticket types behind the problem. The churn risk score is a ranking within your own client base, not a prediction that a client will leave. |
| Insights | Findings MSPCFO surfaces automatically from your data, such as changes in client trends, client revenue performance and engineer utilization. |
| Briefings > Monthly Reviews | Monthly review packages that summarize your results for the month. |
| Release Notes | What changed in MSPCFO and when. |
| Documentation | Opens this documentation site and, if you have access, the Learning Hub. |
0 Comments
Add your comment