Not sure where to even start?
Then this is the place for you.
You can create a test ACH/Nacha file for your bank in 5 easy steps:
1. Create a new account in ACH Universal (File > New > Create)
On the main menu, click on File, then New Account, then leave the option button for 'Create'. Click Next.
Note: If you are working on a multi-user platform, our Workgroup (SQL Express) or Enterprise (SQL Server) - see SQL.
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 'flip' into the new account.
Congratulations. We'll be working in this account going forward.
2. ACH File Setup
If you are simply performing in-house testing (such as IT testing), you can skip this step, as you can create ACH files without entering this information. Go to step 3.
Testing with your bank?
If you will be testing with your bank, you will need to perform this step prior to creating the files that you send to them.
If you already signed up with your bank for ACH service, this information will be in your Welcome packet.
If you have been creating ACH files, but do not have the original documentation form your bank, ACH Universal can pull this information off of a file that you have already created.
If you have neither documents above, follow our guidelines within the wizard below. Of course, we can't guarantee compliance with your bank, but it is a very conservative approach to start.
Most (basic) users can click 'Finish' to complete.
However, if any of the following apply to you, you will want to enter into the 'Advanced setup':
--Need to specify different batch (5 record) information
--Use an SEC code other than PPD (such as CCD)
--Create an offsetting record (i.e., balanced file)
or any other advanced feature.
3. Start the QuickBooks Integration Wizard
Before you continue, confirm that:
--ACH Universal and QuickBooks are both running on the same computer, and
--With QuickBooks open, you are logged in as the administrator for the QuickBooks company you want to work with and you are in single-user mode. The Admin login is only required for the initial integration.
1. Click on the QuickBooks Integration Window.
2. Click on the flashing QuickBooks icon in your task bar.
The first time ACH Universal attempts to connect to your QuickBooks company, you will be prompted by QuickBooks to grant access.
Select the third option 'Yes, whenever this QuickBooks company file is open' and then click Continue.
Note: You can leave the bottom check box unchecked.
Success. You've now connected ACH Universal to your QuickBooks company (qbw) file. Click 'Done'.
Once you have connected to your QuickBooks company (above), you can complete the Integration Wizard that will pop up automatically. Click Next.
View the list of your QuickBooks accounts - select your bank account.
Have more than one origination account? You will want to create a new Account in the software for each bank account sending ACH files. (See also 'Multiple Origination', covered separately, if working with numerous bank accounts.)
This next step (default) will create three custom fields in your QuickBooks Customer, Employee and Vendor profiles.
The checkboxes for Customer, Employee and Vendor profiles should all be checked.
If any are unchecked, and it is one you need, stop here and close the Wizard. You may need to remove some existing custom fields for that profile group.
Note: If you opt to keep your profiles and bank information within ACH Universal--instead of the QuickBooks profiles--select the bottom radio button and instead follow the alternative instructions.
You must be in single-user mode and logged in as an Admin.
If you need to make the changes in QuickBooks, close ACH Universal first -then make your changes in QuickBooks.
Congratulations, you've created the custom fields. Click Finish.
ACH Universal will now display the available transactions.
However, no transactions will be displayed as we haven't entered any banking information on the customers, employees or vendor profiles.
Ok to close the Wizard.
4. Enter banking information to a test vendor
In QuickBooks, select a customer, employee or vendor that you have banking information for.
In this example below, we'll enter banking information for the vendor 'Bayshore Water'.
Enter their banking information.
Tip: The system defaults to CHK Checking and the SEC code you specified in ACH Setup.
For the CHK/SAV field you can enter CHK for checking accounts or SAV for savings accounts. Additional options include (separated by commas) PPD and CCD.
5. Create a test file
Click on the QuickBooks Integration Window icon to open it and click on 'View Transactions and select a date range that has transactions in your bank account and click 'View'.
You should now see the transactions from the profile you entered banking formation for. (Normally you will want to narrow down the date range to the date of the transactions in QuickBooks.)
Click on the 'Send transactions to ACH Universal' at the bottom to create your ACH/Nacha file.
It will be created locally on your computer.
It will NOT be sent to your bank - the ACH file is saved in the software. You will upload it through their web portal.
Click on Yes to view the file.
This is an example of an ACH/Nacha file.
You can upload this file to your bank if you've completed all of the steps above.
Note: If you skipped the ACH setup, you'll see 'OPEN ITEM' within the file - do not send it to the bank.
Upload the file to your bank. By default the file will be located in the folder:
C:\Users\Public\Treasury Software\To Bank
Need help or want to schedule a call to get setup?
Intuit and QuickBooks are registered trademarks of Intuit Inc. Used with permission.