Quicken for Mac 2018 v5.4.x Released

smayer97

John Morrow said:

Transactions move to an unexpected date after matching.

STEPS TO REPRODUCE:
1. Enter transaction manually in the register, set date to 20171211 for example
2. Update account. This downloads (but does not match) a similar transaction. The date is 20171213
3. Drag & drop transaction 2. above on transaction 1. to match
4. The date of the combined transaction switches suddenly, and unexpectedly, to 20180201

NOTES
- This does occur for about half the transactions from the same QFX. I couldn't figure out why
- The "unexpected" date seems to be coming from the <DTPOSTED> QFX tag

<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20180102
<DTUSER>20171213
<TRNAMT>-24.00
<FITID>ce9f946c
<NAME>Le chatham
</STMTTRN>

You have to change your settings and turn off "Use Posted date for ...." :



(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)

John Morrow

I need some advice regarding loan management and maybe there is a bug (or feature).

I have created a new loan, with an opening balance of 120k€. I have also created an asset account to track the asset for the loan. At first, I entered a standalone transaction in the account for the asset to track the value of the asset.

But then I thought these were really the same transaction and should be linked, so I changed the Loan Opening Balance to a Transfer to the asset account. This quickly became a Split in order to record further details. And I also updated the date of LOB.

Probably a bad thing because Quicken promptly created a Balance Adjustment transaction and now my loan doubled in value. (In the database, hopefully not in the real world.)

Is this how Quicken is supposed to behave? Am I doing something wrong? Is changing the LOB transaction not supported yet?

BTW, my attempts at changing the LOB were partially inspired by:
https://www.quicken.com/support/how-do-i-track-refinanced-loan
I know this was written for Quicken Windows, but it should work similarly -eh, better!- on the Mac, shouldn't it?

Snoopy FC

When will amounts/transactions included in hidden accounts be searchable and included in graphs?  With more than 20 years of Quicken data, I've got more than a few accounts that I need data from but don't use regularly (closed accounts).  The only way I know of now to have the transactions of these accounts (particularly investments) reflected in graphs is to maintain them as active on the left sidebar.  Can we add something to the following screen to allow access/updates from these accounts for searching all transactions and presentation on the investment graphs?

It's a pain to activate the account only to allow searching within that account.  Maintaining these as active on the desktop only clutters the account list on the left sidebar.  

RCinNJ

Snoopy FC said:

When will amounts/transactions included in hidden accounts be searchable and included in graphs?  With more than 20 years of Quicken data, I've got more than a few accounts that I need data from but don't use regularly (closed accounts).  The only way I know of now to have the transactions of these accounts (particularly investments) reflected in graphs is to maintain them as active on the left sidebar.  Can we add something to the following screen to allow access/updates from these accounts for searching all transactions and presentation on the investment graphs?

It's a pain to activate the account only to allow searching within that account.  Maintaining these as active on the desktop only clutters the account list on the left sidebar.  

I agree. Why doesn't unchecking "Reports" also include these accounts in searches? More than once I've been looking for transaction history and realized it was probably in a hidden account. Turning accounts off and then hiding again is an unnecessary inconvenience and makes the program less trustworthy..... and who needs an untrustworthy accounting program?

Unknown

Snoopy FC said:

When will amounts/transactions included in hidden accounts be searchable and included in graphs?  With more than 20 years of Quicken data, I've got more than a few accounts that I need data from but don't use regularly (closed accounts).  The only way I know of now to have the transactions of these accounts (particularly investments) reflected in graphs is to maintain them as active on the left sidebar.  Can we add something to the following screen to allow access/updates from these accounts for searching all transactions and presentation on the investment graphs?

It's a pain to activate the account only to allow searching within that account.  Maintaining these as active on the desktop only clutters the account list on the left sidebar.  

And the sole purpose of "hiding" accounts in Quicken Mac is so that they are hidden.  That means "as if they aren't there".  

You want them hidden...but then again, you don't.

Can't have it both ways.  

It works as you like in Quicken Windows...which I find completely unacceptable.  Hidden accounts in QW appear in the drop down lists for reports.  I, personally, hate that and don't feel like scrolling through all those accounts.

So...some people like the idea of NOT seeing hidden accounts in the drop down selection lists.  

Snoopy FC

Snoopy FC said:

When will amounts/transactions included in hidden accounts be searchable and included in graphs?  With more than 20 years of Quicken data, I've got more than a few accounts that I need data from but don't use regularly (closed accounts).  The only way I know of now to have the transactions of these accounts (particularly investments) reflected in graphs is to maintain them as active on the left sidebar.  Can we add something to the following screen to allow access/updates from these accounts for searching all transactions and presentation on the investment graphs?

It's a pain to activate the account only to allow searching within that account.  Maintaining these as active on the desktop only clutters the account list on the left sidebar.  

All I'm hoping for is having the option to set it up however the user sees fit.  I understand why people would want it either way, and I think the user should be able to determine what's most useful.  For my accounts, having data in hidden accounts misrepresents what I actually have (and prevents searching for data in those accounts), and leaving those accounts unhidden simply clutters the account sidebar.  There's got to be a reasonable way to make this work.  

John Morrow

Drag & Drop transactions between Brokerage (and other?) accounts.

STEPS TO REPRODUCE:
1. Add shares into an investment account
2. Dup transaction
3. Drag and Drop to another account -ah, does not work yet alas!

ALTERNATIVE 1
3. Select Brokerage in the side bar
4. Change account for transaction 2. above -does not work either

ALTERNATIVE 2
3. Get Info
4. The account is not displayed and thus cannot be changed

It's so cool to be able to d&d with checking accounts and so sorely missing with brokerage accounts !

RCinNJ

Snoopy FC said:

When will amounts/transactions included in hidden accounts be searchable and included in graphs?  With more than 20 years of Quicken data, I've got more than a few accounts that I need data from but don't use regularly (closed accounts).  The only way I know of now to have the transactions of these accounts (particularly investments) reflected in graphs is to maintain them as active on the left sidebar.  Can we add something to the following screen to allow access/updates from these accounts for searching all transactions and presentation on the investment graphs?

It's a pain to activate the account only to allow searching within that account.  Maintaining these as active on the desktop only clutters the account list on the left sidebar.  

B Hawks wrote: "And the sole purpose of "hiding" accounts in Quicken Mac is so that they are hidden.  That means "as if they aren't there". "

Except the "Hide" menu has two columns. I don't want to always see a closed checking, credit, investments, etc. account in the side bar. However, if I do a search of "All Accounts" and I've chosen to show these accounts in "Reports" I personally think they should be included in the results. For example, I know I paid a vendor in the past and want to see their payment history, I do a search for "All Accounts" and it comes up missing transactions which I "think" should be there (or worse, I don't remember and think these are all of them). Now I have to go searching. I guess you could argue I should run reports, but they are IMHO so broken that I don't have the habit of using them. If some users don't want this I think a check box for this preference makes sense. 

Unknown

Snoopy FC said:

When will amounts/transactions included in hidden accounts be searchable and included in graphs?  With more than 20 years of Quicken data, I've got more than a few accounts that I need data from but don't use regularly (closed accounts).  The only way I know of now to have the transactions of these accounts (particularly investments) reflected in graphs is to maintain them as active on the left sidebar.  Can we add something to the following screen to allow access/updates from these accounts for searching all transactions and presentation on the investment graphs?

It's a pain to activate the account only to allow searching within that account.  Maintaining these as active on the desktop only clutters the account list on the left sidebar.  

Why would you jump to that conclusion?  If it says to include those hidden accounts in Reports, you'll be able to include them in reports...not as a search from the register.

BTW, have you explored using New Reports.  I find that I can create just about any report that I need using that feature, as it allows me to include/exclude accounts, categories and tags to customize any report.  Also allows me to have better control over date ranges and comparison reports.  And I like the auto-save feature of the New Reports.  I have set up and saved about a dozen reports and has made Quicken Mac useable now (along with the workaround for handling transfer transactions).  

You'll find your hidden accounts there.

Also, as I've mentioned before I have Quicken Windows 2017 too.  I hate that I have hidden accounts and then they show up in the account selection for reports.  I have them hidden for a reason.  I don't want to see them.  And I know that if I have to search "way back", I can unhide them.

Same for Quicken Mac.  I on the other side.  I DON'T want to see hidden accounts as a filter choice. 

Unknown

smayer97 (QM2007, CDN user since '92) said:

Interesting times with the release of the Canadian version...Thx.

I posted the following questions here (before these notes), but you have more or less answered the first 2 from that list in your notes. I am posted the rest of them here:

• 2. So essentially the CA version is just the US version with US specific features turned off, based on the Home Currency? Or is there more to it?
• 3. Does the CA "version" of QM2018 include the ability to download from US FI/Banks?
• 4. The US version of QM2018 includes ability to download from CDN FI/Banks. Will this continue to be true?
• 5. The footnotes indicate that Quicken Mobile only works in Canada. Is this a unique version for Canada? Does it not link to US accts?
• 6. I also see that Quicken Mobile is listed to only work with QM2017 and later but the US site lists it as working will all versions of QMac...is there a different versions of QMobile to work with QM2015 and QM2016?
• 7. Is Premium support not available for QM2018 CA like it is for the US? After all, they are effectively the same product (the CA version having reduced functionality)?

Hi, I've been a long time Quicken Windows user (from the DOS days) and was excited when the Quicken for Mac 2018 for Canada was released. I imported my Windows data file and encountered a few issues:
1. the import into Mac messed up my savings accounts as it didn't handle to conversion when you moved money between USD and CAD accounts properly. I did have to fix that manually in all my accounts.
2. security prices are not able to be displayed in CAD. This is highly problematic. A stock such as BMO will use the USD price even if the account is in CAD. Quicken for Windows asks you which stock exchange to use while the Mac version doesn't permit this. It did pick up mutual funds (for example) and got the correct currency. The Quicken chat person wasn't familiar with the product and told me to mention this on this forum. 

Until this is fixed I will be unable to use Quicken for Mac 2018 and will continue to use the Windows version with a VM on my Mac. I'm quite surprised (and disappointed) that this new release hadn't taken care of this properly. I have wasted a lot of time on the import and troubleshooting, and will have to do it again when these bugs are fixed.

smayer97

Snoopy FC said:

When will amounts/transactions included in hidden accounts be searchable and included in graphs?  With more than 20 years of Quicken data, I've got more than a few accounts that I need data from but don't use regularly (closed accounts).  The only way I know of now to have the transactions of these accounts (particularly investments) reflected in graphs is to maintain them as active on the left sidebar.  Can we add something to the following screen to allow access/updates from these accounts for searching all transactions and presentation on the investment graphs?

It's a pain to activate the account only to allow searching within that account.  Maintaining these as active on the desktop only clutters the account list on the left sidebar.  

Meanwhile, you can add your VOTE to 

• Add Option to Search in Hidden Account Registers
• Add Option to Search Invisible and Visible Fields

First, click on each underlined link above to go there, then click VOTE at the top of THAT page, so your will vote count for THAT feature and increase its visibility to the developers by seeking to have the features you need or desire end up in the latest version.

While you are at it, you may want to add your VOTE to related IDEAS found on the List of Requests for Data Entry and Usability Options and Features. Click on the underlined link, then follow the instructions to add your vote to more related ideas. Your VOTES matter!

(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)

smayer97

John Morrow said:

Drag & Drop transactions between Brokerage (and other?) accounts.

STEPS TO REPRODUCE:
1. Add shares into an investment account
2. Dup transaction
3. Drag and Drop to another account -ah, does not work yet alas!

ALTERNATIVE 1
3. Select Brokerage in the side bar
4. Change account for transaction 2. above -does not work either

ALTERNATIVE 2
3. Get Info
4. The account is not displayed and thus cannot be changed

It's so cool to be able to d&d with checking accounts and so sorely missing with brokerage accounts !

Drag and drop would be cool between investment accounts but I suspect this would be quite challenging to implement, given lots assignments and other tax implications...

Alternatively, you can add your VOTE to Add Ability to Transfer Shares between Investment Accounts.

First, click on the underlined link above to go there, then click VOTE at the top of THAT page, so your will vote count for THIS feature and increase its visibility to the developers by seeking to have the features you need or desire end up in the latest version.

While you are at it, you may want to add your VOTE to related IDEAS found on the List of Requests Related to Investments. Click on the underlined link, then follow the instructions to add your vote to more related ideas. Your VOTES matter!

(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)

Unknown

When selecting the Investing tab, the portfolio view takes about 30 seconds to display with the spinning beach ball. The 2017 version of the portfolio view displayed around 5 seconds. The portfolio is unusable with this delay. Also, Quicken 2018 for windows displays the portfolio instantly running VMWARE.

Try adding the "Day Gain Loss " and "Day Gain Loss %" columns to the "Performance" table view. No results display. Works when these columns are added to the "Portfolio Value" view.

smayer97

Batman said:

When selecting the Investing tab, the portfolio view takes about 30 seconds to display with the spinning beach ball. The 2017 version of the portfolio view displayed around 5 seconds. The portfolio is unusable with this delay. Also, Quicken 2018 for windows displays the portfolio instantly running VMWARE.

Try adding the "Day Gain Loss " and "Day Gain Loss %" columns to the "Performance" table view. No results display. Works when these columns are added to the "Portfolio Value" view.

Slowness is a known issue...work-around is to hide the graph (grab window divider and drag it to collapse window split) and only open the graph part of the window when you really want it.

(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)

Craig in ER

Batman said:

When selecting the Investing tab, the portfolio view takes about 30 seconds to display with the spinning beach ball. The 2017 version of the portfolio view displayed around 5 seconds. The portfolio is unusable with this delay. Also, Quicken 2018 for windows displays the portfolio instantly running VMWARE.

Try adding the "Day Gain Loss " and "Day Gain Loss %" columns to the "Performance" table view. No results display. Works when these columns are added to the "Portfolio Value" view.

Thanks for reminding me how to hide the rather useless (to me) graph in portfolio view.  Another issue with the Investing Portfolio is I often get the message "This portfolio has no securities or cash."  I have to click an account under the Investing tab to show the securities and then click the Investing tab.  After doing that the full portfolio populates. This is a bug that was not present - or I never experienced in Q 2017.

Craig in ER

Snoopy FC said:

When will amounts/transactions included in hidden accounts be searchable and included in graphs?  With more than 20 years of Quicken data, I've got more than a few accounts that I need data from but don't use regularly (closed accounts).  The only way I know of now to have the transactions of these accounts (particularly investments) reflected in graphs is to maintain them as active on the left sidebar.  Can we add something to the following screen to allow access/updates from these accounts for searching all transactions and presentation on the investment graphs?

It's a pain to activate the account only to allow searching within that account.  Maintaining these as active on the desktop only clutters the account list on the left sidebar.  

One more feature I would like to see return to Quicken is Universal Search.  That is to be able to search for a transaction in all of the account registers beginning with the current account from one search box.  As it is we have to search one account at a time - very tedious.  Quicken 2007 had a decent universal search function.

Concordman

Snoopy FC said:

When will amounts/transactions included in hidden accounts be searchable and included in graphs?  With more than 20 years of Quicken data, I've got more than a few accounts that I need data from but don't use regularly (closed accounts).  The only way I know of now to have the transactions of these accounts (particularly investments) reflected in graphs is to maintain them as active on the left sidebar.  Can we add something to the following screen to allow access/updates from these accounts for searching all transactions and presentation on the investment graphs?

It's a pain to activate the account only to allow searching within that account.  Maintaining these as active on the desktop only clutters the account list on the left sidebar.  

In the sidebar if you if you select all transactions you are able to search all banking & credit card accounts..WIl not search Investment registers. Select Investing & you can search all those accounts. Not exactly what you want but it least it is a partial to your request

Craig in ER

Snoopy FC said:

When will amounts/transactions included in hidden accounts be searchable and included in graphs?  With more than 20 years of Quicken data, I've got more than a few accounts that I need data from but don't use regularly (closed accounts).  The only way I know of now to have the transactions of these accounts (particularly investments) reflected in graphs is to maintain them as active on the left sidebar.  Can we add something to the following screen to allow access/updates from these accounts for searching all transactions and presentation on the investment graphs?

It's a pain to activate the account only to allow searching within that account.  Maintaining these as active on the desktop only clutters the account list on the left sidebar.  

Thanks for the helpful information - I will use that!   I think that will be close enough for the type of searching I will need to do.  I was trying to use the "Find" item in the "Edit" menu and was getting no where.

Craig in ER

Snoopy FC said:

When will amounts/transactions included in hidden accounts be searchable and included in graphs?  With more than 20 years of Quicken data, I've got more than a few accounts that I need data from but don't use regularly (closed accounts).  The only way I know of now to have the transactions of these accounts (particularly investments) reflected in graphs is to maintain them as active on the left sidebar.  Can we add something to the following screen to allow access/updates from these accounts for searching all transactions and presentation on the investment graphs?

It's a pain to activate the account only to allow searching within that account.  Maintaining these as active on the desktop only clutters the account list on the left sidebar.  

Got it!  Great and helpful tips.  This will work for the "universal" search I was looking for.  You saved me a lot of time.

Snoopy FC

Snoopy FC said:

When will amounts/transactions included in hidden accounts be searchable and included in graphs?  With more than 20 years of Quicken data, I've got more than a few accounts that I need data from but don't use regularly (closed accounts).  The only way I know of now to have the transactions of these accounts (particularly investments) reflected in graphs is to maintain them as active on the left sidebar.  Can we add something to the following screen to allow access/updates from these accounts for searching all transactions and presentation on the investment graphs?

It's a pain to activate the account only to allow searching within that account.  Maintaining these as active on the desktop only clutters the account list on the left sidebar.  

As I noted elsewhere, anything in a account that you have hidden, will also be hidden if you try to search "All Transactions."  I think they need to allow us the option to search for transactions even if they're in hidden accounts.    

smayer97

Snoopy FC said:

When will amounts/transactions included in hidden accounts be searchable and included in graphs?  With more than 20 years of Quicken data, I've got more than a few accounts that I need data from but don't use regularly (closed accounts).  The only way I know of now to have the transactions of these accounts (particularly investments) reflected in graphs is to maintain them as active on the left sidebar.  Can we add something to the following screen to allow access/updates from these accounts for searching all transactions and presentation on the investment graphs?

It's a pain to activate the account only to allow searching within that account.  Maintaining these as active on the desktop only clutters the account list on the left sidebar.  

If you have not already, remember that you can add your VOTE to links found at the post above, here:
https://getsatisfaction.com/quickencommunity/topics/quicken-for-mac-2018-v5-4-x-released?topic-reply...

(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)

smayer97

Snoopy FC said:

When will amounts/transactions included in hidden accounts be searchable and included in graphs?  With more than 20 years of Quicken data, I've got more than a few accounts that I need data from but don't use regularly (closed accounts).  The only way I know of now to have the transactions of these accounts (particularly investments) reflected in graphs is to maintain them as active on the left sidebar.  Can we add something to the following screen to allow access/updates from these accounts for searching all transactions and presentation on the investment graphs?

It's a pain to activate the account only to allow searching within that account.  Maintaining these as active on the desktop only clutters the account list on the left sidebar.  

Another thing to keep in mind is that the universal search is still incomplete...in QM2007 you can also perform a global Find and Replace. Though you can do that in the latest versions of QMac, the "new FInd and Replace" will NOT perform the changes in split transactions. For that, Meanwhile, you can add your VOTE to Improve Batch Editing to include changing Split transactions.

First, click on each underlined link above to go there, then click VOTE at the top of THAT page, so your will vote count for THAT feature and increase its visibility to the developers by seeking to have the features you need or desire end up in the latest version.

While you are at it, you may want to add your VOTE to related IDEAS found on the List of Requests for Data Entry and Usability Options and Features. Click on the underlined link, then follow the instructions to add your vote to more related ideas. Your VOTES matter!

(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)

 

smayer97

Scott Schmidt said:

Can this be FIXED soon?

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.

You are correct. But it doesn't take an "incorrect" share price to trigger the problem.

When entering investment transactions in Quicken 2007, number of shares, share price, commission, and total cost are equally important. Enter any three numbers and Quicken will calculate the other value. 

And, Q2007 will accept a transaction if the math works with rounding. For example, consider a mutual fund purchase of $5,000, where the closing NAV was $48.74. The mutual fund company will take $5,000 divided by $48.74 equals 102.5851, which the fund company rounds to 102.585 shares. Quicken would allow the transaction to be entered as Buy 102.585 shares at $48.74, for $5,000 total.

In Quicken 2016 and later, the share price is a derived field: transaction cost divided by number of shares gives the share price, to 6 decimal places, far more than the stock market actually supports. In Quicken 2018 you can't even enter the share price in a transaction. If the above transaction were originally entered in Q2018, it would calculate $5,000 cost divided by 102.585 shares equals $48.740069 share price.  

What is happening on the import is bizarre:

1. The import completely ignores the total transaction cost that was entered in Q2007.
   
2. It calculates a new, bogus total transaction cost: number of shares times the share price that was in the Q2007 transaction.
   
3. Then it takes the total transaction cost that it fabricated, which may not match the actual transaction, and uses that to derive a new share price: total transaction cost divided by number of shares, to 6 decimal places.

In the example above, it would first calculate a transaction cost of 102.585 shares times $48.74 equals $4,999.99. Then use that to derive new price: $4,999.99 divided by 102.585 is $48.739972. Which isn't even the share price that the same transaction would calculate if it were originally entered in Q2018!

The major error here is that Quicken is forgetting that total cost should be sacrosanct on the import, since that's what determines your cash balance. So if you have an account with a lot of history, the errors accumulate, until the account balance is wildly off.

I have reported this bug to Intuit, and now Quicken, on every beta test since the new Quicken started supporting investment transactions. It is one of many data loss issues that are blocking me from upgrading.Beta is a good place to bring up these issues. I would also suggest you post this issue in the forum as a Problem as its won thread and direct anyone with a similar problem to then go to that thread and click ME TOO. This will also raise visibility to the issue, at least in this forum.

And if you have not done so already, use the Report a Problem menu in Quicken to also submit this problem.

I have also cross-referenced this post (as a placeholder for now) in the 

• List of Obstacles and Hindrances for Migrating from QM2007 or QWin to Quicken for Mac

If you create that new thread, I will update the list with that new entry.

(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)

Quicken Marcus

rangersix said:

I just upgraded to Quicken for Mac 2018 v5.4.x and now I get this error all the time. This account does not to be updated it's just the value of my house and I input that manually.

Paul, Thanks for the suggestion about copy and I think RickO's solution would be an OK workaround for now.

In regards to the Balance question, are you saying the balance number doesn't appear but the column header does?  This typically happens when the sort order is not based on the date.   The people who designed the Mac product many years ago decided not to show the balance if the sort order was based on anything but the date since it isn't matching one's bank's transaction list but I'm not sure this was the right decision.  We get support calls on it.  Also, Quicken Windows shows the balance independent of the sort order.  Anyway, that's the reason it's that way.  What do other people think?  Should we always display the balance?

J_Mike

rangersix said:

I just upgraded to Quicken for Mac 2018 v5.4.x and now I get this error all the time. This account does not to be updated it's just the value of my house and I input that manually.

Re: Balance Column

I think you should keep it as it is. 

No balance is an immediate clue that the register is not in its' "normal" configuration.

The same users who have difficulty grasping the significance of no balance will also have difficulty figuring out why their balance is all 'wonky'. An incorrect or meaningless balance due to filtering or sorting is more likely to cause those same users serious problems such as overdraft, etc.

It ain't broke - don't fix it :<))

jacobs

Scott Schmidt said:

Can this be FIXED soon?

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.

You are correct. But it doesn't take an "incorrect" share price to trigger the problem.

When entering investment transactions in Quicken 2007, number of shares, share price, commission, and total cost are equally important. Enter any three numbers and Quicken will calculate the other value. 

And, Q2007 will accept a transaction if the math works with rounding. For example, consider a mutual fund purchase of $5,000, where the closing NAV was $48.74. The mutual fund company will take $5,000 divided by $48.74 equals 102.5851, which the fund company rounds to 102.585 shares. Quicken would allow the transaction to be entered as Buy 102.585 shares at $48.74, for $5,000 total.

In Quicken 2016 and later, the share price is a derived field: transaction cost divided by number of shares gives the share price, to 6 decimal places, far more than the stock market actually supports. In Quicken 2018 you can't even enter the share price in a transaction. If the above transaction were originally entered in Q2018, it would calculate $5,000 cost divided by 102.585 shares equals $48.740069 share price.  

What is happening on the import is bizarre:

1. The import completely ignores the total transaction cost that was entered in Q2007.
   
2. It calculates a new, bogus total transaction cost: number of shares times the share price that was in the Q2007 transaction.
   
3. Then it takes the total transaction cost that it fabricated, which may not match the actual transaction, and uses that to derive a new share price: total transaction cost divided by number of shares, to 6 decimal places.

In the example above, it would first calculate a transaction cost of 102.585 shares times $48.74 equals $4,999.99. Then use that to derive new price: $4,999.99 divided by 102.585 is $48.739972. Which isn't even the share price that the same transaction would calculate if it were originally entered in Q2018!

The major error here is that Quicken is forgetting that total cost should be sacrosanct on the import, since that's what determines your cash balance. So if you have an account with a lot of history, the errors accumulate, until the account balance is wildly off.

I have reported this bug to Intuit, and now Quicken, on every beta test since the new Quicken started supporting investment transactions. It is one of many data loss issues that are blocking me from upgrading.Yes, this has been a longstanding problem since the initial "modern" Quicken Mac rolled out as Quicken 2015. It has been ignored by the developers in comments posted in both this forum and in beta testing reporting. They seem to think they created a "better way" to do the math, when mathematically precise is sometimes not correct, and therefore doesn't precisely match the way users have handled their transactions in legacy Quicken Mac products.

Here's my example to add to Scott's above: In Quicken 2007 and earlier, when entering investment transactions, I would often use the Commission field to add or subtract one or two cents to make my transactions work due to rounding. Vanguard funds, for instance, work to three decimal places for shares, meaning a sale or purchase of the reported number of shares at the reported share price would sometimes result in a $5,000 purchase actually showing up as $4,999.99. To get my cash balance correct, I'd record the transaction with plus or minus a penny of commission so the total cost was $5,000. I never cared about the couple cents of positive or negative "commission" at the end of the year, but everything worked to perfection for two decades. But when I import my Quicken 2007 data file into any of the modern Quicken versions, despite my crude method of avoiding rounding issues, the program changes the share price to a different value than the actual share price -- e.g. instead of a share price of $56.94, Quicken 2015-18 in its infinite wisdom record a share price of $56.939598 -- meaning I can't trust Quicken's calculations about gains to be precise. Close enough for tracking or financial planning; probably not accurate enough for IRS reporting.

Quicken Marcus

RickO said:

Marcus... some nice additions here. There are some cosmetic problems with the new ability to customize Transaction Report columns:

1) The placement of the column customization is not consistent with other parts of the program. Here it is within Customize settings. In other places (e.g.. Portfolio View), there is a Columns button  on the row of buttons at the top. Other places, you can also right click on the column headers to choose columns. Both of the latter options would be preferred.

2) The Notes column should properly be called Memo/Notes to agree with the registers.

3) When you add a column such as Memo/Notes, it gets added quite wide which pushes the Amount column off screen to the right. That might not be such a problem as long as the user notices and resizes columns. But... the column width settings don't stick; they again become very wide as soon as you leave the report and return to it.

4) What is the ATTM column? That's not a column in a transaction register. Is it a misnomer for something else?

One more suggestion: (and this applies throughout the program)... In other Mac programs there is sometimes a convention that shift-clicking or command-clicking on a disclosure triangle will collapse all (if you click on an open one), or expand all (if you click on a closed one). That would be very helpful throughout Quicken. This could also be accomplished with little Expand All and Collapse All buttons on the button row.

Ugh.  Thanks, Craig.  We'll get that fixed.

smayer97

rangersix said:

I just upgraded to Quicken for Mac 2018 v5.4.x and now I get this error all the time. This account does not to be updated it's just the value of my house and I input that manually.

Agreed...you may help one group but end up with another group confused (or even the same group)...if anything, you may simple want to display a dialogue box that shows up when they change the sort order to anything but the date, warning users that the balance can only be shown when sorted by date, with a check box option to no longer show this dialogue box. 

OR if you do go the QWin route, then still use an optional dialog box to warn that the running balance may not match their statement unless sorted by date.

smayer97

smayer97 (QM2007, CDN user since '92) said:

Interesting times with the release of the Canadian version...Thx.

I posted the following questions here (before these notes), but you have more or less answered the first 2 from that list in your notes. I am posted the rest of them here:

• 2. So essentially the CA version is just the US version with US specific features turned off, based on the Home Currency? Or is there more to it?
• 3. Does the CA "version" of QM2018 include the ability to download from US FI/Banks?
• 4. The US version of QM2018 includes ability to download from CDN FI/Banks. Will this continue to be true?
• 5. The footnotes indicate that Quicken Mobile only works in Canada. Is this a unique version for Canada? Does it not link to US accts?
• 6. I also see that Quicken Mobile is listed to only work with QM2017 and later but the US site lists it as working will all versions of QMac...is there a different versions of QMobile to work with QM2015 and QM2016?
• 7. Is Premium support not available for QM2018 CA like it is for the US? After all, they are effectively the same product (the CA version having reduced functionality)?

@Quicken Marcus, can you please still address 1) and 2) for clarity? there are users that ask about migration to QM2018-CA and want to be sure that they are correctly informed. 

Quicken Marcus

D H Grif said:

I am using 2018 for MAC. The budgeting does not work. Even editing will not list all the income or expenses. It is totally worthless. I have used Quicken for over twenty years. This is by far the most frustrating issue I have ever come across. 

Investment transactions are very different than your typical banking register transactions and similarly, the categories are different.  Architecturally the budget is tied to the banking transactions and not investments so there's a bunch of work we have to do to make investments work also.  If it was easy we would have done it already.  There's also a bunch of work being done on budgets for the Quicken Cloud so from a timing perspective we don't want to completely overhaul our budget infrastructure to support investments only to find out we have to do it again to support the new Quicken cloud.   That's probably too much information but thought I would provide a detailed explanation to help clarify the trade-offs we're making and the timing.