• Firstly, the user needs to export the Bank Statement in Excel or CSV format.
•  Suppose user has exported the bank statement in Excel.

• Go to Digital > Bank Reconciliation. 
  

• In 'Select Bank', the user will select the bank from the drop down as per the requirement.
• Then click on 'Okay'.

• Then the user will select the date range. 

• Then select 'Excel' from the drop down.

Note: In order to import the statement, the user needs to create the method for it.

• The user will select 'Import Method'.

• In Bank Statement Import utility the user will select the bank.

• Then click on 'Add' to create a new method.

• In 'Date Format', the user will select that date format which is mentioned in the excel which is required to be imported for reconciliation.

• Then the user will mention 'CR' in 'Deposit field and 'DR' in Withdrawal field.
• In 'Read Recs from', the user will mention that row from which the data has been started in excel.
• Suppose, mention 5.
• The user will mention the columns which contain the required details i.e. transaction date, cheque no. etc.
• Suppose 'Transaction date' is in 'Column A' and 'Cheque no' is in 'Column D'.

• Then the user will press 'ESC'.
• The user will click on 'Yes' to exit from this window.

• Then click on 'Browse' to attach the bank statement of excel format.

• The user will click on 'Directory' and choose the location from where the file needs to be imported.
• Then user will click on select the file. 

• Click on 'Okay'.

• An 'Enter Start Row' window will appear in which the user will mention that row from which the data is being started in excel.
• Suppose mentions 2. Click on 'Ok'. 

After following the above steps, an excel of bank statement will get imported and the user can easily reconcile the bank statement in Marg ERP Software.