Best Of
Re: Any way to set a Reminder for a specific yearly holiday - ie Mothers Day, Veterans Day, etc
Schedule the reminder as monthly and every 12 months (aka a year):
Sherlock
6
Re: Can I change settings to show dividend reinvestments for current investment only?
Several years ago (I believe), the programmers adjusted the Amount Invested parameter to reset to 0 when the entire holding was sold. I am not sure if that "entire" meant all accounts or if each account was treated separately. Apparently (based on your report here) they missed resetting the Amount Reinvested at the same time.
q_lurker
5
Re: Is there an issue with the link between Quicken and Edward Jones?
The problem continues this AM. So, I've just escalated this issue through my contacts at Edward Jones. I've been advised that the technical staff at Edward Jones are actively working on the problem with Quicken and expect it to be resolved by tomorrow at 9AM CT (May 21). Time will tell !
Re: what is the reference column for on the Mac?
So what is the reference column for on the Mac? Are they just a hold over to show data from an older version of Quicken for Mac?
Re: How to setup a mortgage refinance
To set up a refinance mortgage:
- Set up the new mortgage loan for the full amount of the new mortgage.
- After setting it up, go to the Payment Details of the new mortgage loan.
- Click on the Opening Balance transaction category field, click on the down arrow to the right of the category shown and click on "Split".
- Click on the 2nd line of the Split Category popup and enter a transfer to the old mortgage (mortgage name in brackets). Enter the old mortgage current balance for the amount.
- On the 1st line of the Split, change the dollar amount to the difference between the new mortgage amount and the old mortgage current balance amount. The transaction total for both categories in this Split should be equal to the total amount of the new mortgage. (Ex: New mortgage amount = $105,000 and old mortgage current balance amount = $100,000, so enter $5,000 for the amount of the 1st line of this Split category. Total amount of the Splits = $105,000.)
- Click "OK" to close the split category popup and then click "Save" to save the transaction.
- Your old mortgage should now show a current balance of $0.00. You can now go to the old mortgage Account Details and, if you want, on the Display Options tab, close or hide it.
Boatnmaniac
10
My approach to UTX - OTIS - CARR RTN - RTX
So the new modus operandi on this site seems to be - start your own post rather than add on to an existing one on the same topic. Fine. I'll do so rather than add on to
or this post https://community.quicken.com/discussion/7873473/united-technologies-utx-spin-off-and-merger
or this post https://community.quicken.com/discussion/7873688/raytheon-merger-with-united-technologies-question
or this post https://community.quicken.com/discussion/7874649/utx-recently-split-into-rtx-and-otis-and-carrier-utx-name-unchanged-but-rtx-is-the-underlying-stock (which at least got a link to one of the others)
Real world -- in sequence
United Technologies (UTX) spun off Carrier (CARR) and Otis (OTIS), then merged as equals with Raytheon (RTN), then renamed the new combination Raytheon Technologies (RTX). This series seems to have confused a number of users, so I thought I might share my approach. I doing so I further note that there are a lot of flexibility in Quicken and it need not be a one size fits all solution. What I have done fits me. YMMV.
I should note here that I was a current shareholder of Raytheon and a former shareholder of United Technologies at the time of this spinoff-merger sequence.
I'll further note that for this purpose, I am relying on the Form 8937 published by RTX applicable to the two spinoffs. (ref: https://investors.rtx.com/shareowner-services/merger-related-resources) In that document, RTX puts forth fair market values of RTX, CARR and OTIS as $49.93, $16.92, and $47.32 per share, respectively based on the closing values on 4/3/2020, immediately after the spinoffs took place. You or your broker may choose different values and thus achieve slightly different ending values.
One more note, I am using the Quicken Windows subscription version, current release.
Point 1: UTX spins off two other companies - CARR and OTIS. Quicken provides a macro-transction (aka wizard) for corporate spinoffs, but it addresses directly only one company being spunoff. But it turns out, because of the fixes implemented to the spinoff action in recent years, with proper use the spinoff macro-transaction can be applied for multiple spinoffs. That is what I would do and did in a test file.
I first spunoff OTIS from UTX. The shareholder received 0.5 shares of OTIS with a FMV of 47.32/share for every share of UTX held. The corresponding value of remaining part of UTX would have been 49.93 (UTX value) plus 16.92 (CARR value) or $66.85. Parameters for the first spinoff --
Enter Transactions Corporate Spinoff
Transaction date = 4/3/2020
Transaction date = 4/3/2020
Security Name = United Technologies (however you had it named)
New Company = Otis (however you choose to name it)
New Shares Issued = 0.5
Cost per Old Share = $66.85
Cost per New Share = $47.32
I then spun off CARR
Enter Transactions Corporate Spinoff
Transaction date = 4/3/2020
Transaction date = 4/3/2020
Security Name = United Technologies (however you had it named)
New Company = Carrier (however you choose to name it)
New Shares Issued = 1.0
Cost per Old Share = $49.93
Cost per New Share = $16.92
The first series allocated 26.14% of the original UTX basis to the new OTIS holding with the balance of the basis staying with UTX. The second series split the remaining basis between the CARR and UTX matching the basis allocation presented in the Form 8937 -- 55.17% to UTX, 18.69% to CARR, and 26.14% to OTIS. Executing those two spinoffs consecutively on the same date did not create any issues in Quicken as far as I could tell. The program properly managed the changes from the first spinoff when applying the second spinoff.
Those two series create a sequence with respect to UTX of REMOVE SHARES, ADD SHARES, REMOVE SHARES, and ADD SHARES. As the two intermediate are actually extraneous in the end, I chose to delete those sets. The final set of transactions in my file were
REMOVE SHARE of UTX
ADD SHARES of OTIS (one per lot of the original UTX holding)
ADD SHARES of CARRIER (one per lot of the original UTX holding)
ADD SHARES of UTX (one per lot of the original UTX holding)
Perhaps you or your broker chose different fair market values for determining the cost basis allocation. You can certainly do as I did above with your established fair market values, or you can simply use the Form 8937 values and then edit each final ADD SHARES transaction to reflect the applicable cost basis for that lot of that company as determined by your broker. That is one of the positive benefits to Quicken's new algorithm for spinoffs (an algorithm I strongly encouraged them to adopt).
With two "Corporate Spinoff" macro-transactions you have now achieved the necessary spinoffs of Carrier and Otis.
Point 2: Raytheon and United Technologies merge as equals. As a former and not current shareholder of UTX, I chose a non-standard approach here. I wanted to leave my 10-year old historical transactions with United Technologies in tact as they were originally recorded. Therefore, I chose to Edit the security details for UTX by
a) adding a note in the details about the merger into Raytheon Tech in April, 2020, and
b) changing the ticker from "UTX" to "UTX(old)".
In making that ticker change, I chose the options of copying the prices from UTX to UTX(old), and deleting the price history associated with UTX. That way I preserved the price history, but if a future company chooses the UTX ticker some time down the line, my Quicken file will not get entangled by the duplication.
With that approach taken, I then created a new security for Raytheon Technologies (RTX) and proceeded with a standard Corporate Acquisition whereby RTX acquired RTN using the 2.3348 share ratio. As the original Raytheon was then a non-existing company, I retickered it in the same manner I had with UTX -- RTN became RTN(old).
The more normal approach would have been to have UTX acquire RTN (Corporate Acquisition) and then rename UTX to Raytheon Tech (Edit Security Details or Corporate Name Change), and then reticker that security to RTX.
Point 3: By whatever approach you took, you may have fractional shares of RTX or OTIS at that point. Those fractional shares should be sold for the cash-in-lieu amount you received instead of receiving the actual fractional shares.
Further note: If you downloaded transactions from your brokerage, those are likely to not have the correct cost basis information and may be lacking accuracy about individual lots. I would delete any such transactions.
Be sure to create a backup of your data file before venturing into this perhaps new territory.
At the risk of being accused of spamming this site, I am going to post a link this this discussion in those posts cited above. I will choose not to respond in those others posts, so if you want my thoughts, post your questions to me here.
At the risk of being accused of spamming this site, I am going to post a link this this discussion in those posts cited above. I will choose not to respond in those others posts, so if you want my thoughts, post your questions to me here.
q_lurker
9
Re: Home & Business to Deluxe
Yes, you can. Your business accounts will become debit or credit accounts.
Re: Suggestions on learning Quicken 2020 for Mac
The first place to start is the Help menu within Quicken. Here a bunch more resources:
https://community.quicken.com/discussion/7308565/quicken-mac-faq-where-to-find-a-help-guide-for-2016-onward
https://community.quicken.com/discussion/7308565/quicken-mac-faq-where-to-find-a-help-guide-for-2016-onward
RickO
10
Re: I do not use Quicken Cloud Sync; yet I get One Step Update Cloud Sync Errors
The "You need to select accounts to export" error is due to a setting. Go to Edit, Preferences, investing.quicken.com. Portfolio. Select an account to export there.
Bob_L
5
Quicken for Mac v5.15 Released
There are 2 primary changes in v5.15 -- QuickFill Improvements and the new Quicken Bill Manager feature for US Premier members.
QuickFill Improvements
If you read the v5.14 release forum post you would know that the biggest issue brought up by customers was the inability of 5.14 to auto-create/edit a QuickFill memorized transaction with tag and memo fields from the register. We've solved this issue in 5.15 by giving you the flexibility to decide whether you want just the category to be saved or all key fields.
This option appears above the Category field in the register and also appears in the Transaction Details screen when editing details or splits.
This gives you the ability to decide whether or not to save a QuickFIll that contains all fields for a particular transaction or just the category field. We'll remember your last selection.
Also, we changed the behavior of the checkbox in the tab that appears above the category field. The checkbox controls whether or not a QuickFill should be auto-created when editing a transaction. There may be times when you don't want a QuickFill to be remembered because you know that the edits you're making will never be needed again or if you don't want the current QuickFill to be modified. In this case, you can uncheck the checkbox and then Quicken will NOT edit or create a new QuickFill rule with your edits. Previously, Quicken would remember the last thing you did and so in the next transaction you edited, this feature would be off. We decided that it would be better if the ability to create a QuickFill was always on by default allowing you the ability to uncheck this checkbox without any concern for having to remember to turn this back on the next time you edit a transaction. We felt this is what the majority of customers would want and it was too much work for people to constantly be forced to manage this checkbox.
Quicken Bill Manager (For US Premier Customers Only)
Quicken Bill Manager is a new service that allows you to pay online bills directly and on the same day (Quick Pay) or to write and pay checks (Check Pay) all from within Quicken. We've been testing this internally for the past 6 months and I've been a huge user of the feature. I'm the type of person who likes paying off his credit cards immediately as I use them so I don't get into trouble by spending more than I have in my checking account which means I'm always in the mobile apps of each of my credit cards. I also like credit card points so I have lots of credit cards. Now, I can just use Quicken to pay all my bills using the new Quick Pay feature. Go to Bills & Income and click on the Payees tab. Click Add Payees and walkthrough the eBill Payee steps to add payees. I personally added my credit cards.
After you have some eBills added, now you need to set up a Quick Pay payment account. Select the Bill Pay main menu and choose the Add/Edit Payment Account menu item to enable your checking account for Quick Pay.
Walkthrough the steps to enable your account. Once enabled, you can now pay your bills from within Quicken by clicking on the Pay with Quick Pay button or click on the 3 dots to get a menu to give you options to pay a particular bill. The best part of this is that the payment is made immediately.
Check Pay takes a bit more to set-up a payment account because you have to wait a few days for micro-payments to be sent to your account. Once you receive these, you then need to verify the amounts to enable your account for Check Pay. After this, Check Pay works very similar to Quick Pay. For example, if you have a gardner or someone else you have to pay with a check, simply select Pay with Check Pay in the 3 dot menu, fill out the address information, verify the address and then your check will be printed and sent for you. You don't have to pay for postage or anything.
As always, please let us know of any issues you run into with the 5.15 release in this forum post and also let us know if you like or don't like the way we implemented a feature. We're listening and making changes based on your feedback. We can't monitor all of the forum posts but will be looking at this one so please direct feedback here.
Thanks,
The Quicken Mac Team.
UPDATES
2/28 - Shipped 5.15.
2/29 - Stopped the release to assess if there are any major issues.
3/3 - Shipped 5.15.1 with some minor fixes and now we're 100% released with no plans on stopping the rollout unless something comes up.
3/20 - Shipped 5.15.2.
3/27 - Shipped 5.15.3. - Fixed a number of issues we accidentally introduced in 5.15.2 like the 1899 calendar issue, QuickFill rules sometimes not being applied to downloaded transactions and a transaction auto-matching problem.
QuickFill Improvements
If you read the v5.14 release forum post you would know that the biggest issue brought up by customers was the inability of 5.14 to auto-create/edit a QuickFill memorized transaction with tag and memo fields from the register. We've solved this issue in 5.15 by giving you the flexibility to decide whether you want just the category to be saved or all key fields.
This option appears above the Category field in the register and also appears in the Transaction Details screen when editing details or splits.
This gives you the ability to decide whether or not to save a QuickFIll that contains all fields for a particular transaction or just the category field. We'll remember your last selection.
Also, we changed the behavior of the checkbox in the tab that appears above the category field. The checkbox controls whether or not a QuickFill should be auto-created when editing a transaction. There may be times when you don't want a QuickFill to be remembered because you know that the edits you're making will never be needed again or if you don't want the current QuickFill to be modified. In this case, you can uncheck the checkbox and then Quicken will NOT edit or create a new QuickFill rule with your edits. Previously, Quicken would remember the last thing you did and so in the next transaction you edited, this feature would be off. We decided that it would be better if the ability to create a QuickFill was always on by default allowing you the ability to uncheck this checkbox without any concern for having to remember to turn this back on the next time you edit a transaction. We felt this is what the majority of customers would want and it was too much work for people to constantly be forced to manage this checkbox.
Quicken Bill Manager (For US Premier Customers Only)
Quicken Bill Manager is a new service that allows you to pay online bills directly and on the same day (Quick Pay) or to write and pay checks (Check Pay) all from within Quicken. We've been testing this internally for the past 6 months and I've been a huge user of the feature. I'm the type of person who likes paying off his credit cards immediately as I use them so I don't get into trouble by spending more than I have in my checking account which means I'm always in the mobile apps of each of my credit cards. I also like credit card points so I have lots of credit cards. Now, I can just use Quicken to pay all my bills using the new Quick Pay feature. Go to Bills & Income and click on the Payees tab. Click Add Payees and walkthrough the eBill Payee steps to add payees. I personally added my credit cards.
After you have some eBills added, now you need to set up a Quick Pay payment account. Select the Bill Pay main menu and choose the Add/Edit Payment Account menu item to enable your checking account for Quick Pay.
Walkthrough the steps to enable your account. Once enabled, you can now pay your bills from within Quicken by clicking on the Pay with Quick Pay button or click on the 3 dots to get a menu to give you options to pay a particular bill. The best part of this is that the payment is made immediately.
Check Pay takes a bit more to set-up a payment account because you have to wait a few days for micro-payments to be sent to your account. Once you receive these, you then need to verify the amounts to enable your account for Check Pay. After this, Check Pay works very similar to Quick Pay. For example, if you have a gardner or someone else you have to pay with a check, simply select Pay with Check Pay in the 3 dot menu, fill out the address information, verify the address and then your check will be printed and sent for you. You don't have to pay for postage or anything.
As always, please let us know of any issues you run into with the 5.15 release in this forum post and also let us know if you like or don't like the way we implemented a feature. We're listening and making changes based on your feedback. We can't monitor all of the forum posts but will be looking at this one so please direct feedback here.
Thanks,
The Quicken Mac Team.
UPDATES
2/28 - Shipped 5.15.
2/29 - Stopped the release to assess if there are any major issues.
3/3 - Shipped 5.15.1 with some minor fixes and now we're 100% released with no plans on stopping the rollout unless something comes up.
3/20 - Shipped 5.15.2.
3/27 - Shipped 5.15.3. - Fixed a number of issues we accidentally introduced in 5.15.2 like the 1899 calendar issue, QuickFill rules sometimes not being applied to downloaded transactions and a transaction auto-matching problem.
