The CorporateConnect Custom Report Builder lets your treasury team assemble reports without SQL, without a ticket to IT and without exporting to Excel for manual pivoting. Drag fields onto a canvas, set filters, group and aggregate, pick a delivery channel, schedule it — the rest runs itself overnight.
Output BAI2 for ERP ingestion, CSV for ad-hoc analysis, PDF for board packets, XLSX with pivot tables preserved. Delivery over SFTP, encrypted email or REST API webhook. The same engine underpins Transaction Reporting and the Account Summary.
Open Custom Reports See Export Options
Most banks require a change request to add a column to a report. CorporateConnect ships with a drag-and-drop canvas your CFO, controller or AP manager uses directly. Output that fits your ERP, your auditor and your board packet — all from one interface.
Custom Reports are not just filtered downloads. The builder composes datasets, aggregates them, pivots them and routes them to the system that actually needs the data.
The left pane lists every field exposed across Account Summary and Transaction Reporting. Drop onto the canvas; order by dragging rows. Remove by clicking the ×. No query language to learn.
Set filters on any field in the canvas or on unselected fields. Combine with AND/OR groups. Use parameterized filters so the same template runs against different date ranges or entity subsets without duplication.
Group by one to three fields (e.g., entity → currency → transaction type). Aggregate with sum, count, average, min, max or distinct-count. Subtotals and grand totals calculate automatically and appear on every output format.
Drag a field to rows, another to columns, a measure to values. Pivot renders in the preview and exports to XLSX with Excel-native pivot tables intact. Perfect for wire volume by counterparty country × month dashboards.
Daily, weekly, bi-weekly, monthly, quarterly, or custom cron. Event-driven triggers (e.g., "after prior-day posting completes") ensure the report lands the moment the data is certified. Multiple schedules per template allow one report to go daily to ops and monthly to the board.
BAI2 for ERP ingestion, CSV for analytics workflows, XLSX with pivot tables, PDF for readability and board packets. Each format inherits the grouping and aggregation configuration from the template.
Each combination is supported with no additional licensing. Most CorporateConnect clients run 8–15 scheduled templates in production.
| Delivery Method | Supported Formats | Typical Frequency |
|---|---|---|
| SFTP (SSH key) | BAI2, CSV, XLSX, ISO 20022 camt.053, SWIFT MT940 | Daily — overnight batch |
| SFTP (password) | BAI2, CSV, XLSX | Daily — overnight batch |
| Encrypted Email | PDF, CSV, XLSX | Daily, weekly, monthly |
| REST API Webhook | JSON, CSV, BAI2 (base64-wrapped) | Event-driven or scheduled |
| In-Portal Download | Every format | On-demand |
| Notification + Retrieval | All formats, retrievable 30 days | Event + ad-hoc |
Templates built by actual treasury teams. Adopt them, edit them, or start blank.
Every prior-day balance by account, with sweep and ZBA movements broken out. Output BAI2, delivery via SFTP SSH-key to the ERP inbox nightly at 6:30am CT. Feeds SAP, Oracle ERP Cloud, NetSuite and Workday. Pairs with the Account Summary for on-screen review.
Federal Reserve payment systems guidance flags daily position reporting as a foundational treasury control. This template covers it.
All outbound wires from the prior week, grouped by beneficiary, with approver audit trail. PDF output, encrypted email to the CFO and controller every Monday at 8am. Saves the controller roughly 90 minutes of export-paste-format each week.
Layer in approval-level fields to make dual-authorization evidence explicit for SOX review.
Pivot table: counterparty country (rows) × month (columns) × USD-equivalent amount (values). XLSX output with native pivot tables preserved. Monthly delivery to shared SFTP endpoint. Essential for FX exposure analysis and counterparty concentration reviews.
Analysts open the file in Excel, change slicers and drill into any cell to reveal underlying transactions with one click to CorporateConnect.
