Contact Us

Transaction Reporting — Search, Filter, and Track Payment History in Corporate Connect

Corporate Connect transaction reporting gives finance teams complete visibility into every payment that flows through the US Bank commercial banking platform. Search by date range, transaction type, dollar amount, payee name, reference number, or settlement status. Filter results to isolate wires, ACH batches, check clearings, corporate card charges, or internal transfers. Each transaction record includes the full lifecycle — from initiation through dual authorization, processing, settlement, and posting — with timestamps, operator IDs, and approval chains.

Reconciliation tools match posted transactions against expected payments, flagging unmatched items and duplicate entries for review. Export transaction data in BAI2, CSV, or PDF format for ERP integration or audit documentation. US Bank retains seven years of transaction records in compliance with federal banking regulations enforced by the OCC.

Account Summary Custom Reports
Corporate Connect transaction reporting interface showing filtered payment history with status tracking and date range selection

Transaction Reporting Capabilities — April 2026

  • Search by date range, type (wire, ACH, check, card), amount, payee/payor, reference number, or status
  • Six lifecycle statuses: Pending, Authorized, Processing, Completed, Rejected, Returned
  • 90-day online history with full search; 7-year archive accessible via data export
  • Reconciliation view matches posted transactions against expected payments with variance flagging
  • Export in BAI2, CSV, PDF; automated SFTP delivery for ERP integration
  • Dual authorization audit trail: initiator, approver, timestamps, IP addresses
  • FDIC insured, OCC regulated, SOC 2 Type II certified

Search and Filter Capabilities in Transaction Reporting

The transaction reporting module provides a multi-criteria search panel that narrows millions of transactions to the exact subset a finance team needs — whether for daily reconciliation, audit response, or dispute resolution.

Multi-Criteria Search Panel

The search panel accepts combinations of date range (specific dates or relative periods like "last 30 days"), transaction type (domestic wire, international wire, ACH credit, ACH debit, check, corporate card, internal transfer, fee), amount range (minimum and maximum), direction (debit or credit), account number, payee or payor name (partial match supported), reference or confirmation number, and status. Results display in a sortable, paginated grid showing date, description, amount, running balance, status, and operator. Click any row to expand the full transaction detail including the authorization chain, compliance screening result, and settlement confirmation.

Saved searches store frequently used filter combinations. A treasury analyst might save "Wires over $1M last 7 days" as a one-click search. Saved searches are operator-specific and managed through the user management module.

Date Range Selection and Relative Periods

Date range selection supports both absolute dates (e.g., March 1 to March 31, 2026) and relative periods (today, yesterday, last 7 days, last 30 days, month-to-date, quarter-to-date, year-to-date). Relative periods recalculate dynamically when the search executes, making them ideal for saved searches and scheduled reports. The date filter applies to the transaction posting date by default, with options to filter by initiation date, authorization date, or settlement date instead. This flexibility matters during month-end close when finance teams need to identify transactions initiated in one period but settled in the next. Historical data beyond 90 days is accessible through the data export module, which retrieves archived records within one business day.

Transaction Status Tracking and Lifecycle Visibility

Every transaction in Corporate Connect moves through a defined lifecycle. The transaction reporting module displays the current status and the complete history of status changes with timestamps and operator identification.

Six-Stage Transaction Lifecycle

Corporate Connect tracks six statuses: Pending — created by the initiating operator, awaiting dual authorization; Authorized — approved by the second operator, queued for processing; Processing — submitted to the payment network (Fedwire, ACH, SWIFT); Completed — settled and posted to the account; Rejected — failed validation, compliance screening, or insufficient funds; Returned — reversed after settlement (ACH returns, wire recalls). Each status transition records the timestamp, operator ID, IP address, and reason code. Rejected transactions include the specific failure reason — OFAC screening hit, duplicate detection, format error, or authorization timeout — enabling operators to correct and resubmit without starting from scratch.

Real-Time Status Updates and Notifications

Status changes propagate to the transaction reporting grid in real time. Operators monitoring a pending wire see it move to Authorized, then Processing, then Completed — each transition reflected within seconds. Configurable notifications alert designated operators when specific transactions change status. A CFO might receive an email when any wire over $500,000 reaches Completed status. A compliance officer might receive alerts for any Rejected transaction. Notification rules are configured per operator in the user management module and deliver via email, SMS, or in-app notification. The account summary balance updates simultaneously as transactions post, maintaining consistency across both modules.

Report Types Available in Transaction Reporting

Corporate Connect offers multiple report formats designed for different audiences — from daily operational summaries to detailed audit-ready transaction logs.

Report TypeContentAudienceFrequencyExport Formats
Daily Transaction SummaryAll transactions posted today with running balanceTreasury analystsDaily / On-demandCSV, PDF, BAI2
Payment Status ReportAll pending, processing, and completed paymentsPayment operationsReal-time / On-demandCSV, PDF
Wire Transfer LogDomestic and international wires with SWIFT/Fedwire detailsTreasury, complianceDaily / WeeklyCSV, PDF, MT103
ACH Batch ReportBatch totals, individual items, return/NOC detailAP/AR teamsPer batch / DailyNACHA, CSV, PDF
Reconciliation ReportMatched, unmatched, and disputed transactionsControllers, auditorsDaily / MonthlyCSV, PDF
Audit Trail ReportOperator actions, authorizations, status changesCompliance, auditorsOn-demandCSV, PDF
Exception ReportRejected, returned, and flagged transactionsOperations, complianceReal-time / DailyCSV, PDF

All reports respect operator entitlements configured in user management. FDIC insured institution.

Reconciliation Tools in Corporate Connect

The reconciliation view automates the matching process that treasury teams traditionally perform in spreadsheets — saving hours of manual work at month-end close.

Automated Transaction Matching

The reconciliation engine matches posted transactions against expected payments using reference numbers, amounts, and date proximity. Exact matches are auto-reconciled and marked green. Partial matches (amount within tolerance, similar reference) are flagged yellow for manual review. Unmatched items appear red with suggested matches ranked by probability. Users confirm, override, or escalate each item. The reconciliation state persists across sessions — an analyst can reconcile 200 transactions in the morning and return to finish 50 more after lunch without losing progress. Completed reconciliation reports export in CSV or PDF for controller sign-off and external audit documentation.

ERP Integration for Automated Reconciliation

Organizations running SAP, Oracle, or NetSuite can bypass manual reconciliation entirely by feeding Corporate Connect transaction data directly into the ERP reconciliation module. The data export function delivers BAI2 files via SFTP that map to the ERP chart of accounts. The ERP system performs automated matching against open invoices, purchase orders, and general ledger entries. Exception items route to the appropriate analyst within the ERP workflow. This straight-through processing eliminates the dual-entry problem where transactions are reconciled in Corporate Connect and again in the ERP. Custom reports can be configured to deliver only exception items, reducing the volume of data that requires human review.

Track Every Payment Through Corporate Connect

Transaction reporting gives your finance team complete visibility into payment status, settlement confirmation, and reconciliation across all Corporate Connect modules. Call +1-800-344-8758 to configure transaction reporting for your organization.

Login Guide Contact a Specialist

Frequently Asked Questions About Transaction Reporting

Answers about searching transactions, tracking payment status, reconciliation, and data export in Corporate Connect.

How do I search for specific transactions in Corporate Connect?

Use the search panel to filter by date range, transaction type, amount range, payee name, reference number, or status. Combine multiple criteria for precise results. Save frequently used searches for one-click access. See custom reports for scheduled delivery of filtered results.

What transaction statuses are tracked in Corporate Connect?

Six statuses: Pending (awaiting authorization), Authorized (approved), Processing (submitted to network), Completed (settled), Rejected (failed validation), and Returned (reversed). Each status change records the timestamp, operator ID, and reason code.

How far back can I view transaction history?

Online history covers 90 rolling days with full search capability. Archived transactions from 91 days to seven years are accessible through the data export module in BAI2, CSV, or PDF format. Archive requests process within one business day.

Can I reconcile transactions directly in Corporate Connect?

Yes. The reconciliation view matches posted transactions against expected payments. Auto-matched items are marked reconciled. Partial and unmatched items are flagged for review. Export reconciliation reports in CSV or PDF for month-end close. BAI2 exports feed automated reconciliation in ERP systems.