ACH Submission

Owned by Former user (Deleted)
Last updated: Nov 20, 2024 by Lori Nye

*IMPORTANT *-If you wish to include the HSA Payroll Item amount information on your Outstanding Payables report, it is suggested that you go to Outstanding Payables and run the report before the creation of the HSA Tape File. If you process the HSA ACH file, it will create the Payment for the HSA and also clear the amounts from Outstanding Payables.


ACH Submission Report Options

It creates a file which is sent to the bank by some magnetic means. This file includes the employee's name, transit routing numbers for the financial institution, account numbers, and pay amounts for all the direct deposit employees.  Also, creates an ACH submission file for Health Savings Account withholding's. Separate ACH file created for each HSA deduction processed, HSAACHXXX.SEQ.  The 'XXX' represents the deduction code.

In order for the Ach File Generated column under 'Historical Payrolls' to turn from false to true, the Payroll Posting period needs to be open for what payroll month they are creating.

Negative or zero-dollar amounts are not accepted on HSA submission files. The district will need to speak to the bank and have the amount manually reduced by them.

Negatives won't show on the file, no Outstanding Payables adjustments will need to be made.


ACH Submission

Fields Definitions:

Pay Date:  This date represents the date you would like the funds to be deposited into employee accounts and will default to the most recent posted payroll pay date. If desired, the Pay Date value can be changed by selecting a date from the calendar.

ACH Source: Select the appropriate ACH Source from the drop-down box.

Include Employee SSN: 

  • Default is 'Employee SSN will NOT be included
  • Employee SSN will be included
  • Replace employee SSN with employee ID

Sort By:  In the drop-down box you can select:

  • Employee Name
  • Employee Number

Report Format:  Default is PDF or you can open the drop-down box and choose another output option.

Check the box to 

Check to 'Display All Payrolls?' Checking this will display all payrolls that have been imported and all those that have their ACH submission files set as generated.

Historical Payrolls: Select, by placing a check mark in the box, of one or many payrolls from which to include. 

After you have selected your options, you can run the report by selecting 

Once you have reviewed the report, you can 

Generate Report Example:

Generate Submission Report example:



HSA Submission File

**If the Payee for HSA is setup with Electronic Payment checked (true), then the payee will be included in HSA report/submission file. Only those payees who are setup with the Electronic Payment checked, will be included on the report/submission file**

**Corrections can be made to the HSA File by using Payables Adjustments.  If adding an adjustment after the HSA file was submitted, the next payroll that is ran, the amount will then be included in that HSA Submission file.

Info:  Payables adjustment will only be included if the payroll item was deducted during the current payroll.  Add to an HSA payroll item that is an Electronic payment.

  • The report and submission first look for a HSA item withheld in the payroll and then if one is found, the user adjustments for payables are collected and added to the payroll item amounts from the payroll.


**POINT OF NO RETURN - Once HSA File is created, Payroll cannot be Unposted for corrections**


If the Payroll Item HSA ACH Configuration account information was missed for an employee and Payroll has been completed, enter in the Ach Account Number and Ach Destination in the HSA Payroll Item for the employee and rerun HSA Submission.

To create the HSA Submission File:

Select the HSA ACH Source

Select 'Include Employee SSN:' from drop down options:

  • Employee SSN will be included.
  • Employee SSN will NOT be included (Defaulted)
  • Replace employee SSN with employee ID.

Select 'Sort By' using the drop-down options:

  • Employee Name
  • Employee Number

Select 'Report Format' from the drop-down options.

Select the Payroll to create the HSA file from the 'Historical Payrolls.'

To show all Past payrolls, check  

Click on  first, to create a report to verify all information is correct before generating the HSA Submission File. 

**Once the Submission File is created, this is a **NO POINT OF RETURN**.  At this point, a Payroll CAN NOT be Un-posted**

**Creating the HSA Submission File will create the Outstanding Payable's for the HSA**

Select  to create HSA file.


Sample HSA Submission Report


Sample HSA Submission file


To create a report for 403b Accounts

If wanting to create a report for your 403b Accounts,  please copy the .json file provided for you: Annuities.rpd-json