tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/3910-phantom-transactions-from-etradeInfinite Kind: Discussion 2019-02-26T01:10:23Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/464738832018-11-15T01:40:51Z2018-11-15T01:40:51ZPhantom transactions from E*TRADE<div><p>This sounds like a sweep account:</p>
<p><a href="https://www.investopedia.com/terms/s/sweepaccount.asp">https://www.investopedia.com/terms/s/sweepaccount.asp</a></p>
<p>My assumption is that you E-trade cash balance is held in this sweep account. Your monthly dividend is credited to your account then transferred back to the sweep account. The sweep account is technically owned by another financial institution which is why it is treated as a xfer. When downloading the xfer transaction, MD does not recognize the institution so it assigns the catagory to the saving account as it remembers previous xfers from that account..</p>
<p>When MD does direct connect it downloads all transactions E-trade has on your account. The xfer is a behind the scene transaction between E*trade and the JPMorgan MM that does not make it to your statement but it is in the E*trade system.</p>
<p>My assumption is that your E-trade cash balance is equal to this sweep account and the div you reference is added to your cash balance. If this is so, you only have to delete the extraneous xfer transaction from the investment register. The div transaction should retail the addition to your cash balance.</p>
<p>If i have completely misunderstood your issue please let us know and we will do our best to resolve this issue.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/464738832018-11-15T02:21:56Z2018-11-15T02:21:57ZPhantom transactions from E*TRADE<div>
<div>Thanks for the reply, Tom. I think you understand the issue, and your response is reasonable. </div>
<div><br></div>
<div>But I don't think I can simply delete the xfer, because it just reappears on subsequent downloads. That's why I have to manually create the offsetting xfer. It would be nice if MD would just ignore the xfers between institutions that it doesn't recognize, but guess that may lead to other issues. <br>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Nov 14, 2018 8:40 PM, Tom Freeman <tender+d937458743@tenderapp.com> wrote:<br type="attribution">
<blockquote class="quote">
<div>
<table width="100%">
<tr>
<td>
<p>// Please reply above this line<br>
==================================================</p>
<p><b>From</b>: Tom Freeman (Support staff)</p>
<div>
<p>This sounds like a sweep account:</p>
<p><a href="https://www.investopedia.com/terms/s/sweepaccount.asp">https://www.investopedia.com/terms/s/sweepaccount.asp</a></p>
<p>My assumption is that you E-trade cash balance is held in this sweep account. Your monthly dividend is credited to your account then transferred back to the sweep account. The sweep account is technically owned by another financial institution which is why it is treated as a xfer. When downloading the xfer transaction, MD does not recognize the institution so it assigns the catagory to the saving account as it remembers previous xfers from that account..</p>
<p>When MD does direct connect it downloads all transactions E-trade has on your account. The xfer is a behind the scene transaction between E*trade and the JPMorgan MM that does not make it to your statement but it is in the E*trade system.</p>
<p>My assumption is that your E-trade cash balance is equal to this sweep account and the div you reference is added to your cash balance. If this is so, you only have to delete the extraneous xfer transaction from the investment register. The div transaction should retail the addition to your cash balance.</p>
<p>If i have completely misunderstood your issue please let us know and we will do our best to resolve this issue.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p>
</div>
<div>
<p>On Fri, Nov 09 at 02:47 PM PST, David wrote:</p>
<blockquote>
<div>
<p>Uninvested cash in my E*TRADE investment accounts receives monthly dividends from a JP Morgan MM fund (HTSXX). Each month there is a phantom transaction included in MoneyDance in each investment account. For example: DIV - $10.00, followed immediately by a XFR transaction for $10.00 to a E*TRADE savings account. I have to manually enter another XFR to reverse the first one in order to bring the accounts into balance with reality. The only transaction showing up online at E*TRADE is the DIV. Per E*TRADE account manager, there are no transactions other than the DIV that they can see.</p>
<p>That makes me conclude that MD is somehow generating this phantom XFR transaction. I'm running WIN10 and MD verson 2017.10 (1706). This was also happening on 2017.09.</p>
</div>
</blockquote>
</div>
</td>
</tr>
<tr>
<td>
<p>Having trouble reading this? View this discussion online: <a href="http://help.infinitekind.com/discussions/investments/3910-phantom-transactions-from-etrade">Phantom transactions from E*TRADE</a>.</p>
<p>Reply with #ignore to stop receiving notifications for this discussion.</p>
</td>
</tr>
</table>
</div>
</blockquote>
</div>
<br></div>
</div>
</div>David Krebbstag:infinitekind.tenderapp.com,2009-01-14:Comment/464738832018-11-16T16:29:07Z2018-11-16T16:29:07ZPhantom transactions from E*TRADE<div><p>The difficulty in dealing with sweep transactions is for MD to recognize the difference between a xfer that is from the sweep account to the investment account and a xfer which is an actual transafer of funds. The coding of the transactions are the same.</p>
<p>If you are using direct connect for Etrade, then MD should only ask the server for the transactions since the last download, so it shouldn't download again. Or if it does, it should only overlap by at most a day. It may also be that we ask for the right dates, but they go ahead and send a bunch of old ones anyway.</p>
<p>I have an E*trade account so I am going to test if the transactions I deleted today come back tomorrow.</p>
<p>One thing you may want to do is to create a catagory called sweep transaction, edit the next download to this catagory and MD should remember on subsequent downloads. And edit the xfer to 0. This will keep the xfers from inadvertently messing up your savings account.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/464738832018-11-16T17:01:13Z2018-11-16T17:01:14ZPhantom transactions from E*TRADE<div>Yeah, it would be great if I could just delete the xfer transaction, so please let me know how your testing goes. I know the first time this happened I deleted the xfer and it came back the next day. I didn't try any longer time period between downloads.
<div><br></div>
<div>Thanks for looking into this issue. </div>
<div><br></div>
<div>DK</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Nov 16, 2018 11:29 AM, Tom Freeman <tender+d937458743@tenderapp.com> wrote:<br type="attribution">
<blockquote class="quote">
<div>
<table width="100%">
<tr>
<td>
<p>// Please reply above this line<br>
==================================================</p>
<p><b>From</b>: Tom Freeman (Support staff)</p>
<div>
<p>The difficulty in dealing with sweep transactions is for MD to recognize the difference between a xfer that is from the sweep account to the investment account and a xfer which is an actual transafer of funds. The coding of the transactions are the same.</p>
<p>If you are using direct connect for Etrade, then MD should only ask the server for the transactions since the last download, so it shouldn't download again. Or if it does, it should only overlap by at most a day. It may also be that we ask for the right dates, but they go ahead and send a bunch of old ones anyway.</p>
<p>I have an E*trade account so I am going to test if the transactions I deleted today come back tomorrow.</p>
<p>One thing you may want to do is to create a catagory called sweep transaction, edit the next download to this catagory and MD should remember on subsequent downloads. And edit the xfer to 0. This will keep the xfers from inadvertently messing up your savings account.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p>
</div>
<div>
<p>On Wed, Nov 14 at 06:21 PM PST, David Krebbs wrote:</p>
<blockquote>
<div>
<div>Thanks for the reply, Tom. I think you understand the issue, and your response is reasonable. </div>
<div><br></div>
<div>But I don't think I can simply delete the xfer, because it just reappears on subsequent downloads. That's why I have to manually create the offsetting xfer. It would be nice if MD would just ignore the xfers between institutions that it doesn't recognize, but guess that may lead to other issues. <br>
<div><br>
<div class="elided-text">On Nov 14, 2018 8:40 PM, Tom Freeman <[email blocked]> wrote:<br type="attribution">
<blockquote>
<div>
<table width="100%">
<tr>
<td>
<p>// Please reply above this line<br>
==================================================</p>
<p><b>From</b>: Tom Freeman (Support staff)</p>
<div>
<p>This sounds like a sweep account:</p>
<p><a href="https://www.investopedia.com/terms/s/sweepaccount.asp">https://www.investopedia.com/terms/s/sweepaccount.asp</a></p>
<p>My assumption is that you E-trade cash balance is held in this sweep account. Your monthly dividend is credited to your account then transferred back to the sweep account. The sweep account is technically owned by another financial institution which is why it is treated as a xfer. When downloading the xfer transaction, MD does not recognize the institution so it assigns the catagory to the saving account as it remembers previous xfers from that account..</p>
<p>When MD does direct connect it downloads all transactions E-trade has on your account. The xfer is a behind the scene transaction between E*trade and the JPMorgan MM that does not make it to your statement but it is in the E*trade system.</p>
<p>My assumption is that your E-trade cash balance is equal to this sweep account and the div you reference is added to your cash balance. If this is so, you only have to delete the extraneous xfer transaction from the investment register. The div transaction should retail the addition to your cash balance.</p>
<p>If i have completely misunderstood your issue please let us know and we will do our best to resolve this issue.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p>
</div>
<div>
<p>On Fri, Nov 09 at 02:47 PM PST, David wrote:</p>
<blockquote>
<div>
<p>Uninvested cash in my E*TRADE investment accounts receives monthly dividends from a JP Morgan MM fund (HTSXX). Each month there is a phantom transaction included in MoneyDance in each investment account. For example: DIV - $10.00, followed immediately by a XFR transaction for $10.00 to a E*TRADE savings account. I have to manually enter another XFR to reverse the first one in order to bring the accounts into balance with reality. The only transaction showing up online at E*TRADE is the DIV. Per E*TRADE account manager, there are no transactions other than the DIV that they can see.</p>
<p>That makes me conclude that MD is somehow generating this phantom XFR transaction. I'm running WIN10 and MD verson 2017.10 (1706). This was also happening on 2017.09.</p>
</div>
</blockquote>
</div>
</td>
</tr>
<tr>
<td>
<p>Having trouble reading this? View this discussion online: <a href="http://help.infinitekind.com/discussions/investments/3910-phantom-transactions-from-etrade">Phantom transactions from E*TRADE</a>.</p>
<p>Reply with #ignore to stop receiving notifications for this discussion.</p>
</td>
</tr>
</table>
</div>
</blockquote>
</div>
<br></div>
</div>
</div>
</blockquote>
</div>
</td>
</tr>
<tr>
<td>
<p>Having trouble reading this? View this discussion online: <a href="http://help.infinitekind.com/discussions/investments/3910-phantom-transactions-from-etrade">Phantom transactions from E*TRADE</a>.</p>
<p>Reply with #ignore to stop receiving notifications for this discussion.</p>
</td>
</tr>
</table>
</div>
</blockquote>
</div>
<br></div>David Krebbstag:infinitekind.tenderapp.com,2009-01-14:Comment/464738832018-11-16T21:08:44Z2018-11-16T21:08:44ZPhantom transactions from E*TRADE<div><p>Caveat: I don't use MD as my primary tool so I don't know if this will work. But in with other financial program that I've used, the following works</p>
<ul>
<li>accept the extra entries</li>
<li>then void them</li>
</ul>
<p>Since the void entries are still there, they will just get matched up again (and not created again).</p></div>hleofxquotestag:infinitekind.tenderapp.com,2009-01-14:Comment/464738832018-11-16T22:24:56Z2018-11-16T22:24:56ZPhantom transactions from E*TRADE<div><p>Hi hleofxquotes.</p>
<p>I'm afraid there is no void option in Moneydance.</p>
<p>Des</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/464738832018-11-26T23:45:47Z2018-11-26T23:45:50ZPhantom transactions from E*TRADE<div><p>Tom - Have you had any success with your E*TRADE testing last week?</p></div>Davidtag:infinitekind.tenderapp.com,2009-01-14:Comment/464738832018-11-27T01:08:45Z2018-11-27T01:08:45ZPhantom transactions from E*TRADE<div><p>I just tried and the deleted xfers still downloaded even after this much time.</p>
<p>Which means that E-trade is either ignoring our date stamp request or just sending all transactions within their time period.</p>
<p>I am so sorry for the inconvenience. The best I can really offer is to zero the xfer.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freeman