Bank Involved: Select... Bank Account [] Paybill [] Kcb Bank  [] Family Bank  [] Barclays Bank  []    Date From:   To:  Un Reconciled      

select * from test.paybill where date>='2024-05-07' and date<='2024-05-07' and status!=3 and (debit>0 or credit>0) order by date asc

#	Date	Value Date	Ref	Customer	Description	Debit	Credit	SR Number