Rounding financial numbers
For the accounting features. Please make all numbers round to the nearest dollar.
For rounding related to change order financial markup, use this ticket: https://feedback.procore.com/forums/183340/suggestions/13748373
Thanks for the feedback! Our team will review your suggestion and I will update this ticket if we proceed.
Molly Quinones commented
My suggestion would be to have an admin setting for us to be able to choose by project if we use pennies or not. Some Owners require it and others do not care. On large scale projects such as the ones we typically have across our enterprise, not having to type ".##" for every financial record will be a HUGE time savings, not to mention the reduction of the possibility for errors and then the time to correct those errors if the cents are typed in wrong.
Gilbert Thibeau commented
There should be an option to round totals on commitment and prime contract change orders and proposed change orders. Our accounting department detests having to deal with cents / less-than whole dollar amounts so we normally round totals on subcontract commitments and related change orders. The only way to do this in Procore is to manually enter an amount / defeating the automatic calculations.
Todd Miller commented
Provide for rounding of dollar amounts to whole dollars in financial tools. With the exception of miscellaneous invoices, few accounting transactions use cents. Provide ability to remove, or remove as default.
Using Procore for subcontractor billing does not always calculate the retaiange properly. There usually is some sort of rounding issue since each individual line item on the SOV is calculated and the sum of the column is added up. Attached is an example. I wish we could calculate the retainage without the rounding or had a way to override the system to account for the pennies. The worst one i have run into so far was 7 cents however the 7 cents carries over each month.
Prime invoice rounding error
John Waller commented
Another vote for this preference.
I have never had cents appear on any reports when using other financial packages.
Dollars only would make reports easier to read and save precious pixels on paper.
Cian McGowan commented
There needs to be an option to toggle on/off rounding to the nearest whole dollar in the reports while maintaining the cents in the background. This would make the reports much more visually appealing, without sacrificing accuracy.
There should be an option to save column space and omit the decimal fraction from the reported numbers by visually rounding the numbers to the nearest dollar (similar to the Decimal Places setting/functionality in Excel). The underlying numbers would not be altered or rounded in any way.
2 decimals 0 decimals
Sum 2,001.89 2,002
There should be an option to visually round to the nearest dollar, without altering the decimal portion. This would lead to more column space (larger font) on the reports.
Mukesh Darke commented
turn off rounding
rounding financial numbers
Renee Hurtado commented
I am having the same problem. I am losing money. By this rounding issue, it is making my owner pay apps off and makes it quite time consuming when I am having to edit my PDF to make it correct when dealing with banks and our numbers don't match. This has been an ongoing issue.
Procore really needs to round to the nearest dollar... no more pennies.... please! At least give us as a company that option.
Raena Cunningham commented
"PCCO's display only 2 digits past the decimal for sales tax.. In NYC the Sales Tax is 8.875%, however it displays an approximate of 8.88%."
Shannon Mitchell commented
Retainage confusion. I realize retainage is calculated on each item. The problem with this is will create some rounding problems. On the summary tab of the pay app, if verify the calculation based on the presented figures, there can sometimes be a difference. See attached. I personally don't care about a 4 cent difference because everything will workout at the end of the contract. However, I waste a lot of time explaining our pay app to architects regarding the rounding difference. A rounding solution would be a time saver.
Nicholas O'Brien commented
When entering in a default percentage of retainage, sometimes the amounts differ from calculations in excel - due to decimal point rounding
This then creates discrepancies between Procore generated reports and reports from the bank (using Excel).
Proposed Solution: Implement a fail-safe, or a reminder advising that the amount can be different to say an excel calculation.
Monika Mikl commented
The financial markups on the budget tab are added and rounded in a way that differs from the prime contract tab, resulting in a difference of a few cents. This makes it impossible to create an accurate and precise budget.
Budget tab: entire values are added together, THEN rounded to two decimals at the end.
Prime Contract tab: rounds each value to two decimals first, THEN adds.
Please update the calculation on the budget tab so that the totals are cohesive across the site. Thanks.
Dawn Shirley commented
I have actually seen a similar request and i can confirm that has been reviewed by our engineers and we found that the way the calculations work in Procore is that it does indeed calculate the whole numbers, before rounding it off to 2 decimal points.
We also performed a few tests to confirm that the difference is never more than $1.00 when rounded and this is consistent throughout Procore. Modifying this behavior would have to be a new feature that can be suggested on our user feedback forum.
Please let me know if you do have any questions and i am more than happy to help.
PLEASE fix this. Co-workers have little enough trust in computers without me having to explain why numbers don't match.
Unit/Quantity Based Prime Contract
We like this functionality; however, it is currently not practical due to rounding issues. Four decimal places is not enough on the unit price to make it match our individual bid line items. It would be nice if you gave us the option to set the number of decimals needed to make it match. If this is not clear, feel free to call us.
Morgan Traynor commented
Can we have a project default setting that allows us to eliminate the $.00 cents on Pay Apps and only show whole dollar values? Additionally, have a default setting that allows us to have whole percentages (i.e. 7% vs. 7.34%).