Skip to main content
K
kmasta
October 27, 2020
Solved

How do I adjust inventory for damaged items so that it affects Cost of Goods but also shows up in profit & loss report Using Quickbooks Desktop?

  • October 27, 2020
  • 2 replies
  • 0 views

I have to damage some items out of my inventory in Quickbooks Desktop and when I do I need them to make my Cost of Goods go up.  For example, I understand that a damaged item is cost of goods and I want it to reflect that properly in reports.  However, I don't know how to do this when I do an Inventory Adjustment.  In Inventory Adjustement if I use an Expense Account as my adjusting account as it suggests how will that affect Cost of Goods and make it go up? 

Best answer by QBsguru

When adjusting inventory for damages, you are crediting (reducing) your inventory asset and increasing (debiting) either an expense account for a COGS account.  If COGS, this account will increase by the inventory adjustment.  If you want to track damage costs separately, I suggest you set up a separate account for damaged inventory.  This could be another COGS account or an expense account. 

2 replies

M
Maybelle_S
October 27, 2020

Hello there, @kmasta.

 

If you occasionally write off small amounts of damaged inventory, you do not have to make a separate disclosure on the income statement. The loss is included with the cost of goods sold amount. A separate account such as loss from the write-off of Inventory is included with the other inventory accounts.

 

We can do an inventory adjustment to lower the number of items. Here's how:

  1. Go to the Lists menu and select the Item List.
  2. On the Activities tab, click the drop-down arrow and select Adjust Quantity/Value on Hand.
  3. Select the Adjustment Account by clicking the drop-down arrow. Please consult your accountant to ensure the account recorded is the right account for your business.
  4. Select the item used and record the New Quantity and Qty Difference.
  5. Once done, click Save & Close.

I've also added this link about inventory assets and the cost of goods sold tracking in QuickBooks Desktop (QBDT): Understand inventory assets and cost of goods sold tracking.

 

Let me know how it goes by dropping a comment below. I'm always here to help. Take care!

K
kmastaAuthor
October 27, 2020

Hi thank you for your response but it didn't answer my question.

I want to clarify hopefully you can edit your response or someone else can see I still  need help.

 

Firstly, I am not adjusting inventory for personal use I'm adjusting for damages. 

Second, I was asking what account to use and why and your answer says to ask an accountant.  I don't have one because my business is too small.

 

Also, I am trying to find out how to reduce Cost of Goods Sold when I adjust my inventory for damages in QBD. 

Q
QBsguruAnswer
October 28, 2020

When adjusting inventory for damages, you are crediting (reducing) your inventory asset and increasing (debiting) either an expense account for a COGS account.  If COGS, this account will increase by the inventory adjustment.  If you want to track damage costs separately, I suggest you set up a separate account for damaged inventory.  This could be another COGS account or an expense account. 

    A
    antoncleverence
    February 6, 2025

    Hello!

    To adjust inventory for damaged items in QuickBooks Desktop and have it affect COGS and the Profit & Loss report, follow these steps:

    Go to Vendors > Inventory Activities > Adjust Quantity/Value on Hand.
    In the Inventory Adjustment window, select Cost of Goods Sold as the Adjustment Account.
    Choose the damaged items, enter the quantity to adjust, and provide a note for clarity.
    Save the adjustment.
    This ensures the cost flows into COGS and shows up in your reports. For mobile-friendly inventory tracking, Cleverence Warehouse 15 integrates with QuickBooks to manage inventory adjustments seamlessly.

    Learn more: Cleverence Warehouse 15
    https://www.cleverence.com/solutions/quickbooks-warehouse-15/

    Terms & ConditionsAccessibility statement