Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I joined a company that had several years of invoicing without every building the assemblies that were being sold. When I ran the inventory valuation it showed nearly 1.2mm in items, and -1.068mm in assemblies.
I began cleaning up and have brought the inventory in line by processing build transactions - and have brought it down to approx 250k current inventory, and the majority of negative assembly items cleaned up.
The problem now, however, is that the P&L is reflecting a negative amount in the COGS - Manufactured assemblies account. 1) Why would this happen? We've spent nearly 1mm in components and it appears to not be reflected here. 2) Is there an adjustment that can be made to correct this and adjust the COGS account so that the P&L reflects more accurately for this year?
Hello there, @taze83.
Let me step in and assist you with your concern.
You can check on how you generated the inventory sell. Make sure that you've entered the price and rate for each quantity for the purchase transactions. In that way, it will not show your COGS as a negative amount in your Profit and Loss report.
Please follow these steps to edit the price and rate:
We also advanced inventory feature to help you track inventory stored at different sites or locations.
Please know that I'm always around here in the Community to help. Take care, and have a great day.
@Rejeil_O - are you saying if I go edit an item even after the build transaction, that it will correct this? One example I'm looking at had a sales amount already entered - it was incorrect, so I fixed it - but it still had one. After correcting it, in the Item it still had no effect on the COGS - Manufactured Assembly account.
Good Morning, @taze83.
Thanks for reaching back out to the Community.
Inventory COGS is only affected by selling inventory items on invoices and sales receipts. When you sell inventory items, you can run the Transaction Journal Report to see that the Inventory Asset account is credited and the COGS account is debited. You can check out these two links below for more information:
To have some clarification on the issue, can you please provide some screenshots on where you're seeing this information within your QuickBooks Desktop (QBDT) account? This will allow me to determine the best solution for your business.
I want to make sure that you're able to get back to running your business. The Community is always here to have your back. I'll be waiting for your response.
@Candice C Here are a couple of screenshots....
First is the P&L showing the negative balance in Manufactured Final Assembly..
Second is within the account - some of the build transactions driving it down
Finally - what it looked like at YE2019 (and every prior year as well).
As mentioned, they never did any build transactions to relieve inventory, and I'm wondering if this is a "correction" the system is doing that should actually be spread across previous years?
Thanks for the complete description of the issue and the screenshot above about COGS and assemblies in your QuickBooks Desktop (QBDT) account, @taze83. With this, I can guide you on the actions you need to take care of the issue.
Based on your screenshot above, I can see that your build assembly is the one with the negative balance instead of the total Manufactured Final Assembly. Yes, this might be the system's way of correcting the previous year's inventory records. With this, you'll have to drill down the transactions involve to identify the cause of the negative amount and if the correction is spread across prior years. Here's how:
I've attached a screenshot below that shows the last four steps.
After reviewing your data, you'll be able to determine the transactions associated with your assembly. Then, to check what your P&L report's Manufactured Final Assembly total looked like for YE2019 (and every prior year), you'll have to change and set the date. Then, make sure to refresh the report to implement the update.
To learn more about how QuickBooks handles inventory assets and Cost of Goods Sold (COGS), I'd recommend checking out this article: Track inventory in QBDT. It also provides a detailed explanation of your average cost.
You can get back to us and share whatever you've found out after reviewing your P&L report. Just select the Reply button below. I'm just around to help. Take care always.
@Rea_M I'm trying to follow these steps - but after I go to P&L, double click in the Final Assembly COGS negative amount, it opens the detail report showing the many credit numbers to the account associated with the build assemblies - but if I double click on those, it only opens the build transaction, nothing revealing in terms of dollars and cents. Is there another step I should be taking?
Hello there, @taze83.
When you're unable to get further details about the COGS negative amount through the P&L report, you can pull up another one. This is to further investigate the cause of the negative Final Assembly COGS amount in your QuickBooks Desktop (QBDT) account.
Negative Inventory can show up not just in the P&L report, but also on the following reports:
Since you're using the Enterprise version of QBDT, let's focus on the Negative Item Listing report. Just a heads up that the said report will show current negative quantities but not the past ones. Here's how:
Additionally, to prevent your inventory assemblies show incorrect COGS on your reports, you'll have to avoid selling build items with insufficient quantity. To learn more about the effects of your negative assembly on your company file, kindly check out this article: Fix negative inventory issues in QuickBooks Desktop. It also outlines steps to fix issues from negative inventory.
Leave a comment below if you have follow-up concerns regarding the Final Assembly COGS amount. I'm just around to help. 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