Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Accounting field type for properly displaying budgets

Olga Sachenko
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 7, 2023

We have a use case, where we need JIRA issue to have a custom field storing estimated budget. For this purpose we used a Number field type, which is working fine, unless the budget comes with .00 for cents (e.g. 65.03 comes out as we need it, but if it is 65.00 - the trailing zeros are dropped). This creates a confusion with the Accounting team - as all the numbers need to look consistent.

Is there a way to setup a number field or any other numeric field type so that it does not drop trailing zeros (similar to what Accounting format does in Excel)?

NB: single line text does not do the trick, as its content is not treated as a number, thus not allowing proper search and math operations.

2 answers

0 votes
Painkkims
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 18, 2024

For properly displaying budgets in accounting, I think using a "Budget" field type works best for clear organization. It lets you break down income, expenses, and any other categories you need without making things too complicated. I’d suggest using a column layout, where each category gets its own space. That way, you can see everything at a glance. Also, a good idea is to set up a “variance” field to track how you’re doing against your plan. You can always tweak it to match your specific needs. If you're click for more info, check out this guide here.

0 votes
Iryna Komarnitska_SaaSJet_
Atlassian Partner
March 8, 2023

Hello @Olga Sachenko ,

My team has developed an app Cost Tracker for Jira Cloud that helps to keep track of funds in Jira.

- set hourly ratings for the team
- enter expenses
- make high-quality and informative cost reports

Here is a 30-day trial for you to check if the app is good for you! For teams of up to 10 users add-on is free.

In our articles, we gave useful tips on how else you can use the app:

Olga Sachenko
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 9, 2023

Thank you for your response, however for our case it is an overkill, we just need one field to keep its trailing zeros on screen.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events