Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I closed my retail business last year and had a huge sale to reduce the remaining inventory. All items were sold at one price, regardless of the original price. The sale was chaotic, and I was unable to enter transactions for the specific individual items sold; however, I do have a list of what was left after the sale, so I know what the ending value needs to be. How can I adjust the value of the inventory - while also addressing the loss due to the deeply discounted sale price?
For example, an item that cost me $120 and originally sold for $275 was sold at the final sale for $45.
I have already entered the income from the sale on the check register, but still need to adjust the inventory value and account for the loss.
Thank you!
I know a way how to adjust inventory value for loss due to discounted sales, erinfs.
You can adjust your inventory by using the Opening Balance Equity as the posting account. This way, it will not show on the Profit and Loss Report.
To begin, create the account so you can use it when adjusting the inventory parts. Here’s how:
Let me know if you have further questions or any other concerns. I’m always ready to help. Have a good one.
I’m also adding articles with links to help get started with QuickBooks Desktop.
Let me know if you have further questions or any other concerns. I’m always ready to help. Have a good one.
Thank you so much, but I'd like to adjust the value, not the quantity, as there were hundreds of items sold in this sale. If I wanted to do that much work, I'd just create an invoice. Also, to be clear, this was for a business that I closed, so I don't know that using Opening Balance Equity is the right approach.
You want to do a journal entry to reduce inventory with a corresponding increase in cost of goods sold (COGS). To do that, create a journal entry by debiting COGS and crediting inventory. Up until the point where things got chaotic, were you tracking the COGS of items that sold? If so, I would use the inventory number at that point and subtract your ending inventory to get your COGS debit/inventory credit. If not, post more info and I can try to help further.
The only "loss" you have is the difference between what you sold an item for and what you paid for it (COGS). In your example, an item that cost you $120 and sells for $45 will result in a loss of $75 ($120-$45). The $275 original price is irrelevant.
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