RBC Express Custom Reports: Drag-and-Drop Report Builder
RBC Express Custom Reports is the drag-and-drop builder that sits next to standard transaction reporting. Treasury analysts, controllers and AP leads build their own views without a SQL engineer, an IT ticket or an Excel macro. Calculated fields. Conditional formatting. Pivot tables. GL mapping. ERP integration. All inside authenticated RBC Express.
A treasury analyst drags value date into rows, currency into columns and net settlement amount into values. Filters collapse the query to last 30 days. A calculated field adds year-over-year variance. Conditional formatting flags any row above $1M in red. Export to XLSX with formulas preserved. Save the layout. Schedule a daily 7:00am ET SFTP drop to Kyriba. Four minutes of work inside RBC Express Custom Reports.
Build a Custom Report See Export Formats
The Custom Reports Builder Experience
RBC Express Custom Reports is built on the same 60-plus field schema as standard transaction reporting — except every field is a draggable tile.
Drag-and-Drop Canvas
Pick from a left sidebar of every RBC Express field. Drop into rows, columns, values or filters. Reorder with a drag. Remove with a click. The canvas renders live as fields move — no run button. A treasury analyst building an AP ageing view inside RBC Express Custom Reports sees results update in real time.
Calculated Fields
Sum, average, min, max, count, distinct, percent of total, percent change, moving average, FX conversion, date math, conditional expressions. RBC Express Custom Reports accepts formula syntax or a guided builder — pick the operator, pick the inputs, name the result. Formulas save with the report definition and export in XLSX with working cell references.
Conditional Formatting
Highlight rows above a threshold. Colour-code currencies. Flag transactions missing a GL code. Bold any row from a specific counterparty. RBC Express Custom Reports conditional formatting survives export to XLSX and PDF so recipients see the same visual cues that the analyst built inside the portal.
Five Common Custom Report Use Cases
Representative layouts built by RBC Express commercial clients in under ten minutes each.
| Use Case | Fields | Output | Refresh Cadence |
|---|---|---|---|
| AP Ageing by Vendor | Vendor, Due Date, Amount, Status | XLSX + PDF | Weekly |
| FX Exposure by Currency | Currency, Account, Balance, Rate | XLSX + Pivot | Daily |
| Cost Centre Allocation | GL Code, Cost Centre, Amount, Date | CSV to ERP | Monthly close |
| Wire Volume Trending | Beneficiary Country, Amount, Date | PDF + XLSX | Monthly |
| EFT Return Rate | Vendor, Return Reason, Count, Total | CSV + Email | Daily |
ERP Integration From RBC Express Custom Reports
Most finance organisations close the month inside an ERP, not inside a bank portal. RBC Express Custom Reports maps cleanly to the major Canadian and global ERP stacks.
Supported ERPs
SAP S/4HANA, Oracle NetSuite, Microsoft Dynamics 365 Finance, Sage Intacct, QuickBooks Canada, Sage 300 (Accpac), Xero, MRI Software, Yardi, Workday Financial Management. RBC Express Custom Reports delivers via BAI2 into cash management modules, CSV with custom column mapping into AP modules, or direct API into cloud ERPs supporting webhook ingestion.
GL Code Mapping
Map RBC Express transaction types to your chart of accounts once. Every future report honours the mapping. Wire fees post to one GL code, EFT originations to another, FX gain/loss to a third. RBC Express Custom Reports output matches what your ERP expects — no reclassification work at month-end. Company Administrators maintain the mapping through user management.
Service Brief
- RBC Express Custom Reports = drag-and-drop builder with calculated fields, pivot and conditional formatting.
- ERP targets include SAP, Oracle NetSuite, Dynamics 365, Sage Intacct, QuickBooks Canada, Sage 300, Xero, Workday.
- Distribution lists deliver PDF, XLSX, CSV or JSON to SFTP, secure email or HTTPS webhook — no login required for recipients.
- GL code mapping preserves chart of accounts across reports; maintained by Company Administrators.
- Pivot engine handles 500,000 transaction rows without pagination; drill-through preserved on export.
Distribution Lists and Scheduled Delivery
Most controllers build one report and send it to twelve people weekly. RBC Express Custom Reports handles the fan-out without a shared login.
A Company Administrator creates a distribution list inside RBC Express Custom Reports — email addresses, SFTP endpoints, HTTPS webhooks. The saved report schedules against the list. Every delivery writes to the RBC Express audit trail. Recipients open the file without needing RBC Express credentials. For client confidentiality, encrypted transport (PGP on email, TLS 1.3 on HTTPS, SSH on SFTP) is default. Per OSFI B-13 technology risk guidance, every outbound delivery from RBC Express Custom Reports is logged, signed and retained for 7 years.