cancel
Showing results for 
Search instead for 
Did you mean: 
NauticalJim
Level 2

inventory write off

HI if I need to write off an inventory item due to a loss or damage etc what is the correct way so that it shows im out the cost of the item as well as the quantity?  It seems if the adjustment on hand using the Cost of goods sold account I dont see any change in my P&L or loss?   Please help...

13 Comments 13
gayatriluthfias20
Level 7

inventory write off

Hi @NauticalJim , Create a sub account of COGS called loss/theft/spoilage and use that account when you do an inventory adjustment.  Lower the qty of items that need to be written off. Refresh qbo with clear cache and browsing history. You could use credit memo too for replacing inventory sent to customer. Please see the post  and this post . Comment back, cheers.

AlexV
QuickBooks Team

inventory write off

Good to see you here, NauticalJim.

 

Let me assist you with your inventory.

 

The inventory adjustment is the right way to write off inventories. Also, you will need to select an Expense Account as the Adjustment Account to reflect this on your profit and loss report.

 

Please check this article for your reference on how to adjust your inventory quantity or value in QuickBooks Desktop.

 

Comment below if you need more help. Have a great day!

NauticalJim
Level 2

inventory write off

Thanks alot!  Well what we had done was to put the inventory adjustment into a cost of good sold account however it seems all that does is take it out of inventory so it doesnt affect my P&L or show a loss.  All it does is to reduce my inventory so I pay a little lessbusiness property tax at the end of the year but I dont get the writeoff.  Am I correct?  So exactly how should I make the account so the value of the item taken off inventory shows as a loss on my P&L?  Thanks again..keep in mind im notm an accountant or bean counter lol

 

NauticalJim
Level 2

inventory write off

Thanks also Alex...so it appears thereare different ways to adjust down inventory...one is to just take it off and another is to take it out of inventory and anotheris to take it out of inventory and show the item as a loss...correct?  I have another somewhat related question.  If I send items to Amazon fulfilment...how do I

1 correctly adjust inventory as its not in my posession

2 At the end of the year do I then put in what was sold and adjust out the cost somehow?  Thats a bit more tricky lol

JasroV
QuickBooks Team

inventory write off

Thanks for sharing additional details, @NauticalJim.

 

The inventory adjustment will reflect in your Balance sheet report from the asset side. The Profit and Loss report only reflects if there are changes made on your sales and expenses.

 

Then, to correctly adjust your inventory, you'll want to create sales to put what was sold. This way, QuickBooks automatically adjust your inventory items. 

 

Then, for your 2nd question, I’d recommend consulting with your accountant for the best action to take. Your accountant can give you expert advice on recording it while ensuring your accounts stay accurate.

 

Also, check out this article for more details in managing your inventory quantity: Adjust your inventory quantity or value in QuickBooks Desktop.

 

Leave a reply if there’s anything you need help with managing your inventory or with your QBDT software generally. I’m always around to help you. 

NauticalJim
Level 2

inventory write off

Thanks for your answer but still a bit confused.  I understand that if I sell something it takes out the inventory and applies the cost towards the sale.  Inventory adjustment of damage should take out the cost as well as quantity so it shows a loss.  Now another question would be if I sell something....gets damaged from Fedex or whatever carrier we use....comes back to us.  Then we put in a claim for damage through insurance....and we get an amount that could be cost or more or less...how should we handle it?  Currently we are adjusting the item out at zero dollars on the original invoice but keeping in the inventory number...if we get a check we are creating a credit memo putting the item at whatever amount they paid us for damages as well as any refund of delivery.  But it appears that isnt going into an income account...Is there another (better)way of doing it?  Thanks again.

Jen_D
Moderator

inventory write off

Hi there, @NauticalJim,

 

I can share a few insights about the process of writing off inventory in QuickBooks. Inventory tracking uses different journal posting in your books when receiving inventories and selling them.

 

When you purchase or receive inventory, it debits the Inventory Asset account which is posted in the Balance Sheet report. If there are changes in the quantity because of damages, fire, theft, or breakage, and etc., that's when you use the adjustment option.

 

This method affects both the Asset and the COGS account, but not necessarily show a loss in your books. This is because, we are only changing the quantity and asset value of the item, but the average cost of the item remains the same. For example, if the average cost is 10 and you reduce the quantity by 2, QuickBooks reduces the value of the items on hand by 20.

 

If you want to track the loss in the P&L report, you will need to a different entry to account for the unrecoverable funds from damages. This is method is what we call writing off a bad debt. This article can explain the process and steps for you: Write off bad debt in QuickBooks Desktop

 

Regarding the other question about the insurance claims, there is a way I can suggest for you. You can set up the insurance company as a customer in QuickBooks, so you can transfer the balance from the original client and apply the claim as a payment. Here's how:

 

Step 1: Create a clearing account.

 

  1. Go to the Lists menu and select Chart of Accounts.
  2. Right-click anywhere and click New.
  3. Choose Bank then enter the name Clearing Account as the Account Name.
  4. Press Save & Close.

Step 2: Add the Insurance Company as customer.

 

  1. From the Customers menu select Customer Center.
  2. Right-click anywhere in the list the choose New.
  3. Enter the agency's name in the Customer Name or Company Name field.
  4. Lastly press OK.

Step 3: Create two journal entries to transfer the Balance.

  1. Go to the Company menu and choose Make General Journal Entries.
  2. On the first entry, credit Accounts Receivable and assign the original customers name and debit the Clearing Account.
  3. For the second entry, credit the Clearing Account and debit Accounts Receivable. Choose the Insurance Company this time.

Step 4: Receive the payment.

 

  1. Go to the Customers menu again and choose Receive Payments.
  2. In the Receive From field, enter the insurance company.
  3. Click the outstanding transaction on the result, then on the Payment column, enter the amount you received from them (not more than the invoice amount).
  4. If you receive more, create a credit transaction for the remaining amount so you can apply it next time.
  5. Otherwise, if you receive less, use the write off option for the loss.

Please note that these steps is just a workaround. We always recommend seeking help from an accountant for accounting help and guidance. We want to make sure your books are correct and there is no room for mistakes.

 

Let me know if you have any questions about this. Feel free to connect with me again by clicking the Reply button below. Have a great weekend!

Motor
Level 1

inventory write off

Hello,

I am new to this community so I hope this is the right place to post a question. I have goods that I can't sell any more. How do I write off these inventory goods as an expense or as a loss?  

Which are the specific accounts that must be affected? What is the mechanism in QB to do this? 

What happens later if I am able to sell them at a price less that what I paid for them? How would I enter such a sale?

Thank you.

beckellh
Level 2

inventory write off

I don't have an answer, just want to stay in the loop for this question, because I have the same one.  Expired inventory that needs written off.

AlexV
QuickBooks Team

inventory write off

Hello beckellh!


You can make an inventory adjustment in QuickBooks Online. Let me show you how.


Make sure to set up an inventory adjustment account to track your adjustments. Follow these steps:

  1. Go to the Lists menu and then Chart of Accounts.
  2. Select the Account dropdown, then New.
  3. From the Other Account Types dropdown, select Cost of Goods Sold.
  4. Name this account “Inventory Adjustments”, and then Save and Close.

 

Once done, go to the Inventory menu and select Adjust Quantity/Value On Hand. Then, you can run the Inventory Valuation Summary report to verify that your inventory is now accurate. You can pull up this report when you hover over Inventory from the Reports menu.


Please check this article for more details on how to make an inventory adjustment: Adjust your inventory quantity or value in QuickBooks Desktop.


I'd be glad to help you if you have other concerns. Have a great day!

beckellh
Level 2

inventory write off

Since mine is a write-off due to an expiration date, shouldn't it be a loss?  Yes, putting it in the COGS affects inventory, but I also need it to as a loss.  Now what are my options?

Candice C
QuickBooks Team

inventory write off

Good morning, @beckellh

 

Thanks for reaching back out to the Community. I appreciate you coming here with your question. 

 

Since the problem persists, I suggest contacting our Customer Support Team for further assistance. They'll be able to use more advanced tools to help you out further and take a closer look at your account. Here's how: 

 

  1. Go to the Help menu. 
  2. Press the QuickBooks Desktop Help option. 
  3. Hit the Contact Us hyperlink. 
  4. Give a brief description and click Let's talk
  5. Scroll down and choose to Get a callback

 

It's that simple. 

 

Keep us updated on how it goes. We want to ensure that you're taken care of as soon as possible. Have a splendid day! 

dipmala
Level 1

inventory write off

To successfully control losses while dealing with inventory of obsolete parts, take into account techniques like inventory write-offs. Partnering with organisations that specialise in optimising spare parts inventories, such as Entytle, can also provide solutions to reduce obsolete stock and enhance overall inventory management effectiveness

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us