Billing reconciliation: how to find cross-system mismatches.
Billing reconciliation checks whether the commercial agreement, billing setup, invoices, and recorded payments tell a consistent story for the same customer and period.
Define what you are reconciling
Choose a customer group, service period, and the sources involved. A comparison of CRM and invoices answers a different question from a comparison of payments and bank settlements.
Document the agreement that defines the expected charge. Preserve amendments and approved credits rather than relying on a stale opportunity value.
Billing reconciliation and payment reconciliation
Billing reconciliation asks whether the customer was charged according to the agreement. Payment reconciliation asks whether the recorded money movement matches the expected payment records.
An invoice can be fully paid and still use the wrong commercial amount. Check the agreement and invoice before assuming that a matching payment proves correct billing.
Prepare the records for a meaningful comparison
Match stable customer IDs and normalize billing frequency, currency, tax treatment, and service periods. Retain timestamps so normal processing delays can be explained.
Agree on a processing window and identify expected exceptions. Different update times should not automatically become billing errors.
Compare agreement, subscription, invoice, and payment
Check the approved amount and start date against subscription settings, then compare those settings with the issued invoice. Review credits and usage separately where they affect the total.
Once the invoice is explained, match payments and outstanding balances. Distinguish missing invoices, underbilling, partial payments, and unapplied credits.
Investigate exceptions with a named owner
Attach the relevant source records and identify the exact field or event that differs. Finance, billing, or RevOps should confirm the expected outcome before a correction.
After the correction, verify the invoice and downstream records. If a mapping or handoff caused the issue, address that cause and rerun the comparison.
Payment matches, but the invoice amount is wrong
Illustrative example. These are sample records.
| Field | CRM or agreement | Billing record |
|---|---|---|
| Approved monthly amount | $1,200 | $900 invoice |
| Recorded payment | $900 received | $900 invoice paid |
| Customer and period | CUST-1042 / October | CUST-1042 / October |
The $900 payment can reconcile to the invoice while a $300 agreement-to-billing difference remains. Investigate the approved charge before classifying the gap.
Bring the issue and its evidence together.
Explore how ResolveNow is being built to help your team investigate and track issues across systems.
