Total of Cashier Deposits doubling due to duplicate entries

Total of Cashier Deposits doubling due to duplicate entries

Example Store 03022 The system duplicated their total deposit and confirmed it at $11,098.44 (should have been $5,549.22).
In this case the Restaurant has already Completed their Deposits and Finalized for the day for January 30th, 2021. 

We've had five recent tickets and I resolved it with the following script.

select* from tbTransactionCashDeposit tcd with (nolock)
join tbBankingTransaction tcf  with (nolock)
on tcd.TransactionCashDepositID=tcf.TransactionCashDepositID
where tcd.entityid=345
and cashdepositdate='01/30/2021'

select * from tbBankingTransaction with (nolock)
where TransactionCashDepositID in (89101383,89101383,89101524,89101524,89101842,89101842,89101930,89101930,89101931,89101931,89101932,89101932,89101942,89101942,89120206,89120206,89120211,89120211,89120950,89120950,89123897,89123897,89124253,89124253,89124258,89124258,89125121,89125121,89125419,89125419,89126270,89126270,89128909,89128909,89128912,89128912,89129606,89129606,89129611,89129611,89129614,89129614,89129751,89129751,89129978,89129978,89130180,89130180,89143164)

Begin tran delete from tbBankingTransaction
where BankingTransactionID in (91559962,91559963,91559964,91559965,91559966,91559967,91559968,91559969,91559970,91559971,91559972,91559973,91559974,91559975,91559976,91559977,91559978,91559979,91559980,91559981,91559982,91559983,91559984,91559985)
--commit

CFA is requesting the issue to be reviewed for Root Cause