Let me provide some idea about running job costing inventory reports, @Angela-Thews.
QuickBooks Premier Contractor Edition and Accountant Edition offer a wider range of job costing reports. I can see the importance to see what you have used out of inventory.
To do this, generate a job costing report and open the amount to see the breakdown of each transaction. Then export the statement to an Excel file. From there, you can manipulate the data and add the necessary info.
Here's how:
- Generate the job costing report.
- Select the Excel dropdown found at the top of the report.
- Click Create New Worksheet.
- In the Send Report to Excel window, choose what you'd like to do with the report.
- Once done, hit Export.
To provide you with more insights about personalizing reports in QuickBooks Desktop, you can always check out this link: Customize reports in QuickBooks Desktop.
Lastly, to help you in managing job costs in QBDT, here's a reference that you can scan through: Track job costs in QuickBooks Desktop.
Don't hesitate to comment below if you have other questions about running job costing reports. I'll be happy to lend a helping hand. Keep safe!
