Understanding investment funds in 2018 vs 2007 on Mac
With 2007, I had an memorized transaction for my paycheck. One component of the split was a transfer to two different mutual funds (with T. Rowe Price).
So, in Checking, there is a transaction with category [TRP Mutual], and value $150.
In the fund register, the transfer is a BUY, with a Transfer of [Checking], Cash Out of $150, Share Price based on the last download, and Shares In of $150/(Share Price). The last two were always incorrect, so once or twice a year I'd go through and correct the actual Share Price and number of Shares.
In 2018, for dates before 5/2017, each of those investments are showing up as two separate BUYS:
- Description: 150 shares @ 1.00, Transfer: Checking, Amount: -150, no Cash Out, no Cash In, an amount of -150, and a balance of 0.00
- Description: the actual number of shares @ the actual price (e.g. 5.585@26.855864), Match Status: Downloaded, Share Balance: increased by actual number of shares, no Cash Out, no Cash In, an amount of -150, and a balance of 0.00.
- Match Status: Downloaded, Descripton: 5.5638@ 26.959991 with amount of -150.00, no change in Balance, no Cash In or Out, Share Balance: increased by 5.5638
- Description: 5.563798 @ 26.960001 with amount of -150, Transfer: Checking, Share Balance: increased by 5.563798, Cash Out: 150.00, Balance: reduced by 150.00.
My questions:
What's going on here?
How is it supposed to work for recording a purchase, using dollars in a different account?
What decides whether or not the Balance changes from a transaction?
Why is the Transfer column hidden by default? Is there really no way to create or change the transfer value from the register? Is the transfer transaction actually linked?
Comments
-
Ah, and since I did the conversion, new paychecks result in a single entry. The one I did today looks like old times, but the one from two weeks ago have 150 Cash Out. It all seems very random.0
-
While not having experience with Q2007, others here have extensive experience & can best reply on the transition to QM18. Transfers to my knowledge cannot be brought over from Q2007; there may be some work arounds that hopefully others can offer.
As far as moving forward make sure the transfer column is showing in the register if you desire having it in the register.0 -
Transfers absolutely do come over from Quicken 2007.Concordman said:While not having experience with Q2007, others here have extensive experience & can best reply on the transition to QM18. Transfers to my knowledge cannot be brought over from Q2007; there may be some work arounds that hopefully others can offer.
As far as moving forward make sure the transfer column is showing in the register if you desire having it in the register.Quicken Mac Subscription • Quicken user since 19930 -
So do splits come over from q2007.Concordman said:While not having experience with Q2007, others here have extensive experience & can best reply on the transition to QM18. Transfers to my knowledge cannot be brought over from Q2007; there may be some work arounds that hopefully others can offer.
As far as moving forward make sure the transfer column is showing in the register if you desire having it in the register.0 -
Yes, they do too...Concordman said:While not having experience with Q2007, others here have extensive experience & can best reply on the transition to QM18. Transfers to my knowledge cannot be brought over from Q2007; there may be some work arounds that hopefully others can offer.
As far as moving forward make sure the transfer column is showing in the register if you desire having it in the register.Have Questions? Help Guide for Quicken for Mac
FAQs: Quicken Mac • Quicken Windows • Quicken Mobile
Add your VOTE to Quicken for Mac Product Ideas
Object to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires(Now Archived, even with over 350 votes!)
(Canadian user since '92, STILL using QM2007)0 -
I was able to get the two big accounts with lots of this stuff at least adding to the right number of shares. And then I can adjust the cash balance to zero.
But just to make sure I understand - If I create a "Sell" transaction in a mutual fund or other investment account, the money from the sell just goes "poof" and disappears. It's up to me to create it is some other place if I want to keep track.
But if I do a "Buy" from my checking account, I end up with a linked account. But the cash value of the investment account changes.
I'm struggling with the consistency of any of this.0 -
Thanks! That does help. So the expected way of doing any buy or sell takes two separate entries, by design. I'm assuming that where it works with a single entry (e.g. when I do a transfer from checking, and buy), while it works, may be a bit risky, and may give odd results.Bryan said:I was able to get the two big accounts with lots of this stuff at least adding to the right number of shares. And then I can adjust the cash balance to zero.
But just to make sure I understand - If I create a "Sell" transaction in a mutual fund or other investment account, the money from the sell just goes "poof" and disappears. It's up to me to create it is some other place if I want to keep track.
But if I do a "Buy" from my checking account, I end up with a linked account. But the cash value of the investment account changes.
I'm struggling with the consistency of any of this.
I'm used to the Transfer being in the Category, and I'm not having that as a choice. But I see that a transfer is actually something that happens in the description, using Transfer:[]. I've still got some paradigm issues to deal with.
On just a regular transfer between, say, a banking and checking account. It looks like you can put a category on a transfer. Why would that be useful?
0