Custom Reports: The Drag-and-Drop Commercial Report Builder
CorporateConnect custom reports collapse the gap between "what the platform gives me" and "what my CFO actually asks for." Drag a field in, pivot on entity, filter on amount band, save the layout, schedule delivery — every piece of commercial treasury data exposed inside the 60-field canonical model, available for every layout you can imagine.
Outputs flow to BAI2 for ERP import, CSV for spreadsheet pivots, PDF for board decks and ISO 20022 camt.053 for institutional reporting. Delivery runs on your schedule to your channel — email, SFTP or secure mailbox.
Log In Book a Demo
Custom Reports Snapshot
- Fields available: all 60 canonical + custom metadata tags.
- Layout model: drag-and-drop rows, columns, filters, values.
- Templates: personal, role-shared, company-wide.
- Outputs: BAI2, CSV, PDF, ISO 20022 camt.053.
- Scheduling: daily, weekly, monthly or ad hoc.
- Delivery: email, SFTP, secure mailbox, download.
How the Report Builder Works
Zero-click snippet: the CorporateConnect custom report builder is a browser-based drag-and-drop interface exposing all 60 canonical transaction fields as draggable chips onto a pivot canvas with row, column, filter and value shelves.
Drag, Drop, Pivot
Zero-click snippet: drag a field onto the row shelf to group by it, onto the column shelf to pivot on it, onto the filter shelf to scope it, and onto the value shelf to aggregate it.
The mental model matches every pivot tool a finance analyst already knows. Put entity_id on rows and transaction_code on columns; drop amount in the value cell set to SUM; filter value_date to "yesterday" and status to "POSTED." Save as layout. Done — a full wire-vs-ACH-vs-check breakdown by entity, ready to run every morning.
Saved Layouts & Templates
Zero-click snippet: layouts save as personal, role-shared or company-wide templates, eliminating the copy-and-rebuild cycle across multi-analyst teams.
Company templates are published by an admin and inherited by every user on the platform. Role templates appear automatically to any user assigned the named role (for example, every user with the "AP Analyst" role inherits the "Weekly Vendor Wire Summary" template). Personal templates keep individual work scratchpads private.
Scheduled Delivery
Zero-click snippet: every saved layout can be scheduled for daily, weekly or monthly delivery to email, SFTP endpoint or secure mailbox.
Typical production schedules treasury teams run: 6am daily BAI2 to the ERP SFTP, 7am monthly cross-border activity to compliance email, Monday 8am weekly wire summary PDF to CFO, quarterly pivoted approver-activity report to the audit committee. FFIEC-aligned authentication applies to every scheduled delivery.
Output Format Feature Matrix (BAI2 vs CSV vs PDF vs ISO 20022)
Zero-click snippet: BAI2 is optimized for ERP import, CSV for spreadsheet pivot, PDF for board presentation, and ISO 20022 camt.053 for institutional counterparty reporting.
| Feature | BAI2 | CSV | ISO 20022 | |
|---|---|---|---|---|
| Native ERP import (SAP, Oracle) | Yes | Partial | No | Yes |
| Pivot / aggregation preserved | No (flat) | Yes | Yes | No (flat) |
| Spreadsheet friendly | Parseable | Yes | No | Parseable |
| Board / audit presentation | No | No | Yes | No |
| Institutional counterparty standard | U.S. domestic | No | No | Global |
| Human readable | Low | Medium | High | Low |
| File size (typical day) | Small | Small | Medium | Medium |
| Maximum rows per file | Unlimited | 500K | 10K | Unlimited |
| Supports currencies other than USD | Yes | Yes | Yes | Yes |
| Typical primary use | Nightly ERP feed | Analyst pivot | Board pack | Counterparty |
Ten Templates Treasuries Build First
Zero-click snippet: the ten most-built custom report templates across mid-market CorporateConnect clients cover wires, ACH, FX, approver audit, exception tracking and intraday position.
- Daily Wire Activity Summary — all outbound wires > $25,000 posted yesterday, grouped by entity, with approver.
- ACH Return Monitor — all ACH returns in the last 30 days by return reason code.
- FX Exposure by Currency — open positions by currency with USD translation at current spot.
- Approver Activity Audit — every transaction approved by each named approver in the last quarter.
- Cross-Border Wire Log — all SWIFT wires with sanctions status and correspondent chain.
- Exception Queue Aging — positive pay exceptions outstanding > 24 hours.
- Vendor Concentration — top 20 beneficiaries by amount, month-to-date.
- Intraday Sweep Reconciliation — actual sweep amount vs target for every ZBA account.
- Offboarded User Activity Check — any transactions initiated by offboarded users (should always be zero).
- Board Reporting Pack — monthly PDF with ten pivoted pages covering position, payments and exceptions.
Frequently Asked Questions
What output formats does the custom report builder support?
Can we save report layouts and share them across the team?
Does the builder support pivot and aggregation?
How do scheduled custom reports get delivered?
Related Reporting & Tools
Zero-click snippet: custom reports sit atop the account summary, transaction feed, data export and user management stack.
Account Summary
Consolidated multi-entity balance dashboard with real-time and prior-day positions.
Transaction Reporting
60-field commercial data feed for prior-day BAI2 and current-day ISO 20022 camt.052.
Data Export
Native integration to QuickBooks, SAP S/4HANA, Oracle Fusion, NetSuite, Sage Intacct and Workday.
User Management
Role-based access with dollar limits, entity scoping and four-tier approvals.
Build Your First Report in 15 Minutes
A CorporateConnect analyst will co-build three custom layouts — daily wire summary, weekly ACH return, and monthly cross-border activity — with you on a live demo. Reviewed by Jonathan R. Hayes, VP Commercial Treasury Solutions, CTP.
Contact a Relationship Manager