cancel
Showing results for 
Search instead for 
Did you mean: 

Reply to message

View discussion in a popup

Replying to:
Experienced Member

Committed Costs report broken down by item?

Is 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.