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

[Paul Mckenna]

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<mailto: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<http://PITUNES.COM/BILL>
AITUNES.COM<http://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<mailto:david.carlson.417 at gmail.com>>
Sent: 03 October 2016 19:28
To: Paul Mckenna
Cc: gnucash-user at gnucash.org<mailto: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<mailto: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<mailto: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.