Cleaning up credits on rec.

Hi everyone

To contextualize. We run online stores for several of our customers, we run everything and then when the store closes, we deduct our production and extra fees and give our customers their "profit" from the store, every time their clients order something, that order is added into an open SO which tracks all the production expenses, this SO is then invoiced and "closed out" with money from the bank account associated to Stripe. All of these stores constantly receive payments from Stripe, so controlling when are these payments being done and against which store is logistically hard from an accounting perspective

So basically there's a bunch of credits in the account that cannot be cleared and these have been accumulating like crazy. We use Stripe to receive payments from our customers but Stripe's payouts usually contain several payments not necessarily associated to a specific invoice. To close out the jobs, we "receive" the money from our stripe account into a bank account and then we immediately transfer this money into our operating account, as shown in attached picture, basically zeroing out these credit against a payment (transfer)

Problem is that this is being properly done now but there's a bunch of "received" payments that are not properly associated in the bank account and as shown below:

So, how can we clear these out? Theoretically speaking we already received this money in the form of (literally) dozens of payouts that were done and every time a reconciliation has to be done, all of the transfers done zero themselves out with the "payments" received but before me, this had been piling up and some team members couldn't grasp the idea so they missed doing the transfers immediately. I don't want to clear these payments out because then these invoices would reopen and the whole cycle would continue constantly