Re: [GNC] Example of multi-split feature of CSV importer?
Michael, Adrien, Section 4.3 in the Guide is titled "Simple vs. Split Transactions" and explains in some detail what is meant. Perhaps the language there is not clear enough (improvements always welcome!), but it's not true that this isn't defined or explained. David On March 19, 2019, at 4:32 AM, Adrien Monteleone wrote: I think the confusion lies with using the undefined term ‘multi-split’ at all. As Geert pointed out, *all* transactions have multiple ’splits’. (when used as a noun to mean each ledger entry) This reference to ‘multi-split’ likely arises because the register by default, as well as the CSV importer only show a single line with the ‘other’ account rather than both ledger entries. This is why I always recommend users just getting started with GnuCash to turn on the Transaction Journal view mode so they can see everything that is going on. It helps to understand the double-entry process. I preferred it so much (and many of my transactions contain 3 or more ledger entries anyway) that I just use it permanently. When trying to help family members learning GnuCash, I’ve found they are routinely confused when they only see the transfer account and then have to do a more complicated entry. Regards, Adrien > On Mar 18, 2019, at 5:43 PM, Michael Hendry wrote: > >> On 18 Mar 2019, at 17:54, Geert Janssens wrote: >> >> Hi Hendry, >> >> The term split has been in use in GnuCash long before I joined the project. >> As >> I'm not an accountant, I don't know which would be the proper formal >> accounting term to use in this context. And additionally it may be very hard >> to change the use of this term throughout the project (though if there >> really >> is a more correct term it may be worth gradually promoting it). >> >> Regards, >> >> Geert > > Evening, Geert. > > Agreed, in the glossary the definition of a split goes like this... > > "Split > A split, or Ledger Entry, is the fundamental accounting unit...” > > ...I’ve been using Gnucash for 9 years and have coped with the concept in > practice. > > There is always a place for a tightly defined vocabulary in any technical > context, but I’m puzzled at the choice of “split”, when “Ledger Entry” > describes the idea so well, and split already means something else. > > Perhaps it’s a UK/US usage thing? > > I’ve never used the CSV import procedure, but I’ve been skimming the current > threads on this topic and felt that Gnucash newbies might benefit from some > clarification. For example, the term “multi-split” has no definition in the > glossary. > > “Multi-“ is conventionally used to mean “more than one”, but in this instance > it’s been defined to mean “more than two”. > > I’m not an accountant either, and I’m not necessarily arguing that the term > “split” should be renamed, just pointing out that there is potential for > misunderstanding. > > Michael Hendry ___ 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.
Re: [GNC] Example of multi-split feature of CSV importer?
I think the confusion lies with using the undefined term ‘multi-split’ at all. As Geert pointed out, *all* transactions have multiple ’splits’. (when used as a noun to mean each ledger entry) This reference to ‘multi-split’ likely arises because the register by default, as well as the CSV importer only show a single line with the ‘other’ account rather than both ledger entries. This is why I always recommend users just getting started with GnuCash to turn on the Transaction Journal view mode so they can see everything that is going on. It helps to understand the double-entry process. I preferred it so much (and many of my transactions contain 3 or more ledger entries anyway) that I just use it permanently. When trying to help family members learning GnuCash, I’ve found they are routinely confused when they only see the transfer account and then have to do a more complicated entry. Regards, Adrien > On Mar 18, 2019, at 5:43 PM, Michael Hendry wrote: > >> On 18 Mar 2019, at 17:54, Geert Janssens wrote: >> >> Hi Hendry, >> >> The term split has been in use in GnuCash long before I joined the project. >> As >> I'm not an accountant, I don't know which would be the proper formal >> accounting term to use in this context. And additionally it may be very hard >> to change the use of this term throughout the project (though if there >> really >> is a more correct term it may be worth gradually promoting it). >> >> Regards, >> >> Geert > > Evening, Geert. > > Agreed, in the glossary the definition of a split goes like this... > > "Split > A split, or Ledger Entry, is the fundamental accounting unit...” > > ...I’ve been using Gnucash for 9 years and have coped with the concept in > practice. > > There is always a place for a tightly defined vocabulary in any technical > context, but I’m puzzled at the choice of “split”, when “Ledger Entry” > describes the idea so well, and split already means something else. > > Perhaps it’s a UK/US usage thing? > > I’ve never used the CSV import procedure, but I’ve been skimming the current > threads on this topic and felt that Gnucash newbies might benefit from some > clarification. For example, the term “multi-split” has no definition in the > glossary. > > “Multi-“ is conventionally used to mean “more than one”, but in this instance > it’s been defined to mean “more than two”. > > I’m not an accountant either, and I’m not necessarily arguing that the term > “split” should be renamed, just pointing out that there is potential for > misunderstanding. > > Michael Hendry ___ 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.
Re: [GNC] Example of multi-split feature of CSV importer?
> On 18 Mar 2019, at 17:54, Geert Janssens wrote: > > Hi Hendry, > > The term split has been in use in GnuCash long before I joined the project. > As > I'm not an accountant, I don't know which would be the proper formal > accounting term to use in this context. And additionally it may be very hard > to change the use of this term throughout the project (though if there really > is a more correct term it may be worth gradually promoting it). > > Regards, > > Geert Evening, Geert. Agreed, in the glossary the definition of a split goes like this... "Split A split, or Ledger Entry, is the fundamental accounting unit...” ...I’ve been using Gnucash for 9 years and have coped with the concept in practice. There is always a place for a tightly defined vocabulary in any technical context, but I’m puzzled at the choice of “split”, when “Ledger Entry” describes the idea so well, and split already means something else. Perhaps it’s a UK/US usage thing? I’ve never used the CSV import procedure, but I’ve been skimming the current threads on this topic and felt that Gnucash newbies might benefit from some clarification. For example, the term “multi-split” has no definition in the glossary. “Multi-“ is conventionally used to mean “more than one”, but in this instance it’s been defined to mean “more than two”. I’m not an accountant either, and I’m not necessarily arguing that the term “split” should be renamed, just pointing out that there is potential for misunderstanding. Michael Hendry (my email address has my surname and first name in that order because michael.hendry… was already taken when I signed up!) ___ 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.
Re: [GNC] CSV Import
Thanks Geert. Apologies for top posting and typos. I'm in Taipei on the way to Manilla and thence to the north end of Luzon Island. I'll file an enhancement request once I'm back home in a couple of weeks. For those wishing TMI, please look at www.ihsamission.comSent from my Verizon, Samsung Galaxy smartphone Original message From: Geert Janssens Date: 3/18/19 18:14 (GMT+08:00) To: gnucash-user@gnucash.org Cc: "Stephen M. Butler" Subject: Re: [GNC] CSV Import Op donderdag 14 maart 2019 17:22:48 CET schreef Stephen M. Butler:> For some reason my Citi Visa account has lost the ability to export file> in non-CSV formats. So, running the CSV importer on the file that had> fields:> > Status, Date, Description, Debit, Credit, MemberName> > I mapped Date --> Date, Description --> Description, Debit -->> Deposit, Credit --> Withdrawl> > Noticed that there were three rows with amounts in the Credit column and> all said values where negative!> > Ran the importer and saw that those three rows were treated as charges. > What should I have done? Especially since Citi put negative values in> the Credit column.> > Could I map both columns as Deposit? Counter-intuitive but so is Citi> Cards right now!> > --SteveUnfortunately you can't map both columns to Deposit. We may have to improve this (as well as disambiguating the names). I couldn't find an enhancement request for this yet in bugzilla. Feel free to add one so this issue won't get lost.As a workaround you can preprocess your csv files to* either merge the Debit and Credit columns (so you have one column with both positive and negative numbers and you map this column to "Deposit")* or make the numbers in the Credit column positive (so you have two columns with all positive numbers and then map Debit to Deposit and Credit to Withdrawal)Geert ___ 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.
Re: [GNC] Example of multi-split feature of CSV importer?
And to carry that on, I’ve worked with some POS (Point of Sale) systems in restaurants that referenced each portion of a split check as a ’split’ (noun) and not just as a verb. (the act of dividing it) So there is some industry usage of each resulting portion being ‘a split’. (and probably why it never confused me as I was already familiar with that usage) Of course, that too may have been an incorrect usage, and perhaps there is something more descriptive in formal accounting. Regards, Adrien > On Mar 18, 2019, at 1:23 PM, Robert Heller wrote: > > At Mon, 18 Mar 2019 18:54:30 +0100 Geert Janssens > wrote: > >> >> Hi Hendry, >> >> The term split has been in use in GnuCash long before I joined the project. >> As >> I'm not an accountant, I don't know which would be the proper formal >> accounting term to use in this context. And additionally it may be very hard >> to change the use of this term throughout the project (though if there >> really >> is a more correct term it may be worth gradually promoting it). >> >> Regards, >> >> Geert >> >> Op maandag 18 maart 2019 18:19:00 CET schreef Michael Hendry: On 18 Mar 2019, at 16:36, Patrick wrote: That makes sense. Thank you for the very helpful response and the example. Regards, Patrick >>> >>> Am I alone in finding the use of the word “split” in this context to be >>> confusing? >>> >>> In ordinary everyday English, splitting an object involves its being >>> separated into two or more fragments. >>> >>> When I split a log in two with an axe, the result is ONE split (the plane in >>> which the log separates) and TWO smaller logs. If I keep on going, the >>> outcome of N splits is (N - 1) smaller logs. > > When you split a log, you end up two (or more) log sections (generally like > pie slices). One can say "one split that log". In the case of GnuCash, one > split the overall transation across two (or more) accounts. It is also common > English usage to "split the tab" when a group of friends goes out for dinner, > etc. This comes very close to what is happening in GnuCash. > >>> >>> In the context of double-entry bookkeeping, each transaction involves two >>> entries - one (for example) recording the issue of a cheque from a bank >>> account, and the other logging the same transaction through the appropriate >>> expense account. >>> >>> When several expense accounts are involved in the same payment (e.g. if you >>> buy petrol, milk and a bunch of flowers at a service station) there are >>> actually three double entries. It’s convenient to record the cheque issued >>> to cover all three expenses as one entry, and to allocate an entry for each >>> of the separate expenses to put together as one (quadruple)-entry >>> transaction. >>> >>> So what you get when you split a Gnucash transaction is two or more >>> _entries_ relating to the same financial transaction. >>> >>> No? >>> >>> Michael ___ 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.
Re: [GNC] Example of multi-split feature of CSV importer?
At Mon, 18 Mar 2019 18:54:30 +0100 Geert Janssens wrote: > > Hi Hendry, > > The term split has been in use in GnuCash long before I joined the project. > As > I'm not an accountant, I don't know which would be the proper formal > accounting term to use in this context. And additionally it may be very hard > to change the use of this term throughout the project (though if there really > is a more correct term it may be worth gradually promoting it). > > Regards, > > Geert > > Op maandag 18 maart 2019 18:19:00 CET schreef Michael Hendry: > > > On 18 Mar 2019, at 16:36, Patrick wrote: > > > > > > That makes sense. Thank you for the very helpful response and the example. > > > > > > Regards, > > > Patrick > > > > Am I alone in finding the use of the word âsplitâ in this context to be > > confusing? > > > > In ordinary everyday English, splitting an object involves its being > > separated into two or more fragments. > > > > When I split a log in two with an axe, the result is ONE split (the plane in > > which the log separates) and TWO smaller logs. If I keep on going, the > > outcome of N splits is (N - 1) smaller logs. When you split a log, you end up two (or more) log sections (generally like pie slices). One can say "one split that log". In the case of GnuCash, one split the overall transation across two (or more) accounts. It is also common English usage to "split the tab" when a group of friends goes out for dinner, etc. This comes very close to what is happening in GnuCash. > > > > In the context of double-entry bookkeeping, each transaction involves two > > entries - one (for example) recording the issue of a cheque from a bank > > account, and the other logging the same transaction through the appropriate > > expense account. > > > > When several expense accounts are involved in the same payment (e.g. if you > > buy petrol, milk and a bunch of flowers at a service station) there are > > actually three double entries. Itâs convenient to record the cheque issued > > to cover all three expenses as one entry, and to allocate an entry for each > > of the separate expenses to put together as one (quadruple)-entry > > transaction. > > > > So what you get when you split a Gnucash transaction is two or more > > _entries_ relating to the same financial transaction. > > > > No? > > > > Michael > > > > > ___ > 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. > > > -- Robert Heller -- 978-544-6933 Deepwoods Software-- Custom Software Services http://www.deepsoft.com/ -- Linux Administration Services hel...@deepsoft.com -- Webhosting Services ___ 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.
Re: [GNC] Example of multi-split feature of CSV importer?
Hi Hendry, The term split has been in use in GnuCash long before I joined the project. As I'm not an accountant, I don't know which would be the proper formal accounting term to use in this context. And additionally it may be very hard to change the use of this term throughout the project (though if there really is a more correct term it may be worth gradually promoting it). Regards, Geert Op maandag 18 maart 2019 18:19:00 CET schreef Michael Hendry: > > On 18 Mar 2019, at 16:36, Patrick wrote: > > > > That makes sense. Thank you for the very helpful response and the example. > > > > Regards, > > Patrick > > Am I alone in finding the use of the word “split” in this context to be > confusing? > > In ordinary everyday English, splitting an object involves its being > separated into two or more fragments. > > When I split a log in two with an axe, the result is ONE split (the plane in > which the log separates) and TWO smaller logs. If I keep on going, the > outcome of N splits is (N - 1) smaller logs. > > In the context of double-entry bookkeeping, each transaction involves two > entries - one (for example) recording the issue of a cheque from a bank > account, and the other logging the same transaction through the appropriate > expense account. > > When several expense accounts are involved in the same payment (e.g. if you > buy petrol, milk and a bunch of flowers at a service station) there are > actually three double entries. It’s convenient to record the cheque issued > to cover all three expenses as one entry, and to allocate an entry for each > of the separate expenses to put together as one (quadruple)-entry > transaction. > > So what you get when you split a Gnucash transaction is two or more > _entries_ relating to the same financial transaction. > > No? > > Michael ___ 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.
Re: [GNC] Example of multi-split feature of CSV importer?
GunCash’s use of the term “split” is quite specific, and defined in the Glossary of the Guide, as well as Chapter 4.1 Basics. Basic Concepts. David > On Mar 18, 2019, at 10:49 PM, Michael Hendry wrote: > >> On 18 Mar 2019, at 16:36, Patrick wrote: >> >> That makes sense. Thank you for the very helpful response and the example. >> >> Regards, >> Patrick > > Am I alone in finding the use of the word “split” in this context to be > confusing? > > In ordinary everyday English, splitting an object involves its being > separated into two or more fragments. > > When I split a log in two with an axe, the result is ONE split (the plane in > which the log separates) and TWO smaller logs. If I keep on going, the > outcome of N splits is (N - 1) smaller logs. > > In the context of double-entry bookkeeping, each transaction involves two > entries - one (for example) recording the issue of a cheque from a bank > account, and the other logging the same transaction through the appropriate > expense account. > > When several expense accounts are involved in the same payment (e.g. if you > buy petrol, milk and a bunch of flowers at a service station) there are > actually three double entries. It’s convenient to record the cheque issued to > cover all three expenses as one entry, and to allocate an entry for each of > the separate expenses to put together as one (quadruple)-entry transaction. > > So what you get when you split a Gnucash transaction is two or more _entries_ > relating to the same financial transaction. > > No? > > Michael > ___ > 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.
Re: [GNC] Example of multi-split feature of CSV importer?
> On 18 Mar 2019, at 16:36, Patrick wrote: > > That makes sense. Thank you for the very helpful response and the example. > > Regards, > Patrick Am I alone in finding the use of the word “split” in this context to be confusing? In ordinary everyday English, splitting an object involves its being separated into two or more fragments. When I split a log in two with an axe, the result is ONE split (the plane in which the log separates) and TWO smaller logs. If I keep on going, the outcome of N splits is (N - 1) smaller logs. In the context of double-entry bookkeeping, each transaction involves two entries - one (for example) recording the issue of a cheque from a bank account, and the other logging the same transaction through the appropriate expense account. When several expense accounts are involved in the same payment (e.g. if you buy petrol, milk and a bunch of flowers at a service station) there are actually three double entries. It’s convenient to record the cheque issued to cover all three expenses as one entry, and to allocate an entry for each of the separate expenses to put together as one (quadruple)-entry transaction. So what you get when you split a Gnucash transaction is two or more _entries_ relating to the same financial transaction. No? Michael ___ 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.
Re: [GNC] Example of multi-split feature of CSV importer?
That makes sense. Thank you for the very helpful response and the example. Regards, Patrick On Mon, Mar 18, 2019 at 5:45 AM Geert Janssens wrote: > Op zondag 17 maart 2019 00:55:38 CET schreef Patrick: > > > I would like to import split transacations from a CSV file. Based on the > > > help balloon for it, the "multi-split" option seems to be the way to do > > > this, but I am not sure how to use this option. Is there an example > > > somewhere of how to use this option? > > > > > > To be specific, what I don't understand is that when the multi-split > option > > > is disabled, I can set one column in the CSV to be the "Account", and > > > another column to be the "Transfer Account". Setting these two columns > > > allows me to specify the "credit" and "debit" accounts involved in the > > > transaction. However, when I enable the multi-split option, the option to > > > set a "Transfer Account" goes away. So, I am not sure how to specify the > > > second of the two accounts involved with the transaction when multi-split > > > is enabled. > > > > First off, strictly speaking each transaction is "multi-split" as even the > simplest transaction (a transfer from one account to another) has two > splits: one in the source account and one in the target account. The split > itself doesn't know about the transfer. It only knows which account it > belongs to. > > > > As a real example is always more helpful, let's assume a transaction that > transfers $100 from Account A to Account B. This would be represented with > two splits: > > > > Transaction date 2019-03-18 > > Transaction description "Transfer" > > Split 1: Account A $100 (Withdrawal) > > Split 2: Account B $100 (Deposit) > > > > Converting this in a multi-split csv file that can be imported would yield > something like this: > > Date,Description,Account,Deposit,Withdrawal > > 2019-03-18,Transfer,Account A,,100 > > 2019-03-18,Transfer,Account B,100, > > > > As you can see there is no need for a "Transfer Account" column in this > case. Each split is associated with one account, you only have to define > that account. GnuCash will use the transaction related fields (in this case > only "Date" and "Description") to detect transaction boundaries. As both > fields are identical on each line, GnuCash will assume both splits to be > part of the same transaction. > > > > The single-line import format is a shorthand that can only be used in case > of transactions with at most two splits. For that situation each line > represents such a full transaction and hence may hold information to define > two splits. For that reason it also provides two Account assignments > options (Account and Transfer Account) as each split in that transaction > can have one. So the above translated into a single line csv file would > look like this: > > > > Date,Description,Account,Transfer Account,Deposit > > 2019-03-18,Transfer,Account B,Account A,100 > > > > You could say the single line import format is a special case to simplify > most imports from bank accounts while the multi-split format is more > generic and the only format that will ever be able to import multi-split > (that is more than two splits) transactions (1). > > > > Regards, > > > > Geert > > > > (1) Note there are currently issues with the csv importer for > multi-currency imports or stock imports. These will eventually be resolved > allowing the multi-split format to import every kind of transaction gnucash > supports internally. > ___ 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.
Re: [GNC] Example of multi-split feature of CSV importer?
Op zondag 17 maart 2019 00:55:38 CET schreef Patrick: > I would like to import split transacations from a CSV file. Based on the > help balloon for it, the "multi-split" option seems to be the way to do > this, but I am not sure how to use this option. Is there an example > somewhere of how to use this option? > > To be specific, what I don't understand is that when the multi-split option > is disabled, I can set one column in the CSV to be the "Account", and > another column to be the "Transfer Account". Setting these two columns > allows me to specify the "credit" and "debit" accounts involved in the > transaction. However, when I enable the multi-split option, the option to > set a "Transfer Account" goes away. So, I am not sure how to specify the > second of the two accounts involved with the transaction when multi-split > is enabled. First off, strictly speaking each transaction is "multi-split" as even the simplest transaction (a transfer from one account to another) has two splits: one in the source account and one in the target account. The split itself doesn't know about the transfer. It only knows which account it belongs to. As a real example is always more helpful, let's assume a transaction that transfers $100 from Account A to Account B. This would be represented with two splits: Transaction date 2019-03-18 Transaction description "Transfer" Split 1: Account A$100 (Withdrawal) Split 2: Account B $100 (Deposit) Converting this in a multi-split csv file that can be imported would yield something like this: Date,Description,Account,Deposit,Withdrawal 2019-03-18,Transfer,Account A,,100 2019-03-18,Transfer,Account B,100, As you can see there is no need for a "Transfer Account" column in this case. Each split is associated with one account, you only have to define that account. GnuCash will use the transaction related fields (in this case only "Date" and "Description") to detect transaction boundaries. As both fields are identical on each line, GnuCash will assume both splits to be part of the same transaction. The single-line import format is a shorthand that can only be used in case of transactions with at most two splits. For that situation each line represents such a full transaction and hence may hold information to define two splits. For that reason it also provides two Account assignments options (Account and Transfer Account) as each split in that transaction can have one. So the above translated into a single line csv file would look like this: Date,Description,Account,Transfer Account,Deposit 2019-03-18,Transfer,Account B,Account A,100 You could say the single line import format is a special case to simplify most imports from bank accounts while the multi-split format is more generic and the only format that will ever be able to import multi-split (that is more than two splits) transactions (1). Regards, Geert (1) Note there are currently issues with the csv importer for multi-currency imports or stock imports. These will eventually be resolved allowing the multi-split format to import every kind of transaction gnucash supports internally. ___ 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.
Re: [GNC] CSV Import
Op donderdag 14 maart 2019 17:22:48 CET schreef Stephen M. Butler: > For some reason my Citi Visa account has lost the ability to export file > in non-CSV formats. So, running the CSV importer on the file that had > fields: > > Status, Date, Description, Debit, Credit, MemberName > > I mapped Date --> Date, Description --> Description, Debit --> > Deposit, Credit --> Withdrawl > > Noticed that there were three rows with amounts in the Credit column and > all said values where negative! > > Ran the importer and saw that those three rows were treated as charges. > What should I have done? Especially since Citi put negative values in > the Credit column. > > Could I map both columns as Deposit? Counter-intuitive but so is Citi > Cards right now! > > --Steve Unfortunately you can't map both columns to Deposit. We may have to improve this (as well as disambiguating the names). I couldn't find an enhancement request for this yet in bugzilla. Feel free to add one so this issue won't get lost. As a workaround you can preprocess your csv files to * either merge the Debit and Credit columns (so you have one column with both positive and negative numbers and you map this column to "Deposit") * or make the numbers in the Credit column positive (so you have two columns with all positive numbers and then map Debit to Deposit and Credit to Withdrawal) Geert ___ 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.
