Transaction Reports
Transaction reports within Scotiaconnect form the analytical backbone for commercial treasury operations. From daily account statements to multi-year audit trails, the reporting module delivers structured financial data in formats that integrate with accounting systems, treasury workstations, and compliance workflows. Organizations managing multiple accounts across subsidiaries and currencies rely on these reports to maintain visibility, satisfy regulatory obligations, and support strategic decisions with accurate, timely information.
The Scotiaconnect reporting engine draws from every transaction type processed through the platform — wire transfers, ACH batches, international payments, FX trades, and account activity. Users access reports through the digital banking dashboard or receive them automatically through scheduled delivery channels. Each report can be tailored to specific accounts, date windows, transaction categories, and amount thresholds. This configurability means the CFO receives a summary level view while the accounting department pulls granular transaction-level detail — both from the same underlying data source.
Core Report Categories Available Through Scotiaconnect
Account activity statements present end-of-day balances, intraday movements, and transaction line items across all linked business accounts. Payment initiation reports catalog every wire and ACH submission with beneficiary details, amounts, currency, and approval chain status. Forex trade confirmations capture rate locks, settlement dates, and counterparty information for each currency transaction.
Reconciliation files in BAI2 format deliver standardized bank reporting feeds into treasury management systems, eliminating manual data entry and reducing posting delays. Custom consolidated reports merge multiple accounts into a single document organized by legal entity, region, or currency — particularly valuable for organizations with subsidiary banking structures spread across North America.
Compliance-oriented audit reports track every user interaction: report requests, parameter selections, format choices, download events, and schedule modifications. This audit trail satisfies internal review requirements and streamlines regulatory examination preparation. Archived reports remain accessible for seven years, supporting long-term recordkeeping obligations without burdening local storage infrastructure.
Report Format Options and Integration Pathways
PDF output delivers formatted, presentation-ready reports with headers, transaction tables, and summary sections. CSV and XLSX formats serve analysis workflows — finance teams import raw data into spreadsheet tools, accounting platforms, or business intelligence applications for custom calculations and visualization. BAI2 feeds connect directly to treasury workstation software such as Kyriba, GTreasury, or FIS Integrity. MT940 SWIFT-format statements integrate with international banking platforms and multicurrency accounting systems.
Each format preserves complete data fidelity. The choice between them depends on how downstream systems consume the information, not on limitations of the export itself. A single report template can generate multiple output formats simultaneously, routing a PDF to the executive team while sending raw CSV data to the accounting department's ERP integration endpoint.
| Report Type | Available Formats | Delivery Method | Frequency |
|---|---|---|---|
| Account Activity Statement | PDF, CSV, BAI2, MT940 | Portal download, Email, SFTP | Daily, Weekly, Monthly |
| Wire Transfer Log | PDF, CSV, XLSX | Portal download, Email | On-demand, Daily |
| ACH Batch Summary | PDF, CSV, XLSX | Portal download, SFTP | Per batch, Daily |
| FX Trade Confirmation | PDF, CSV | Portal download, Email | Per trade, Daily |
| Consolidated Multi-Account | PDF, XLSX, BAI2 | Portal download, Email, SFTP | Weekly, Monthly |
| Audit Trail Export | CSV, XLSX | Portal download, SFTP | On-demand, Monthly |
Scheduled Delivery and Automation Workflows
Scheduled report delivery eliminates the manual overhead of logging into Scotiaconnect to pull recurring reports. Users configure templates once — specifying accounts, date ranges, formats, and recipients — and the platform handles generation and distribution on the chosen cadence. Daily cash position reports reach the treasury team by 8 AM. Weekly consolidated statements land in the CFO's inbox every Monday. Month-end reconciliation files transmit via SFTP to the accounting system without anyone clicking a button.
Delivery logs record every automated transmission with recipient confirmation and timestamps. If an email bounce or SFTP connection failure occurs, the system retries delivery and alerts the report administrator. Scheduled reports remain accessible in the portal's download area for on-demand retrieval, providing a backup path if primary delivery channels experience disruption.
Custom reporting templates can include conditional logic — for example, sending a standard weekly summary when transaction volumes stay within normal ranges but triggering an immediate notification report if volume exceeds a defined threshold. This proactive alerting helps treasury teams spot anomalies early rather than discovering them during periodic review cycles.