Quickbooks Metching with CommerceSync and multiple deposits for one invoice

I've got the steps you'll need about fixing your deposit concerns so you can match them, dmvtitleexperts.

You'll have to create two (2) Bank deposit transactions and ensure to select the Accounts Receivable account from the Account column, input the customer's name who paid it, and then apply it to the invoice. 

Afterward, you'll have to create a receive payment and select the two deposits. 

Once done, you can find a match of the transactions and it will show under the Match transactions window.

That should do it! Need help reconciling your account, here's a detailed instruction to ensure your books are updated: Reconcile your account in QuickBooks Online.

If you need more help with banking or other related concerns, don't hesitate to add them below. I'll be happy to lend a hand.

Hello, thank you for your prompt reply. 

Before I follow the steps you gave me, what should I do with the already created information?

The deposits are a part of a larger invoice for which credit cards have already been recorded as accepted as a payment on the invoices that were created with CommerceSync. When I follow the trail on the invoice - all the steps/workflow are complete - it just does not have the deposit as the last step on the invoice, merging it all together. Will the instructions you gave do that for the invoice?

Also, what do I do with the pending transactions in the "for review" tab for these deposits as well? As I normally "match" them. 

Hello, dmvtitleexperts. 

QuickBooks Online will find a potential match based on the details of the transactions. These include the date, description, categories, and amount. 

The steps given by my colleagues above are to help you create a bank deposit and select the Bank account where the actual payment was deposited. Then apply it to the invoice. 

You can visit this link for additional information: Record and make bank deposits in QuickBooks Online.

Once done, you can now start matching the recorded invoice payments. By doing this, you'd avoid getting duplicates. Let me share this guide for the step by step process: Categorize and match online bank transactions in QuickBooks Online. 

You may refer to this article to see the instructions on how you can reconcile your accounts so they always match your bank to avoid discrepancies: Reconcile an account in QuickBooks Online.

Also regarding the pending transactions in the for review tab. They are the list of your downloaded bank transactions. You'll need to  match the transactions, to avoid getting duplicate records of your transaction in the bank register. 

Know that you can always get back to me if there's anything else that you need. I'll be here to you. Have a good one!

---

@dmvtitleexperts wrote:

I cannot match the transaction to the invoice that was already created in quickbooks via commercesync. It does not find the transaction.

---

@dmvtitleexperts 

Have you contacted CommerceSync to inquire about this issue? It seems that the connector can only mirror transactions into QBO but has no function to reconcile them. Another option, you should explore another connector for this requirement. 

Hello, I am still unable to do this following your provided steps. I am stuck at the "Receive Payment" area. I start to receive a payment, and put in the customers name. And then it says there are no open invoices for this customer. I do see the deposits at the bottom of the manual entries I made from the first instructions. 

The invoices I am trying to match have already been paid and completed, so there are no outstanding transactions for this, they just need to match the deposits. I'm not sure if that is relevant information for you to know. So, there already are invoices and payments created in the sales area for this transaction. 

What should I do?

Thank you for sharing additional information, @dmvtitleexperts.

Let me clarify things and help you match your invoice to the deposits.

Before we start, please know that QuickBooks doesn't allow you to match multiple bank transactions to one QuickBooks entry. However, you can match multiple QuickBooks entries to one bank transaction.

Since the invoice was already paid and recorded in Quickbooks via CommerceSync immediately, you don't need to process the receive payment option. All you need is to make a deposit to the payment and match it to the deposit from your bank. Here's how:

1. Sign in to your QuickBooks Online (QBO) account.
2. Click Banking from the left menu.
3. Choose the appropriate bank account.
4. Select the deposit you want to match, then click Find match.
5. In the Match transactions window, select the deposit you created in QuickBooks. Then, click Save.

I'll be adding this article for more guidance: Categorize and match online bank transactions in QuickBooks Online.

However, if you can't still match the deposit, you can consider excluding the deposit from the bank feeds. You don't need to worry about excluding the deposit since it was already recorded to QuickBooks.

Let me know how it goes, @dmvtitleexperts. I want to make sure this issue is taken care of.

Once everything is good, you may want to reconcile your bank account in QBO. This will help ensure your QuickBooks transactions match your bank and credit card statements.

Have a good one.