Fw: Credit card import (QIF) seems to be reversed
mylists23902 at outlook.com
Mon Oct 3 17:55:35 EDT 2016
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
PPAYMENT RECEIVED - THAN
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
PCARD PAYMENT - THANK YOU
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'?
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
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.
On Sun, Oct 2, 2016 at 4:37 PM, Paul Mckenna <mylists23902 at outlook.com<mailto:mylists23902 at outlook.com>> wrote:
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?
gnucash-user mailing list
gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
More information about the gnucash-user