[GNC] Import a transaction from a CSV file with both the debit and credit account set

Geert Janssens geert.gnucash at kobaltwit.be
Sat Jan 12 12:50:48 EST 2019


Op zaterdag 12 januari 2019 18:21:34 CET schreef Patrick:
> Thank you for the advice.
> 
> I am using version 3.3. When I am using the import wizard and specifying
> the contents of each column in the CSV file, I see "Date", "Description",
> "Withdrawal" (amount), and "Account". But I don't see a way to specify the
> other account. (I tried specifying a second "Account" column, but when I do
> this, it deselects the previously selected "Account" column.)
> 
That sounds as if you have enabled the "Multiline" checkbox ?
If that checkbox is *not* checked, there should be some additional column 
types like "Transfer Account" and "Transfer Amount"

But perhaps it's more useful if you post a sample of your csv data (you can 
anonymize it of course). That will make it easier to help you set the proper 
values.

Geert

> Regards,
> Patrick
> 
> On Sat, Jan 12, 2019 at 6:57 AM Geert Janssens <geert.gnucash at kobaltwit.be>
> 
> wrote:
> > I'm pretty sure what you ask can be done in the new csv importer in
> > GnuCash
> > 3.x.
> > 
> > What version of GnuCash are you using ?
> > 
> > Regards,
> > 
> > Geert
> > 
> > Op zaterdag 12 januari 2019 00:34:06 CET schreef Patrick:
> > > Hello,
> > > 
> > > When I am importing transactions from a CSV, I see a way to set one of
> > 
> > the
> > 
> > > accounts involved with the transaction, but not the other account. The
> > 
> > only
> > 
> > > way I know to set the other account is to do it manually in the import
> > > wizard for each transaction. Is there a way to set both accounts in the
> > 
> > CSV
> > 
> > > file so that I don't have to do it manually for each transaction?
> > > 
> > > I like to keep a log of transactions in a CSV file separately from my
> > > Gnucash file, and then import that CSV. If Gnucash doesn't allow setting
> > > both accounts in a CSV file, maybe there is a way to use the QIF format
> > 
> > to
> > 
> > > set both accounts and then import the QIF file? I am open to that, if
> > 
> > that
> > 
> > > is possible.
> > > 
> > > Regards
> > > Patrick
> > > _______________________________________________
> > > 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.






More information about the gnucash-user mailing list