Fw: Credit card import (QIF) seems to be reversed

[David Carlson]

I missed seeing the other sample on my cellphone, but you identified your
problem.  Perhaps there are other users familiar with that credit card and
whether there is another work-around or way to motivate them to fix their
downloads.  If they claim to work with Quicken you might ask them if other
customers using Quicken have reported problems.

I don't think GnuCash allows reversing signs during import.  It expects the
file to be correct or it would not work with any other financial program
either.

David C

On Oct 4, 2016 1:34 AM, "Paul Mckenna" <mylists23902 at outlook.com> wrote:

> Thanks David,
>
>
> I checked the type I have set the Halifax account to and it is a Credit
> card, the reason I posted a sample of the two qif files was because the
> Halifax one shows purchases as positive and payments towards the card as
> negative, whereas the AMEX is the other way round.
>
>
> Do you know if there is an option when importing somewhere to say "reverse
> transactions' or something like that?
>
>
> The Halifax does let me export the transactions as a CSV file as well but
> unless I'm wrong, I think gnucash remembers the import options from qif
> files whereas with a CSV file I seem to have to classify what each payment
> was for every time.
>
>
> I can probably create a script that replaces all T1,T2,etc with
> T-1,T-2,etc and similar for the payments but I wanted to check I wasn't
> missing a checkbox somewhere.
>
>
> Thanks
>
>
>
>
>
> ------------------------------
> *From:* David Carlson <david.carlson.417 at gmail.com>
> *Sent:* 04 October 2016 05:24
> *To:* Paul Mckenna
> *Cc:* gnucash-user at gnucash.org
> *Subject:* Re: Fw: Credit card import (QIF) seems to be reversed
>
> Paul,
>
> Since you say that your AMEX account imports correctly, open up the
> register of your new Halifax file and type <Ctrl>E.
>
> verify that the account type is Credit Card and that it is under the
> Liability top level account.  It should probably be right next to the AMEX
> account.
>
> You can also look in your chart of accounts to see the same information.
>
> David C
>
>
> On Mon, Oct 3, 2016 at 4:55 PM, Paul Mckenna <mylists23902 at outlook.com>
> wrote:
>
>> Hi David,
>>
>>
>> Thanks for your email, I've check the qif file and it does have the liability
>> type indicated, so for my Halifax account (The one I'm having problems
>> with) it starts
>>
>>
>> !Type:CCard
>> D27/09/2016
>> Parking Charge
>> T12.46
>> ^
>>
>> D26/09/2016
>> PPAYMENT RECEIVED - THAN
>> T-100.00
>> ^
>>
>> Which is me paying for some parking and then paying £100 towards the
>> credit card, however with another credit card (AMEX) the qif file looks
>> like this
>>
>>
>> !Type:CCard
>> D03/07/2016
>> T-£2.37
>> PITUNES.COM/BILL
>> AITUNES.COM
>> More Text
>> Another Reference
>> N##################
>> ^
>> D27/07/2016
>> T£27.97
>> PCARD PAYMENT - THANK YOU
>> A
>> A
>> A
>> N##################
>> ^
>>
>> Again this is me paying for something on the credit card and then paying
>> off £27.97, The AMEX qif file imports OK and how I would expect but the
>> Halifax one messes me up. Is it that they are formatting it wrong?
>>
>> I am able to export the transactions as a CSV file but then when I do an
>> import I have to choose what field the 'amount' is should it be 'deposit'
>> or 'withdrawal'?
>>
>> Thanks again
>> Paul
>> ------------------------------
>> *From:* David Carlson <david.carlson.417 at gmail.com>
>> *Sent:* 03 October 2016 19:28
>> *To:* Paul Mckenna
>> *Cc:* gnucash-user at gnucash.org
>> *Subject:* Re: Fw: Credit card import (QIF) seems to be reversed
>>
>> Paul,
>>
>> I had to look at some old history to find a copy of a QIF import file in
>> my data.  First, the QIF should  have a liability type indicated at the
>> beginning of the file then payment transactions should have positive values
>> and charges should have negative values.  If your file from your credit
>> card does not match that, then your financial institution is at fault. If
>> they offer OFX or "Quicken" formats, try those.
>>
>> If your new credit card account in your GnuCash data is not one of the
>> liability types, then that is the problem.
>>
>> Any other problem would require more detailed information to diagnose.
>>
>> Believe it or not, recently some financial institutions are screwing up
>> their download file structures. One of my credit cards is reversing my
>> payments so they appear as charges in the OFX files.  Strangely, their QIF
>> files and CSV files are correct.  Of course, their customer support denies
>> that there is any problem.
>>
>> Good Luck.
>>
>> David C
>>
>> On Sun, Oct 2, 2016 at 4:37 PM, Paul Mckenna <mylists23902 at outlook.com>
>> wrote:
>>
>>> Hi all,
>>>
>>> I'm having a problem importing a qif file from my Credit card people
>>> (Halifax), when I import it payments go to charges and vice-versa.
>>>
>>> I've checked the qif file and charges (for example when I but something)
>>> are in positive and when I make a payment to the card it shows as negative.
>>>
>>> Is this correct or am I missing something
>>>
>>>
>>> I used gnucash a long time ago and everything worked as it should but
>>> that was with another credit card company, what is the best way for me to
>>> do an import and have the values switched?
>>>
>>>
>>> Thanks
>>>
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> 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.
>>>
>>
>>
>