Import employee timesheet values

Import employee payment hours and payment values into timesheets in Sage 50 Payroll Ireland.

Use the Single Timesheet Import option to import payment hours or payment values into employee timesheets.

Create a single timesheet import file

Before importing timesheet values, create a CSV file in the required format. You can create the file in Microsoft Excel or Windows Notepad.

If you use time and attendance software, check whether it can generate the CSV file for you. Your software provider needs your payment numbers to create the correct format.

The CSV file needs to contain one row for each employee.

Column	Information
A	Payroll period number.
B	Employee number.
C	Enter 0000.
D	Hours or value for payment element 1.
E	Hours or value for payment element 2.
F	Hours or value for payment element 3.

---

Example

Field	Value
Period	5
Employee	0241
Unused field	0000
Payment 1	37.5
Payment 2	€250.00
Payment 3	€300.00

---

Before you import

Keep the following in mind when creating your import file.

• Enter hours using industrial minutes. Don't include a decimal point. The last two digits represent hundredths of an hour
• Running the import again replaces the previously imported values. Zero values and blank fields don't overwrite existing imported values
• Don't include employee hourly rates. Sage 50 Payroll Ireland uses the hourly rates stored in the employee's details
• You can import multiple payment elements, provided you've already created them in the company payments
• The employee number in the CSV file needs to match the employee number in Sage 50 Payroll Ireland exactly. For example, employee 0054 won't match 54
• Timesheet imports always include fixed payments. To save a timesheet for an employee with only fixed payments, either:
  • Include the employee in the import file, for example, 5,0003,0000
  • Save the employee's timesheet using Random, Sequential, or Batch entry
• Save the file in CSV format
• Keep the CSV file open until the import completes

---

Hourly paid employees

Before importing zero hours for an hourly paid employee, remove any standard hours from their employee record.

1. Go to the employee record.
2. Open the Payments tab.
3. Delete the value in Std. Hrs.
4. Select Save, then Cancel.

---

Import the CSV file

1. Back up your payroll data.
2. Select Processing, then Time and Pay.
3. Under Entry Mode, select Import.
4. Select Browse next to File Location.
5. Select the CSV file, then select Open.
6. Select Continue.
7. Review any errors or warnings and resolve them before continuing.
8. If required, select Print Detailed View to print the import summary.
9. Check your printer settings, then select Print.
10. Select Save Time and Pay.
11. Select OK.