ACH Universal
Opera Bug
Contents
|
Index
ACH Universal
Absolute basics
Getting Started
Download and Install
Gathering Data
Create an Account
ACH Setup
Import Data
Create and Transmit File
Getting Started FAQ
Automate Backup
Importing Transactions
Importing Transactions
Entering Transactions Manually
Deleting An Import
Deleting A Single Transaction
Editing Untransmitted Records
Filtering Imports
Mapping Fields - Reference
Profiles
Creating Profiles
Using Profiles
IAT - International Transactions
File Creation and Transmission
Balanced Files - Offsetting Records
Prenotification
Recurring Transactions
Addenda Records (CCD+, PPD+)
Reversals
Transmission Methods
Email notification - file level
File encryption AES
Consolidation/Summary of Records
Security / Login record
General Ledger and Loan Records
Separate Batches DR vs. CR
SSH - SFTP
Create SSH Keys
SSH Setup
Tax Payments (TXP)
Overview
Formatting the Addenda Record
Additional tags/fields
TXP10 example (Fed 941)
6 record substitution
Child Support ACH Addenda
Multiple Tax Payers
Legacy tax payments
Creating an Agency Profile
Creating a Tax Form
Importing TXP transactions
Completing the Agency Profile
Make a tax payment
Fiduciary Mode
Importing and mapping data
Creating and reviewing the file
Returns
Working with ACH Return Files
CTX - EDI (Processor edition)
Account Creation
Account Setup - CTX
Mapping - Basic
Mapping - Advanced
Mapping - Without Profiles
CTX Output
XML
XML Setup
XML Importing Files
Reporting
General Usage
Grouping Data
Filtering Data
Exporting Data
Advanced Topics
Remote Desktop (Terminal Services / Citrix) Platform
Multiple Origination Accounts
Create - Multiple Accts
Importing - Multiple Origination Accts
Setup - Multiple Accts
Copy Settings From Existing Account
Authentication File
No Write Permissions to Users-Public
Placing records on hold
Sending directly to the Fed (FRB)
Email
Email Setup
List of Transaction Tags
Remote Desktop Services (RDS)
RDS - Maintenance
RDS - Directory Location
RDS - Clustered Servers
Automation and Integration
Scheduler - Basic Automation
Software Integration Kit - Advanced
Settings
SIK Testing
SQL Insertion
Global batch processes - across many accounts
Command Line Syntax
Command Line Interface
ACH Universal
ACH-2-Excel
BAI-2-Excel
Software Integration Kit
Bank Positive Pay
Profile Importing
For use with QuickBooks
Setup - QuickBooks based profiles
Connect to QuickBooks
Integration Wizard
ACH Setup
Creating ACH Files
Transmitting ACH files to your bank
Holding and resending transactions
Settings - ACH Universal
Troubleshooting-Connections
Email - QuickBooks
Email Overview - QuickBooks
ACH Universal based profiles
Setup - QuickBooks
Advanced setup
Importing Transactions Alt
Holding and over-riding records
Profiles
Adding
Editing
Direct Deposit
Security
Setup
Users-Add
Segregation of duties
Permissions
Roles
Reference
Legacy - WS_FTP OpenPGP, SSL with certificates
ACH File Structure and Setup
File ID Modifier
Glossary
Standard Entry Class Codes (SEC Codes)
List of Standard Entry Class Codes
ARC - Accounts Receivable Entry
BOC - Back Office Conversion
CCD/CCD+ - Cash Concentration or Disbursement
CIE - Customer Initiated Entry
CTX - Corporate Trade Exchange
IAT - International
POP - Point of Purchase Entry
PPD/PPD+ - Prearranged Payment and Deposit Entry
RCK - Represented Check Entry
TEL - Telephone Initiated Entry
TXP - Tax Payments
WEB - Internet Initiated Entry
Frequently Asked Questions (FAQ)
Changing Default Standard Entry Class Code
Changing Profile Lookup Field
Changing Debit and Credit Text
Changing File Transmission Method
I want to pay my vendors. What will they see on their bank statements?
I am collecting from customers. How do I know the funds went into my account?
I am on the Desktop platform with 1 workstation license. If I purchase an additional workstation, can I share data?
What is an account?
I purchased ACH Universal, but the Main Screen says Positive Pay
I have one source file but multiple databases. How do I split the file into the correct database?
I have a non-standard date format. How do I use it?
My date field is embedded within text. How do I import it?
My bank requires a login record
ActiveX component can't create object
ADO/MDAC Re-Installing
Mapping Fields
Direct payments from tenant to landlord
Maintenance - Desktop
Database Backup
Restore Database
Database Archiving
Download Service Pack
Desktop Platform Upgrade
Legacy Help
ACH 101
Pay Employees (Direct Deposit)
Pay Vendors
Collect From Customers
Accounts
Creating An Account
Account Creation
General Messages
NTFS
Text_Import
Out_of_balance
Consolidate Positive Pay files
Installation Troubleshooting
Banking Features
Returns
Returns - Manually adding records
Returns - Importing records
Returns - Creating files
Notification of Change
Notification of Change - Manually adding records
Notification of Change - Importing records
Notification of Change - Creating files
ACH Universal - Legacy Help
Getting Started - Gathering Your Data
ACH - Setting up a new account
ACH column mapping descriptions
Balanced File Creation
Transferring funds between your accounts
Customer, Employee and Vendor Accounts (Profiles)
FAQ's - Importing
We have non-standard date formats. How do we import this?
Our date field is embedded within text. How do we accommodate this?
All of the amounts in the file are positive. What do I do?
How do I use the 'Sign' field?
How do I use the 'Amount_Reverse_Sign' field?
How do I delete the entire import (I accidentally imported an incorrect file)?
How do I copy and paste from Excel?
What are the International capabilities? Can the system handle Euros and British Pounds?
I can prepare the data in either Excel or text. Which is easier to work with?
How do I know what text format my file is in?
How do I create a new Mapping Template?
How do I set the default import directory?
How do we filter by Account Number?
FAQ's - Records: Adding, Deleting & Unmatching
How do I add a record without re-importing?
Where can I see the manually added and rounding records?
How do I delete a record?
How do I modify/edit an existing record?
How do I save my work?
FAQ's - Transmission to Bank
How do I upload the transmission file?
How do I FTP the transmission file?
How do I know the file was successfully transmitted?
How do I re-transmit a file?
How do I transmit through a firewall?
How do I automate the process?
How do I send a summary notification by email?
PGP - Troubleshooting
E-mail configurations - How do I enter the settings?
FAQ's - Scheduler/Control Panel
What can I automate?
Does the computer need to be on? Can I be in the program?
How do I know if the scheduler ran?
Troubleshooting help
Scheduler Overview
Control Panel Overview
FAQ's - Installation
Can I install on an NT or Windows 2000 formatted with NTFS (not FAT)?
I’d like to upgrade. Do I need to uninstall, then re-install?
How do I create a new bank account?
How do I delete a bank account?
How do I reset my Sample account?
How do I change the accounting periods?
How do I unzip a file?
Installation Troubleshooting
Installing the SQL Server Version
Upgrading to a New SQL Version
MSDE Installation
Corrupt Database - Desktop
Moving to a new Workstation
Upgrading
Transfers
SQL Lockout
U.S. Bank Secure Payment
Utilities
BAI File Creator
ACH2Excel - ACH Conversion Utility
Notification of Change ABA Merge Utility
BAI-2-Excel Batch Processing