Can someone provide Auto Bank reconciliation Statement in Excel sheet, as one of my friend have to reconcile bank with the ledger and having thousand numbers chques entry in the GL. So it is a long procedure to do it manually.
Regards
Rajesh
Can someone provide Auto Bank reconciliation Statement in Excel sheet, as one of my friend have to reconcile bank with the ledger and having thousand numbers chques entry in the GL. So it is a long procedure to do it manually.
Regards
Rajesh
CA Urvish Patel
(Chartered Accuntant)
(31 Points)
Replied 25 September 2008
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
shailesh agarwal
(professional accountant)
(7642 Points)
Replied 25 September 2008
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.
V P Narasimhan
(Accounts Manager)
(791 Points)
Replied 22 July 2009
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.
CAclubindia
