100R Report
The Indiana 100R Report, also known as the Annual Compensation Report, is a mandatory filing required by the Indiana State Board of Accounts (SBOA). It details the compensation paid to employees by governmental units during a calendar year.
Menu path
From the Human Resources menu, select State. From the State - IN menu, select 100R Report.
Submission period
The report is due by January 31 of the following year.
For example, the 2025 report is due by January 31, 2026.
Selection rule
Employees who were paid within the check range selected in the Load criteria are selected and reported.
Prerequisite
Enter valid information in the Title field on the Payroll Information - State Required page.
Load data
Use the IN 100R Report - Load page to specify the criteria for loading the required data for the report.
On the IN - 100R Report page, select Load.
Refer to the Field descriptions and enter or select the required load criteria.
Select Load, and then Yes.
If data for the selected criteria is loaded, select Yes to delete and reload the data.
Save the Load Summary report file and select OK.
If errors are encountered, save the Load Error log and select OK.
Navigate to the file location.
Inspect the files. Refer to Maintain data and update it as necessary.
Repeat these steps until no errors are encountered and all required data is loaded.
Field descriptions
The following table describes the fields on the IN 100R Report - Load page.
Field | Description |
|---|---|
Reporting Year | The reporting calendar year of the 100R data. |
Check Issue Start Date | The starting date of the period in which checks were issued. The default is January 1 of the Reporting Year. You can select an alternative date if needed. |
Check Issue End Date | The ending date of the period in which checks were issued. The default is December 31 of the Reporting Year. You can select an alternative date if needed. |
Employee Department Criteria | Indicates which employee location to include in the report. |
Employee Title Criteria | Indicates which employee title to include in the report. |
Maintain data
If errors are encountered during the Load data process, you can correct the source data on the Employee Information form of the IN - 100R Report page. After corrections, you must purge and reload the data.
PowerSchool recommends that you correct the report’s source data that is retrieved from the Core application.
On the IN - 100R Report page, filter records using the filter criteria. To enter filter criteria:
Select an option in the first field.
Select or enter a value.
Select Add if the button is enabled.
Refer to Search for records for more information.To add a record, select Add Record. Refer to the Field descriptions and enter valid information in the required fields. Select Save, and then Yes.
To edit a record, select the ellipsis in the Actions column and then select Edit. Update the information and select Save.
To delete a record, select the ellipsis in the Actions column, select Delete, and then select Yes.
To download the information, select Download, then select Download PDF or Download as an Excel Document. The default file names are:
Excel: IN 100R Report_<MMDDYYYY>_<hhmmss>.xlsx
PDF: IN 100R Report_<MMDDYYYY>_<hhmmss>.pdf
Field descriptions
The following table describes the fields on the Employee Information form of the IN - 100R Report page.
Field | Description | Load logic - Data source and Valid values |
|---|---|---|
Year | The calendar year of the 100R data. The default value is the current year. This field is view-only and cannot be updated after saving the record. | Not applicable |
Employee Number | The employee’s identification (ID) number. Select the Lookup icon to search for and select an employee number. This field is view-only. | The field value is retrieved from the Employee Number field on the Employee Information page. |
First Name | The employee’s first name. This field is view-only. | The field value is retrieved from the First Name field on the Employee Information page. |
Middle Initial | The employee's middle initial. This field is view-only. | The field value is retrieved from the Middle Name field on the Employee Information page. |
Last Name | The employee's last name. This field is view-only. | The field value is retrieved from the Last Name field on the Employee Information page. |
Title | The employee’s position, title, or duties. | The system determines the title based on the Employee Title Criteria selected on the IN 100R Report - Load page. If Department Title is selected, the value is retrieved from the Department field on the Employment tab of the Employee Information page. If Primary Job Class is selected, the value is retrieved from the Job Class field of the employee’s primary pay rate on the Pay Rate Information page. If there is a value in the Title field on the Payroll Information - State Required page, it is used instead of the Department Title or Primary Job Class determined during the Load process. This field value overrides the Title field value on the Payroll Information - State Required page. |
Department | The employee’s department, office, or building name. | This field value depends on the Employee Department Criteria selected on the IN 100R Report - Load page. The field value is retrieved from the Location Code field on the Location Table page. This field value overrides the Location Code field value on the Location Table page. The values in the drop-down list are retrieved from the Location Table page. |
Street Address | The first line of the employee's location address. | This field value depends on the Employee Department Criteria selected on the IN 100R Report - Load page. The field value is retrieved from the Address field on the Location Table page. This field value overrides the Address field value on the Location Table page. |
City | The employee's location city. | This field value depends on the Employee Department Criteria selected on the IN 100R Report - Load page. The field value is retrieved from the City field on the Location Table page. This field value overrides the City field value on the Location Table page. |
State | The employee's location state. | This field value depends on the Employee Department Criteria selected on the IN 100R Report - Load page. The field value is retrieved from the State field on the Location Table page. This field value overrides the State field value on the Location Table page. |
Zip | The employee's location zip code. | This field value depends on the Employee Department Criteria selected on the IN 100R Report - Load page. The field value is retrieved from the Zip Code field on the Location Table page. This field value overrides the Zip Code field value on the Location Table page. |
Compensation | The total compensation paid to the employee in the calendar year that just ended. This field must contain a decimal point and cents, even if the cents are zeroes. | The value is calculated by adding up the checks issued during the date range selected on the IN 100R Report - Load page. |
Donation | Indicates whether the employee’s compensation is funded totally or partially by donated funds. The default is No - 0. | Valid values:
|
Create file
Use the IN 100R Report - Report page to specify the report criteria and create the report file.
On the IN - 100R Report page, select Report.
Select the Year.
Create a hard copy of the report to verify data before you create the electronic file:
Select Hard Copy.
Select PDF or Excel.
Select Create, and then Yes.
Save the file and select OK.
Navigate to the folder containing the report file.
Inspect the file. Refer to Maintain data and update it if necessary.
Repeat these steps until all the required data is included.
Create the electronic file:
Select Electronic File.
Select Create, and then Yes.
Save the file and select OK.
The default file name is gateway100R.csv.
For detailed information about the report’s file layout, refer to 100R Report - File Layout and Data Mapping.
Follow the state's submission procedures.
Purge data
If you need to correct setups or employee data, purge the existing records and reload the data.
On the IN - 100R Report page, select Purge.
Select the Year.
Select Submit.
Select Yes, and then OK.