[GNC] importing csv and negative numbers

[Stan Brown]

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