[GNC] Transaction Imports

[Jon Schewe]

Anyone have a how-to or tutorial on how to import stock transactions
from a CSV file? I'm not finding anything in the documentation on how
to handle the different commodities.

On Sun, 2022-06-19 at 15:10 -0500, Jon Schewe wrote:
> I'm trying to do a similar import and I'm finding that I can't
> convince
> GnuCash to enter the other account. I'm using import transactions
> from
> CSV.I have matched columns to Date, Description, Account, Price,
> Deposit, Transfer Account.The "Account" column is the mutual fund
> account.The "Transfer Account" column is the currency account.
> When I start the import process all of my transactions need an
> account
> to transfer from, despite specifying the Transfer Account. When I try
> and select my currency account I'm told that it has the wrong
> commodity.
> I have another column for the currency amount, but I don't know what
> to
> map that to in the importer.
> I tried checkout out 
> https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv
> 
>  but it doesn't seem to address this.Suggestions on where I'm going
> wrong.
> On Mon, 2022-04-11 at 22:36 -0400, David T. via gnucash-user wrote:
> > 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 tohave 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
> > > > > transactionsfrom my 401(k) account.Unfortunately, the plan
> > > > > administrator does not offer a good option forexporting the
> > > > > transaction data but I am able to get what I need with
> > > > > somebasic web scraping.
> > > > > I have been experimenting with creating a multi-split CSV
> > > > > import from thedata that I have captured.What I wanted to do
> > > > > was a file layout such as:
> > > > > *Date,Description,Account,Deposit,SharesAsMemo,Price*01/04/20
> > > > > 21
> > > > > ,Contribution,Cash,-299.26,,Vanguard Institutional Index
> > > > > Institutional
> > > > > Fund,299.26,0.916289038,326.601/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 memocolumn for reference (but that the system would
> > > > > auto-calculate that numberusing the provided Price and
> > > > > transaction amount ("Deposit")).I hit a blocker on the second
> > > > > to last step of the import wizard with themessage: "*The
> > > > > account 'Vanguard Institutional Index Fund' has a
> > > > > differentcommodity to the one required, 'US Dollar'. Please
> > > > > choose a differentaccount.*"
> > > > > So I'm wondering if there are other ways I can go about what
> > > > > I'm trying toaccomplish?  I started with the CSV importer
> > > > > because I figured it would bethe easiest record layout to
> > > > > create but I'm not against using a differentformat 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 andwill just select the Cash account for all
> > > > > rows
> > > > > in the Import Previewscreen. I could pack the memo field with
> > > > > the ticker symbol, price,quantity, and total debit and let it
> > > > > all dump into the Imbalance-USDaccount. I would then have to
> > > > > either manually fix them one by one orpossibly script it
> > > > > out.  I have done this with success in the past butwould
> > > > > rather
> > > > > just get it right at the data import step if that's in anyway
> > > > > possible.
> > > > > My thanks in advance for any advice offered.
> > > > > - Stu------------------------------
> > > > > gnucash-user mailing 
> > > > > listgnucash-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.
> > > > > 
> > 
> > _______________________________________________gnucash-user
> > mailing 
> > listgnucash-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.
> 
> _______________________________________________
> 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.
>