You can export project scope costs data for any project in your project list directly to a CSV file.
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:
Select Export to CSV from the Scope drop-down located at the top-right.
A CSV file is immediately generated and downloaded.
For Export Scope to CSV, a file is created Scope for <project name>_<current date>.csv
For Export Labor Costs to CSV, a file is created Labor Costs for <project name>_<current date>.csv
Open the CSV reports.
The above is an example of the Scope report file.
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 9. CSV File fields
Field | Description | Export Scope CSV File | Export Labor Costs CSV File |
|---|---|---|---|
Tempo Time Record ID | The Tempo time record ID. |
|
|
Tempo Worklog ID | The Tempo Worklog ID. |
|
|
Tempo Project | The name of the Cost Tracker project. |
|
|
Tempo Project ID | The unique ID of the Cost Tracker project. |
|
|
Currency** | Currency code. (Not available for Time-based projects). |
|
|
Group | Group name on Scope page. |
|
|
Task Key | Jira issue key. |
|
|
Key | Jira issue key. |
|
|
Task Title | Jira issue summary. |
|
|
Task Status | Status of Jira issue. |
|
|
Status | Status of Jira issue |
|
|
Role | The team member's role. |
|
|
Team Member | The name of the team member in Jira. |
|
|
Cost Rate | Cost Rate with all available precision. (Not available for Time-based projects). |
|
|
Billing Rate * | Billing Rate with all available precision. (Not available for Time-based projects). |
|
|
Time Spent (Seconds) | Time spent, in seconds. |
|
|
Time Spent (Hours) | Time spent, in hours. |
|
|
Cost | Cost incurred by this time record in this project scope with all available precision. (Not available for Time-based projects). |
|
|
Actual Cost | Cost incurred by this time record in this project scope with all available precision. (Not available for Time-based projects). |
|
|
Billable Time Spent (Seconds) * | Billable time spent, in seconds. |
|
|
Billable Time Spent (Hours) * | Billable time spent, in hours. |
|
|
Revenue * | Revenue generated by this time record in this project scope with all available precision. |
|
|
Actual Revenue * | Revenue generated by this time record in this project scope with all available precision. |
|
|
Date | Worklog date. |
|
|
Account Name | Account name associated to the worklog or to the Jira issue. |
|
|
Account Key | Account key associated to the worklog or to the Jira issue. |
|
|
Account Category | Account category of this expense. |
|
|
Account Category Type | Account category type of the associated account. |
|
|
Account Status | Status of the associated account. |
|
|
Customer Name | Customer name associated with this expense. |
|
|
Customer Key | Associated customer key. |
|
|
* These fields are filled only if Revenue Tracking is on.