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 Threads
- Get EU driving license help
- LIC maturity amount filing missed
- Advice on income tax
- E filing thr net banking for AY2025-26
- PROPERTY REPORTING IN ITR
- F&o profit or loss can show a government emplo
- Tax Query for FY 2024-25
- ITR Offline JSON Utility not showing saved drafts
- Incometax port8 not working
- U4gm-Leveling an Amazon Build with Lightning Spear
Related Threads
CAclubindia
