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

Importing From Excel and CSV files

• 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

QuickBooks Pro, Premier, Enterprise

• 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?

QuickBooks Online

• 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 Types and Setup

• 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
    • Automation and Integration - Overview
    • Software Integration Kit (SIK) - Advanced
      • Automation (SIK) Introduction
      • SIK Testing
      • Create Task in Windows Task Scheduler
      • Activity Receipt Reporting - Turn On/Off
      • SQL Insertion - ACH
    • Command Line Syntax (Deprecated)
      • Command Line Interface
      • Command Line Syntax ACH Universal
      • Command Line Syntax ACH 2 Excel
      • Command Line Syntax Profile Importing
  • Transmission via SSH-SFTP
    • Creating SSH Keys
    • SSH Setup
    • What are Wells Fargo's Key Exchange Algorithms?
  • Tax Payments (TXP)
    • TXP-Payments Overview
    • TXP Formatting the Addenda Record
    • TXP Tags and Fields
    • TXP 10 Example Federal Form 941
    • TXP - 6 Record Substitution
    • TXP Child Support ACH Addenda
  • Corporate Trade Exchange (CTX)
    • CTX - Corporate Trade Exchange
    • CTX Account Creation
    • CTX Setting up a Payee Profile
    • CTX Mapping Basic
    • CTX Mapping Advanced
    • CTX Mapping Without Profiles
    • CTX Output
    • Multiple Origination with CTX Format
  • 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
  • Bank Specific
    • JPMorgan Chase - ACH File Setup (Bank Specific)
    • Federal Reserve Bank (FRB) Transmissions
    • Citibank - Setting up Global Format (Bank Specific, Not NACHA)
    • Nordea Bank - ACH Dynamic Naming (Bank Specific)
  • Returns and NOC's
    • Returns - Receiving and Working with ACH Return Files from your Bank
    • Returns - Creating an ACH Return File
    • Notification of Change - (NOC)

Email

• 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 Express & SQL Server

• 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

Canadian Format (EFTs)

• 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 and Encryption

• Security - Overview
• Security Explained
• Database Encryption
• Resetting Password
• Do you offer encryption?
• Segregation of Duties
  • Segregation of Duties - Setup
  • Segregation of Duties - Users
  • Segregation of Duties - Roles
  • Segregation of Duties - Permissions

Advanced Topics / Reference

• Cloud-based Installation
  • Cloud-based Installation
  • Creating an AWS Account
  • Creating an AWS Virtual Machine
  • Installation on AWS (simple)
  • Accessing AWS (web-based simple)
  • Accessing AWS via RDP App
  • Concurrent AWS User Setup (advanced)
  • Backup + Troubleshooting
• Remote Desktop Services (and Citrix)
  • Remote Desktop Services (RDS) - Overview
    • RDS Maintenance
    • RDS Directory Location
    • RDS Clustered Servers
• ACH-2-Excel and Utilities
  • ACH-2-Excel
  • ACH Edit
  • ACH Merge
• 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
    • How do I register a DLL (Vista, Windows 7, or Windows 8)?
    • Licensing Error: 'The system is unable to connect'
    • No-Write Permissions to Users-Public
    • Entering an Authentication Code
• Reporting
  • Reports
  • Reports - Grouping
  • Reports - Filtering
  • Reports - Exporting
• 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?

Installation and Moving Center

• Installation and Moving Center

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

• 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

• 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

• 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

QuickBooks Online

• Getting Started 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?
• 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)

1. Create an Account

• Create a New Account (File > New)

2. Confirm Periods

• Periods - Bank Rec

3. Importing Data

• Importing Data Overview
• Import Wizard Step-by-Step
• Amount Field Options
• Deleting an Import / Records

4a. Matching (Common)

• Matching - Getting Started
• a. One to One Matching
• b. Many to Many Matching
• c. Category Matching
• d. Manual Matching
• e. Reviewing, Unmatching, Rerunning

4b.Matching (Reference)

• f. Iterative Date Setting

5. Reports

• 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

FAQs

• How do I get more accounts for Bank Rec?
• Entering Data Manually
• Deleting a Record
• Importing/Editing in a Reconciled Period
Legacy help
• Deciding What to Map
• Mapping Bank Data - Bank Rec
• Mapping General Ledger Data - Bank Rec
• Import Bank Data
• Create Accounts
• Performing System Matching
• Unmatching Records

Monthly Processes

• 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
• AWS Development

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
• Year-End Accounting

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
Third Party Systems & Services
• 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
Special Clients
• Integrated Payables client - BEC 1180 - usaji.org (Regions Bank)
• Special Clients (Genius ERP, STCL, Michael Shooster)
Personnel
• New Employee - Training - Infrastructure
• New Employee - Training - Notes
Internal Processes (SOP)
• Tracking Prospective Sales and Follow-up with Newly Licensed Clients
• Calendar of Tasks to Complete
• Zendesk Format Guidelines
• 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