JIRA + Tempo, how to use it for billing


We're in the process of switching to JIRA from our old project management system and the development team is loving it, but our accounts manager hates it.

I'm struggling to figure out how to get JIRA/Tempo to easily track billed and not billed work logs and run reports.

I'm not sure if I need to be asking this question within Tempo, JIRA or if there's another way to achieve this.

I've come close to getting this to work by using a combination of custom worklog attributes and filters, but the problem is we can't filter report views by worklog attributes, making the system unusable for what we need.

The requirements are fairly simple and our previous system could manage this easily:

  • Every two weeks, we need to run a report accross all projects to see which time logs have not been billed yet
  • Daily reports on a per customer basis to find out what time has been spent for a particular customer

Any help is appreciated.



3 answers

Hi Susanne,

Thanks for the reply.

Unfortunately, our need for filtering is more about bulk editing and easily updating multiple timelogs of a certain filter, rather than data interpretation, otherwise we would have no issue in using Excel for manipulating data.

Ideally, what we would like to see is the ability to filter by an attribute such as billed=false, and then be able to bulk edit all timelogs to billed=true, via a "check all" link or similar.

I've attached a mockup in an attempt to describe how I envisage this. It's more about bulk editing the result set of a filter for quicker management of timelog data.

Our current activeCollab system allows us to do this very easily. 

It's starting to look like we may have to abandon the idea of moving our development team to JIRA due to these billing and accounting difficulties. It's starting to become more hassle than it's worth.

The point of moving to JIRA was to improve efficiency and not to make life harder for our account manager who insists we stay with our existing "not broken, don't fix it" system. 

An argument we don't seem to be winning and is causing much internal tension sad

Thanks again,



Hi Scott,

It is not possible to filter by worklog attributes in JIRA or Tempo, but it can be done after an export to Excel. When you export a Timesheet to Excel, you can pivot the table to show only the data you are interested in and filter it. Please take a look at http://blog.tempoplugin.com/2012/pivoting-tempo-and-jira-reports-using-excel/ for more information.

Kind regards,

Susanne (Tempo)

Actually Tempo Books is about to come out, that is the missing link for actually billing it.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Jira

Looking for anyone who made the switch to Data Center

The Jira Marketing team is putting together an ebook on migrating to Data Center. We're looking for pro tips on how you staffed your project team and organized your Proof of Concept. Share yo...

45 views 0 2
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you