ACH Submission
*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 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:Â Select a pay 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.
**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