In this article, you'll find details of what's in each column of the first tab of the online report.
The “report” function calculates and summarizes in a spreadsheet, over a given period, the variable elements required for payroll.
How do I access the report?
To access the report in the online area, click on the Report tab. Once on the page, select the desired period start and end dates in the top left-hand corner.
The report can be consulted online at any time to monitor the data it contains, and can be exported to Excel for use in payroll preparation at the end of the period.
The online report consists of seven tabs, which open and close according to what you need to see displayed. Click on the tab of interest to open or close it.
Contractual data
This first tab contains all data relating to the employee's contract of employment:
Employee payroll number
Contract type
Employee's position title
Contract start and end dates
Archiving notes: these are notes left from the employee's file when he/she is archived. When an employee is archived, he/she continues to appear for one month in the report.
This information is entered in the employee's personal and/or contractual data.
Salary data
This tab provides detailed information on payroll:
Monthly hourly volume
Average gross hourly rate
Employee's gross monthly salary
This information is taken from the contractual and salary data in the employee's file.
Hours schedule period
This tab shows the hours worked by the employee each week during the selected period. It shows the weekly total of scheduled hours and employee timesheets. Columns vary according to establishment settings.
If overtime compensation is activated
Period start tracker: balance of the employee's his/her hours counter on the Sunday preceding the start of the selected period.
Number of hours worked each week: additional hours are shown in red, while hours worked less than this are shown in blue.
End-of-period tracker: balance of the employee's tracker on the last Sunday of the selected period. ⚠️ If the tracker is modified or reset to zero, the end-of-period tracker is the tracker balance after modification.
Counter changes: value of the change recorded in this column.
If overtime compensation is not activated
Total breaks taken during the selected period.
Number of additional hours worked per week: only additional hours are shown in red. ⚠️ If the employee has worked fewer hours than stipulated in his/her contract, this information will not appear in the report.
For employees on daily rate contracts, the number of days worked during the period appears week by week.
Premium hours
This tab lists all hours for which payment or recovery will be increased according to the provisions of the collective agreement and the parameters of the establishment.
These hours are isolated for information purposes and to apply specific supplements. They are not to be added to hours worked, as they are already counted as such.
A distinction is made between
Structural additional hours: provided for in an employment contract that exceeds the legal working time of 35 hours, worked and paid in the same way every month.
Exceptional additional hours: worked in excess of the hours stipulated in a full-time employment contract.
Overtime: in the case of a part-time contract, hours worked in excess of those stipulated in the contract.
Tab organization
The Overtime tab is organized differently according to the establishment's parameters:
Total structural additional hours: grouped according to the different increment bands.
Structural additional hours: grouped by collective agreement: 25%, 50%.
Increased overtime hours: 10%, 25%, 50%.
Exceptional additional hours: 20%, 50%.
Night work
Hours worked on Sunday
Holiday hours: all hours worked on holidays appear in the same column. Hours worked on May 1st appear in a separate column.
Total absences period
This tab lists absences planned by employee over the report period.
Column headings are adapted to the categories of absences planned for the period. If a category has not been planned, it does not appear in the report columns (e.g.: authorized absences, sick leave, late arrivals).
Compensation items
Here you'll find a selection of benefits in addition to the employee's salary:
Bonuses/Advances (€): to add a bonus or advance, click on the + to the left of the column and enter the amount added to or withdrawn from pay. For a bonus, enter the positive amount. For an advance, enter the amount in negative (with a - in front).
The amount of the bonus or advance can be modified by clicking on the + again. Add or subtract the value required to adjust the amount. You can also delete the amount entered to add a different one.
You can add a bonus AND an advance over the same period: the amount of each operation is specified on the exported report.
The date entered for adding the bonus/advance corresponds to the month of the start of the report period. This date can be modified if need be. For example: if the report period starts on 02/27, the date proposed for the bonus/advance will be February.
Meals: number of meals paid for (compensatory allowances or luncheon vouchers) or amount of basket bonus to be paid to the employee at the end of the period.
Transport cost: entered in the employee's contractual data in the employee file. Corresponds to the amount paid by the employer each month (generally 50% of the transportation costs incurred by the employee).
Comments
In this tab, you can leave comments for your accountant or payroll manager.
Comments can be exported to Excel, but do not appear anywhere else on Skello.
Once a comment has been added to the report, it can be modified and updated, but cannot be deleted.