Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,299,341
Community Members
 
Community Events
165
Community Groups

How to get billable hours in JIRa export

Edited
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.

4 answers

1 accepted

0 votes
Answer accepted
Roberto Lins Community Leader Sep 19, 2021

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!

2 votes

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!

17-issues-with-worklogs.png

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

1 vote
yuliia_b__SaaSJet_ Marketplace Partner Feb 08, 2022

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.

export issue history.png

0 votes

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:

Screenshot 2022-03-25 at 16.50.50.png

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,965 views 38 49
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you