Skip to Content
This question has been flagged
accountingimportbank_statementquickstart
1 Respondre
5915 Vistes
Avatar
Nicolas Van Den Neste (nvd)

Odoo is not supporting MT940E for the bank statement format, so how to import it ?


Avatar
Descartar
Avatar
Nicolas Van Den Neste (nvd)
Autor Best Answer

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


Avatar
Descartar
Related Posts Respostes Vistes Activitat
Bank statement import in excel or CSV
accounting import bank_statement
Avatar
Avatar
Avatar
2
de gen. 23
10432
[Accounting] Add a line before posting Solved
accounting import chartofaccount quickstart
Avatar
1
de febr. 25
6466
[15community] Import camt.053 file contains information like # results in damaged accounting (database)
accounting import reconciliation bank_statement
Avatar
0
de jul. 23
2872
How to re-invoice your customer from a vendor bill?
accounting quickstart
Avatar
1
d’oct. 25
4920
FAILURE TO IMPORT JOURNAL ENTRIES
accounting import
Avatar
Avatar
1
de febr. 25
2813