Hi there, @endless questions.
I can see the importance of matching your deposit to your refund receipts. However, this is the best workaround to match the two transactions where you can deposit all the receive payment to Undeposited funds account and then get the refund transaction to the undeposited funds. Once done, you can create a bank deposit and deposit the payments as well as the refund receipts.
You can follow these steps to deposit the payments to undeposited funds.
- Go to the + New.
- Select either Receive Payment.
- Choose the customer from the Customer drop-down arrow.
- Click the checkbox in the invoice you’re about to receive.
- From the Deposit to fields, select Undeposited Funds.
For the Sales receipts, you can refer to this link for the steps: Deposit payments into the Undeposited Funds account in QuickBooks Online.
Once done, you can make a refund transaction using an undeposited funds account, and after that create a bank deposit and deposit all the received payment and also the refund receipt.
For more detailed information about banking transactions like transfer funds and also reconciliation, you can visit the QuickBooks Online Help Article.
If you have additional questions, feel free to leave a message in the comment section. I'll be happier to help. Take care and have a great day!