Step 1) Go to Transection > Bank > Bank Entry
Step 2) Click on Quick Entry(Alt + Q)
Step 3) Select Bank right Side above in which bank imports data.
Step 3) Then click on the Left side below option Import From Bank Statement option .
Step 4) Then Select the .XLS file and then press Load option.
Step 5) Then select Account master respective transaction and then Press Save option.