Export industry and compensation data for ISAB, Reka, and timber construction
SwissSalary contains three industry-specific export reports: the ISAB Interface for construction industry data, the Reka-Check - Interface for compensation data, and the Interface Timber construction CSV for carpentry and related businesses. Each export creates a file with its own filters and control mechanisms. Use the exports at the reference dates required by ISAB, Reka, or the timber construction association, after payroll periods within the export period are posted.
Prerequisites
- Posted payroll periods exist within the export period.
- Employees are assigned to the required departments, allocation groups, and salary classes.
- For the ISAB export: identification document types and LMV salary classes are defined.
- For the Reka export: language codes and statistics codes are maintained.
Export ISAB data
The ISAB Interface creates a ZIP archive with an Excel template, the employee data, and the related employee photos or documents for the information office for occupational safety in the construction sector.
- Open the ISAB Interface report.
- If necessary, filter by Allocation Group, Employee No., Department, or Salary Class.
- Configure the options.
| Field | Description |
|---|---|
| Excel Import File | The path to the output file. The field is read-only; use the assist function to select it. |
- In the Allocation area, assign the LMV salary classes.
| Field | Description |
|---|---|
| Document type - identification card | Document type for identifying the employees. Mandatory field. |
| A - Construction-Skilled worker | Salary class for skilled construction workers. |
| B - Construction worker with expertise | Salary class for construction workers with expertise. |
| C - Construction worker | Salary class for unskilled construction workers. |
| Q - Skilled construction worker | Salary class for qualified skilled construction workers. |
| V - Foreman | Salary class for foremen. |
- Run the report.
The result is a ZIP archive (ISAB.zip) that contains the Excel template, the employee data, and a subarchive with photos and documents.
Export Reka-Check data
The Reka-Check - Interface creates a text file with compensation information for Reka (Swiss Travel Fund).
- Open the Reka-Check - Interface report.
- If necessary, filter the company scope by Name.
- Configure the options.
| Field | Description |
|---|---|
| Reference date | The reference date for the employment status. Mandatory field. SwissSalary proposes the work date. |
| Free Field 1–4 | Up to four statistics codes that are written to the file as additional information. |
- Run the report.
The default file is named SwS2REKA.txt. The report processes all companies included in the filter and writes the language assignment automatically based on the employee language code (D/F/I/E).
Hinweis
After the export, SwissSalary shows the number of employees written to the file.
Export timber construction data
The Interface Timber construction CSV creates CSV files for the industry statistics of carpentry businesses, cabinetmaking shops, roofing companies, and related businesses.
- Open the Interface Timber construction CSV report.
- If necessary, filter by Employee No., Department, or Allocation Group.
- Configure the mandatory information.
| Field | Description |
|---|---|
| Year Ending Date | Reference date for the statistics year. Mandatory field. |
- In the optional Assignment departments area, assign department codes to the business areas.
| Field | Description |
|---|---|
| Administration | Department code for administration. |
| Timber construction | Department code for timber construction. |
| Cabinetmaking | Department code for cabinetmaking. |
| Roofer | Department code for roofing. |
| Sawmill | Department code for the sawmill. |
| Solid construction | Department code for solid construction. |
| Architecture GC | Department code for architecture and general contracting. |
- Run the report.
The report creates a detail file and a summary file in CSV format.
Check the export result
Check the following for every export:
- Reconcile the output data and the reference date with the requirements of the recipient.
- Employees with missing assignments (salary class, department, statistics code).
- The number of exported records compared with the expected number of employees.
- For ISAB: the assigned LMV salary classes and the identification document type.
Wichtig
SwissSalary creates the files but doesn't submit them automatically. Check the content before you forward the file to the recipient.
Good to know
- If assignments of the salary class, department, identification document type, or statistics code are missing—employees or fields are missing from the file or the report.
- If the identification document type for ISAB is missing in the employee file—the ZIP archive is unusable.
- SwissSalary only creates the required data and files—forwarding them to the respective recipient is your responsibility.