Skip to main content
All CollectionsTime management and payrollAccounting report
What's in each column of the Skello report?
What's in each column of the Skello report?

This article explains how to read and understand the payroll report on Skello

Badïa avatar
Written by Badïa
Updated over a week ago

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.

Did this answer your question?