On 2022-06-12 22:00, Kevin T via gnucash-user wrote: > It seems that when importing CSV files, to a CC account, if the > 'credit' column, which when imported is called the 'deposit' field, > has a negative value in it, it is imported as a 'debit' transaction. > I have to refer to the statement, to find which of these transactions > are supposed to be credits. IE i can't trust the import.> is there any way > to work around this behavior.
Can you clarify please? Do you mean that (a) a credit column in CSV contains minus $100.00, the import shows POSITIVE $100.00 in the debit column and nothing in credit, or (a) a credit column in CSV contains minus $100.00, the import shows NEGATIVE $100.00 in the debit column and nothing in credit, or (c) something else? If it's (a), that's correct and consistent behavior. GC won't let you manually enter a transaction with a negative number in credit or debit; it changes that to a positive number in debit or credit respectively. After all, a credit of minus $100 is equivalent to a debit of plus $100. If this is what is happening, you _can_ trust the import. And while I myself have had instances where I wanted to record something as a negative credit rather than a positive debit, as far as I know there's no way to do that. And after all, the two _are_ equivalent so it's purely a matter of presentation and not of incorrect numbers. If you mean (b), something seems off. I'll let others, who are more familiar with the details of importing, ask you questions. (One thing you could and should always do, when reporting a possible problem, is state which version number of GC you're using, which operating system, and whether you're using a prebuilt version or you compiled it yourself.) If you mean (c), please explain all that is in the CSV file for this transaction, and all that is in the transaction after import. Screen shots might help; be sure to attach them, as opposed to including them inline in HTML. -- Stan Brown Tehachapi, CA, USA https://BrownMath.com _______________________________________________ gnucash-user mailing list [email protected] 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.
