Location

SmartFusion Modules > Payroll > Process > Export ACA Files

Description

This JIRA will give the client the ability to export employee Demographics into an Excel Spreadsheet format

Test Cases

Note: You must have the export set to integrity data in the system parameters. Payroll System File > Page 2 > ACA Export

Set up an employee

  • Find or create an employee who was hired this month

  • Go through the process to inactivate them

  • Then rehire (activate) them again in the same month.

Create the Export File

  • Go to Payroll > Process > Export ACA Files

  • set the month to the month where you hired, fired, and rehired the employee in the last step.

  • Set the file export path.

  • Click Export

Validate that the file exports

Validate that the output file is a tab delimited file with a txt extension

Verify the Integrity Data Export File

  • Open the export

  • find your employee and verify that it is using the most recent hire date.

  • Compare your export to the one attached to the JIRA titled Excel-Templates.zip

Validate that the export data matches that of the template.

Notes on fields:

  • COMPANYID = FED TAX ID NUMBER
  • OPTINW2 =FALSE
  • OPTIN1095C = FALSE
  • Attachment Password will be blank as SF does not offer that feature
  • Sutastate = tax state from Tax tab on Enter/Edit Employee Master
  • State = employee address state