Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
LBorkin
Level 1

How to correct a negative Finished Goods COGS going back 13 years

I just started working with a Manufacturer using QB Desktop Premier Plus Manufacturing. The owner was a DIY bookkeeper for himself starting in 2013. He is using inventory for his assemblies but was invoicing for years without building assemblies and just adjusting inventory quantities once or twice a year. Fast forward to this year  - the Finished Goods COGS account is in the negative.

 

I've gone back to 1/1/25 and built assemblies to match the invoices generated but how do I adjust the account on 1/1/25 to show the actual value of the Finished Goods in inventory to correct the Balance Sheet? The CPA never said anything to him about the numbers being off and closed out 2024 after preparing the tax return.

1 Comment 1
PollNofer
Level 3

How to correct a negative Finished Goods COGS going back 13 years

I’ve seen this before. You can’t really fix 13 years of activity retroactively without reopening old years (and you don’t want to, since the CPA has already closed 2024). The cleaner approach is to treat January 1, 2025, as your reset point.

 

What most folks do in that case is book a one-time journal entry on 1/1/25 to true up Finished Goods Inventory to the actual value you’ve determined. That way, the Balance Sheet reflects the correct inventory asset, and the offset is applied to an equity account (usually Opening Balance Equity or a custom adjustment equity account). From there forward, make sure all assemblies are built before invoicing so COGS flows correctly.

 

If you try to fix all prior years, you’ll throw off tax filings and reconciliations that the CPA already signed off on. Better to lock the past and start clean. You may also want to involve the CPA now just to document why you adjusted, so future audits or reviews don’t raise red flags.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us