Project planning is always about time, scope and finance. Jira is a handy tool for working with the first element: estimation in time and story points, Agile reports, Scrum and Kanban boards with flexible settings, etc. So, everything related to project planning and process tracking can be done in Jira using default functionality.
We, here at SaaSJet, build the products, meaning we have a lot of projects. Small and big. Good structured and a bit chaotic. However, there is always one question on the table - what is the cost of a particular project we run?
With this issue in mind, we built a product that helps us and (knowing that our situation isn’t unique) will help other organizations.
The concept is quite simple. People do projects. So, they spend their time on tasks. All of them have rates. To make something happen, teams need computers, servers, software, etc.
We all understand that Excel sheets are not an option when you have a large team and many projects. As one joke says - Excel is the foundation of the entire world economy :).
We decided to develop a simple and functional app that would optimize the process of tracking costs in the company and provide reporting in a convenient form - Cost Tracker for Jira Cloud.
Our formula for the project cost is: People’s rates * allocated time + direct expense.
Now, let’s see what Cost Tracker is in play. Once you install the product from the Marketplace, all Jira users will be synced to the app.
The first step is to set the hourly rate for each team member.
Next, add all expenses related to the project. You can include One-time and Recurring expenses, and associate them with a Project, a User, or any combination of users.
If you have permission to manage expenses, you can add recurring expenses to the database. Recurring expenses come with additional settings:
Now, define the scope of your report. For example, if you want to evaluate last month’s work, go to Jira Filters and create a filter that captures all issues with a worklog from the previous month.
Example JQL:
("worklogDate" >= startOfMonth(-1)) AND ("worklogDate" <= endOfMonth(-1)) AND project = Development
This filter will be used for monthly reporting.
Finally, go to the Cost Report page and generate the report:
The resulting report will include:
Notes:
This app was created to address challenges we faced, and we’re confident our experience is not unique — many companies encounter similar problems, and we’ve developed solutions to tackle them.
We also reference real use cases to illustrate how these solutions work in practice.
We hope this will be useful for everyone!
Iryna Komarnitska_SaaSJet_
Product Marketer
SaaSJet
Ukraine
10 accepted answers
0 comments