User-centric Account summary timesheet in Tempo

I've done a lot of searching and experimentation and this appears to be impossible, but I wanted to ask here...

Is there a way to generate a timesheet that is a timesheet with a user's total hours per Account (for any of the standard time periods)?

I'm thinking of "per Account" as in the worklog attribute described here:

Here's what I have tried so far:

  • Use the Account view in Tempo timesheet. This gives time by account, but I'd have to pick every account individually AND remove other user's time manually.
  • Use the standard timesheet view, select the view as Report, Report in a tabular view, or Report in a table view and then under Views options select the Account checkbox. This can be exported to Excel and summed there, but that's assuming that 1) the user gets the correct report exported, 2) the user orders values correctly in Excel, and 3) the user sums values correctly in Excel. This is too many assumptions.

Is there any other way to do this?

Thanks in advance for any help.

3 answers

Hi Sean,

you could try to use the Excel export from the Account report view. Go to the Account timesheet and choose All Accounts. In the Report view you have the possibility to export the information to Excel. In Excel you will have to create a pivot table to get only the information you are interested in. See for more information.

Hope this helps

Susanne (Tempo)

Hi Susanne,

Thanks for your time and your answer. Unfortunately, given the people who will be using this, creating a pivot table in Excel (or even using Excel at all in some cases) is not going to be a viable option.

What we may end up doing is using the API to accomplish this, as we do need to do this work as much as possible within a browser.

Thanks again,


Hi Sean,

We are working towards a solution to your problem that will be available through the Tempo UI.



This would be a great help to us as well.... +1 to this!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published 11 hours ago in Jira Ops

Jira Ops Early Access Program Update #1: Announcing our next feature and a new integration

Thanks for signing up for Jira Ops! I’m Matt Ryall, leader for the Jira Ops product team at Atlassian. Since this is a brand new product, we’ll be delivering improvements quickly and sharing updates...

158 views 0 5
Read article

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