Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
It's great to see you here today, @theteam. Yes, there's a way to get the information you need.
Let's run the Product/Service List report so you can view the summary of the selling prices and purchase costs of all your products. I'll guide you how.
The screenshot below shows you the steps.
Once done, you can compare the amounts in the Price and Cost columns on the report. This way, you'll have the option to update them weekly. Here's a sample screenshot of how it looks like in QBO.
I recommend running other reports to see your sales and inventory status in the program. Two of them are Sales by Product/Service Summary and Inventory Valuation Detail. For more information, visit this article: Use Sales and Inventory Reports.
You can also customise those reports to format things just the way you want them. Then, memorise them to save their current customisation settings. That way, you can quickly access them in the future.
I'm here anytime you have other concerns. Keep safe always, @theteam.
Thank you for the reply.
I tried that method, as seen in the picture below, the report is generated without the selling price.
How do I connect both Purchase price and selling price in one report?
In our business both prices are variable and I must monitor to make profit.
Hi theteam!
Thank you for joining the thread and for your screenshot. I'll help you check the change in prices.
You can use the Inventory Valuation Detail report, as suggested by ReymondJayO. This will give you the combined list of purchases and sales transactions of them items. You can also filter items to easily check the change of price, like in the screenshot below. They are determined based on a First-In-First-Out basis.
To filter certain items, click the Customise button on the report page. Then, expand the Filter section and choose the list of products in the Product/Service drop-down list. See more info about customising reports.
Fill me in if you need more assistance with getting the change of price of your items. Have a good one!
Thank you very much for the reply.
To Run Inventory Valuation Report I will have to change all item type to "Inventory".
Are there any way to generate this report for "Non Inventory" Items?
Thank you for the reply.
COS is not generated for the "Non Inventory" Items. are there anyway to do this?
Thank you for getting back to us here on the Community page, @theteam.
The cost of sale or goods sold will only be realized when you sell the item on invoices or sales receipts. At this time, you can a report from the Product/Services window to check the details of your items added from there. We don't have the option to include the non-inventory items on the Inventory Valuation Detail report.
Here's how:
To learn more about setting up and tracking inventory in QuickBooks Online, check out this link.
Post again if there's anything you need assistance with. I'm here to help however I can. Keep safe!
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