With Fluida, you can export the attendance data of all users in different file formats. Do you have to send the data for the month to the payroll department? Do you need annual attendance for statistical purposes?
Find out how to do this!
To access the feature, go to Company > Settings > Export data.
Choose the data to export
Use the first four drop-down menus to set which data to export.
→ Which data do you want to export?
Attendance: all data, including vacation, leave, non-matching attendance, etc.
Timestamps clocking in and out: entry and exit times, and the totals of the hours recorded.
Note: timestamps can only be exported in Excel format (.xls).
→ Whose data do you want to export
Choose whether to export data from the whole company, a workplace, a team or a specific person.
Choose whether to export a specific month or a full year.
→ Month or year
Based on the period you have chosen, you can select which month or year you want to export.
💡 In the case of a month still in progress, the future days are exported with the attendances predicted by the shifts assigned to each user.
In which format should I export data?
With the last two fields, you can choose different file formats and the formatting of hours and minutes.
→ File type
With Fluida, you can export attendance in different formats. From classic Excel files to Zucchetti web payrolls, the app is always updated with the most popular file types.
Complete Excel: the file contains the details of all regular, planned and recorded hours, including matching, absences without justifications, vacations, etc.
💡 If you choose annual export, each month will be contained in a different sheet
Simplified Excel: contains a selection of the main fields, displayed in landscape mode.
In addition, you have at your disposal CSV, Zucchetti Paghe Web, Inaz (Pay and Lul), Sistemi JOB (Attendance, Items and Reasons) and Team System formats, depending on the extensions activated.
►Read here for more information about extensions.
You can choose whether to export the data in time format (hh:mm) or decimal format (for example, 1h30' corresponds to 1.5 hours).
What do these items mean?
To properly read the exported data, let's take a look at some of the app mechanisms and the items you will find in the files.
Fluida tracks the attendance of users and compares it with the assigned shifts, taking into account any company closures, permissions entered, etc. Fluida considers these hours to be matching.
On the contrary, if, within a day, there are hours of absence or extra attendance that are unjustified, Fluida reports them as non-matching hours.
An example of complete data export. Click on the image to download an example of complete data export. ↓
A1: This field shows the user's registration number
Regular Hours: The number of hours scheduled by the shifts assigned to a user (net of company closures or any absences). The hours are divided into "in the workplace" or "remote" hours.
Note: if the timestamp feature is active, this field shows the matching hours of the day.
Scheduled Hours: includes shifts assigned, justifications entered for the period you are exporting, and company closures.
Justifications: the extra hours of absence and attendance that a user requests with the "+" button (from the app) or "+ new" (from the desktop), entering one of the justifications present in the absence/attendance section.
Hours tracked: the hours tracked via SMART timestamp clocking in and out (actual working hours). To be compared with the Scheduled Hours field.
Non-matching attendance: Fluida tracks the actual working hours of a user, through his or her timestamps, and compares them with the shifts assigned to that user. If the actual hours exceed the total assigned hours, and the user has not entered a justification regarding overtime, the extra hours are reported as non-matching attendance.
Unjustified absence: unlike non-matching attendance, if a user's actual working hours are less than the total expected by his or her shifts, and no justification has been entered for those hours, Fluida reports the difference as an Unjustified Absence.
An example of a timestamp export. Click on the image to download an example of a timestamp export. ↓
► Find out how to timestamp clock in and out with Fluida.
► Read about how to enable app extensions.