Bank reconcilation

In my client place they are using SAP B1 2005B PL:40

I need best suggest to handle bank reconcilation in SAP B1 and how to generate the Bank reconcilation report.

As per my knowledge:

In SAP B1 there is option to do Bank reconcilation through automatic

reconcilation or Manual reconcilation.

Ex: As per bank book balance is 100000.00 and as per customer book

balance is 90000.00 it means one cheque may not clear in bank bank

book of Rs.10000.

Now If I do reconcilation as per SAP B1 process the difference amount

should transfer to cheque issue but not presented and bank balance

will increase by 10000 rs in customer book.But in Tally the system is

different for Bank Reconcilation.