Skip to main content
J
jroneill
November 25, 2024
Question

I want a report that shows the sales price and average cost for each invoice

  • November 25, 2024
  • 1 reply
  • 0 views

I can do a nice neat sales price history report. I can do a nice neat average cost report. I cannot find a way to get them both to appear on the same report in a nice neat vertical fashion. I've been able to do something like this in margin reports, but it leads to very ugly and hard to format horizontal reports. Please help! 

1 reply

Bryan_M
Bryan_M
November 25, 2024

We can run the Inventory Valuation Detail to generate a report that shows the Sales Price and Average Cost for each invoice, @jroneill. I'll provide the full instructions below.

 

To display the column and data you want to see, you can customize the Inventory Valuation Detail report,  Here's how:

 

  1. Select Inventory from the Reports tab. Then, pick Inventory Valuation Detail.
  2. Click the Customize Report tab.
  3. Go to the Columns section from the Display tab. Ensure that the Average Cost (Avg Cost) and Sales Price have a checkmark beside them. If not, tick the checkmark column.
  4. Also, enter the date range you want to view from the Dates section.
  5. Once done, click OK. Then, it will display the invoice Avg Cost and Sales Price.

 

Moreover, you can gain more knowledge about modifying a report by reading this article: Customize reports in QuickBooks Desktop.

 

Also, if you wish to save the customization of your report, check out this article: Create, access and modify memorized reports.

 

Additionally, feel free to visit this article to generate an Excel workbook, CSV spreadsheet, or PDF copy of your report: Export reports as Excel workbooks in QuickBooks Desktop.

 

We’ll be glad to engage in further discussions with you regarding invoice reports that include Avg Cost and Sales Price data or any related concerns. We are just one post away. Thank you, and have a good one.

Terms & ConditionsAccessibility statement