Billing operations
Usage-to-Invoice Reconciliation: Compare Quantities Before Money
By the Orvlin team · · 2 min read
Usage to invoice reconciliation: what to decide
A $10,000 invoice run matches last month’s total, so everyone assumes it is correct. But one account may be underbilled by $500 and another overbilled by $500. A matching aggregate is not proof of accurate customer charges.
Use account, meter and period as reconciliation keys. Explain intentional differences such as included allowances, exclusions, corrections and negotiated rates. Then reconcile financial amounts separately, including tax and credits. Each layer tests a different assumption.
How this works in practice
Product records show 12,000 completed jobs. The meter has 11,500 and the invoice bills 10,500 after a 1,000-job allowance. The allowance explains the last difference but not the first 500 missing jobs. Investigate ingestion before changing pricing.
What can go wrong
Payment reconciliation is a separate step. An invoice can be accurate but unpaid, or a payment can cover several invoices. Do not interpret collected cash as evidence that every usage quantity was billed correctly.
Questions for your team
- Choose stable reconciliation keys.
- Compare source counts with accepted meter quantities.
- Explain allowance and adjustment differences.
- Review amount and payment reconciliation separately.
Frequently asked questions
- Does every difference indicate an error?
- No. Differences can be intentional, but they need a documented reason. Unexplained gaps should not be normalized merely because they recur.