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

[David Carlson]

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.
>>
>
>