How to get billable hours in JIRa export

[Aditya]

is there a way of getting a report from JIRA, where I would have enough details to see tickets, time spent, billable, nonbillable, ticket type and further details?

When I export issues from JIRA, I get all the details about a ticket bit never get the actual billable hours.

when I export tempo worklog, I get billable hours and other details but never get the ticket details present in JIRA

I need a report which can get me both.

[Roberto Miasack · Accepted solution]

Hi, @Aditya 

Natively, the hours in the jira are logged without much detail.
In order to be able to divide the hours into billable and non-billable, I added a plugin for this:

https://marketplace.atlassian.com/apps/6572/tempo-timesheets-time-tracking-reports?hosting=cloud&tab=overview

You can learn how to create this directly from the third-party vendor documentation: 

https://www.tempo.io/blog/2013/tempo-timesheets-tip-of-the-month-keeping-track-of-billable-vs-non-billable-time

Cheers!

[Levente Szabo _Midori_]

Better Excel Exporter for Jira Cloud integrates with Tempo and comes with a pre-built template for exporting your Tempo (or other) worklogs into native Excel reports.

Browse the export samples and see if they serve as an inspiration for your reporting needs!

(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)

[Miron Ivano _Timescale_]

Hi @Aditya 

If you need an alternative our team have also build a great addon that has a solution for your problem - Timescale. 

With it you can create reports with time spent, billable, nonbillable, ticket type and much more. After which you can export it in EXCEL, CSV, PDF.

Here is an example of the export:

[Yuliia_Borivets__SaaSJet_]

Hi @Aditya 

Another solution you can check out is the Issue History add-on developed by my team. 

Here you can arrange the columns and add fields (assignee, time spent) you need to the report. Also, you can filter by project, sprint, date range, etc. Export to CSV and Excel is available.