Import Excel Timesheet

To import a timesheet the file must first be saved to your PC, and closed. You will not be able to import a timesheet if it is currently open in Excel.

There are five ways to import timesheets.

Tick the 'Import Timesheet' option when creating a Pay Run.

Click 'Import Timesheet' in the 'Pay Run' ribbon.

Right-clicking on the Pay Run List and selecting 'Import Timesheet' from the drop-down list.

Clicking on the 'Timesheet' button in the 'Pay Packet' ribbon whilst in the pay packet view, and selecting 'Import Timesheet'.

Right-clicking in the 'Pay Run Payees' list and selecting 'Import Timesheet' from the drop-down list.

All five options point to the same Timesheet Import Wizard. When this opens, first select the Timesheet file type if it is different from default. Click 'Browse' to find the timesheet file. Choose the file through the resulting dialogue box and click 'Open'.

Step 1 of the import wizard includes an option to create a manual pay packet for each employee with values in the timesheet. For example, it can be useful if paying commissions that need to be kept separate from the main pay packet. Once complete, click 'Next'

In this screen the Wizard will validate the data in the timesheet and provide a summary of data. Any errors or warnings will be displayed in the 'Report' box. If there are no warnings and the data summary is correct, click 'Next' to proceed with the import.

Click 'Finish'. A message will be displayed informing that the file upload has been successful, the Import Wizard will close and notification of successful (or unsuccessful) import of the timesheet will be received via email once import is complete.