Inserting running total

Problem to insert running total in MySQL transactional database. need your help for solutions and opinion. Table structure of my table is, create table `wtacct` ( `ID` int(11) NOT NULL …