Hours worked can be imported into the system with a .csv file, which can be exported from spreadsheet software such as Excel.

To access the Import Hours page, navigate to Employees > Run Payroll > Import Hours where you will be prompted to select a number of columns. These columns should correspond with the relevant column in your spreadsheet i.e. Row A = 1, Row B = 2 and so on.

Each column represents the following data:

• Account ID – the ID of the Employee Account, which can be found in the Employees screen
• Date – the accounting date or end date of the pay period
• Hours – the total number of hours worked (can be decimal)
• Pay type – should match the ‘pay types’ set up in the employee record i.e. wages, bonus
• Works order number – if the hours are the result of a works order
• Project name – if the employee costs are to be assigned to a project
• Department name – if the employee costs are to be assigned to a department
• Customer account code – if the employee’s hours are to be assigned to a customer account
• Stock code – if the employee hours are to be attached to an order item

If the date field is blank, you will need to choose a relevant payroll date using the ‘if blank date’ field.

Finally, choose the file to import and select ‘Import’.

The employee hours will then be imported into the ‘Enter Hours’ screen.