Developed and maintained by ProWorkstack · Development and review process
Compare completed billable work with invoices, subtract known adjustments, and estimate the gap still unexplained.
Read the guide: Completed Work Not Invoiced: Check the Gap Between Work and Billing
Your results
Enter your inputs and select Calculate.
How this calculator works
Eligible value = max(CRM billable value − documented exclusions, 0). Signed variance = eligible value − matched invoices. Unbilled gap = max(signed variance, 0). Yearly equivalent gap = period gap × 12 ÷ reporting months.
Worked example
For a year with 1,200,000 in eligible CRM value, 20,000 in legitimate exclusions and 1,140,000 in invoices, the unexplained gap is 40,000. A 25% recovery scenario is 10,000 per year.
Assumptions
Use matching customer group of records, currencies, recognition policies and date cutoffs. Defaults are illustrative. Converting to a yearly estimate assumes the selected period is representative.
Interpreting your results
A variance is a difference to investigate, not proof of lost revenue, fraud or tax liability. Investigate unmatched identifiers, invoicing delays, cancellations, credits and duplicates. Converting to a yearly estimate may be misleading for seasonal revenue.
Calculation formulas
- eligible
MAX(expected_revenue - exclusions, 0)- signed_gap
eligible - billed_revenue- unbilled_gap
MAX(signed_gap, 0)- annual_gap
unbilled_gap * 12/period_months- Yearly equivalent of unexplained billing gap
annual_gap- Unbilled gap for this period
unbilled_gap- Eligible work value minus invoices
signed_gap- Gap as a percentage of eligible work value
unbilled_gap / eligible * 100- 25% recovery: annual spending limit
annual_gap * 0.25
Frequently asked questions
Should I enter pipeline revenue?
No. Enter value that is already eligible for invoicing under the selected period and your billing policies.
Maintained by ProWorkstack · Last reviewed: 2026-10-04 · Development and review process