Agreed records
2,730
Matching amount, currency, period and status. Ready for report review.
Subscription reconciliation
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.
2,730 agree; unresolved pairs stay separate.
Synthetic data. Deterministic comparison, no live integration.
Source: reconciliation-demo/result.json
| Evidence | Value / state |
|---|---|
| Agree | 2,730 |
| Differ | 240 |
| Need a person | 30 |
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
Zoomed exceptions · a separate scale, excluding agreed records.
Source: reconciliation-demo/result.json
| Outcome | Subscriptions |
|---|---|
| Agree | 2,730 |
| Need a person | 30 |
| Differ | 240 |
Reconciliation workflow
Synthetic data · deterministic comparison
Input
3,000 CRM and 3,000 billing rows; saved exports, no live connection.
Deterministic code
Exact subscription ID and the same monthly period. Duplicate or incompatible keys need review.
Deterministic code
Amount in integer cents, currency and normalized status. No assumed FX conversion or fuzzy matching.
Human review
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.
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.
These pairs remain unresolved. A reviewer must establish the currency treatment before any monetary comparison; the report makes no FX assumption.
| Subscription | CRM / Billing | Decision |
|---|---|---|
| SUB-00241 | EUR / USD | Pending |
| SUB-00242 | EUR / USD | Pending |
| SUB-00243 | EUR / USD | Pending |
| SUB-00244 | EUR / USD | Pending |
| SUB-00245 | EUR / USD | Pending |
| SUB-00246 | EUR / USD | Pending |
| SUB-00247 | EUR / USD | Pending |
| SUB-00248 | EUR / USD | Pending |
| SUB-00249 | EUR / USD | Pending |
| SUB-00250 | EUR / USD | Pending |
| SUB-00251 | EUR / USD | Pending |
| SUB-00252 | EUR / USD | Pending |
| SUB-00253 | EUR / USD | Pending |
| SUB-00254 | EUR / USD | Pending |
| SUB-00255 | EUR / USD | Pending |
| SUB-00256 | EUR / USD | Pending |
| SUB-00257 | EUR / USD | Pending |
| SUB-00258 | EUR / USD | Pending |
| SUB-00259 | EUR / USD | Pending |
| SUB-00260 | EUR / USD | Pending |
| SUB-00261 | EUR / USD | Pending |
| SUB-00262 | EUR / USD | Pending |
| SUB-00263 | EUR / USD | Pending |
| SUB-00264 | EUR / USD | Pending |
| SUB-00265 | EUR / USD | Pending |
| SUB-00266 | EUR / USD | Pending |
| SUB-00267 | EUR / USD | Pending |
| SUB-00268 | EUR / USD | Pending |
| SUB-00269 | EUR / USD | Pending |
| SUB-00270 | EUR / USD | Pending |
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 outcomesThis 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.
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.