Export for your labour consultant
Included in the Max plan: Employee management is included in the FatturaSmart Max plan at €149.99/year + VAT for up to 5 employees (which also includes unlimited invoicing, warehouse, Sistema TS and public APIs). It is turned on after accepting the data processing agreement. Discover the Employees module.
At the end of the month your labour consultant (consulente del lavoro) needs attendance, leave and expenses to prepare the payslips. With FatturaSmart you no longer have to collect them by hand: the file goes out automatically by email every month, and you can download it whenever you want in CSV, XLSX or the code-based payroll layout. Your consultant doesn’t need an account.
Step 1: Set the Consultant’s Email
- Go to Employees → Settings, Payroll consultant section
- Enter the Consultant email
- Save
The saved address is not shown. Saving a new one replaces it; saving an empty field removes it.
Note: your consultant receives your employees’ data on your instruction. Make sure the address is correct and that the consultant is authorized to process that data.
Step 2: Map the Codes for the Payroll Software (optional)
If your consultant wants the code-based payroll layout, in Employees → Settings, Payroll software export section, enter the codes they use in their software:
| Field | What it’s for |
|---|---|
| Company code | The code your consultant uses to identify your company |
| Leave type codes | For each leave type (vacation, permits, sick leave…), the matching Code in the payroll software |
| Employee codes | Each employee’s code in the payroll software; when empty the employee number is used |
The payroll layout is a generic CSV with mappable codes: ask your consultant which codes to enter and have them check the first file.
Automatic Monthly Send
If you set the consultant’s email, FatturaSmart sends them the file on the morning of day 2 of every month, with the data for the previous month in XLSX format. The file arrives as an email attachment.
The XLSX file contains three sheets (with Italian names):
| Sheet | Content |
|---|---|
| Presenze (attendance) | Each employee’s day-by-day detail |
| Riepilogo (summary) | The month’s totals per employee: worked hours, overtime and leave hours per leave type |
| Note spese (expenses) | The month’s approved expense reports, for all employees |
Only approved leave and expense reports go into the file.
Send at Month Closing
When you close a month in Employees → Month closing with Close month, the attendance file is sent to your consultant right away, if you set their email. In that case the automatic day-2 send for that month is not repeated.
If you change the month after closing it, FatturaSmart warns you: click Export again to send your consultant the updated file. For details on closing see Attendance and clock-in.
Export on Demand
You can generate the file at any time, for any month.
Step 1: Open the export
Go to Employees → Month closing and, on the month you need, click Export. The Export attendance panel opens.
Step 2: Choose month and format
| Format | Content |
|---|---|
| Excel (xlsx) | The file with the Presenze, Riepilogo and Note spese sheets |
| CSV | Day-by-day attendance, totals per employee and approved expenses in a single semicolon-separated file |
| Payroll (code-based layout for payroll software) | The CSV with the codes you mapped in the settings |
Step 3: Generate and download
Click Generate file. If you set the consultant’s email, the file is also sent to them and you see the destination address; otherwise it’s only generated. Click Download file to save a copy.
Next Steps
- Attendance and clock-in – check the timesheet and close the month
- Payslips – distribute the payslips prepared by your consultant to your employees
Need help?
Reach us on WhatsApp by clicking the icon in the bottom right, or email support@fatturasmart.com.
Frequently Asked Questions
Does my labour consultant need to sign in to FatturaSmart?
No. Your labour consultant doesn't need an account: they receive the attendance file as an email attachment at the address you set in the Employees settings.
When is the file sent to my consultant?
Automatically on day 2 of every month, with the XLSX file for the previous month. If you close the month with Close month, the file is sent at closing and the automatic day-2 send for that month is not repeated.
What does the XLSX file for my consultant contain?
The XLSX file has three sheets: Presenze (attendance), with the daily detail, Riepilogo (summary), with the totals per employee, and Note spese (expenses), with the month's approved expense reports.
Is the file compatible with my consultant's payroll software?
Besides CSV and XLSX, FatturaSmart generates a code-based payroll CSV: you enter the company code and the leave type and employee codes your consultant uses, so the file carries their codes. It is a generic layout with mappable codes, to be checked by your consultant.
