The Destination Data Centre for ATB is 21990
For their EFT ID, it was the Data Centre number + transit number
Appendix B—EFT file validations
Getting Started - ACH Universal
- Getting Started with ACH Universal - Basic Steps.
- Welcome to ACH Universal!
- Download and Install
- Create an Account
- Importing Data and Creating a File
- Automate Backup
- Getting Started with Excel and csv File Imports
- Create an Excel/CSV file for Import
- Mapping Fields - Reference
- Creating and Using Profiles
- Deleting an Import
- Editing Untransmitted Records
- Import Options
- Troubleshooting Importing of Excel files
- Getting Started in QuickBooks
- Writeback - Pay Some Vendors by Check, Some by ACH
- ACH-QuickBooks Specific Options
- Pre-Notes and Split Deposits
- Email Overview - QuickBooks
- ACH Universal-Based Profiles
- CCD vs PPD (SEC Codes)
- Self-guided tour (review/testing)
- Multiple Origination Accounts - QuickBooks Integration
- Exporting QuickBooks Banking Info
-
Troubleshooting
- QuickBooks Troubleshooting - Connections
- QuickBooks Troubleshooting Setup
- QuickBooks Permissions and Security - ACH
- Revoked Certificate - QuickBooks
- Troubleshooting - Creating a Report in QuickBooks of Profile Data (P1)
- Troubleshooting - Creating a Report in QuickBooks of Bank Register Data (P2)
- Troubleshooting - Missing transactions when integrating with QuickBooks Desktop
- Troubleshooting 'XML' Error message
- How do I know if I should process ACH payments or check payments in QuickBooks?
- How do I 'hold' or 'exclude' a payment once I have it in the QuickBooks integration box?
- ACH Universal won't connect to QuickBooks. What's wrong?
- How do you set up split deposits? And can I use percentages?
- How do I upload banking information to QuickBooks profiles?
- What are the minimum access rights needed in QuickBooks for integration with ACH Universal?
- How can I prevent issued checks from transferring to ACH Universal when using QuickBooks?
-
Reference / Legacy
- QuickBooks Setup and Integration - Overview
- Connect to QuickBooks
- QuickBooks Integration Wizard
- Mapping Import Data Using Profiles-Excel
- Profiles in QuickBooks
- Creating a Sub-Account in QuickBooks for ACH Transactions
- Transmitting ACH Files to Your Bank
- After Importing Transactions: Create the File
- Settings - ACH Universal
- Holding and Resending Transactions
- Direct Deposit with QuickBooks Integration
- Pay Cards
- Write-Back Feature
- Creating ACH Files
- Setup Legacy - QuickBooks Online
- Creating an ACH File Legacy - QuickBooks Online
- ACH Setup Wizard - Basic Reference Legacy
- Getting Started with Canadian EFT's - Basic Steps Legacy
- Canadian Format - Overview and Setup Legacy
- How do I set up an Offset record (or Balanced file)? Legacy
- How do I create a Pre-note? Legacy
- How do I create a Reversal? - Legacy
- International Transactions (IAT) Legacy
- Is Treasury Software Compliant with the New NACHA Rules? Legacy
- Can you walk me through how to create an ACH file? Legacy
- How do I set up the email feature in ACH Universal? Legacy
- Is it necessary to have ID numbers assigned to Profiles? Legacy
- How do I change where the transmission file is saved? Legacy
- Why is the software saying I have invalid profiles?
- Getting Started - QuickBooks Online
- Importing Transactions
- Multiple Accounts
- Email Check Stubs
- Profiles
- Self-guided tour (review/testing)
- Transitioning from QuickBooks Desktop to QuickBooks Online
-
Troubleshooting
- QuickBooks Online - Troubleshooting
- Exporting Transactions from QuickBooks Online to Excel
- QuickBooks Online - How to Change From French to English
- Fixing 'Could not bind server socket…'
- Troubleshooting - Reverting from QuickBooks Online (back to users/public folder)
- Why am I unable to connect ACH Universal to QuickBooks Online?
- Display Name when Integrating with ACH Universal
- ACH File Setup
- Change the Location of the ACH File
- Balanced Files - Offset Records
- Pre-notes (Pre-notifications)
- Recurring Transactions
- Addenda Records (CCD+, PPD+)
- Reversals
- Transmission Methods
- How do I send my ACH file to the bank?
- How do I change the effective date on my ACH file?
- What are the 'Standard Entry Class Codes'?
-
Advanced / Reference
- Company Entry Description
- Same Day ACH Transmissions
- International Transactions (IAT)
- 'ENR' Standard Entry Class (SEC) Code
- Does the ACH file date need to be changed to accommodate holidays?
- How do I set up a '200' or '220' in the 5 records?
- Where is the processing date on my ACH file?
- Why is my bank account number not entered in the ACH File Setup?
- How do I change my banking information in ACH Universal?
- Email Notification - Internal
- File Encryption - AES 256
- Consolidation - Summary of Records
- Security (Login) Records
- General Ledger and Loan Records
- Separate Batches - Debit vs. Credit
- Health Care Reassociation
- Automation and Integration
- Transmission via SSH-SFTP
- Tax Payments (TXP)
- Corporate Trade Exchange (CTX)
- Multiple Origination Accounts and Third Party NACHA (Processor) Rules
- Bank Specific
- Returns and NOC's
- Email Notifications - Setup
- Including a Logo in Email Notifications
- How do I get the check stub detail to show in emails when doing a general import?
- Email Setup Using Gmail
- Why is Gmail not receiving or sending Treasury Software-hosted emails?
- Email Setup Using Office 365 / Cloud-Based Outlook
- Why am I receiving 'A program is trying to send an email message on your behalf' warning in Outlook?
- Email Setup Using an SMTP Server
- Including Credits in Emails
- List of Email Transaction Tags
- Why are the automatic emails not sending?
- Resending Emails
- SQL: Migrating to SQL Express, SQL Server (Permissions within SQL Server)
- SQL Server - General Troubleshooting
- SQL Server Native Client (addresses TLS 1.2 and initial connectivity issues) [Resolved]
- SQL: Unable to Connect to SQL Server - 1. Not Running in Services Panel
- SQL: Unable to Connect to SQL Server - 2. Firewall
- SQL: Unable to Connect to SQL Server - 3. Enabling TCP/IP - Named Pipes
- SQL: How to Enable SQL Server Configuration Manager
- SQL: Workstation Cannot See the Accounts/Databases
- TLS 1.2 support for Microsoft SQL Express and SQL Server
- How do I connect to SQL/SQL Express on this new workstation?
- SQL: System Requirements
- Getting Started with creating Canadian EFT files
- Software Differences - Canadian EFT vs US ACH
- CPA 005 1464-Byte Description of EFT Record Formats
- Entering an ABA/Routing Number for Canadian Banks
- IAT - International Transactions
- File Creation Number (FCN)
- Troubleshooting Canadian Date format issues
- Troubleshooting UK and Canadian Date Settings - On/Off
- Other Canadian Banks
-
Bank Specific
- RBC - Royal Bank of Canada
- TD Bank - Toronto Dominion
- ScotiaBank
- HSBC
- BMO - Bank of Montreal
- CIBC - Canadian Imperial Bank of Commerce
- CIBC - Different Origin ID Numbers for Debits / Credits
- Bank Specific > JPMorgan Chase Canada - EFT File Setup
- Nordea Bank
- Desjardins Bank
- Alberta Treasury Bank (ATB) or ATB Financial
- Van City Credit Union (Vancouver City, Canada)
- Originating payments with RBC and receiving bank is Canadian
- Security - Overview
- Security Explained
- Database Encryption
- Resetting Password
- Do you offer encryption?
- Segregation of Duties
- Cloud-based Installation
- Remote Desktop Services (and Citrix)
- ACH-2-Excel and Utilities
-
Maintenance and Troubleshooting
- How Do I Restore a Corrupt Database?
- How do I Manually Update a Service Pack?
- Disabling Windows DEP when Software does not Launch Properly
- First Time Installation? Here are the step-by-step checklists
- How do I upgrade from one version to another version of the software?
- How do I add an account (database) in Treasury Software?
- How do I add or move Treasury Software to another computer?
- How Do I Manually Update a Service Pack?
- Troubleshooting
- Reporting
- Importing an ACH File
- Entering Transactions Manually
- Deleting a Single Transaction
- Remote Desktop (Terminal Services/Citrix) Platform
- Placing Records on Hold
- Partner Program Terms
-
FAQs - ACH Universal
- Does Treasury Software work on a Mac?
- Installation Instructions
- How do I delete a profile?
- How do I add one more item to the ACH file I created?
- How Do I Re-create a File?
- How Do I License the Software?
- How do I know which License I will need in ACH Universal?
- Can I integrate with my Online Store?
- How Can I Find Treasury Software's SOX Compliance Certificate?
Getting Started - Bank Positive Pay
- Getting Started with Bank Positive Pay - Basic Steps
- Download and Install.
- Gathering Data.
- Create and Setup an Account.
- Bank Express Codes
- Import Data.
- Create and Transmit File.
- Getting Started with Excel and csv files
- Entering Transactions Manually.
- Deleting an Import.
- Deleting a Single Transaction.
- Editing Untransmitted Records.
- Filtering Imports.
- File Creation and Transmission.
- Multiple Accounts - Account number in Excel
- Multiple Accounts - No account number in Excel
- Consolidating/Merging multiple issue files
- Scheduler - Basic Automation.
- Software Integration Kit - Advanced.
- Settings - Basic, Advanced, and Automation
- SQL Insertion.
- Command Line Syntax.
- Command Line Syntax - Bank Positive Pay
- Command Line Syntax - BAI-2-Excel
- Getting Started QuickBooks Desktop
- QuickBooks Integration - Bank Positive Pay - Settings and Integration
- Positive Pay Setup with QuickBooks.
- Importing QuickBooks Transactions.
- Creating the Positive Pay File
- Transmitting the Positive Pay File
- Testing Bank Positive Pay
- Troubleshooting - QuickBooks and Bank Positive Pay.
- QuickBooks Security - Bank Positive Pay
- Getting Started QuickBooks Online
- QuickBooks Online - Positive Pay Setup
- QuickBooks Online - Importing Transactions
- QuickBooks Online - Demo / Walk-through Positive Pay
- BAI File Creator
- BAI File Creator - Advanced
- BAI File Creator - Debit/Credit Fields
- BAI-2-Excel Batch Processing
- How do I create a new Positive Pay account in Treasury Software?
- Can you walk me through how to create a Bank Positive Pay file?
- Bank Positive Pay won't connect to QuickBooks. What's wrong?
- Why am I unable to connect Bank Positive Pay to QuickBooks Online?
- How do I get a Bank Express Code for Positive Pay?
- Nordea Bank - Formatting
- How do I send my Positive Pay file to the bank?
- Do you offer encryption for Positive Pay files?
- How do I change the bank account number in my Positive Pay account?
- How do I create a BAI file?
- Northwest Bank - Requires Dynamic Naming for File Name
- Nordea Bank - Requires Dynamic Naming for File Name
Getting Started - Bank Reconciliation
- Getting started with Bank Reconciliation - Basic Steps
- Download and Install - Bank Rec
- --SQL Express (Bank Rec provided)
- --SQL Server (use your SQL Server)
- Importing Data Overview
- Import Wizard Step-by-Step
- Amount Field Options
- Deleting an Import / Records
- Matching - Getting Started
- a. One to One Matching
- b. Many to Many Matching
- c. Category Matching
- d. Manual Matching
- e. Reviewing, Unmatching, Rerunning
- Running your first Reconciliation Report
- Why is Bank Rec creating a System Generated Balancing Entry?
- Reviewing Unmatching Records
- Reports in Bank Rec
- Toolbar Buttons - Reporting
- Grouping Data
- Troubleshooting
Monthly Processes
- Weekly - Entering Deposit Log into QuickBooks
- Weekly - Making a Deposit
- Adding a Customer in QuickBooks
- Importing Bank and Credit Card Activity into QuickBooks
- Support Payments Received Online
- Copying Perpetual License Customers from Volusion to QuickBooks
- Creating Invoices from QuickBooks
- Send Customers a Manual Receipt
- Reconciling Accounts
- Reconciling Chargify1 to Stripe
- Reconciling Chargify2 to Braintree
- Record Merchant fees (gross-up) and other adjustments
- Preparing Good/Bad List
- Bi-Weekly and Monthly Taxes
- AWS Development
- Chargify 1st of Month (John)
- Chargify 1st of Month (Cindy)
- Pre-Processing
- Processing
- Post-Processing
- Reporting and Follow-up with Delinquent Receivables
Internal Only
- Home Page - Internal
- Links / Resources
- Online Platform - Issues and Discussion
- Online Platform - User tips
- Online Platform - Internal Admin tips
- Internal Phone List
- Avaya Jan 2023
- Display Account Numbers
- QuickBooks Encryption Internal
- Turning off Encryption Steps
- Canadian Banks - Formats (Internal Only)
- Right Networks and Other Hosting Providers
- SQL Troubleshooting and Tips
- Providing the Master Passcode
- Troubleshooting SQL Connectivity Aug 2024
- Current Projects
- PPC & Site Change History
- EAP
- Creating & Running Zendesk Reports
- Development Schedule
- Error Messages and How to Resolve Them
- If an SA is locked out
- Bank Rec Implementation Process
- SQL - Steps to take when troubleshooting SQL connection issues
- Bank and Processor Contacts
- Internal Licensing System
- Discounts - Banks, Resellers, Advisors, Nonprofits, and Generic
- Discount for 2 or more products
- Custom Codes
- If the phones go down
- Most recent commissions detail and emails
- Automated licensing system troubleshooting
- Training Notes for New Employee
- Demos - Outline of Items to Cover
- Vacation (PTO) Hours - Treasury Software Employees
- Emulating a cell phone in a web browser
- How to fix manually-created 'Defined Fields' in QB
- Adding Positive Pay formats to the Library Chargify
- Converting a perpetual license to a subscription license
- Cancel a subscription (and restart)- Chargify
- Sending the link + updating the customer's email in Chargify
- Creating a one-time invoice in Chargify
- Upgrading/downgrading a client's subscription in Chargify
- Recording a payment in Chargify after account has been cancelled
- Entering a coupon after the order was placed
- Adding a workstation - Chargify
- Issuing a refund in Chargify
- Creating a one-time invoice
- Purchase Orders from Resellers
- Reseller Pricing Sheet (can be provided to them)
- How to create a Proforma Invoice in Chargify for a client or Reseller
- How to Record a Payment when there is no Invoice in Chargify
- 'Upgrade/Downgrade' vs. 'Change Product'
- Remittance (One-time) Invoices
- Components
- Volusion-Legacy
- PartnerStack Procedures
- Keener/Call Center
- Zendesk Tickets
- Zendesk Guide
- Licensing System (in-house)
- GoDaddy
- Sonar-Constellix DNS
- Egnyte - Including sharing
- Calendly
- Google Analytics
- Google AdWords and PPC
- Cloudflare (and Dr. Flare)
- Active Campaign
- Heatmaps
- Aha!
- Legacy - Fogbugz
- Password for ACHMerge.com - Gigi
- DNS Made Easy
- Integrated Payables client - BEC 1180 - usaji.org (Regions Bank)
- Special Clients (Genius ERP, STCL, Michael Shooster)
- Tracking Prospective Sales and Follow-up with Newly Licensed Clients
- Calendar of Tasks to Complete
- Zendesk Format Guidelines
- Software Notes
Getting Started - ACH Universal Online
Importing From Excel and CSV Files
- Importing With Excel and CSV Files
- Creating an Excel File for Import
- Mapping Fields
- Deleting an Imported File
- Editing/Updating Records
- Date Format/Options
- Import-Options
- Getting Started with QuickBooks Online
- Connecting to QuickBooks Online
- Importing Transactions
- Email Check Stubs
- Profiles
- Transitioning from QuickBooks Desktop to QuickBooks Online
- Reviewing Unprocessed Records
- Placing Records On/Off Hold
- Creating Pre-notes
- Creating Reversals
- Creating and Saving an ACH File
- Viewing Archived/Processed Files
- ACH File Quick Setup
- Offset Records - Balanced Files
- Migrating from Desktop
- Advanced Settings Bank Specific
- Getting Started with creating Canadian EFT files
- Alberta Treasury Bank
- BMO - Bank of Montreal
- CIBC - Canadian Imperial Bank of Commerce
- Desjardins Bank
- HSBC-Canada
- JPMorgan Chase Canada
- National Bank of Canada
- Nordea Bank
- RBC Royal Bank of Canada
- Scotiabank - Canada
- TD - Toronto Dominion
- Van City Credit Union
- All Other Canadian Banks
- Email Setup
- Email Body (Templates)
- Check Stubs - Excel Transactions (Consolidation)
- Check Stubs - QuickBooks Online Transactions
- Adding Your Logo
- Sending Emails - Default
- Sending Emails - Gmail
- Sending Emails - Microsoft-Office
- Sending Emails - SMTP Server
- Resending Emails
