Pivot Report

Integrate Timesheets by Tempo

This article describes how to set up the integration between Pivot Report and Tempo Timesheets.

Alternatively, if you need fewer features for time tracking, you can try Colined’s Worklogs Report.

Are there additional requirements?

Before enabling the integration between Tempo Timesheets and Pivot Report and using reports, a Jira admin must follow Tempo Timesheets’ Jira Cloud configuration guide, available in a separate article.

Once the configuration is complete, follow the steps below to enable the integration.

Which fields from Tempo are supported?

Pivot Report can display the following fields from the Tempo app in the reports.

Support field

Definition

Accounts & Billable Hours

These are used to track time across multiple teams and spaces. By connecting accounts to specific spaces and setting the account in the Work item view, worklogs can be assigned to accounts to provide data for reporting and bookkeeping.

Work Attributes

These are fields that you can add to worklogs to record detailed information about logged time.

Examples of work attributes might include "Overtime", "Non-Billable", or "Travel time".

Teams

Users who are grouped into teams can view each other's roles, schedules, and worklogs.

How users will appear in the Worklogs tab?

When using third-party applications such as Timesheets by Tempo, the original worklog author information may not be available. Instead, the third-party application's name, such as Tempo, may appear as the user who entered the worklog.

As a result, the Worklogs tab type will not display the original worklog author.
Tempo will appear as the only user for all time entries.

How can you enable or modify an integration?

Timesheets by Tempo stores additional data outside of your Jira instance. To enable Pivot Report access to this data, you need to grant permission via OAuth 2.0.

The steps below describe how this permissions can be accessed, set up for the first time, and revoked.

How can you access the ‘Tempo Integration’ page?

The status of the integration between Tempo and Pivot Report is shown on the Tempo Integration page. You can access this page by:

  1. Open the Settings menu in Jira’s top navigation bar, by clicking on the gear icon.

  2. From the dropdown, choose Apps.

  3. Within the Apps settings page, click on Tempo Integration from the list of Pivot Report configuration options.

  4. On the Tempo Integration page, you can preview the status of the integration with Pivot Report.

Group 65-20250716-135114.png

Example of a disabled integration (as shown in the screenshot)

shot_240424_184921.png

Example of an existing integration

For an existing integration, no additional steps are necessary.

iScreen Shoter - Google Chrome - 240325225850.png

How can you set up a new integration with ‘Timesheets by Tempo’?

Within this Tempo Integration page, you'll find a tutorial outlining the steps for a Jira admin to integrate Pivot Reports with Timesheets by Tempo.

These steps are repeated below.


Access the ‘OAuth 2.0 Applications’ in Tempo Settings

  1. Click on Tempo within the Apps list.

  2. Within the Timesheets by Tempo page, click on Settings.

  3. On the Settings page, scroll through the Data Access option and select OAuth 2.0 Applications.

  4. Click New Application in the OAuth 2.0 Applications page, to access the Create Application pop-up.

Group 65 (1)-20250716-140022.png


Complete the Application pop-up

Enter your details as follows into the Create Application pop-up:

  1. Enter “Pivot Report Integration” into the Name textbox.

  2. Enter the https://pr.colined.app/api/1/tempo/auth/COPY_URI_FROM_YOUR_SETTINGS into the ‘Redirect URIs’ textbox.

  3. Set the Client type to “Public”.

  4. Keep the Authorization grant type set to “Authorization code”

Group 34 (1)-20250703-033154.png


Obtain the Redirect URIs the Application pop-up and create application

Retrieve the ‘Redirect URIs’ from the Tempo Integration page.

  1. Click on the Copy next to ‘Redirect URIs’ from the Tempo Integration page, and paste the contents into Create Application pop-up (see step 6 above).

Group 65 (2)-20250716-140237.png

Afterwards, click on Create Application in the Create Application pop-up.
This will open the Credentials pop-up for secure access to the Tempo database.

If you close the Create Application pop-up at any time, you can apply changes by using the actions (•••) menu.

  1. Click on the actions (•••) menu in the OAuth 2.0 Applications page.

  2. Select Edit from the dropdown to open the pop-up.

Group 181 (1)-20250821-052057.png


Populate the Credentials pop-up and submit

Within Credentials pop-up, copy to Clipboard each of the fields.

  1. Paste Client ID into the Tempo Client ID textbox on the Tempo Integration page.

  2. Paste Client secret into the Tempo Client Secret textbox on the Tempo Integration page.

  3. Once both fields are filled, click on Submit.

Group 37 (2)-20250705-004309.png

These fields will needs to be pasted within the Tempo Integration page.

Group 182-20250821-052406.png

If you close the Credentials pop-up at any time, you can apply changes the Client ID and Client secret fields by using the actions (•••) menu.

  1. Click on the actions (•••) menu in the OAuth 2.0 Applications page.

  2. Select Credentials to open the pop-up.

Group 181-20250821-051918.png


Authorize access

Group 35 (2)-20250704-003433.png
  1. Click on Authorize Access in this pop-up. Afterwards, click on Onwards!.

Group 35 (3)-20250704-003734.png
Example of a successful authorization yielding an ‘Onwards!’ button
  1. After clicking on Onwards!, you are redirected to the Tempo Integration page. Confirm that you are seeing Tempo Integration is ON (as shown in the screenshot).

    Group 186-20250821-052906.png


How can you revoke access for ‘Timesheets by Tempo’?

Turn off the application

  1. Click on Turn off button on the Tempo Integration page, to revoke access.

Group 185-20250821-052730.png


Revoke credentials

You can revoke access by using the actions (•••) menu.

  1. Click on the actions (•••) menu in the OAuth 2.0 Applications page.

  2. Select Delete from the dropdown to open the pop-up.

Group 183-20250821-052522.png
  1. Click on Revoke.

Group 184-20250821-052625.png

If you have questions or need assistance, contact our support team via email or service desk. Our team is available Monday through Friday (9:00 AM to 7:00 PM GMT+7) to help with technical challenges or discuss improvements.