[GNC] Multi-split CSV Import

D. sunfish62 at yahoo.com
Fri Aug 20 11:46:21 EDT 2021


Glad you're putting this into a narrative. In the past, I've worked on the docs, on both Mac and Windows environments. If I* can do it, it's most certainly possible!

David

* Geert and other long term devs can vouch for my high level of ineptitude regarding the development tools. 


-------- Original Message --------
From: flywire <flywire0 at gmail.com>
Sent: Fri Aug 20 09:32:16 EDT 2021
To: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Multi-split CSV Import

Geert, thank you. With that pretty simple explanation I completely
understand it.

I've rolled all that together ordering the split description lines the same
as the input form and added an example based on the Tutorial and Concepts
Guide. David T, I'm with you on contributing but iirc the development
environment to contribute to the docs is all but unachievable on Windows.
I'll leave this as a suggestion.

==========

* Multi-split: Selecting this check box allows the splits for a single
transaction to be defined on consecutive lines within the file with each
line defining a single split. If not selected each line is assumed to
contain the information for a single transaction including one or two
splits;

Multi-split is a gnucash specific variant of a csv file to support easier
data preparation.

Each line should define one split via:
- transaction-specific fields (date and description as bare minimum) *and*
- split specific fields (account and deposit/withdrawal as bare minimum).

There is a convenience feature built-in so you don't have to repeat the
transaction fields if the split belongs to the same transaction as the
previous one (though you can repeat them if that makes csv preparation
easier).

Sample Multi-split.csv

Date,Description,Deposit,Account
05/03/2006,Grocery Store,-45.21,Assets:Checking
,,45.21,Expenses:Groceries
14/03/2006,Employers R Us,670.00,Assets:Checking
,,180.00,Expenses:Taxes:Federal
,,90.00,Expenses:Taxes:Medicare
,,60.00,Expenses:Taxes:Social Security
,,-1000.00,Income:Salary
_______________________________________________
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