ScotiaConnect Transaction Reports

ScotiaConnect transaction reports give accounting and treasury teams complete visibility into every credit and debit flowing through their business accounts, updated in real time and exportable in formats that drop directly into existing reconciliation workflows. Instead of waiting for end-of-day batch files or manually logging into a banking portal to copy transaction data, finance departments access current, filterable transaction histories on demand — covering wires, ACH payments, check clearings, deposits, fee assessments, and interest postings across all linked accounts.

Real-Time Transaction Visibility

ScotiaConnect transaction reports update within seconds of settlement, displaying every cleared transaction alongside pending items that have been initiated but not yet finalized.

The transaction dashboard presents a unified feed of all account activity, sortable by date, amount, transaction type, originating account, and counterparty. Each transaction row expands to show full detail — settlement timestamp, reference number, fee breakdown, intermediary bank routing for wire transfers, and any attached notes or documentation. For enterprises managing dozens or hundreds of daily transactions, the dashboard supports bulk selection for export, categorization, and annotation so accounting teams can mark items as reconciled, flag exceptions for review, and attach internal reference codes directly within ScotiaConnect.

Pending transactions appear in a visually distinct section of the report, showing wires awaiting approval, ACH batches in processing, and scheduled payments queued for future dates. This split between cleared and pending activity gives treasury managers a complete picture of their cash position — not just what has already settled, but what is about to move.

Export Format Comparison

The table below compares the four export formats available through ScotiaConnect transaction reports, with guidance on which format suits different business needs.

Date-Range Filtering and Historical Access

ScotiaConnect transaction reports support precise date-range filtering from the current moment back through seven years of archived transaction history.

Current-year transactions return instantly from the live database, while prior-year records are retrieved from the archive system — typically within five to ten seconds for date ranges spanning multiple years. The filter interface supports custom date ranges, preset periods (current month, prior quarter, year-to-date, fiscal year), and relative ranges (last seven days, last thirty days). Multiple filters can be combined: a controller might pull all wire transfers over $10,000 from Q3 2024 across three specific accounts, and the system generates the report with those parameters applied.

Automated Reconciliation Workflows

ScotiaConnect transaction reports integrate with accounting systems through scheduled CSV exports that land in a secure download locker or arrive by email on a defined cadence.

Accounting teams configure recurring exports with field mappings tailored to their general ledger structure — mapping ScotiaConnect transaction types to GL account codes, setting delimiter preferences, and defining date formats that match their ERP import requirements. Once configured, the export runs automatically on the scheduled cadence. The accounting team receives a notification when the file is ready, imports it into their reconciliation module, and matches transactions against internal records. This automation cuts the daily reconciliation cycle from hours of manual data entry to minutes of review and exception handling.

For enterprises with internal audit requirements, ScotiaConnect transaction reports maintain full audit trails showing every report generation event — who requested the report, which filters and date ranges they applied, and the timestamp of the request. These logs support internal controls testing and satisfy examiner requests during regulatory reviews conducted under FinCEN guidelines. The transaction history archive preserves seven years of immutable records, providing the documentation foundation that accounting teams and external auditors need for period-end close, tax preparation, and compliance reporting.

"ScotiaConnect transaction reports eliminated three hours of daily manual reconciliation for our accounting team. The CSV exports drop directly into QuickBooks with the field mappings we configured once — now the team reviews exceptions instead of retyping data."

— Greta P. Johannsen

CFO, Mid-Continent Agribusiness, Omaha NE