tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/69613-signs-reversedInfinite Kind: Discussion 2021-08-21T16:50:20Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/491598682021-04-24T02:30:21Z2021-04-24T02:30:21ZSigns reversed<div><p>I'm a fellow user.</p>
<p>It has been observed that some financial institutions have reinterpreted the OFX specification and as such have changed the structure of the data they are providing.<br>
We have seen this reflected in data being incorrectly categorized between deposits and withdrawals when they are stored in Moneydance.</p>
<p>To deal with this an option has been implemented under the menu path File → Preferences → Network to' Ignore Transaction Types in Favor of Amount Sign'.</p>
<p>Selecting this option will result in Moneydance interpreting OFX data in a different way to account for the change in structure that some financial institutions are providing.</p>
<p>I would see if selecting this option resolves your problem.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/491598682021-04-24T14:49:53Z2021-04-24T14:49:53ZSigns reversed<div><p>Thanks for your reply. I found commentary mentioning the Ignore<br>
Transactions toggle you describe below. Unfortunately, it's not working<br>
for me and makes no difference in the import. I should have mentioned<br>
this in my first post. PS - I'm running 2020.2, not 2019.2. Any other<br>
suggestions are most welcome. Thanks.</p></div>jdct2132tag:infinitekind.tenderapp.com,2009-01-14:Comment/491598682021-04-24T15:27:34Z2021-04-24T15:27:39ZSigns reversed<div><p>I’m in the same situation as you with one of my Credit Cards…. The following maybe of interest, but only if your bank will let you grab a CSV file.</p>
<p>In MD go to File → Import, find your CSV file, click Open. On the next screen top item, make sure the account you want to import into is selected. Check the other fields are correct. On the next screen you will see Amount. Change this to Debit Amount, then finish.</p>
<p>The above I think will only work with CSV, but as most Banks normally offer CSV, maybe this will help you. I’ve been importing this way for years.</p>
<p>There is also a CSV Importer extension that other have recommended over the years, that you may like to try. Personally, I’ve felt the above method is more straight forward.</p>
<p>Jeff – Fellow User</p></div>jeff_ltag:infinitekind.tenderapp.com,2009-01-14:Comment/491598682021-04-24T19:53:42Z2021-04-24T19:53:43ZSigns reversed<div><p>Thanks Jeff. The csv files downloaded from yellow 1/2 two columns, debit and credit. I've tried every combination of reversing the column headers on the file and changing the field label in the import window. I was able to successfully import by multiplying the debit amounts by -1 but only on the initial upload. Subsequent uploads are still incorrect. I am befuddled. I'll try the importer you mentioned.</p>
<p>TY!</p></div>jdct2132tag:infinitekind.tenderapp.com,2009-01-14:Comment/491598682021-04-24T20:03:03Z2021-04-24T20:03:03ZSigns reversed<div><p>Hi jdct2132,</p>
<p>Can you post a sample of the CSV file? (make sure that there's no sensitive information in it before attaching it)<br>
The CSV Importer extension can likely import it. It provides for user-defined file reader(s) that, once you've set up, can be used in subsequent downloads.</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/491598682021-04-25T07:25:21Z2021-04-25T07:25:21ZSigns reversed<div><p>Hi, I wrote a quick extension to swap the signs on qif figures and then<br>
load it into MD. Go to<br>
<a href="https://bitbucket.org/mikerb/moneydance-2019/downloads/">https://bitbucket.org/mikerb/moneydance-2019/downloads/</a> and download<br>
qifloader.mxt. Install it using Manage Extensions/Add from file. Note:<br>
this has not been verified by TIK so you will need to accept the warning<br>
from MD.</p>
<p>This extension is a quick fix and is cumbersome, but it works. Have a<br>
loook at <a href="https://bitbucket.org/mikerb/moneydance-2019/wiki/QIF%20Loader">https://bitbucket.org/mikerb/moneydance-2019/wiki/QIF%20Loader</a><br>
for details on how to use it.<br>
Regards<br>
Mike</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/491598682021-05-22T16:40:54Z2021-05-25T11:07:21ZSigns reversed<div><p><a href="https://github.com/stant/mdcsvimporter2015">https://github.com/stant/mdcsvimporter2015</a></p>
<p>define your reader once and use it all the time.<br>
Just flip between -Payment- or -Deposit- field to reverse sign</p></div>stashu.pub