LIMITED TIME 90% 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.
DebraJ1
Level 1

How to match multiple vendor invoices and vendor credits to a bank feed debit

QBO question - I have vendor payments that are automatic debits that contain both invoices and credits. I cannot figure out how to match these as the only option I see during that match function is for the invoices. The vendor credits may or may not match a specific invoice for that same period. What steps are necessary to resolve this?

2 Comments 2
JeveeAdvin__la
QuickBooks Team

How to match multiple vendor invoices and vendor credits to a bank feed debit

In QuickBooks Online (QBO), vendor credits must be manually linked to supplier bills using the Pay Bills feature. DebraJ1. This ensures your records align with the bank transactions you’ve downloaded. 

 

If the vendor credit is a refund unrelated to a specific bill, you’ll need to create a bank deposit and then use the Pay Bills function to connect the deposit to the credit.

 

Here's how to create a bank deposit:

 

  1. Select + New.
  2. Choose Bank Deposit.
  3. In the Account dropdown menu, select the account from which you received the refund.
  4. In the Add funds to this Deposit section, complete the following fields:
  5. Received from: Select the vendor who issued the refund.
  6. Account: Choose Accounts Payable. Note: It's important to select Accounts Payable so you can link the refund to the vendor credit. This may seem unusual, but it's the best method to handle this.
  7. Payment Method: Enter the method your vendor used to refund you.
  8. Amount: Input the amount of your refund.
  9. Finally, select Save and close.

 

Next, even if no bills are being paid, doing this step maintains accurate vendor records:

 

  1. Choose + New.
  2. Then go to the Pay bills section.
  3. Select the bank deposit you just created. You’ll see the amount of the vendor credit in the Credit Applied field. The Total payment should be US $0.00.
  4. Then hit Save and close.

 

For additional scenarios involving vendor refunds, refer to this article: Enter vendor credits and refunds in QuickBooks Online.

 

You can also explore this article for help matching bank transactions: Confirm suggested matches for bank transactions in QuickBooks Online.


Before we wrap up, I suggest you explore QuickBooks Live  Expert Assisted to streamline your accounting, maintain precise financial records, and access professional support. This could free up valuable time, allowing you to concentrate on expanding your business.


The QuickBooks Community is always here to provide assistance or address any further questions you may have.

Rainflurry
Level 15

How to match multiple vendor invoices and vendor credits to a bank feed debit

@DebraJ1 

 

You'll need to create a bill payment in QBO that matches the withdrawal amount.  Go to New > Pay bills, select the bills and credits that net to the payment amount.  Then, match that to the bank feed.  

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

Need to get in touch?

Contact us