We can certainly assist you with getting started. However, we do have some video tutorials that are embedded on the Quick Start page in the software. These videos can also be found at the following URL:
We do encourage our users to watch the videos as they will provide a great overview of how to get started.
Follow these instructions once the software has been downloaded and installed. If you have not yet installed the software, please refer to the link at the bottom of the page.
Step One: (If you are a single-user installing on your Desktop, skip this step.)
If you are sharing a database with two or more people, you will want to use a SQL Express or SQL Server database engine.
If using a SQL Express, please be sure to download the SQL Express engine (or bundle). http://treasurysoftware.com/Support/support2-Installation-SQL-Express.aspx. The SQL Express requires the "Workgroup" version when licensing.
If using a SQL Server, you will need a SQL Admin or DBA to assist during the setup. The SQL Server requires the "Enterprise" version when licensing.
Click on Settings->Migrate to SQL Express, SQL Server... and continue through the wizard.
Step Two: Create a new account to work in rather than using the Sample account [File->New Account->Create an Account... give it a name and continue through the wizard until Finished.] For most setups, you will only need to fill out the information on screen 2 of the setup.
If you are in Canada, complete the Canadian Setup by clicking on the red maple leaf icon in the toolbar. Be sure to scroll all the way down the page to review all options.
Click on 'Activate Canadian format', then click on your bank and select a 5-digit Institution ID.
If your bank is not listed, select 'All Other Banks' and continue.
Enter your company information as requested and then click OK.
It is very unusual for you to need to adjust the settings in the 'Bank and Over-ride codes' section.
Enter a short company name (up to 15 characters) as well as a long company name (up to 30 characters) as either may be displayed on the other party's bank statement.
Click 'OK' when you're all set.
Step Four: Import the data--
If you will be integrating with QuickBooks Desktop, you will click the 'Pro, Premiere, Enterprise Integration' icon in the toolbar and go through the integration wizard. Note: The first time you are integrating with QuickBooks, you must be logged in with Admin credentials and be in Single-User mode. After the integration, enter into your QuickBooks profiles and--under the 'Additional Info' tab--add the bank account information to each vendor, employee, or customer profile. Once the bank information is entered, in ACH Universal, click on the QuickBooks Integration (Pro, Premiere, Enterprise) icon.
NOTE: The "ABA Routing Number" for Canadian customers is a leading zero + the 3-digit institution number + the 5-digit branch number (total of nine digits).
If you are a QuickBooks Online user, please refer to this link: http://treasurysoftware.com/Help7ACH/quickbooks-online-edition.html
All non-QuickBooks users will be importing an Excel or CSV file with the required data. From the main screen, you will click on 'Import Transactions', select your import file, and map the headers of each column during the initial import (see below). To map the columns, simply click on the column and select the appropriate header from the dropdown. To create a basic ACH file you only need to map the 'Name', 'Amount', 'ABA Number', and 'Bank Account Number'.
Note: Disbursement amounts that are shown as positive numbers must be mapped as "Amount Reverse Sign".
Optional: ACH Universal has built-in email functionality so automatic emails can be sent to ACH recipients notifying them of the transaction details. This feature is available with the Corporate edition license. This link explains how to set up the email feature: http://treasurysoftware.com/Help7ACH/email_setup.html
Frequently Asked Questions:
Should I enter any information within the ACH File Setup Wizard (7 screens)?
No, please leave the settings at their default settings - and any entries empty.
Testing with my bank - any special settings?
Yes, please enter the following into the 'Over-ride for the File Creation Number' field (do not enter the apostrophes):
- for RBC: enter 'TEST'
- for Scotiabank: enter '0000'
First time creating a file to be sent to the bank - any special settings?
Yes, please enter the following into the 'Over-ride for the File Creation Number' field:
- for TD Bank: enter '0001'
- for BMO: enter '0001'
After you've created the files for the above scenarios, delete the entry from the 'Over-ride for the File Creation Number' field.
For additional information: http://treasurysoftware.com/Help7ACH/canada-eft-005-1464-file-format.html