cancel
Showing results for 
Search instead for 
Did you mean: 
thomastonmilk
Level 1

How can I record a customer credit memo that does not restock the item?

We sell milk to schools and stores.  Most all customer returns cannot be resold.  Every customer credit memo returns the item to inventory and adds the COGS back to our customer sales on reports which throws off our total sales and profit and loss.  How can I create a credit memo in Quickbooks Desktop Accountant 2019 that does not restock the item or return it to inventory?  Your help is appreciated.

 

Solved
Best answer February 14, 2022

Best Answers
Rainflurry
Level 13

How can I record a customer credit memo that does not restock the item?

@thomastonmilk 

 

Using a credit memo should work fine.  Just set up a non-inventory item called "Milk Returns" or "Spoilage" or something similar and assign that item to whatever expense account you use for the returns.  Then, issue the credit memo.  That will add the credit to the customer's account (by reducing A/R) and book the expense while having no effect on inventory.    

View solution in original post

7 Comments 7
SarahannC
Moderator

How can I record a customer credit memo that does not restock the item?

Hello there, @thomastonmilk.


When creating a credit memo in QuickBooks, it affects your items. QuickBooks will record them in your Profit and Loss report and Sales report.

 

With that, in QuickBooks, there's no direct way to create a credit memo that will not restock the item.

 

 You can create journal entries to keep things you want. Still, you can consult other accountants for further assistance and ensure you'll be using appropriate accounts in the process. They might also share with you another way on how to handle them accordingly.

 

Here's how:

 

  1. Go to the Company menu.
  2. Select Make General Journal Entries.
  3. Fill out the fields to create your journal entry. Make sure your debits equal your credits.
  4. Select Save or Save & Close.

 

You'll want to check this article for more details and tips: Learn how to record journal entries in QuickBooks Desktop.

 

If you notice a discrepancy between the Profit & Loss and a Sales reports, you can visit this article to learn more on how you can troubleshoot them: Profit and Loss report does not match a sales report.

 

Visit again if you have further concerns. I'm always here whenever you need help. Stay safe, thomastonmilk.

thomastonmilk
Level 1

How can I record a customer credit memo that does not restock the item?

Thank you for your response but this solution will not work for me.  We have over $16,000 in daily sales with multiple items returned almost daily.  It would take me forever to do journal entries for each item on a credit memo.  I feel Quickbooks should have made adjustments in this software for that situation.  I'm sure I'm not the only wholesale or retail business that sells consumable products that cannot be returned to stock.  I'm using 2019 Desktop, hopefully they have remedied this in 2022.

Rainflurry
Level 13

How can I record a customer credit memo that does not restock the item?

@thomastonmilk 

 

Using a credit memo should work fine.  Just set up a non-inventory item called "Milk Returns" or "Spoilage" or something similar and assign that item to whatever expense account you use for the returns.  Then, issue the credit memo.  That will add the credit to the customer's account (by reducing A/R) and book the expense while having no effect on inventory.    

BigRedConsulting
Community Champion

How can I record a customer credit memo that does not restock the item?

@SarahannC 

RE: With that, in QuickBooks, there's no direct way to create a credit memo that will not restock the item.

 

Of course there is, which @Rainflurry came up with - it seems without any effort whatsoever.

thomastonmilk
Level 1

How can I record a customer credit memo that does not restock the item?

I'm not sure I agree with "without an effort" because I tried it and creating an non-inventory item "returns or spoilage" did not work for me plus we have over 1000 items. Other suggestions are welcomed.


@BigRedConsulting wrote:

@SarahannC 

RE: With that, in QuickBooks, there's no direct way to create a credit memo that will not restock the item.

 

Of course there is, which @Rainflurry came up with - it seems without any effort whatsoever.


 

Rainflurry
Level 13

How can I record a customer credit memo that does not restock the item?

@thomastonmilk 

 

What didn't work about it?  When I set it up and issued a credit memo, it booked an expense (as opposed to restocking the item) and corresponding customer credit.  Isn't that what you're trying to accomplish? 

AlcaeusF
Moderator

How can I record a customer credit memo that does not restock the item?

Hello Rainflurry,

 

I have reviewed the solution you’ve shared and it's correct and accurate. Thank you for sharing your inputs to help address the issue.

 

We love to see members supporting one another! Have a great day.

Need to get in touch?

Contact us