Skip to main content
February 24, 2023
Solved

How do I match a vendor credit against a deposit for a returned ACH caused by a subcontractor providing incorrect ACH info?

  • February 24, 2023
  • 2 replies
  • 0 views
I had an ACH payment get returned due to a subcontractor providing incorrect ACH info. What do I create to match against the deposit for the returned ACH in the banking feed? Vendor credits do not appear to be matchable to the deposit of the returned ACH. I have already created a new bill and matched it against the sub's new payment with the correct ACH info, so we're reflecting double payment on the sub's 1099. Thanks in advance.
Best answer by Kevin_C

I've got you covered, @SB91. I'll share the steps to ensure you can match the vendor credit to the deposit transaction for returned ACH payment in QuickBooks Online (QBO).

 

You can match the vendor credit to the returned ACH payment by hitting Accounts Payable (A/P) when adding the deposit for the returned ACH in your bank feeds.

 

Let's start by entering a vendor credit to make sure the credit hits the expense account you use for this vendor. Here's how:

 

  1. Click the + New button, then select Vendor credit.
  2. Choose your vendor in the Vendor dropdown.
  3. Depending on how you record purchases with this vendor, enter the Category details or Item details.
  4. Once done, tap Save and close.

 

Then, since the deposit for the returned ACH is in the banking feed, we can add the transaction and ensure to select Accounts Payable (A/P) from the Category section and choose the correct vendor. See the sample screenshot below:

 

Lastly, use Pay Bills to connect the bank deposit to the vendor credit. Even though you aren’t paying a bill, this is the right thing to do as this last step is to keep your vendor expenses accurate. Here's how:

 

  1. Click the + New button, then select Pay bills.
  2. Select the bank deposit you just created. You’ll see the amount of the vendor credit in the Credit Applied field and the Total payment should be US $0.00.
  3. Tap Save and close.

 

Additionally, you'll want to check out this article for the detailed steps in case you need to review all your vendor transactions in QBO: View vendor transactions.

 

Feel free to add a reply below if you have other questions or concerns about your QBO account. The Community is always here to help. Have a wonderful day ahead!

2 replies

Kevin_CAnswer
February 24, 2023

I've got you covered, @SB91. I'll share the steps to ensure you can match the vendor credit to the deposit transaction for returned ACH payment in QuickBooks Online (QBO).

 

You can match the vendor credit to the returned ACH payment by hitting Accounts Payable (A/P) when adding the deposit for the returned ACH in your bank feeds.

 

Let's start by entering a vendor credit to make sure the credit hits the expense account you use for this vendor. Here's how:

 

  1. Click the + New button, then select Vendor credit.
  2. Choose your vendor in the Vendor dropdown.
  3. Depending on how you record purchases with this vendor, enter the Category details or Item details.
  4. Once done, tap Save and close.

 

Then, since the deposit for the returned ACH is in the banking feed, we can add the transaction and ensure to select Accounts Payable (A/P) from the Category section and choose the correct vendor. See the sample screenshot below:

 

Lastly, use Pay Bills to connect the bank deposit to the vendor credit. Even though you aren’t paying a bill, this is the right thing to do as this last step is to keep your vendor expenses accurate. Here's how:

 

  1. Click the + New button, then select Pay bills.
  2. Select the bank deposit you just created. You’ll see the amount of the vendor credit in the Credit Applied field and the Total payment should be US $0.00.
  3. Tap Save and close.

 

Additionally, you'll want to check out this article for the detailed steps in case you need to review all your vendor transactions in QBO: View vendor transactions.

 

Feel free to add a reply below if you have other questions or concerns about your QBO account. The Community is always here to help. Have a wonderful day ahead!

SB91Author
February 24, 2023

This appears to have worked. Thanks so much!

MariaSoledadG
February 24, 2023

Hello there, SB91.

 

I'm glad that the solution provided by my colleague above works for you. Anyway, if there's anything else that you need help with, let me know so we can get back to you as soon as possible. Have a great day!

January 9, 2024

This isn't working for me, the contractor payments are still showing up as double.

Bryan_M
January 10, 2024

Hi there, @c_k.

 

Let me share insight about why your contractor payments still showing double and help you fix it.

 

It might be that you're contractor has paid twice. We can perform a refund to your contractor to contra balance the duplicate payment.

 

Here's how: 

 

  1. Select + New.
  2. Select Credit card credit.
  3. In the Payee field, select the appropriate vendor.
  4. From the Bank/Credit account ▼ dropdown, select the credit card where you received the refund to.
  5. Enter the Payment date, refund Amount, Tax and Category.
    Note: The category used here is the original expense account on the original bill.it

 

Feel free to read this article for more details: Enter vendor credits and refunds in QuickBooks Online.

 

For your reference, I'm also adding here some articles that you can visit about entering a vendor credit and applying them to your transactions:

 

Come back here if you have additional questions about managing your contractor transactions. I'll be willing to help. Have a good one.