Generate ATB Financial payment files without an ERP

Bank-ready ATB Financial EFT 1464-byte payment files from a CSV, in CAD or USD. Built for Alberta small businesses, bookkeepers, and finance teams running ATB payment runs without treasury software.

Generate your first ATB fileFree preview, no signup required.

If you’re sending vendor or payroll payments through ATB Financial and don’t have an ERP — or your ERP doesn’t speak EFT to ATB — your options usually come down to three: re-enter each run in ATB Business (you can save Receivers and Templates, 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 ATB accepts it.

PayFile Pro is the fourth option. Drop a CSV of payees in, get back a bank-ready ATB EFT 1464-byte file. No subscription, no payment data sent to our servers, credits that never expire.

Scope

PayFile Pro generates ATB credit files (vendor and payroll disbursements) in the 1464-byte CPA format. Debit files for pre-authorized debit (PAD) collections aren’t currently supported, and PayFile Pro doesn’t currently generate ATB’s 96-byte or CSV import formats — email us if either is something you need.

How it works

First time: a few minutes

  1. 1. Download the Excel (.xlsx) template from the ATB EFT 1464 generator. The template has every column pre-formatted as text, so leading zeros in transit numbers and account numbers stay intact.
  2. 2. Fill in your originator details and your payee list. Originator details for ATB are: your 10-character Originator’s ID (format 21990EEEEE, where 21990 is ATB’s Data Centre ID and EEEEE is the 5-digit Profile ID ATB assigned you when EFT was provisioned — see the Originator’s ID FAQ below for where to find it), your originator long and short names (what appears on your payee’s bank statement), your file creation number (a 4-digit value 00019999 that increments each file — ATB rejects a duplicate file creation number only when both the number and all transactions in the file are identical to a prior submission, but the safer practice is to keep every production file’s creation number unique), and the transit and account number of the settlement account ATB will debit.

    The payee list is everyone you might pay this month — full Receiver list, not just this run.

  3. 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 ATB’s 1464-byte format spec before generation. If anything’s off, you see it before the bank does. Hit generate, download your file, then upload it through ATB Business (Create EFT → Import a File → Select EFT profile → Browse to the file → Import file).

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 creation 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. ATB Business. ATB Business will let you save Receivers and reusable Templates — 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 adding them as a Receiver. 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 ATB Business — 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 ATB 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 ATB’s specific format (CPA 1464-byte) with a native template and bank-specific validation built directly against the 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 a native template built directly against ATB’s specific format, PayFile Pro is the tighter fit.

vs. a hand-built spreadsheet that outputs ATB CPA 1464 by hand. This works until it doesn’t. ATB will reject files for a missing leading zero, a wrong record sequence, an invalid Originator’s ID, a logical record count that doesn’t match the actual record count, an out-of-range due date, 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

Do I need to be an ATB business banking customer to use PayFile Pro?

To submit a generated file, yes — your business needs to be set up with ATB Financial for batch payment origination, with the EFT Service activated and a Profile ID assigned. PayFile Pro generates the file; your ATB business banking profile is what authorizes you to upload it. If you’re not sure whether your profile supports EFT origination, your ATB Relationship Manager or ATB Business Solutions (1-877-363-4855) can confirm and provision it if needed.

What is my ATB Originator's ID, and how do I get one?

An Originator’s ID is a 10-character alphanumeric value ATB assigns to you when your EFT Service is provisioned. It identifies you as the originator of the file and appears in the A (header) record of every CPA 1464-byte ATB EFT file. Per ATB’s CPA 1464-byte file specification, its format is fixed:

  • The first five characters are always 21990 — that’s ATB Financial’s Data Centre ID, identical for every ATB customer.
  • The last five characters are your Profile ID— a 5-digit value ATB assigns you. This is the part that’s unique to your business.

So the full Originator’s ID looks like 21990EEEEE, where EEEEE is your Profile ID. Your Profile ID is also what shows up in ATB Business when you go to Create EFT → Import a File and select an EFT profile. Get it from the ATB Business Solutions team that set up your EFT Service, or look it up in ATB Business under your EFT profile settings. There’s no self-serve external lookup — ATB assigns it.

The PayFile Pro template asks for the full 10-character Originator’s ID. If you only have your 5-digit Profile ID handy, prefix it with 21990 to get the value the file requires. (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,” Scotiabank’s term is “Customer Number,” and ATB’s term is “Originator’s ID.”)

What's the difference between ATB's 1464-byte, 96-byte, and CSV import formats?

ATB Business accepts three EFT file import formats, and the format you choose is independent of the payment data itself — same underlying transactions, three different file structures.

  • 1464-byte (CPA format) — the Canadian Payments Association’s industry-standard fixed-width file. ATB recommends this format. Originator’s ID, originator long/short names, settlement details, and every payment field are written into a 1464-character record. This is the format PayFile Pro generates.
  • 96-byte format — an ATB-developed simplified version of the CPA format. Each transaction is encoded in a more compact 96-byte record. Available in ATB Business but not currently generated by PayFile Pro.
  • CSV format — ATB’s own CSV layout for EFT import. Available in ATB Business but distinct from PayFile Pro’s input CSV (PayFile Pro’s CSV is the input to the template; ATB’s CSV is an alternative output file format). Not currently generated by PayFile Pro.

If your ATB profile is set up for any of the three, the 1464-byte file PayFile Pro generates will work. If you specifically need the 96-byte or CSV format generated for a downstream system that requires it, email us — both are on the roadmap and customer demand is what moves them up.

Can I send USD payments through ATB EFT?

Yes — ATB supports EFT credits in both CAD and USD. PayFile Pro’s ATB EFT 1464 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. (Liquidity limits in ATB Business are tracked separately for CAD and USD, so this single-currency-per-file constraint matches how ATB operates regardless.)

Will this work with ATB Business?

Yes. PayFile Pro generates the payment file; ATB Business (formerly ATB Online Business) is what you use to submit it. They’re complementary tools — no integration or API connection required. From the EFTs home page in ATB Business, choose Create EFT → Import a File → Select EFT profile → Browse to the file PayFile Pro generated → Import file. The same flow works for both small business and full commercial cash management — there’s no separate platform to worry about.

How is this different from saving a payment template in ATB Business?

ATB Business lets you save Receivers and reusable Templates, which is genuinely useful — that’s not the differentiator. The difference is what happens when a run varies from the template. In ATB Business, 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 adding them as a Receiver. 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 ATB debit files (PADs)?

Not currently. PayFile Pro generates ATB 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. (ATB has its own PAD agreement requirements you’d need to satisfy with ATB Financial separately before originating PAD collections — see the PAD Agreement appendix in the ATB EFT User Guide.)

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 ATB 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 ATB still rejects a file after generation, the most likely causes are: an invalid Originator’s ID (a frequent first-time error is using just the 5-digit Profile ID without the 21990 prefix, or vice versa — see the Originator’s ID FAQ), a duplicate file creation number combined with identical transactions (ATB rejects only when both match a prior file — but unique creation numbers per production run is the safer practice), a logical record count mismatch (the trailer’s record count must equal the actual number of records in the file), an out-of-range due date, an invalid transaction type code, 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 an ATB 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 ATB file?

Free preview before you buy — see the parsed file before you spend a credit.

Questions about your setup? Email us.

Sending payments through other banks?

PayFile Pro is an independent software product. We are not affiliated with, endorsed by, or sponsored by ATB Financial (Alberta Treasury Branches). ATB Financial, ATB Business, ATB Online Business are trademarks of their respective owners.