Create time reports
Analyze tracked time using filters, grouping, and sorting in time reports, then create timesheets, export data as Excel or PDF, and manage invoicing workflows
In time reports, you can analyze tracked time in detail using filters, groupings, and totals. From here, you can create timesheets, export time entries, mark time as invoiced, or start the invoicing process using integrated invoicing tools.
🔐 Global time reports are available starting with the Professional plan.
Key benefits and use cases
-
Analyze time entries using filters, grouping, totals, and sorting
-
Create timesheets by printing or saving 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 workflows with "Auf abgerechnet setzen" and "Rechnung erzeugen"
The Zeitauswertungen menu
You'll 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.
In 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: Shared reports can only be deleted by the report's creator or an admin.
How to create and save reports
-
Go to Zeitauswertungen.
-
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.
-
Enter a name for the report in the top left.
-
Click Auswertung speichern in the top right.
You don't need to save your report to export it or create invoices.
Tip: You can display saved time reports as dashboard widgets in the Home section.
Configure a time report
The report options are divided into four sections:
-
Time period
-
Data filters
-
Sorting and grouping
-
Displayed columns
Time period
Choose the time period to include in the report. awork offers both relative and absolute options:
-
Absolute time period (e.g., August): The report always shows data for that month, but you can switch between months manually at the top.
-
Relative time period (e.g., 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 time zone selector in the top right of the time reports.
Here, you can choose which time zone to use when displaying tracked time and assigning time entries to local calendar days:
-
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.
Data filters
You can filter by the following criteria:
-
User
-
Project
-
Tags
-
Activity
-
Billing status
-
Time entry note
You can combine any filters. They're always applied using AND logic, for example, invoiced time entries and a specific activity.
Sorting and grouping
Choose how to organize your list:
-
Choose a grouping (groups appear as headings in the list)
-
Choose a field to total by (e.g., total by user and expand the entries below)
-
Sort list by (ascending or descending, including by fields you haven't chosen to display)
-
Set rounding (how entries are rounded). You can choose between two options:
- Nächstes: Rounds up or down to the nearest full unit (15 minutes, 30 minutes, or an hour). For example, 1:17 becomes 1:15.
- Aufrunden bis: Always rounds up to the next value. For example, 1:17 becomes 1:30.
Note: If you group or total by task list, set a primary list for the time report when tasks appear in multiple task lists.
Choose displayed columns
Choose which columns to show in the table. To do this, click the column icon on the right above the time entries, below the summary.
Only columns available for selection can be displayed. You can't add additional columns.
Charts in the summary
The summary shows totals by billable status:
-
Total (purple): Total time for the selected period
-
Billable (yellow): Tracked time that is billable
-
Invoiced (green): Tracked time that is billable and has been invoiced
-
Non-billable (red): Tracked time that isn't billable
The chart has two settings: a bar chart or matrix, and a pie chart. awork automatically displays the bar chart when the data isn't grouped. Grouped data is automatically shown as a matrix.
Bar chart
If the report isn't grouped, bars show the amount of tracked time. Hover over an entry to see the date and value.
Matrix
If the report is grouped, a matrix is displayed. The rows correspond to the groups. The matrix shows entries for the units being viewed, such as days, and the total for each group at the end. Hover over an entry to see the date and value.
For readability, values are rounded to the nearest full hour when 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, not-yet-invoiced, and already-invoiced time.
- If the report is grouped, the chart shows the proportions of the group totals. Hover over a section to see its value and percentage.
Export time reports
1. As a PDF timesheet
You can print your report or save it as a PDF.
-
Filter the report as needed.
-
Click the document icon in the top right.
-
Use your browser's print dialog to print or save as PDF.
Groups, totals, and column filters are included.
Tip: Add your logo under Einstellungen > Allgemeines to display it on the PDF.
2. As an Excel spreadsheet (.xlsx)
You can export raw data or create a formatted export. To do this, 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, totaling, or sorting data. You can also choose columns and decide how data should be rounded.
How to edit time entries in time reports
Edit individual time entries
Click the action button on the right of a time entry, then select Bearbeiten to open the editing window.
Edit multiple time entries at once
You can edit multiple time entries at once, for example, to mark them as invoiced. Depending on your permissions in Rechtemanagement, you can change the activity, project, task, or user for multiple time entries at once, or delete time entries.
-
Hover over the left edge next to the time entries or group titles, then use the checkboxes to select individual entries or entire groups.
-
Use the floating action bar at the bottom to perform actions or clear your selection.
Note: Currently, you can't select every time entry with a click. Grouping lets you select time entries within each group with a click.
Mark time as invoiced
-
Click the dollar icon in the top right.
-
Select Auf abgerechnet setzen.
Note: Only time entries that haven't already been marked as invoiced can be transferred to invoices.
How to create invoices from time reports
You can bill time using the integrated invoicing tools.
-
Click the dollar icon in the top right.
-
Select Rechnung erzeugen.
Note: Invoiced time entries generally can't be edited anymore.
Only admins can change a time entry that's already marked as abgerechnet back to nicht abgerechnet, so it can be edited again.
Learn more about invoicing 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 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 isn't marked as abgerechnet. 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 time period.
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 to export it or create invoices.
Who can delete shared reports?
Shared reports can only be deleted by the report's creator or an admin.
