ScotiaConnect Payment Reconciliation

ScotiaConnect Payment Reconciliation Overview

Reconciliation is the step that separates good treasury operations from great ones. Every ACH batch, wire transfer, and check payment your business issues eventually needs to be matched against internal records — invoices, purchase orders, payroll registers, general ledger entries. Done manually, this consumes hours of finance team time every day. ScotiaConnect payment reconciliation automates the matching process so your team spends its time reviewing exceptions rather than pairing thousands of routine transactions one by one.

Automated Transaction Matching

ScotiaConnect reconciliation applies configurable matching rules against every payment that clears your accounts. The engine compares transaction data from the ScotiaConnect payment ledger with records imported from your accounting system or ERP platform.

Matching Rule Configuration

Define matching criteria that reflect how your business identifies reconciled transactions. Common rules include: exact match on amount plus reference number; amount match with a date tolerance of one business day; amount match with partial reference number comparison; payee name fuzzy matching for situations where your ERP records a vendor name slightly differently than the payment instruction. ScotiaConnect processes these rules in priority order — exact matches clear first, then progressively looser rules catch near matches that appear in the exception review queue. The matching engine runs automatically each morning, or you can trigger an on-demand reconciliation run after uploading a new batch of internal transaction data.

Exception Handling and Investigation Workflow

The transactions that automated matching cannot resolve are where your finance team adds real value. ScotiaConnect surfaces every unmatched item in the exception dashboard with the most likely reason for the mismatch.

Exception Categories and Resolution Tools

Each exception carries a category flag: amount discrepancy where the payment amount differs from the expected amount by more than the defined tolerance; missing counterpart where no matching record exists in the imported data; timing difference where the payment settled on a different date than expected; duplicate detection where the same payment appears to have been submitted twice. For each exception, ScotiaConnect displays the payment details side-by-side with the closest potential match from your imported records. Treasury staff can confirm the suggested match, manually pair the transaction with a different record, flag the item for further investigation by AP or the originating department, or create an adjusting entry. Every resolution action is timestamped and attributed to the user who resolved it.

Integration with Accounting Systems and ERP Platforms

Reconciliation only works when both sides of the equation — the bank payment data and your internal accounting records — are in the same system. ScotiaConnect supports data import from virtually any accounting or ERP platform through three methods.

Data Import Methods and Field Mapping

CSV upload handles ad hoc imports and platforms without API connectivity. Fixed-width file import accommodates legacy ERP systems that export data in columnar formats. Direct API integration, available for major ERP platforms, enables scheduled imports that pull transaction data automatically on a daily or weekly cadence. During initial setup, you map the columns in your import file to ScotiaConnect reconciliation fields — transaction date, amount, reference number, payee name, payment type — and the system retains that mapping for all subsequent imports from the same source. Field mapping is saved as a named configuration profile, so organizations reconciling data from multiple systems can switch between profiles without redefining the mapping each time. The FinCEN recordkeeping requirements mandate that financial institutions retain transaction records for five years, and ScotiaConnect reconciliation exports produce a complete, auditable package that satisfies both internal and external review standards.

Daily Reconciliation Workflow

A typical ScotiaConnect reconciliation day starts before your finance team arrives. The system runs the scheduled data import, pulling yesterday's transactions from your ERP or accounting platform. Then the matching engine processes all cleared ScotiaConnect payments against the imported records. Within minutes, the reconciliation dashboard updates: matched transactions move to the completed register, unmatched items populate the exception queue with suggested pairings, and a summary email lands in your treasury team's inbox showing the match rate, exception count, and any critical items — like large wires that failed to match — that deserve immediate attention.

Review, Resolve, and Report

Your team opens the ScotiaConnect reconciliation dashboard, reviews the exception queue sorted by priority and aging, resolves each unmatched item using the side-by-side comparison view, and generates a daily reconciliation report with a single click. The report includes the match rate, a categorized breakdown of exceptions by reason code, an aging summary that shows how long each unresolved exception has been open, and a complete audit log of all resolution actions taken that day. Reports export as PDF for audit packages or CSV for further analysis in your own tools.

Reconciliation Reporting and Audit Support

ScotiaConnect generates a daily reconciliation summary that captures the complete picture: total transactions processed, match rate percentage, exception count and categories, aging on unresolved items, and a user-action audit trail showing who resolved each exception and when. Monthly reconciliation reports aggregate daily summaries into a single document suitable for month-end close packages or external auditor review. All ScotiaConnect reconciliation data and reports remain accessible for seven years — consistent with the audit record retention period maintained across the ScotiaConnect platform.