Generate Scotiabank payment files without an ERP
Bank-ready Scotiabank CPA005 1464 and ScotiaConnect EFT Import payment files from a CSV. Built for small businesses, bookkeepers, and finance teams running Scotiabank payment runs without treasury software.
If you’re sending vendor or payroll payments through Scotiabank and don’t have an ERP — or your ERP doesn’t speak EFT to Scotiabank — your options usually come down to three: re-enter each run in ScotiaConnect (you can save templates and Payment Groups, but every variance from the saved list is a manual edit through the portal UI), license desktop EFT software you’ll use once a week, or stitch together a payment file in a spreadsheet and hope Scotiabank accepts it.
PayFile Pro is the fourth option. Drop a CSV of payees in, get back a bank-ready Scotiabank payment file. No subscription, no payment data sent to our servers, credits that never expire.
Scope
PayFile Pro generates Scotiabank credit files (vendor and payroll disbursements). Debit files for pre-authorized debit (PAD) collections aren’t currently supported — email us if that’s something you need.
Two Scotiabank payment file formats. Which one do you need?
PayFile Pro generates two Scotiabank payment file formats. They serve different submission paths — which one you need depends on how your Scotiabank business banking is set up and how your team submits files to the bank.
| Scotiabank CPA005 1464 | ScotiaConnect EFT Import | |
|---|---|---|
| Format basis | CPA Standard 005 (industry standard, 1464-byte fixed-width) | Scotiabank-specific EO record format (586-byte fixed-width, CRLF line endings) |
| Currency | CAD or USD (one currency per file) | Set by your preconfigured Payment Group in ScotiaConnect |
| When to use | Direct submission to Scotiabank as a CPA005 file. The standard option if your account is set up for CPA005 file submission and you control the originator details on each file | Upload through ScotiaConnect using a preconfigured Payment Group. Use this if your team manages payments through Service Groups and Payment Groups in ScotiaConnect — the file references your existing setup rather than re-entering originator details every time |
| Generator | Open Scotiabank CPA005 generator → | Open ScotiaConnect EFT Import generator → |
If you’re not sure which one you need: ask the Scotiabank contact who set up your business banking profile. The format you submit must match the submission path your account is configured for. Sending the wrong format — or putting CPA005 originator details in an EFT Import file expecting a Payment Group reference, or vice versa — is one of the most common reasons Scotiabank rejects a file.
How it works
First time: a few minutes
- 1. Pick your Scotiabank format (CPA005 or ScotiaConnect EFT Import) 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. What goes here depends on the format you picked:
- Scotiabank CPA005 1464 — your 10-digit Customer Number (assigned by Scotiabank when your account is provisioned for CPA005 EFT submission — see the Customer Number FAQ below for where to find it; this is not the same as the 6-digit ScotiaConnect tech-support customer number), your originator long and short names (what appears on your payee’s bank statement), your file creation number (use 0000 for test files; unique non-zero for production — Scotiabank rejects duplicate file creation numbers, see the rejections FAQ), and the transit and account number of the settlement account Scotiabank will debit.
- ScotiaConnect EFT Import — your preconfigured Payment Group identifier (see the Payment Group FAQ below). The Payment Group is the unit you set up in ScotiaConnect that carries your originator-side details (via the linked SD Agreement: long/short name, settlement/chargeback account, currency) — it’s referenced by name in the file rather than re-entered every time. You still enter your full payee list (recipient name, institution, transit, account) in the PayFile Pro template — recipients aren’t part of the Payment Group.
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 Scotiabank’s format spec before generation. If anything’s off, you see it before the bank does. Hit generate, download your file, upload it through ScotiaConnect (or your direct CPA005 submission path).
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. ScotiaConnect. ScotiaConnect will let you save EFT templates and configure Payment Groups — 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 and assigning them to a Service Group. 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 ScotiaConnect — 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 Scotiabank 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 Scotiabank’s specific formats (CPA005 1464 and ScotiaConnect EFT Import) 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 Scotiabank’s specific formats, PayFile Pro is the tighter fit.
vs. a hand-built spreadsheet that outputs Scotiabank CPA005 by hand. This works until it doesn’t. Scotiabank will reject files for a missing leading zero, a wrong record sequence, a duplicate file creation number, a date outside the −30/+60-day window, 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 Scotiabank CPA005 1464 and ScotiaConnect EFT Import?
Two different submission paths into Scotiabank. CPA005 1464 is the Canadian Payments Association industry-standard format — a 1464-byte fixed-width file you submit directly to Scotiabank, with all originator details (Customer Number, originator long/short names, settlement account) carried in the file’s header records. ScotiaConnect EFT Import is a Scotiabank-specific 586-byte format used by businesses who manage payments through ScotiaConnect’s Service Groups and Payment Groups — the file references your preconfigured Payment Group by name, and ScotiaConnect resolves the originator details, settlement account, and currency from your existing setup. Which one you submit depends on how your Scotiabank business banking is configured and how your team prefers to submit files. PayFile Pro generates both.
Do I need to be a Scotiabank business banking customer to use PayFile Pro?
To submit a generated file, yes — your business needs to be set up with Scotiabank for batch payment origination, either for direct CPA005 submission or for ScotiaConnect with EFT/Payment Group entitlements. PayFile Pro generates the file; your Scotiabank business banking profile is what authorizes you to upload it. If you’re not sure whether your profile supports EFT origination, your Scotiabank business banking contact can confirm and provision it if needed.
What is my Scotiabank Customer Number, and how do I get one?
A Customer Number is a 10-digit unique identifier Scotiabank assigns to you when your account is provisioned for CPA005 EFT file submission. It identifies you as the file submitter and appears in three places in every CPA005 file: the A (header) record, every C (credit) record, and the Z (trailer) record. Per Scotiabank’s CPA005 1464-byte file specification, all three values must match exactly or the file will be rejected. Your Customer Number is assigned by Scotiabank — there’s no self-serve way to look it up. Get it from the Scotiabank business banking contact who set up your CPA005 EFT origination.
A common point of confusion. Scotiabank also issues a separate 6-digit “ScotiaConnect customer number” that’s used for identifying your company when you call ScotiaConnect technical support. It’s visible by clicking the profile icon in the top right corner of any page in ScotiaConnect. This is a different identifier from your 10-digit CPA005 Customer Number — they are not interchangeable. Putting the 6-digit ScotiaConnect support number into your CPA005 template will cause Scotiabank to reject the file. The value you need for your PayFile Pro template is the 10-digit one assigned for EFT submission.
For ScotiaConnect EFT Import files, you don’t enter a Customer Number directly into the template — the file references a Payment Group instead, and ScotiaConnect resolves your customer identity from your authenticated session. The 10-digit Customer Number requirement only applies to the CPA005 path. (Different banks use different terms for the same kind of code — RBC calls theirs a “processing centre code,” BMO and TD use “Originator ID,” CIBC’s term is “Originator Number,” and Scotiabank’s term is “Customer Number.”)
What is a ScotiaConnect Payment Group, and how do I find it?
A Payment Group is a unit you configure in ScotiaConnect that controls which SD Agreements and chargeback (settlement) accounts a batch of EFT payments can be debited against. The SD Agreement linked to your Payment Group is what carries your originator long and short names, settlement account, and currency — so a single Payment Group reference in the file resolves all the originator-side details Scotiabank needs. Per Scotiabank’s ScotiaConnect Standard Import spec, the Payment Group field is mandatory in every EFT Import (EO) record, and Scotiabank validates that the agreement number and chargeback account associated with the named group are accessible to your user — if they’re not, the file is rejected.
Payment Groups are a different ScotiaConnect concept from Service Groups. Payment Groups govern originator-side details (which SD Agreements and chargeback accounts a payment can draw from). Service Groups govern recipient-side details (which payees a user can send payments to, and approval limits). The ScotiaConnect EFT Import file references your Payment Group; the recipient details for each payment are entered directly in your PayFile Pro template (recipient name, institution, transit, account) and written into each payment row in the generated file.
To find the Payment Group identifier you should reference in your PayFile Pro template: in ScotiaConnect, go to your EFT/Integrated Payments setup and look at the Payment Groups your profile has access to. If you don’t see any, your Super User or administrator needs to set one up before you can use the ScotiaConnect EFT Import format. If you only have CPA005 file submission set up (not ScotiaConnect Payment Groups), use PayFile Pro’s Scotiabank CPA005 generator instead.
Can I send USD payments through Scotiabank EFT?
Yes — Scotiabank supports EFT credits in both CAD and USD via CPA005 1464. PayFile Pro’s Scotiabank CPA005 generator 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.
For ScotiaConnect EFT Import, the file’s currency is set by your Payment Group configuration in ScotiaConnect — not by the file itself. If you need to submit USD via the EFT Import path, you’ll need a USD-configured Payment Group set up in ScotiaConnect (your Super User or administrator can do this).
Will this work with ScotiaConnect?
Yes. PayFile Pro generates the payment file; ScotiaConnect is what you use to submit it. They’re complementary tools — no integration or API connection required. You upload the file PayFile Pro generates directly to ScotiaConnect’s payment file upload feature. The same flow works whether your business uses ScotiaConnect Digital Banking for Business for small-business operations or for full commercial cash management — there’s no separate small-business platform to worry about.
How is this different from saving a payment template in ScotiaConnect?
ScotiaConnect lets you save EFT templates and configure Payment Groups, which is genuinely useful — that’s not the differentiator. The difference is what happens when a run varies from the template. In ScotiaConnect, 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 and assigning them to a Service Group. 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.
Can PayFile Pro generate Scotiabank debit files (PADs)?
Not currently. PayFile Pro generates Scotiabank credit files — vendor payments, payroll, supplier disbursements. Pre-authorized debit (PAD) collections aren’t supported. If debit file generation is something you need, email hello@payfilepro.com — it’s on the roadmap and customer demand is what moves it up.
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 Scotiabank 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 Scotiabank still rejects a file after generation, the most likely causes are: the wrong Customer Number on a CPA005 file (a frequent first-time error is using the 6-digit ScotiaConnect tech-support customer number instead of the 10-digit one Scotiabank assigned for EFT submission — see the Customer Number FAQ), a duplicate file creation number on a CPA005 production file (Scotiabank requires every production file’s creation number to be unique — use 0000 only for test files), a due date outside Scotiabank’s −30/+60-day window from the file creation date, the wrong format for your submission path (CPA005 sent to a Payment Group profile, or vice versa), an incorrect settlement account, 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 a Scotiabank 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 Scotiabank 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
- RBC payment file generator → CPA005 and Standard 152
- 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
- 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 The Bank of Nova Scotia. Scotiabank, ScotiaConnect, ScotiaConnect Digital Banking for Business are trademarks of their respective owners.