Skip to main content
J
j.vonstetten
January 2, 2024
Question

inventory value not showing in reports properly

  • January 2, 2024
  • 1 reply
  • 0 views

Hello,

 

My inventory value isn't showing up correctly in reports. 

I'm running the inventory valuation summary and it's only showing for certain items. 

 

On top of that, it's only showing the value based on our COGS prices for each assembled final product, and I need it to reflect the wholesale value of what we have in stock to get a good snapshot for what value we've carried over in the beginning of the year. We sell B2B, and Ecommerce, but if I can at least get the wholesale projected value, I can extrapolate the ecommerce value based off of our speculated sales reports from that based on trends and 2023 sales figures. 

 

Can anyone help me with this? This report is totally f***ed up and I need it really bad. 

 

Thank you in advance for any help with this that you can offer. It is very much appreciated. 🙂

 

1 reply

M
Maybelle_S
January 2, 2024

Hello there, j.vonstetten.

 

I understand your frustration with the inventory valuation summary not displaying correct values for certain items.

 

When running the Inventory Valuation Summary report, it'll only show the SKU, QTY, Asset Value, and Calc. Avg. With that, showing the wholesale value is unavailable.

 

You can manually calculate it using the wholesale calculator. Check this link for more details: https://quickbooks.intuit.com/global/tools-and-templates/wholesale-price-calculator/#.

 

I've added this article to help you manage your inventories:

 

 

Let me know if you have other questions about the inventory report. I'm always here to help. Take care.

J
j.vonstettenAuthor
January 2, 2024

Hello Mabel,

 

Why is it only showing in part of the column for some of the sku's, but not all. How can I fix that?

 

I've attached a photo of what my report looks like right now.

G
GlinetteC
January 2, 2024

It's good to have you back, j.vonstetten.

 

I can help you figure out why some of the SKU's not showing in part of the column.

 

It could be that the SKU information for the item hasn't been entered, causing it to not show in the report.

 

You'll want to review the data entry to ensure that SKUs are being entered consistently for all items.

 

I've added some resources you can check that will help you manage your inventory and keep track of them:

 

 

Keep me posted if you need further assistance managing your inventory in QuickBooks. I'll be here to provide you with the support that you need. Keep safe.

Terms & ConditionsAccessibility statement