cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Maverick2
Level 6

I need a report that shows the running balance of an inventory item quantity

I'm on QB Desktop

 

I need a report that shows in the in/out of an inventory item with a running inventory amount. I did this report before so I know it's possible, but I cannot figure out how to do it again. ARG! It had the running list of items used in builds and items received into inventory from POs.

 

I find it frustrating that QB makes item receipt records go *poof* when you enter the bill.

 

TIA

 

 

Solved
Best answer January 17, 2023

Best Answers
ZackE
Moderator

I need a report that shows the running balance of an inventory item quantity

Thanks for following up with the Community, Maverick2.

 

Your Inventory Valuation Detail report shows information about inventory value, stock status, and pending builds. You'll also see transactions for each item on it.

 

Here's how to run it:
 

  1. In the top menu bar, go to Reports, then Report Center.
  2. Search for "Inventory Valuation Detail" and choose it.
  3. Select Customize Report, then customize it as necessary with your available options.

 

If you need more detail on the report, you can export and further customize it outside of QuickBooks.

 

Here's how to export reports:
 

  1. While viewing a report, click its Excel option on the toolbar.
  2. To create a new Excel workbook, pick Create New Worksheet. If you want to update an existing workbook with your report's data, select Update Existing Worksheet, then Browse.
  3. In the event you'd like to format its data in a specific way, hit Advanced.
  4. When you're prepared to export it, click OK.

 

Now you can customize your exported report further in Excel.

 

I've also included a couple detailed resources about working with reports which may come in handy moving forward:
 

 

Please don't hesitate to send a reply if there's any questions. Have a wonderful day!

View solution in original post

5 Comments 5
Rubielyn_J
QuickBooks Team

I need a report that shows the running balance of an inventory item quantity

I can show you how to generate a report that shows the running balance of an inventory item quantity, @Maverick2.

 

We can create a custom report to show the in/out of an inventory item with a running inventory amount. Let me show you how:

 

  1. Select the Reports menu.
  2. Choose Custom Reports, then click Summary.
  3. From the Display tab, set the date range.
  4. Select the Customize Report button and click Item detail on the Display rows by drop-down.
  5. Under Display columns for section, choose Quantity.
  6. On the Filters tab, remove the Account filter. 
  7. Add Transaction Type and then choose Build Assembly filter. Then, add Detail Level then select All except summary filter.
  8. Lastly, click OK.

 

Additionally, I've attached some links you can utilize to guide you in personalizing reports as well as how to save them on its current customization setting in QuickBooks Desktop:

 

 

Fill me in if you have further questions about running reports in QuickBooks. I'll be around to help you always. Keep safe!

Maverick2
Level 6

I need a report that shows the running balance of an inventory item quantity

I need to revisit this thread. The method outlined in the 2nd post only shows the qty of items removed from inventory when an item is built. It has two columns: Item Number, and the total taken out of inventory for that time period (for assembly builds).

 

I need to see these columns: Item number, qty added to inventory by any method, qty removed from inventory by any method, and the total running quantity. I need to see each in / out.

 

Again, I've done this before, I just can't figure out how I did it before.

ZackE
Moderator

I need a report that shows the running balance of an inventory item quantity

Thanks for following up with the Community, Maverick2.

 

Your Inventory Valuation Detail report shows information about inventory value, stock status, and pending builds. You'll also see transactions for each item on it.

 

Here's how to run it:
 

  1. In the top menu bar, go to Reports, then Report Center.
  2. Search for "Inventory Valuation Detail" and choose it.
  3. Select Customize Report, then customize it as necessary with your available options.

 

If you need more detail on the report, you can export and further customize it outside of QuickBooks.

 

Here's how to export reports:
 

  1. While viewing a report, click its Excel option on the toolbar.
  2. To create a new Excel workbook, pick Create New Worksheet. If you want to update an existing workbook with your report's data, select Update Existing Worksheet, then Browse.
  3. In the event you'd like to format its data in a specific way, hit Advanced.
  4. When you're prepared to export it, click OK.

 

Now you can customize your exported report further in Excel.

 

I've also included a couple detailed resources about working with reports which may come in handy moving forward:
 

 

Please don't hesitate to send a reply if there's any questions. Have a wonderful day!

Maverick2
Level 6

I need a report that shows the running balance of an inventory item quantity

AHA! Yes that's it. Thank you.

 

And an FYI, if you type Inventory Valuation Detail in the search field in the top right, it doesn't find it. However it was easy enough to find by clicking on the inventory choice in the left pane.

Kevin_C
QuickBooks Team

I need a report that shows the running balance of an inventory item quantity

You're most welcome, Maverick2.

 

I’m glad to hear that the information provided by my colleague above helped you locate the inventory report you need.

 

Please feel welcome to reply here or create a new thread if there are any other QuickBooks-related questions. Have a great day ahead!

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us