cancel
Showing results for 
Search instead for 
Did you mean: 
940alex
Level 3

Cost vs Average Cost Report

I need a report which shows these columns: Item, Cost, Average Cost and Sales Price.

 

Just noticed I had a loss in XX item sold because I base Sales Price on the Cost (theoretic cost), but the actual Average Cost is higher due to a high prorrated Freight in the Purchase or because Vendor incremented prices and Accounting didn't notice and just captured Bill with that price.

 

With this report I can compare my "theoretic" Cost vs the Actual Average Cost and update my Sales Price accordingly.

Currently I found that the inventory valuation report Shows my "Average Cost" and "Sales Price" which I can work with to make same analysis, but having the "theoretic" cost column could give me better insight.

 

Thanks

Solved
Best answer June 10, 2021

Best Answers
katherinejoyceO
QuickBooks Team

Cost vs Average Cost Report

Hello there, @940alex

 

Thanks for coming to the Community today. I understand you'll need to get a report that shows the information you need (Item, Cost, Average Cost, and Sales Price) in columns.

 

At the moment, we're unable to pull up a specific report that'll show this information. What you've found is a good workaround. 

 

Additionally, you'll want to export both reports to manually get the data needed. 

 

I've got you this article as your guide in exporting your reports to excel from QuickBooks Desktop: Export reports as Excel workbooks in QuickBooks Desktop

 

Let me know if you have more or other concerns. I'm always around here to help. 

 

View solution in original post

2 Comments
katherinejoyceO
QuickBooks Team

Cost vs Average Cost Report

Hello there, @940alex

 

Thanks for coming to the Community today. I understand you'll need to get a report that shows the information you need (Item, Cost, Average Cost, and Sales Price) in columns.

 

At the moment, we're unable to pull up a specific report that'll show this information. What you've found is a good workaround. 

 

Additionally, you'll want to export both reports to manually get the data needed. 

 

I've got you this article as your guide in exporting your reports to excel from QuickBooks Desktop: Export reports as Excel workbooks in QuickBooks Desktop

 

Let me know if you have more or other concerns. I'm always around here to help. 

 

View solution in original post

940alex
Level 3

Cost vs Average Cost Report

Hi Katherine. Thanks for your reply.

 

I agree there is a report where I can get the "Theoretical" Cost, and then there's the one where I can get "Average Cost". And yes I can export them both and put them together with a vlookup. As a work around.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us