Count mismatch in Bank File w.r.t. BatchPaid file in excel

Count mismatch in Bank File with respect to BatchPaid file in excel


Solution :

Step 1 : Generate the Bank File in excel

Step 2: Generate batchPaid file in excel

Step 3 : Use vlookup functionality of excel and extract the employee codes which are not available in bank file.

Step 4: Check the Bank name details of employee and assign the bank names to them if missing.