/
Reporting IN Gateway Annual Payroll History

Reporting IN Gateway Annual Payroll History

Description of Issue

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.

Context
  • Payroll
  • Indiana
  • Payroll Detail History Report
Cause

Munis does not have a canned report for this submission.

Resolution

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. 

Additional Information






Related content

Payroll Report including Employee Master data and Gross Wage Accumulators
Payroll Report including Employee Master data and Gross Wage Accumulators
More like this
Report for Earnings and Deductions with Account information
Report for Earnings and Deductions with Account information
More like this
How do I Create a Check Report for Payroll Checks
How do I Create a Check Report for Payroll Checks
More like this
Payroll Report including Personnel status and Gross pay for a Certain Check Date
Payroll Report including Personnel status and Gross pay for a Certain Check Date
More like this
Report with employee number, name, position, pay rate for specific period
Report with employee number, name, position, pay rate for specific period
More like this
Report that shows everything in Earnings and Deductions in payroll
Report that shows everything in Earnings and Deductions in payroll
More like this