Gender pay gap reporting - Import employment types
Description

As part of Gender Pay Gap reporting, you need to review the employment type of your employees, to ensure the current setting for them is correct.

Let's take a look at how to do this.

Cause
Resolution

The Employment Type report

Run the report:

  1. Click Reports and then choose Report Writer.
  2. Within Report Writer click File then click Open.
  3. Choose the EmpType.rpt file then Open it.
  4. Click Process to generate the report.

This report shows:

  • Employee's Gender
  • Employee's Surname
  • Employee's First Name
  • Employee's PPS Number
  • Employee's current Employment Type

Import employment type information

  1. Open Micropay and log in to a payroll as normal.
  2. On the menu bar, click Help then click System Information.
  3. Make a note of the Data Directory link.
  4. On the menu bar, click Reports then click Report Writer.
  5. Click File, then click Open.
  6. Select EmpType.rpt, then click Open.
  7. Click Process. A report listing all employees in your payroll appears on-screen.
  8. Click File, then click Save As. Click the Save in arrow, then browse to the location you noted in step 3.
  9. In the File name box, type EmpType.csv.
  10. Click Save.
  11. Close Sage Payroll and browse to the location you noted in step 3.
  12. Right-click the file EmpType.csv, then click Open with.
  13. When prompted, select Excel then click OK.
  14. Click File then click Save.
    If the Data Directory link that you noted in step 3 is C:\ProgramData\Sage Payroll Irl/*Current Tax Year*, skip to step 21. If it's not, you must correct the Sage Payroll data path specified within the import file. To do this, please complete steps 15 to 27.
  15. Click the Data Directory link.
  16. Right-click the file EMPTYPE.IMP, then click Open with.
  17. When prompted, select Notepad then click OK.
  18. Locate the data= entry line, then edit the highlighted section below so it matches your data directory location:
    data= C:\PROGRAMDATA\SAGE PAYROLL IRL\*Current Tax Year*\EmpType.CSV
  19. Click File, then click Save.
  20. Click File, then click Exit.
  21. Open Sage Payroll and log in to a payroll as normal.
  22. Take a backup of your payroll data.
  23. On the menu bar, click Miscellaneous, point to Data Import then click Data Import.
  24. Browse to the location you noted in step 3.
  25. Select EMPTYPE.IMP then click Open.
  26. To import employment type for any employees with no setting,

    for each relevant employee enter:


    'P' to assign the employment type 'Permanent'
    'T' to assign the employment type 'Temporary'
    'C' to assign the employment type 'Casual'
     

  27. Repeat steps 4 to 7 again and check the correct employment type is applied to each employee. If not, you must restore the backup you took before you ran the import process and complete the steps detailed in this section again.
Steps to duplicate
Related Solutions