Duplicate payment due to credit card - how best to handle
SOLVED
Hi all - a little confused on how best to handle this one.
We had a client pay an open invoice using credit card through the paynow link on our invoice. The amount was $70k and for some reason, it was paid in several chunks in a single day, 5 payments totalling $70k. Not sure if they processed it that way or if QB had a limit on how much they could make in a single payment or what.
Regardless, it marked the invoice paid based on those card payments. Separately, when the payment hit our bank, it was as a single entry for the full $70k (not the 5 small payments) and now the invoice is cleared from AR, and QB recorded those incoming 5 payments, but I still have the $70k bank deposit to record, but no open AR to book it to. It defaulted to undeposited funds and is showing as a ($70k) on AR.
How do I best clean this up?
I always find the QB autopayments cause weird issues like this. Have had other ones in the past, but for a former client, so I don't recall what the fix was and can't look at history to follow the same method.
Would appreciate some advice here. Thanks!
EDIT -
Thanks all for the replies, I was able to sort it. I applied the incoming bank transaction to the Undep funds entries, and treated that extra $70k payment as a duplicate. I zeroed it out and all ties out now. The issue is when QB autobooks CC payments, you don't need to manually create an Accept Payment against an invoice. We've never used the QB autopay features before, so was just unfamiliar.
Thanks again for the replies.