Support
Reports and data export
For: Managers
OneShift has four reports under Reports in the side navigation. This guide covers who sees each one, what you can filter and export, and how to read the same data from a BI tool.
The reports and who sees them
Open Reports in the ACCOUNTING group of the side navigation. The menu lists only the reports you may open, and shows nothing if you may open none.
| Report | Who sees it | What it shows | Export |
|---|---|---|---|
| Customer | Billing permission | A customer’s captured statement time and budgets, by project. | Excel |
| Timesheets | Timesheet management permission, or a team lead | One row per member and week, including weeks with no timesheet. | None |
| Detailed | Timesheet management permission, or a team lead | Every time entry, with its status. | Excel |
| Issues | Workspace management permission | Kanban issues across the workspace. | None |
Each report also enforces this on the server, so a link to a report you may not open does not work.
What a team lead sees
With timesheet management rights you see every member. As a team lead without them, the Timesheets and Detailed reports are limited to the members of the teams you lead. SeeTeams, positions and member settings.
Filters work the same way everywhere
- Pick values in the filter bar, then select Apply. The button turns solid when there are unapplied changes.
- Clear all appears once any filter is set.
- Filters and sorting are kept in the page address, so a filtered report can be bookmarked or shared with someone who has access to the same report.
- Customer, Project, Task, Assignee and User pickers include a switch between Active and Archived (or Inactive) entries. They default to active only.
Customer report
The Customer report shows what has been captured on statements for one customer. It needs the billing permission.
Filters
| Filter | Notes |
|---|---|
| Date range | Starts on this month. |
| Customer | Required. Search customers by name. |
| Project | Optional, and available after you pick a customer. Leave it empty for all the customer’s projects. |
What it shows
- Billable and non-billable totals for the whole report, then one block per project with its tasks and entries (Date, User, Billable, Duration, Comment).
- A budget bar per project and task, split into “Current report” and “Previous reports”.
- Results are paged by project. “Page 1 of 3 projects” with Previous and Next. The totals cover all pages.
- “No statement entries found for this customer in the selected month.” when nothing matches.
Export
Export downloads an Excel (.xlsx) file for the customer and date range, and for the chosen project if you set one. It is disabled until a customer and range are selected, and it exports everything in the range, not only the page on screen. There is no row limit. The file’s sheet is “Customer Report”: customer and period at the top with the total charge and total free time, then a table with Date, Project, Task, Member, Comment, Charge and Free.
Timesheets report
The Timesheets report shows one row per member and week, so you can see who has not submitted. It needs the timesheet management permission, or a team lead role.
Filters
| Filter | Notes |
|---|---|
| Date range | Weeks start on Monday. |
| User | Search by name. Choose active, inactive or all members. |
| Status | Open, Submitted, Approved, Rejected or Missing. Pick several to combine them. |
Columns
Timesheet, User, Period, Status, Billable, Utilization and Total. Every column except Status sorts when you select its header. Results are paged by member, so all of a member’s weeks stay on one page.
Missing weeks
A week with no timesheet shows the status Missing, but only inside the member’s working period. Select Create in its row to create the timesheet for that member. “Timesheet created.” confirms it. If one already exists, you see “Timesheet already exists for this period.”
Email all
Email all opens a new email in your mail program, addressed by Bcc to every member in the report, with the subject “Timesheet for” and the period. It covers every page of the report, not only the one on screen. When no member matches, it is disabled with “No members to email”.
Selecting a timesheet key opens that timesheet. Returning takes you back to the same filtered report. This report has no file export; use the Detailed report for that.
Detailed report
The Detailed report lists individual time entries and is the one to export when you need rows. It needs the timesheet management permission, or a team lead role.
Filters
| Filter | Notes |
|---|---|
| Date range | Required to export. |
| Customer, Project, Task | Each can hold several values. Choosing a customer narrows the project and task lists. |
| Team | Entries by members of the chosen teams. |
| User | Search by name, with an active/inactive choice. |
| Status | Two groups. Timesheet: Open, Submitted, Approved, Rejected. Statement: Awaiting capture, Captured. |
Specific customers, projects or tasks you pick take priority over the Active/Archived switch. As a team lead without timesheet management rights, the member, customer, project and task choices are limited to what your teams’ members worked on.
Columns
Date, User, Task, Billable, Duration, Comment and Status. The summary above the table shows the billable and non-billable totals for everything that matches, not only the page. “No entries match your filters.” appears when nothing matches.
Export
Export downloads an Excel (.xlsx) file for the selected date range and filters. It exports all matching entries, not just the page on screen, in a sheet named “Detailed Timesheets”: the period at the top, then a table with Date, Member, Customer, Project, Task, Comment, Status, Charge and Free, with a totals row.
Issues report
The Issues report lists Kanban issues across the workspace, including those on archived customers and projects if you choose. It needs the workspace management permission.
| Filter | Notes |
|---|---|
| Customer, Project, Task | Each has its Active/Archived switch. Active is the default. |
| Assignee | Includes “Unassigned”, workspace members, and customer contacts. |
| Status | The columns of your issue workflow. |
Results show the issue’s Key, Title and Status. “No issues match your filters.” appears when nothing matches. The report has no file export. For how boards and the issue workflow work, seeKanban boards.
Statement Excel export
A statement has its own Excel export, separate from the reports above. It belongs to the statement, so it is in the Billing guide.
It is the Export action on a statement. It writes one sheet with the header (customer, date, total charge and free time), every entry, then per project the total, prepaid and billed days or hours with rate and amount. SeeStatements in the Billing guide.
The same file is attached to the draft invoice when you send a statement to invoicing, for example with Business Central.
Reporting endpoint for BI tools
For Power BI, Excel or any tool that can read an OData feed with a username and password, OneShift exposes a read-only reporting endpoint. Only workspace managers can create its credentials.
Generate credentials
- Open Workspace and select theIntegration tab. It shows only for workspace managers.
- Under Reporting, select Generate credentials, then confirmGenerate in the “Generate new credentials?” dialog. “Integration credentials generated” confirms it.
- The Username and Password fields fill in. They are masked. Select Reveal credentials to see them (and Hide credentialsto mask them again), or use the copy button beside each field.
Connect your tool
| Setting | Value |
|---|---|
| URL | https://api.oneshift.ai/odata. The “OData reporting API” link on the Integration tab opens it. |
| Authentication | Basic. Use the Username and Password from the Integration tab. |
| Access | Read-only. The credentials give access to your workspace’s data only. |
| Metadata | https://api.oneshift.ai/odata/$metadata, with the same credentials, describes the entity sets and fields. |
Entity sets
| Entity set | One row per | Notable fields |
|---|---|---|
| Timesheets | Timesheet | Member, start and end date, status, working days, total and billable duration, who submitted, approved or rejected it and when, rejection reason. |
| TimesheetEntries | Time entry | Date, comment, duration, billable flag, task, project, customer and member. |
| Statements | Statement | Customer, date, comment, status, billable total amount and its currency. |
| StatementEntries | Entry captured on a statement | Date, duration (minutes) and duration in hours, billable flag, billable rate, currency and amount, position name, task, project, customer and member. |
Field names use lower camel case, such as memberFirstName. The endpoint supports the OData query options $select, $filter, $orderby,$expand and $count, for example/odata/Statements?$filter=status eq 'Approved'.
duration × billableRate.