Credit Card QIF file importing from MBNA or Halifax

Tabansi's Avatar


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)


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

    jeff_l's Avatar

    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

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

    dtd's Avatar

    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.

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

    dwg's Avatar

    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.

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

    Tabansi's Avatar

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



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

    Tabansi's Avatar

    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.


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

    Tabansi's Avatar

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


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

    dwg's Avatar

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

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

    dwg's Avatar

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

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

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

    Tabansi's Avatar

    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.

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

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac