Importing is the process that brings data into ACH Universal. There are actually several different ways to bring in data.
Data can be classified into two categories:
•Transactions - Data represents a transaction to be imported and mapped in the ACH file.
•Profiles - Data represents a Customer, Employee or Vendor Profile, which is used in conjunction with a transaction import file to create the entries in the ACH file
Profiles alone do not contain enough information to create an ACH file as they are not associated with any specific transaction. Transactional data can include the payee information. If your accounting system uses Profiles, transactional data includes a field that identifies a specific payee by name or ID number (most common).
[NOTE: QuickBooks Online users will be required to set up Profiles in ACH Universal.]
In some situations, you may want to enter a transaction (or sometimes several transactions) manually instead of using a file import.
The file that you are importing should be in Excel, comma delimited (CSV), tab delimited, or another tabular format.
From the ACH Universal Home Page, click the 'Import Transactions' icon.
Browse to select a file, or 'copy and paste' from Excel.
Tip: Browse to select a file is much faster and efficient for large imports.
The ACH Transaction Column Mapping screen will be displayed (below).
In a typical scenario, you will need to map the following fields (in no required order):
•Amount or Amount_Reverse_Sign
In addition, you may want to add:
•ACH_Email_Address (if using the email feature)
Disbursements - use Amount_Reverse_Sign when needed
Negative amounts decrease your balance, and represent payments out to employees and vendors.
Positive amounts increase your balance, and typically represent collections from customers and other funds received.
If the Excel or other file that you are importing is displaying amounts as positive numbers--and the transactions represent payments out--then map the field as Amount_Reverse_Sign. This has the effect of multiplying the amount by a negative one.
Afterwards, click Next.
This screen will display a list of the importable rows and invalid rows. Expand the summary rows to view the detail by clicking on the “+” sign as shown below. The one invalid row is usually the source data column headers, which will not be transferred to the transmission file.
Click 'Next' to complete the Wizard.