Auto Bank reconciliation Statement

You can try using the formulas like "Vlookup" or "sumif" and give the link on the cheque number and pick up the amount so that those cheques which are cleared will be picked up and rest will be included in the BRS.

In case of anymore help mail me on urvishhpatel @ yahoo.com

AS I THINK YOU SHOUD GO TALLY-FOR THIS

AS IT IS VERY EASSY AND TIME SAVING

IF ANY PROBLEM CONTACT ME

SHAILESH

my friend is working in a financial institution and not using Tally.  He has to do Reconciliation on manually. Thousands of cheques have been received on monthly basis and also deposition of cash on daily basis. The problem we are facing is to reconcile the cash and the dishonoured cheques. Thus we require an excel sheet with formulas. If we put our whole data on respective place on excel sheet it will auto reconciled and give us the seperate sheet for cash cheque and dishonoured cheques.

Dear

One thing can be suggested . U can download the Bank book in excel and sort amount wise in debit & credit column. If you have the bank statgement on the other hand U can tick or put a * on the right side for the passed amount. After this exercise you can filter & find the reuslt. If you try & keep on trying U willbecome an expert in excel reconciliation.

All the best.

In fact we use to do for Debtors Ledger & Credtors Ledger by mentioned c1,c2 and so on matching each entries.