How to column update with history

i have table name - payments it has “total work order price”, " paid " and balance columns of a vendor.
a particular date I entry some amount in “paid” column also get balance through input event method.

next date i will entry balance payment for that vendor , now option is only update the column of “paid” .
in my case
i need payment history for that vendor additionly update the balance automatically
how can do the challange for my case
kindly someone give good idea to the scene
thanks to reply
Below add the screenshot of my table list page.

in my case
need solution update balance payment of vendor also payment history
kindly solution for this situation