This format is specific to Citibank Global clients.
Unless you are a Global client (typically very large companies), do not use this format.
The vast majority of our clients do not need this format, and instead should be using the Nacha standard format.
Please remember that as this is not a Nacha format - and requires an Advanced (Processor) level license.
Getting Started - ACH Universal
- Getting Started with ACH Universal - Basic Steps
- Welcome to ACH Universal
- Download and Install
- Create an Account
- Importing Data and Creating a File
- Automate Backup
- Getting Started with Excel and csv File Imports
- Create an Excel/CSV file for Import
- Mapping Fields - Reference
- Creating and Using Profiles
- Deleting an Import
- Editing Untransmitted Records
- Import Options
- Troubleshooting Importing of Excel files
- Getting Started in QuickBooks
- Writeback - Pay Some Vendors by Check, Some by ACH
- ACH-QuickBooks Specific Options
- Pre-Notes and Split Deposits
- Email Overview - QuickBooks
- ACH Universal-Based Profiles
- CCD vs PPD (SEC Codes)
- Self-guided tour (review/testing)
- Multiple Origination Accounts - QuickBooks Integration
- Exporting QuickBooks Banking Info
-
Troubleshooting
- QuickBooks Troubleshooting - Connections
- QuickBooks Troubleshooting Setup
- QuickBooks Permissions and Security - ACH
- Revoked Certificate - QuickBooks
- Troubleshooting - Creating a Report in QuickBooks of Profile Data (P1)
- Troubleshooting - Creating a Report in QuickBooks of Bank Register Data (P2)
- Troubleshooting - Missing transactions when integrating with QuickBooks Desktop
- Troubleshooting 'XML' Error message
- How do I know if I should process ACH payments or check payments in QuickBooks?
- How do I 'hold' or 'exclude' a payment once I have it in the QuickBooks integration box?
- ACH Universal won't connect to QuickBooks. What's wrong?
- How do you set up split deposits? And can I use percentages?
- How do I upload banking information to QuickBooks profiles?
- What are the minimum access rights needed in QuickBooks for integration with ACH Universal?
- How can I prevent issued checks from transferring to ACH Universal when using QuickBooks?
-
Reference / Legacy
- QuickBooks Setup and Integration - Overview
- Connect to QuickBooks
- QuickBooks Integration Wizard
- Mapping Import Data Using Profiles-Excel
- Profiles in QuickBooks
- Creating a Sub-Account in QuickBooks for ACH Transactions
- Transmitting ACH Files to Your Bank
- After Importing Transactions: Create the File
- Settings - ACH Universal
- Holding and Resending Transactions
- Direct Deposit with QuickBooks Integration
- Pay Cards
- Write-Back Feature
- Creating ACH Files
- Setup Legacy - QuickBooks Online
- Creating an ACH File Legacy - QuickBooks Online
- ACH Setup Wizard - Basic Reference Legacy
- Getting Started with Canadian EFT's - Basic Steps Legacy
- Canadian Format - Overview and Setup Legacy
- How do I set up an Offset record (or Balanced file)? Legacy
- How do I create a Pre-note? Legacy
- How do I create a Reversal? - Legacy
- International Transactions (IAT) Legacy
- Is Treasury Software Compliant with the New NACHA Rules? Legacy
- Can you walk me through how to create an ACH file? Legacy
- How do I set up the email feature in ACH Universal? Legacy
- Is it necessary to have ID numbers assigned to Profiles? Legacy
- How do I change where the transmission file is saved? Legacy
- Why is the software saying I have invalid profiles?
- Getting Started - QuickBooks Online
- Importing Transactions
- Multiple Accounts
- Email Check Stubs
- Profiles
- Self-guided tour (review/testing)
- Transitioning from QuickBooks Desktop to QuickBooks Online
-
Troubleshooting
- QuickBooks Online - Troubleshooting
- Exporting Transactions from QuickBooks Online to Excel
- QuickBooks Online - How to Change From French to English
- Fixing 'Could not bind server socket…'
- Troubleshooting - Reverting from QuickBooks Online (back to users/public folder)
- Why am I unable to connect ACH Universal to QuickBooks Online?
- Display Name in QBO when Integrating with ACH Universal
- ACH File Setup
- Change the Location of the ACH File
- Balanced Files - Offset Records
- Pre-notes (Pre-notifications)
- Recurring Transactions
- Addenda Records (CCD+, PPD+)
- Reversals
- Transmission Methods
- How do I send my ACH file to the bank?
- How do I change the effective date on my ACH file?
- What are the 'Standard Entry Class Codes'?
-
Advanced / Reference
- Same Day ACH Transmissions
- International Transactions (IAT)
- 'ENR' Standard Entry Class (SEC) Code
- Does the ACH file date need to be changed to accommodate holidays?
- How do I set up a '200' or '220' in the 5 records?
- Where is the processing date on my ACH file?
- Why is my bank account number not entered in the ACH File Setup?
- How do I change my banking information in ACH Universal?
- Email Notification - Internal
- File Encryption - AES 256
- Consolidation - Summary of Records
- Security (Login) Records
- General Ledger and Loan Records
- Separate Batches - Debit vs. Credit
- Health Care Reassociation
- Automation and Integration
- Transmission via SSH-SFTP
- Tax Payments (TXP)
- Corporate Trade Exchange (CTX)
- Multiple Origination Accounts and Third Party NACHA (Processor) Rules
- Bank Specific
- Returns and NOC's
- Email Notifications - Setup
- Including a Logo in Email Notifications
- How do I get the check stub detail to show in emails when doing a general import?
- Email Setup Using Gmail
- Why is Gmail not receiving or sending Treasury Software-hosted emails?
- Email Setup Using Office 365 / Cloud-Based Outlook
- Why am I receiving 'A program is trying to send an email message on your behalf' warning in Outlook?
- Email Setup Using an SMTP Server
- Including Credits in Emails
- List of Email Transaction Tags
- Why are the automatic emails not sending?
- Resending Emails
- SQL: Migrating to SQL Express, SQL Server (Permissions within SQL Server)
- SQL Server - General Troubleshooting
- SQL Server Native Client (addresses TLS 1.2 and initial connectivity issues) [Resolved]
- SQL: Unable to Connect to SQL Server - 1. Not Running in Services Panel
- SQL: Unable to Connect to SQL Server - 2. Firewall
- SQL: Unable to Connect to SQL Server - 3. Enabling TCP/IP - Named Pipes
- SQL: How to Enable SQL Server Configuration Manager
- SQL: Workstation Cannot See the Accounts/Databases
- TLS 1.2 support for Microsoft SQL Express and SQL Server
- How do I connect to SQL/SQL Express on this new workstation?
- SQL: System Requirements
- Getting Started with creating Canadian EFT files
- Software Differences - Canadian EFT vs US ACH
- CPA 005 1464-Byte Description of EFT Record Formats
- Entering an ABA/Routing Number for Canadian Banks
- IAT - International Transactions
- File Creation Number (FCN)
- Troubleshooting Canadian Date format issues
- Troubleshooting UK and Canadian Date Settings - On/Off
- Other Canadian Banks
-
Bank Specific
- RBC - Royal Bank of Canada
- TD Bank - Toronto Dominion
- ScotiaBank
- HSBC
- BMO - Bank of Montreal
- CIBC - Canadian Imperial Bank of Commerce
- CIBC - Different Origin ID Numbers for Debits / Credits
- Bank Specific > JPMorgan Chase Canada - EFT File Setup
- Nordea Bank
- Desjardins Bank
- Alberta Treasury Bank (ATB) or ATB Financial
- Van City Credit Union (Vancouver City, Canada)
- Originating payments with RBC and receiving bank is Canadian
- Security - Overview
- Security Explained
- Database Encryption
- Resetting Password
- Do you offer encryption?
- Segregation of Duties
- Cloud-based Installation
- Remote Desktop Services (and Citrix)
- ACH-2-Excel and Utilities
-
Maintenance and Troubleshooting
- How Do I Restore a Corrupt Database?
- How do I Manually Update a Service Pack?
- Disabling Windows DEP when Software does not Launch Properly
- First Time Installation? Here are the step-by-step checklists
- How do I upgrade from one version to another version of the software?
- How do I add an account (database) in Treasury Software?
- How do I add or move Treasury Software to another computer?
- How Do I Manually Update a Service Pack?
- Troubleshooting
- Reporting
- Importing an ACH File
- Entering Transactions Manually
- Deleting a Single Transaction
- Remote Desktop (Terminal Services/Citrix) Platform
- Placing Records on Hold
- Partner Program Terms
-
FAQs - ACH Universal
- Does Treasury Software work on a Mac?
- Installation Instructions
- How do I delete a profile?
- How do I add one more item to the ACH file I created?
- How Do I Re-create a File?
- How Do I License the Software?
- How do I know which License I will need in ACH Universal?
- Can I integrate with my Online Store?
- How Can I Find Treasury Software's SOX Compliance Certificate?
Getting Started - Bank Positive Pay
- Getting Started with Bank Positive Pay - Basic Steps
- Download and Install.
- Gathering Data.
- Create and Setup an Account.
- Bank Express Codes
- Import Data.
- Create and Transmit File.
- Getting Started with Excel and csv files
- Entering Transactions Manually.
- Deleting an Import.
- Deleting a Single Transaction.
- Editing Untransmitted Records.
- Filtering Imports.
- File Creation and Transmission.
- Multiple Accounts - Account number in Excel
- Multiple Accounts - No account number in Excel
- Consolidating/Merging multiple issue files
- Scheduler - Basic Automation.
- Software Integration Kit - Advanced.
- Settings - Basic, Advanced, and Automation
- SQL Insertion.
- Command Line Syntax.
- Command Line Syntax - Bank Positive Pay
- Command Line Syntax - BAI-2-Excel
- Getting Started QuickBooks Desktop
- QuickBooks Integration - Bank Positive Pay - Settings and Integration
- Positive Pay Setup with QuickBooks.
- Importing QuickBooks Transactions.
- Creating the Positive Pay File
- Transmitting the Positive Pay File
- Testing Bank Positive Pay
- Troubleshooting - QuickBooks and Bank Positive Pay.
- QuickBooks Security - Bank Positive Pay
- Getting Started QuickBooks Online
- QuickBooks Online - Positive Pay Setup
- QuickBooks Online - Importing Transactions
- QuickBooks Online - Demo / Walk-through Positive Pay
- BAI File Creator
- BAI File Creator - Advanced
- BAI File Creator - Debit/Credit Fields
- BAI-2-Excel Batch Processing
- How do I create a new Positive Pay account in Treasury Software?
- Can you walk me through how to create a Bank Positive Pay file?
- Bank Positive Pay won't connect to QuickBooks. What's wrong?
- Why am I unable to connect Bank Positive Pay to QuickBooks Online?
- How do I get a Bank Express Code for Positive Pay?
- Nordea Bank - Formatting
- How do I send my Positive Pay file to the bank?
- Do you offer encryption for Positive Pay files?
- How do I change the bank account number in my Positive Pay account?
- How do I create a BAI file?
- Northwest Bank - Requires Dynamic Naming for File Name
- Nordea Bank - Requires Dynamic Naming for File Name
Getting Started - Bank Reconciliation
- Getting started with Bank Reconciliation - Basic Steps
- Download and Install - Bank Rec
- --SQL Express (Bank Rec provided)
- --SQL Server (use your SQL Server)
- Importing Data Overview
- Import Wizard Step-by-Step
- Amount Field Options
- Deleting an Import / Records
- Matching - Getting Started
- a. One to One Matching
- b. Many to Many Matching
- c. Category Matching
- d. Manual Matching
- e. Reviewing, Unmatching, Rerunning
- Running your first Reconciliation Report
- Why is Bank Rec creating a System Generated Balancing Entry?
- Reviewing Unmatching Records
- Reports in Bank Rec
- Toolbar Buttons - Reporting
- Grouping Data
- Troubleshooting
Monthly Accounting
- Weekly - Entering Deposit Log into QuickBooks
- Weekly - Making a Deposit
- Adding a Customer in QuickBooks
- Importing Bank and Credit Card Activity into QuickBooks
- Support Payments Received Online
- Copying Perpetual License Customers from Volusion to QuickBooks
- Creating Invoices from QuickBooks
- Send Customers a Manual Receipt
- Reconciling Accounts
- Reconciling Chargify1 to Stripe
- Reconciling Chargify2 to Braintree
- Record Merchant fees (gross-up) and other adjustments
- Preparing Good/Bad List
- Bi-Weekly and Monthly Taxes
- Chargify 1st of Month (John)
- Chargify 1st of Month (Cindy)
- Pre-Processing
- Processing
- Post-Processing
- Reporting and Follow-up with Delinquent Receivables
Internal Only
- Internal Phone List
- Avaya Jan 2023
- Display Account Numbers
- QuickBooks Encryption Internal
- Turning off Encryption Steps
- Canadian Banks - Formats (Internal Only)
- Right Networks and Other Hosting Providers
- SQL Troubleshooting and Tips
- Providing the Master Passcode
- Troubleshooting SQL Connectivity Aug 2024
- Current Projects
- PPC & Site Change History
- EAP
- Creating & Running Zendesk Reports
- Development Schedule
- Error Messages and How to Resolve Them
- If an SA is locked out
- Bank Rec Implementation Process
- SQL - Steps to take when troubleshooting SQL connection issues
- Bank and Processor Contacts
- Internal Licensing System
- Discounts - Banks, Resellers, Advisors, Nonprofits, and Generic
- Discount for 2 or more products
- Custom Codes
- If the phones go down
- Most recent commissions detail and emails
- Automated licensing system troubleshooting
- Training Notes for New Employee
- Demos - Outline of Items to Cover
- Vacation (PTO) Hours - Treasury Software Employees
- Emulating a cell phone in a web browser
- How to fix manually-created 'Defined Fields' in QB
- Adding Positive Pay formats to the Library Chargify
- Converting a perpetual license to a subscription license
- Cancel a subscription (and restart)- Chargify
- Sending the link + updating the customer's email in Chargify
- Creating a one-time invoice in Chargify
- Upgrading/downgrading a client's subscription in Chargify
- Recording a payment in Chargify after account has been cancelled
- Entering a coupon after the order was placed
- Adding a workstation - Chargify
- Issuing a refund in Chargify
- Creating a one-time invoice
- Purchase Orders from Resellers
- Reseller Pricing Sheet (can be provided to them)
- How to create a Proforma Invoice in Chargify for a client or Reseller
- How to Record a Payment when there is no Invoice in Chargify
- 'Upgrade/Downgrade' vs. 'Change Product'
- Remittance (One-time) Invoices
- Components
- Volusion-Legacy
- PartnerStack Procedures
- Keener/Call Center
- Zendesk Tickets
- Zendesk Guide
- Licensing System (in-house)
- GoDaddy
- Sonar-Constellix DNS
- Egnyte - Including sharing
- Calendly
- Google Analytics
- Google AdWords and PPC
- Cloudflare (and Dr. Flare)
- Active Campaign
- Heatmaps
- Aha!
- Legacy - Fogbugz
- Password for ACHMerge.com - Gigi
- DNS Made Easy
- Integrated Payables client - BEC 1180 - usaji.org (Regions Bank)
- Special Clients (Genius ERP, STCL, Michael Shooster)
- Tracking Prospective Sales and Follow-up with Newly Licensed Clients
- Calendar of Tasks to Complete
- Zendesk Format Guidelines
- Software Notes
