Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowIs there a way to get the Committed Costs by Job report to show costs broken down by item code?
Otherwise, I need Quickbooks to produce a report that looks like the attached cost report template, basically a Cost to Completion report to forecast how my projects are performing against the budget.
I need the report to show posted bills as Actual Costs, and POs as Committed Costs. If I have to export to Excel to insert the variance and estimated cost columns, that's fine. But I'm running into a problem.
I've tried building this report in Excel manually by:
-Exporting Estimated vs Actual report to Excel
-Creating an extra column for Committed Costs
-Exporting an Open PO report to another spreadsheet and
-Using a SUMIFs formula in the Committed Costs column to pull in open PO totals based on the Item Code in the Est. v Act. sheet.
But the problem arises when I have open POs for items that don't have any actual costs yet, because those item codes don't appear on the Est. v Act. sheet. I have over a dozen separate customers that I need to create this report for on a weekly basis, so manually adding cost codes to accommodate those POs would take forever. And I don't want a report with every single cost code on it because it would be prohibitively long.