cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
purchase
Level 1
posted
‎May 30, 2020 05:16 AM
last updated ‎October 05, 2020 7:58 PM

How to make reports for only available stock material and skip zero stock items

 
Reply
1 Comment 1
Rea_M
Moderator
Moderator
‎May 30, 2020 07:22 AM

How to make reports for only available stock material and skip zero stock items

Hello there, purchase.

 

There are a variety of stock/inventory reports that QuickBooks Online (QBO) offers. You can pull up the Stock Take Worksheet report to view the complete list of your stock items and their quantity on hand. Then, you can manually export it to an Excel file and manually remove the zero stock item. Let me guide you how.

  1. Go to the Reports menu.
  2. Type in Stock in the search box, then select Stock Take Worksheet.
  3. Select the Gear icon at the top of the report to update its columns.
  4. Click the Export icon.
  5. Choose Export to Excel.

 

I've attached screenshots below for your reference.

1.PNG2.PNG

 

Moreover, some reports are only available to a specific QBO subscription. If you wish to learn more which reports are accessible for your version, kindly refer to this article: Reports included in your QuickBooks Online subscription.

 

Furthermore, you can customise reports to focus on the details that matter the most. For the step-by-step guide, you can check out this article: Customise reports in QuickBooks Online.

 

Please let me know if you have other concerns. I'm just around to help.

Reply