THE FINANCIAL GRAPH THAT EXPLAINS WHERE MONEY ACTUALLY WENT.
Relational tables store isolated numbers. PayTrace constructs a unified, multi-hop directed graph across payment rails, entities, invoices, switch queues, and intermediary escrow nodes — answering why money disappeared in milliseconds.
Why Relational Databases Fail for Financial Investigations
When an enterprise customer claims a ₹8.42 Lakh payment was executed but the ERP shows unpaid, the truth is distributed across 6 external systems. SQL queries fail because relationships are multi-directional, asynchronous, and non-deterministic.
The N+1 Join Explosion
Tracing a single settlement discrepancy across Banks, Gateways, ERPs, POs, and Emails requires dozens of recursive SQL joins across schema-isolated databases, taking hours of manual engineer effort.
Index-Free Adjacency
PayTrace stores transactions, contracts, and settlement batches as interconnected graph vertices. Traversal runs at O(1) per hop regardless of total database volume, discovering causal bottlenecks instantly.
Heterogeneous Edge Types
Relationships carry semantic payload: [ISSUED_FOR], [CAPTURED_IN], [SWEPT_TO_BATCH], and [FAILED_WEBHOOK]. Every edge carries timestamps, confidence weights, and audit hashes.
Layer 1: Real-Time Payment Rails & Switches
PayTrace models low-level bank switch messages, ISO 8583 packets, NPCI / NEFT / RTGS settlement logs, and gateway token events as an immutable directed execution graph.
Customer Initiation
Checkout session spawned, card tokenized or corporate netbanking intent recorded.
AUTH_88921Core Banking Debit
Bank switch verifies balance, executes debit, and generates unique RRN.
881902849102Intermediary Escrow
Processor aggregates captured funds into daily clearing batch container.
SB-9018Nodal Disbursement
Final bank wire to vendor account or reversal trigger upon discrepancy.
PENDING_SWEEPEntity Resolution & Canonical Counterparty Mapping
Counterparties appear under dozens of aliases across banks, billing systems, and payment portals ("ABC Ind", "ABC Industries Ltd", "ABC-Corp Delhi").
PayTrace's Entity Resolution Agent performs multi-identifier graph clustering across GSTIN, PAN, Bank IFSC/Account pairs, corporate LEIs, email domains, and phone prefixes, unifying disparate records into a single canonical entity node with 99.8% precision.
- ✓ Fuzzy Jaro-Winkler + Semantic embedding name matching
- ✓ Corporate hierarchy & subsidiary parentage traversal
- ✓ Bank account modification risk radar (BEC fraud prevention)
{
"canonicalEntityId": "ENT-ABC-IND-001",
"primaryName": "ABC Industries Private Limited",
"gstin": "07AAACA1234F1Z5",
"pan": "AAACA1234F",
"resolvedAliases": [
{ "alias": "ABC Ind.", "source": "HDFC Statement" },
{ "alias": "ABC Industries", "source": "Razorpay Checkout" },
{ "alias": "ABC-Corp AP Portal", "source": "Outlook Thread" }
],
"linkedBankAccounts": [
{ "account": "00210200019281", "ifsc": "HDFC0000021", "verified": true }
],
"riskRating": "LOW_EXPOSURE",
"totalHistoricalVolume": "₹14.82 Cr across 1,420 txns"
}
Linking Unstructured Contracts & Invoices to Transaction Vertices
A financial transaction without its binding legal contract or tax invoice is an unanchored number. PayTrace binds multimodal document nodes directly into the money trail graph.
Purchase Order Vertex
Extracts line items, delivery milestones, unit price caps, and authorized signatories from scanned PDFs and procurement APIs.
Tax Invoice Vertex
Performs OCR verification on GST rate breakdown, SAC/HSN codes, TDS deductions, and bank remittance instructions.
Master Agreement Vertex
Evaluates contracted payment terms (Net 30/60), penalty clauses, interchange schedules, and dynamic early settlement rebates.
Time-Delta Analysis & Asynchronous Causal Ordering
In banking, chronological arrival does not equal causal order. Clock drift, webhook retry delays, and batch clearing schedules obscure what actually happened first. PayTrace builds a Directed Acyclic Graph (DAG) with nanosecond timestamp normalization.
Chronological Illusion vs Causal DAG
A bank debit event may be ingested by the ERP at 14:15:00, while a customer dispute email arrives at 14:12:00. PayTrace evaluates switch transit latencies to reconstruct the exact true-world sequence of events.
Settlement Batch Window Alignment
Discrepancies often occur because transactions miss daily clearing cut-offs (e.g., 23:30 IST batch closure). PayTrace maps discrete batch windows across clearing houses to verify whether funds are delayed or permanently lost.
23:30:00 IST (Daily)02:00:00 IST (+1 Day)24.5 HoursBayesian Path Certainty & Graph Neural Inference
When direct foreign keys or UTR references are stripped in bank narratives, PayTrace applies probabilistic relationship scoring across amount, timestamp proximity, fee tolerances, and counterparty graph embeddings.
Amount & Fee Tolerance
Accounts for processor MDR cuts, GST deductions, and currency conversions. Reconciles a ₹8,42,000 invoice with a ₹8,25,160 net settlement based on contracted 2% fee schedules.
Temporal Window Decay
Applies exponential time-decay kernels: correlations between an invoice and bank credit drop as the elapsed time exceeds standard SLA windows without explicit UTR link.
Graph Structure Embedding
Node2Vec and GNN embeddings evaluate historical transaction topological motifs, assigning confidence ratings (e.g., HIGH 96.8% certainty) to resolved paths.
Live Multi-Hop Financial Graph Engine
Pan, zoom, drag nodes, filter relationship layers, and inspect the real-time topology of Case #PT-92881. Click any node to open the live inspector.
Case Study: Reconstructing Missing Settlement #PT-92881
Follow how PayTrace traversed 7 graph hops in 4.2 seconds to uncover why ₹8,42,000 from ABC Industries was marked "UNPAID" in the SAP ERP ledger.
Invoice INV-8821 matched with Gateway AUTH_88921
Customer initiated payment via corporate checkout. Gateway recorded capture status for ₹8,42,000 and debited customer account via HDFC Core Switch (RRN 881902849102).
Webhook Dispatch Timeout (HTTP 504)
The payment gateway attempted to notify the SAP ERP webhook endpoint. Due to a 5-second cloud gateway timeout, the event dropped without retrying. The ERP remained in an "UNPAID" state.
Funds Trapped in Clearing Batch SB-9018
Because the webhook failed to link the merchant descriptor, the gateway clearing engine held the ₹8,42,000 settlement batch under exception code EX_UNMATCHED_DESC.
Automated Root Cause & Remediation
The money was neither stolen nor lost — it was trapped in Gateway Escrow Batch SB-9018 due to dropped webhook communication with SAP S/4HANA.
2. Post credit memo to SAP Invoice INV-8821.
Autonomous Subgraph Pattern Detection
PayTrace runs graph mining algorithms to detect topological anomalies that indicate fraud, leakage, or systemic settlement blockage.
Disbursement Splintering
Single large PO split into multiple micro-invoices just below internal authorization limits paid to newly created beneficiary accounts.
FAN_OUT_SPLIT_DISBURSEMENTEscrow Sink Accumulation
Funds flowing into payment processor intermediary nodes without corresponding daily sweep edges to enterprise operating accounts.
UNSWEPT_ESCROW_TRAPCircular Settlement Loops
Repeated invoice-to-refund-to-credit cycles indicating synthetic transaction wash-trading or merchant account cycling.
DIRECTED_CYCLE_DETECTEDPayTrace Graph vs Traditional Relational SQL
Comparing investigation performance across multi-hop enterprise financial topologies.
| BENCHMARK DIMENSION | RELATIONAL SQL (POSTGRES / MYSQL) | PAYTRACE FINANCIAL GRAPH ENGINE |
|---|---|---|
| 1-to-2 Hop Lookup | 12ms (Standard indexed query) | 1.2ms (Index-free pointer traversal) |
| 4-to-6 Hop Root Cause Traversal | 4,200ms+ (Recursive JOIN explosion / Timeout) | 4.2ms (Constant-time neighbor walk) |
| Heterogeneous Entity Resolution | Requires brittle ETL scripts & static foreign keys | Probabilistic clustering across GSTIN, PAN & Bank pairs |
| Unstructured Document Linking | Opaque file blobs stored outside relational model | OCR vertices embedded natively into transaction paths |
| Explainability & Audit Provenance | Disjoint query logs; manual timeline stitching | Interactive topological causal graph with SHA256 proofs |
Trace Money Trails in Sub-Seconds with PayTrace AI.
Deploy PayTrace onto your payment switches, ERP ledgers, and document vaults in under 48 hours with zero disruption to legacy workflows.