Change to the Advanced Portfolio report

[David Carlson]

On 1/20/2015 2:13 AM, Mike Alexander wrote:
> --On January 19, 2015 at 11:00:44 PM -0600 David Carlson
> <david.carlson.417 at gmail.com> wrote:
>
>> Bottom line, I am asking that the Advanced Portfolio Report correctly
>> allocate dividend income (or capital gain income) for several
>> different security accounts that are combined into one transaction,
>> probably by noting that each income sub-account has a name similar to
>> it's corresponding security sub-account.
>>
>
> That's a non-trivial change which I don't want to get into right now.
> What I do in similar circumstances is download the transactions into a
> QFX file and import them into GnuCash.  This produces 30 or 40
> separate transactions each time, rather than one master transaction,
> but it seems to work ok.  I still have to enter some transactions
> manually, but this still saves me a fair amount of work.
>
> If you want this suggestion to be preserved for future consideration,
> you should file an enhancement request in BugZilla.
>
>          Mike
>
> PS: I pushed a new version of the report tonight that fixes a minor
> bug in the code I just added.  It was ignoring the date of the report.
>
I will submit an enhancement request.

My 401-K custodian does not offer QIF or OFX exports, so I would need to
mess with CSV to QIF, OFX or something like that in my case. 

However, your suggestion brings up the point that the QIF or OFX
importer would need to differentiate between many similar investment
transactions in the same file that should be allocated to different
sub-accounts.  Can that part of the process work automatically or would
it be necessary to manually fine tune each of those 30 or 40
sub-transactions to the correct sub-accounts each time.  I have not even
tried importing investment transactions in several years because GnuCash
used to fail miserably with them.

The "CSV" file that my custodian can provide does have unique
combinations of security and account descriptions for each sub-account
transaction, but I am not sure that I could convert that file into a QIF
or OFX file. 

David C