[GNC] Multi split transactions using csv import

Geert Janssens geert.gnucash at kobaltwit.be
Tue Nov 3 03:24:33 EST 2020


Hi,

The gnucash csv importer unfortunately can't handle that case. Your only option is to transform 
the csv data outside of gnucash to be in a format it does support.

Regards,

Geert

Op zondag 1 november 2020 02:21:14 CET schreef Craig Phillips:
> Hi,
> 
> I've been scratching my head on how to do this for a significant time so
> hoping someone can help...
> 
> I have transactions that I have downloaded from a site, and that I would
> like to import into gnucash using a csv.
> 
> Each transaction is a row and in columns I have a total credit, balanced by
> the sum of two debits.
> 
> Normally when I'm trying to work out what my import file needs to look like
> I enter an example transaction manually and then download the transaction
> list from that sub account to give me an idea of what I would need to do.
> Having done that, and what I can gather from the documentation, it looks
> like split transaction entries are meant to be entered as rows one after
> the other. This would be painful for me as I have the necessary data in
> columns and I can't work out an easy way of transposing the data to
> individual rows.
> 
> So my question - can the csv import work for me if I'm looking to upload
> one row for a split transaction? (i.e. one credit balanced by two debits).
> If so, what does it look like?
> 
> Thanks in advance for your help.
> _______________________________________________
> 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