The Timesheets Report allows managers and staff to view, analyze, and export logged working time. It shows how much time each staff member spent on tasks, which projects and customers are involved, and provides totals.
Main Interface Elements
| Element | Description |
|---|---|
| My Timesheets button | Redirects to the personal timesheets page for the current user. |
| Chart | Bar chart (Chart.js) showing total logged time over the selected period. |
| Filter panel | Dropdowns and date pickers to narrow down data. |
| Data table | List of timesheet entries with details (staff, task, times, notes, etc.). |
| Table tools | Export, reload, search, “Group by Task” toggle, pagination, sorting. |
| Footer total | Sum of logged time in hh:mm and decimal format. |
Filter Panel Details
| Filter | Options / Behavior |
|---|---|
| Range | Today, This Month Logged Time, Last Month Logged Time, This Week Logged Time, Last Week Logged Time, Period (custom). |
| Period (From / To) | Appears when “Period” is selected. Use date pickers to set a custom range. |
| Staff Member | Dropdown – choose a specific staff member or “All Staff Members”. |
| Customer | Ajax autocomplete field – start typing customer name. |
| Project | Multiple‑select ajax field – search and select one or more projects. |
| Apply button | After setting filters, click Apply to update the chart and table. |
Chart
- Displays total logged time aggregated by day or staff member (depending on system configuration).
- Hover over bars to see exact values.
Data Table Columns
| Column | Description |
|---|---|
| Staff Member | Clickable name that opens the staff profile. |
| Task | Task name (clickable – opens task modal). Shows task status (e.g., In Progress, Complete). |
| Timesheet Tags | Tags attached to the timesheet entry. |
| Start Time | Date and time when work started (format dd-mm-yyyy hh:mm). |
| End Time | Date and time when work ended. |
| Note | Optional comment entered by the staff member. |
| Related | Linked object – usually a project (clickable). |
| Time (h) | Duration in hh:mm format (e.g., 02:00). |
| Time (decimal) | Duration in decimal hours (e.g., 2.00). |
Footer Total
- Total Logged Time: sum of all displayed entries in
hh:mmand decimal format.
Table Tools
| Tool | Description |
|---|---|
| Show X entries | Choose rows per page (10, 25, 50, 100, All). |
| Export | Export data to CSV, Excel, or PDF. |
| Reload | Refresh the table data. |
| Search | Global search across all table columns. |
| Group by Task | Toggle switch – when ON, timesheet entries are grouped by task to see total time per task. |
| Pagination | Previous / Next links and page numbers. |
| Sorting | Click any column header to sort ascending/descending. |
How to Use (Step by Step)
- Select a time range from the Range dropdown. For a custom range, choose Period and set From date and To date.
- Optionally filter by Staff Member, Customer, and/or Project. You can leave any filter empty to include all.
- Click the Apply button.
- The chart updates automatically; a bar chart shows logged time distribution.
- The data table shows all matching timesheet entries.
- Use the Group by Task toggle to aggregate time per task.
- Use search, sorting, and pagination to navigate the table.
- Click Export to download the report.
- The footer total gives the overall logged time for the current filter set.
Tips
- Use Customer filter to see time spent on a specific client.
- Use Project filter to track project budget vs. actual time.
- Group by Task is helpful to identify which tasks consume the most hours.
- Today or This Week presets are useful for daily stand‑ups or weekly reviews.
- Export weekly reports for further analysis in spreadsheets.
Frequently Asked Questions
Q: Why are some timesheet entries missing from the table?
A: Check the filters – ensure the date range, staff member, customer, and project selections are correct. Also note that “Group by Task” may combine entries.
A: Check the filters – ensure the date range, staff member, customer, and project selections are correct. Also note that “Group by Task” may combine entries.
Q: How can I see time for a single day?
A: Choose Period, set both From and To dates to the same day, then click Apply.
A: Choose Period, set both From and To dates to the same day, then click Apply.
Q: The chart is empty. What should I do?
A: Widen the date range, select “All Staff Members”, or ensure there are timesheets for the chosen filters.
A: Widen the date range, select “All Staff Members”, or ensure there are timesheets for the chosen filters.
Q: Do I need to click Apply after changing a filter?
A: Yes – the report only updates when you click Apply.
A: Yes – the report only updates when you click Apply.
Q: What does “Time (decimal)” mean?
A: It shows the same duration but in decimal hours (e.g., 1 hour 30 minutes = 1.50). Useful for payroll or billing calculations.
A: It shows the same duration but in decimal hours (e.g., 1 hour 30 minutes = 1.50). Useful for payroll or billing calculations.
.webp)