Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

How do i import Dutch bankstatements of the ABN AMRO bank?

By
Jeroen Hermans
on 4/17/14, 12:32 PM 2,614 views

I am using the ABN AMRO bank in Holland for my business. I can export bankstatements in .TAB (tab delimited) or MT940 format. I can find a lot of people trying to import from ABN AMRO, but i cannot find a solution for this (trivial?) problem.

How can i import bankstatements of ABN AMRO from internet banking?

0

Hi, There are 2 solutions. That is the TAB version (but not sepa compliant) or you can use the CAMT.053 format. YOu can use the modules here: https://code.launchpad.net/~banking-addons-team/banking-addons/banking-addons-70

Hi Erwin. Thank you for the fast reply! If i understand correctly i should install either account_banking_mt940 for the MT940 ABN format, or account_banking_nl_abnamro for the .TAB format? When using account_banking_nl_abnamro i get "Afschriften gevonden voor rekening 0xxxxxxxxx, maar er is geen standaard dagboek aangemaakt." (no journal created in Dutch). I am not completely sure on how to create a default journal in OpenERP. The account_banking_mt940 description tells me it is basically just a framework and has no real functionality?

Jeroen Hermans
on 4/17/14, 2:44 PM

Just for future reference: i added a journal for the bankaccount. When i did that, i could import the .TAB file using account_banking_nl_abnamro. Thank you Erwin!

Jeroen Hermans
on 4/18/14, 5:18 AM

Unfortunately it does not work when there is an "Acceptgirobetaling" in my .TAB file: XXXXXXXXX EUR 20140125 xxxxx,84 xxxxx,84 20140125 -xxxxx,00 /TRTP/Acceptgirobetaling/IBAN/NL86INGB0002445588/BIC/INGBNL2A /NAME/Belastingdienst/REMI/ISSUER: CUR REF: 6158 3735XXXXXXXXXXX/EREF/XXXXXXXX/XXXX//XX/XXXXXXXXXX

As this is the "belastingdienst" (IRS in the US) i have these mutations rather often :( Did something change in the ABN format?

Jeroen Hermans
on 4/20/14, 2:33 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 4/17/14, 12:32 PM
Seen: 2614 times
Last updated: 3/16/15, 8:10 AM