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.

Before you start

Multi timesheet import allows you to import values to a timesheet, however it can't remove or replace default values.

For example, you have an employee with basic hours of 37.5 set in their employee record. You then import 20 hours against their basic hours using multi timesheet import.

In this example, their timesheet will have a line for 37.5 and a line for 20, as the import doesn't remove existing default data.

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.

• Create a multi-timesheet CSV file
• CSV format for multi-timesheet imports
• Examples of multi-timesheet CSV imports