Here is an Excel Template where you can paste your MT940E format and in the third tab this one will be automatically converted into an excel import template made for Odoo. 

Three things to do : 

• Paste your file in the excel template 

• Change the id of the bank statement in the third tab to not have duplicated id 

• Bonus : Vlookup on partner_id to have the partner_id/id 

• By adding a fourth tab with all your contacts and ids you can automate this step 

Then import in Odoo via model = account.bank.statement

PS : if you want to look into a formula don’t forget to valid it back by clicking on “Ctrl+Shift+Enter” and not just “Enter”

MT940E Import Template