ACH Universal

  • Contents
  • Index
  • Search
  • ACH Universal
    • Absolute basics
    • Getting Started
      • Download and Install
      • Gathering Data
      • Create an Account
      • ACH Setup
      • Import Data
      • Create and Transmit File
      • Automate Backup
      • Getting Started FAQ
    • 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
      • WS_FTP - SSH, OpenPGP, SSL with certificates
      • Email notification - file level
      • File encryption AES
      • Consolidation/Summary of Records
      • Security / Login record
      • General Ledger and Loan Records
      • Separate Batches DR vs. CR
      • 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)
        • Getting Started - CTX
        • Account Creation
        • Account Setup - CTX
        • Mapping CTX Files - Basic
        • Mapping CTX Files - Advanced
        • CTX Output
    • 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
    • Email
      • Notifying Customers, Employees, and Vendors
      • 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
      • Accounting System Integration
        • Create a sub-account
        • Track and select payments
        • Direct Deposit ACH Reports
      • 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
      • Roles
    • Reference
      • 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
    • Utilities
      • BAI File Creator
      • ACH2Excel - ACH Conversion Utility
      • Notification of Change ABA Merge Utility
      • BAI-2-Excel Batch Processing

© 2012 Treasury Software