General Ledger ACH
Written by Brandy Burch
Updated at March 18th, 2025
NOTES:
- This setup is not for Payroll or Revenue ACH. Please see Payroll ACH or Revenue ACH.
- GL ACH will not prevent items from pulling into an A/P check run. Process your GL ACH items before doing a check run.
Overview
General Ledger ACH is an add-on module with the ability to:
- Pay outstanding Accounts Payable (both accrual and cash basis A/P).
- Collect outstanding Accounts Receivable invoices or balances due.
- Pay or Receive Revenue Billing through ACH (Automated Clearing House).
Pak Accounting Interface: G/L ACH interfaces with Accounts Payable, Accounts Receivable, and Revenue / Billing to send or receive payments from customers / vendors / owners.
Initial Setup
- Setup an ACH journal number in the General Ledger module > Master Files Maintenance > Journal. This will help keep all ACH entries separate from other entries.
-
Setup each bank in the General Ledger ACH > Master Files Maintenance > ACH Bank Accounts - all banks should be setup including your company's bank and any bank that you will be transferring to or from. The routing number for each bank will be needed. If you will be wiring funds, the Wire Routing Number will need to be added to the Wire Routing Number field. The system will automatically default this number to be the same as the ACH Routing Number.
NOTE: Many credit unions will use a different routing / transit number for direct deposit vs. what is encoded on their checks. It would be a good idea to call the credit union to verify the number. -
In the General Ledger > Bank Account master, setup your company's bank account information under ACH tab. Some of this information will be provided by your bank.
- In Sub-Account Maintenance [F12], for each customer / vendor using ACH, setup the bank and account information on the ACH tab. The setup for this tab is the same for customers and vendors.
NOTES:
- If you do not see the ACH tab in Sub-Account Maintenance, go to General Ledger > Master File Maintenance > Sub-Table, find the Sub-Table # you are working in and select the ACH tab.
- The Optional Addenda record prints a description on the ACH file and statements. The ACH type (PPD or CCD) depends on what your bank requires. ***If you are going to submit CCD type transactions, please notify your bank in order for them to prepare to receive these transactions.***
The General Ledger ACH module has a prenote capability. In the bank account master, if a number is entered in the Number of days required for a prenote field, the system will look at the Sub-Account Maintenance [F12] > ACH tab > Prenote Date field for those Sub-Accounts being extracted to see if a date has been entered. If there is no date entered but ACH information exists, a zero amount line will be created for the prenote in the ACH file. If the bank account maintenance, Number of days required for prenote field is set to zero, the Sub-Accounts without a prenote date recorded that are being extracted (because there are ACH transactions for them) will be set to the extract"s effective date so that a prenote file is not created.
NOTE: If a prenote test file fails, return to the Sub-Account maintenance, ACH tab and clear out the prenote date to process another test. Additionally, the system will not allow the input of special characters (-, ", :, etc.) when entering account information. Only numeric values may be entered.
Using GL ACH:
G/L ACH Cycle:
-
Extract the accounts receivable and/or accounts payable information to send to the bank.
- You will need to pay the GL ACH items before cutting checks in A/P. Otherwise, invoices will be paid via check instead of ACH.
- Use the Edit Grid to hold any transactions.
- Check the Edit listing for any problems.
- Print Statements (optional).
- Update to create the ACH file and create the general ledger entries.
Voiding Payment - see Voiding GL ACH Payment