[GNC] Transaction Imports

[David T.]

Further to this: you care about how much money something cost (the amount you have spent), and how much you got for it (the amount of shares you purchased). The first affects how much money you have in your bank account, the second affects how many shares show in your mutual fund.

On April 11, 2022 8:16:06 PM EDT, Stu Perlman <sgperlman at gmail.com> wrote:
>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.
>>>
>>>