About IQ export

In Messenger, the IQ export is actually a .csv (comma separated value) file, with a , (comma) as the value separator.  It contains the Timesheet information between the selected dates and for the selected employees.  This file can be imported into IQ Payroll.

Here is an example of the IQ Export

Figure 1

The format of the row is as follows:

Column	Details	Example
1	Reference/ID Number	1
2	NT	45.00
3	OT1	4.6
4	OT2	2.0
5	OT3	1.5
6	OT4	1.1
7	OT5	1.0
8	OT6	0.5
9	OT7	0.25

The hours are in a decimal format, so therefore 10 hours and 45 minutes will be shown as 10.75