Transaction merge
Please, please, please revise investment accounts so that downloaded transactions can be merged with manually keyed transactions, and so that reminders (for things like a paycheck) can be set up with splits? Many, many people with a brokerage account uses it also as a checking account, like any other checking account, so it would be beyond wonderful if MD could do the same.
Showing page 2 out of 3. View the first page
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
31 Posted by markritchie on 18 May, 2019 04:58 PM
Another vote for the ability to merge investment transactions. I found this thread while trying to figure out how to merge downloaded transactions from my HSA. I already have my paycheck setup with splits, one of which is a transfer to my HSA investment account. However, when I try to download transactions (from Fidelity in this case), MD tries to add a duplicate transaction for my paycheck contributions since it won't let me merge it with the existing transfer created by my paycheck.
32 Posted by avp2 on 28 May, 2019 03:16 PM
I have not seen anyone not want this feature. And, it has been on the lists for quite some time.
33 Posted by cyclnz on 15 Jun, 2019 02:51 PM
+1
I am also one that uses my brokerage account as my primary checking account.
34 Posted by Pat Conroy on 16 Jun, 2019 07:40 PM
+1
Sent from Nine<http://www.9folders.com/>
________________________________
35 Posted by Michael on 15 Aug, 2019 07:49 PM
4 years later and we're still crossing fingers they eventually figure out a way to marge investment txns or at least come up with a non-kludgy way to mark (and hide!) them so they don't keep downloading every time.
36 Posted by Jill Wilson on 15 Aug, 2019 10:09 PM
I have several credit cards that are auto paid in full from my brokerage
account. I find that it works out better if I delete the reminder
transactions (that I use as a placeholder so I know what my cash flow is)
the day before I download the actual transactions from the brokerage
account. Then I can accept the brokerage transactions and merge the credit
card transactions in the CC accounts.
I really should not have to do this. This needs to be fixed.
System closed this discussion on 14 Nov, 2019 10:10 PM.
Dave Kremer re-opened this discussion on 07 Jun, 2020 06:27 PM
37 Posted by Dave Kremer on 07 Jun, 2020 06:27 PM
More than 5 years since this issue was first raised and still not a single response from the support staff. No blog posts or releases for the entire product for nearly a year. Feels like a dead or dying product.
I think I'm done dealing with single developer commercial products. Maybe it's time for me to move to something like GNU Cash.
Support Staff 38 Posted by Sean Reilly on 09 Jun, 2020 10:16 PM
Hi All,
I just wanted to let you know that I do still plan on adding the ability to merge (and generally clean up) downloaded investment transactions into Moneydance. I understand that it's frustrating to have seen this feature requested for so long and it still not being implemented.
I wonder if it would be of any use to provide the merge function but only for non-security transactions in the Bank Transactions part of the register?
Thanks,
Sean
--
Sean Reilly
Developer, The Infinite Kind
https://infinitekind.com
39 Posted by Jeff on 09 Jun, 2020 10:22 PM
Merging bank transactions only would cover my use case
40 Posted by Dave Kremer on 09 Jun, 2020 11:16 PM
Thank you for responding to this.
Merging bank transactions would fix this problem for me.
In my case, it's a Fidelity Cash Management account that causes the problems. It is a brokerage account that also acts like a checking account. I have a debit card, can write checks, do automatic payments, direct deposit and Fidelity will replenish the checking portion of the account with transfers from another brokerage account. Many of those cases have the same transaction getting downloaded from more than one source and not being able to merge them is a pain.
By the way, it's not just that this issue has been around for a long time without getting implemented. In my opinion, the real issue is that people submit things to these discussion lists and no one from Infinite Kind provides any kind of response. Just leaving things to close without some response drives me and probably a lot of other customers nuts. PLEASE have someone from support respond to posts instead of letting them just get closed by the system.
41 Posted by john on 09 Jun, 2020 11:45 PM
This exactly – and like Dave Kremer – it’s a brokerage account – but the securities stay separate from the cash account – how MS Money and Quicken (arrgh!) do it today… The account has 2 sides. One for the securities, the other for the cash and banking transactions.
42 Posted by cookie87 on 09 Jun, 2020 11:51 PM
Yes, the merge function is most necessary for the non-security bank transactions - that’s what we’ve been asking for, for YEARS. Thank you for hopefully actually doing it. I’m not paying for another upgrade without it.
43 Posted by Larry Donahue on 09 Jun, 2020 11:52 PM
---------
Laurence S. Donahue, Esq.
Law 4 Small Business
www.L4SB.com<https://www.l4sb.com/>
(p) 505.715.5700
[email blocked]<mailto:[email blocked]>
[signature_257062664]
CONFIDENTIALITY NOTICE: This message is being sent by or on behalf of a lawyer. The unauthorized disclosure or interception of e-mail is a federal crime. See 18 U.S.C. § 2517(4). It is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
From: cookie87 <[email blocked]>
Reply-To: "[email blocked]" <[email blocked]>
44 Posted by Pat Conroy on 11 Jun, 2020 12:58 AM
Hi Sean,
Yes for me I think that would be the more useful part.
Thanks,
Pat.
System closed this discussion on 10 Sep, 2020 01:00 AM.
Mark J re-opened this discussion on 16 Feb, 2021 11:36 AM
45 Posted by Mark J on 16 Feb, 2021 11:36 AM
Yes,please, Sean!
46 Posted by cyclnz on 16 Feb, 2021 06:43 PM
Yes I believe merging bank transactions would cover my primary use case also and would be a great feature.
My brokerage account also has a loan account which may need the merge feature at some point so that transfer payments from the bank accounts can be merged with the downloaded data in the loan account. But at the present time, I don't think downloading from my brokerage firm handles transaction downloads for the loan account. I assume that is a problem with my brokerage firm though.
47 Posted by cookie87 on 17 Feb, 2021 03:23 AM
I hope you are still working on this Sean - an update would be very much appreciated. Plus, We wish Infinite Kind would stop closing this thread, since this issue is still not resolved after a ridiculous number of years.
48 Posted by dwg on 17 Feb, 2021 03:30 AM
I'm a fellow user.
I'm afraid the Tender software closes discussions after about 3 months of no activity, so TIK cannot make the thread stay open.
49 Posted by davet65 on 19 Feb, 2021 06:26 PM
I just discovered this thread by accident when searching for another problem.
I have long been frustrated by this issue, and my suggestion is to have the SAME MERGING PROCESS for ANY DOWNLOADED TRANSACTION. I can appreciate that there may be problems due to the different data downloaded, but please make the process as similar as possible.
My primary concern is with different treatment of Bank vs Credit Card accounts/downloaded transactions [though it applies to Investment Accounts, too]. Unless I am missing/confusing something - which is very possible - this is what MD does:
* When a downloaded Bank transaction finds a merge candidate already in the transaction register,
* MD always shows the Downloaded Transaction as an Unconfirmed Transaction in the split window below,
* the Downloaded Transaction shows as the Current Transaction in the right side panel that pops up,
* and the Previoulsy Entered Transaction shows up in the Merge Choices below.
* So I click Merge.
That is fine and intuitive.
But if in a Credit Card account:
* the Previously Entered Transaction DISAPPEARS from the original register list,
* and shows up - I think - as an Unconfirmed Transaction below as if it was downloaded,
* the Current Transaction in the right hand column panel is now that previously entered transaction, not the Downloaded one,
* and the Downloaded Transaction now shows up as the Transaction as Downloaded.
* So to "Merge" the Downloaded with Previously Entered, I have to choose Current Transaction!
If you are totally confused reading the above, sorry, I tried to write it out as clearly as I believe it actually happens. To me, this difference in treatment of Merge Candidates is VERY confusing - though I have learned to live with it.
50 Posted by Johann Beda on 19 Feb, 2021 06:37 PM
I have not noticed any difference for CC vs Bank download transaction merging. Broadly the behaviour I see is like davet65 described for bank transactions, and I have never noticed any auto-merging happening like described for credit cards.
Might the difference be between imported data files and data files that are downloaded directly by MoneyDance? I manually download all the datafiles (prefereably OFX) myself and then hand them to MD.
This discussion talks about "auto-merge" which might have something to do with what davet65 is seeing.
https://infinitekind.tenderapp.com/discussions/general-questions/2669-meaning-of-auto-merge-in-preferences
51 Posted by john on 19 Feb, 2021 07:53 PM
This thread is about the transaction behavior for a brokerage account
that also has a checking account.... started years ago, this needs to
happen for many thousands of people to break free of Quicken and their
subscription scheme - and stream of constant updates that break shit for
no reason....
52 Posted by robert.l.spauld... on 27 Feb, 2021 02:05 PM
Patiently awaiting.
System closed this discussion on 29 May, 2021 02:10 PM.
cookie87 re-opened this discussion on 04 Sep, 2021 12:03 PM
53 Posted by cookie87 on 04 Sep, 2021 12:03 PM
Many users are still anxiously waiting for this capability...
54 Posted by davet65 on 04 Sep, 2021 02:02 PM
Regarding my post #49 and Johann #50:
I think Johann is correct. MD appears to treat automatically downloaded credit card transactions differently from manually downloaded files that I have to manually import into MD. Or perhaps it is a difference in the downloaded file structure from different merchants? I have noticed that for my manually downloaded files, a potential transaction match does disappear from the register if a similar transaction is downloaded. But if the downloaded transaction is accepted, then the original potential match transaction reappears above as a match candidate. I have learned to accept then match so the process is similar to automatically downloaded transactions.
This goes back to my original comment to have the SAME matching process for ANY downloaded transaction - including the original purpose of this thread regarding bank/checking vs investment/brokerage accounts. But add credit card accounts.
55 Posted by Johann Beda on 04 Sep, 2021 02:56 PM
Something that might be nice would be the ability to select two arbitrary transactions and have them merge - thus if I accidentally create two instances of the same transaction, or if I make downloads from different sources that include the same transaction, then I can say "hey, these two things are actually the same thing".
Probably there are some "behind the scenes" things that make this difficult, like tracking download file id numbers or things like that. Moneydance is pretty good at not adding duplicates when I import files again or import files from my financial institution that duplicate transactions (ie. "all spring transactions" and "full year transactions").
System closed this discussion on 04 Dec, 2021 03:00 PM.
Mark J re-opened this discussion on 13 May, 2022 11:42 AM
56 Posted by Mark J on 13 May, 2022 11:42 AM
Sean, can you at least explain why this should be different for investment accounts? On the surface it seems to be an easy add and as shown by all the comments over 7 years, highly in demand. Please add investment account merging.
Thanks, Mark
Support Staff 57 Posted by Maddy on 13 May, 2022 12:05 PM
Hi Mark,
You can achieve this by using the Toolbox now!
Firstly, please ensure you are running this version of Moneydance: Moneydance 2022.4 (4078) and update/install the Toolbox via Extensions->Manage Extensions. The latest Toolbox version is v.1048.
Close and re-launch Moneydance!
Then, navigate to Extensions->Toolbox Move Investment Transactions and follow the onscreen instructions.
Please let us know if you have further questions or need more assistance.
--
Maddy, Infinite Kind Support
58 Posted by Stuart Beesley ... on 13 May, 2022 01:02 PM
Slight correction to the post above. Toolbox allows you to move/merge investment transactions from one account into another. It does NOT perform any kind of in-account transaction merge on downloaded bank transactions (which i think is what is being requested).
59 Posted by Andrew Price on 13 May, 2022 01:03 PM
Andrew
07503 978 705
On 13 May 2022, at 14:02, Stuart Beesley (Mr Toolbox) <[email blocked]> wrote:
Support Staff 60 Posted by Maddy on 13 May, 2022 01:14 PM
@ Andrew My apology for having misinterpreted the purpose of this feature.
@Stuart Thank you for clarifying the information, Stuart.
--
Maddy, Infinite Kind Support