Skip to main content

Importing hours from Smartplan

Learn how to set up and import hours from Smartplan via Excel.

Setup Guide:

  1. Go to your Smartplan account, click the Payroll tab, and select Salary as your payroll system.

2. Once the setup is complete, you need to add the pay types used by your employees.

For each pay type, specify:

  • Title

  • Pay Type from Salary

3. You can also create pay supplements, for example for public holidays or weekend work.

When creating a pay supplement, specify:

  • Pay Supplement Name

  • When it applies (weekdays/public holidays)

  • Who it applies to (all or selected employees)

  • Time period for the supplement

  • Pay Type from Salary (e.g. Holiday Hourly Pay or Weekend Hourly Pay)


Import Guide

1. Once you have completed the setup, you can run payroll from Hours & Payroll in Smartplan. First, select the payroll period you want to process, then click Run Payroll for the Period.

Next, enter each employee's payroll number so Salary can assign the hours to the correct employee. You also need to select the employee's pay type. This information is saved automatically, so you only need to enter it the first time you run payroll.


Once you've completed these steps, click Download Payroll File in the bottom-right corner. Your payroll file will then be downloaded.

2. Go to Salary, click the Registrations tab → Time Registration, and click the Import from File button.

3. Select Time Registrations (Salary Format), unless you have selected a different payroll system in Smartplan, such as Danløn. In that case, select the Danløn Format instead.

4. Select the period for the time registrations, then click Continue to Upload.

5. Upload the Excel file exported from Smartplan.

6. Review the imported time registrations and click Approve. Finally, click Finish.

Did this answer your question?