RBC Express Transaction Reporting: 60-Field Activity Reports
RBC Express Transaction Reporting is the reporting engine underneath every number on the Account Summary dashboard. Sixty-plus filterable fields. Saved views. Scheduled BAI2 and MT940 delivery. CSV, XLSX and PDF. Seven-year audit retention aligned with OSFI and CRA record-keeping expectations. One engine across every commercial account.
Treasury controllers schedule daily BAI2 drops to Kyriba, ION and SAP TRM. AP leads pull CSV extracts filtered by vendor and value date. Internal auditors search the full 7-year archive by transaction reference. Every report generation event writes to the RBC Express audit log for regulatory defensibility.
Open RBC Express Reports Build a Custom Report
60 Fields. Every Filter. One Report Engine.
The RBC Express Transaction Reporting engine exposes the same data the RBC core banking platform posts to the general ledger — filtered, sorted and exported on demand.
Identity Fields
Originator name, originator account, beneficiary name, beneficiary account, BIC, IBAN, correspondent bank, intermediary reference, end-to-end reference, initiator user ID, approver user ID, release user ID — twelve ways to trace a single transaction through the RBC Express workflow.
Amount & FX Fields
Gross amount, net amount, fee amount, original currency, settlement currency, FX rate, FX spread, value date, posting date, running balance. For multi-currency treasury operations this is where most RBC Express Transaction Reporting queries begin — rate plus date plus counterparty.
Status & Compliance
Status (initiated, pending approval, released, settled, returned), OFAC screening result, sanctions hit reference, FINTRAC reportable flag, GL code, cost centre, tag, memo line. RBC Express Transaction Reporting surfaces compliance fields in the same query plane as operational fields — no separate AML portal.
Standard Report Library Inside RBC Express
Six pre-built reports cover 80 percent of treasury and AP use cases. Start with a template, refine with filters, save the view, schedule the delivery.
| Report | Fields | Format Options | Schedule |
|---|---|---|---|
| Prior-Day Balance & Transaction | 40 | BAI2, MT940, CSV, PDF | Daily 7:00am ET |
| Intraday Activity | 32 | BAI2 Intraday, MT942, CSV | Every 15 min |
| Wire Activity Detail | 58 | CSV, XLSX, PDF | On demand / daily |
| EFT Batch Summary | 28 | CSV, PDF | Per batch release |
| FX Rate & Contract Log | 22 | CSV, XLSX | Daily / weekly |
| User Audit Trail | 18 | CSV, PDF | Monthly / on demand |
Scheduled Delivery From RBC Express
Most commercial teams do not sit inside RBC Express Transaction Reporting all day. They get files dropped into a treasury workstation, an ERP inbox or a cloud folder.
Delivery Channels
SFTP pickup (most common for BAI2 into Kyriba, ION, GTreasury, Treasury Intelligence Solutions). Secure encrypted email with PGP attachment for smaller organisations. HTTPS webhook JSON for modern treasury stacks. Direct API pull for teams building in-house dashboards. Every delivery from RBC Express Transaction Reporting is signed, versioned and retried on failure.
Schedule Granularity
Every 15 minutes (for MT942 intraday). Hourly. Daily at a user-specified ET time. Weekly on a user-specified day. Monthly on the 1st or last business day. Bank holiday awareness suppresses delivery on Canadian statutory holidays or shifts to the next business day per preference. Multiple schedules per saved view let the same RBC Express Transaction Reporting template feed different downstream systems at different cadences.
Reporting Dimensions
- RBC Express Transaction Reporting = 60-plus filterable fields across identity, amount, status and compliance.
- Export formats = BAI2 Prior Day and Intraday, MT940, MT942, CSV, TSV, XLSX, PDF, JSON API.
- Schedules run every 15 minutes to monthly; SFTP, encrypted email, HTTPS webhook or API pull.
- Retention = 7 years, aligned with OSFI and CRA record-keeping expectations; full audit trail on every run.
- Saved views preserve filters, sort order, columns, export format and schedule — shareable to teammates in scope.
Audit Trail and 7-Year Retention
Every action inside RBC Express Transaction Reporting is captured — including the reporting metadata itself.
Who ran the report. Which filters were applied. What was exported. Where it was delivered. When it was opened at the SFTP endpoint. The RBC Express Transaction Reporting audit log captures all of it for 7 years, searchable by authenticated Company Administrators. For regulated clients this defeats the most common audit question: "can you prove what was sent and to whom?" Yes — through the same RBC Express Transaction Reporting engine that produced the original file. The retention window aligns with OSFI record-keeping expectations and CRA tax archive requirements.