Generate RBC payment files without an ERP
Bank-ready EFT and CPA005 files from a CSV. Built for small businesses, bookkeepers, and finance teams running RBC payment runs without treasury software.
If you’re sending vendor or payroll payments through RBC and don’t have an ERP — or your ERP doesn’t speak EFT to RBC — your options usually come down to three: re-enter each run in RBC’s business banking portal (saved templates help, but every variance from the saved list is a manual edit through the portal UI), license desktop ACH software you’ll use once a week, or stitch together a payment file in a spreadsheet and hope RBC accepts it.
PayFile Pro is the fourth option. Drop a CSV of payees in, get back a bank-ready RBC payment file. No subscription, no payment data sent to our servers, credits that never expire.
Two RBC payment file formats. Which one do you need?
RBC supports two batch payment file formats. PayFile Pro generates both. Which one you submit depends on how your RBC business banking profile is set up.
| RBC CPA005 | RBC Standard 152 | |
|---|---|---|
| Format basis | CPA Standard 005 (industry standard) | RBC-specific 152-byte layout |
| Currency | CAD or USD (one currency per file) | CAD or USD (one currency per file) |
| When to use | If RBC has provisioned your profile for CPA005 file uploads | If RBC has provisioned your profile for the Standard 152 layout |
| Generator | Open RBC CPA005 generator → | Open RBC Standard 152 generator → |
If you’re not sure which one you need: ask the RBC contact who set up your business banking profile. The format you submit must match the format your account is configured to accept. Sending the wrong format is one of the most common reasons RBC rejects a file.
How it works
First time: a few minutes
- 1. Pick your RBC format (CPA005 or Standard 152) and download the Excel (.xlsx) template. The template has every column pre-formatted as text, so leading zeros in transit numbers and account numbers stay intact.
- 2. Fill in your originator details and your payee list. Originator details are what RBC needs to identify you as the file submitter: your client number, your processing centre code (a 5-digit code RBC assigns to your business banking profile), and the transit and account number of the funding account RBC will debit. The payee list is everyone you might pay this month — full vendor list, not just this run.
- 3. Save the filled-out template as CSV, then upload to PayFile Pro. Open with Excel, edit, and use Save As → CSV (Comma delimited). PayFile Pro previews the file and validates it against RBC’s format spec before generation. If anything’s off, you see it before the bank does. Hit generate, download your file, upload it through your RBC business banking interface.
Why XLSX as the working file, CSV for upload?
Excel will silently strip leading zeros from typed-in numeric fields, which breaks transit/account number formatting. The XLSX template is pre-formatted as text to prevent this. CSV is what PayFile Pro reads — saving from your XLSX preserves the formatting you already locked in.
Every run after: under a minute
Open last week’s XLSX (not the CSV — the XLSX preserves your text formatting). Update the date, file number, and amounts. Save as CSV. Upload, generate, done. Originator details and payee list stay put.
Skipping a vendor this run? Leave the amount blank — that row is automatically skipped and stays in your template for next week. Adding a new vendor? Add a row with their banking details once; they’re part of your reusable template from then on. The XLSX is your living payee list — you maintain it in one place and reuse it forever.
Files are generated entirely in your browser. Your account numbers, amounts, and payee list never touch our servers, our disk, or anything else.
When you’d reach for this instead of the alternatives
vs. RBC’s online banking interface (RBC Express, Online Banking for Business). RBC’s portal will let you save a payment template too — that’s not where the time savings live. The difference is what happens when a run varies from the template. In the portal, skipping a vendor means actively excluding them from this run; adding a new vendor means filling in their banking details through the portal UI. Both actions are stateful — undone or repeated for every run that varies. With PayFile Pro, your Excel sheet is the template: skip a vendor by leaving the amount blank, add one by adding a row. The spreadsheet is the state; each run is just what’s in the amount column. PayFile Pro doesn’t replace your RBC interface — it sits in front of it. You generate the file here, you submit it there.
vs. an ERP (NetSuite, SAP, Sage, QuickBooks Enterprise). If you already have an ERP doing AP, use it. If you don’t, an ERP is overkill to solve “send 30 EFT payments every two weeks.” PayFile Pro is for the gap between “the bank’s portal isn’t enough” and “we have an ERP.”
vs. desktop ACH/EFT software (Treasury Software’s ACH Universal, etc.). This is the closest competitor for a small business doing RBC payment files without an ERP. ACH Universal handles US ACH/NACHA and Canadian EFT and integrates with QuickBooks. Where it differs from PayFile Pro: it’s installed Windows software (Mac users need an emulator like Parallels), licensing is annual subscription rather than prepaid credits, and the workflow is QuickBooks-tied rather than CSV-first. PayFile Pro generates RBC’s bank-specific formats (CPA005 and Standard 152) with native templates and bank-specific validation built directly against each format’s spec. If you do US ACH, want phone support, and are already deep in QuickBooks, ACH Universal is a serious option — it’s been around since 1999 and is a NACHA Preferred Partner. If you want a browser-based tool that works on any OS, no subscription, and native templates built directly against RBC’s specific formats, PayFile Pro is the tighter fit.
vs. a hand-built spreadsheet that outputs CPA005 by hand. This works until it doesn’t. RBC will reject files for a missing leading zero, a wrong record sequence, a date in the wrong format, or any of two dozen other things. PayFile Pro validates against the spec before generation, so you find out the file is malformed in your browser, not from a bank rejection email three days later.
Frequently asked questions
What's the difference between RBC CPA005 and RBC Standard 152?
RBC supports two batch payment file formats: CPA005 (aligned with the CPA Standard 005 industry format) and Standard 152 (RBC-specific 152-byte format). Which one you submit depends on how your RBC business banking profile is set up. If you’re not sure, ask the RBC contact who set up your account — using the wrong format for your profile is one of the most common reasons a file gets rejected. PayFile Pro generates both.
Do I need to be an RBC business banking customer to use PayFile Pro?
To submit a generated file, yes — your business needs to be set up with RBC for batch payment origination. PayFile Pro generates the file; your RBC business banking profile is what authorizes you to upload it. If you’re not sure whether your profile supports EFT origination, your RBC business banking contact can confirm and provision it if needed.
What is a processing centre code, and how do I get one?
A processing centre code is a 5-digit number RBC assigns to your business banking profile. It identifies which RBC processing centre handles your file submissions and goes on every payment file you generate. RBC won’t post it on a self-serve page — it’s specific to your account. If you don’t know yours, ask your RBC business banking contact.
Can I send USD payments through RBC EFT?
Yes, RBC’s CPA005 format supports both CAD and USD payments. PayFile Pro lets you choose the currency per file. One currency applies to the entire file — you can’t mix CAD and USD payments in the same generation. If you need both, generate two files.
Will this work with RBC Express or RBC Online Banking for Business?
Yes. PayFile Pro generates the payment file; RBC Express (or the file upload feature in Online Banking for Business) is what you use to submit it to RBC. They’re complementary tools. You upload the file PayFile Pro generates directly to your RBC interface — no integration or API connection required.
How is this different from saving a payment template in RBC's portal?
RBC’s portal lets you save a list of payees, which is genuinely useful — that’s not the differentiator. The difference is what happens when a run varies from the template. In the portal, skipping a vendor means actively excluding them from this run, and adding a new vendor means filling in their banking details through the portal UI. Both actions are stateful and have to be undone or repeated for the next run. With PayFile Pro, your Excel sheet is the template. Leave an amount blank to skip a vendor — their row stays in next week’s template. Add a row to add a vendor — they’re part of your reusable template from then on. The spreadsheet is the state; each run is just what’s in the amount column.
Is my payment data secure?
Yes. PayFile Pro generates files entirely in your browser. Account numbers, amounts, and payee lists never leave your machine — no upload to our servers, no storage on our disk, no transmission anywhere. The only data we store is your account info: email, company name, primary bank, credit balance.
What if RBC rejects the file I generate?
PayFile Pro validates files against the format spec before generation, which catches most common rejection causes (wrong field length, missing required fields, invalid characters, malformed dates). If RBC still rejects a file after generation, the most likely causes are: the wrong format for your profile (CPA005 vs Standard 152), an incorrect processing centre or client number, or a rare edge case we haven’t seen yet. Email hello@payfilepro.com with the rejection message and we’ll help you debug.
How much does it cost to generate an RBC payment file?
PayFile Pro uses prepaid credits. One credit per generated file. Credits never expire. Packs start at $10 USD for 5 credits ($2.00 per file) and scale to $1.50 per file at 50 credits. No subscription, no monthly minimum, no auto-renewal. Buy credits when you need them.
Ready to generate your first RBC file?
Free preview before you buy — see the parsed file before you spend a credit.
Not sure which? See the format comparison above or email us.
Sending payments through other banks?
Canadian banks
- BMO payment file generator → 1464 and EFT 80-byte
- TD payment file generator → EFT 80-byte
- CIBC payment file generator → CPA005, 1464, and EFT 80-byte
- Scotiabank payment file generator → CPA005 and ScotiaConnect EFT Import
- ATB Financial payment file generator → EFT 1464 (CPA005)
- Credit Unions payment file generator → CPA005 1464 (PaymentStream AFT)
US banks
- US ACH (any bank) payment file generator → NACHA ACH (PPD + CCD)
- JPMorgan Chase payment file generator → NACHA ACH (PPD + CCD)
- Bank of America payment file generator → NACHA ACH (PPD + CCD)
- Wells Fargo payment file generator → NACHA ACH (PPD + CCD)
- U.S. Bank payment file generator → NACHA ACH (PPD + CCD)
PayFile Pro is an independent software product. We are not affiliated with, endorsed by, or sponsored by Royal Bank of Canada. RBC, RBC Royal Bank, RBC Express, CPA Standard 005 are trademarks of their respective owners.