ScotiaConnect Transaction Reporting: 60+ Filterable Fields for Canadian Commercial Clients
ScotiaConnect Transaction Reporting gives Canadian treasury teams, controllers and auditors direct access to every payment, deposit, adjustment and fee across the Scotiabank commercial estate — filtered on more than 60 indexed fields, saved as reusable views and scheduled for delivery in BAI2, MT940, ISO 20022 CAMT, CSV or PDF.
One screen. Every transaction. Every channel. The same engine that powers real-time account summaries produces the report your CFO needs for month-end, the file your ERP needs for reconciliation and the audit trail your regulator expects under OSFI record-keeping.
Open ScotiaConnect Try Custom ReportsSixty-Plus Indexed Fields
Every dimension your reconciliation, audit and forecasting workflows depend on.
Reporting Dimensions You Can Filter On
- Identity — originator name, beneficiary name, account number, counterparty BIC, reference number.
- Timing — post date, value date, effective date, created timestamp, approved timestamp, released timestamp.
- Classification — transaction type, BAI2 code, ISO 20022 code, channel (web, mobile, API, file upload), product.
- Money — amount, currency, FX rate, fee, net amount, running balance.
- Controls — user who initiated, user who approved, user who released, dual-control flag, status.
Every field is indexed at the database layer so even a ten-year search across a 50-entity group returns sub-second. Filters can be chained with AND/OR logic and grouped with parentheses — for example "all USD wires above $250,000 released by the AP supervisor between 2026-Q1 start and month-end, excluding internal transfers". The query preview shows matching row count before execution so analysts can refine before running.
Saved views are the productivity unlock. A typical treasury team at a mid-market Canadian organisation maintains 12 to 20 saved views: daily cash position, weekly EFT batch reconciliation, monthly wire activity, quarterly FX P&L, FINTRAC large cash transaction reporting, and ad-hoc audit pulls. Views can be private, shared within a department or published to the whole organisation.
Report Catalogue and Delivery Schedules
Six pre-built reports cover the majority of Canadian commercial reporting requirements.
| Report | Fields | Format Options | Schedule |
|---|---|---|---|
| Daily Activity | All 60 fields | CSV, BAI2, PDF | Daily at 07:00 ET |
| EFT Batch Summary | 35 fields including AFT reason codes | CSV, BAI2, PDF | Daily post-settlement |
| Wire Transfer Register | 42 fields including correspondent BIC | MT940, CSV, PDF | Weekly, Monday 06:00 ET |
| FX Conversion Log | 28 fields including rate and spread | CSV, PDF | Monthly, 1st business day |
| User Activity Audit | 18 fields including IP and session | CSV, PDF | Monthly, on demand |
| FINTRAC Large Transaction | 22 fields meeting PCMLTFA schema | CSV, XML | Within 15 days of trigger |
Format Interoperability
BAI2, MT940, MT942, ISO 20022 CAMT, CSV and PDF — pick what your downstream system ingests.
BAI2 is the workhorse for North American ERP integration. ScotiaConnect emits compliant BAI2 type-2 and type-3 records that load directly into SAP Cash Management, Oracle Cloud ERP, NetSuite and Microsoft Dynamics 365 without transformation. MT940 and MT942 support international treasury workstations such as Kyriba, GTreasury and FIS Quantum. ISO 20022 CAMT.053 and CAMT.054 are the go-forward standard under Payments Canada's Lynx and Real-Time Rail modernisation, described at payments.ca.
PDF exports include a cryptographically-signed header showing the user who ran the report, the timestamp, the filter criteria and the row count. This satisfies the auditable trail expectation under CPA Canada assurance standards and works for external auditors running year-end testing.
Audit Trail and Seven-Year Retention
Every report execution is itself a logged event: user, timestamp, filter criteria, row count, export format, delivery destination, IP address. The audit log is immutable and retained for seven years in alignment with OSFI record-keeping guidance. Designated Auditor role users can query the audit log directly without disturbing production operators.