Billing reconciliation is the practice of systematically comparing what customers should pay against what they actually pay. It's the most reliable method for detecting revenue leakage — and the most commonly skipped process in subscription finance.
Most companies trust their billing system. The billing system is only as correct as the humans who configured it. Every pricing change, plan migration, discount, and contract amendment is an opportunity for the configuration to drift from reality. Billing reconciliation catches that drift.
Why Billing Reconciliation Matters
Consider a SaaS company with 2,000 customers, 5 pricing plans, quarterly pricing updates, and a sales team authorized to offer custom discounts. That's thousands of billing configurations, changing regularly, managed by multiple people across multiple systems.
Without reconciliation, errors persist until someone manually notices — which may be never, because customers don't complain about being undercharged. With daily reconciliation, errors are caught within 24 hours and corrected before they compound.
The data bears this out: companies that run comprehensive billing reconciliation maintain leak rates below 0.5%. Companies that don't reconcile run 3-5%. On $10M ARR, that's the difference between $50K and $500K in annual leakage.
The 5 Types of Billing Reconciliation
1. Price-to-Invoice Reconciliation
The most fundamental check: does the amount on each invoice match the expected amount based on the customer's plan, add-ons, and discounts?
How to run it:
- Extract the current plan and pricing for every active subscription
- Calculate the expected charge (plan price + add-ons - active discounts)
- Compare against the actual invoice amount
- Flag any variance above your threshold ($1 for most companies)
Common findings: Grandfathered pricing not updated, promotional rates past expiry, add-on pricing changed but not propagated, currency conversion using stale rates.
2. Contract-to-Billing Reconciliation
For customers with signed contracts (especially enterprise deals), compare every contractual term against the billing system's configuration.
Key fields to reconcile:
- Base subscription rate and billing frequency
- Price escalation clauses (annual increases)
- Minimum commitment amounts
- Overage pricing and thresholds
- Discount terms and expiration dates
- Auto-renewal terms
Common findings: Annual 3-7% price escalation in the contract but not in the billing system. Minimum commitments defined but not enforced. Overage pricing specified but not configured. These gaps exist in 10-20% of enterprise contracts.
3. Usage-to-Billing Reconciliation
For usage-based components, compare the metering system's recorded usage against the billing system's charged usage.
How to run it:
- Pull total metered usage per account per billing period from your metering system
- Pull total billed usage per account per billing period from your billing system
- Calculate the variance for each account
- Flag any account with variance above 0.5%
Common findings: Rounding policies that systematically undercharge, timezone mismatches between metering and billing periods, pipeline delays causing usage events to land in the wrong period, tier boundaries not matching current pricing.
4. Entitlement-to-Plan Reconciliation
Compare what each customer is using against what their plan includes. This catches overprovisioning — customers getting more than they're paying for.
What to compare:
- Active seats vs. plan seat limit
- Accessible features vs. plan feature set
- Storage/usage vs. plan limits
- API rate limits vs. configured limits
Common findings: Seat counts exceeding limits without overage billing, enterprise features accessible to lower-tier accounts after migration, trial features persisting after conversion to a plan that doesn't include them.
5. Collections-to-Revenue Reconciliation
Compare collected cash against recognized revenue. This catches revenue that was recognized but never collected — or collected but not recognized.
Key metrics to track:
- Invoice-to-collection rate by customer segment
- Write-off rate as percentage of revenue
- Credit/refund rate as percentage of revenue
- Bad debt rate compared to industry benchmark
Automation: From Manual to Continuous
Running these 5 reconciliation types manually requires 3-5 days of analyst time per quarter. That's 12-20 days per year — and it only catches leaks every 90 days.
Automated billing reconciliation runs daily (or continuously), catches leaks within 24 hours, and scales to any number of customers without additional analyst time. The setup cost is hours; the ongoing cost is near-zero.
Automate Your Billing Reconciliation →
For a detailed walkthrough of specific detection checks, see our guide on how to detect revenue leakage. For the full picture, read our complete revenue leakage guide.