Reporting IN Gateway Annual Payroll History

How do I submit the Annual Payroll History Report (without social security numbers) to IN Gateway? This should include at a minimum the date, employee name, gross wages, and check number for all payroll checks issued for the year.

• Payroll
• Indiana
• Payroll Detail History Report

Munis does not have a canned report for this submission.

The Payroll Detail History report should be used to create the excel submission file:

1. Navigate to Human Capital Management > Payroll > Employee History > Payroll Detail History Report
2. Select Search on the Menu Ribbon
3. Define the screen as follows:
   
   1. Frequency Cycle > Yearly = Prior Year
   2. Earnings/Deductions Detail = Earnings
4. Select Accept from the Menu Ribbon
5. Select the Excel option
6. In excel create a Pivot Table to create the submission file
   1. Add an new sheet
   2. Select Insert > Pivot Table
   3. Select the data from the excel and insert that into the pivot table
   4. In the pivot table set the following fields in the Rows box
      1. Employee Last Name
      2. Employee First Name
      3. Check Date
      4. Check Number
   5. Move the Amount field to the Values box
7. Select Design > Report Layout > Show in Tabular Form

This will put the information into separate columns as described by the state.