Additional payment

Good afternoon, if you compare boxing and private in terms of payments, then in private you cannot go in and make a payment backdated, go into a payment and edit its currency or amount or exchange rate, delete any of the payments. Those. It is rather banal to know the balance on the account (account) at the time of creating the payment. In boxing, if you do the same, then after X days you will receive false data. For example:
1. Payment 100 UAH. Balance after payment 100
2. Payment for -10 UAH. Balance after payment 90
3. Payment for 20 UAH. Balance after payment 110
In the box, you delete the 2nd payment and it remains:
1. Payment 100 UAH. Balance after payment 100
3. Payment for 20 UAH. Balance after payment 110
those. you received garbled data. I see 2 options for solving such problems:
1. After changing the payment, recalculate the balance for all payments of this account that were created after the date of the changed payment
2. Calculate the balance of payments "on the fly". Those. at page time
But with thousands of payments, when calculating on the fly, problems may arise, and the first option loads the system to no avail. Of course, there are tricks that will allow you to slightly reduce the load in the second option, but this is relatively difficult.
Do you need to see the balance directly in the list of payments or when you enter a specific payment?

Another option is more suitable - the baby "on the fly".
Oskіlki tse field we need to call for znakhodzhennya such problems (rozbіzhnіst surpluses in the system and in the actual surplus, through the pardon of managers).
Then, it is possible to add a checkmark to the column with filters, when you turn it on, this field will be displayed and the window will be turned off in the real hour.