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........
Menu
Bank Reconcilation
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.
Recent Topics :
- NRI since March 2023 – resident savings acco
- My All-Time Top 15 Indian Web Series
- Wrong date of invoice
- Paper 6 - IBS
- Chhath Puja 2026 Dates Timing Tithi
- Tax Benefit on Second Property
- IPO application checklist: 18 rules that decide wh
- NSE IPO Price, GMP, Allotment Date and Listing
- Gst tax rate
- Cash deposited by customer
Related Topics :
CAclubindia
