Tool 94 · Open Banking & APIs

Transaction JSON
Visualizer & Ledger

Paste a raw Open Banking API response — UK OBReadTransaction6 or FDX v5 format — and instantly see a sortable ledger, inflow/outflow breakdown, MCC merchant categories, running balance chart, and schema sanity checks. Nothing leaves your browser.

Zero PII · Client-Side Only UK OBReadTransaction6 · FDX v5 MCC Mapping · Cash Flow Analysis
Paste JSON Response
Load example:
No data leaves your browser. All processing is in-memory. Tab close = data gone.
Format
Auto-detect works for most responses. Select manually if parsing fails.
Display Options
Supported fields
AccountId · TransactionId · BookingDateTime · ValueDateTime · Amount · CreditDebitIndicator · TransactionInformation · MerchantDetails · ProprietaryBankTransactionCode · Balance
📋
No transactions loaded
Paste a JSON response in the Import tab and click Parse & Visualise to see the ledger.
📊
No data yet
Import a transaction JSON first to see the cash flow analysis.
UK OBReadTransaction6 Fields
FieldTypeRequiredNotes
FDX v5 Transaction Fields
FieldTypeRequiredNotes
MCC Code Reference
MCCCategoryIconRiskSCA Exemption Note
About This Tool ▼

What it does: Parses raw Open Banking JSON responses from UK CMA9 ASPSPs (OBReadTransaction6 schema) or US FDX v5 data providers, and renders a clean sortable ledger with running balance, MCC-based merchant categorisation, cash flow donut chart, and a schema sanity check panel that flags missing mandatory fields and data quality issues.

Who it's for: Fintech developers debugging Open Banking API integrations, QA engineers validating ASPSP responses, product managers reviewing account data quality, and compliance teams auditing transaction enrichment pipelines.

Data privacy: All parsing runs in your browser using native JSON.parse(). Nothing is sent to any server. The page stores no cookies and uses no analytics. Closing the tab clears all data.

Related tools: Tool 10 (API Explorer + Rate Limit Simulator) · Tool 16 (IBAN Validator + BIC Lookup) · Tool 17 (ISO 20022 Message Validator) · Tool 19 (SCA Exemption Calculator)

Built by: Post Oak Labs · AINumbers.co · CC BY 4.0