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

Bulk payment from an third party payer including a chargeback-cannot match transaction

Hello.  I have a bulk payment from an insurance company that includes a chargeback, but cannot properly match the transaction.  Hopefully someone can help.  I will use sample numbers to illustrate the issue. 

A single bank payment transaction from the insurance company exists in the amount of $1000.  The statement from the insurance company shows:

$800 to pay an invoice for customer 1

$700 to pay an invoice for customer 2

$-500 to claw back an amount that was paid to customer 3 previously. (They show a balance of $-500 on their account)

 

When I go to match the transaction, the -500 balance of customer 3 does not come up in the list.  So I cannot match the transaction.  Not sure what do do at all!  Issue a refund/credit? Thanks. 

 

 

 

Solved
Best answer a week ago

Best Answers
KiazzymaeC
QuickBooks Team

Bulk payment from an third party payer including a chargeback-cannot match transaction

Thank you for getting back to us, @GGG4. I have an alternative way for you to successfully match your transaction, and I'd be happy to guide you through the process.

 

But before we get started, let's start by undoing any previously matched transactions and delete any related entries you've created. Once that's taken care of, let's move on to correctly recording your transactions. Here's how you can handle a single bank payment from the insurance company by recording it as Accounts Receivable (A/R 

 

  1. Click + New, then select Bank deposit under the Other column.
  2. In the Account field, choose the bank that received the payment
  3. Proceed to the Add fund to this deposit.
  4. Under the Received From column, select the three customers and choose Account Receivable in the Account field.
  5. Enter the respective amounts for the three payments under the Amount (USD) column.
  6. Once done, select Save and Close.

 

I've provided a screenshot for your visual reference:

bank.png

 

 

 

     

 

 

 

 

 

After recording this, you can proceed to match the transactions accurately.

 

Next, let’s ensure that the payments for customers 1 and 2 are recorded correctly. Verify that the invoices for customers 1 and 2 are still open. If they are, go ahead and record the customer payments against these open invoices.

 

To maintain accuracy in your financial records, remember to reconcile your accounts regularly. This will help you ensure that your QuickBooks data matches your bank or credit card statements.

 

If you have further questions about matching your transactions, feel free to reply to this trend. I’m more than happy to help guide you through any challenges!

View solution in original post

5 Comments 5
RazzieE
QuickBooks Team

Bulk payment from an third party payer including a chargeback-cannot match transaction

I appreciate your detailed illustration to visualize your issue, @GGG4. Let me guide you on how to handle this below.

 

To start, you'll need to receive the payments for both Customer 1 and Customer 2 as you normally would. Make sure to select Payments to deposit in the Deposit To drop-down menu.

Selecting Payments to deposit keeps the payments for Customer 1 and Customer 2 in a temporary holding account also called Undeposited Funds. This step is crucial to properly combine the payments into a single bank deposit later.
 

Once you’ve received the payments for both invoices, proceed to create a bank deposit.
 

Here’s how:

 

  1. Go to the + New button and select Bank Deposit.
  2. In the Select the payments included in this deposit section, make sure to check Customer 1 and Customer 2 only.
  3. Enter Customer 3 in the Received From field and select Accounts Receivable in the Account section to link it to the customer’s payment.
  4. Enter -500 in the Amount field.
  5. Once done, click Save and Close.

 

After creating the bank deposit, navigate to Customer 3’s payment. Edit the payment and tick the deposit box to specify whether it’s an overpayment or a credit memo. Once done, click Save and Close. By doing this, the $-500 balance for Customer 3 will now appear in the list, allowing you to match your transaction successfully.
 

I'll leave this article for you if you'd like to customize your invoice in the future: Customize invoices, estimates, and sales receipts in QuickBooks Online.
 

We're always here to help! If you need further assistance with matching your transaction in QBO, feel free to respond to this thread. Have a great day!

GGG4
Level 1

Bulk payment from an third party payer including a chargeback-cannot match transaction

Thank you very much for your time on this and for replying so quickly!  I know it will work in the end but unfortunately I do not have a "payments to deposit" account.  I proceeded with your instructions using the undeposited funds account instead, and while the balance on customer 3's account is now 0, it shows a transaction of $500 with type "deposit" with status "open".  Even after I match the bulk payment transaction, the $500 comes up on the list when I try to match other transactions.  I wonder where I went wrong?  I can easily undo all of this and start again.  

KiazzymaeC
QuickBooks Team

Bulk payment from an third party payer including a chargeback-cannot match transaction

Thank you for getting back to us, @GGG4. I have an alternative way for you to successfully match your transaction, and I'd be happy to guide you through the process.

 

But before we get started, let's start by undoing any previously matched transactions and delete any related entries you've created. Once that's taken care of, let's move on to correctly recording your transactions. Here's how you can handle a single bank payment from the insurance company by recording it as Accounts Receivable (A/R 

 

  1. Click + New, then select Bank deposit under the Other column.
  2. In the Account field, choose the bank that received the payment
  3. Proceed to the Add fund to this deposit.
  4. Under the Received From column, select the three customers and choose Account Receivable in the Account field.
  5. Enter the respective amounts for the three payments under the Amount (USD) column.
  6. Once done, select Save and Close.

 

I've provided a screenshot for your visual reference:

bank.png

 

 

 

     

 

 

 

 

 

After recording this, you can proceed to match the transactions accurately.

 

Next, let’s ensure that the payments for customers 1 and 2 are recorded correctly. Verify that the invoices for customers 1 and 2 are still open. If they are, go ahead and record the customer payments against these open invoices.

 

To maintain accuracy in your financial records, remember to reconcile your accounts regularly. This will help you ensure that your QuickBooks data matches your bank or credit card statements.

 

If you have further questions about matching your transactions, feel free to reply to this trend. I’m more than happy to help guide you through any challenges!

GGG4
Level 1

Bulk payment from an third party payer including a chargeback-cannot match transaction

Thank so so very much.  While I won't know until reconciliation, I think that worked very well.  I really appreciate your help, you saved me hours of work. 

JamaicaA
QuickBooks Team

Bulk payment from an third party payer including a chargeback-cannot match transaction

Good day, GGG4.

 

I appreciate you getting back to us and confirming that the suggestions worked. On behalf of my colleague, you're always welcome. Please know that it's our pleasure to address any questions or issues with QuickBooks.

 

If you have any other reconciliation concerns, comment them below. I'll be glad to assist you further.

This widget could not be displayed.
This widget could not be displayed.

Need to get in touch?

Contact us
close
Feedback