Powered by the TrustRelay Fabric
Reconciliation Studio
Deterministic bank-to-GL reconciliation with audit-ready evidence.
Reconciliation Studio is powered by the TrustRelay Fabric, mapping bank outcomes to payout intents with cryptographic evidence for your auditors.
Problem
Reconciling bank outcomes (ACH settled, wire cleared, check returned) to GL entries is manual, error-prone, and lacks audit-ready evidence. Teams spend hours matching spreadsheets, chasing exceptions, and explaining gaps to auditors.
Risk
Unreconciled exceptions, delayed monthly close, failed audits, unclear liability for returned payments. No systematic way to prove a payout settled vs. returned.
Solution
Reconciliation Studio automates bank file ingest, maps outcomes to payout intents, tracks settled/returned/exception statuses, and generates NetSuite-ready CSV exports. Every reconciliation event captured as immutable evidence.
Core Capabilities
Bank File Ingest
Automated processing of bank outcome files (ACH returns, wire confirmations, check clearings). Intelligent parsing with validation and error handling.
ML-Assisted Record Matching
Machine learning model scores match candidates between bank lines and payout intents. High-confidence matches auto-reconcile; lower-confidence candidates are ranked for faster manual resolution.
Confidence-Weighted Matching
Every auto-match includes confidence score and matching rationale. Auditors can verify why each bank line was paired with a specific payout intent.
Intelligent Exception Prioritization
AI ranks exceptions by likelihood of match and business impact. AP analysts work the highest-value exceptions first, reducing time-to-close.
NetSuite CSV Export
Generate GL-ready CSV files with intelligent account mapping. Settled payouts map to expense accounts, returns to AR or suspense with configurable rules.
Audit Trail Integration
All reconciliation events, match scores, and GL exports logged to Evidence Vault. Full transparency on how each transaction was reconciled.
How It Works
Bank File Upload
Bank sends outcome file (ACH NACHA, wire confirmation, check clearing report) to S3. File Ingest Service triggers reconciliation job.
Outcome Parsing & Matching
Fabric parses file, extracts payout IDs or trace numbers, matches to approved intents. Statuses updated: SETTLED, RETURNED, or EXCEPTION for unmatched.
GL Export Generation
Reconciliation Studio generates NetSuite CSV with journal entry rows. Settled payouts map to expense accounts, returns to AR or suspense.
Evidence & Audit Trail
Every reconciliation, outcome status change, and GL export logged to Evidence Vault. Auditors can trace any GL entry back to original payout intent and bank confirmation.
Connection to TrustRelay Fabric
Payout Intent Lifecycle
Fabric stores payout intents from Policy Engine decisions. Reconciliation Studio updates intent status (pending → settled → exported) as bank outcomes arrive.
Vendor Context
GL export includes vendor name, bank account (last 4), and payout metadata from Fabric. Controllers can trace every NetSuite journal entry to specific vendor and intent.
Evidence Vault Snapshots
Reconciliation events (matched, returned, exported) captured as evidence. Immutable proof for auditors showing payout → bank outcome → GL entry lineage.
For Your CFO
Reconciliation Studio closes the loop on payouts. Instead of manual spreadsheet matching, the system deterministically maps bank outcomes to payout intents. You know what settled, what returned, and what's stuck in exception.
NetSuite integration is clean. GL-ready CSV exports with proper account mapping. No more re-keying, no more "why doesn't this balance," no more Excel forensics at month-end.
Auditors get evidence, not explanations. Every reconciliation has a trail: original intent, policy decision, bank outcome, GL export timestamp. No "trust the AP team" — evidence is cryptographically immutable.