Please visit the page at https://help.treasurysoftware.com/hc/en-us/articles/7410063065111
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
- Entering Transactions Manually
- Deleting a Single Transaction
- Deleting an Import
- Editing Untransmitted Records
- Filtering Imports
- Mapping Fields - Reference
- Importing an ACH File
- Profiles
- International Transactions (IAT)
- QuickBooks Pro, Premier, and Enterprise - Setup and Integration
- Getting Started in QuickBooks
- Profiles in QuickBooks
- Write-Back Feature
- ACH Universal-Based Profiles
- QuickBooks Troubleshooting - Connections
- Creating a Sub-Account in QuickBooks for ACH Transactions
- Creating ACH Files
- Transmitting ACH Files to Your Bank
- Settings - ACH Universal
- Paying Some Vendors by Check, Some by ACH
- Holding and Resending Transactions
- International Transactions (IAT)
- QuickBooks Permissions and Security - ACH
- Direct Deposit with QuickBooks Integration
- Pay Cards
- Email Overview - QuickBooks
- Testing with QuickBooks
- QuickBooks - Advanced Setup
- Troubleshooting 'XML' Error message
- Multiple Origination Accounts - QuickBooks Integration
- 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
- Getting Started in QuickBooks Online
- QuickBooks Online - Setup
- QuickBooks Online - Importing Transactions
- QuickBooks Online - Creating an ACH File
- QuickBooks Online - Setting Up Multiple Accounts
- QuickBooks Online - Fixing 'Could not bind server socket…'
- QuickBooks Online - Email Check Stubs
- QuickBooks Online - Profiles
- QuickBooks Online - Demo / Walk-through Sample
- Transitioning from QuickBooks Desktop to QuickBooks Online
- QuickBooks Online - How to Change From French to English
- QuickBooks Online - Troubleshooting
- Error Integrating with QuickBooks Online: 'Could not bind server socket'
- Troubleshooting - Reverting from QuickBooks Online (back to users/public folder)
- ACH File Setup
- Change the Location of the ACH File
- After Importing Transactions: Create the File
- Balanced Files - Offset Records
- Pre-notes (Pre-notifications)
- Recurring Transactions
- Addenda Records (CCD+, PPD+)
- Reversals
- Transmission Methods
- Email Notification - Internal
- File Encryption - AES 256
- Consolidation - Summary of Records
- Security (Login) Records
- General Ledger and Loan Records
- Separate Batches - Debit vs. Credit
- Transmission via SSH-SFTP
- Tax Payments (TXP)
- Corporate Trade Exchange (CTX)
- Health Care Reassociation
- Email Notifications - Setup
- Including a Logo in Email Notifications
- Email Setup Using Gmail
- Why is Gmail not receiving or sending Treasury Software-hosted emails?
- Email Setup Using Office 365 / Cloud-Based Outlook
- Email Setup Using an SMTP Server
- Including Credits in Emails
- List of Email Transaction Tags
- Why are the automatic emails not sending?
- 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
- SQL: System Requirements
- Getting Started with creating Canadian EFT files
- Getting Started with Canadian EFT's - Basic Steps
- Creating CPA-005 1464-byte files for EFTs
- Canadian Format - Overview and Setup
- CPA 005 1464-Byte Description of EFT Record Formats
- Originating payments with RBC and receiving bank is Canadian
- Entering an ABA/Routing Number for Canadian Banks
- IAT - International Transactions
- 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
- Alberta Treasury Bank (ATB) or ATB Financial
- Van City Credit Union (Vancouver City, Canada)
- Other Canadian Banks
- File Creation Number (FCN)
- Troubleshooting Canadian Date format issues
- UK and Canadian Date Settings - On/Off
- Security - Overview
- Users and Access Control
- Segregation of Duties - Users
- Segregation of Duties - Roles
- Segregation of Duties - Permissions
- Database Encryption
- Automation and Integration
- Remote Desktop Services (and Citrix)
- ACH-2-Excel and Utilities
- Change the Working Directory to \Users\Public\ (version 2020 and later)
- Remote Desktop (Terminal Services/Citrix) Platform
- Citibank - Setting up Global Format (Bank Specific, Not NACHA)
- JPMorgan Chase - ACH File Setup (Bank Specific)
- Nordea Bank - ACH Dynamic Naming (Bank Specific)
- Licensing Error: 'The system is unable to connect'
- Multiple Origination Accounts and Third Party NACHA (Processor) Rules
- Copying Settings from an Existing Account
- Creating an Authentication File
- No-Write Permissions to Users-Public
- Placing Records on Hold
- Federal Reserve Bank (FRB) Transmissions
- Same Day ACH Transmissions
- Returns - Receiving and Working with ACH Return Files from your Bank
- Returns - Creating an ACH Return File
- Notification of Change - (NOC)
- CTX - Corporate Trade Exchange
- Multiple Origination with CTX Format
-
FAQs - ACH Universal
- Troubleshooting Importing of Excel files
- Entering an Authentication Code
- Does Treasury Software work on a Mac?
- Installation Instructions
- How do I upgrade my ACH Universal?
- Is Treasury Software Compliant with the New NACHA Rules?
- Does the ACH file date need to be changed to accommodate holidays?
- How do I create a new ACH Account in Treasury Software?
- Can you walk me through how to create an ACH file?
- 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?
- How do I get the check stub detail to show in emails when doing a general import?
- ACH Universal won't connect to QuickBooks. What's wrong?
- Why am I unable to connect ACH Universal to QuickBooks Online?
- How do I set up a '200' or '220' in the 5 records?
- How do you set up split deposits? And can I use percentages?
- How do I upload banking information to QuickBooks profiles?
- How do I set up an Offset record (or Balanced file)?
- Why is the software saying I have invalid profiles?
- How do I connect to SQL/SQL Express on this new workstation?
- What are Wells Fargo's Key Exchange Algorithms?
- Is it necessary to have ID numbers assigned to Profiles?
- Why am I receiving 'A program is trying to send an email message on your behalf' warning in Outlook?
- Where is the processing date on my ACH file?
- How do I delete a profile?
- How do I add one more item to the ACH file I created?
- How do I create a Pre-note?
- How do I set up the email feature in ACH Universal?
- Why are the automatic emails not sending?
- Do you offer encryption?
- Why is my bank account number not entered in the ACH File Setup?
- How do I create a Reversal?
- How do I change my banking information in ACH Universal?
- How do I send my ACH file to the bank?
- How do I change the effective date on my ACH file?
- How do I change where the transmission file is saved?
- How Do I Restore a Corrupt Database?
- How do I Manually Update a Service Pack?
- How Do I Re-create a File?
- How Do I License the Software?
- Can I Put the Database (.BRD) File on a Network Drive so Multiple Users Can Access and Share the Data?
- How do I know which License I will need in ACH Universal?
- What are the 'Standard Entry Class Codes'?
- Can I integrate with my Online Store?
- How Can I Find Treasury Software's SOX Compliance Certificate?
- How do I register a DLL (Vista, Windows 7, or Windows 8)?
- What are the minimum access rights needed in QuickBooks for integration with ACH Universal?
- What are Wells Fargo's Key Exchange Algorithms?
- Is it necessary to have ID numbers assigned to Profiles?
- Why am I receiving 'A program is trying to send an email message on your behalf' warning in Outlook?
- Where is the processing date on my ACH file?
- How do I delete a profile?
- How do I add one more item to the ACH file I created?
- How do I create a Pre-note?
- Do you offer encryption?
- Why is my bank account number not entered in the ACH File Setup?
- How do I create a Reversal?
- How do I change my banking information in ACH Universal?
- How do I send my ACH file to the bank?
- How do I change the effective date on my ACH file?
- How do I change where the transmission file is saved?
- How can I prevent issued checks from transferring to ACH Universal when using QuickBooks?
- Disabling Windows DEP when Software does not Launch Properly
- 'ENR' Standard Entry Class (SEC) Code
- 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?
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 Volusion to Wells Fargo
- 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
- Canadian Banks - Formats (Internal Only)
- Right Networks and Other Hosting Providers
- SQL Troubleshooting and Tips
- 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
- Development Schedule
- Training Notes for New Employee
- Demos - Outline of Items to Cover
- Vacation (PTO) Hours - Treasury Software Employees
- Avaya - Changing Voice Mail Greeting
- Avaya - Listening to voicemail remotely
- Avaya - How to forward calls to your cell phone
- Internal Reconciliations
- Emulating a cell phone in a web browser
- How to fix manually-created 'Defined Fields' in QB 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
- 1. Purchase Orders from Resellers
- 2. Reseller Pricing Sheet (can be provided to them)
- 3. How to create a Proforma Invoice in Chargify for a client or Reseller
- 4. How to Record a Payment when there is no Invoice in Chargify
- Volusion
- 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
