For Banking, Insurance & Capital Markets

    Extract data from fixed-width mainframe reports at enterprise scale.

    Clean, audit-ready data from the reports your finance and risk teams already run.

    • 01Land settlement, GL, and claims runs in your warehouse before BOD, reconciled and ready.
    • 02Process headers, detail, totals, and reserves in a single pass, with parent-child relationships preserved.
    • 03Audit-grade reconciliation across 1,000+ pages in seconds.
    FW-SETTLE-2025-1215.txt
    FEDERAL RESERVE BANK OF NEW YORK DAILY SETTLEMENT REPORT FEDWIRE FUNDS SERVICE REPORT ID: FW-SETTLE-2025-1215 -------------------------------------------------------------------- DATE: 12/15/2025 TIME: 18:30:02 EST PAGE: 1 OF 14 PARTICIPANT: JPMORGAN CHASE BANK NA ABA: 021000021 ACCOUNT: 0218-4403-7 RESERVE BAL: $847,291,403,228.14 SECTION 1: TRANSACTION SUMMARY BY MESSAGE TYPE -------------------------------------------------------------------- MSG DESCRIPTION SENT CNT SENT AMOUNT 1000 BASIC FUNDS TRANSFER 14,823 287,493,021,847.50 1001 BASIC FT - DRAWDOWN 482 8,921,304,527.00 1500 FOREIGN TRANSFER 3,847 94,728,301,482.25 3000 SECURITIES (DVP/RVP) 6,721 124,839,201,748.25 4000 BANK-TO-BANK TRANSFER 8,492 47,291,038,472.75 -------------------------------------------------------------------- TOTALS 61,323 908,548,128,409.75 pos: 0----5---10---15---20---25---30---35---40---45---50

    Get every field in the right place, on every page, across every cycle your teams run.

    → Capability 01

    Accurate Extraction Across Thousands of Pages

    Extract every field from long credit reports or bank statements by exact character position consistently from page 1 through page 2,000. No drift between runs and no reconciliation surprises regardless of report length or column density.

    → Capability 02

    Handle Multiple Layouts Within a Single Report

    Process reports containing multiple section types in a single pass, from transaction summaries to settlement details. Automatically preserve independent field definitions for each layout and parent-child relationships in the output.

    → Capability 03

    Preserve Extraction Knowledge Beyond Any One Person

    Capture your report structures in visual, reusable templates that any team member can maintain and audit. Your extraction logic outlasts the tenure of the people who originally understood the format.

    → Capability 04

    Automate the Entire Report-to-Database Pipeline

    Trigger ingestion from SFTP, email, shared folders and more, validate against your business rules, and export directly to 200+ destinations including SQL Server, Oracle, and Snowflake, all within a single configured pipeline.

    Built for the reports your finance and insurance teams already run. See how on yours.

    Built for the people who run EOD batches, regulatory submissions, and audit cycles.

    Four parts of the working week that get easier when extraction stops needing manual attention.

    → EOD

    Settlement files loaded before BOD

    Land Fedwire, SWIFT, and nostro/vostro extracts the moment they arrive at the EOD cutoff. Totals reconcile against the reserve summary, ledger ties to subledger, and clean positions reach the warehouse inside the SLA — every day, unattended.

    → CLOSE

    Trial balance that ties out, first pass

    Read GL extracts and journal posting runs at exact character ranges, so a packed-decimal value on page 400 lands the same way it lands on page 4. Double-entry totals validate automatically and exceptions surface before the trial balance runs, so the close team works from clean numbers from the start.

    → REG

    Solvency II, IFRS 17, and Basel filings, always traceable

    Capture field-level lineage on every QRT, IFRS 17 input, LCR or NSFR run, and Basel exposure report you produce. Validation logs and exception history travel with every figure, and historical snapshots stay queryable, so audit and compliance teams always have the trail they need ready to hand.

    → ONBOARD

    Bordereaux and IBNR runs, onboarded in an afternoon

    Generate a working template from a sample bordereau or IBNR run in roughly five seconds, with section boundaries, packed-decimal handling, and parent-child structure inferred. A new treaty or claim category becomes an afternoon's work for a single analyst.

    From fixed-width text file to validated, structured data — in six steps.

    Set up once and run unattended from there.

    01
    Ingest

    Pull files from any mainframe channel

    Reports arrive as fixed-width text via SFTP, MFT, or batch drop, and load directly into the engine for parsing.

    Source: SFTP├─ host: fed.fedwire.gov ├─ path: /settle/daily/*.txt ├─ schedule: 18:45 EST daily └─ status: ● active
    02
    Extract

    Auto-Generate Layout in ~5 seconds

    Load a sample report and the AI builds a schema for it, mapping every section, column, and header to its exact character position.

    Generated Template├─ Header (10 fields) ├─ Section_1 (7 cols × N rows) ├─ Totals (reconciliation) ├─ Section_2 (6 cols × N rows) └─ Reserve (key-value pairs)
    03
    Preview

    Hierarchical output verification

    Headers sit at the top level and detail rows nest as children, with the structure usually correct on the first pass.

    Preview Tree▼ Record 1 ├─ bank: FEDERAL RESERVE NY ├─ date: 2025-12-15 ├─ ▼ Section_1 [10] │ ├─ 1000 BASIC FUNDS │ └─ 1001 DRAWDOWN REQ └─ ▼ Section_2 [7]
    04
    Validate

    Business rules + 300+ transformations

    The engine reconciles totals, matches closing balances, validates ABA routing, and normalizes currency and dates automatically on every file.

    Validation Rules✓ totals_reconcile PASS ✓ closing_bal_match PASS ✓ aba_valid PASS ✓ numeric_fields PASS ├─ errors: 0 └─ warnings: 0
    05
    Export

    200+ native connectors

    Export to SQL Server, Oracle, Snowflake, DB2, or downstream APIs as JSON, XML, or normalized relational tables.

    Destination Map▸ fedwire_header → SQL Server ▸ transaction_summary → SQL Server ▸ position_detail → Snowflake ▸ reserve_summary → Oracle ├─ FK: report_id └─ Mode: upsert
    06
    Automate

    Unattended pipelines via Job Scheduler

    Pipelines run on file-arrival or scheduled triggers and handle extraction, validation, and load end to end, with alerts reaching ops only when something needs attention.

    Job: fedwire_daily_etl├─ trigger: file_arrival ├─ last_run: 2025-12-15 18:47 ├─ duration: 3.2s ├─ records: 1,247 → loaded ├─ alerts: none └─ status: ● success

    Walkthrough: Fedwire daily settlement report.

    Used by every major US bank for end-of-day reconciliation. Four sections. Different schema in each. One template.

    FEDERAL RESERVE BANK OF NY      DAILY SETTLEMENT REPORT
    FEDWIRE FUNDS SERVICE           REPORT ID: FW-SETTLE-2025-1215
    --------------------------------------------------------
    DATE: 12/15/2025    PARTICIPANT: JPMORGAN CHASE BANK NA
    ABA: 021000021      FED DISTRICT: 02-NEW YORK
    ACCOUNT: 0218-4403-7   RESERVE BAL: $847,291,403,228.14
    
    SECTION 1: TRANSACTION SUMMARY BY MESSAGE TYPE
    --------------------------------------------------------
    MSG   DESCRIPTION          SENT CNT    SENT AMOUNT ($)
    1000  BASIC FUNDS TRANSFER  14,823   287,493,021,847.50
    1001  BASIC FT - DRAWDOWN      482     8,921,304,527.00
    1500  FOREIGN TRANSFER       3,847    94,728,301,482.25
    3000  SECURITIES (DVP/RVP)   6,721   124,839,201,748.25
    --------------------------------------------------------
    TOTALS                    61,323   908,548,128,409.75
    
    SECTION 2: SETTLEMENT POSITION DETAIL
    --------------------------------------------------------
    TIME SLOT    OPENING BAL    DEBITS      CLOSING BAL
    06:00-08:00  847,291,403  42,819,304   855,756,117
    14:00-16:00  862,795,763 312,847,103   848,420,677
    18:00-18:30  853,874,959  18,293,048   852,429,202
    
    RESERVE BAL CLOSING:   $852,429,202,490.52
    REQUIRED RESERVE:      $124,847,291,038.00
    EXCESS RESERVES:       $727,581,911,452.52
    FED FUNDS TARGET:             5.25-5.50%
    Header Region · 10 Fields
    Participant metadata
    Bank name, ABA, Fed district, account, opening reserve. Parent record for everything below.
    Section 1 · 7 Columns
    Transaction summary
    Message-type rows: sent/received counts and amounts, net position. Totals reconciled against detail.
    Section 2 · 6 Columns
    Position detail
    Time-slot rows: opening, debits, credits, closing, overdraft flag. Different schema than Section 1.
    Reserve Summary · K/V Pairs
    End-of-day position
    Closing balance must match Section 2's 18:30 row. Validation runs automatically. Exceptions alert ops.
    < 60 min
    Initial setup per report type
    3.2s
    Typical processing time, 1,000-page report
    $0
    Per-page inference cost at volume
    See it on your data

    Bring a real settlement, GL, or claims report. See clean output the same day.

    Stand up a pipeline in an afternoon. Run it where your data already lives.

    Two parts of the workflow that determine how quickly a finance or insurance team gets to production, and how cleanly the pipeline holds up under audit.

    → Setup

    AI-accelerated template creation

    Generate a working template from a sample claims run, bordereau, or settlement file in roughly five seconds, with the character offsets handled by the engine instead of mapped by hand from the copybook.

    • ~5 seconds from sample to working template
    • Section boundaries, column ranges, and header/footer patterns inferred automatically
    • Packed-decimal and EBCDIC fields handled out of the box
    • Output is an editable visual template — your team stays in control
    → Deployment

    Runs where your data lives

    Process settlement files, GL extracts, and claims runs inside your own environment, with regulated data staying where your audit team has already certified it sits.

    • On-premises, private cloud, or hybrid
    • No outbound data movement required
    • Fits Basel, Solvency II, and equivalent residency frameworks
    • Sits alongside the mainframe and controls your audit team already certified
    Where AI does fit

    AI accelerates setup. Templates handle production.

    Auto-Generate Layout uses AI to build templates faster. For recurring mainframe reports, template-based extraction is the right method.

    Built for the reports that finance and insurance teams run every day.

    Hover any vertical to see the structural pattern ReportMiner solves.

    Retail / Commercial Banking

    Settlement & GL

    Daily settlement, GL extracts, SWIFT summaries, nostro/vostro reconciliation, treasury position, branch MIS.

    Multi-section docs with cross-section reconciliation rules.
    Capital Markets

    Trade & risk reporting

    Trade confirmations, DVP/RVP settlement, end-of-day positions, VaR runs, CCAR/DFAST submissions.

    Dense columns. Packed-decimal numerics. Multi-currency.
    P&C / Life Insurance

    Claims & policy admin

    Claims runs, loss ratios, policy admin printouts, premium accounting, earned/unearned, commissions.

    Policy headers tied to many claim-level detail rows.
    Reinsurance & Actuarial

    Bordereaux & reserving

    Bordereau files, treaty cessions, IBNR runs, actuarial extracts, Solvency II / IFRS 17 inputs.

    Thousands of pages. Strict reconciliation tolerances.
    Regulatory & Compliance

    Filings & AML

    Basel III/IV exposures, Solvency II QRTs, LCR/NSFR runs, SAR/AML outputs, audit trails.

    Audit-grade. Every figure traces back to source.

    What your team actually does after setup.

    Initial setup runs under an hour, and steady-state operation is mostly exception handling.

    Before ReportMiner

    Fragile scripts and manual investigation.

    • Manual entry from printed or PDF reports
    • Brittle scripts that break on minor format changes
    • Log diving to diagnose extraction failures
    • Ad-hoc cron jobs scattered across teams
    • Hours chasing reconciliation breaks from silent column shifts
    After ReportMiner

    One pipeline, with alerts only on exceptions.

    • Setup: 15–60 minutes per report type
    • Schedule or file-arrival triggers
    • Centralized monitoring dashboard
    • Alerts only on failures or exceptions
    • Visual template editor — no custom code
    • Team focuses on exceptions, not maintenance
    Setup in under an hour. Steady-state in under a week.

    Connects to your mainframe environment and your modern stack.

    Pull files in from the sources your mainframe writes to, and push clean records out to the systems your team already runs reporting from.

    Sources · Ingestion

    Where your files come from

    SFTP
    FTP
    MFT
    AS2
    Mainframe batch drop
    Email
    REST API
    SOAP
    Azure Blob
    S3
    SharePoint
    EngineReportMiner
    Destinations · Export

    Where data needs to land

    SQL Server
    Oracle
    PostgreSQL
    Snowflake
    Redshift
    SAP HANA
    IBM DB2
    Salesforce
    Dynamics
    JSON
    XML
    Parquet

    Load your mainframe report. Generate the template. See the extracted output — all in one session.

    Bring a real settlement, GL, or claims report. See clean, validated output in minutes — and a production pipeline the same day.

    No per-page inference costs·Character-position precision·Dedicated mainframe onboarding