Skip to content
logo Knowledgebase

Import timesheets by department and cost centre

Created on  | Last modified on 

Summary

Import timesheet values split by department and cost centre in Sage 50 Payroll Ireland.

Resolution

You can import payment hours or values into employee timesheets and allocate them to departments and cost centres. To do this, you enable the multi-timesheet option and import a CSV file.

TIP:

If you don’t need department or cost centre splits, use the single timesheet import instead.

Enable the multi-timesheet option

You need to enable this option before importing data.

  1. Open Sage 50 Payroll Ireland and sign in to the payroll.
  2. Go to Help, then select System Information.
  3. Select Data Directory, then open the payroll folder.
  4. Right-click PAYROLL.INI, then select Open with Notepad.
  5. In the [Timesheet] section, enter:
    • Sequence=3
    • AllMulti=1
    • Type=Multi
  6. Select File, then Save.
  7. Select File, then Exit.

Repeat these steps for each payroll where you want to use a multi-timesheet import.

Import a multi-timesheet CSV file

  1. Go to Processing, then select Time and Pay.
  2. Next to File Location, select Browse.
  3. Select the CSV file, then select Open.
  4. Select Continue, then review any errors or warnings.
  5. Select Save Time and Pay, then OK.

You need to fix all errors before saving the import.

Related Solutions