Payment Reconciliation
Close your books without the manual reconciliation work.
Automatically cross-reference every payment against every invoice with a 3-pass matching algorithm that flags discrepancies, ages balances, and identifies write-off candidates. Cut month-end close time in half.
Runs 3-pass matching across payment and invoice records.
How it runs
Multi-agent orchestration — here's the flow, step by step.
Call verslay_recall to retrieve prior reconciliation run baselines, known CRM-to-payment gap patterns, and reconciliation thresholds from memory. Connect to HubSpot to pull all closed-won deals and their expected payment amounts, payment dates, and associated contact/company IDs for the specified period. Produce a CRM expected-revenue ledger as Phase 1 output.
crm scannerConnect to Stripe to pull all successful charges, refunds, and disputes for the same period as Phase 1 crm-scanner: charge IDs, amounts, customer IDs, and metadata. Cross-reference Stripe customer IDs and metadata against HubSpot deal contact IDs to begin matching. Produce a raw payment dataset to pair with the CRM ledger.
payment scannerConsume Phase 1 CRM expected-revenue ledger and Phase 1 Stripe payment dataset. Perform systematic matching: for each HubSpot deal, find the corresponding Stripe charge(s). Flag unmatched deals (CRM deal with no payment), unmatched payments (Stripe charge with no CRM deal), amount mismatches (deal value ≠ charged amount), and timing gaps (payment date > deal close date by >30 days). Produce a categorized discrepancy report for Phase 3.
reconciliation checkerIn parallel with reconciliation-checker, call verslay_web_search for 'HubSpot Stripe reconciliation best practices 2026' and 'CRM to payment gateway matching standards' to surface tooling and process benchmarks. Call verslay_news_search for any HubSpot or Stripe API change announcements that may explain systematic matching failures. Produce a reconciliation standards package for Phase 4.
web researcherConsume Phase 2 discrepancy report and Phase 2 reconciliation standards. Aggregate discrepancies by type (unmatched deal, unmatched payment, amount mismatch, timing gap) and calculate total at-risk revenue. Call verslay_chart_create to generate a discrepancy-by-type bar chart and a reconciliation-accuracy trend chart (this period vs prior periods from memory). Produce a synthesis package for Phase 5.
data analystConsume Phase 3 charts and synthesis, Phase 2 discrepancy report, and Phase 2 reconciliation standards. Write a payment reconciliation brief: match rate summary, discrepancy breakdown by type, total at-risk revenue, root cause analysis for top discrepancy patterns, and recommended remediation actions (CRM hygiene fixes, Stripe metadata tagging, manual review items). Call verslay_memorize to store the current period's match rate, discrepancy totals, and top gap patterns. Pass brief to distributor.
executive briefing writerReceive the reconciliation brief from executive-briefing-writer. Distribute to the configured finance team email or Slack channel. Confirm delivery and log the send timestamp.
distributorRequired Agents
7- crm-scanner
- payment-scanner
- reconciliation-checker
- web-researcher
- data-analyst
- executive-briefing-writer
- distributor
Connections
Required
What it does
- 3-pass matching algorithm
- Discrepancy classification
- Aging buckets through 90+ days
- Write-off candidate flagging
- Fuzzy match confirmation queue
Example prompt
Which time period should I reconcile (last month or specific date range)? I will flag unmatched payments, partial payments, duplicates, and missing invoices, group discrepancies by client/amount/age, and produce an action-item report.
Ready to deploy Payment Reconciliation?
Start free. One click, full agent orchestration.
Get Started Free →