Import of QM2007 Investment Transactions - Marcus Please Consider Fixing

Scott SchmidtScott Schmidt Member
I recently purchased QM 2018 and imported my data, including investment transactions, from QM2007.  The account balances in almost all investment accounts did not match between the QM2007 and QM2018 files after import.  I investigated, and determined that there is an inconsistency in the way data is handled that is causing this problem.  Please let me explain.

When entering QM2007 investment transactions, there are four fields that are entered in the register - number of shares, $ amount of transaction, commission, and share price.  The share price is back-calculated from the first three parameters.  Occasionally if one of the first three fields is edited during the transaction entry, the share price does not get updated properly and the transaction ends up being entered with this field having an incorrect value (i.e. it is not consistent with the shares/$/commission fields).  This is no big deal because this share value doesn't seem to be used for much in QM2007.

However, when importing this faulty transaction into QM2018, the total transaction cost is calculated from the number of shares, commission, and the (possibly incorrect) share price.  This results in the transaction $ amount being incorrect, and the account cash balance starts to diverge from that in the QM2007 register.  

I don't know why QM2007 doesn't consistently update the share price field, but it doesn't always happen.  A better way to do the import is to import and use the QM2007 shares/$/commission fields and then calculate the share price.  This method would eliminate the possibility of a faulty QM2007 share price from initiating  this problem.  

One workaround, of course, is to edit the transaction $ value in QM2018 after import, but in 20 years of QM2007 data, just finding all of these instances is a very large task.

Please review this issue and then consider revising the import code to eliminate the problem.  The transaction amount needs to remain sacrosanct so that the cash balance is maintained.  Thanks!
1
1 votes

No Status · Last Updated

Comments

  • mshigginsmshiggins SuperUser ✭✭✭✭✭
    edited March 2018
    Thanks for the suggestion.
    Quicken user since Q1999. Currently using QW2017.
    Questions? Check out the  Quicken Windows FAQ list
  • Scott SchmidtScott Schmidt Member ✭✭
    edited March 2018
    Thanks for the feedback.  I hope that this can be corrected, since it really messes up imported account registers for investment accounts.  Who wouldn't want the old and new balances to match?  I have no idea if the Quicken folks will see this and act on it - I have posted it several times without any feedback, but I'm pretty sure thy would agree that how this works right now is not correct and should be fixed.  The key is getting it to their attention, especially considering all of the other bugs and improvements vying for their time and attention.  Fingers crossed...
  • RickORickO SuperUser ✭✭✭✭✭
    edited November 2019

    Thanks for the feedback.  I hope that this can be corrected, since it really messes up imported account registers for investment accounts.  Who wouldn't want the old and new balances to match?  I have no idea if the Quicken folks will see this and act on it - I have posted it several times without any feedback, but I'm pretty sure thy would agree that how this works right now is not correct and should be fixed.  The key is getting it to their attention, especially considering all of the other bugs and improvements vying for their time and attention.  Fingers crossed...

    Your best bet for the developers to see your notes is to use menu Help > Report a Problem in Quicken.
    Quicken Mac Subscription; Quicken Mac user since the early 90s
Sign In or Register to comment.