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 <[email protected]>
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][email protected]> 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][email protected]>
> *Sent:* Monday, February 05, 2024 8:59 AM
> *To:* Kalpesh Patel <[3][email protected]>; km22
<[4][email protected]>
> *Cc:* [5][email protected]
> *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][email protected] <mailto:[7][email protected]>email
>
>
--------------------------------------------------------------------
----
>
> *From:*gnucash-user
> <gnucash-user-bounces+gylemc=[8][email protected]> on behalf
of km22
> via gnucash-user <[9][email protected]>
> *Sent:* Monday, February 5, 2024 4:54 AM
> *To:* Kalpesh Patel <[10][email protected]>
> *Cc:* [11][email protected] <[12][email protected]>
> *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][email protected]>
> > Sent: Sunday, February 04, 2024 4:57 AM
> > [14]To:[email protected]
> > 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][email protected]
> 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][email protected]
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:[email protected]
2. mailto:[email protected]
3. mailto:[email protected]
4. mailto:[email protected]
5. mailto:[email protected]
6. mailto:[email protected]
7. mailto:[email protected]
8. mailto:[email protected]
9. mailto:[email protected]
10. mailto:[email protected]
11. mailto:[email protected]
12. mailto:[email protected]
13. mailto:[email protected]
14. mailto:To:[email protected]
15. mailto:[email protected]
16. https://lists.gnucash.org/mailman/listinfo/gnucash-user
17. mailto:[email protected]
18. https://lists.gnucash.org/mailman/listinfo/gnucash-user
_______________________________________________
gnucash-user mailing list
[email protected]
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.
