The DIY Revenue Leakage Audit Template

You do not need a consultant to find revenue leakage. You need five contracts, their corresponding invoices, and about two hours of uninterrupted focus. This is the exact audit template we use internally, stripped down to the version you can run yourself this week.

The average B2B company leaks 1-5% of annual revenue through billing errors, missed escalators, and contract-invoice mismatches. On $10M in revenue, that is $100K-$500K per year. The audit below will tell you where yours is hiding.

Step 1: Select your audit sample

Pull your five highest-value active contracts. Not random ones. The biggest ones. Revenue leakage is proportional to contract value, so a 2% error on a $50K/month contract loses more than a 10% error on a $2K/month contract. Start where the dollars are.

For each contract, pull every invoice from the last 12 months. If you bill monthly, that is 12 invoices per customer, 60 total. Export them to a spreadsheet or just have the PDFs open. You need the signed contract and the actual invoices side by side.

Step 2: Check base rates

For each of the five contracts, compare the contracted rate to the invoiced rate. Line by line. If the contract says $150/hour and the invoice says $140/hour, flag it. If the contract says $12,000/month for the Professional tier and the invoice says $10,500/month, flag it. Rate mismatches are the most straightforward leak to find and the most common one caused by manual data entry during customer onboarding.

Do not assume the billing system is right. The billing system contains whatever someone typed into it. The contract is the source of truth.

Step 3: Check annual escalators

Look at each contract for escalator language: "annual increase," "CPI adjustment," "rate escalation," "price adjustment." If the contract includes an escalator, check whether the invoiced rate reflects it. A 3% annual escalator on a $20K/month contract that went unapplied for one year is $7,200 in missed revenue. For two years, $14,832. This compounds and it almost never gets caught because nobody re-reads the contract after it is signed.

Step 4: Check for unbilled overages

If any of your contracts include usage-based components with overage rates, pull the usage data. Compare actual usage to the contractual cap. If usage exceeded the cap, check whether the overage was billed. In our experience, roughly 40% of usage-based contracts have at least one month of unbilled overages. The usage data lives in the product database. The billing system does not know about it unless someone built the integration or manually reconciled.

Step 5: Check promotional discounts

Search each contract for introductory pricing, promotional discounts, or temporary rate reductions. If the contract says "20% discount for the first 6 months," count the months. If month 7 still shows the discounted rate, flag it. Promotional discounts that never expire are one of the easiest leaks to fix because the customer already agreed to the full price. You are not renegotiating. You are enforcing the existing terms.

Step 6: Check setup fees and one-time charges

Review each contract for one-time fees: setup fees, onboarding fees, implementation charges, data migration fees, training fees. Then check whether those fees actually appeared on an invoice. Setup fees get missed because they are billed once, often months after the contract is signed, and the person who closes the deal is not the person who generates the invoice.

Step 7: Check surcharges and pass-throughs

If your contracts include surcharges (fuel, regulatory, material cost pass-throughs, after-hours premiums), verify they are being billed. Surcharges are the most frequently omitted line item because billing systems rarely have a field for them. They require manual addition to each invoice, and manual processes fail silently.

Step 8: Score your findings

For each discrepancy, calculate the dollar impact: (Correct Amount - Billed Amount) x Number of Affected Periods. Rank them. The top three findings will almost certainly account for 80% of your total leakage. Those are your recovery priorities.

What to do with the results

You have two paths. Path one: fix the billing going forward and decide case-by-case whether to pursue retroactive recovery. Path two: issue true-up invoices for the historical gap. Most companies recover anything over $5,000 retroactively and correct anything under $5,000 on a go-forward basis.

If you found leakage in 5 contracts, you will find it in 50. The question is whether you want to spend 20 hours running this audit across your full book, or whether you want to automate it. RevRecovery does this analysis across every contract and every invoice continuously, flags discrepancies as they happen, and calculates the recovery value automatically. But the template above works if you have the time and the discipline to run it quarterly.