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! Go to Solution.
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
I've provided a screenshot for your visual reference:
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!
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:
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!
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.
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
I've provided a screenshot for your visual reference:
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!
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here