Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi there, @mccoy.
I can share some information about the closing of books feature in QuickBooks Online.
The possible reason why reports keep changing the COGS value is that there are created transactions within the set close date. As a suggestion, you can try running the Audit Log. This report will let you see who made the changes and exactly what changes were made in your QuickBooks Online company file.
Let me know how it goes or if you have additional questions. The Community is always here to provide answers.
I ran reports of all transactions within the closing date and modified by who.
No transactions were made after the closing date....but the cost of goods value continues to change.
@mccoy wrote:but the cost of goods value continues to change.
change compared to what?
I pulled our fiscal year end P&L on Sept 10th and again on Oct. 24th, and again on Nov 16 - the value of the cost of goods was different on each report and thus our profit/loss changed. This fiscal year ended May 31. There were no new transactions dated within the fiscal year.
Although this should not be happening - the likely culprit is an inventory 'item' and the offsetting change is probably in inventory value. Use the inventory item value report and compare to a prior version (if you have one). A change in a transaction date (or cost) on an item receipt/purchase can ripple forward in COGS & inventory. However, if the prior year is locked then you shouldn't see new changes. Note that if someone unlocks the period and makes changes then re-locks, it will show in audit trail, but will not be flagged as a prior period exception
I'm experiencing the same issue with one of my COGS accounts. I have an old backup that doesn't seem to have the issue. Is there an easier fix then rebuilding all my data from 3 weeks ago?
I got some others ways to fix your COGS account, Yeazel.
You'll want to download our QuickBooks Tool Hub tool and run the Quick Fix my File. This scans your company file for issues and fixes them right away. I'd be glad to show you how.
You can also check this article for more details and additional troubleshooting steps: Fix company file and network issues with QuickBooks File Doctor.
Once done, I'd recommend updating your QBDT to the latest release to avoid any issues in the future.
I'm also attaching these articles that you can use for guidance in managing your COGS. These provide details on how to keep track of your COGS and inventories:
I'm always here to help if you're still having issues with your COGS account, I'm just a few clicks away from you.
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