Analytics

Time reports that make decisions easier

From absences through project hours to time accounts: every figure that matters, clearly prepared and exported in seconds. For teams of 10 to 100 people.

  • Excel export in under 5 seconds
  • GDPR compliant, hosted in Germany
  • No training needed, ready to use at once

An end to Excel lists and manual collation

For the month end, for keeping projects in check or for answering your team, you need quick answers, not hours of Excel work.

Problem

Excel chaos at the month end

Holiday days, sick days, overtime: all collected by hand from different lists. Every single time.

Problem

No overview of projects

How much time went into which project? Are we within budget? Without a report there are no answers.

Problem

People ask about their time account

How much overtime do I have? What is my balance? Every question means recalculating by hand.

Solution

Every report in 3 clicks

Pick a period, set the filters, export. MetronHR builds every report automatically and calculates to the minute, including the break deduction under the Working Hours Act.

Working time per weekAverage39:36h, target40:00h
CW36, 30:30h
252627282930313233343536

Result

Reports at the push of a button

With MetronHR the month-end reports are ready in minutes: pick a period, export, done.

EmployeeTargetActualSaldo
Sophie KramerEmpfang160:00h162:15h+2:15h
Jonas KellerTreatment160:00h158:30h-1:30h
Greta WinklerAdministration120:00h121:00h+1:00h
Mara BrandtTreatment160:00h173:45h+13:45h
Moritz LangEmpfang160:00h159:15h-0:45h
Nele AhrensLabor128:00h130:30h+2:30h
Ben OsterlohTreatment160:00h156:00h-4:00h
Nora VogelAdministration80:00h81:30h+1:30h
Lena FischerLabor160:00h164:30h+4:30h
Tim WagnerEmpfang120:00h118:45h-1:15h
Ida NovakTreatment160:00h161:30h+1:30h
Paul RennerAdministration160:00h157:15h-2:45h
12 Employees1728:00h1744:45h+16:45h

This is how reports work in MetronHR

No complicated configuration. No training. Just open it and use it.

Step1

Pick a period and filters

Month, quarter, year or a free range. Filter by person, department or project. Every setting lives in the URL, so links can be reused.

Configured once, reusable at any time
Narrow the report12 People3 von 12
August 2026Treatment and labBalance above 2:00h
Sophie Kramer+2:15hJonas Keller-1:30hGreta Winkler+1:00hMara Brandt+13:45hMoritz Lang-0:45hNele Ahrens+2:30hBen Osterloh-4:00hNora Vogel+1:30hLena Fischer+4:30hTim Wagner-1:15hIda Novak+1:30hPaul Renner+0:30h
Extra hours in treatment and lab+20:45h

Step2

Check and visualise the figures

Clear tables with every detail. Budget monitoring with a traffic light (green, amber, red). Every figure calculated to the legal rules.

See what matters at a glance
Traffic light accountLimit10:00h, 1 above that
-16h-10h0h+10h+16h

Step3

Export with one click

CSV for quick further processing, or Excel with metadata (who, when, which period). The download starts at once.

Ready in 5 seconds, for accounting or for management
Export the month end as
ExcelTime account per personCSVRaw data for the accountantPDFOverview to sign off
Contains per personName, staff number

Every report that matters, in one place

Three report categories cover the most common needs, without unnecessary complexity.

Absences

Holiday and sickness reports

For accounting and the month end

Every absence by person, department or period. With holiday days, sick days and special leave. Including a detail view per person.

Projects

Project time reports

Budget control and how the work is distributed

Hours recorded per project, how the work is distributed (frontend, backend, design and so on), budget monitoring with a traffic light (on plan, at risk, over budget).

Time accounts

Employee time accounts

Overtime and time off in lieu, in the open

Target against actual, how overtime develops, a calendar view with working days and absences. People can see their own figures at any time.

Templates

Build your own report and reuse it

Save the filters you set once and call them up next time

Period, person, department, client, project, service, billable flag and calculation method can be combined into a template, saved under a name and shared with others. The second time round, the month end is one click instead of a fresh assembly.

Filters

Flexible period filters

From a month to a year, whatever you need

Month, quarter, half year, year or a custom range. With forward and back navigation and an offset ("last year", for example).

Export

Export in several formats

CSV, or Excel with metadata

CSV for quick further processing. Excel with a header (who exported, when, which period), ready for payroll.

Calculation

Calculations that follow the ArbZG

ArbZG compliant, with breaks deducted

Breaks deducted automatically under the Working Hours Act. Public holidays and working time models taken into account.

Visualisation

Charts and overviews

Understand the figures instead of staring at them

Pie charts for the distribution of work, progress bars for budget monitoring. All of it responsive and printable.

Access

Role-based permissions

Role-based access protects the data

Management and accounting see every figure. Team leads see their team. Everyone else sees only their own time account. GDPR compliant.

Who gets something out of MetronHR reports?

Different roles, different needs, one piece of software.

Owner or director

A project overview for better decisions

Which projects are going well? Where is the budget about to break? Where are we putting in too much time?

An overview of every project, with budget status (green, amber, red) and how the work is distributed. At a glance.

Team lead

Team time accounts always in view

People ask about their overtime balance. Every question means recalculating by hand and searching Excel lists.

Everyone sees their own time account (target, actual, overtime, calendar). You see the team overview. No more questions.

Employee

See your own hours and overtime

How much overtime do I have? What is my balance right now? Until now you had to ask.

Your own time account with target against actual, overtime and a calendar view, open at any time, without having to ask.

Accountant

Clean exports for payroll

Every month, incomplete or faulty timesheets from the client.

Finished Excel exports with all working hours, absences and overtime, ready for payroll at the push of a button.

Exports that open anywhere

MetronHR exports your data as CSV and Excel, file formats that open in every common spreadsheet program.

CSV (works everywhere)
Excel (XLSX)
Opens in Google Sheets
Opens in Excel 365
Opens in Numbers (macOS)
Opens in LibreOffice Calc

Security and data protection

Reports contain sensitive data. Data protection is the default here.

  • German servers (GDPR compliant), your data stays in Germany
  • Role-based access control: only those who may, see sensitive data
  • Complete documentation of every export: who downloaded which report and when

Privacy Policy

GDPR compliant

Made in Germany, hosted on German servers
Trust Center

Frequent questions about reports

Answers to the main questions about reports and exports.

Three categories: 1) absence and sickness reports (for accounting), 2) project reports (budget, distribution of work), 3) time accounts (overtime, target against actual per person).

Yes, every report can be exported as Excel (XLSX) or CSV. Excel exports carry metadata (who, when, which period) for complete documentation.

MetronHR shows the budget status as a traffic light: green = under 80% used (on plan), amber = 80 to 100% (at risk), red = over 100% (over budget). Including a chart of how the work is distributed.

Yes, everyone has access to their own time account with target against actual, overtime and a calendar view. Team leads see their team, management sees everyone.

Yes, every calculation takes account of the break rules under the German Working Hours Act (ArbZG), public holidays and working time models.

Reports load at once. Exports (CSV or Excel) are ready in a few seconds, even with 100 people and a full year of data.

The reports belong to every plan: time account, project reports and payroll, each with Excel and CSV export. The analytics module with its four reporting axes, the drill-down to the single entry and the saved filter templates belongs to the Professional plan. During the trial you can try it out with no obligation.

Question not answered here? Every step is explained in the help centre.

Ready for reports that actually help?

Try MetronHR free for 14 days. No credit card, no tricks. Every report included.

Questions? Send us a message