can select from sql  as given model

  Opengbalance      Closingbalance

  Dr  Cr  Dr      Cr