cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
mshehzad2211
Level 1

Can I download stock value report by Location wise?

Is QBO has option of Stock report with location wise? How can I download stock report by Location
1 Comment 1
LeizylM
QuickBooks Team

Can I download stock value report by Location wise?

I see that you're seeking a detailed overview of stock values across various sites, mshehzad. Although downloading a stock value report by location isn't possible, I can guide you through alternative options to obtain this information.

 

The option to run a stock value report by location is unavailable in QuickBooks Online (QBO). As a workaround, we can run and export the Sales by Location Detail or Purchases by Location, then manually combine the transaction data. This will help create a more comprehensive overview of inventory valuation across different locations.

 

Here's how:

 

  1. Go to the Reports, then enter Sales by Location Detail or Purchases by Location Detail on the search bar.
  2. Click Switch to classic view, and select Customise. From there, click the Filter drop-down.
  3. Check the options for Rows/Columns and Filter dropdown arrow, and make sure to check the box for Location.
  4. Select Run Report.

 

Once done, simply click the Export icon and select Export to Excel. I've added a screenshot for your reference.

 

Additionally, these resources guide you through the process of managing your stocks:

 

 

If you have any questions about tracking inventories in QuickBooks Online, I'm here to assist you further. Please don't hesitate to reach out for more help.