[GNC] Unable to import CSV with charges and payments

R C myplaybsemail at gmail.com
Sun Oct 30 11:06:35 EDT 2022


I figured it out.  On the import wizard, I had to make both the credit and
deposit a withdrawal.

On Fri, Oct 28, 2022 at 7:18 PM David Carlson <david.carlson.417 at gmail.com>
wrote:

> I have found that some financial institutions do not structure their CSV
> files with opposite positive or negative values for charges vs payments.
> Then it becomes a challenge for GnuCash to make the differentiation for
> us.  It might be necessary to pre process your file by changing the sign
> for one of the types manually before importing it.  I am "lucky" that the
> one such company that I import from also exports in QRM, oops, I mean QFX
> format, but it reverses the sign for both charges and payments in that
> format.  Oh, well.
>
> On Fri, Oct 28, 2022 at 5:42 PM R C <myplaybsemail at gmail.com> wrote:
>
>> How do I import a csv with both charges and payments.  When I try, it only
>> imports one type and puts everything in there.
>>
>> --
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> The problem isn't how much you make, it's how much you spend.
>> "I have not failed. I've just found 10,000 ways that won't work." - Thomas
>> Edison
>> _______________________________________________
>> 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
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
> --
> David Carlson
>


-- 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The problem isn't how much you make, it's how much you spend.
"I have not failed. I've just found 10,000 ways that won't work." - Thomas
Edison


More information about the gnucash-user mailing list