The Job Profitability Report currently shows costs first, then revenue in the next column. The computed difference represents the profit. The % of the difference/profit is based on the costs. Normally profit is stated as a % of Revenue. Is there a way to change the order of these columns so the % is based on revenue instead of costs?
I already do a lot of exports from QuickBooks to Excel and that would be a solution if we were only going to look at the report on an occasional or rare basis. But we would like to use this report on a regular basis so it is not practical for all of our users to export and redo the formulas on a regular basis. It just seems backwards from what normal financial statements and analysis are based on so I thought maybe there was a way to correct it.
Are there some advanced reporting functionality that I am not aware of that we can write new or revise reports. The customize reports is not an option, as the parameters are not very flexible.
I appreciate you explaining how it would help you out to be able to reorder the column report in QuickBooks Desktop. It is always our aim to develop relevant features that came from QuickBooks users or customer feedback. I'll be sure to take note of this product option for future enhancements.
While that feature isn’t currently in our development roadmap, we are working on big improvements that will be helpful for the majority of our customers.
You can visit the What's New section on your QuickBooks Desktop, to stay informed with our latest news and updates including product enhancement.
In the meantime, I recommend customizing the report to get the specific details you need. You can also memorize it to save its current customization settings. It serves as your record and helps you quickly access it for future use.
If you have any other questions about generating a report or need anything else in QuickBooks, let me know in the comment below. I'll be more than happy to help you in any ways I can. Have a lovely day!