Skip to Content
This question has been flagged
4 Replies
4545 Views
Avatar
Hubert Pineault

I'm using Odoo 10 Community. I've install account_bank_statement_import and it's accessible. It seems that the ofx import is either available with the enterprise version or through a OCA module found here:

https://github.com/OCA/bank-statement-import


This module requires python library ofxparse and, in the discussion feed of github, it was mentionned that version 0.16 was required. I installed 0.16 with pip (I'm running on a debian machin and the repositories only contain 0.14), place the github module in my addons directory and successfully intalled the module through the app tool in odoo.

But, when I go into the import form, it still shows only the csv import textbox.

Doing some research in odoo, I found under the accounting setting that csv and ofx are only available for the enterprise edition. Clicking or unclicking this option doesn't change anything.

Any idea what could be done?

Avatar
Discard
Hubert Pineault
Author

Something's weird. Uninstalling account_bank_statement_import doesn't remove the import option.

Hubert Pineault
Author

I found the solution. The new module is available straight in the accounting board, under your bank account journal.

Avatar
Hubert Pineault
Author Best Answer

So it turns out I was look way to deep for this simple task.

This is available straight in the accounting board (not sure of the translation; "tableau de bord" in french). You have to create first a bank account for your society and a journal linked to it. The journal would than be available on your accounting board.
There will be a button (and later a grey link after the first import) 'import statement' (or something similar, "importation d'un relevé" in french). From there, it's pretty straight foward. Note that your bank account needs to have the full bank id, not just the folio (815-12345-12345678-EOP, for ex).
Also, it seems that the original bank import module interfere with the bank_account_statement_import module and the OCA bank_account_statement_import_ofx module. The only way to access ofx import is the one mentionned above, but their exist two other ways of importing bank statement, which you want to avoid if you're looking to import ofx.

1. On the accounting board, in your bank journal, their is a 'more' button which will span a menu were you find a import statement option. This will bring you to the original importation tool which only offers csv importation. 

2. In the Accounting module, under 'Settings', you will find 'Accounting'. Expand it and there will be 'bank account' (I'm not sure of the term, I'm translating from my french version). Click on it and click on the bank account for which you want to import a statement. Then, under the 'Actions' button, you'll find the option 'Account statements'. Click on it and it will bring you to a page were you see all statements linked to this bank account. You will also have the options of creating or importing new statement. Importing will bring you to the original form where you can only import csv.

Avatar
Discard
Avatar
Rob Baxter
Best Answer

Thanks Hubert.  BTW, the English version of  "tableau de bord" in Odoo is "Switchboard"
If anyone else is looking for it here is how to get there:

(Top Black Menu) "Accounting" -> (Left Side Menu) -> "Dashboard" -> "Bank" box -> (right corner) More -> "Import Statement"

Avatar
Discard