SinglePoint Data Export is the pipeline that moves U.S. Bank commercial account data out of the portal and into your ERP, treasury system or audit vault. BAI2 Version 2 with every Type Code, SWIFT MT940 customer statements, SWIFT MT942 intraday statements, CSV with custom column mapping and PDF archival — delivered via SFTP, API or direct ERP connector.
This page is the reference for format choice, delivery schedule, ERP target and GL mapping. Field-level accuracy matters: Federal Reserve payment systems data has to reconcile to BAI2 exactly, and most treasury audits reference SinglePoint Data Export files as the primary source of truth.
Build Custom Reports Standard Reports
Every SinglePoint Data Export format has a documented use case, an ERP target and a certified parser on the receiving side.
Bank Administration Institute standard with all Type Codes (010 File Header, 020 Group Header, 100 Account Identifier, 16x Continuation, 49x Account Trailer, 98x Group Trailer, 99x File Trailer). SinglePoint Data Export BAI2 covers Prior Day and Current Day Intraday for Kyriba, ION Treasury and SAP TRM.
Customer statement message for end-of-day book balances. SinglePoint Data Export MT940 provides tag 20 reference, tag 25 account, tag 28C statement number, tag 60F opening balance, tag 61 transaction line, tag 86 narrative and tag 62F closing balance.
Interim intraday statement for mid-day reporting. SinglePoint Data Export MT942 refreshes every 15 minutes during Fedwire hours. Used by multi-bank treasury systems for same-day cash positioning across correspondent relationships.
Comma-separated values with full control over column order, header naming, date format (ISO 8601 or locale), decimal separator and line terminator. SinglePoint Data Export CSV is the universal fallback when native connectors are unavailable.
Human-readable PDF with digital signature and tamper-evident hash. SinglePoint Data Export PDF is used for auditor evidence, board packs and dispute resolution. Each file embeds the SinglePoint audit timestamp.
For outbound ACH origination files only. SinglePoint Data Export emits NACHA-formatted files matching the SEC code, batch control totals and file control per the current NACHA Operating Rules. Required for same-day ACH.
The five most common SinglePoint Data Export configurations.
| Format | Use Case | ERP Target | Refresh Cadence |
|---|---|---|---|
| BAI2 Prior Day | End-of-day reconciliation | Kyriba, ION, SAP TRM | Daily 6:00am CT |
| BAI2 Current Day | Intraday positioning | Kyriba, ION | Every 15 minutes |
| MT940 | End-of-day SWIFT statement | Multi-bank treasury | Daily 6:00am CT |
| CSV | Universal ERP import | QuickBooks, NetSuite, Sage | Daily or on-demand |
| Audit evidence, board pack | Document vault | Monthly or on-demand |
SinglePoint Data Export ships files through the channel that matches your operational reality.
SFTP pickup to a U.S. Bank-managed or client-managed target with optional PGP encryption. API pull via REST endpoints (/v1/exports/bai2-prior-day, /v1/exports/mt940) authenticated with OAuth 2.0 client credentials. SinglePoint Data Export delivery confirmation posts to the audit trail with success, failure and retry detail.
Certified connectors ship with SinglePoint Data Export for SAP S/4HANA, Oracle NetSuite, Microsoft Dynamics 365 Finance, Sage Intacct, QuickBooks Online and Workday Financials. Each connector is tested against the ERP's current release and includes GL mapping from SinglePoint Custom Reports.
SinglePoint Data Export at a glance.
Commercial Banking Portal — Topic Cluster