Skip to main content

Create time reports

Analyze recorded time entries using filters and grouping in Zeitauswertungen to create timesheets and export data as Excel or PDF for invoicing

Time reports let you analyze recorded time in detail using filters, grouping, and totals. From here, you can create timesheets, export time entries, mark them as invoiced, or start creating invoices using integrated invoicing tools.

🔐 Global time reports are available starting with the Professional Plan.


Main benefits and use cases

  • Analyze time entries using filters, grouping, totals, and sorting

  • Create timesheets by printing or exporting a PDF directly from the report

  • Export data as an Excel file (.xlsx) or PDF extract

  • Edit time entries individually or in bulk, depending on your permissions

  • Support invoicing processes with "Auf abgerechnet setzen" and "Rechnung erzeugen"


The Zeitauswertungen menu

You can find Zeitauswertungen in the main menu under Workspace.

  • Meine Auswertungen contains all the reports you've created

  • Freigegebene Auswertungen contains reports other users have shared with you. This section only appears if there are reports in it.

From the overview, you can create, search for, and sort reports by name or last edited date, in ascending or descending order.

Duplicate, share, and delete a report

The action button on the right of each saved time report gives you access to these options:

  • Duplizieren

  • Auswertung freigeben

  • Löschen

The available options may vary depending on your permissions, since you can only see data you have access to.

Note: Only the person who created a shared report or an admin can delete it.


How to create reports

  1. Go to Zeitauswertungen

  2. Click + Auswertung in the top left, or choose one of the preconfigured Sofort-Auswertung options: Monatliche Erfassungsübersicht, Erfasst vs geplant, Abrechenbarkeit pro User, Bereit zur Rechnungsstellung

Save a report

  1. Enter a Name for the report in the top left

  2. Click Auswertung speichern in the top right

You don't need to save your report to export data or create invoices.

Tip: You can display saved time reports as a Dashboard widget in the Home area.


Configure a time report

The settings for creating reports are divided into four sections. The time and data filters determine which time entries appear in the report. Sortierung und Gruppierung and Angezeigte Spalten determine how those entries are displayed:

  1. Zeitbereich

  2. Datenfilter

  3. Sortierung und Gruppierung

  4. Angezeigte Spalten

Zeitbereich

Choose the time period to include in the report. awork offers relative and absolute options:

  • Absoluter Zeitraum (for example, August): The report always shows data for this month, but you can manually switch between months at the top.

  • Relativer Zeitraum (for example, Diesen Monat): The report always shows the current month.

Report time zone

If your account time zone differs from your workspace time zone, you'll find a Zeitzonenauswahl dropdown menu in the top right of the time reports.

Here, you can choose the time zone used to display recorded time and determine which local calendar day a time entry is assigned to:

  • Meine [deine ausgewählte Zeitzone]: Uses your personal account time zone.

  • [Workspace-Name] [Workspace-Zeitzone]: Uses your workspace time zone.

This affects both the report and the export. By default, awork uses the time zone set in your account settings.

Datenfilter

You can filter by the following criteria:

  • User*in

  • Projekt

  • Tags

  • Tätigkeit

  • Abrechnungsstatus

  • Notiz der Zeiten

You can combine all filters. They're always applied using AND logic, for example, invoiced time entries and a specific activity. A data filter only limits which time entries are displayed. It doesn't add a column to the table. To do that, use Angezeigte Spalten.

Sortierung und Gruppierung

Here, you can choose how your list is organized:

  • Gruppierung auswählen (groups appear as headings in the list)

  • Summierung nach Feld wählen (for example, total by user and expand the entries underneath)

  • Liste sortieren nach (ascending or descending, including by fields you haven't chosen to display)

  • Rundung festlegen (how entries are rounded). You can choose between two options:

    • Nächstes: Round up or down to the nearest unit (15 minutes, 30 minutes, or an hour). For example, 1:17 becomes 1:15.
    • Aufrunden bis: Always round up to the next value. For example, 1:17 becomes 1:30.

Note: If you group or total by task list, you should set a primary list for the time report when tasks appear in multiple task lists.

Choose Angezeigte Spalten

Choose which columns to display in the table. To do this, click the column icon on the right, below the summary and above the time entries.

You can only display columns that are available to select. You can't add additional columns.

Important: Datenfilter and Angezeigte Spalten are separate settings. For example, filtering by Tätigkeit under Datenfilter won't automatically show the activity as a column in the table. To display the activity in the report, select it under Angezeigte Spalten.


Charts in the summary

The summary shows totals by billability:

  • Gesamt (Lila) Total time for the selected period

  • Abrechenbar (Gelb) Recorded time that is billable

  • Abgerechnet (Grün) Recorded time that is billable and has been invoiced

  • Nicht abrechenbar (Rot) Recorded time that isn't billable

There are two chart settings: bar chart or matrix, and pie chart. awork automatically displays the bar chart when the data isn't grouped. For grouped data, it automatically uses the matrix view.

Bar chart

When the report isn't grouped, bars show the amount of recorded time. Hover over an entry to see the date and value.

Matrix

When the report is grouped, a matrix is displayed. The rows correspond to the groups. The matrix shows entries for the units being analyzed, such as days, followed by the total for each group. Hover over an entry to see the date and value.

To improve readability, all values are rounded to whole hours if there isn't enough space. Hover over a value to see the exact amount.

Pie chart

  • If the report isn't grouped, the chart shows the proportions of non-billable time, time that hasn't been billed yet, and time that has already been billed.
  • If the report is grouped, the chart shows the proportions of the group totals. Hover over a segment to see its value and percentage.

Exporting time reports

1. As a PDF timesheet

You can print your report or save it as a PDF.

  1. Apply the filters you need to the report

  2. Click the document icon in the top right

  3. Use your browser's print dialog to print or save as a PDF

Groups, totals, and column filters are included.

Tip: Add your logo under Einstellungen > Allgemeines to have it appear on the PDF.

2. As an Excel spreadsheet (.xlsx)

You can export raw data or create a formatted export. To do so, click the download icon in the top right.

Tip: Use the options to format the export (only available for PDF and formatted exports) by filtering, grouping, summing, or sorting data. You can also choose which columns to include and how to round the data.


Editing time entries in time reports

Editing individual time entries

Click the action button on the right side of a time entry, then select Bearbeiten to open the editing window.

Editing multiple time entries at once

You can edit multiple time entries at once, for example, to mark them as billed. Depending on your permissions in permission management, you can change the activity, project, task, or user for multiple time entries at once, or delete time entries.

  1. Hover over the left edge next to the time entries or group titles, then use the checkboxes to select individual time entries or entire groups.

  2. Use the floating action bar at the bottom to perform actions or clear your selection.

Note: Currently, you can't select all time entries with a click. When the entries are grouped, you can select time entries in each group with a click.


Marking time as billed

  1. Click the dollar icon in the top right

  2. Select Auf abgerechnet setzen

Note: Only time entries that haven't been marked as billed yet can be transferred to invoices.


Creating invoices from time reports

You can invoice time using the integrated invoicing tools.

  1. Click the dollar icon in the top right

  2. Select Rechnung erzeugen

Note: Invoiced time entries generally can't be edited.

Only admins can change a time entry that's already marked as billed back to not billed, so it can be edited again.

Learn more about billing time here.


FAQ

Are breaks (paused time) shown in time reports?

Paused time isn't shown in the report by default. Click Bearbeiten in the action menu for a time tracking entry to view the paused time or duration. You can't change paused time, but you can delete it. You can only delete it if the time entry hasn't been marked as billed. Find more information here.

Can I report on the planned effort for tasks?

Yes. You can add a column for this. It shows the total planned effort for a task, regardless of the report's selected date range.

For example, if a task has a total planned effort of 10 hours but the report only covers the current month, the full 10 hours will still be shown.

Why is a URL visible in my PDF?

If a link appears at the bottom of the PDF, for example, it's related to your print settings. Disable this information in the print dialog.

Do I need to save a report before exporting it or creating an invoice?

No. You don't need to save your report before exporting it or creating invoices.

Who can delete shared reports?

Only the person who created the report or an admin can delete shared reports.

Last updated HappySupportPowered by happysupport.ai
© 2026 HappySupport. All rights reserved.