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 Topic
- TIS Glitch Alert : inflated summary
- IT returns of partners
- Challan status in Payment Failed but amount deduct
- Sec 54 exemption
- Query regarding retirement benefits
- TDS Payment and filing
- Capital gains exemption under sec 54
- Revamped traces portal, conso file download failed
- Due date of ITR for Option Trader
- Cancelled invoice entry
Related Topics
CAclubindia
