Become a Govt. Certified GST Practitioner in just 58 hours. Register Now!

Bank Reconcilation

Jyoti Aggarwal (COMPANY SECRETARY) (336 Points)

08 December 2007

Hi,

Can anyone tell me that whwther we can reconcile the bank with the help of VLOOKUP function in excel??? If Yes, then how?Please explain........

Reply
Follow
Share

4 Replies

Balaji Sarangarajan (MBA & (CA Final)) (1131 Points)
Replied 08 December 2007

Hi Jyoti Yes it is possible. Since cheque no being common in both bank statement & bank, we can pick up the ch.no with vlookup formula. but ensure that in both the statement it should be typical. Regds Balaji S.

Upgrade to CAclubindia Pro. Subscribe Now!

Jyoti Aggarwal (COMPANY SECRETARY) (336 Points)
Replied 08 December 2007

hello Sir, Can you explain how to use VLOOKUP function ?I don't know its use Thanks in advance.. Regards, Jyoti

Balaji Sarangarajan (MBA & (CA Final)) (1131 Points)
Replied 09 December 2007

Hi jyoti First u have to sort both bank book & bank statement cheque numberwise than u can use the vlookup formula for brs. if u have problem u mail me some samples to balajisarangarajan @ hotmail.com i ll do it & send it to u regds Balaji

V P Narasimhan (Accounts Manager) (793 Points)
Replied 22 July 2009

The easiest way we use to do in excel is we will download the bank book and sort amount wise lower level to upper level. Then by going thro' the bank statment we will finish it very fastly. U can also try.