Leakage report, March sample
- Sample: 8 lines; 5 with a difference.
- Classed as leakage: 0 cases, EUR 0.
- Classed as valid exceptions: 0 cases, EUR 0.
Financial Intelligence · Expanded Financial Intelligence
Revenue Assurance
Find possibly unbilled deliveries, missing invoices, incorrect contract pricing, expired entitlements, missed renewals and other revenue leakage.
Demonstration: Kestrel Mobile (fictional) · Telecommunications. Fictional data and a scripted answer.
The situation
- Organisation
- Kestrel Mobile (fictional)
- Who is asking
- Revenue assurance lead
- Industry
- Telecommunications
- What happened
- Billed revenue per account has drifted below what the usage records say should have been billed.
The question asked
Where did we under-bill last month, and how much of it is real leakage rather than a valid exception?
What it reads, and who can see the result
- Rated usage, March databaseUsage records rated at the contracted plan, read only.
- Invoices, March exportThe billing system's invoice lines.
- Discount policy documentApproved discount limits by plan.
- Reads
- Usage and invoice lines for the accounts in the sample, and the discount policy.
- Does not read
- Call content, customer contact details or payment cards.
- Permission
- A read-only reporting role granted by the billing platform owner.
- Who sees it
- Revenue assurance and the head of billing.
Try it
Review each flagged record: confirm it or dismiss it. The totals and the answer below follow your decisions.
| Account | Plan | Line | Difference (EUR) | Finding | Decision |
|---|---|---|---|---|---|
| ACC-1042 | Business 20 GB | Monthly fee | 0 | Matched | None needed |
| ACC-1077 | Business 20 GB | Roaming, 9 days | 1,860 | Usage rated, never invoiced | |
| ACC-1101 | Enterprise 100 GB | Monthly fee | 940 | Billed on the cheaper plan after an upgrade | |
| ACC-1130 | Enterprise 100 GB | Discount | 2,300 | Discount 22%: policy allows 15% | |
| ACC-1155 | Business 5 GB | Monthly fee | 0 | Matched | None needed |
| ACC-1190 | Business 5 GB | Credit note | 410 | Credit issued twice for one fault | |
| ACC-1204 | Enterprise 100 GB | Promotion | 1,225 | Promotion applied after its end date | |
| ACC-1233 | Business 20 GB | Monthly fee | 0 | Matched | None needed |
- Flagged
- 5 of 8 · EUR 6,735
- Leakage
- 0 · EUR 0
- Valid
- 0 · EUR 0
- Undecided
- 5 · EUR 6,735
The answer
Simulated answer. Written for this fictional case, not produced by a live model. Only the figures in it are computed, from what you decided above.
5 of 8 sampled lines show a difference of EUR 6,735.
Three differences are mechanical (usage never invoiced, a plan not updated after an upgrade, a credit issued twice) [S1]. Two are policy questions: a discount above the allowed limit and a promotion still applied after its end [S2]. A policy question can be a valid exception if someone with authority approved it, which the data cannot show.
You have classed 0 as leakage (EUR 0) and 0 as valid (EUR 0). 5 cases (EUR 6,735) are undecided.
Relies on: S1 · Rated usage vs invoice lines, March sampleS2 · Discount policy v4
Review and approval
The head of billing decides. Approving the leakage classification starts recovery and rate corrections for the cases classed as leakage. It does not change any invoice by itself.
Not ready to approve. 5 flagged cases are still undecided. Confirm or dismiss each one first.
In the product this is a different person with the right permission. Here you play that role to see the rule.
What it produces
Control to add
- Block a promotion line from rating after its end date.
- Require a second approver for any discount above policy.
Limits of this example
- This is a sample, not a population: the total is not an estimate for all accounts.
- Whether a discount above policy was approved is not in the data and must come from the account owner.
- This is a scripted demonstration on fictional data. No model was called and no real organisation, person or result is shown.
More in Financial Intelligence
- Overview and reportingLeaders see finance through spreadsheets that disagree, assembled by hand before every meeting.
- Revenue and profitabilityRevenue leaks quietly, and it is hard to see which customers, products or sites actually make money.
- Costs and optimisationSpend grows across suppliers, licences, cloud services and people with no single place to see what is wasted.
- Financial governanceCash, risk and unusual transactions are watched by different people with different tools, and action is slow.
- Bank-to-Ledger ReconciliationMatch authorised bank transactions, accounting records, settlements and invoices, and find entries that are unmatched, duplicated, missing or delayed, with the matching…
- Multidimensional Profitability IntelligenceCalculate supported profitability and margin by customer, contract, project, product, location, department and business unit, respecting the accounting and allocation as…
- AI Cash-Flow ForecastingProduce source-backed cash forecasts with scenario ranges and cash-shortfall warnings, showing assumptions, confidence limits and forecast against actual.
- Contract-to-Invoice VerificationCompare contracts, purchase orders, agreed rates, invoice charges, quantities, tax and payment terms, and surface exceptions for review.
The Financial Intelligence story · This capability in the full register