Steps to Export GridNote: The North Dakota PERS Service Purchase Report option is used by those North Dakota school districts who have employees who are purchasing service credit from North Dakota PERS. The North Dakota PERS Service Purchase Report option generates a report (file) for the designated deductions and employees in order to submit the necessary information to North Dakota PERS after each check cycle in Payroll.
From the Payroll screen, select the Government Reporting menu and then North Dakota PERS Service Purchase Report.
At the North Dakota PERS Service Purchase Report screen, click the Report Options tab and complete the information.
Enter the range of dates in the From Date and To Date fields for which payroll calculation batches to display (based on Check Date). Use the mm/dd/yyyy format or click the down-arrow button for the fields to select the desired dates. After entering or selecting a date, you must advance out of the field. The current month (as based on the computer date) will appear as the default, but can be changed.
The payroll batches with Check Dates in the specified date range appear in the Payroll Batches List. Select the desired payroll calculation batches (and/or date sequences if a payroll batch has multiple date sequences) from the Payroll Batches List to include when generating the report by clicking the box for the Selected column to the left of the desired record. A checkmark will appear in the box if the record is selected. To select all the payroll batches (and/or date sequences if a payroll batch has multiple date sequences), click the Select All button located above the Payroll Batches List. If desired, change the filters to modify the records displayed here.
Enter the 6-digit code assigned to your organization by the North Dakota PERS Office in the ORG Code ID field.
Click the Save button.
Click the Pay Groups tab to select the pay groups to include on the report.
Note: The pay groups defined (within the Pay Group File) to be included on the North Dakota PERS Service Purchase Report are selected by default, but can be changed if needed; if changes are made here, the changes will also be reflected in the Pay Group File.
To select a pay group, click the box under the Selected column to the left of the pay group ID. A checkmark will appear in the box if the pay group is selected.
To select all of the pay groups, click the Select All button located above the Pay Groups List.
Click the Save button.
Click the Deductions tab to select the appropriate deductions to include on the report.
Tip: To lock a column in place so that it does not move while scrolling the information in the grid, click the pushpin located to the right of the desired column heading. Once the pushpin has been selected for a column, the pushpin will appear vertical to indicate the column is locked, and the locked column will move to the left and appear in front of all unlocked columns. To unlock a column, click the pushpin again; the pushpin will appear horizontal to indicate a column is unlocked. If the screen is closed and re-opened, or the Save button is clicked (if applicable), the settings for the pushpins will go back to the defaults.
For each applicable deduction, enter which share (Employee, Employer, or Both) of the deduction to include on the report in the field under the column for the appropriate category (After Tax or Pre Tax), or click the down-arrow button to select the correct one.
Note: A deduction can only be selected under one category.
Click the Save button.
Click the View/Edit Data tab to view the information on the report and make any changes if needed.
Tip: To lock a column in place so that it does not move while scrolling the information in the grid, click the pushpin located to the right of the desired column heading. Once the pushpin has been selected for a column, the pushpin will appear vertical to indicate the column is locked, and the locked column will move to the left and appear in front of all unlocked columns. To unlock a column, click the pushpin again; the pushpin will appear horizontal to indicate a column is unlocked. If the screen is closed and re-opened, the settings for the pushpins will go back to the defaults.
To change the amount for an employee, click in the Amount field and then key the correct information. To delete an employee from the report, click the Delete button to the left of the desired employee's record(s).
Note: All changes will be lost once the View/Edit Data screen is closed (either by closing the option or accessing a different tab (screen)); if any changes were made, create the file at this time in order to include the desired changes.
To export the data into a file in order to open and print the report (such as in Microsoft® Excel), if desired, complete the Export Grid option (accessed from the File menu).
Note: The file created with the Export Grid option is not the file to submit to North Dakota PERS as it is not using the correct required file format/layout.
Create the file to submit by completing the following steps:
Select the Options menu and then Create Report File.
At the Create Report File screen, select the desired path (drive and folders) for the destination location and click the Save button.
After the report is generated and the file created, click the X in the upper right-hand corner to close the screen.