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.

01

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.

ReportWho sees itWhat it showsExport
CustomerBilling permissionA customer’s captured statement time and budgets, by project.Excel
TimesheetsTimesheet management permission, or a team leadOne row per member and week, including weeks with no timesheet.None
DetailedTimesheet management permission, or a team leadEvery time entry, with its status.Excel
IssuesWorkspace management permissionKanban 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.
02

Customer report

The Customer report shows what has been captured on statements for one customer. It needs the billing permission.

Filters

FilterNotes
Date rangeStarts on this month.
CustomerRequired. Search customers by name.
ProjectOptional, 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.
This report counts statements only. Time that is not on a statement yet, and balances imported into a budget, are not in it. Its consumed figures can therefore read lower than the budget bars on the workspace pages. The Detailed report shows time that has not been captured on a statement.

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.

03

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

FilterNotes
Date rangeWeeks start on Monday.
UserSearch by name. Choose active, inactive or all members.
StatusOpen, 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.

04

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

FilterNotes
Date rangeRequired to export.
Customer, Project, TaskEach can hold several values. Choosing a customer narrows the project and task lists.
TeamEntries by members of the chosen teams.
UserSearch by name, with an active/inactive choice.
StatusTwo 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.

An export is limited to 50,000 rows. Above that, the export is refused with “Export exceeds the 50,000-row limit. Refine filters or shorten the date range.” Narrow the filters or split the period.
05

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.

FilterNotes
Customer, Project, TaskEach has its Active/Archived switch. Active is the default.
AssigneeIncludes “Unassigned”, workspace members, and customer contacts.
StatusThe 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.

06

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.

07

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

  1. Open Workspace and select theIntegration tab. It shows only for workspace managers.
  2. Under Reporting, select Generate credentials, then confirmGenerate in the “Generate new credentials?” dialog. “Integration credentials generated” confirms it.
  3. 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.
Generating again replaces the old credentials. The dialog warns that any integration using the current credentials will stop working, so update your BI tool right after.

Connect your tool

SettingValue
URLhttps://api.oneshift.ai/odata. The “OData reporting API” link on the Integration tab opens it.
AuthenticationBasic. Use the Username and Password from the Integration tab.
AccessRead-only. The credentials give access to your workspace’s data only.
Metadatahttps://api.oneshift.ai/odata/$metadata, with the same credentials, describes the entity sets and fields.

Entity sets

Entity setOne row perNotable fields
TimesheetsTimesheetMember, start and end date, status, working days, total and billable duration, who submitted, approved or rejected it and when, rejection reason.
TimesheetEntriesTime entryDate, comment, duration, billable flag, task, project, customer and member.
StatementsStatementCustomer, date, comment, status, billable total amount and its currency.
StatementEntriesEntry captured on a statementDate, 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'.

Reconcile money against the statement total. A statement’s billable total is rounded once per project. The per-entry amounts in StatementEntries are rounded entry by entry, so their sum can differ from the total by cents. Use the total, or compute duration × billableRate.