Error when matching a deposit to an invoice.

rgsitconsulting · ‎September 25, 2017

I'm experiencing an error when trying to match a deposit to an invoice. The invoice was sent to the client and paid through QuickBooks ACH. I received notification when the invoice was paid, and it was mark as paid in Quickbooks. The ACH funds have now been deposited in by business checking account. In my business checking account 'review' register it pulls up the correct invoice to match, but I receive the following error:

This transaction is already matched with another downloaded transaction. Please refresh to see the latest data.

The transaction does not show up in my business checking account 'In Quickbooks' register, so there's nothing to unmatch.

How do I fix this?

(Title has been edited by moderator for clarity)

AliciaRoy · ‎September 25, 2017

Since the two transactions have already been matched, you don't need to match a third transaction, as it's been balanced correctly. In these cases, you can simply exclude the deposit since the payment has already been recorded. You can do so by going to Banking on the left navigation panel, using the box on the left to mark the transaction, clicking on Batch actions, and choosing Exclude selected.

If the payment came through in the undeposited funds account and you want to ensure it's categorized correctly, first go to the + icon and select Bank Deposit. Under the Select Existing Payments field, use the boxes on the left to choose the payments. Once you've filled out the form, click Save and Close at the bottom right corner.

View solution in original post

AliciaRoy · ‎September 25, 2017

Hi rgsitconsulting,

I'm here to help you uncover what transactions were previously matched.

It sounds like the transaction that's already matched is the invoice, and not the imported deposit. Since the invoice was entered manually, it won't show up under the 'In QuickBooks' register of the banking page. I recommend going to Sales > Invoices to locate the invoice and see which downloaded transaction has already been matched, which may just end up being the applied payment. The following article may be helpful, as it discusses the matching feature of the banking page: https://community.intuit.com/articles/1164872.

Please let me know if this helps, or if you have any further questions for me.

rgsitconsulting · ‎September 25, 2017

So when I look at the invoice, it's shown as Paid (Not Deposited) and is matched to the received payment. The downloaded transaction is trying to be matched to the Received Payment. I receive the "This transaction is already matched with another downloaded transaction. Please refresh to see the latest data." error when trying to match.

AliciaRoy · ‎September 25, 2017

Since the two transactions have already been matched, you don't need to match a third transaction, as it's been balanced correctly. In these cases, you can simply exclude the deposit since the payment has already been recorded. You can do so by going to Banking on the left navigation panel, using the box on the left to mark the transaction, clicking on Batch actions, and choosing Exclude selected.

If the payment came through in the undeposited funds account and you want to ensure it's categorized correctly, first go to the + icon and select Bank Deposit. Under the Select Existing Payments field, use the boxes on the left to choose the payments. Once you've filled out the form, click Save and Close at the bottom right corner.

rgsitconsulting · ‎September 25, 2017

Thank you. Excluding then selcting the existing payment in Bank Deposits settled the account correctly.

AliciaRoy · ‎September 25, 2017

That's great to hear!

Please feel free to reach back out if there's anything else I can do to help.

Topics

Training

Community

Resources

Error when matching a deposit to an invoice.