Payroll ACH Data Export

You can create a data file to send to the bank for every payroll liabilities vendor that accepts electronic funds transfers — including state and federal taxing authorities — after you've created the EFT payroll liabilities in the Payroll module.

An EFT entry can be either a regular electronic funds transfer or a pre-notification sent to the bank to verify that all EFT information is correct. Depending on how you want to handle pre-notifications, the Regular and Pre-Notification entries can be in either one file or two. The data file created follows the Automated Clearing House (ACH) file-formatting standards.

In order for the export to generate, users must first set up vendors and complete parameters in Payroll Configuration.

Run the ACH Data Export

The Payroll ACH Data Export is reached by selecting Exports > Payroll > ACH Data Export.

Set the following parameters:

• Cycle: Defaults to current accounting cycle.

• Payroll Liability Voucher: Select from the list of approved and pending vouchers.

• Entry Type: Select the EFT types to export:

• • All: All EFTs for the selected voucher are exported.

  • Regular: Pre-notifications for the selected voucher are excluded.

  • Pre-Notification: Only pre-notifications from the selected voucher are included.

• File Modifier: Select from A, B, C, D, E. The modifier must be increased incrementally with each ACH export created on the same day. Important: If you are sending information from a Special register to the bank on the same day, you must remember to select the appropriate file modifier. For example, if your initial data export used the file modifier "A," your Special Register export must use the file modifier "B." Verify this information with your bank.

• Immediate Destination Source: Select from ACH Operator Routing Number and the Employer's Bank Routing Number.

• Immediate Origin Source: Select from Company ID and the Employer's Bank Routing Number.

• Standard Entry Class Code: Select from CCD or PPD according to your bank's requirement. The default is CCD.

Return to Print Liability Checks & Make EFT Payments