Matching check deposit to failed reoccurring bank transactions

Hi there, @egeorge4.

Sometimes, payments are unable to match invoices because the details and dates are not the same. 

On your end, the payments of your customers failed, however, it was marked as paid in the invoices that causes the discrepancies in your account. 
There are ways to handle this before reconciling them.

Here's how: 

First, figure out where the failed payment is in QuickBooks:

1. Go to + New, then select Bank deposit.
2. Review the QuickBooks Payments section.
3. In the list look for the payment. If you see it, it isn't deposited yet. If you don't, it is deposited.

Second, you must create a service item to track the rejected bank transfer:
 

1. Go to the Gear icon then select Products and services.
2. Click New and select Service.
3. Type "Rejected bank transfer" for the name.
4. Type "Bank transfer payment received rejected by the bank" for the description.
5. If the bank deposit is already deposited, select the bank account you deposited into for the Income account. Or if the bank deposit hasn't been made yet, select Undeposited funds for the income account.
6. Click Save and close.

For further steps in handling failed customer payments, you can click this article: Handle a rejected or failed bank transfer payment.
 

After you match customer transactions, you can check these links for the reconciliation processes:

• Learn the reconcile workflow in QuickBooks.
• Reconcile an account in QuickBooks Online.

You might want to learn what to do if you match the wrong transactions, you can read through this article: Fix bank transactions downloaded in QuickBooks Online.

Feel free to reply to this post if you have further questions about matching customer payments to the invoice. I'll be happy to lend a hand. Keep safe.