Import standard hours into Employee Details
Description

In order to calculate payroll for Salary paid employees, Sage Payroll must calculate the standard hours per period, multiplied by the number of periods included within the snapshot year range.

To help with this you can import an employee's standard hours into the Employee Details section of their record. Let's take a look at how to do this.

Cause
Resolution

Download the required files

  1. Click on the Standard Hours files.zip button to download the StdHours.rpt and STDHOURS.IMP files.
    Standard Hours files.zip
  2. Depending on your Internet browser, the files automatically downloads to your Downloads folder or you're prompted to save the files. Once the files have been downloaded, you should save them into the data directory of your payrolls. 
TIP: To access the data directory, from the menu bar within Sage Payroll, click Help then click System Information and click the Data Directory link.  

Import standard hours information

  1. Open Sage Payroll and log into 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 StdHours.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 StdHours.csv.
  10. Click Save.
  11. Close Sage Payroll and browse to the location you noted in step 3.
  12. Right-click the file StdHours.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 24. If it's not, you must correct the Sage Payroll data path specified within the import file. To do this, please complete steps 18 to 23.
  15. Click the Data Directory link.
  16. Right-click the file STDHOURS.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*\StdHours.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 STDHOURS.IMP then click Open.
  26. Delete all employees set to H hourly, as their hours worked information will be taken from their historical payslips.
  27. Enter the period standard hours for any employee missing this information and save this file.
  28. Repeat steps 4 to 7 again and check the correct standard hours are applied to each of the Salary employees. 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