EFTPS 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 EFTPS Data Export

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

Set the following parameters:

• Cycle: Defaults to current accounting cycle.

• Payroll Cycle: Select from the list.

• Payroll Register: Select from the list of printed registers.

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

Return to Print Liability Checks & Make EFT Payments