Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowHow can I run a sales History by SKU report in Quickbooks online?
I can run it by product/ service but it doesn't associate the corresponding SKU to each item.
I want to monitor my sales for each sku and use this report to adjust my reorder points based on the previous years historical sales.
Solved! Go to Solution.
Welcome to the Community, Stringo. I can see the importance of getting the SKU information on the reports. No worries, I'm here to provide you with steps on how to group the SKU.
To make the SKU column visible in a report, you have to turn on a specific feature.
Here's how you can activate it:
Once done, you can see the report that shows the SKU column.
I'd like to share this article about customizing sales forms. This will guide you on how to personalize your reports.
In addition, you can check out this article for you to learn how to set up product and service items you buy and sell: Add product and service items to QuickBooks Online
Comment below if you need more help with running a report. We're always here to lend a hand.
Welcome to the Community, Stringo. I can see the importance of getting the SKU information on the reports. No worries, I'm here to provide you with steps on how to group the SKU.
To make the SKU column visible in a report, you have to turn on a specific feature.
Here's how you can activate it:
Once done, you can see the report that shows the SKU column.
I'd like to share this article about customizing sales forms. This will guide you on how to personalize your reports.
In addition, you can check out this article for you to learn how to set up product and service items you buy and sell: Add product and service items to QuickBooks Online
Comment below if you need more help with running a report. We're always here to lend a hand.
Many Thanks !
That's great to hear, Stringo.
I'm glad to know the steps provided by my colleague helped you and that you were able to run SKU information on your data reports. It's always our aim to ensure that you receive the support you need.
I'll keep this thread available if there's anything else you need further assistance with when running reports in your account. Just let me know, so I can provide additional help. Keep safe!
I understand having SKU as a column but how do you filter it to pick certain SKUs and not have to show all of our SKUs?
Hi there.
I recognized that having the option to filter transactions by SKU would be a helpful feature to have. I'm here to share further details about this.
We see your suggestions as an opportunity to identify the areas in the product's reporting feature that need improvement. I encourage you to send us your feedback or product recommendations.
Your valuable feedback will be forwarded and reviewed by our Product Development team to help improve your experience while using the program. Here's how:
Alternatively, you can export your transaction report to Excel. Once the data is in Excel, you can then filter and sort the transactions by the SKU column to only display the specific SKUs you need.
To do this:
I'm also adding an article if you want to keep your products and services organized: Group your products and services into different categories.
On the other hand, we got these articles to help you keep your current report settings for future use and learn more about exporting reports outside QBO:
Feel free to reach out anytime if you have additional questions or need further assistance. We're happy to help walk through any reporting or customization issues you encounter.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here