cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Matching 1 bank payment to multiple vendors

Hello,

 

I recently paid a group of vendors via ACH outside of QuickBooks.  The debit to our bank account was imported into my QB bank feed center as 1 transaction.  How do I match this single payment to all the individual vendors that were paid?

e.g. 

vendor 1 was paid $100

vendor 2 was paid $200

vendor 3 was paid $300

bank debit in QB was 1 transaction for a total of $600

 

Thanks!

Solved
Best answer 05-01-2019

Accepted Solutions
QuickBooks Team

Re: Matching 1 bank payment to multiple vendors

Hi @STaylor04,

 

Currently, you're unable to match your lump sum payment to your vendor bills. But I have another option you can consider.

 

You can ignore/exclude the downloaded payment and manually enter them in QuickBooks. To ignore/exclude the downloaded transaction, you may follow these steps:

  1. Click on Banking from the menu bar.
  2. Choose Bank Feeds, then Bank Feeds Center.
  3. Select the bank account.
  4. Click on Transaction List.
  5. In the Action column, select Ignore under the Select drop-down.
  6. Select Yes on the pop-up.

Once done, you'll need to create the bills for each vendor that you're paying. Here's how:

  1. Click on Vendors from the menu bar.
  2. Choose Enter Bills.
  3. Enter the vendor name and the necessary details.
  4. Click on Save & New until all bills are created.

Once completed, you may now create a payment for all the bills. Kindly follow these steps:

  1. Click on Vendors from the menu bar.
  2. Choose Pay Bills.
  3. Select the 3 bills you've created.
  4. Click on Pay Selected Bills.
  5. Click on Done.

Please let me know if you have any other concerns. I'll be sure to get back to you.

2 Comments
QuickBooks Team

Re: Matching 1 bank payment to multiple vendors

Hi @STaylor04,

 

Currently, you're unable to match your lump sum payment to your vendor bills. But I have another option you can consider.

 

You can ignore/exclude the downloaded payment and manually enter them in QuickBooks. To ignore/exclude the downloaded transaction, you may follow these steps:

  1. Click on Banking from the menu bar.
  2. Choose Bank Feeds, then Bank Feeds Center.
  3. Select the bank account.
  4. Click on Transaction List.
  5. In the Action column, select Ignore under the Select drop-down.
  6. Select Yes on the pop-up.

Once done, you'll need to create the bills for each vendor that you're paying. Here's how:

  1. Click on Vendors from the menu bar.
  2. Choose Enter Bills.
  3. Enter the vendor name and the necessary details.
  4. Click on Save & New until all bills are created.

Once completed, you may now create a payment for all the bills. Kindly follow these steps:

  1. Click on Vendors from the menu bar.
  2. Choose Pay Bills.
  3. Select the 3 bills you've created.
  4. Click on Pay Selected Bills.
  5. Click on Done.

Please let me know if you have any other concerns. I'll be sure to get back to you.

BRC
Established Community Backer ***

Re: Matching 1 bank payment to multiple vendors

Assuming you are using AP and the vendors each have a Bill for this amount, then...

 

You can do this but you'll need to use a pass-through or 'scratch' bank account.

 

In this case,

- Record the payment (check in QB?) and for the account, transfer it to the scratch bank account.

- Pay the bills, and use the scratch bank account as the account at the bottom of the pay bills dialog.

- The resulting scratch bank account balance will then be 0.00.

 

Need to get in touch?

Contact us