Home → Problems →

Credit Card QIF file importing from MBNA or Halifax

• Edit

Tabansi

10 May, 2023 06:44 PM

Hi There,
I have seen various other discussions regarding this in relation to Lloyds credit card importing but I have always had this problem importing QIF files from both MBNA and Halifax, where the import is successful it shows all the transactions as a payment (deposit) rather than a charge on the accounts.

For a number of years I always just manually go into each transaction and have to change them afterwards but when you have around 6 months worth it is wafully painful. Is there any solution to this please.

I currently have Moneydance Version 2023.1 (5006)

Thanks

1. 1 Posted by jeff_l on 10 May, 2023 07:53 PM

   

   I don’t have an MBNA a/c but I do have a Halifax CC.

   The first thing I would suggest is to download the CSV file from Halifax. So, either use the MD built in importer via File/Import, when it comes to the 2nd screen under Amount, select Debit amount.

   Or you can use the MD Extension CSV importer to achieve similar results. I have included two screen grabs to illustrate the settings I use that you may find helpful.

   Fellow user

   • Screenshot_2023-05-10_at_20.50.03.png 99.6 KB
   • Screenshot_2023-05-10_at_20.38.15.png 191 KB
   • Edit

2. 2 Posted by dtd on 10 May, 2023 10:25 PM

   

   just a user - I also think there is a setting in Moneydance to ignore an issue and import the exact amount... can't remember quite what it is, but something like

   Moneydance/Settings/Network/Ignore Transaction Types in Favor of Amount Signs

   If that is unchecked, maybe test (make a backup first) that by clicking the check box - and import a QIF file?

   (I am not sure if that's the right one to try, but it sounds good....)

   Someone else will probably chime in if I am right or wrong about this.

   • Edit

3. 3 Posted by dwg on 10 May, 2023 11:38 PM

   

   The ignore transaction types option is for OFX/QFX files. QIF tiles do not have transaction types, they are driven by the amount signs to determine payments or deposits.

   Are you sure you are downloading QIF files?

   Open up the QIF file in a text editor and see what the transactions looks like.

   We do see institutions screw up QIF files from time to time.

   • Edit

4. 4 Posted by Tabansi on 12 May, 2023 05:13 PM

   

   Hi dwg,
   I have opened up a QIF file in Wordpad and one of the transactions looks like this:

   D04/05/2023
   PDELIVEROO
   T29.23
   ^

   Regards

   • Edit

5. 5 Posted by Tabansi on 12 May, 2023 05:15 PM

   

   Thanks Jeff_I,
   I do use .CSV for Paypal imports but for every other account (including the credit card accounts) I have been using QIF files forever, it just seems to be the credit card ones that display a charge as a payment.

   Regards

   • Edit

6. 6 Posted by Tabansi on 12 May, 2023 05:18 PM

   

   Thanks DTD,
   I did try that setting (both checked and unchecked) in File>Preferences>Network, but unfortanately this made no difference.

   Regards

   • Edit

7. 7 Posted by dwg on 12 May, 2023 10:20 PM

   

   The QIF transaction looks looks wrong it should be a debit not a credit.

   • Edit

8. 8 Posted by dwg on 12 May, 2023 11:39 PM

   

   A user faced with this same issue developed a QIF loader that would handle reversed transaction signs:

   https://bitbucket.org/mikerb/moneydance-2019/wiki/QIF%20Loader

   I've used many of Mike's extensions and they work well, he is also the author of the Quote Loader extension.

   • Edit

9. 9 Posted by Tabansi on 14 May, 2023 08:46 AM

   

   Hi dwg,
   I tried this extension and if worked perfectly for me, I just selected the .QIF file and loaded it, highlighted all the loaded transactions and clicked "Switch Values" which converted them to payments, then clicked on "Save Transactions" which saved them into Moneydance correctly as payments.

   Perfect, thanks for your assistance.

   • Edit

10. System closed this discussion on 13 Aug, 2023 08:50 AM.