[GNC] OFX with prices and taxes

sunfish62 at yahoo.com sunfish62 at yahoo.com
Tue Dec 23 22:56:57 EST 2025


Luiz, 

I'll note that a major difference between QIF and OFX is the use of a unique ID number (FITID) for each transaction. I don't know whether you are properly generating these, nor do I know precisely how GnuCash handles them in any given import cycle. 

However, I'm not sure exactly why you wouldn't just use the QIF you've gotten already?  Aside from preventing you from reimporting the same transactions (via the aforementioned FITID), I'm not sure there are any benefits to using one format over another. 

⁣David T. ​

On Dec 24, 2025, 4:26 AM, at 4:26 AM, Jim DeLaHunt <list+gnucash at jdlh.com> wrote:
>Hello, Luiz:
>
>On 2025-12-23 05:42, Luiz Angelo Daros de Luca wrote:
>> Hello,
>>
>> My bank does not offer funds status in OFX but in a plain TXT file. I
>> generated a script to convert it to QIF, resulting in something like
>> this:
>>
>> ^
>> D05/12/2025
>> NSellX
>> YRF Ref DI Plus Ágil
>> I7.89737115
>> Q394.33375200
>> T3109.96
>> MResgate Fundo - RF Ref DI Plus Ágil
>> L[Ativos Atuais:Conta Corrente:BB Estilo]
>> O4.24
>>
>> I think OFX can handle this kind of transaction, with fee/taxes but
>> the ones I wrote are ignored by gnucash. Can gnucash handle that info
>> in OFX? And where can I get a good OFX example similar to my case?
>
>Yes, GnuCash can import OFX files.
>
>Be aware that your example above is a QIF format, and OFX format is 
>different from QIF.
>
>I did a search for "OFX example file" and found a few useful links:
>
>  * Example OFX file <https://gist.github.com/jvz/2837829>
>  * "where to get sample ofx files for testing?" question, with several
>    useful answers
><https://stackoverflow.com/questions/3334663/where-to-get-sample-ofx-files-for-testing>
>  * Open Financial Exchange, Wikipedia article
>    <https://en.wikipedia.org/wiki/Open_Financial_Exchange>
>
>I hope that helps,
>      —Jim DeLaHunt
>
>_______________________________________________
>gnucash-user mailing list
>gnucash-user at gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-----
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.


More information about the gnucash-user mailing list