Hours (Time records)
Last updated
Last updated
You can select from templates provided by Moment or you can build your own export template. However, this setup requires some technical insight. Please contact support for assistance if you have questions regarding creation of your custom export template file.
Here you can set up your file: Setup > Settings > Export templates
All export files are subject to a one-time cost.
To retrieve the file with registered hours, go to Company > Timesheet status . If the export template is set up, you will see this box:
Make sure you have create an export template, as described in the section above.
Follow your internal company routines. Usually this is to ensure that all employees are done registering their hours for the given period.
Choose to include accumulated banked hours
Choose to include external co-workers
Choose to only include hours from overtime categories
The exported file is ready to be imported into your salary system.
This is how the exported file can look like: 0;0;57;800;0.00;1;1096.00;1096.00;0;0;"";"2019090";"";"";"";"";0 0;0;57;400;0.00;1;435.00;435.00;0;0;"";"2019090";"";"";"";"";0 0;0;57;400;0.00;1;435.00;435.00;0;0;"";"2019090";"";"";"";"";0 0;0;57;655;0.00;1;91.00;91.00;0;0;"";"2019090";"";"";"";"";0
The columns (headers) will in this case be: 0 (year. To be chosen on import) 0 (period. To be chosen on import) externalUserAccountNumber compensationTypeCode empty quantity amountIncludingVat totalAmountIncludingVat empty empty projectNumber empty fields to be used for several data fields All columns and content are flexible, and get be adjusted in Moment.
The export file does only contain records where the external employee number is added
The export does not change any data in Moment, so you can run the export as often as you like.