Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Aaron1979
Level 1

Refunds

I am in the auto business. I purchased 6 spark plugs from one of my vendors for $23.54 per plug. This part is an inventory item so I entered the expense in. I realized after the fact that the vendor charged me full retail at $23.54 per plug instead of $14.12 per plug. They refunded me the difference which was $ 9.42 per plug for a total of $56.52. They refunded me back to my business bank card which I verified hit my account. The question is how do I properly receive this partial refund so it will accurately show what I actually paid per plug and also ensure that it hits the correct account which is inventory assets. I have already tried creating a vendor credit / bank deposit / create an expense and while that will allow me to clear the credit from the vendor and allow me to match the transaction in the bank feed it does not allow me to reflect an accurate running total for how much I have actually spent with the vendor for the year and it also does not accurately reflect the true total for what should be in the inventory asset account if I check it in the trial balance. The recommended method I have found so far appears to create two credits of the same amount where there should only be one. 

11 Comments 11
Rainflurry
Level 15

Refunds

@Aaron1979 

 

Why can't you just create a credit card credit and assign your inventory asset account to the credit?  Go to New > Vendors > Credit Card Credit.  Choose the vendor under 'Payee' and under 'Category details' select your inventory asset account and the amount of the refund.  That should allow you to match the bank feed, reduce the amount spent with the vendor and reduce your inventory asset value.

Mich_S
QuickBooks Team

Refunds

I appreciate you providing us the further details about your concern with recording a partial vendor refund, @Aaron1979. I'm here to get the help you need.

 

I actually agree with Rainflurry's suggestion of creating a Credit Card Credit transaction to enter the refund in QuickBooks. Additionally, you'll have to ensure that you select your Inventory Asset account and enter the amount of the refund. I suggest consulting your accountant about the type of account to use or other possible options. To enter the credit, follow these:

 

  1. Click on + New.
  2. Choose Credit card credit.
  3. From the Payee field, pick the right vendor.
  4. Locate the appropriate inventory asset account from the Bank/Credit Account drop-down menu.
  5. Navigate the Category details.
  6. Choose the account that you have for your cash back rewards whether expense/income account as you see fit.
    Please note Kindly review How to create a new parent account or subaccount to create an account to track your cashback rewards, if you don't have one yet.
  7. Fill in the other needed information such as the refund amount.
  8. Click on Save and close.

 

There you go! That should allow you now to match transactions from your bank feed.

 
For future use, I'll also add these modules about keeping track of vendor transactions in QBO:

 

Please keep in touch by leaving a reply below. We're here to assist if you have other concerns managing refunds or QuickBooks in general. Keep safe!

Aaron1979
Level 1

Refunds

Hi Rainflurry,

I do not have a button for credit card credit. Maybe that is for the desktop version?

Rainflurry
Level 15

Refunds

@Aaron1979 

 

In QB Online, go to New > Credit card credit (under Vendors).

Aaron1979
Level 1

Refunds

I found it, I was looking in the vendor section by mistake. Thanks and I'll give this a try.

Aaron1979
Level 1

Refunds

Ok I did what you had suggested and created a credit card credit with the vendor and applied the credit to the Inventory Asset account and when I saved the transaction I received an error message saying " you need to select a different type of account for this transaction" 

Rainflurry
Level 15

Refunds

@Aaron1979 

 

That's odd.  It works fine for me.  Try clearing your cache or use incognito mode (Chrome) or a private window (Firefox)...

Aaron1979
Level 1

Refunds

Ok I tried clearing cache and using incognito with chrome. No change, I still have the same error message.

Rainflurry
Level 15

Refunds

@Aaron1979 

 

Then I’m not sure what to tell you. It works fine for me. Maybe someone else can chime in with a solution.

Aaron1979
Level 1

Refunds

Are you using QB Online?

Mich_S did mention something about selecting an account for cash back rewards but I didn't understand what he meant.

Adrian_A
Moderator

Refunds

I appreciate you for getting back to us, Aaron1979.

 

What my colleague means by selecting an inventory account is to choose the corresponding account of the item. However, we recommend reaching out to your accountant so you'll be guided on the process.

 

Feel free to pin these references for more resources in keeping track your transactions:

 

 

You can always mention my name whenever you need help. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us