Contact Us

Custom Reports — Build, Schedule, and Deliver Financial Reports in Corporate Connect

The Corporate Connect custom report builder lets finance teams design reports that match their exact requirements — selecting specific data fields, applying filters, choosing output formats, and scheduling automated delivery via email or SFTP. Unlike the pre-built reports in the account summary and transaction reporting modules, custom reports combine data from multiple sources into a single output. Pull account balances alongside transaction volumes, merge wire transfer details with ACH batch summaries, or create executive dashboards that roll up activity across the entire corporate relationship.

Saved templates eliminate report re-creation. Build a report once, save it as a template, and run it on demand or schedule it for daily, weekly, or monthly delivery. Shared templates give every authorized operator access to standardized reports that ensure consistency across departments. US Bank — FDIC insured and regulated by the OCC — retains report output for seven years.

Data Export Transaction Reporting
Corporate Connect custom report builder showing field selection, filter configuration, and scheduled delivery settings

Custom Report Builder Overview — April 2026

  • Drag-and-drop field selection from account balances, transactions, payments, and card data sources
  • Multi-criteria filters: date range, account, transaction type, amount, status, payee, department
  • Scheduling: daily, weekly, monthly, quarter-end, or custom intervals
  • Delivery channels: email (encrypted attachment or secure link) and SFTP (direct file transfer)
  • Export formats: BAI2, CSV, PDF, Excel XLSX, MT940
  • Saved templates with personal and shared libraries; version history for template changes
  • FDIC insured, OCC regulated, SOC 2 Type II certified, 256-bit TLS encryption

Building a Custom Report Step by Step

The report builder walks operators through a four-step process: select the data source, choose fields and filters, configure the output format, and set the delivery method.

Step 1: Data Source and Field Selection

Start by selecting one or more data sources: account balances (current-day, prior-day, historical), transactions (wires, ACH, checks, cards, internal transfers), payment batches (ACH files, payroll runs), or corporate card activity. Each data source exposes a set of fields that can be added to the report layout. Common fields include account number, account name, transaction date, posting date, amount, debit/credit indicator, payee/payor name, reference number, status, operator ID, and authorization chain. Drag fields into the report layout to define columns. Set column order, sorting (ascending or descending), and grouping (by account, by date, by department). Grouping creates subtotals automatically.

Step 2: Filters and Date Range

Apply filters to narrow the data included in the report. Filter by specific accounts, transaction types, amount ranges, statuses, departments, or cost centers. Date range accepts absolute dates or relative periods (today, yesterday, last 7 days, month-to-date, prior month, quarter-to-date). Relative periods recalculate each time the report runs — essential for scheduled reports that should always reflect the current period. Multiple filters combine with AND logic. For complex requirements, the advanced filter mode supports OR conditions and nested groups. Preview the filtered result set before saving to verify the report contains the expected data. The preview displays the first 100 rows; the full report generates all matching records.

Scheduling and Delivery Configuration

Automated delivery ensures the right report reaches the right person at the right time — without manual intervention from treasury staff.

Schedule Frequency and Timing

Custom reports support multiple scheduling frequencies: daily (specify time of day), weekly (specify day and time), monthly (specify date and time, with end-of-month option for months with fewer than 31 days), quarterly (first or last business day of quarter), and custom intervals (every N days). The scheduler accounts for US banking holidays — if a scheduled date falls on a holiday, the report runs on the next business day or the prior business day, depending on the configuration. Each schedule maintains a run history log showing execution time, record count, file size, and delivery status. Failed deliveries trigger retry logic and alert the report owner.

Email and SFTP Delivery Channels

Email delivery attaches the report as an encrypted file or provides a secure download link that expires after 72 hours. Recipients are specified by email address and must be authorized in the user management module. SFTP delivery pushes the report file directly to a customer-managed server using SSH key authentication. SFTP configuration includes hostname, port, directory path, file naming convention (with date/time variables), and compression options. Both channels support all export formats. For organizations that feed reports into ERP systems, SFTP delivery with BAI2 format enables fully automated data ingestion without human intervention. The data export module provides additional SFTP management tools.

Export Format Comparison

Choose the output format that matches your downstream system requirements. Each format preserves the fields and filters configured in the report builder.

FormatBest ForStructureERP CompatibleHuman Readable
BAI2Treasury workstations, SAP, OracleFixed-width, coded transaction typesYes — native ingestionNo — requires parser
CSVSpreadsheets, data analysis, custom scriptsComma-delimited, header rowYes — with mappingYes
PDFArchival, distribution, printFormatted pages with headers/footersNoYes
Excel XLSXPivot tables, formulas, chartsMulti-sheet workbook, formatted cellsYes — with mappingYes
MT940International subsidiaries, SWIFT-based systemsSWIFT message format, standard tagsYes — international ERPNo — requires parser

BAI2 and MT940 formats follow specifications published by the Federal Reserve and SWIFT respectively. FDIC insured institution.

Templates, Sharing, and Version Control

Saved templates turn one-time report configurations into reusable assets that standardize reporting across the organization.

Personal and Shared Template Libraries

Every operator maintains a personal template library containing their saved report configurations. Company administrators can promote any personal template to the shared library, making it available to all operators with the Custom Reports entitlement. Shared templates ensure that every department runs the same month-end close report with identical fields, filters, and formatting. Operators execute shared templates but cannot modify them without administrator permission. The template library displays the report name, description, data sources, last run date, schedule status, and owner — giving administrators visibility into which reports are active and which are obsolete.

Version History and Audit Trail

Every change to a report template creates a version entry: who modified it, when, and what changed. Administrators can revert to any prior version if a modification produces unexpected results. The audit trail captures template creation, modification, deletion, sharing, and execution events. This version control satisfies OCC examination requirements for change management in financial reporting systems. Combined with the user management module's entitlement controls, the template audit trail provides a complete chain of custody from report design through delivery.

Build Reports That Match Your Exact Requirements

The Corporate Connect custom report builder eliminates the gap between the data your systems need and the reports your bank provides. Configure fields, filters, formats, and delivery schedules — then let automation handle the rest. Call +1-800-344-8758 to discuss custom reporting requirements.

Login Guide Contact a Specialist

Frequently Asked Questions About Custom Reports

Answers about building, scheduling, delivering, and sharing custom reports in Corporate Connect.

How do I create a custom report in Corporate Connect?

Navigate to Custom Reports, click Create New Report, select data sources, choose fields, apply filters, set the date range, choose the output format, and save. Optionally schedule recurring delivery via email or SFTP. See data export for SFTP configuration details.

Can I schedule automatic report delivery in Corporate Connect?

Yes. Schedule reports daily, weekly, monthly, or at custom intervals. Deliver via email (encrypted attachment) or SFTP (direct file transfer). The scheduler handles banking holidays and maintains a delivery log. Failed deliveries trigger retries and alert the report owner.

What export formats does the custom report builder support?

BAI2 (treasury workstations, ERP), CSV (spreadsheets), PDF (archival), Excel XLSX (pivot tables), and MT940 (international). Each format preserves selected fields and filters. See the data export page for format specifications.

Can I share saved report templates with other operators?

Administrators promote personal templates to the shared library. All operators with Custom Reports entitlement can run shared templates. Edit permissions require administrator authorization. Template version history tracks all changes. Manage operator access through user management.