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

Maverick2 · ‎July 11, 2022

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

ZackE · ‎January 17, 2023

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:

In the top menu bar, go to Reports, then Report Center.
Search for "Inventory Valuation Detail" and choose it.
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:

While viewing a report, click its Excel option on the toolbar.
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.
In the event you'd like to format its data in a specific way, hit Advanced.
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

Rubielyn_J · ‎July 11, 2022

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:

Select the Reports menu.
Choose Custom Reports, then click Summary.
From the Display tab, set the date range.
Select the Customize Report button and click Item detail on the Display rows by drop-down.
Under Display columns for section, choose Quantity.
On the Filters tab, remove the Account filter.
Add Transaction Type and then choose Build Assembly filter. Then, add Detail Level then select All except summary filter.
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 · ‎January 17, 2023

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 · ‎January 17, 2023

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:

In the top menu bar, go to Reports, then Report Center.
Search for "Inventory Valuation Detail" and choose it.
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:

While viewing a report, click its Excel option on the toolbar.
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.
In the event you'd like to format its data in a specific way, hit Advanced.
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 · ‎January 18, 2023

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 · ‎January 18, 2023

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!

Topics

Training

Community

Resources

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