ScotiaConnect Custom Reports: Drag-and-Drop Builder for Treasury and FP&A Teams
The ScotiaConnect Custom Reports builder lets controllers, treasury analysts and FP&A teams assemble their own transaction, balance and FX reports without writing a line of SQL. Drag fields onto a canvas, add calculated columns, apply conditional formatting, map results to your general ledger and publish on a schedule.
The output integrates directly with SAP, Oracle, NetSuite, Sage Intacct, Microsoft Dynamics and QuickBooks — no middleware, no manual transformation. Backed by the same indexed data store that powers 60-field transaction reporting and real-time balances.
Launch Builder See Pre-Built ReportsThe Builder Experience
Canvas-based construction with live preview on every change.
Builder Capabilities at a Glance
- Drag-and-drop canvas — pull any of 60+ fields into rows, columns or filters with zero code.
- Calculated fields — arithmetic, date functions, IF/THEN logic, currency conversion.
- Conditional formatting — red-flag thresholds, traffic-light scoring, variance alerts.
- GL mapping — link BAI2 and ISO 20022 codes to your chart of accounts.
- Pivot and rollup — group by entity, cost centre, currency or fiscal period with multiple subtotal levels.
The canvas is driven by a familiar spreadsheet metaphor. Rows, columns and filter shelves accept any combination of raw fields (post date, amount, currency, channel) and calculated fields (net-of-fees amount, CAD-equivalent rolling sum, variance versus prior month). Every drop refreshes a live preview with the first 100 rows so the designer sees the result immediately. When the layout is right, save, schedule and share — the heavy-lift export runs server-side.
Calculated fields are more than spreadsheet formulas: they are versioned, audited and sandboxed. A CFO-defined "adjusted cash position" calculation is propagated across every report that depends on it, and any change is logged in the audit trail with before/after value diffs. This prevents the silent drift problem that haunts Excel-based reporting pipelines.
Popular Custom Report Patterns
Five layouts we see across the ScotiaConnect commercial client base.
| Use Case | Fields | Output | Refresh Cadence |
|---|---|---|---|
| Daily cash position by entity | Entity, currency, available balance, intraday net | CSV to treasury workstation | Every hour 08:00-18:00 ET |
| Monthly EFT reconciliation to AP ledger | Beneficiary, amount, value date, AP invoice ID | BAI2 to SAP | 1st business day of month |
| Quarterly FX P&L | Currency pair, rate, spread, realised gain/loss | Excel with conditional formatting | 5 business days after quarter-end |
| Dual-control exception report | User, amount, approval gap, dollar threshold | PDF to Chief Compliance Officer | Weekly Monday 06:00 ET |
| FINTRAC $10K cash threshold | Cash deposit flag, amount, branch, date | XML per PCMLTFA schema | Within 15 days of trigger |
ERP Integration
Native ingest for the seven ERPs used by 80%+ of Canadian mid-market and enterprise clients.
ScotiaConnect Custom Reports emit formats that the leading enterprise resource planning systems ingest without transformation:
- SAP S/4HANA — BAI2 via the Bank Statement Import Tool (BSIT); ISO 20022 CAMT.053 via the Bank Communication Management (BCM) module.
- Oracle Cloud ERP / Oracle Fusion — BAI2 through Cash Management's Bank Statement Loader; ISO CAMT through the AutoReconciliation service.
- NetSuite — CSV with the built-in Bank Data Import SuiteApp; BAI2 via the Bank Feeds connector.
- Sage Intacct — QIF, OFX, CSV via Sage Bank Feeds; reconciliation automated end-to-end.
- Microsoft Dynamics 365 Finance — CAMT.053 and BAI2 through the Bank Reconciliation module.
- Workday Financial Management — BAI2 and CSV through Workday Bank Connect.
- QuickBooks Enterprise — QBO and CSV via Bank Feeds.
For bespoke or legacy systems, the ScotiaConnect API exposes the same report payloads as JSON. Your integration team writes a pull consumer against /v1/reports/{id}/run and handles downstream mapping internally.
Distribution Lists and Audit
Each custom report supports a distribution list of internal ScotiaConnect users and external email addresses (with per-recipient policy enforced by user management). Delivery is logged in the audit trail: recipient, timestamp, file hash, delivery success. For SFTP destinations, connection health is monitored and the Super User is alerted on any failure.