Loading Profile...
Deleted downloaded transactions won't stay deleted
When I download transactions from my bank (PNC) via "Online/Download Transactions", they sometimes do not get matched properly. Mildly inconvenient, but I can live with it. I delete the unmatchable transactions from the downloaded list, and mark them as "cleared" manually.
However, since updating to version 2008r3 (629), the deleted transactions reappear every time I choose "Online/Download transactions". Right now this is annoying, but as the list of reappearing transactions gets longer and longer over time, it will make it very difficult to use.
I have tried deleting/saving/restarting multiple times, but they always reappear. Any matched transactions are properly removed from the list, so I don't believe it is my bank resending the transactions.
Any suggestions or fixes appreciated.
Java Version: 1.6.0_05
However, since updating to version 2008r3 (629), the deleted transactions reappear every time I choose "Online/Download transactions". Right now this is annoying, but as the list of reappearing transactions gets longer and longer over time, it will make it very difficult to use.
I have tried deleting/saving/restarting multiple times, but they always reappear. Any matched transactions are properly removed from the list, so I don't believe it is my bank resending the transactions.
Any suggestions or fixes appreciated.
Java Version: 1.6.0_05
I’m annoyed
10
people have this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
The best answer from the company
-
Your bank is apparently re-sending them, but Moneydance eliminates the ones that have already been matched with location transactions (or added as new transactions).
The transaction IDs for the (re)downloaded transactions are not associated with any transactions in your register, so Moneydance cannot eliminate them.
The solution should be to match the downloaded transactions with the correct local transaction. Does the correct match not appear at all in the selector at the top of the list of downloaded transactions? Is it a different amount, or has the local transaction already been matched with a different downloaded transaction? That's the only way that a local transaction shouldn't be provided as a possible match.
The company says
this answers the question
Create a customer community for your own organization
Plans starting at $19/month
-
Inappropriate?Does this only happen with that particular bank?1 Comment Add a comment
This answers the question
-
I only have the one online banking account, so I'm afraid I don't have any other to compare against. -
Inappropriate?Happens with all accounts... -
Inappropriate?Your bank is apparently re-sending them, but Moneydance eliminates the ones that have already been matched with location transactions (or added as new transactions).
The transaction IDs for the (re)downloaded transactions are not associated with any transactions in your register, so Moneydance cannot eliminate them.
The solution should be to match the downloaded transactions with the correct local transaction. Does the correct match not appear at all in the selector at the top of the list of downloaded transactions? Is it a different amount, or has the local transaction already been matched with a different downloaded transaction? That's the only way that a local transaction shouldn't be provided as a possible match.
The company says
this answers the question
-
Inappropriate?Sean,
I occasionally have examples meeting one or more of the criteria that you mention in your last paragraph. The most common one is when two or more items are deposited on one deposit slip. I don't want to merge them into a split transaction just to get them to match the download. Granted, I usually try to limit myself to one item per deposit, but sometimes that is a major hassle. If there was a way to "group" multiple transactions to fulfill a downloaded transaction, or to edit a transaction that is a good match except for amount to change the amount to match the download without the odious process of closing the download window, finding the transaction which was probably entered with an estimated amount, remembering the correct amount and editing the transaction, then re-opening the download window and trying again to match it.
I don't think that sentence parses correctly, but you get the idea.
I'm done letting off steam, I apologize if I over did it. I do not want to delay work on the next release.
On the point of there being no transaction ID to match when a downloaded transaction is deleted, what if the transaction could be kept as a voided transaction, so it would match next time?
Best,
Dave -
Inappropriate?I have the same problem as bkuehner. This all started since your update. This is not a simple procedure fix. It is a software problem with Moneydance not properly communicating with the bank's software. Stop trying to pass the buck and please quickly find the problem with your last update, everything worked fine with me UNTIL YOUR LAST UPDATE. Otherwise, you will force me to go back, God Forbid, to Quicken!!!!! I cannot now properly balance my online bank accounts.
Walter Haalck
I’m frustrated
-
Inappropriate?Please do not be too hasty to blame Moneydance. As a long term user, I have been forced to study the the concept of how OFX and QFX files are structured, including some of the tricks that Intuit is applying to to force financial institutions to pay Intuit huge amounts of protection money. That is on top of what they are extorting from users.
Intuit does not want an open file format, because the little guys like Sean Reilly can do it better at a fraction of the cost.
As it is, Sean spends way too much time trying to chase down new issues created by Intuit.
If your problem is actually matching successfully downloaded transactions to pre-existing transactions in the file, that is an entirely separate issue, which, for me, went away almost completely when I learned that there were two different levels of matching, one called possible match and another called repeat payee, and how each type behaved.
Dave1 Comment Add a comment
This answers the question
-
I can also say that many banks don't have perfect OFX services. Quite a lot of them have bugs and strange behaviors that Moneydance has been modified to work around, and there are some bugs that we haven't found a way to workaround (like broken transaction IDs from certain credit card companies).
I don't pretend that there are no bugs in Moneydance, but in most cases explaining how the system works usually helps people understand why certain transactions keep reappearing. I try to make sure that I err on the side of showing duplicates rather than hiding valid transactions :) -
Inappropriate?I can ditto the above. What I had was a usage error. If I have to match the transactions by hand then they stay in sync.
PS as a Quicken user "forever", I know they released multiple times, paid updates, with the same bugs! They never fix anything. Also having your data in XML is sweet. You're not locked in. Which is why I'm here. -
Inappropriate?I was seeing the transactions crop up again even when I just did "Show Online Transactions", which I don't think downloads anything from the bank.
I have not had this problem occur recently, so perhaps it was a particular set of transactions that were being handled oddly.
As for the two level of matching that David mentions, I don't think "Repeat Payee" is indicating a match. I think it is just a shortcut way of entering the rest of the data for a downloaded transaction that didn't match any existing transaction, and Moneydance is making a guess as to the rest of the info based on past history. Is that an incorrect understanding?1 Comment Add a comment
This answers the question
-
Yes, both of your statements are correct. Show Online Transactions doesn't download anything from the bank. I believe the problem with deleted transactions re-appearing without a download was fixed in a recent update. Repeat Payee is saying that Moneydance has detected one or more similar transactions in your register and is offering their description/category fields as human-friendly replacements.
-
Inappropriate?I've got a similar problem with T. Rowe Price Mutual Fund.
Some funds seem to work, others like (Health Sciences, PRHSX) keep showing the transaction when I click download.
It shows as 'unmatched'. I have recorded the transaction, I have deleted the transaction to no avail.
When I 'Record' it, I get duplicates, yet MD does not match it!
Maybe the problem is that when the transaction is downloaded, the action shows 'BUYMF' , but when I say 'Record' it records with the action 'Buy'!
This is a problem in itself that now it shows a minus cash balance. This should have been a buying shares or adding shares to the account.
Java Version: 1.5.0_16
Java Vendor: Apple Inc.
2008r3 (631)2 Comments Add a comment
This answers the question
-
Changing BUYMF to Buy shouldn't change anything. Can you try recording both transactions (so that the duplicates are both in the register)? Then right-click (or control click) on each of the duplicate transactions in the register and select Show Transaction Details from the popup menu. In the window that appears, all of the "hidden" fields for the transaction should be present, including the transaction ID (probably labeled ol_fitid_1). Getting the online transaction ID for both transactions should show if the bank is sending the duplicate transactions with different transaction IDs.
-
OK I think I may have found the potential problem but I can not fix it.
When I said to download for the first time, MD asked me to identify the Security name. I picked 'Mid-Cap Growth' which is what I had in Quicken (since I imported info from Quicken 2006). When MD downloads the transactions is records 'T. ROWE PRICE MID-CAP GROWTH'. So it seems that the security name is not the same. I can find no way to change the security name that MD associates with this account when it downloads! So the transactions keep on downloading.
Thee has to be a way to show and or change the security name that MD associates with the account during download.
I tried to disable and refresh the online banking service for this account to no avail. -
Inappropriate?cris, you should be able to change the security name by going to the Tools->Edit Accounts menu, selecting the security under the investment account and clicking the Edit button. If that doesn't work then editing the security name in the Tools->Edit Securities menu should work.
I need to make this more clear in the interface.
1 person says
this answers the question
-
Inappropriate?Sean,
'Edit Accounts' does not let me edit the Security.
But, I can change the Security like you said from 'Edit Securities'.
This still did not solve the problem.
The Security was ID: '^Health Sciences1', Name: 'Health Sciences'.
I am assuming that the '^' is either escape character or capital or something for MD.
I changed as follows:
ID:'^T. ROWE PRICE HEALTH SCIENCES'
Name:'T. ROWE PRICE HEALTH SCIENCES'
I could tell that the Security name in the Register got updated.
I re-setup the 'Online Banking' and did a download. I still got a duplicate download that will not go away. During the download, MD did not ask me to identify the Security name (I am assuming this is normal).
Is there a way to see the raw download for the account. I am assuming that once I do a 'Show Transaction Detail' (Right click on the transaction), that this is the MD filtered/decoded version.
16 out of the 20 accounts look good regarding downloading. However, the 4 accounts refuse to match transactions and keep on downloading. I have 'Recorded' the transaction and deleted the old ones. I have Deleted the downloaded transactions and the results are the same. The transactions still download.
Here is one of the transactions that is problematic:
<ptxn>
<txnid>36002</txnid>
<acctid>177</acctid>
<desc>XXXX PARTICIPANT CONTRIB</desc>
<status> </status>
<date>2008.09.25</date>
<dtentered>2009.04.06 06:14:34:991</dtentered>
<taxdate>2008.09.25</taxdate>
<checknum></checknum>
<memo>XXXX PARTICIPANT CONTRIB</memo>
<tags>
<tag>
<key>xfer_type</key>
<val>xfrtp_buysell</val>
</tag>
<tag>
<key>ol_fitid_1</key>
<val>2850020002008-09-2600:57:47.122978010</val>
</tag>
<tag>
<key>ol.orig-payee</key>
<val>XXXX PARTICIPANT CONTRIB</val>
</tag>
<tag>
<key>ol.orig-memo</key>
<val>XXXX PARTICIPANT CONTRIB</val>
</tag>
<tag>
<key>ol_fi_id</key>
<val>ofx:Intuit:7775</val>
</tag>
</tags>
<splits>
<stxn>
<txnid>36003</txnid>
<acctid>217</acctid>
<desc>XXXX PARTICIPANT CONTRIB</desc>
<parentamt>-5000.00</parentamt>
<splitamt>194.175</splitamt>
<rawrate>3.8835</rawrate>
<status> </status>
<tags>
<tag>
<key>invest.splittype</key>
<val>sec</val>
</tag>
</tags>
</stxn>
</splits>
</ptxn>
EMPLOYEE
