[GNC] import csv transactions with split

[David Solet]

Hello,
My version = 4.6 (Windows). I want to import a csv file with split
transactions. The following text lines from the csv file represent one
transaction (not real) that took place on 9/19/2021. This is a simplified
example. An actual transaction would likely have more splits. Column heads
are in the first line. The first line starts with a "," because the first
column head is blank--that is not a typo.
,acct,customer_id,amt,descr,depdate
1,a1net,a1custtl,155.28,cus_JwZTuBkST5GCko_7/29/2021,9/19/2021
2,dues,cus_GtJPUDZyyQ,-40,cus_GtJPUDZyyQ_8/14/2021,
3,dues,cus_IuTPxTysqQ,-40,cus_IuTPxTysqQ_8/1/2021,
4,dues,cus_JwZTuBkST5,-40,cus_JwZTuBkST5_7/29/2021,
5,dues,cus_K2IckcwXuD,-40,cus_K2IckcwXuD_8/13/2021,
6,fees,cus_GtJPUDZyyQ,1.18,cus_GtJPUDZyyQ_8/14/2021,
7,fees,cus_IuTPxTysqQ,1.18,cus_IuTPxTysqQ_8/1/2021,
8,fees,cus_JwZTuBkST5,1.18,cus_JwZTuBkST5_7/29/2021,
9,fees,cus_K2IckcwXuD,1.18,cus_K2IckcwXuD_8/13/2021,

After examining previously exported csv transactions with splits from my
gnucash file, I assumed date needed to be in the first line only. I
attempted to import this as one transaction with multiple splits. I checked
the multi-split box and identified:
acct = account
depdate = date
amt = deposit
customer_id = description
descr = memo

I am hoping screenshots are not scrubbed. The import preview screen looked
like this:
[image: image.png]

After choosing next, I linked the account field with existing accounts. The
account "a1net" is the bank. "dues" is membership dues (type = income).
"fees" is credit card fees  (type = expense). However, at the Match
Transactions screen, my choices did not complete as expected. All of the
splits showed as "New, UNBALANCED...". The screen looked like this:

[image: image.png]
I will point out that there are three separate splits that are linked to
"Membership Fees" and three linked to "Credit card fees PRS" in this one
transaction. a1net is the net bank deposit. I want to preserve that level
of detail for documentation, and that kind of detail can be preserved when
transactions like this are manually entered. Is it possible to do this with
a csv import? Thank you for your help.
David
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 43862 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210919/3f52807c/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 38391 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210919/3f52807c/attachment-0003.png>