Skip to main content
Export the data

How to export attendance and clocking data

Fulvia Chesi avatar
Written by Fulvia Chesi
Updated over 4 months ago

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.

  • Clocking in and out: entry and exit times, and the totals of the hours recorded.

Note: clockings 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.

Period

  • 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.

Formatting

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.

💡 Make sure that the Clock-in clock-out feature is active: the certified clockings allow Fluida to track attendance and generate export files in the most complete way possible.

An example of complete data export. Click on the image to download an example of complete data export.

  1. A1: This field shows the user's registration number

  2. 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 clock-in clock-out feature is active, this field shows the matching hours of the day.

  3. Scheduled Hours: includes shifts assigned, justifications entered for the period you are exporting, and company closures.

  4. 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.

  5. Hours tracked: the hours tracked via clocking in and out (actual working hours). To be compared with the Scheduled Hours field.

  6. Non-matching attendance: Fluida tracks the actual working hours of a user, through his or her clockings, 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.

  7. 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 clocking export. Click on the image to download an example of a clocking export.

► Find out how to clock in and out with Fluida.

Read about how to enable app extensions.

Did this answer your question?