banner_ad

Bank Reconcilation

Others 1373 views 4 replies

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........

Replies (4)
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.
hello Sir, Can you explain how to use VLOOKUP function ?I don't know its use Thanks in advance.. Regards, Jyoti
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

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.


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 14 May 2026
CA ARTICLE

PRAVEEN GARG & CO

Faridabad

CA Foundation

View Details
Company
26 May 2026
Senior Accountant cum purchase Manager

Vardhaman Group of India

Pimpri Chinchwad

CA Inter

View Details
Company
19 May 2026
Article, CA & Paid Assistant Positions

Aggarwal Sarawagi and Co

New Delhi

CA

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 27 May 2026
CA Article Trainee

Rahul Dang & Associates-Chartered Accountants

Pune

CA Inter

View Details
Company
16 May 2026
Account & Audit Asst

RAHUL KHANDEBHARAD & ASSOCIATES

Nashik

B.Com

View Details
Company
23 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
ARTICLESHIP 23 May 2026
Article Assistants

Acupro Consulting

Gurgaon

CA Inter

View Details