Note: Positions must be loaded prior to uploading distributions.
| Step | |
|---|---|
| ❏ | In the current year payroll, use the Payroll > Reports > User Created Reports page to generate a user-created report. Reference the below image for a list of fields to select and click Create Report. Use the filter to exclude pay type 4 (substitutes) employees. Save the report as an Excel file. |
| ❏ | Download and save a copy of the Import PMIS Distributions Template. |
| ❏ | Copy and paste columns from the most current spreadsheet to the Import PMIS Distributions Template. Manually complete all applicable blank fields. Distribution Sequencing is required if the distribution record has more than one account code. Indicate matching position number and billet with multiple sequence numbers. (Sample screenshot - Gina) |
| ❏ | Delete the first and last name columns. The file can only contain the information that is being imported. |
| ❏ | Prior to uploading the file, some column formatting changes must be done to reflect leading zeros. After deleting the first and last name columns, format the following columns: • Column C Billet must be five characters • Column E Distribution Sequence – If an employee has more than one line of distribution data, this field should be numbered consecutively beginning with 1 and must be three characters. • Column G Job Code must be four characters. If your job codes are less than four characters, the job code column may have to be reformatted. • Column M Sub Object must be two characters • Column N Organization must be three characters • Column R Project Detail must be two characters • Column T Account Percent must be eight characters (five digits to the right of the decimal) Excel formatting instructions. |
| ❏ | Delete the headers on the first row. Save the file again with a new name. For example, PMIS Distributions Load 1. |
| ❏ | In the current year PMIS, upload the file on the Position Management > Utilities > Import Position Records page. Select Distribution Records. Click Choose File and select the PMIS Distributions Load 1.csv file and click Execute. Review the error report and make changes as necessary and import the file again until there are no errors and the file is successfully uploaded. |
| ❏ | Repeat the above steps for supplement positions; however, name the files accordingly. For example, save the file as PMIS Supplement Distributions instead of Distributions. The supplements should be uploaded in a separate file from the regular distributions. |