There are a number of Import options available at Settings > Import, System > Import Tab.
Note: There are a number of related settings also available in the ACH File Setup window.
Some of the common features available at this tab include:
Text for 'Debit'
Text for 'Credit'
Imported amounts need decimals - GL
UK Date format
Custom Date Import
Filter Import - GL
# of columns copy & paste
# of rows copy & paste
Suppress importing $0.00 transactions
Filter by sign of amount
Advanced /rarely used features
Void Check Indicator
SQL - Timeout (in seconds)
ACH Batch Description - Show on Manual
Suppress prompt to show after file create
Import Safety Locks
Stop import if the file has same name only
Please see the embedded help in the Settings > Import, System > Import Tab for additional information.
Filter Import
By using accounts (databases), ACH Universal allows you to create a logical separation of transactions. For example, you can create a Payroll account for direct deposit transactions and an Operating account for vendor payments. Filtering becomes necessary when source files contain transactions for multiple ACH Universal accounts. By filtering the import, transactions are imported into the proper account.
By definition, a filter is only required if you have already created multiple ACH Universal accounts.
Before beginning
The steps below must be repeated for each ACH Universal account. In the example of Payroll and Operating, the steps must be done once in the Payroll account and once in the Operating account.
Creating the filter
A filter consists of nothing more than an identifier used to distinguish data for one account from other data. This can be a field containing the text "payroll" and "operating", an account number, or some other identifier. Each filter must be unique from that of all other accounts.
1. Make sure you are in the proper account.
2. From the Ribbon bar select Settings > 'Import, System' icon (legacy menu users: File >Options > General).
3. In the textbox corresponding to "Filter Import - GL", enter the identifier you wish to use for the current account.
4. Click Close.
Repeat these steps for every account you need to filter. The identifiers must be different for each account.
Using the filter
There are two ways to use the filter. You can schedule imports using the Control Panel for recurring imports or you can perform the import manually.
Using a manual import filter
Import your transaction file as outlined in 'Importing Transactions'.
Map all fields in the file as usual with one addition: map the field representing the filter text as 'Filter.' ACH Universal will import all transactions from the file into the proper account based on the filter text. If you do not map 'Filter' the entire import will be brought into the account currently opened.
NOTE: You can also click "Scheduler" to schedule the import using the Automated Scheduler.
When finished, click Close.