Transaction merge

cookie87's Avatar

cookie87

12 May, 2015 12:41 AM

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 2. View the first page

  1. 31 Posted by markritchie on 18 May, 2019 04:58 PM

    markritchie's Avatar

    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.

  2. 32 Posted by avp2 on 28 May, 2019 03:16 PM

    avp2's Avatar

    I have not seen anyone not want this feature. And, it has been on the lists for quite some time.

  3. 33 Posted by cyclnz on 15 Jun, 2019 02:51 PM

    cyclnz's Avatar

    +1

    I am also one that uses my brokerage account as my primary checking account.

  4. 34 Posted by Pat Conroy on 16 Jun, 2019 07:40 PM

    Pat Conroy's Avatar

    +1

    Sent from Nine<http://www.9folders.com/>
    ________________________________

  5. 35 Posted by Michael on 15 Aug, 2019 07:49 PM

    Michael's Avatar

    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.

  6. 36 Posted by Jill Wilson on 15 Aug, 2019 10:09 PM

    Jill Wilson's Avatar

    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.

  7. System closed this discussion on 14 Nov, 2019 10:10 PM.

  8. Dave Kremer re-opened this discussion on 07 Jun, 2020 06:27 PM

  9. 37 Posted by Dave Kremer on 07 Jun, 2020 06:27 PM

    Dave Kremer's Avatar

    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.

  10. Support Staff 38 Posted by Sean Reilly on 09 Jun, 2020 10:16 PM

    Sean Reilly's Avatar

    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

  11. 39 Posted by Jeff on 09 Jun, 2020 10:22 PM

    Jeff's Avatar

    Merging bank transactions only would cover my use case

  12. 40 Posted by Dave Kremer on 09 Jun, 2020 11:16 PM

    Dave Kremer's Avatar

    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.

  13. 41 Posted by john on 09 Jun, 2020 11:45 PM

    john's Avatar

    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.

  14. 42 Posted by cookie87 on 09 Jun, 2020 11:51 PM

    cookie87's Avatar

    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.

  15. 43 Posted by Larry Donahue on 09 Jun, 2020 11:52 PM

    Larry Donahue's Avatar

    ---------
    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]>

  16. 44 Posted by Pat Conroy on 11 Jun, 2020 12:58 AM

    Pat Conroy's Avatar

    Hi Sean,

    Yes for me I think that would be the more useful part.

    Thanks,
    Pat.

  17. System closed this discussion on 10 Sep, 2020 01:00 AM.

  18. Mark J re-opened this discussion on 16 Feb, 2021 11:36 AM

  19. 45 Posted by Mark J on 16 Feb, 2021 11:36 AM

    Mark J's Avatar

    Yes,please, Sean!

  20. 46 Posted by cyclnz on 16 Feb, 2021 06:43 PM

    cyclnz's Avatar

    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.

  21. 47 Posted by cookie87 on 17 Feb, 2021 03:23 AM

    cookie87's Avatar

    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.

  22. 48 Posted by dwg on 17 Feb, 2021 03:30 AM

    dwg's Avatar

    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.

  23. 49 Posted by davet65 on 19 Feb, 2021 06:26 PM

    davet65's Avatar

    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.

  24. 50 Posted by Johann Beda on 19 Feb, 2021 06:37 PM

    Johann Beda's Avatar

    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

  25. 51 Posted by john on 19 Feb, 2021 07:53 PM

    john's Avatar

    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....

  26. 52 Posted by robert.l.spauld... on 27 Feb, 2021 02:05 PM

    robert.l.spaulding's Avatar

    Patiently awaiting.

  27. System closed this discussion on 29 May, 2021 02:10 PM.

  28. cookie87 re-opened this discussion on 04 Sep, 2021 12:03 PM

  29. 53 Posted by cookie87 on 04 Sep, 2021 12:03 PM

    cookie87's Avatar

    Many users are still anxiously waiting for this capability...

  30. 54 Posted by davet65 on 04 Sep, 2021 02:02 PM

    davet65's Avatar

    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.

  31. 55 Posted by Johann Beda on 04 Sep, 2021 02:56 PM

    Johann Beda's Avatar

    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").

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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