cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.

Reply to message

View discussion in a popup

Replying to:
AileneA
Moderator

Reply to message

Hello, pk1234.

 

When dealing with multiple vendors' bills and you want to apply a lump sum ACH payment, it can be tricky. However, a simple trick can help you accomplish this task with ease. Here's what you need to do. First, manually record the transactions that are involved in the payment. Then, you must use the Pay Bills feature to allocate the payment amount to the corresponding vendor bills. This will ensure the payment is accurately applied to each vendor's bill. 

 

However, before you can use the Pay Bills feature, you must ignore the bill transactions in the banking. This is because the Pay Bills feature will only work with bills that have not been paid yet. By ignoring the bill transactions, you tell the system that these bills have not been paid yet and must be paid from the lump sum payment. 
 

By following these steps, you can ensure that the payment is accurately applied to the individual vendors and their bills. This will help with proper accounting and reconciliation, which is essential for any business.

Here's how:

 

  1. Click Banking and choose Bank Feeds.
  2. Choose Bank Feeds Center.
  3. Select the Bank Account.
  4. Choose the transaction and under the Add drop-down. Then select the Ignore.
  5. Click Yes to delete the transactions.

 

 

 

 

Then, let's enter the bills manually of the vendors. Here's how:

 

  1. Click Vendors and select Enter Bills
  2. Enter all the details needed and Save and Close once done.

 

Once finished, we can use the Paybills feature and manually mark-check the transactions that need to be paid. I'll show you how to do it:

 

  1. Click Vendors and select Pay Bills.
  2. Mark-check the bills and click PaySelected Bills.
  3. Press Done once finished.

 

 

 

 

 

 

 

 

For more details about adding and matching bank feed transactions, check out this article: Add and match Bank Feed transactions in QuickBooks Desktop.

 

However, since you're matching this transaction to multiple vendors in QuickBooks, which is not currently possible. In this situation, I would suggest sending feedback directly to the QuickBooks developers requesting the addition of this feature. To do this, start by clicking on the Help tab within QuickBooks and selecting the option to Send Feedback Online. This will allow you to provide detailed feedback about the issue you are experiencing and suggest potential solutions that could be implemented in future updates. By providing this feedback, you can help improve the QuickBooks software and ensure that it meets the needs of its users. 

 

You may want to consider mastering the reconciliation workflow in QuickBooks. It can help ensure that your books are accurate and up-to-date. The reconcile feature allows you to compare transactions in QuickBooks to those on your bank and credit card statements. Doing so lets you identify discrepancies and ensure that everything is recorded correctly. 

 

In the meantime, you can ignore that downloaded transaction and manually enter it in QuickBooks. That way, you can directly apply it to the payments. Let me know if you have further questions about using payments for multiple transactions in QuickBooks. I'll be here to extend another help. Have a great day!

Need to get in touch?

Contact us