Getting Started - ACH Universal

• Getting Started with ACH Universal - Basic Steps
• Welcome to ACH Universal
• Download and Install
• Gathering Data
• Create an Account
• ACH File Setup
• Change the Location of the ACH File
• Import Data using Excel or CSV files
• Create and Transmit File
• Automate Backup

Importing Transactions

• Importing Transactions from Excel or CSV
• Entering Transactions Manually
• Deleting a Single Transaction
• Deleting an Import
• Editing Untransmitted Records
• Filtering Imports
• Mapping Fields - Reference
• Profiles
  • Creating and Using Profiles
  • Mapping Import Data Using Profiles
• International Transactions (IAT)

File Creation and Transmission

• 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
  • Creating SSH Keys
  • SSH Setup
• Tax Payments (TXP)
  • TXP Formatting the Addenda Record
  • TXP Tags and Fields
  • TXP 10 Example Federal Form 941
  • TXP - 6 Record Substitution
  • TXP Child Support ACH Addenda
  • Legacy TXP (no longer supported) - Multiple Taxpayers
• Corporate Trade Exchange (CTX)
  • CTX Account Creation
  • CTX Setting up a Payee Profile
  • CTX Mapping Basic
  • CTX Mapping Advanced
  • CTX Mapping Without Profiles
  • CTX Output
• Health Care Reassociation

Reporting

• Reports
• Reports - Grouping
• Reports - Filtering
• Reports - Exporting

Automation and Integration

• Automation and Integration - Overview
• Software Integration Kit (SIK) - Advanced
  • SIK Testing
  • Activity Receipt Reporting - Turn On/Off
  • SQL Insertion - ACH
• SIK - Command Line Syntax
  • Command Line Interface
  • Command Line Syntax ACH Universal
  • Command Line Syntax ACH 2 Excel
  • Command Line Syntax Profile Importing
• Global Batch Processes Across Many Accounts

Email

• Email Notifications - Setup
• Including a Logo in Email Notifications
• Email Setup Using Gmail
• Email Setup Using Office 365 / Cloud-Based Outlook
• Including Credits in Emails
• List of Email Transaction Tags

Remote Desktop Services (and Citrix)

• Remote Desktop Services (RDS) - Overview
  • RDS Maintenance
  • RDS Directory Location
  • RDS Clustered Servers

QuickBooks

• QuickBooks Pro, Premiere, and Enterprise - Setup and Integration
  • QuickBooks Setup and Integration - Overview
  • Connect to QuickBooks
  • QuickBooks Integration Wizard
  • ACH Setup Wizard - Using QuickBooks
  • QuickBooks Troubleshooting Setup
• Profiles in QuickBooks
• Write-Back Feature
• Creating a Report in QB of Bank Register Data
• Multiple Origination Accounts - QuickBooks Integration
• 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 Security - ACH
• Direct Deposit with QuickBooks Integration
• Pay Cards
• Email Overview - QuickBooks
• Testing with QuickBooks
• Creating a Report in QB of Bank Register Data
• QuickBooks - Advanced Setup
• Troubleshooting 'XML' Error message
• Multiple Origination Accounts - QuickBooks Integration

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 - Profiles
• QuickBooks Online - Demo / Walk-through Sample
• QuickBooks Online - How to Change From French to English
• QuickBooks Online - Troubleshooting
• Error Integrating with QBO: 'Could not bind server socket'

Security and Encryption

• Security - Overview
• Users and Access Control
  • Segregation of Duties - Setup
• Segregation of Duties - Users
• Segregation of Duties - Roles
• Segregation of Duties - Permissions
• Database Encryption

Utilities

• ACH-2-Excel
• ACH Edit
• ACH Merge

Canadian Format (EFTs) - ACH Universal

• 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
• Other Canadian Banks
• File Creation Number (FCN)
• Troubleshooting Canadian Date format issues
• UK and Canadian Date Settings - On/Off

Advanced Topics

• 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
  • Multiple Origination Accounts and Third Party NACHA (Processor) Rules - Overview
  • Multiple Origination On the Fly based
  • Multiple Origination Profile based
  • Setup and Importing Multiple Origination Accounts
• 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 - Working with Return Files - Overview
• Returns - Processing from an ACH File
• Notification of Change - (NOC)
• SQL: System Requirements
• SQL: Migrating to SQL Express, SQL Server (Permissions within SQL Server)
• SQL Server - General Troubleshooting
• 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
• CTX - Corporate Trade Exchange

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 QB integration box?
• Why is Gmail not receiving or sending Treasury Software-hosted emails?
• 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 create a Return file?
• 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?
• Troubleshooting Importing of Excel files
• 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?
• 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 can I prevent issued checks from transferring to ACH Universal when using QuickBooks?

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.

Importing Transactions

• Mapping Fields - Reference.
• Entering Transactions Manually.
• Deleting an Import.
• Deleting a Single Transaction.
• Editing Untransmitted Records.
• Filtering Imports.

File Creation and Transmission

• File Creation and Transmission.
• Multiple Accounts - Account number in Excel
• Multiple Accounts - No account number in Excel
• Consolidating/Merging multiple issue files

Reporting

• Reports.
• Grouping Data.
• Filtering Data.
• Exporting Data.

Automation and Integration

• 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

QuickBooks

• QB Integration - Bank Positive Pay - Settings and Integration
• Positive Pay Setup with QuickBooks.
• Importing QB 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

QuickBooks Online

• QuickBooks Online - Positive Pay Setup
• QuickBooks Online - Importing Transactions
• QuickBooks Online - Demo / Walk-through Positive Pay

Security

• Security - Overview and Setup.
• Setting Up Users and Roles.
• Segregation of Duties.

Utilities

• BAI File Creator
• BAI File Creator - Advanced
• BAI File Creator - Debit/Credit Fields
• BAI-2-Excel Batch Processing

FAQs

• 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?
• How do I connect to SQL Express/SQL Server?
• 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?

Getting Started - Bank Reconciliation

• Getting started with Bank Reconciliation - Basic Steps
• Download and Install - Bank Rec
• Create Accounts
• Import General Ledger Data
• Import Bank Data
• Run Automated Transaction Matching

Imports

• Entering Data Manually
• Deleting a Record
• Deleting an Import
• Importing/Editing in a Reconciled Period

Mapping Your Data

• Deciding What to Map
• Selecting Fields to Represent Amount
• Mapping Bank Data - Bank Rec
• Mapping General Ledger Data - Bank Rec

Matching in Bank Rec

• Site and Type Rules
• Matching and Types of Matches in Bank Rec
• Performing System Matching
• Performing Manual Matching
• Unmatching Records

Reports

• Reports in Bank Rec
• Toolbar Buttons - Reporting
• Grouping Data
• Running your first Reconciliation Report
• Periods - Bank Rec
• Troubleshooting

FAQs

• How do I get more accounts for Bank Rec?
• How do I create a new Bank Reconciliation Account in Treasury Software?
• How do I set up Bank Rec on SQL Express/SQL Server?

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

Monthly Credit Card Processing

• Chargify 1st of Month (John)
• Chargify 1st of Month (Cindy)
• Pre-Processing
• Processing
• Post-Processing
• Reporting and Follow-up with Delinquent Receivables

Quarterly Accounting

• Quarterly Taxes

Yearly Accounting

• Year-End Taxes
• Year-End W-2s
• Year-End 1099s

Internal Only

• Internal Phone List
• Canadian Banks - Formats (Internal Only)
• Right Networks and Other Hosting Providers
• SQL Troubleshooting and Tips
• 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
• 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
• Entering a coupon after the order was placed
• Adding a workstation - Chargify
• Issuing a refund in Chargify
• Creating a one-time invoice
Third Party Systems & Services
• 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
• Active Campaign
• Heatmaps
• Aha!
• Legacy - Fogbugz
• Password for ACHMerge.com - Gigi
• DNS Made Easy
Special Clients
• Integrated Payables client - BEC 1180 - usaji.org (Regions Bank)
• Software Notes
  • QB Online Clients
  • Creating an Employee Report in QB that Shows the Banking Information
  • Office 365 email setup
  • Setting up Multiple Origination accounts in Bank Positive Pay
  • Sending ACH file to the Federal Reserve