Investment Report - Duplicated Account

rayplayer's Avatar

rayplayer

17 Feb, 2019 02:24 PM

I have two Easyshare accounts (RP) and (SP) both holding BT shares. I have just run the Investment Performance report and notice the (RP) account is duplicated? The duplicate (RP) account has no shares but I recognise the income entry as a recent dividend? I also notice the value of the account mirrors that of the (SP) account?

I thought perhaps a rogue account had crept into the system but looking under tools/accounts that is clearly not the case.

I am running build 2019.1 (1855).

  1. 1 Posted by rayplayer on 20 Feb, 2019 02:21 PM

    rayplayer's Avatar

    Hi any thoughts on this please.

  2. 2 Posted by rayplayer on 02 Mar, 2019 01:38 PM

    rayplayer's Avatar

    Hello Infinite Kind, is anybody there?

  3. 3 Posted by rayplayer on 11 Mar, 2019 11:23 AM

    rayplayer's Avatar

    Hi Infinite Kind, this is very disappointing - not even an acknowledgment.

    I have switched to using the Investment Reports Extension where there are no duplicated accounts - which proves there is an issue with Moneydance. However, the Investments Reports Extension is picking up cash balances that differ from the figures I know are correctly reflected in Moneydance – so using the extension does not resolve.

    Something is not right - could my file be corrupted and what is the best way to resolve that?

    Would appreciate some help please.

  4. 4 Posted by derekkent23 on 11 Mar, 2019 01:02 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    Your first thought two investment account with the same name seems the most likely.
    In the Investment Performance report double click on the rogue investment accounts Non-ISA BT Easyshare (RP) to open a transaction window. This may give a clue to what’s going on.

    Hope this helps.

  5. 5 Posted by rayplayer on 15 Mar, 2019 09:47 AM

    rayplayer's Avatar

    Hi Derek, thanks for the response and the tip but all it does it open the Non-ISA BT Easyshare (RP) account as you'd expect - proving there is not actually a duplicated account.

    I have since concluded this is another 'feature' of MoneyDance reporting which clearly can not be trusted.

    .

  6. 6 Posted by derekkent23 on 15 Mar, 2019 09:55 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    I am not having any problems with Investment Performance report running 2019.2(1860).
    Are you getting the same duplication in any other reports?

  7. 7 Posted by rayplayer on 15 Mar, 2019 05:43 PM

    rayplayer's Avatar

    If I run the account balances report all seems well - no duplicated accounts or values.

    However, if I run the portfolio report there is one entry for the Easyshare Account (RP) which correctly states the number of shares and value, but there is an extra line as well with the shares and value from the (SP) account? Which is clearly wrong.

    There is also an entry in the report for the Easyshare Account (SP), which is correctly shown.

  8. 8 Posted by derekkent23 on 15 Mar, 2019 05:59 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    Try this.
    In the Investment Performance report click EDIT - RESET - NONE, then tick the items to be included in the report.

    Hope this helps.

  9. 9 Posted by rayplayer on 15 Mar, 2019 06:02 PM

    rayplayer's Avatar

    Hi Derek, appreciate your help - unfortunately no change.

  10. 10 Posted by derekkent23 on 15 Mar, 2019 06:08 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    OK give up, this one is for support

    SUPPORT CAN YOU STEP IN, Thanks

  11. 11 Posted by rayplayer on 28 Mar, 2019 10:06 AM

    rayplayer's Avatar

    Hi, can I prompt for an update please.

     

    BR’s

     

    Ray

     

    From: Infinite Kind <[email blocked]>
    Sent: 17 February 2019 14:26
    To: [email blocked]
    Subject: Your support request has been received by The Infinite Kind

     

     <http://infinitekind.com>

    The Infinite Kind technical support: infinitekind.com/help <http://infinitekind.com/help>
    email: [email blocked]

     

    Hello rayplayer!

    This is an automated response to let you know that we've received your request:

    Investment Report - Duplicated Account

    and will respond as quickly as possible. Answers to many common questions can be found in our knowledge base <http://help.infinitekind.com/kb> and user guide <http://help.infinitekind.com/kb/user-guides/moneydance-2015-user-guide> .

    Based on your support request, we think you may find the following articles from our FAQ helpful:

    * Create an Investment Account <http://help.infinitekind.com/kb/investment-accounts/create-an-investment-account>
    * Adding Securities <http://help.infinitekind.com/kb/investment-accounts/adding-securities>
    * Represent Property as Investment <http://help.infinitekind.com/kb/investment-accounts/represent-property-as-investment>

    We'll send an email to you (at [email blocked]) when we update your support request. Alternatively, you can keep track of this conversation online <http://help.infinitekind.com/discussions/investments/4231-investment-report-duplicated-account> .

    Thanks again!

    Sincerely,
    The Infinite Kind

     

    Be a part of the Community: Blog <http://infinitekind.com/blog> | <http://twitter.com/theinfinitekind> | <http://facebook.com/MoneydanceApp>

     

    You have been sent this message because you recently opened a help request with The Infinite Kind.

  12. 12 Posted by derekkent23 on 28 Mar, 2019 10:29 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    Hi rayplayer.

    I have posted a link to this thread on Sean’s (the Moneydance’s software developers) Slack site in the hope he will respond to your issue.

    Hope this helps.

  13. 13 Posted by Stuart Beesley on 28 Mar, 2019 02:09 PM

    Stuart Beesley's Avatar

    Hi,
    (I'm just a user),
    This won't help you much, but the Investment Perf report is working fine for me... In fact I recently reconciled it back so that I know it's working. So must be a bug, or perhaps there's something 'funny' with your dividend txn..? Out of interest, what happens if you delete the txn and re-run the report? You can then use edit undo to reinstate the txn. Did the duplicate disappear?

  14. Support Staff 14 Posted by Sean Reilly on 29 Mar, 2019 09:51 AM

    Sean Reilly's Avatar

    Hi Rayplayer,

    I'm so sorry that nobody from TIK has responded to your message after such a long time.

    In Moneydance every investment account has a reference to securities that are managed within that account. This sounds like the Non-ISA BT Easyshare (RP) account and British Telecom security (or maybe just some of the transactions associated with those) have gotten crossed. That is, there are likely transactions in the Non-ISA BT Easyshare (RP, or maybe SP) that reference the security within another investment account. I know of one third party extension that might have caused this to happen.

    It is sometimes possible to manually correct, but the fastest way to resolve it would probably be to do a screen sharing session. If that's ok with you could you let me know what dates and times would work for you as well as your time zone?

    Thanks,
    Sean

    --Sean Reilly Developer, The Infinite Kind
    https://infinitekind.com

  15. 15 Posted by rayplayer on 30 Mar, 2019 10:37 AM

    rayplayer's Avatar

    Hi Stuart, if I delete the dividend txn and re-run the report the duplicate disappears - I can't see anything wrong with the txn, but from Sean's comments something has gotten crossed.

    Hi Sean, many thanks for your response - I'm in the UK and can do a screen share on Monday (1 April) morning or afternoon if that works for you?

    Note that I use the Investment Reports extension, and notice that has no duplicated accounts but it shows negative cash balances which are clearly wrong.

    BR's

    Ray

  16. Support Staff 16 Posted by Sean Reilly on 01 Apr, 2019 10:40 AM

    Sean Reilly's Avatar

    Hi Ray,

    OK, let's do a screenshare today then. I'm also in the UK and could do the screenshare this afternoon, so shall we say 1pm? Here's the link to begin the screen sharing session:
      https://get.teamviewer.com/tikhelp

    If you click that and run the app that auto-downloads then I'll see when you're online and can prompt to begin the connection.

    Thanks,
    Sean

  17. 17 Posted by derekkent23 on 02 Apr, 2019 08:28 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi rayplayer.

    Assuming you had a screen session with Sean would be interest to know if there was a solution to your issue and what that solution was.

    Thanks

  18. Support Staff 18 Posted by Sean Reilly on 02 Apr, 2019 02:49 PM

    Sean Reilly's Avatar

    Hi Ray,

    OK, I've found the problem and confirmed that it was what we discussed during the screen sharing session. It is easy to correct on your side, so no code changes would help on ours (other than adding detection for situations like this). To fix this, do the following:
    1. open your Non-ISA BT Easyshare (RP) account 2. make sure the "Register" tab is selected 3. edit the DivXfr transaction on 2019.02.04 4. while editing that transaction, click the popup arrows in the Security field to select the British Telecommunications security. I know it's already selected, but you'll have to reselect it. This was the problem with the data in the file... this transaction was somehow linked with the British Telecom security in the (SP) account rather than the BT security in the (RP) account.

    That should get you back on track and I'll add a check to an upcoming version of MD to auto-correct this kind of situation or at least prevent this from happening again. Do you remember how this transaction was entered in the first place? If it was through an extension then it'd be good to check to see if there is a newer version of the extension available that fixes the problem, or maybe avoid that extension in the future.

    Thanks,
    Sean

    --Sean Reilly Developer, The Infinite Kind
    https://infinitekind.com

  19. 19 Posted by rayplayer on 02 Apr, 2019 03:14 PM

    rayplayer's Avatar

    Hi Sean, many thanks - I should have mentioned when we spoke but I won't be able to access my PC to do this until Sunday.  I will get back to you then - hope that's ok.

    BR's

    Ray

    Get Outlook for Android

  20. 20 Posted by rayplayer on 08 Apr, 2019 09:17 AM

    rayplayer's Avatar

    Hi Sean, I have just done as you suggested and it has fixed it, so many thanks.

    I've not used an extension to enter transactions in the past so it would have been a manual entry.

    Thanks Again

    BR's

    Ray

  21. rayplayer closed this discussion on 08 Apr, 2019 09:17 AM.

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

Recent Discussions

19 May, 2019 10:40 PM
19 May, 2019 09:09 PM
19 May, 2019 08:36 PM
19 May, 2019 08:30 PM
19 May, 2019 08:17 PM