Why are values in the Total column out of order and don have mathematical sense?
Most likely you are sorting transactions by something other than Date. Running totals only make mathematical sense when transactions are sorted by date. These values are tied to the specific transactions and when you sort transactions by numbers, category or some other field, the totals naturally go out of order, even though the values are still correct. Simply click on the header of the Date column to sort transactions by date, this will bring the view and totals back to normal.