Vanguard downloads

[Andrew Gross]

David,

Wanted to do a fair amount of additional testing before I wrote back...

I have tried two different tracks of testing...

1) Manually downloading QFX files.  For each mutual fund I setup the
security account, the income account, the cap short gains account and the
cap long gains account.  I downloaded a specific time range -- starting
with just one month for simplicity -- and tried uploading.  I had to map
the QFX accounts to the gnucash accounts before each upload; there doesn't
seem to be a facility for remembering mapping.  It seemed straightforward
except that the first account to map is called the "OFX account" and the
second account is the "security account".  I don't know what the difference
is between an OFX account and a security account; I used the security
account for both.   Income was downloaded the income accounts perfectly.
But cap gains are ignored.  Actually, gnucash didn't ask for a mapping to
the cap gains accounts.

2) Automatic downloads via AQBanking.  In setting up the online wizard, I
can connect to Vanguard OK but for mutual funds the account I login with is
a master account number, not the number of the mutual fund so the mapping
doesn't make sense.  Just to test, I created a new account just for the
master account and nothing downloaded but I didn't expect it would.

At this point, I am having a problem determing 1) if I am asking gnucash to
do something it wasn't meant to do 2) Vanguard's data is somehow
incompatible or 3) I am not configuring gnucash properly.

I am continuing to google search on things like "vanguard" and "gnucash".

Thanks,

Andrew

Andrew Gross
m 646.204.5819

On Sat, Jan 21, 2017 at 10:02 AM, David Carlson <david.carlson.417 at gmail.com
> wrote:

> GnuCash can track multiple accounts downloaded in one OFX file if the file
> is formatted correctly.  I do that regularly with ordinary bank accounts at
> one of my banks.  I am not sure about investments as my broker does not
> offer OFX downloads.
>
> Does that help?
>
> David C
>
> On Fri, Jan 20, 2017 at 11:05 AM, Andrew Gross <biz.aeg at gmail.com> wrote:
>
>> Hello again,
>>
>> I have been successful with initial tests in download Vanguard data into
>> GC
>> via the QFX format and I have successfully setup an AQbanking connection
>> to
>> Vanguard.  (Setting up a separate GC test bed has been a great help.)
>>  Ideally, I would like to download via OFX/Aqbanking into all my Vanguard
>> accounts but am thinking this violates how GnuCash works.  For example, if
>> I have a mutual fund account with x number of funds, Vanguard will want to
>> dump all transactions into one account instead of allowing for each fund
>> to
>> go into a separate account.
>>
>> But with a QFX download, I can specify which account to download and then
>> manually upload to the appropriate fund's account in GnuCash
>>
>> Anyone have similar experiences?
>>
>> Thanks for any help.
>>
>> Kind regards,
>>
>> Andrew Gross g
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> 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.
>>
>
>