Customer was refunded a security deposit, bank matched transaction, refund was returned by Stripe and a second refund was processed
I am seeking the correct bookkeeping process to post a returned refund for a Customer. I want an outline of the correct steps to post the returned funds to the Customer Account.
#1-4 outlines what HAS BEEN done already in QBO:
1. Sales Receipt posted to Customer account for payment via Stripe and deposited to a bank account. Deposit matched to bank feed. This Sales Receipt included a security deposit that was posted to the liability account.
2. Customer Refund was processed for the Customer security deposit refund; posted to a liability account. Refund matched to bank feed.
3. Security Deposit Refund funds were returned to the bank account via Stripe. Deposit matched to bank feed. [Initially, this refund was deposited via the "Add funds to this deposit" section of the Bank Deposit screen. This does not show up under the Customer transaction list. Nor does it appear in the balance sheet security deposit liability account report to confirm the liability has been cleared.]
4. Customer was issued a second Refund for the security deposit. This posted to the liability account, also. Refund was matched to bank feed.
My problem is in brackets [ ] above in #3. I need to know how to post the returned Refund, as listed in #3 above, that is not done via the "Add funds to this deposit" section. I don't want a Journal Entry, either.
1. I need a way to see this returned refund with bank matched deposit on the Customer transaction list.
2. I also need it to show up on the balance sheet report under the security deposit liability section so the account shows as $0, not $-500 as it currently does. I think there should be a way to post a transaction to the Customer, credit the security deposit refund liability account to bring that back to $0 ($-500 refunded + $500 returned refund = $0), and then process the second successful refund that will post to the security deposit refund liability account which will zero out the parent account of Security Deposits.
I don't know what transaction(s) are/would be the correct ones to allow for the bank-matched transactions to stay on the books, post new transactions that won't affect anything other than the liability account, and, most importantly, post to the Customer transaction list AND to the balance sheet liability section for this property which is tracked via classes.
I tried to think about it via a similar process, Customer instead of Vendor, as outlined in the QBO Community Solved issue "Bill Pay voided an uncashed check" (https://quickbooks.intuit.com/learn-support/en-us/banking/bill-pay-voided-an-uncashed-check/01/717126#M49304), but couldn't figure out what the process would be for a Customer and the corresponding Customer transactions.
Please let me know if any further details are needed to understand my dilemma and what the solution I need would be. Again, I would appreciate an outline of steps, similar to what FritzF Moderator on November 25, 2020 @ 3:53PM posted in the QBO article referenced above. Thank you.
