# Employee reports out of bexio ## One clear hours report per person, built from your bexio time – with overtime and undertime, vacation, public holidays and an expected-versus-actual comparison, calculated for you. {#pro-mitarbeitende-person-ein-klarer-stundenrapport-aus-deinen-bexio-zeiten-mit-uber-und-unterzeit-ferien-feiertagen-und-soll-ist-vergleich-automatisch-berechnet src=9f5a3538} ## A clear hours report per person {#ein-klarer-mitarbeiter-stundenrapport src=3316e107} ^^ Per person This is how plain [bexio time tracking becomes a real working-time analysis](/en/analyse-time-tracking/): every person gets their own hours report, laying out the time recorded in bexio in a form anyone can follow – day by day, and summed across the whole period. You can analyse employee hours straight out of bexio, without recording them again anywhere. Managers and employees then look at the same traceable figures instead of holding two versions of a spreadsheet against each other. **What is in every report:** - Actual hours worked, straight from bexio time tracking - Expected hours, from the weekday hours you configured - The balance between the two – stated plainly as overtime or undertime - A calendar heatmap and a weekly view for a quick read ## Who employee reports pay off for {#fur-wen-sich-mitarbeiter-rapporte-lohnen src=a48f44da} ^^ This fits you if The employee hours report is meant for companies already recording their time in bexio who need a clean working-time analysis per person – typically SMEs, agencies and service providers with several employees. If you keep a spreadsheet template per employee today, this replaces exactly that file. It earns its place wherever employee hours have to be reviewed regularly: before an annual review, for payroll, in a discussion about overtime and remaining vacation, or when management wants to know how the team stands against its expected hours. If what you mainly need is billing towards clients, the [work report](/en/work-report/) is the better place to start. ## Vacation, public holidays and expected hours, counted for you {#ferien-feiertage-und-soll-arbeitszeit-automatisch src=fd6d2be4} ^^ Counted automatically An hour balance is only correct if vacation and public holidays are handled correctly. mReport takes both from your central base data: the public holidays come from the company holiday calendar kept for that year, and where the day before a holiday counts as shortened in your company, that reduced expectation goes into the calculation too. Vacation taken is measured against the recorded vacation entitlement in the same pass – remaining vacation and the hour balance come from one source and cannot drift apart. You maintain these rules once a year, not once per report and not once per person. Your time in bexio is left unchanged; mReport only reads it, as the [privacy policy](/datenschutz/) describes. ## Calculating overtime – on an example month {#uberzeit-berechnen-an-einem-beispielmonat src=98c9768a} ^^ Balance Rather than arguing about numbers, the report shows how the balance came about. A real example from the demo report for July 2026: :: 184.00 h | Expected hours :: 171.50 h | Hours worked :: −8.00 h | Overtime paid out :: −20.50 h | Overtime balance The arithmetic goes through step by step: 171.50 h worked against 184.00 h expected gives −12.50 h. From that come the 8.00 h paid out as overtime on 23 July – hours already compensated must not show up again in the open balance. What is left is the reported balance of −20.50 h. That replaces the spreadsheet otherwise kept per person – including the formulas that have to be adjusted every time the year turns. Every one of these figures can be traced back to the individual day, and the same expected-versus-actual comparison carries on across the whole year and across year boundaries. The report states the vacation in the same breath – in this example 97.50 h taken and 102.50 h available. How many employee reports your plan includes is on the [pricing page](/en/pricing/). ## The finished report as a PDF {#der-fertige-rapport-als-pdf src=6473f542} ^^ Ready to hand over Every report exports as a PDF – in the same layout you see here: with the company logo, the recipient, the period, the working-time and vacation figures and the overtime paid out. The document is ready to send, print or file; there is nothing to rework. That takes the employee report straight into the annual review, into payroll or into the personnel file. How the export works for every report type is on the [PDF export page](/en/pdf-export/). ## Even when something changes mid-year {#auch-wenn-sich-mitten-im-jahr-etwas-andert src=506fc8ab} ^^ Real working years A year rarely runs cleanly from January to December. These are the points where the hand corrections in a spreadsheet come from – and exactly what mReport takes off you. ### The workload changes If somebody moves from 100 to 80 percent in June, that must not distort the yearly balance. For changes like this you record a further dataset with its own validity period: every month is calculated under the rules that applied at the time. ### Overtime is paid out Overtime that has been paid out can be recorded as a payment. It is counted in the balance, so the overtime reported still matches what is genuinely still open. ### Several years in view Overtime does not disappear on 31 December. Balances, vacation entitlement and vacation taken can be analysed across year boundaries – including the comparison with the previous year.