[GNC] GnuCash with Interactive Brokers
Jonathan Knepher
jbk at wild-e.com
Sun Feb 4 17:28:03 EST 2024
I export a report from IB in QFX format* either when I have transactions
or at the end of each month, and import it on GnuCash. It almost works
perfectly, occasionally I have to fixup the account references for
dividends. IB automatically provides reasonable non-conflicting
filenames for the QFX exports too. (AcctNum_StartDate_EndDate.qfx) It
has been a while since I had multi-currency transactions, but I don't
remember it being an issue.
I used to have IB autogenerate and email the reports to me - they would
come as CSV, but dealing with duplicated transaction lines in that
method was more tedious than using the QFX method.
* - Performance & Reports, Statements, Quicken Web Connect; then select
the date range you need.
On 2/4/24 12:11, Jim DeLaHunt wrote:
> On 2024-02-04 01:56, km22 via gnucash-user wrote:
>
>> 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.
>
> Me too! I have Interactive Brokers accounts in two currencies. While
> the volume of transactions is low enough that I can keep up by hand
> entry, I would like to learn a more automated method.
>
> I encourage contributions to the list and/or GnuCash wiki, not just
> individual emails to the original poster.
>
> Best regards,
> —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