VIMALA (IPCC student) (76 Points)
09 April 2013Dear Friends,
Can anyone help me in BRS reconciliation as i am doing a very huge transaction related BRS, i;m unable to use Vlook up formula there are no one parameter to use tat formula
Please help how can i finish with any other EXCEL formula which reduces my time in checking individual transaction comparing wtih Bank Pass sheet & Bank boook maintained in company
Very Urgent help me
CA MANOJ
(CA, MBA, B.Com)
(141 Points)
Replied 10 April 2013
if u are not able to use vlookup
then u can sort the entries amount wise
as it can helps u to recognise entries in group and easily
or u can sort the entries according to cheque numbers.
VIMALA
(IPCC student)
(76 Points)
Replied 10 April 2013
Actually problem is i know to use Vlookup but in my case of BRS i cant able to use that as there is no particluar parameter & also very few cheque entries are there rest all is party receipts & payment & some fund transfer through RTGS & NEFT these things i need to check with pass sheet
So somebody help me on this
Live Course on Invoice Management System (IMS) - 2nd Batch(With Recording)
CAclubindia
