rowid | date       | name | debit | credit

  7   | 24.07.2017 | bob  | 792   | 0

  1   | 25.07.2017 | jon  | 792   | 0

  5   | 25.07.2017 | maggi|  0 | 500

select date,
name,DEBIT,CREDIT,
(select SUM(cashwithdraw)-SUM(cashdeposit) from _temp as a where a.rowid<=b.rowid )+0.0 AS balance,
from _temp as b order by date