CorporateConnect Transaction Reporting turns every posted wire, ACH item, check, deposit, fee and internal transfer into a filterable, exportable record. Sixty-plus fields. Seven years of hot-search retention. Saved views that share across teams. Export queues that emit CSV, BAI2, ISO 20022 camt.053 or PDF on demand or on schedule.
This is the reporting engine your audit committee asks about — built on U.S. Bank's commercial data warehouse, aligned to FinCEN recordkeeping obligations and available inside CorporateConnect at no extra cost.
Open Transaction Reports Build Custom Report
Find the wire, isolate the ACH return, audit the controlled disbursement batch. Transaction Reporting surfaces every posted item across wires, ACH, checks, deposits, lockbox receipts and fees in a single searchable grid.
Transaction Reporting covers the workflows that consume 70% of a treasury department's reporting time.
Sixty-plus indexed fields cover everything from transaction amount to BAI2 type code to wire intermediary bank. Combine filters with AND/OR logic. Save complex filters as named views for reuse. Your AP clerk filters on beneficiary name; your AML analyst filters on originator country.
Type a partial reference, beneficiary name, amount or date and CorporateConnect returns matching items across every field. Elasticsearch-backed, sub-second response even against seven years of history. Great for phone-support scenarios where a customer asks "do you have my wire from Tuesday?"
Every filter combination saves to a named view. Personal views live with the user; team views share to a role or department. Common team views include "Unsettled Outbound Wires," "ACH Returns Last 30 Days" and "Lockbox Receipts $10K+."
Large extracts (>100,000 rows) queue to a background job. The Notifications panel flags completion. Files stay in the queue for 30 days at encrypted-at-rest storage, retrievable by any authorized user. Export formats cover CSV, XLSX, BAI2, ISO 20022, PDF and SWIFT MT940.
Every posted transaction stays searchable for 7 years. Aligned with the Bank Secrecy Act recordkeeping standard. Historical records beyond the hot window retrieve from archive within 1 business day on request.
Drill into any wire to pull the SWIFT MT103/MT202 or Fedwire output message number. Beneficiary bank acknowledgement, intermediary routing and imposed fees displayed inline. Critical for customer-service tickets and audit evidence.
Transaction Reporting exposes fields organized by category. Each field supports a predictable set of operators so queries behave consistently across transaction types.
| Field Category | Example Fields | Filter Operators |
|---|---|---|
| Amount & Currency | Amount, Currency, USD-Equivalent, FX Rate, Debit/Credit | =, ≠, >, <, between, in-list |
| Transaction Type | Wire In, Wire Out, ACH Credit, ACH Debit, Check, Deposit, Fee, Sweep | =, ≠, in-list |
| Dates | Value Date, Post Date, Settle Date, Initiated Date | =, between, >, <, relative (last 30d) |
| Counterparty | Originator Name, Originator ABA, Beneficiary Name, Beneficiary Bank | =, contains, starts-with, in-list |
| Reference & Memo | OBI, Reference, Invoice, Check Number, Wire Reference | =, contains, is-null, not-null |
| Routing | Originator Country, Beneficiary Country, Intermediary Bank, SWIFT BIC | =, in-list, contains |
| BAI2 Codes | Type Code (e.g., 195, 469, 575), Summary Code, Detail Code | =, in-list |
| Status | Originated, Released, Acked, Credited, Returned, Rejected | =, in-list |
| Account & Entity | Account Number, Account Nickname, Legal Entity, Division | =, in-list |
| User & Approval | Initiator, Approver, Approval Level, Template ID | =, in-list, is-null |
From daily reconciliation to annual audit, Transaction Reporting collapses what used to take hours into a filter, a saved view and a scheduled export.
Accounting opens the "Yesterday Posted" saved view, exports BAI2 to the ERP via data export and matches postings to general-ledger entries. A decade ago this workflow required manual downloads from four channels. Today it is two clicks plus an automated SFTP drop.
The Account Summary ties the totals; Transaction Reporting supplies the detail. Variance investigations drill from an exception balance straight to the offending transaction in under 30 seconds.
AML analysts filter on wires from specific originator countries, amount thresholds above $10K CTR triggers, or counterparty names flagged by internal watchlists. Each filtered result exports with full audit metadata — initiator, approver, timestamp, original file hash. Compliance teams at mid-market firms use this to compile evidence packages for suspicious activity review.
Referenced OFAC screening runs at transaction entry and at release; results log into the same record, filterable on "screening status = match."
External auditors routinely request "every wire over $500K in Q3." Transaction Reporting filter + export emits a stamped PDF package with a date range, audit-trail metadata and the matched records. Saves your controller half a day of screenshotting.
For SOX ICFR evidence, the saved view with scheduled monthly PDF delivery creates a permanent, timestamped archive without manual touch.
