[GNC] import csv transactions with split

David H hellvee at gmail.com
Mon Sep 20 00:41:05 EDT 2021

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 <dsolet at 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 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