First, you have to save your bank statement Excel in Excel 97-2003 Workbook form

Step: 1
- Transaction → Quick Entry → Bank Payment

Step: 2
- Click on Import

Step: 3
- Select Bank Account → Set Format

Step: 4
- After Set Format Select Option as Excel Sheet Sequence → Click on Save

Step: 5
- Write Your Excel Sheet Name → Click on Browse and Select Your Excel sheet → click on save & close
