tag:infinitekind.tenderapp.com,2009-01-14:/discussions/online-banking/12514-mbna-card-transactions-reversed-after-site-changeInfinite Kind: Discussion 2019-12-11T08:10:23Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-07T20:53:15Z2019-03-07T20:53:15ZMBNA Card transactions reversed after site change<div><p>Hi David,</p>
<p>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.</p>
<p>Ethan<br>
Infinite Kind Support</p></div>Ethantag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-07T23:11:41Z2019-03-07T23:11:41ZMBNA Card transactions reversed after site change<div><p>Thanks Ethan. I'm attaching 5 files</p>
<ol>
<li>MBNA -2517.csv<br></li>
<li>MBNA -2517.qif</li>
</ol>
<p>3 MBNA -0925.qif</p>
<p>The three files above show the 'problem' when importing to MoneyDance</p>
<p>The two files below show what I think is correct behaviour on import to Moneydance</p>
<ol>
<li>TescoBank report .csv<br></li>
<li>TescoBank report .qif</li>
</ol>
<p>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.</p>
<p>There is nothing in any of the files that is 'sensitive'.</p>
<p>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.</p>
<p>David</p></div>flying.boytag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-08T00:16:02Z2019-03-08T00:16:02ZMBNA Card transactions reversed after site change<div><p>I'm a fellow user.</p>
<p>I'm assuming that MBNA is a credit card, based on this assumption In my opinion the MBNA QIF files are wrong.</p>
<p>Purchases, interest charged should be a negative amount</p>
<p>Payments should be a positive amount.</p>
<p>Consider the following extract from one of my credit card downloads, this I consider correct:</p>
<p>!Type:CCard D18/02/19<br>
T-69.95<br>
POPTUS BILLING AUTOPAY MACQUARIE PAR<br>
M4557021153624908<br>
^ D14/02/19<br>
T-164.80<br>
PMEDIBANK PHI DEBIT MELBOURNE<br>
M4557021153624908<br>
^ D07/02/19<br>
T264.75<br>
PDIRECT DEBIT PAYMENT<br>
M4557021153624908<br>
^ D23/01/19<br>
T-30.00<br>
P+ANNUAL FEE<br>
M4557021153624908<br>
^</p>
<p>Purchases and charges are negative and payments are positive.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-08T11:06:22Z2019-03-08T11:06:22ZMBNA Card transactions reversed after site change<div><p>Thanks dwg. Everything I find out convinces me that MBNA are in the wrong. I use another accounting package too, Xero, and I see the same problem with MBNA imports there.</p>
<p>I'm convinced there is no issue with MoneyDance itself, but it is helpful to know that other people are seeing the same thing with MBNA.</p></div>flying.boytag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T09:10:12Z2019-03-17T09:10:13ZMBNA Card transactions reversed after site change<div><p>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</p></div>Gerald Pontingtag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T09:20:57Z2019-03-17T09:20:57ZMBNA Card transactions reversed after site change<div><p>Hi Gerald</p>
<p>Just a quick reply in case you’ve missed the obvious.</p>
<p>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.</p>
<p>Let me know how you get on, and if I need to look at this harder.</p>
<p>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.</p>
<p>They gave me a tech issues reference number INC0564307 which may save you some time explaining the issue to some first-line handler.</p>
<p>Keep me informed, please.<br>
David</p>
<p>— If it’s not one damned thing after another, it’s the same damned thing again and again and again.</p></div>flying.boytag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T15:31:26Z2019-03-17T15:31:26ZMBNA Card transactions reversed after site change<div><p>Hi David</p>
<p>Many thanks for your help. I found the Export button below my March<br>
statement, which offered CSV or QIF files. I chose QIF - but where did<br>
it export it to? How do I find the file? and how do I get in into<br>
Moneydance? - it was simple and almost automatic before they changed<br>
things.</p>
<p>When I get that far, I'll certainly take up the other problem with MBNA<br>
if I also find credits and debits swapped.</p>
<p>Best wishes</p>
<p>Gerald</p></div>Gerald Pontingtag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T15:49:13Z2019-03-17T15:49:13ZMBNA Card transactions reversed after site change<div><p>Hi Gerald,</p>
<p>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.</p>
<p>If you're still not sure where the download is going, please let us know which web browser and operating system you are using.</p>
<p>Ethan<br>
Infinite Kind Support</p></div>Ethantag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T16:28:36Z2019-03-17T16:28:36ZMBNA Card transactions reversed after site change<div><p>Hi David,</p>
<p>I was able to import the MBNA_5407581341152517_20190307_2248.csv file using Moneydance's built-in importer. (see David_MBNA_Register.jpg)</p>
<p>To do so, from the Moneydance menu bar, go to File > Import.<br>
A file browser will open allowing you to navigate to the MBNA...csv file.<br>
Clicking on the csv file will invoke the importer.<br>
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.<br>
On the second screen of the importer, set the field selectors per my screenshot. (see David_MBNA_Importer.jpg)</p>
<p>HTH -Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T16:31:29Z2019-03-17T16:31:30ZMBNA Card transactions reversed after site change<div><p>Hi</p>
<p>No QIF file in Download folder.</p>
<p>My operating system is Windows 10 and my browser is Firefox.</p>
<p>I have succeeded in opening the csv version in excel - can I get it from<br>
Excel to Moneydance ? (I'd hoped Excel would have a 'save as qif'<br>
finctions.)</p>
<p>Many thanks for your help. ( Not sure if I will get back to this today)</p>
<p>Gerald</p></div>Gerald Pontingtag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T16:35:27Z2019-03-17T16:35:27ZMBNA Card transactions reversed after site change<div><p>Thank you Kevin</p>
<p>Your post does not directly address my main issue, but is helpful nonetheless as another forum member was having trouble navigating his folders.</p>
<p>Your experience seems to be that the polarity is correct. I will investigate whether the site has been corrected, or whether there is a different issue.</p>
<p>I’ll get back to you.</p>
<p>David<br>
— If you must choose between two evils, pick the one you’ve never tried before.</p></div>flying.boytag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T16:40:08Z2019-03-17T16:40:08ZMBNA Card transactions reversed after site change<div><p>HI David,</p>
<blockquote>
<p>Your experience seems to be that the polarity is correct.</p>
</blockquote>
<p>On the contrary, I think that the signage of the transactions is opposite of what they should be but I set the field selector of the importer to compensate for the erroneous construction of the file.</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T16:43:18Z2019-03-17T16:43:18ZMBNA Card transactions reversed after site change<div><p>Hi Gerard,</p>
<p>Look to my previous post for instructions on how to import the current version of the MBNA csv file into Moneydance.<br>
<a href="http://help.infinitekind.com/discussions/online-banking/12514-mbna-card-transactions-reversed-after-site-change#comment_47081862">http://help.infinitekind.com/discussions/online-banking/12514-mbna-...</a></p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T16:45:09Z2019-03-17T16:45:09ZMBNA Card transactions reversed after site change<div><p>Sorry Kevin, your post has confused me.</p>
<p>I THINK you’re saying that I am right in believing the MBNA website is faulty. And that your .jpg file shows the polarity AFTER you has massaged it.</p>
<p>If I’ve understood correctly, just HOW did you tweak the text importer??</p>
<p>Thanks</p>
<p>David<br>
— If it’s not one damned thing after another, it’s the same damned thing again and again and again.</p></div>flying.boytag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T16:51:01Z2019-03-17T17:44:30ZMBNA Card transactions reversed after site change<div><p>Hi David,</p>
<p>Yes, I agree, you are correct in your summation that the files are constructed improperly by MBNA.</p>
<blockquote>
<p>...just HOW did you tweak the text importer??</p>
</blockquote>
<p>To compensate for the opposite signage, I changed the field selector from 'Amount' to 'Debit Amount'. Look carefully at the screenshot in my previous post.<br>
<a href="http://help.infinitekind.com/discussions/online-banking/12514-mbna-card-transactions-reversed-after-site-change#comment_47081862">http://help.infinitekind.com/discussions/online-banking/12514-mbna-...</a></p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T17:23:06Z2019-03-17T17:23:06ZMBNA Card transactions reversed after site change<div><p>Hi Kevin</p>
<p>Thanks for that.</p>
<p>1 step forward, 2 steps back …..</p>
<p>I think my text file importer is different from yours. Nowhere am I offered the option to select “Debit Amount”.</p>
<p>The extension I use is called Text Importer and is showing as v.103. In case it is relevant I’m on MoneyDance 2017.8 (1678) using MacOS 10.13.6 (High Sierra).</p>
<p>Have I misunderstood something, or is there an upgrade to Text Importer?</p>
<p>Getting there ….</p>
<p>David</p>
<p>— Tiny Toes Hertford Ltd, 41 Chambers Street, Hertford, SG14 1PL<br>
T: 01992 589020 <a href="http://www.tinytoeshertford.co.uk">www.tinytoeshertford.co.uk</a> <a href="mailto:manager@tinytoeshertford.co.uk">manager@tinytoeshertford.co.uk</a><br>
Registered in England & Wales No: 10876848. Registered office: Wilson Devenish (Accountants), The Maltings, Railway Place, Hertford, SG13 7JT.</p></div>flying.boytag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T17:35:06Z2019-03-17T17:35:06ZMBNA Card transactions reversed after site change<div><p>Hi David,</p>
<p>You are using a slightly older build of MD 2017. The current build is MD 2017.10 (1706)</p>
<p>Provided that you DID NOT purchase Moneydance through the Apple Store, then you can download MD 2017.10 (1706) here:<br>
<a href="http://infinitekind.com/download_2017">http://infinitekind.com/download_2017</a></p>
<p>As for the import, although the interface of Moneydance's built-in importer and the interface of the Text Importer are similar, they are different.</p>
<p>Follow the instructions from my previous post to use the built-in importer. Do not use the Text importer extension.<br>
<a href="http://help.infinitekind.com/discussions/online-banking/12514-mbna-card-transactions-reversed-after-site-change#comment_47081862">http://help.infinitekind.com/discussions/online-banking/12514-mbna-...</a></p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T17:50:53Z2019-03-17T17:50:53ZMBNA Card transactions reversed after site change<div><p>That’s grand advice, Kevin. (Try to imagine an Irish accent!)</p>
<p>I used the built-in importer and all was as you described. I now have a simple work-around while the MBNA fiasco persists.</p>
<p>I’m resisting any major (or minor) upgrades to key software at present, while I’m preparing end-of-year accounts. When things are less time-critical I’ll revisit that.</p>
<p>Thanks again for the massive help, and your patience.</p>
<p>David<br>
—</p></div>flying.boytag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T17:55:28Z2019-03-17T17:55:28ZMBNA Card transactions reversed after site change<div><p>HI David,</p>
<p>Excellent! You're welcome. I'm glad to hear that you were able to get this sorted.</p>
<p>Thank you for reporting back with your results.</p>
<p>Yours is sage advise not to make any drastic changes when important work prevails.</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T19:07:07Z2019-03-17T19:07:08ZMBNA Card transactions reversed after site change<div><p>In response to Kevin - post 9 - I followed your advice exactly re use of the importer ... and the statement did not appear in Moneydance.<br>
Gerald</p></div>Gerald Pontingtag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T19:29:26Z2019-03-17T19:29:26ZMBNA Card transactions reversed after site change<div><p>Hi Gerald,</p>
<p>Can you confirm that you selected the proper account to receive the import? This would be done on the first screen of the built-in importer.</p>
<p>If you still can not get the csv file imported into Moneydance, please attach a sample of the csv file so that I can give it a whirl.</p>
<p>Keep in mind that these are public forums. Make sure that there is no sensitive data in the file before attaching it.</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T20:28:27Z2019-03-17T20:28:27ZMBNA Card transactions reversed after site change<div><p>Hi - I've lost your most recent message - please send again and I will<br>
deal with it tomorrow</p>
<p>Thanks - Gerald</p></div>Gerald Pontingtag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-17T21:02:47Z2019-03-17T21:02:47ZMBNA Card transactions reversed after site change<div><p>Hi Gerald,</p>
<p>You can return to the forum to view any and all messages on this thread.<br>
<a href="http://help.infinitekind.com/discussions/online-banking/12514-mbna-card-transactions-reversed-after-site-change#comment_47082170">http://help.infinitekind.com/discussions/online-banking/12514-mbna-...</a></p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-18T08:51:35Z2019-03-18T08:51:36ZMBNA Card transactions reversed after site change<div><p>Hi</p>
<p>The MBNA site has changed since last night - I just exported a QIF file<br>
into Moneydance with no problem</p>
<p>Gerald</p></div>Gerald Pontingtag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-18T10:27:40Z2019-03-18T10:27:40ZMBNA Card transactions reversed after site change<div><p>That’s odd. I just tried it and the problem is still there,</p>
<p>(I used the .qif option)</p>
<p>I’ll retry now with .csv</p>
<p>…</p>
<p>Yup, the problem is still there with .csv files too.</p>
<p>I wonder if they only applied the fix on new transactions? What was your take on that?</p>
<p>“You couldn’t make it up!” What a fiasco.</p>
<p>David</p>
<p>— Success consists of going from failure to failure without loss of enthusiasm.</p></div>flying.boytag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-18T11:32:54Z2019-03-18T11:32:55ZMBNA Card transactions reversed after site change<div><p>No idea ! There was no offer of 'export to QIF' yesterday.</p>
<p>This morning I was able to export as a QIF file and I was offered 'save'<br>
or 'open with Moneydance' - and this worked.</p>
<p>But some, not all, of the debits were in the credit column !</p>
<p>I will not need to use it for another month, hoping they will have it<br>
sorted by then !</p>
<p>Gerald</p></div>Gerald Pontingtag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-18T11:43:26Z2019-03-18T11:43:26ZMBNA Card transactions reversed after site change<div><p>Was there any pattern (eg by date) for the good and bad transactions?</p>
<p>Please keep an watching interest in this, as you are the only independent evidence tester I’ve found!</p>
<p>David<br>
— It may be that my sole purpose in life is to serve as a warning to others.</p></div>flying.boytag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-18T11:53:08Z2019-03-18T11:53:08ZMBNA Card transactions reversed after site change<div><p>Did not notice a pattern and I've swapped them now - Gerald</p></div>Gerald Pontingtag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-19T19:05:32Z2019-03-19T19:05:32ZMBNA Card transactions reversed after site change<div><p>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.</p>
<p>Code letter T; Description Amount of the item.<br>
For payments a leading minus is required. For deposits either no sign or a plus sign is accepted.</p>
<p>I have passed this discovery to the various deniers within the technical support teams at MBNA and I await their response.</p>
<p>David</p></div>flying.boytag:infinitekind.tenderapp.com,2009-01-14:Comment/470442722019-03-23T08:14:47Z2019-03-23T08:14:48ZMBNA Card transactions reversed after site change<div><p>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</p></div>Jagnut_1961