I am experimenting with Tryton and the latest Docker image and trying to import an OFX file. Statement import, is okay Have a company name File File extension But when I try to import I am told I need a journal. I guessed that I needed somewhere for the import to go but I do not know how to crea…

It is the statement journal that needs to be linked to the bank account and define some accounting properties like journal, account etc.

Sorry, I am going to have to go back over this. Not sure how to link ‘statement journal’ ‘bank account’. How do I create a ‘statement journal’? Is it under Financial>Configuration>Journals>Journals? Then how are they linked? If this is in the documentation, please give me a hint where? Thank yo…

[image] douglas: How do I create a ‘statement journal’? It is in Financial > Configuration > Statements > Statement Journals [image] douglas: Then how are they linked? By bank account number.

Experiment only, I managed to import an OFX file. Thank you for your help. I have a suggestion. The OFX statement import detects the account it is to be imported to from the text otf OFX file. There should be a way of overriding this. In my OFX file the account number had be partially anonymized (…

[image] douglas: In my OFX file the account number had be partially anonymized (of the form ****1234). This is strange. What is the point to anonymize your own data? Also bank account number is not really sensitive. [image] douglas: If you think it is valid then where should I submit it? …

In my OFX file the account number had be partially anonymized (of the form ****1234). This is strange. What is the point to anonymize your own data? Also bank account number is not really sensitive. I have no idea why the bank does this.

I am looking at the journal for the imported OFX file and it has not picked up a description. I am comparing this to my experience using GnuCash. I understand that I might have to do some configuration but am not sure what? Here is an image of what I have. I am still to select the the party and acc…

[image] douglas: it has not picked up a description Tryton takes the OFX memo of the transaction as description for the origin. [image] douglas: I am still to select the the party and account . Yes if the payee of OFX does not match exactly any existing party (and only one). But now …

Hello, Just checking the next stage of the process. Have I also to get the pending amount to zero by filling in lines for each entry? This seems especially useful for splitting transactions. Thanks, Douglas

[image] douglas: Have I also to get the pending amount to zero by filling in lines for each entry? Yes you must affect the lines to the proper accounts and/or invoice etc.

Create Journal for OFX import

Support User

Topic		Replies	Views
Best practice startup for US-style importing OFX files for Bank Account and Credit Card account User accounting	1	107	October 22, 2024
MT940 import - journal required User accounting	13	116	November 19, 2025
Statement journal <-> bank account association User accounting	2	91	July 5, 2024
How to configure the statement process? User	1	238	May 20, 2022
Importing OFX statement file in 5.0 User	3	435	January 6, 2020

Create Journal for OFX import

Related topics