I don't use the csv importer but it seems to be complaining about not having a transfer account - "New, UNBALANCED (need acct to transfer $($$$.cc))! While you do have a text description in the account column when I do a csv import in gnucash format the account names are in the full format eg "Expenses:Credit Card:Fees". Does that help ?
Cheers David H. On Mon, 20 Sept 2021 at 13:14, David Solet <dso...@gmail.com> wrote: > 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 > _______________________________________________ > gnucash-user mailing list > gnucash-user@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 list gnucash-user@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.
