Thanks. This can be a very tedious process, especially where there might be dozens of securities to match one by one through a gui that requires many clicks through different drop down lists.
It would be nice if there was a way to ensure much better matching suggestions and then the user simply needs to click to accept (in most instances). I’ll continue to experiment with importing IBKR ofx transactions into a dummy test file. Thanks for the guidance so far. On 6 Feb 2024, at 13:21, Steve Butler <stephen.m.butle...@gmail.com> wrote: That is true for the first time. After that it will learn the matches you make and only ask for new ones. On Tue, Feb 6, 2024, 16:35 km22 via gnucash-user <[1]gnucash-user@gnucash.org> wrote: Thanks. Upon importing the OFX I am prompted to match the different bonds in the statement with the relevant asset in GnuCash: This is quite a manual process having to match these manually one-by-one. Do you know whether there is a way for me to define the assets in GnuCash so this mapping is more automated? (Or at least where GnuCash is able to select the best match for me to review?) Since it reads "Please note that the exchange code of the commodity you select will be overwritten" does this mean that if I set the ISIN/CUSIP correctly in GnuCash the mapping would be more seamless? On 2024-02-05 22:17, Kalpesh Patel wrote: > > Ken, as Gyle mentioned, they are sibling to each other. In terms of > technical specs, QFX is modified OFX format which contains additional > Intuit’s non-XML header but GNC treats them both equal as it simply > ignores that header. From the transaction wise they both will contain > identical data. > > *From:*Gyle McCollam <[2]gmccol...@live.com> > *Sent:* Monday, February 05, 2024 8:59 AM > *To:* Kalpesh Patel <[3]kalpesh.pa...@usa.net>; km22 <[4]k...@gmx.com> > *Cc:* [5]gnucash-user@gnucash.org > *Subject:* Re: [GNC] GnuCash with Interactive Brokers > > It doesn't "prefer" either, in fact the import is OFX/QFX. > > Thank You, > > *Gyle McCollam* > > Gyle McCollam > > [6]gmccol...@live.com <mailto:[7]gmccol...@gyleshomes.com>email > > -------------------------------------------------------------------- ---- > > *From:*gnucash-user > <gnucash-user-bounces+gylemc=[8]gmail....@gnucash.org> on behalf of km22 > via gnucash-user <[9]gnucash-user@gnucash.org> > *Sent:* Monday, February 5, 2024 4:54 AM > *To:* Kalpesh Patel <[10]kalpesh.pa...@usa.net> > *Cc:* [11]gnucash-user@gnucash.org <[12]gnucash-user@gnucash.org> > *Subject:* Re: [GNC] GnuCash with Interactive Brokers > > Hi Kalpesh, > > Thanks for your reply. IBKR offers these "Third-party Downloads": > > 1. Quicken Web Connect -> which generate a QFX file > > 2. GainsKeeper > > 3. TradeLog > > 4. MS Money -> which generates a OFX file > > > Do you know whether GnuCash prefers OFX or QFX? > > I have downloaded both and will experiment with them. > > Thanks, > > Ken > > > > On 2024-02-05 10:27, Kalpesh Patel wrote: > > While I am NOT with Interactive Broker, your best bet is to see if > you can download transactions in OFX (Open Financial Exchange) or QFX > (Quicken Financial Exchange) format. That would be the best format and > I believe most broker-dealers support that format as a download method > from their web portal. > > > > -----Original Message----- > > From: km22<[13]k...@gmx.com> > > Sent: Sunday, February 04, 2024 4:57 AM > > [14]To:gnucash-user@gnucash.org > > Subject: [GNC] GnuCash with Interactive Brokers > > > > Hi Gnucash Users, > > > > Does anyone on this mailing list have a method for importing > transactions from Interactive Brokers (IBKR) to GnuCash? (Especially > multi-currency users.) > > > > I currently enter all transactions manually but would like to > explore ways of importing transactions. > > > > Please share your approach if so. > > > > Thanks, > > > > Ken > > > > > > > > > _______________________________________________ > gnucash-user mailing list > [15]gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > [16]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. > _______________________________________________ gnucash-user mailing list [17]gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: [18]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. References 1. mailto:gnucash-user@gnucash.org 2. mailto:gmccol...@live.com 3. mailto:kalpesh.pa...@usa.net 4. mailto:k...@gmx.com 5. mailto:gnucash-user@gnucash.org 6. mailto:gmccol...@live.com 7. mailto:gmccol...@gyleshomes.com 8. mailto:gmail....@gnucash.org 9. mailto:gnucash-user@gnucash.org 10. mailto:kalpesh.pa...@usa.net 11. mailto:gnucash-user@gnucash.org 12. mailto:gnucash-user@gnucash.org 13. mailto:k...@gmx.com 14. mailto:To:gnucash-user@gnucash.org 15. mailto:gnucash-user@gnucash.org 16. https://lists.gnucash.org/mailman/listinfo/gnucash-user 17. mailto:gnucash-user@gnucash.org 18. https://lists.gnucash.org/mailman/listinfo/gnucash-user _______________________________________________ gnucash-user mailing list gnucash-user@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.