Not sure where to even start?
Then this is the place for you.
You can create a test EFT file for your bank:
For those who prefer to watch a video to 'Get Started', please use this link:
Getting Started (3m 52s)
1. Create a new account in ACH Universal (File > New > Create)
Click on the blue 'File' tab >New Account > 'Create an Account'.
Note: If you will be setting up on a multi-user platform, you may want to hold off creating your production accounts until you have connected to the SQL backend. See the SQL instructions for our
Workgroup (SQL Express) or Enterprise (SQL Server) platform.
Then enter a name for your account. You will want to be able to identify the bank account name (e.g., Operating or Payroll). Click Next, then Finish. The software will open into the new account.
If you will be originating ACH transactions from more than one bank account, you will want to create a new account in our software for each bank account originating ACH files.
(See also Multiple Origination, covered separately, if working with numerous bank accounts.)
2. EFT File Setup
Open the Canadian Setup page by clicking on either the Canadian EFT Setup (red maple leaf icon) in the Ribbon Bar - or on the Home Page of the software.
First, click on the 'Activate Canadian format' checkbox,
Choose a bank under the Quick Setup. Many of the default settings for each bank will auto-populate, including the bank's Destination Data Centre.
If your bank is not listed, select 'All Other Banks' and enter your Bank's Destination Centre.
Enter your company information as requested and then scroll to the bottom and click 'Save'.
Be sure to click 'OK' at the bottom of the page when completed.
Bank Specific Notes and Documentation
Toronto Dominion - TD
Royal Bank of Canada - RBC
Bank of Montreal - BMO
Canadian Imperial Bank of Commerce - CIBC
--It is unusual for you to need to adjust the settings in the 'Bank and Override codes' section.
--Enter a short company name or acronym (up to 15 characters, all capitals, no spaces) as well as a long company name (up to 30 characters) as either may be displayed on the other party's bank statement.
--The Originator/Company ID number is assigned by the bank. (It is generally not the same as your bank account number.)
A. Should I enter any information within the ACH File Setup Wizard (7 screens)?
No, you will not need to enter any data in the ACH File Setup. This is for the U.S. format only. Please leave the settings at their default settings, and any entries empty.
B. Testing with my bank - any special settings?
Yes, if the bank requires it, please enter the following into the 'Override for the File Creation Number' field (do not enter the apostrophes):
- RBC: enter 'TEST'
- Scotiabank: enter '0000'
- TD Bank: enter '0001'
- BMO: enter '0001'
After you've created and uploaded a successful test file, delete any entry from the 'Override for the File Creation Number' field and enter '0001' under 'Reset File Create Number' and click the blue link. (TD and BMO will enter '0002' and Reset.)
Click 'OK' at the bottom of the page when making any changes in the Settings.
C. Need to create Branch + Financial Institution number?
(In the U.S. it is known as an ABA Routing Number.)
3. Import data using QuickBooks Desktop, QuickBooks Online or import Excel/csv files
Follow the instructions for importing data and creating files for ACH Universal.
Need help or want to schedule a call to get setup?
Intuit and QuickBooks are registered trademarks of Intuit Inc. Used with permission.