cancel
Showing results for 
Search instead for 
Did you mean: 
sburfeind
Level 1

Can you match a lump some payment to several different invoices?

 
3 Comments 3
David-212915
QuickBooks Team

Can you match a lump some payment to several different invoices?

Hey @sburfeind,

 

Thanks for joining the Community. I'd be delighted to assist you with matching a lump sum payment to several different invoices. 

 

Just to clarify, are you needing to match a downloaded transaction that was a lump sum payment for multiple invoices? If so, one method for matching this is to utilize the Undeposited Funds account to make a deposit. Here's the steps for recording the payments to Undeposited Funds:

 

  1. Click the Plus icon.
  2. Select Receive Payment
  3. Choose the Customer, Payment Date, and Invoices that are being paid. 
  4. Select the Undeposited Funds account in Deposit to.
  5. Click Save.

 

If the invoices are for multiple customers, you will need to receive payment for each one and deposit them to Undeposited Funds. 

 

Now it's time to make the deposit for these funds, here's how:

 

  1. Click the Plus icon.
  2. Select Bank Deposit.
  3. Choose the payments that make up the deposit.
  4. Select the Date and Account.
  5. Click Save.

 

This deposit will now match the lump sum payment for several different invoices. 

 

The following articles contain additional insight on this:

 

 

 

I'm sure that you'll be an expert at matching lump sum payments in no time. 

 

Should you need further assistance, please let me know. Have a lovely week ahead. 

R007
Level 1

Can you match a lump some payment to several different invoices?

Hi QB Community,

I am new with bank feeds feature for my QB desktop and have a similar issue, but they are payments going to vendors and not payments received from clients.

 

For instant: 

1. I use ACH to pay 3 vendors on the same day with a total of $300 (100/each).

2. Downloaded bank feed into Quickbooks desktop and there is a transaction with a lump sum of $300. This amount equals to 3 different payments made to 3 vendors. Each entry was already entered under Write Checks in QB desktop.

3. QB is asking to match the transaction of $300, but I cannot match it since there are 3 entries of $100 each in QB that was paid to each vendor. 

 

What would be a good way to match this transaction?  Hope this makes sense.

Thank you so much for your help!!

Kristine Mae
Moderator

Can you match a lump some payment to several different invoices?

I'd like to help you get around with this, R007.

 

We're unable to match the transaction to three different checks. Though, we have two options for you:

  • Ignore the downloaded transaction. Then, when you reconcile, make sure to take note of those checks to avoid a difference.
  • Delete the checks, create bills instead, then match the downloaded transaction to the bills.

If you'll choose the second option, here's how you can delete the checks:

  1. Click the Vendors menu, then go to Vendor Center.
  2. Choose the vendor, then open the check.
  3. Click the Delete button.
  4. You'll receive a message, "Are you sure you want to delete this transaction?", choose OK.

Then, create a bill. Here's how:

  1. Click the Vendors menu, then choose Enter Bills.
  2. Fill in the necessary fields.
  3. Click Save & New or Save & Close.

Lastly, here's how you can match the downloaded transaction to the bills:

  1. Click the Banking menu.
  2. Go to Bank Feeds, then choose Bank Feeds Center.
  3. Choose the bank account, then click Transaction List.
  4. Choose the lump sum amount, click the Select drop-down arrow, then choose Select Bills to Mark as Paid.
  5. Choose the bills, then click Add to QuickBooks.

Let me know if you need further help with this. I'm just here.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us