Import employee timesheet values
Description

If you're importing employee timesheet values and not dividing them between various departments and/or cost centres, follow the steps in this guide.

To import payment and deduction values into timesheets and allocate them to a specific department or cost centre, use the Multi-timesheet import option.

Cause
Resolution

Create a single timesheet import file

Before you can import payment hours or values into Sage Payroll, you must prepare a CSV file in the required format. You can do this using either Microsoft Excel or Windows Notepad.

If you're using a time and attendance software, check with your software provider to see if they can create the CSV file for you. They'll need to know your payment numbers. To run this information directly into a Microsoft Excel spreadsheet. You can then email this spreadsheet to your software provider.

The CSV file must contain one line per employee using the following order:

Microsoft Excel column Information to enter
A Enter the period number.
B Enter the employee's number.
C Enter 0000.
D Enter the hours or value for payment element 1.
E Enter the hours or value for payment element 2.
F Enter the hours or value for payment element 3.

Load the single timesheet import file into Sage Payroll

Take a backup of your payroll data, then complete the following steps:

  1. On the menu bar, click Processing then click Time and Pay.
  2. Under Entry mode, select Import.
  3. Next to the File Location box, click browse Browse icon..
  4. Browse to and select the CSV file, then click Open.
  5. Click Continue.
  6. Check the Time and Pay - Import window for any errors and warnings. If any appear, you must resolve them before proceeding.
  7. To print a list of the data you're about to import, click Print Detailed View.
    Check your printer settings are correct, then click Print.
  8. To import and save the timesheet values, click Save Time and Pay then click OK.
Steps to duplicate
Related Solutions