Skip to main content
October 16, 2018
Question

How do I match a vendor credit with the amount deposited back to the bank account?

  • October 16, 2018
  • 4 replies
  • 0 views

I received an expense from a vendor that is ACH directly from my bank account twice a month.  I entered the expense and matched it when it hit the bank.  The same vendor issued credit for the bill, depositing the funds back.  I entered a vendor credit because I want record of the credit memo and expense (in and out), but how do I match the bank entry with the vendor credit which still shows a balance amount? 

4 replies

October 16, 2018

Hi there cdawkins,

Thanks for providing those details.

Since you already entered a vendor credit, we must create a Bank deposit first to match your bank transaction.

Here's how:

  1. Select Plus Icon (+)  at the top, and click Bank Deposit.
  2. In the Add other funds to this deposit section, fill in the following fields:
         Received from: Select or enter the vendor name.
         Account: Select the Account payable account.
         Amount: Enter the check amount.
  3. Select Save and Close.

To link the deposit to vendor credit:

  1. Select Plus Icon (+) at the top, and click Check.
  2. Select Choose a payee drop-down arrow, and click the vendor name.
  3. Provide the Check #, Date, Amount and Memo fields blank.
  4. From the Add to Check sections, select Add for the outstanding vendor credit and deposit.
  5. Select Save and Close.

You can also check the article: How do I handle vendor credits and refunds?

Should you have other questions, please let me know. Have a great day!



October 16, 2018
This method seems to cancel off the outstanding amount on the expense account, but it leaves the original cost and refund transactions in the Banking "for review" list.  Please explain... are we then meant to exclude those, and not match them to anything?
Rustler
October 16, 2018

The same vendor issued credit for the bill, depositing the funds back.  I entered a vendor credit because I want record of the credit memo and expense (in and out),

this is fine

but how do I match the bank entry with the vendor credit which still shows a balance amount?

As suggested, on the deposit change the from account to accounts payable and use the vendor name - THEN use pay bills, select the bill the deposit made, and apply the vendor credit to pay it.

match the deposit in QB to the banking download


September 19, 2019

Your post just saved my life!!  I changed the from account to Accounts Payable and VIOLA!!!!  Thank you.  I have spent hours and days trying to figure this out.  

qbteachmt
October 16, 2018

"The linking of the deposit to the vendor credit, shouldn't that be a NON-posting transaction"

You got Real Money. That needs to Post as part of banking.

"or if it does create a journal entry"

Never use JE for AP or Banking. You don't use JE when Names are involved, and you don't use JE for anything where the program already has tools. You have Banking tools and Vendor Tools. And using a JE for AP means you just broke "cash vs accrual basis" reporting.

"To summarize:  VC:  dr A/P, cr Exp."

No.

"Bank Deposit: dr Cash  cr A/P"

No.

Learn to use the Tools that are provided.

If you got a refund and enter that as a Deposit, such as returning a bad toner cartridge = Office supplies, you realize, Hey, I cannot use my product/services here, or track that it relates to a specific customer name. So, when you need to enter More Info, such as returned Inventory products or got a refund for Services rendered, and might also want to track Customer name, that is why you start with the Vendor Credit.

And if you used Vendor Credit, you already created negative AP. That means the Refund is Debit Bank and Credit AP; which means using the Deposit screen, to show the deposit of the refund check is AP for that vendor name. That is why you then can link the refund to the available credit, in the Bill Payment function.

"Otherwise it would be creating a negative balance for AP again"

The Deposit, posting as AP, shows as if this is Bill to be paid; that's why you can link the earlier Vendor Credit to that deposit. That closes out the AP for that name.


December 12, 2018

It’s nice to see you in the Community space, pgazso.


I want to ensure the returned items are properly tracked in your account.


I'm glad to let you know that you can enter a bank deposit and input the transaction to the same expense account. Let me provide you the step by step process.


Here’s how:

 

  1. Go to the Plus icon (+) at the top, and select Bank Deposit.
  2. Click on the drop-down for Account, and select the appropriate bank.
  3. In the Date field, enter the correct period.
  4. Go to the Add other funds to this deposit section.
  5. In the Received from column, select a vendor.
  6. In the Account column, enter the expense account you want to post the transaction.
  7. Enter the amount of the deposit.
  8. Click on Save and Close.

That'll do it. By following these steps, the returned items are already posted to the correct account.

 

I added a link where you'll find the latest news and updates about the product. You may want to visit this site: The QuickBooks Blog.

 

Keep me posted if you have questions about QBO. I'll be around to answer them. Wishing you the best.

 

 

 

 

 

February 8, 2022

I've followed the guidance on this thread, but I'm still not getting where I want to be.  Here's my situation...

 

I rented a truck. I was charged a $150 deposit (to debit card) when I picked it up. When I returned the truck, the total rental charge was deducted from my deposit, which resulted in $31.63 being refunded to my debit card. I Have 2 transactions in my books -- an expense for $150 and a deposit for $31.63.

 

I want the refund to show up in the Vendor transaction list (to reduce the total $ spent with this vendor).  I've tried to credit a vendor credit, deposit to A/P, pay the bill, etc.; but because I'm recording expenses, not paying bills, this just creates opens/overdues for the vendor and messes up the total $ for the vendor.

 

I'm sure I'm missing something, but this sure seems unnecessarily complicated.  Ideas?

KlentB
March 6, 2020

I'll help you track and match that deposit, lainscough.

 

When we add a line item in the deposit, we can select the name of the project associated with your vendor from the RECEIVED FROM column. This way, we'll be able to link the deposit to your project. I'll guide you how:

 

  1. Click the + New icon.
  2. Select Bank Deposit.
  3. Choose the appropriate bank from the Account drop-down menu.
  4. Enter the correct period in the Date field.
  5. Go to the Add other funds to this deposit section.
  6. Select the project associated with your vendor in the Received from column.
  7. In the Account column, enter the expense account you want to post the transaction.
  8. Enter the amount of the deposit.
  9. Hit Save and Close to complete the process.

Since we're splitting the transaction and the amount is already divided, we'll no longer have to match it. We can just simply add it instead of matching the deposits. You can follow the steps that I've listed  below:

 

  1. Select Banking from the sidebar menu.
  2. Click the Banking tab.
  3. On the For Review tab, select the deposit to open it.
  4. Tick the Add radio button.
  5. Click the Split button to open the Split Transaction window.
  6. Choose the name of the appropriate customer or project from the RECEIVED FROM column.
  7. Select a Category and enter an Amount for each category to assign to the transaction until the total amount matches the downloaded amount. You can select Add Lines to add more categories.
  8. Hit Save and Add.
  9. Then, click the Add button (beside Edit Split).

There you have it. In case you need to assign and categorize your downloaded banking transactions, you can visit our article to be guided in doing it: Assign, categorize, edit, and add your downloaded banking transactions.

 

Please know that the Community always has your back, so don't hesitate to let me know If I can be of any assistance. Feel comfortable to tag me in your comments.

March 6, 2020

Thank you!  I was getting hung up on the refund coming from the vendor and was selecting that vendor in the Received From column.

 

I could also use a vendor credit, which I tried.  Using this way, I was getting hung up on the visual in the Vendor >> Transaction List.  When you use a vendor credit, then match the deposit to the credit by classifying it to Accounts Payable, then using a bill/expense/check to zero out the outstanding amount, total on the transaction list page shows that the amount is subtracted twice.  However, when I check the affect of the transaction on the Income Statement, the expense account is correct and Net Income is correct.  It's just a visual oddity on the Vendor Transaction List page.

Candice C
March 6, 2020

Thanks for keeping us updated, @lainscough

 

I'm so glad that we were able to provide you with some information on how to resolve your issue about matching a bank feed deposit. The Community is always here to have your back. 

 

Let us know if you have any other questions. I'm always here to lend a helping hand. Have a wonderful day!