Revenue Leakage: Counting the Real Cost and Stopping the Bleeding

📷 Hero Image Placeholder

AI Prompt: Abstract visualization of cash flowing out of a cracked pipe or container labeled "MRR" in a dark server room environment, red liquid representing lost revenue, dramatic cinematic lighting, ultra-realistic, professional fintech editorial photography style, dark navy background

Replace with: revenue leakage concept image

Revenue leakage is money you've earned but haven't collected. For MSPs, it's the gap between what your vendors charge you and what you actually bill your clients. Unlike churn (which is visible) or bad debt (which is tracked), leakage is invisible by default — it only becomes visible when you look for it.

Defining Revenue Leakage in the MSP Context

MSP revenue leakage specifically refers to services delivered and paid for at the vendor level that never appear on client invoices. The most common form: Microsoft 365 licenses paid to Microsoft or a distributor that aren't reflected in the PSA agreement lines driving client billing.

Leakage is different from write-offs (intentional credits) and different from service delivery failures (where you didn't deliver what was billed). Leakage is the quiet kind — your system delivered the service, the vendor charged you, but your billing system never caught up.

How to Calculate Your Leakage Rate

The fastest rough estimate: compare your total Microsoft 365 vendor cost against your total Microsoft 365 billed revenue for the same month. The gap between them (after subtracting your intended margin) is your leakage.

More precisely: run a reconciliation between your vendor export and PSA export. Sum the delta quantities for each unmatched or underbilled row. Multiply by your average margin per seat. That's your monthly leakage in dollars.

Industry benchmark: most MSPs see 8–15% revenue leakage on their first audit. A 10% leakage rate on $30,000/month in Microsoft 365 billing = $3,000/month = $36,000/year walking out the door silently.

📷 Inline Image Placeholder

AI Prompt: Clean dark-theme chart showing monthly revenue leakage compounding over 12 months vs. leakage stopped at month 1, area chart, red shaded area representing lost revenue, dark background with white and red lines, professional data visualization style

Replace with: leakage compounding over time chart

Why Leakage Compounds Faster Than You Expect

Leakage isn't just the current month's gap — it's every month that gap existed and you didn't catch it. A 10-seat underbilling that started 8 months ago is 80 seat-months of lost revenue. At $22/seat margin, that's $1,760 you'll never recover without a conversation with the client.

Compounding works in both directions: the longer you wait to find leakage, the harder the back-billing conversation becomes. Most MSPs choose to write off leakage older than 2–3 months and focus on fixing going forward. The case for monthly reconciliation is precisely to prevent this forced write-off.

Plugging the Holes: The Fix

The fix isn't complicated — it's a process:

1. Designate an owner. Someone is responsible for running reconciliation monthly. Finance, ops manager, or a billing admin — it doesn't matter who, as long as it's one specific person.
2. Set a monthly calendar event. The last Friday of each month: export vendor data, export PSA data, run reconciliation, review results, update PSA, done.
3. Use the right tool. Manual spreadsheets miss fuzzy mismatches and take hours. An automated tool takes 20 minutes and catches everything.
4. Track your leakage ratio as a KPI. Watch it go from 10%+ to under 2% over 3–4 months as you clean up historical errors and prevent new ones.

Frequently Asked Questions

What is an acceptable leakage ratio?

Target below 2%. Most MSPs start at 8–15% on their first audit. Within 3 months of monthly reconciliation, you should be below 3%. Below 2% is excellent and reflects mature billing processes.

Can reducing leakage actually improve EBITDA?

Yes — and significantly. Recovering $2,000/month in leakage flows directly to EBITDA since the cost of service delivery is already sunk. It's often faster than acquiring a new client.

Do I need specialized software?

At very small scale (under 10 clients, simple SKU set), a spreadsheet can work. Beyond that, the time cost and error rate of manual reconciliation make purpose-built software the clear choice.