tag:infinitekind.tenderapp.com,2009-01-14:/discussions/online-banking/19209-importing-change-transactions-from-charges-to-payments-vvInfinite Kind: Discussion 2021-07-25T21:15:25Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/493012322021-07-21T10:09:31Z2021-07-21T10:09:33ZImporting : Change transactions from charges to payments + vv<div><p>Hi<br>
I trust this finds you well.<br>
I have been finding Moneydance really good since I made the switch from Microsoft Money.<br>
For one of my credit cards, QIF files are imported the wrong way round.<br>
I've been using a longwinded work around of manually changing charges to payments + vv<br>
i.e. '+' to '-' and '-' to '+'</p>
<p>Please is there any way of changing the way transactions are imported into the account please><br>
OR<br>
Is there a way of batch changing charges to payments + vv<br>
i.e. '+' to '-' and '-' to '+'?<br>
I've attached a QIF for that account<br>
Thank you<br>
Tim</p></div>Tim Normantag:infinitekind.tenderapp.com,2009-01-14:Comment/493012322021-07-21T22:24:13Z2021-07-21T22:24:13ZImporting : Change transactions from charges to payments + vv<div><p>just a user</p>
<p>have you tried Preferences/Network/Ignore Transaction Types in favor of Amount signs?<br>
Not saying that will work, but it can be tried.<br>
EDIT - seems that is for OFX files, but here's a thread with other alternatives:<br>
<a href="https://infinitekind.tenderapp.com/discussions/problems/69613-signs-reversed">https://infinitekind.tenderapp.com/discussions/problems/69613-signs...</a></p>
<p>btw - you uploaded the bank statement, not the QIF file. Hopefully someone from Infinite Kind will delete that for you.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/493012322021-07-21T22:47:07Z2021-07-21T22:47:07ZImporting : Change transactions from charges to payments + vv<div><p>I'm a fellow user.</p>
<p>Obviously I have not see the QIF file as it has not been posted, but over the years some institutions have provided QIF files that have the amounts in them from the perspective of the bank rather than the customer.</p>
<p>A fellow user created QIF loader extension that can potentially help with this.</p>
<p>You can find this extension at:</p>
<p><a href="https://bitbucket.org/mikerb/moneydance-2019/wiki/QIF%20Loader">https://bitbucket.org/mikerb/moneydance-2019/wiki/QIF%20Loader</a></p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/493012322021-07-23T01:39:09Z2021-07-23T01:39:11ZImporting : Change transactions from charges to payments + vv<div><p>Thank you for your comments, which led me to this - which works for me:<br>
"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>Jeff – Fellow User"</p></div>Tim Normantag:infinitekind.tenderapp.com,2009-01-14:Comment/493012322021-07-25T21:15:23Z2021-07-25T21:15:23ZImporting : Change transactions from charges to payments + vv<div><p>I've deleted your bank statement PDF from the original post, since it's generally not a good idea to post things like that publicly on the internet.</p>
<p>I'm glad to hear you've found a solution that will work for you. I think the first suggestion would have worked for the original problem, but if you've found that CSVs meet your needs, that's fine.</p>
<p>Ethan<br>
Infinite Kind Support</p></div>Ethan