Skip to Content
This question has been flagged
accountingimportbank_statementquickstart
1 Reply
3142 Views
Avatar
Nicolas Van Den Neste (nvd)

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


Avatar
Discard
Avatar
Nicolas Van Den Neste (nvd)
Author 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
Discard
Related Posts Replies Views Activity
Bank statement import in excel or CSV
accounting import bank_statement
Avatar
Avatar
Avatar
2
Jan 23
7448
[Accounting] Add a line before posting Solved
accounting import chartofaccount quickstart
Avatar
1
Aug 23
4106
[15community] Import camt.053 file contains information like # results in damaged accounting (database)
accounting import reconciliation bank_statement
Avatar
0
Jul 23
663
Import plan comptable
accounting import
Avatar
0
Mar 24
285
How to handle existing Odoo-data when setting up Odoo accounting?
accounting import
Avatar
Avatar
1
Apr 24
378