Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowApologies in advance for newbie type question. We have been using QB for 24 years. We made a commitment to make sure all the COGS are correct from 9/1 through the end of the year so we can figure out what the score is rather than "lights are on, everyone got paid, come back tomorrow." mentality. We corrected the COGS from 9/1 for each item but when we refresh the report of "sales-by item summary" the old cost continues to show up. Is there a way to have the updated cost show up in the report? Thanks in advance.
I can share some information about updating your information that will show in your reports, @Toznator.
You mentioned correcting COGS, are you referring to the accounts used? Note that updating accounts won't affect past transactions, only future ones.
If you want to show updated costs in your report, recording journal entries can be a good option. However, it is important to use the appropriate categories to avoid messing up your account. To ensure that you use the correct accounts when recording journal entries in QuickBooks, I would suggest consulting with a trained and qualified accountant. They can provide you with the necessary guidance and help you avoid any potential errors.
Here's how:
Here's more information about creating a journal entry in QuickBooks Desktop for Windows or Mac.
Refer to this article for more information about how QuickBooks handles inventory assets, average cost, and Cost of Goods Sold (COGS): Understand inventory assets and cost of goods sold tracking.
For more information on how to add filters to your report and get the exact data you need, check out the article: Customize reports in QuickBooks Desktop.
Let me know if you need further information about your reports. I'm always here to assist. Have a great rest of the day!
What did you do to update the COGS of items?
The only way to effectively update (reset) the cost of an inventory item and have it reflect correctly on sales would be through a Bill or Inventory Adjustment dated prior to the sale date.
The item should not have any quantity on the date prior to the adjustment stated above.
Let me know if you need more detailed instructions.
Let me know if this helps.
(Please cheer/kudo if you like my answer.)
JS
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