Transition to the NACHA ACH file format
Follow this guide to transition from our standard ACH payment files to NACHA compliant files. To use the NACHA file format, you'll need to enable and set up your checking accounts, vendors, and employees for bank files.
Learn more about bank file payments.
| Subscription |
Sage Cloud Services Accounts Payable Cash Management Expenses |
|---|---|
| Regional availability |
United States |
| User type |
Business |
| Permissions |
Administration
Company
Accounts Payable
Cash Management
Time and Expenses
|
| Configuration |
Enabled for bank file payments |
Step 1. Export bank details
If you don't have the banking information on hand to enter in Intacct, you can export it. Before you enable bank file payments in checking accounts and vendor and employee records, export the bank details to maintain the banking information.
-
Go to Cash Management > All or Setup > Accounts > Checking.
-
Select Manage views.
-
Select Create new view.
-
Select the following columns to include in your view:
-
Bank name
-
ID
-
Account number
-
ACH bank ID
-
Company name
-
Company identification
-
Originating financial institution
-
Company entry description
-
Company discretionary data
-
Record type code
-
Service class code
-
Originator status code
-
Batch number
-
Trace number sequence
-
Payment number sequence
-
Enable ACH
-
-
Select Next and go to Step 3 to select the following filter.
-
Select Enable ACH as the column to filter.
-
Select Equals as the operator.
-
Enter True as the value.
-
-
Select Next and go to Step 5 to name the view.
Enter Account ACH details as the view name.
-
Select Save.
-
Select Export and export the checking account bank details in CSV format.
-
Go to Cash Management > All or Setup > Accounts > Checking.
-
Select Manage views.
-
Select Create new view.
-
Select the following columns to include in your view:
-
Bank name
-
ID
-
Account number
-
ACH bank ID
-
Company name
-
Company identification
-
Originating financial institution
-
Company entry description
-
Company discretionary data
-
Record type code
-
Service class code
-
Originator status code
-
Batch number
-
Trace number sequence
-
Payment number sequence
-
Enable ACH
-
-
Select Next and go to Step 3 to select the following filter.
-
Select Enable ACH as the column to filter.
-
Select Equals as the operator.
-
Enter True as the value.
-
-
Select Next and go to Step 5 to name the view.
Enter Account ACH details as the view name.
-
Select Save.
-
Select Export and export the checking account bank details in CSV format.
-
Go to Accounts Payable > All > Vendors.
-
Select Manage views.
-
Select Create new view.
-
Select the following columns to include in your view:
-
Vendor ID
-
Vendor name
-
Enable ACH
-
ACH bank routing number
-
Account number
-
Account type
-
Account classification
-
-
Select Next and go to Step 3 to select the following filter.
-
Select Enable ACH as the column to filter.
-
Select Equals as the operator.
-
Enter True as the value.
-
-
Select Next and go to Step 5 to name the view.
Enter Vendor ACH details as the view name.
-
Select Save.
-
Select Export and export the vendor bank details in CSV format.
-
Go to Expenses > All > Employees.
-
Select Manage views.
-
Select Create new view.
-
Select the following columns to include in your view:
-
Employee ID
-
Employee name
-
Enable ACH
-
ACH bank routing number
-
Account number
-
Account type
-
Account classification
-
-
Select Next and go to Step 3 to select the following filter.
-
Select Enable ACH as the column to filter.
-
Select Equals as the operator.
-
Enter True as the value.
-
-
Select Next and go to Step 5 to name the view.
Enter Employee ACH details as the view name.
-
Select Save.
-
Select Export and export the employee bank details in CSV format.
Step 2. Enable bank file payments
If your company doesn't already use bank files, follow these instructions.
The bank file payment service enables you to pay vendors and employees using bank files. Enable bank files at the top level of your company. Sage Intacct only supports the use of bank file payments in particular locales.
Enabling bank file payments involves:
- Turning on the subscription in your company.
- Assigning the correct permissions to users who need them.
| Subscription |
Cash Management |
|---|---|
| Regional availability |
Bank file payments are only available between banks that use the same currency in the following countries:
|
| User type |
Business users with admin privileges |
| Prerequisites |
Ensure that ISO country codes are enabled for the company so that you can make international payments and receive bank feeds. Select the country code for the country where the company operates. On the Company information page, select Use ISO country codes, and select the correct code for the country where the company is located. Learn more. |
-
Go to Company > Admin > Subscriptions.
-
On the Subscriptions page select Sage Cloud Services, then select Subscribe.
If you're returning to this page to make edits, select Configure.
-
Company information defaults from the Company information page.
Check to make sure that everything is accurate.
-
Select Enable bank file payment.
Sage Intacct enables the subscription, and the Status of the company subscription changes to Subscribed.
- Select Save.
-
Go to Company > Admin > Users, roles, and groups > Users.
- Select Subscriptions next to the user or role to whom you want to give permissions to make bank file payments.
- Assign the following Permissions:
- Select Save.
| Application | Activities and lists | Permissions |
|---|---|---|
|
Accounts Payable |
Vendors |
Bank details, Unmask bank details |
|
Cash Management |
Bank file generator |
Run |
|
Bank files |
List, View, Manage, Export, Confirm, Delete |
|
|
Checking accounts |
List, View, Add, Edit |
|
|
Expenses |
Bank file generator |
Run |
|
Bank files |
List, View, Manage, Export, Confirm, Delete |
|
|
Employees |
Bank details |
This process might take up to an hour.
Step 3. Enable bank files for checking accounts
You can create a new checking account or edit an existing checking account to support bank file payments. Some fields are required specifically for bank file payments that are otherwise optional.
| Subscription |
Cash Management Sage Cloud Services |
|---|---|
| Regional availability |
Bank file payments are only available between banks that use the same currency in the following countries:
|
| User type |
Business user with admin privileges |
| Permissions |
Cash Management
|
| Configuration |
ISO country codes are enabled. Bank file payment option selected in Sage Cloud Services. See Configure Sage Cloud Services for details. |
| Tip |
Designate Accounts Payable journals. |
| Restrictions |
Bank file payments are only available between banks that use the same currency. |
-
Go to Cash Management > All or Setup > Accounts > Checking.
- On the Checking Account information page, select the Details tab.
-
In the Checking Account section, enter or modify the following required information:
Details tab field descriptions Field Description Account ID
Required if creating a new checking account.
Account number
Enter the account number of this checking account.
Bank name
Enter the name of the bank.
Name on the account
Enter the name of the checking account holder. This is the legal name associated with the account.
Country
The country in which the bank is located. Determines the bank file format used to make bank file payments.
Currency
The currency in which the checking account operates.
Ensure that your currency matches the country you select for the checking account. For ACH, select USD as the currency.
-
In the accounting information section, enter or modify the following required fields:
Accounting information section Field Description GL account
Select a General Ledger account.
Location ID
Select the location ID of the entity with which this checking account is associated.
- On the Bank file tab select Enable bank file payments.
-
In the Bank setup section, select the NACHA Bank file format that matches your bank requirements.
Options include balanced or unbalanced and with or without an end-of-file marker.
-
Fill in the remaining required fields.
These are for the bank file required for the location of your checking account, as shown in Details: Bank file setup.
- Save your changes.
Step 4. Update vendors and employees for bank files and enter bank details
Edit your vendor and employee records to support bank file payments. The following instructions are to set up vendors and can be repeated for employees that you pay with ACH in Intacct.
- From the Vendors list, select Edit next to the vendor you want to edit, or select Add to create a new one.
- Go to the Payment information tab.
- In the Payment details section, select the Preferred payment method dropdown list and select ACH or bank file.
-
Optionally, in the Payment details section, select Merge payment requests.
This allows Sage Intacct to create a single payment request for all bills associated with this vendor.
- On the Bank file tab, select Enable bank file payments.
-
Select the Payment country field value that matches the country selected in the vendor record.
For ACH payments, select United States.
- Enter the vendor details for the bank file according as shown in the field descriptions.
- Fill in any remaining fields as desired in other tabs.
- Save your changes.
Step 5. Use the bank file workflow to process payments
-
Select ACH or bank file as the payment method when you pay bills.
-
Use the Bank File Generator and Bank Payment File menu options to generate, download, and confirm the payment files.