Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
MirriamM
Moderator

I received a credit card refund from a vendor. How do I categorize that and add that to my ledger?

I appreciate your input from every angle, bpetryak. 

 

You're right about creating a credit card credit transaction and just excluding the transaction from the bank feed. Since the option to match a credit card credit to a banking transaction isn't an option. The transactions that you can match under the RECEIVED column on the Bank transactions page are the following:

 

  • Open invoices
  • Receive payments
  • Deposits
  • Sales receipts
  • Journal entries
  • Transfers

 

The transactions that you can match under the SPENT column are as follows:

 

  • Open bills
  • Checks
  • Bill Payments
  • Expenses
  • Journal entries
  • Transfers
  • Credit Card Payments
  • Refunds receipts

 

To better guide you in managing your downloaded bank transactions, I recommend checking these articles: 

 

 

To ensure hassle-free reconciliation of your account in the future, you may refer to our article on the best practices for the reconciliation workflow in QuickBooks. It also guides how to overcome challenges during the reconciliation process.

 

If I can be of further assistance in managing your credit card credit or bank transactions, I'm just a post away. The Community Team is on the lookout for your response on this thread.

owner8
Level 1

I received a credit card refund from a vendor. How do I categorize that and add that to my ledger?

I don't believe qbo agents do not know how to work with bank feeds.  What they do not understand is when you are working with bank feeds, you are not going to "New" and creating anything.  You are working from the checking account feed or the credit card account feed.  When you have a charge come in on your credit card feed, it comes in as a positive amount.  When you categorize and save, it saves automatically as an expense.  You do not have to create anything.  QBO does it for you.  When you return a product to a vendor it shows up in your credit card account feed for review as a negative number.  At this point again, you do not create anything "New".  This is suppose to be automated so that it streamlines the process.  Im assuming that this is something fairly new for QBO because I haven't corresponded with anyone in customer service that isn't doing it old school and are not familiar how bank feeds work.  To make it simple, I simply categorize the credit that comes in as a negative number as the same category I categorized for the initial positive transaction.  This way my project reports and expenses numbers are correct.  For example... I purchased something from Home Depot for a job (project).  The credit card feed from Home Depot showed up for review as $100.00.  I categorized this transaction from the review screen as Cost of Goods:Supplies and Materials, assign it to the project and click record.  QBO automatically creates that expense for me.  Three weeks later, we did not need all the material we purchased for the Job (project) so I returned $50.00 worth of products.  The next day that return transaction from Home Depot is in my credit card bank feed as a negative number because it was a credit.  I categorize it as Cost of Good:Supplies and Materials, choose the project and click record.  QBO records it as a negative expense.  But that is ok because it will total out correctly in the end because when it was all said and done I only spent $50 out of that $100 that was originally charged.  So when I pull up the project report it shows me that I only spent $50 on Cost of Goods:Supplies and Materials. And if I look at my total expenses, that credit has been taken out of the total expense category as well.  This may not be the old school accounting way to do things, but it is easy and provides that same number in the end.  The only issue that I have encountered by doing it this way is when I match receipts.  When I upload the refund receipt, QBO will not recognize it as a negative number so it will not match without me opening the receipt and changing the number to a negative. Then it will match and the receipt is attached to that refund transaction.  Hope this helps anyone who is working in QBO through bank feeds.  The wonderful thing is when you strictly using bank feeds you don't have to deal with miss types or entries.  Plus when you reconcile bank statements, it is rare that they don't reconcile first time!

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

Need to get in touch?

Contact us