Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello,
I'm new user in QBO world, and just in a phase of setting up Accounting features and other.
Now Inventory and CoGS is on the menu.
I open new product under Inventory type, and assign :
Inventory asset account : Inventory Asset
Income account : Sales of Product Income
Expense account : Cost of Sales.
When I post a Bill , the net amount is posted on Inventory Asset, shown in Balance Sheet.
When I post a Sales Invoice , Sales of Product Income is recorded.
But Inventory Asset Balance remains unchanged , as well as Cost of Sales !
There are some "movements" when I run report on that Product , from Products and Services , but movement on GL code Inventory Asset and Cost of Sales is zero (0.00), instead of decreasing Inventory Assets and increasing Cost of Sales.
Can someone please help me understand what am I doing wrong in setting up the Inventory products ?
Many thank in advance.
Kind regards,
Jasna Mato
Solved! Go to Solution.
Welcome aboard QuickBooks Community, Old nan!
I'd be glad to assist you update your product setup, and get your report corrected.
Upon checking the screenshot you've shared, it shows that your Inventory Starting Values is zero. This is the reason why both your Inventory Asset Balance and Cost of Sales are zero.
Let's edit the product's inventory starting value by following these steps:
1. Click on the Gear icon, and choose Product and Services.
2. Find the inventory product that you intend to edit.
3. Under the ACTION column, click Edit.
4. Under Quantity on hand, click Starting value.
5. Click Got it!
6. Fill out the Initial quantity on hand as well as the Initial cost.
7. Click Save and close.
To learn more about managing your inventory, check out this article: Inventory Overview and Setup.
Let me know if you have any other concerns. Have a blissful day!
Welcome aboard QuickBooks Community, Old nan!
I'd be glad to assist you update your product setup, and get your report corrected.
Upon checking the screenshot you've shared, it shows that your Inventory Starting Values is zero. This is the reason why both your Inventory Asset Balance and Cost of Sales are zero.
Let's edit the product's inventory starting value by following these steps:
1. Click on the Gear icon, and choose Product and Services.
2. Find the inventory product that you intend to edit.
3. Under the ACTION column, click Edit.
4. Under Quantity on hand, click Starting value.
5. Click Got it!
6. Fill out the Initial quantity on hand as well as the Initial cost.
7. Click Save and close.
To learn more about managing your inventory, check out this article: Inventory Overview and Setup.
Let me know if you have any other concerns. Have a blissful day!
I have uploaded inventory in bulk and now, 18 inventory cost is not reflexing in profit and loss.
I suggest the client use QB for inventory management.
Now, I am regretting it.
I hope you're doing well, tarannum.
To verify, do you want to delete the other inventory items? If so, I'll be happy to share some steps.
QuickBooks Online now has a Batch action option in the Product and Services page. This means that you will be able to make the items you don't need inactive in bulk.
Here's how:
Here's a sample screenshot for a visual reference:
You can also read this article for reference: How to edit, delete, and restore list elements.
Please let me know in the comments below if you need something else. I'll be right here to help you out again. Take care and stay safe!
I know how to delete and restore.
There are around 20+ inventory items. Uploaded properly as product.
Now, the cost is not reflecting in profit and loss or in balance sheet.
Whom should I contact??
No. Inventory value is not reflecting in the financial statement.
I know how to delete or restore the inventory.
Thank you for coming back to the QuickBooks Community to provide further information, tarannum. I'll share detail on how uploaded inventory works in QuickBooks Online.
When importing a list of your products and services in QuickBooks Online, this will not show on the Profit and loss or in the Balance Sheet reports. This is because the said reports are only used to shows your summary of income and expenses for your business. Then, a snapshot of what a business owns (assets) and owes (liabilities) at a specific point in time. This is usually completed at the end of a month or financial year and is an indicator of the financial health of your business.
The imported inventory appears in the Product/Service List report. That said, I suggest going to the Reports menu at the left panel to pull up the said report. From there, you'll see the specific cost and price per item. I attached a screenshot below for visual reference.
However, if the uploaded inventory items are already sold, this should be reflected in the Profit and Loss or in the Balance Sheet. That said, I recommend logging in to your QuickBooks account using a private browser. This is to rule out the possibility of a webpage issue, and private browsing doesn't store local files or cache.
Use these keyboard shortcuts based on the browser you're using.
If it works in incognito, I recommend clearing the cache of your regular browser. This removes the history or log of sites so you can start with a clean slate. You can check this article to see the steps: Clear cache and cookies to fix issues when using QuickBooks Online.
If the steps above didn't work, use another supported browser as alternatives.
You can also refer to this article to see several troubleshooting steps on how to resolve transactions that are missing from your Profit and Loss report: Why are my income and expense transactions missing from my Profit and Loss report?.
If the issue persists or needs further assistance with the information mentioned above, I suggest contacting our QuickBooks Support Team. They have the tools to pull up your account investigate the cause of the issue. They can also provide extra details on how inventory works in the system.
Please refer to this article to see steps on how you can manually enter your inventory products and the details associated with the items: Add inventory products in QuickBooks Online.
Please know that I'm just a post away if you have any other questions about the report. Wishing you and your business continued success.
Thank you for reply.
I know how profit and loss and balance sheet work.
I uploaded inventory with opening balances.
Now, inventory value is reflecting on the balance sheet. Except a few 20 product value.
I guess I should contact support.
Update:
I contact the support and support team sorted out my issue.
Thanks for the reply everyone.
Can you please explain how your issue got resolved? I am having the same issue here.
Everything is updating correctly except for COGS. Thank you.
Thanks for chiming in on this thread, OVBaccount.
If you have followed the steps shared above and still getting the same situation, I'd recommend reaching out to our Customer Care Team. They can do a screen sharing session with you and investigate what's causing this behavior on your Profit and Loss report.
Here's how:
If you have the new QuickBooks Assistant help update, you can follow these steps:
To learn more about the reports in QuickBooks Online, you can read this article: Reports included in your QuickBooks Online subscription.
Please keep us posted on how it goes. We want to make sure this is resolved for you. Take care and stay 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