[GNC] Transaction Imports

[Jon Schewe]

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/2021
> > > > ,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.