Ethan on 07 Mar, 2019 08:53 PM
That does indeed sound like a problem on their end if it just changed. If you'd like to be sure, you could attach a QIF file here are we could take a closer look at it. Keep in mind these are public forums, so you should make sure it doesn't have any personal data. If you'd prefer, you can also open up another private thread that only our support staff can see.
The three files above show the 'problem' when importing to MoneyDance
The two files below show what I think is correct behaviour on import to Moneydance
4. TescoBank report .csv
5. TescoBank report .qif
I'm no expert, and I'm tying myself in knots, trying to figure it all out. What I think I am seeing now is that the 'sign-conventions' in all the files are the same ??? If so my interpretation would be that something in the MBNA formatting has changed and MoneyDance is misinterpreting the 'sign' of the amount.
There is nothing in any of the files that is 'sensitive'.
I am so stressed by this problem that I am beginning to doubt my sanity. How could the MBNA tech people get it so wrong, and no other MBNA customers raise the question (It's been live at least 3 weeks)? Very grateful for any help, or reports here from other MBNA / MoneyDance users.
on 17 Mar, 2019 09:10 AM
Hi. I have only been using Moneydance for a few months and till the March statement I have been able to download my statements from the MBNA website to Moneydance with no problem. However, I cannot find any way to do the download. From the above, it seems that others have achieved the download, then found problems with the format. Please explain how to get an accessible file out of the MBNA statement, then I'll have a look at the other problem. Many thanks
Just a quick reply in case you’ve missed the obvious.
When you are displaying Transactions, there should be a clickable button (green on my screen) at bottom left, labelled “Export”. I know I missed it for a stupidly long time.
Let me know how you get on, and if I need to look at this harder.
If you’ve downloaded transactions before, check for yourself if the debits and credits are still reversed. If not, you may be able to help me! If they are, it would move things along if you complained via the online banking telephone helpline 0345 607 2271.
They gave me a tech issues reference number INC0564307 which may save you some time explaining the issue to some first-line handler.
Keep me informed, please.
If it’s not one damned thing after another, it’s the same damned thing again and again and again.
on 17 Mar, 2019 03:31 PM
Many thanks for your help. I found the Export button below my March
statement, which offered CSV or QIF files. I chose QIF - but where did
it export it to? How do I find the file? and how do I get in into
Moneydance? - it was simple and almost automatic before they changed
When I get that far, I'll certainly take up the other problem with MBNA
if I also find credits and debits swapped.
Ethan on 17 Mar, 2019 03:49 PM
That depends on the settings of your web browser. When clicking on a download link, the browser will either ask you where to save it, save it to your default save location without asking (perhaps your Downloads folder?), or try to automatically open the file in an assigned program. If you're not seeing any action after downloading, my guess is that it's being saved to whatever you have set as your default download location. Do you see the QIF file there? If so, you can go to File -> Import from the Moneydance menu bar and select that file.
If you're still not sure where the download is going, please let us know which web browser and operating system you are using.
I was able to import the MBNA_5407581341152517_20190307_2248.csv file using Moneydance's built-in importer. (see David_MBNA_Register.jpg)
To do so, from the Moneydance menu bar, go to File > Import.
A file browser will open allowing you to navigate to the MBNA...csv file.
Clicking on the csv file will invoke the importer.
You can likely accept the defaults on the first screen of the importer but check them over anyway and make sure that the proper account is selected to receive the import.
On the second screen of the importer, set the field selectors per my screenshot. (see David_MBNA_Importer.jpg)
I was able to track down the official word on QIF file formats. If you use Wikipedia to search for "Quicken Interchange Format" you'll see a comprehensive definition of the formats expected. Section 2.2 Detail Items lists various code letters, the meaning of the entries with that code letter, and a specification of allowable formats.
Code letter T; Description Amount of the item.
For payments a leading minus is required.
For deposits either no sign or a plus sign is accepted.
I have passed this discovery to the various deniers within the technical support teams at MBNA and I await their response.
Thank you flying.boy ..My MBNA transactions are reversed when the qif file is directly imported into Microsoft Money from MBNA, My solution was...I saved and edited the qif file in Notepad++ simply by adding a - between T and the transaction amount I saved the new file and imported into Microsoft Money all is ok for now until MBNA decide they have a problem and sort it out