Exporting the Project Scope Data

Abstract

How to export the project scope data

You can export project scope costs data for any project in your project list directly to a CSV file. The file is named 'Costs per Task <project name>' and includes the following fields: "Key", "Task Title", "Status", "Actual Cost", " Currency", "Time Spent (Hours)", "Group".

There are two options for exporting to CSV, depending on the project cost data you want and how it's organized: by Jira issue (Export Scope to CSV) or by time record (Export Labor Costs to CSV). For example, choose the latter option if you want to see a breakdown of how many hours were logged by which team member to each Jira issue, and the costs associated with each time record.

To export the project scope cost data:
  1. Select Export to CSV from the Scope drop-down located at the top-right.

    Scope dropdown menu
  2. A CSV file is immediately generated and downloaded.

Fields in the CSV file

These fields are included in the CSV file for each Jira issue or time record included in your project's scope:

  • Export Scope to CSV: 1 row per Jira issue with only the fields marked Export Scope

  • Export Labor Costs to CSV: 1 row per time record with each field in this table

Table 11. CSV File fields

Field

Description

Export Scope CSV File

Export Labor Costs CSV File

Tempo Time Record ID

The Tempo time record ID

error-icon.png
checkmark-icon.png

Project

Name of the Cost Tracker project

error-icon.png
checkmark-icon.png

Project ID

Unique ID of the Cost Tracker project

error-icon.png
checkmark-icon.png

Currency

Currency code

checkmark-icon.png
checkmark-icon.png

Group

Group name on Scope page

checkmark-icon.png
checkmark-icon.png

Task Key

Jira issue key

checkmark-icon.png
checkmark-icon.png

Task Title

Jira issue summary

checkmark-icon.png
checkmark-icon.png

Task Status

Jira Issue status name

checkmark-icon.png
checkmark-icon.png

Role

Team role of the time record's author

error-icon.png
checkmark-icon.png

Team Member

Name of the team member in Jira

error-icon.png
checkmark-icon.png

Cost Rate

Cost Rate with all available precision

error-icon.png
checkmark-icon.png

Billing Rate *

Billing Rate with all available precision

error-icon.png
checkmark-icon.png

Time Spent

Time spent in seconds

checkmark-icon.png
checkmark-icon.png

Cost

Cost incurred by this time record in this project scope with all available precision

checkmark-icon.png
checkmark-icon.png

Billable Time Spent *

Billable time spent in seconds

checkmark-icon.png
checkmark-icon.png

Revenue *

Revenue generated by this time record in this project scope with all available precision

checkmark-icon.png
checkmark-icon.png


* These fields are filled only if Revenue Tracking is on.