banner_ad

Bank Reconcilation

Others 1368 views 4 replies
User Avatar

COMPANY SECRETARY
336 Points Posted on 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........

3 Reply Share Follow
On 08 December 2007 at 10:10 Report
Replies (4)
User Avatar

MBA & (CA Final)
1131 Points Posted on 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.
4 Reply
On 08 December 2007 at 14:01
User Avatar

COMPANY SECRETARY
336 Points Posted on 08 December 2007
hello Sir, Can you explain how to use VLOOKUP function ?I don't know its use Thanks in advance.. Regards, Jyoti
3 Reply
On 08 December 2007 at 14:17
User Avatar

MBA & (CA Final)
1131 Points Posted on 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
4 Reply
On 09 December 2007 at 09:05
User Avatar

Accounts Manager
795 Points Posted on 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.

2 Reply
On 22 July 2009 at 19:41


CCI Pro
Join the CA Students WhatsApp Community for ICAI Updates, Trending Courses & Notes!

Leave a Reply

Post Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Threads

More recent discussions | Post

Related Threads
Loading

Latest Job Openings

View all
Company
22 May 2026
Audit assistant

Displayandbeyond

Mumbai

CA

View Details
Company
02 May 2026
Experience Audit Manager

AGGARWAL SAMIR & CO

New Delhi

CA Inter

View Details
Company
Featured 02 May 2026
Senior Executive

hitesh chandwani & co

Pune

B.Com

View Details
Company
04 May 2026
Articleship

S.K Gairola & CO

New Delhi

B.Com

View Details
Company
11 May 2026
CA Dropout

Patron Accounting LLP

Pune

CA Inter

View Details
Company
23 May 2026
Article Assistant

Geeta Manchanda & CO.

New Delhi

CA Inter

View Details
Company
08 May 2026
Paid Assistants

Quick Taxperts Private Limited

Bengaluru

Graduate (Any)

View Details
Company
ARTICLESHIP 30 April 2026
Article Assistant

J SINGH & ASSOCIATES

Ahmedabad

CA Inter

View Details