[GNC] Transaction Imports

[Stu Perlman]

Thank for the heads up.

On Mon, Apr 11, 2022 at 3:03 PM D <sunfish62 at yahoo.com> wrote:

> Not going to go into great detail here, but you definitely DON'T want to
> have gnucash calculate shares. Have it calculate price.
> On Apr 11, 2022, at 11:21, Stu Perlman <sgperlman at gmail.com> wrote:
>>
>> Hello Everyone,
>>
>> I am looking for some guidance on how to import a few hundred transactions
>> from my 401(k) account.
>> Unfortunately, the plan administrator does not offer a good option for
>> exporting the transaction data but I am able to get what I need with some
>> basic web scraping.
>>
>> I have been experimenting with creating a multi-split CSV import from the
>> data that I have captured.
>> What I wanted to do was a file layout such as:
>>
>> *Date,Description,Account,Deposit,SharesAsMemo,Price*
>> 01/04/2021,Contribution,Cash,-299.26
>> ,,Vanguard Institutional Index Institutional Fund,299.26,0.916289038,326.6
>> 01/19/2021,Contribution,Cash,-299.26
>> ,,Vanguard Institutional Index Institutional Fund,299.26,0.892008703,335.49
>>
>>
>> My wishful thinking was that I could put the number of shares into the memo
>> column for reference (but that the system would auto-calculate that number
>> using the provided Price and transaction amount ("Deposit")).
>> I hit a blocker on the second to last step of the import wizard with the
>> message: "*The account 'Vanguard Institutional Index Fund' has a different
>> commodity to the one required, 'US Dollar'. Please choose a different
>> account.*"
>>
>> So I'm wondering if there are other ways I can go about what I'm trying to
>> accomplish?  I started with the CSV importer because I figured it would be
>> the easiest record layout to create but I'm not against using a different
>> format if what I want to accomplish can be done.
>>
>> I have a backup plan which is that I will NOT do the multi-split import and
>> will just select the Cash account for all rows in the Import Preview
>> screen. I could pack the memo field with the ticker symbol, price,
>> quantity, and total debit and let it all dump into the Imbalance-USD
>> account. I would then have to either manually fix them one by one or
>> possibly script it out.  I have done this with success in the past but
>> would rather just get it right at the data import step if that's in any
>> way possible.
>>
>> My thanks in advance for any advice offered.
>>
>> - Stu
>> ------------------------------
>>
>> 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
>> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>>