[GNC] Multi split transactions using csv import

[will at theprescotts.com]

Is this a one time chore. I don't know about doing it on the Gnucash side, but it seems relatively easy to do in in a spreadsheet.

Insert a column for numbering the rows.

Duplicate all the rows as a block, i.e. with the second copy of all the rows following the first block
e.g.
1 a ...
2 b ...
3 c ...
4 d ...
1 a ...
2 b ...
3 c ...
4 d ...

In the first block clear the column for one of the splits
In the second block clear the column for the other split

In one block copy the splits into the same column they are in in the other block

Finally sort all rows to put the splits back on consecutive rows
1 a ...
1 a ... 
2 b ... 
2 b ...
3 c ...
3 c ...
4 d ...
4 d ...

Will



On 2020 Oct 31, at 10-31 19:21:14, Craig Phillips <craigphil at gmail.com> wrote:

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.