How do I match multiple credit memos from multiple customers to single bank transaction?

It's my priority to ensure you'll be able to match your credit memos to a bank transaction in QuickBooks Desktop (QBDT), @johnap1070. That's why I'm here to provide additional steps to resolve your concern.

To start, we can first delete the payments ($30 and $60) applied to your customers invoices. So you can apply the credit memo to them later. Here's how:

1. In your QBDT account, go to the Customers tab and choose Customer Center.
2. From there, look for the customers with a payment of $30 and $60.
3. Open their profile and click the Transaction tab.
4. Locate the payments and double-click it to open.
5. Then, click the Delete option found at the upper part of the page.
6. Choose OK to confirm the action.

After that, go ahead and create a credit memo for those amounts. Then, link the credit memo to the open invoices by using the Receive Payments feature. I'll guide you on how:

1. In your company file, navigate to the Customers menu and choose Receive Payments.
2. From there, fill in the needed information. In the Received from drop-down, select the name of the customer. 
3. Next, click the Discounts and Credits icon.
4. On the Credits tab, check the credit you want to apply and then select Done.
5. Select Yes if you see a prompt. The amount will be applied automatically to the invoice.
6. When done, click Save & Close.

Once paid, match the entries with the $90 bank transaction. 

You'll also want to run sales report in QBDT to monitor your accounts receivables and your business income. To do so, simply go to the Reports menu and hover over to the Sales section. From there, select whichever report you need. 

If you have questions about performing the process I've outlined above, please leave a reply. I'm just around the corner to assist you once again. Have a good day and wishing your business continued success.

Thank You , but that does not work Divina. I think you misunderstood my original post.

You are instructing me to delete the original payments deposited from my bank that were matched to the invoices. Doing that alone screws up my bank register.

I had over 100 ACH transactions ran on the 1st and deposited into the account by the bank as a lump sum a few days later. Every single one of those transactions has already been properly matched to that lump sum. The bank rescinded the two transactions due to NSF several days after the monies had already been deposited and matched and then the bank did a withdrawal from the account for the 90 to cover the NSFs. 

I have to note that there was payment collected and then returned for each of those accounts. Zeroing out the invoices with a discount seems to throw the numbers off and makes the original transactions inaccurate.

Appreciate the details, @johnap1070.

Let me share some information about recording NSF in QuickBooks Desktop (QBDT). You can record NSF or bounced checks either in the Record Bounce Check feature or by manual process.

To begin with, you'll want to delete your created credit memo. Just go back to the customer's page and delete it. 

After that, proceed with the manual process. You'll want to start by creating an item and income account for tracking bounced checks and their associate charges.

1. Create an income account. Make sure to select Income Account as Type, and then enter Bounced Checks Income as the Account Name.
2. Create a bad Check Charge Item. Item Name: Bad Check Charge, leave the Amount at 0.00, Non-taxable. The Account: Select Bounced Checks Income.

Once done, create a journal entry to reverse the original payment. Go to Company, and then select Make General Journal Entries. Here's how it looks like:

Lastly, switch the payment for the invoice to the reversing journal entry. Here's how:

1. Go to Reports, select Customers Receivables, and then choose Customer Balance Detail.
2. Double-click the original payment line for the NSF transaction. 
3. In the Receive Payments window, move the check mark from the invoice to the reversing journal entry.
4. Click Save and Close.

With the above recommendation, you're able to record the NSF accordingly in QuickBooks. Please check out this guide for more information: Handle Non-Sufficient Funds (NSF) or bounced check from customers.

Additionally, here's a link in case you need help with other customer-related tasks. It has our general customer topics with articles: Sales and Customers.

Please let me know in the comment section below if you have follow-up questions or clarifications. I'm more than happy to assist you. Take care and have a great day ahead.

Thank you ShiellaGraceA  for your explanation. The problem with the process you described is that QBD software will not allow me to do more than one line item for Accts Receivable. I need to create two lines; one for 30 and one for 60 to match the the 90 withdrawal. 

Can you suggest a modified method???   I am thinking that I should recreate the journal entry and then apply them to AR Holding accounts.  Then within  the AR holding accounts, create debits that send them to the Accts Receivable to be matched to the 90 debit from the checking account.

FYI: This is a ridiculous process to  perform for NSF. Your software engineers should correct this issue on a future update and streamline the NSF return process.

Appreciate you for getting back to us, johnap1070. 

The steps and information shared by my colleague above are the right way process for handling NSF/bounced checks in QuickBooks Desktop (QBDT).
 

Yes, I agree with the idea of recreating the journal entry. However, we're unable to advise which account to choose since it has a unique way of handling transactions. It would be best to consult an accountant about this matter. This is to ensure your register and book will remain accurate.

• To find an accountant, you can visit this link: Find a ProAdvisor.
• Also, you can check this article for more details: Create a journal entry in QuickBooks Desktop for Windows or Mac.

In case you need help with other tasks in QBDT, you can browse this link to go to our general topics with articles.

If you need more help with your transactions or any other QuickBooks concerns, you can always go back to this thread. Take care.  

Well then your solution does not work due to limitations and inefficencies of your software, and stated simply, bad programming.

This is all the more reason for me to work with the CEO and have us move to a more robust accounting software such as Sage.