I haven't been able to get the report to look like the job profitability report in QBD. I need a report that I can see the Actual costs vs the amount we have billed for already, and see the difference. This shows me at a glance what I have to bill for, so I can see if there are any other vendor invoices I might need to get into the system. I was able to see all of the costs, just not what we have billed for
Thank you for getting back to us here in the Community, @JBAtlanta.
I'll gladly share some information with you. Currently, running a report that shows both the Actual costs and the amount that has been billed already is unavailable.
As a workaround, let's run the Project Profitability report mentioned above and the Sales by Product/Service Detail report. We can export them to excel and combine them into one to view the information you needed.
Here's how to pull up the report for your billed transactions:
Run the Sales by Product/Service Detail report from the Reports menu.
Select Customize and choose Filter.
Check off the Transaction Type box and then choose Invoice as the transaction type (or whatever transaction type you'd like).
Tick Run report.
Here's how to export the reports:
After you run the report. At the top right of the report, select the Export icon. Then choose Export to Excel.
Save the file somewhere you can easily find, like your Downloads folder or your desktop.