“Client Revenue Month-over-Month Report”
Autotask PSA Datto RMM Datto Backup Microsoft 365 SmileBack HubSpot IT Glue All reports
AI-GENERATED REPORT
You searched for:

Client Revenue Month-over-Month Report

Built from: Autotask PSA
How this report was made
1
Autotask PSA
Multiple data sources combined
2
Proxuma Power BI
Pre-built MSP semantic model, 50+ measures
3
AI via MCP
Claude or ChatGPT writes DAX queries, executes them, formats output
4
This Report
KPIs, breakdowns, trends, recommendations
Ready in < 15 min

Client Revenue Month-over-Month Report

This report provides a detailed breakdown of client revenue month-over-month report for managed service providers.

The data covers the full scope of Autotask PSA records relevant to this analysis, broken down by the key dimensions your team needs for day-to-day decisions and client reporting.

Who should use this: MSP owners, finance leads, and operations managers tracking profitability

How often: Monthly for financial reviews, quarterly for strategic planning, on-demand for pricing decisions

Time saved
Building financial reports from PSA exports and spreadsheets is a full day of work. This report delivers it in minutes.
Margin visibility
Revenue numbers alone do not tell the story. This report connects revenue to cost for true profitability.
Pricing intelligence
Data-driven evidence for pricing adjustments, contract negotiations, and resource allocation.
Report categoryFinancial & Revenue
Data sourceAutotask PSA · Datto RMM · Datto Backup · Microsoft 365 · SmileBack · HubSpot · IT Glue
RefreshReal-time via Power BI
Generation timeUnder 15 minutes
AI requiredClaude, ChatGPT or Copilot
AudienceMSP owners, finance leads
Where to find this in Proxuma
Power BI › Financial › Client Revenue Month-over-Month Report
What you can measure in this report

Client Revenue Month-over-Month Report

Data source: Autotask PSA
Period: Aug 2024 – Jan 2026
Generated: March 2026

Overall Revenue Snapshot

Total billed revenue across all clients for the most recent full months.

$771K
Jan 2026 Revenue
Total billed across all clients
-13.1%
MoM Change
vs Dec 2025 ($887K)
$1.34M
Peak Month
April 2025 — highest in 18 months
3 clients
Revenue Drops >15%
Dec 2025 → Jan 2026
View DAX Query — Monthly Revenue Total
-- Dataset not available for this report.
-- DAX will be authored in a future Phase 3 pass.

18-Month Revenue Trend

Total revenue billed across all clients, August 2024 through January 2026.

Month Revenue Cost Profit Margin
Aug 2024$850,721$341,174$509,54759.9%
Sep 2024$827,356$329,694$497,66260.2%
Oct 2024$872,119$339,276$532,84361.1%
Nov 2024$846,378$467,360$379,01844.8%
Dec 2024$933,099$456,466$476,63351.1%
Jan 2025$942,444$426,958$515,48754.7%
Feb 2025$1,051,887$497,151$554,73752.7%
Mar 2025$1,106,651$552,775$553,87650.1%
Apr 2025$1,341,613$721,781$619,83346.2%
May 2025$1,080,822$788,927$291,89527.0%
Jun 2025$1,033,307$409,835$623,47260.3%
Jul 2025$1,045,558$428,079$617,47959.0%
Aug 2025$1,058,862$416,369$642,49360.7%
Sep 2025$1,002,352$514,945$487,40748.6%
Oct 2025$1,006,189$501,872$504,31750.1%
Nov 2025$927,813$422,695$505,11854.5%
Dec 2025$887,195$399,887$487,30854.9%
Jan 2026$770,865$245,047$525,81968.2%
View DAX Query — Monthly Revenue Trend
-- Dataset not available for this report.
-- DAX will be authored in a future Phase 3 pass.

Client Revenue: Dec 2025 vs Jan 2026

Top 20 clients by total revenue, showing the most recent month-over-month change. Sorted by total lifetime revenue descending.

Client Dec 2025 Jan 2026 Change MoM% Status
Craig-Huynh$136,721$109,533-$27,188-19.9%Watch
Lewis LLC$58,770$59,279+$509+0.9%Stable
Little Group$83,468$67,909-$15,560-18.6%Watch
Burke, Armstrong and Morgan$34,680$18,941-$15,739-45.4%Alert
Martin Group$50,966$42,297-$8,669-17.0%Watch
Lopez-Reyes$29,982$29,604-$378-1.3%Stable
Wall PLC$28,030$32,027+$3,997+14.3%Growing
Wu-Jackson$21,259$16,215-$5,044-23.7%Watch
Hahn Group$16,426$12,495-$3,931-23.9%Watch
Ramos Group$18,601$15,897-$2,704-14.5%Stable
Richards, Bell and Christensen$17,249$17,213-$36-0.2%Stable
Thompson, Contreras and Rios$16,099$16,475+$376+2.3%Growing
Price-Gomez$14,284$13,575-$709-5.0%Stable
Torres-Jones$14,819$13,928-$891-6.0%Stable
Kelley-Walsh$13,029$13,304+$275+2.1%Growing
Patterson, Riley and Lawson$11,248$11,462+$214+1.9%Growing
Buchanan, Acosta and Chambers$11,601$9,453-$2,148-18.5%Watch
Lee-Dalton$7,314$7,306-$8-0.1%Stable
Montgomery-Peck$7,377$6,989-$388-5.3%Stable
Clements, Pham and Garcia$6,954$5,057-$1,897-27.3%Watch
View DAX Query — Client MoM Revenue Comparison
-- Dataset not available for this report.
-- DAX will be authored in a future Phase 3 pass.

Key Findings

What the data tells you — and what to do about it.

Burke, Armstrong and Morgan dropped 45%

Revenue fell from $34,680 in December to $18,941 in January — a $15,739 drop. This is the sharpest percentage decline among your top clients. Verify whether this is a project ending or early churn signal.

Craig-Huynh, your largest client, is down 20%

At $2.3M in total revenue, Craig-Huynh matters most to your numbers. A 20% MoM dip from $136K to $109K may reflect project completion, but given the size of this account, it warrants a check-in.

Little Group and Martin Group both declining

Little Group fell 18.6% ($83K → $68K). Martin Group fell 17.0% ($51K → $42K). Two large accounts dipping simultaneously in the same month increases the overall January shortfall.

Wall PLC is your fastest-growing account

Revenue grew from $28,030 to $32,027 — a 14.3% increase. This is an active upsell relationship. Look at what's driving the growth and replicate it with similar clients.

Lewis LLC is your most stable large account

At $2.2M in total revenue and virtually flat MoM (+0.9%), Lewis LLC represents a dependable revenue base. Strong contract structure here — worth using as a reference for renewal negotiations with other clients.

Seasonal Revenue Patterns

Understanding whether a dip is seasonal or structural changes how you respond. Here's what 18 months of data shows.

Q2 is consistently your strongest quarter

The data shows a clear peak in April–June each year. April 2025 reached $1.34M — the highest month in the dataset. This likely reflects project kick-offs tied to annual budget cycles. If you're not scheduling QBRs and upsell conversations in Q1, you're missing the window where clients make decisions.

May 2025 had the lowest margin despite high revenue

At $1.08M revenue and $789K cost, May 2025's 27% margin was the weakest in 18 months. High revenue months can mask margin erosion — this is exactly why tracking cost alongside revenue matters. Something drove cost up sharply in May: a large project delivery, subcontractor spend, or overtime. Worth investigating in your PSA time entries.

January dips are structural, not just seasonal

January 2026 at $771K is lower than January 2025 at $942K — a year-over-year decline of 18%. If this were purely seasonal, you'd expect roughly the same floor each year. The gap suggests some revenue from Q1 2025 hasn't been replaced or that project-based revenue from late 2024 hasn't carried forward into 2026 contracts.

H2 2025 stabilized between $927K and $1.06M

August through November 2025 showed the most stable revenue band in the dataset. That consistency across four months indicates recurring contract revenue is holding. The December and January dip is almost certainly driven by project-based work slowing, not by contract cancellations.

View DAX Query — Revenue and Margin by Quarter
-- Dataset not available for this report.
-- DAX will be authored in a future Phase 3 pass.

What to Do With This Data

Revenue tracking is only useful if it changes how you manage client relationships. Here's a practical action plan by segment.

Alert clients (drops >30%): Call this week

Burke, Armstrong and Morgan dropped 45% in one month. That's either a project ending or a warning sign. Either way, it needs an immediate conversation. Check their open tickets, review their contract renewal date, and verify whether they have any outstanding proposals or pending decisions. Don't wait for them to reach out.

Watch clients (drops 15–30%): Schedule a QBR

Craig-Huynh, Little Group, Martin Group, Wu-Jackson, Hahn Group, and Buchanan, Acosta and Chambers all declined between 15 and 30%. For these accounts, a quarterly business review is the right response. Bring data: show them their ticket volumes, SLA compliance, and what you've delivered. Position the conversation around value, not just billing.

Growing clients: Expand the conversation

Wall PLC (+14.3%), Thompson Contreras and Rios (+2.3%), and Kelley-Walsh (+2.1%) are all trending up. These are the clients most likely to say yes to expanded services, new projects, or additional seats. Start an upsell conversation while the relationship momentum is positive — not six months later when growth has stalled.

Stable clients: Protect the contracts

Lewis LLC, Richards Bell and Christensen, Lee-Dalton, and Patterson Riley and Lawson are all flat within ±2%. These clients represent your revenue floor. Prioritize renewing their contracts early, respond to their tickets fast, and make sure SLA compliance stays high. Flat revenue from a happy client beats trying to win back a churned one.

View DAX Query — Identify Clients with Sustained Decline
-- Dataset not available for this report.
-- DAX will be authored in a future Phase 3 pass.

Common Questions

Is the January decline seasonal or a real problem?
January often sees a dip after Q4 project close-outs. Compare against January 2025 ($942K) — this year's January ($771K) is about 18% lower. Some of that is natural; some may reflect project-dependent revenue not yet replaced.
Which clients should I call first?
Start with Burke, Armstrong and Morgan (45% drop) and Craig-Huynh (20% drop, largest account). Then check Wu-Jackson, Hahn Group, and Clements, Pham and Garcia — all dropped more than 20% with no obvious project milestone to explain it.
Why does May 2025 show such a low margin (27%)?
May 2025 had $789K in cost against $1.08M revenue — the highest cost month in the dataset. This could be a large project delivery, subcontractor billing, or a month with significant overtime. Worth investigating in your PSA time entries.
How is this different from a standard revenue report?
This report shows per-client MoM deltas, not just totals. A top-line revenue figure masks whether one client grew while three declined. The client-level view helps you act on the right relationships at the right time.
How often should I review this data?
Monthly is the minimum. For accounts above $20K/month, weekly tracking lets you catch billing anomalies before month-end. For accounts in "Watch" status, set a 30-day check to see if the decline continues or reverses. Most MSPs find that clients who drop two months in a row without a project explanation are at serious churn risk.
Should I include internal (non-billable) time in this analysis?
No. This report focuses on billed revenue only — what actually hits the invoice. Including internal time would inflate cost figures and distort margin calculations. Run a separate internal vs. client hours analysis to understand capacity allocation across the team.
What if a client's revenue drops but ticket volume stays the same?
That's worth investigating in detail. If ticket volume holds steady but billed revenue falls, it may mean time is going unbilled — a write-off or an approval bottleneck. Check the time entry compliance rate for that client's tickets and compare billed hours against worked hours in your PSA.

How MSPs Use Monthly Revenue Tracking

Revenue trends become more useful when they connect to specific business actions. These are the patterns MSP owners and account managers find most valuable in practice.

Account managers use MoM data to prepare QBR talking points

Walking into a quarterly business review with a chart showing revenue growth over 12 months is a different conversation than arriving without data. Clients who see that their spending has increased typically ask why — and that's an opportunity to show what you delivered. Clients whose revenue has declined may be quietly considering alternatives; this data lets you get ahead of that conversation.

Finance teams use it to forecast next quarter

If you can see that Q1 consistently runs 15–20% below Q4, you can plan staffing and cash flow accordingly. Many MSPs use three months of trailing revenue per client to set quarterly targets and flag accounts where actual performance is diverging from forecast before the month closes.

Operations teams use it to spot billing gaps

A drop in billed revenue that doesn't match a drop in ticket volume usually means something broke in the billing pipeline — time entries not approved, invoices stuck in draft, or a project billing milestone not triggered. Monthly comparison at the client level makes these gaps visible faster than waiting for a monthly invoice run to surface discrepancies.

Owners use it to identify renewal leverage

When a client's revenue has grown 20% year-over-year, that's the right time to renegotiate the contract rate. When revenue has declined, that's the time to focus on delivering visible wins before the renewal conversation. MoM data tells you which conversation you need to have — and when.

Generate this report from your own data

Connect Proxuma Power BI to your PSA, RMM, and M365 environment, use an MCP-compatible AI to ask questions, and generate custom reports - in minutes, not days.

See more reports Get started