← Back to all demos

Subscription reconciliation

Do CRM and billing agree?

2,730 agree, 240 differ, 30 need a person. Inspect the differences and keep unresolved cases visible.

Synthetic data · 3,000 CRM and 3,000 billing rows compared by deterministic rules against known expected outcomes. Not a customer deployment.

240 differ · 30 need a person

2,730 agree; unresolved pairs stay separate.

Synthetic data. Deterministic comparison, no live integration.

  • Agree
  • Need a person
  • Differ

Source: reconciliation-demo/result.json

View data table
240 differ · 30 need a person
EvidenceValue / state
Agree2,730
Differ240
Need a person30

Most agree. The exceptions stay visible.

2,730 of 3,000 subscriptions agree; 240 differ and 30 need a person.

Synthetic data. One subscription per outcome; needing a person is kept separate from a confirmed difference.

91 % agree

  • Agree2,73091.0%
  • Need a person301.0%
  • Differ2408.0%

270 not agreed

Zoomed exceptions · a separate scale, excluding agreed records.

  • Need a person3011.1%
  • Differ24088.9%

Source: reconciliation-demo/result.json

View data table
Most agree. The exceptions stay visible.
OutcomeSubscriptions
Agree2,730
Need a person30
Differ240

Reconciliation workflow

From paired records to a review queue

Synthetic data · deterministic comparison

  1. Input

    CRM + billing rows

    3,000 CRM and 3,000 billing rows; saved exports, no live connection.

  2. Deterministic code

    Match the key

    Exact subscription ID and the same monthly period. Duplicate or incompatible keys need review.

  3. Deterministic code

    Compare the fields

    Amount in integer cents, currency and normalized status. No assumed FX conversion or fuzzy matching.

  4. Human review

    2,730 / 240 / 30

    Agree / differ / need a person. Inspect the differences and decide the treatment of unresolved pairs.

Boundary: comparison creates evidence and unresolved cases for a person. No billing, CRM or currency correction is written automatically.

Agreed records

2,730

Matching amount, currency, period and status. Ready for report review.

Confirmed differences

240

180 amount differences and 60 status differences under the declared comparison rules.

Explicit uncertainty

30

USD pairs require review. No assumed FX conversion or automatic correction.

Flagged amount delta

€900

Billing minus CRM for supported flagged pairs. A difference to investigate, not recovered revenue.

Checked against the expected result

240 of 240 known test discrepancies detected · 0 false positives · 0 missed discrepancies · 0 cents error in the supported amount total.

All 3,000 subscription outcomes, per-pair amount deltas and reason codes match the expected manifest, including the 30 review cases. These results apply to this controlled dataset and rule contract. They do not establish error-free performance on future customer data.

SUB-00001 · discrepancy

CRM: €49.00 · active

Billing: €54.00 · active

Amount €49.00 to €54.00

amount mismatch

SUB-00181 · discrepancy

CRM: €49.00 · active

Billing: €49.00 · past due

Status active to past due

status mismatch

SUB-00241 · review

CRM: €49.00 · active

Billing: USD 49.00 · active

Currency EUR to USD

unsupported currency

SUB-00271 · match

CRM: €49.00 · active

Billing: €49.00 · active

All compared fields agree.

Inspect all 30 pending review cases

These pairs remain unresolved. A reviewer must establish the currency treatment before any monetary comparison; the report makes no FX assumption.

Reconciliation review queue · recorded pending cases
SubscriptionCRM / BillingDecision
SUB-00241EUR / USDPending
SUB-00242EUR / USDPending
SUB-00243EUR / USDPending
SUB-00244EUR / USDPending
SUB-00245EUR / USDPending
SUB-00246EUR / USDPending
SUB-00247EUR / USDPending
SUB-00248EUR / USDPending
SUB-00249EUR / USDPending
SUB-00250EUR / USDPending
SUB-00251EUR / USDPending
SUB-00252EUR / USDPending
SUB-00253EUR / USDPending
SUB-00254EUR / USDPending
SUB-00255EUR / USDPending
SUB-00256EUR / USDPending
SUB-00257EUR / USDPending
SUB-00258EUR / USDPending
SUB-00259EUR / USDPending
SUB-00260EUR / USDPending
SUB-00261EUR / USDPending
SUB-00262EUR / USDPending
SUB-00263EUR / USDPending
SUB-00264EUR / USDPending
SUB-00265EUR / USDPending
SUB-00266EUR / USDPending
SUB-00267EUR / USDPending
SUB-00268EUR / USDPending
SUB-00269EUR / USDPending
SUB-00270EUR / USDPending
Download the unresolved cases
Rules, evidence and limits

Exact stable subscription ID, same monthly period, EUR integer cents and explicit normalized statuses. No fuzzy matching. Duplicate IDs, unsupported currencies, unknown statuses, invalid amounts and incompatible periods require review. Missing counterpart records are flagged without inventing an amount.

The input rows, expected manifest and all outcomes are downloadable. No live HubSpot/Stripe connection or write-back occurs. Tax, discounts, proration and currency conversion require an agreed extension to the rules. Investigation time, reviewer acceptance and customer savings have not been measured.

Inspect the recorded verification report Download inputs, expected cases and all outcomes
Read why this step uses no model
Technical run details

This reconciliation uses deterministic code and makes no model calls. Financial totals are checked against known expected values.

Input and expected-result digests are saved with the report.

Investigate your CRM and billing workflow

A customer pilot would agree the comparison rules first, run against an approved reference set, then measure report acceptance and remaining investigation work. That is how we would establish correctness and economic value for the actual process.