Deal value reconciliation
Deals where contract value does not match issued + drafted invoices plus pending schedule items. Use this to find data-quality issues so billing forecasts stay accurate.
| Deal | Customer | Ccy | Contract value | Invoiced | Remaining schedule | Expected total | Difference |
|---|
All amounts are net (excl. VAT) in each deal's own currency (EUR + USD are never mixed). "Invoiced" sums net_amount of draft/issued/sent/paid/overdue invoices, excluding cancelled, soft-deleted, and storno invoices (the cancelled original they negate is already excluded); credit notes net out automatically. "Remaining schedule" sums only pending billing schedule items (draft_created and covered_by_prepayment items are already represented in Invoiced). ARR-neutral classified concessions are added back to the expected total so one-off goodwill credits don't show as a contract gap. Red = under-billed vs contract, amber = over-billed.