Miscellaneous Quicken Questions
Re: Miscellaneous Quicken Questions
That is fine as long as you do not change your mind several years down the road. I am not certain the specific years but I recall having not upgraded for many years, and when I did do so, I had to find an intermediate conversion in order to get up to date. I recall it was not overly difficult but it told me not to get too far behind.
For example purposes only, say you were using Quicken 99 and your new OS on your new PC in 2013 was not compatible with Quicken 99. You could not necessarily upgrade to Quicken 2013 and have it convert your Quicken 99 files. You might have to convert the Quicken 99 files to Quicken 2005 files first, and then to Quicken 2013.
For example purposes only, say you were using Quicken 99 and your new OS on your new PC in 2013 was not compatible with Quicken 99. You could not necessarily upgrade to Quicken 2013 and have it convert your Quicken 99 files. You might have to convert the Quicken 99 files to Quicken 2005 files first, and then to Quicken 2013.
finiki, the Canadian financial wiki The go-to place to bolster your financial freedom
Re: Miscellaneous Quicken Questions
I recently started buying US equities in my TD Canadian SD RRSP and it doesn't look as if US stocks appear in Quicken on the dropdown box of a $CAN RRSP account.
Do I have to open a separate investment account (rather than a retirement account) to track dividends, etc in US stocks? I've been doing that anyway in my RBC accounts, because RBC separates CAN and US investments, but TD doesn't. It exchanges all $US dividends in my (self-directed) RRSP to $CAN automatically and records the total in $CAN. How can I best record this in Quicken?
Do I have to open a separate investment account (rather than a retirement account) to track dividends, etc in US stocks? I've been doing that anyway in my RBC accounts, because RBC separates CAN and US investments, but TD doesn't. It exchanges all $US dividends in my (self-directed) RRSP to $CAN automatically and records the total in $CAN. How can I best record this in Quicken?
"Why do I have to go to school? If I watch YouTube I'll know everything."
- Grandson #2
- Grandson #2
Re: Miscellaneous Quicken Questions
All my securities in Quicken are set up manually.
finiki, the Canadian financial wiki
“It doesn't matter how beautiful your theory is, it doesn't matter how smart you are. If it doesn't agree with experiment, it's wrong.” [Richard P. Feynman, Nobel prize winner]
“It doesn't matter how beautiful your theory is, it doesn't matter how smart you are. If it doesn't agree with experiment, it's wrong.” [Richard P. Feynman, Nobel prize winner]
Re: Miscellaneous Quicken Questions
I use two separate Quicken accounts to track one TDW RRSP account.
Account #1: CAD$ holdings
Account #2: US$ holdings
I record US$ dividends in US account, then do XOut to Canadian account. Quicken prompts for exchange rate when you save the XOut transaction. You have to enter the correct rate so the number on the Canadian side matches TDW records.
Account #1: CAD$ holdings
Account #2: US$ holdings
I record US$ dividends in US account, then do XOut to Canadian account. Quicken prompts for exchange rate when you save the XOut transaction. You have to enter the correct rate so the number on the Canadian side matches TDW records.
Re: Miscellaneous Quicken Questions
This is also exactly how I do it. The US$ account will then offer-up the US-listed securities.ig17 wrote:I use two separate Quicken accounts to track one TDW RRSP account.
Peter
Patrick Hutber: Improvement means deterioration
Patrick Hutber: Improvement means deterioration
Re: Miscellaneous Quicken Questions
Another tip about this setup. I use a pair of Bought/SoldX transactions to record Norbert's Gambit.
Going from CAD to USD, I enter this in the CAD$ account:
Bought 100 shares @ price X
SoldX 100 shares @ the same price X. Proceeds go to the US$ account.
Quicken prompts for the exchange rate when you save SoldX. I enter my effective gambitted rate.
Going from CAD to USD, I enter this in the CAD$ account:
Bought 100 shares @ price X
SoldX 100 shares @ the same price X. Proceeds go to the US$ account.
Quicken prompts for the exchange rate when you save SoldX. I enter my effective gambitted rate.
Re: Miscellaneous Quicken Questions
Thanks all. That was the setup I ended up with. Glad I'm not missing anything.
Ig17, thanks for the tip. what company do you use for Norbert's gambit? I'll be doing it for the first time in the next week or so. (Thanks Norbert)
I haven't owned US shares for many years while the $US was falling against $CAN. Now that the US is recovering and the $CAN is likely to fall, it seems a better time to do it.
Ig17, thanks for the tip. what company do you use for Norbert's gambit? I'll be doing it for the first time in the next week or so. (Thanks Norbert)
I haven't owned US shares for many years while the $US was falling against $CAN. Now that the US is recovering and the $CAN is likely to fall, it seems a better time to do it.
"Why do I have to go to school? If I watch YouTube I'll know everything."
- Grandson #2
- Grandson #2
Re: Miscellaneous Quicken Questions
I use resource stocks that trade millions of shares a day on both exchanges. Potash, Encana, Suncor, Canadian Natural Resources. These can be quite volatile so you have to be careful. I watch the trend before I pull the trigger. I try to catch a stock in an uptrend.Wallace wrote:what company do you use for Norbert's gambit?
Many posters seem to prefer less volatile stocks such as banks and railroads.
- Peculiar_Investor
- Administrator
- Posts: 13267
- Joined: 01 Mar 2005 14:52
- Location: Calgary
- Contact:
Re: Miscellaneous Quicken Questions
Using Quicken 2013 Home and Business and doing some tax planning. So I ran the Schedule 3 - Capital Gains report.
I'm not sure if surprised is the right word, maybe disappointed is better. WTF is the Canadian version of Quicken showing Short Term and Long Term sections of the report, with no option to Customize and get rid of this American behaviour .
I'm not sure if surprised is the right word, maybe disappointed is better. WTF is the Canadian version of Quicken showing Short Term and Long Term sections of the report, with no option to Customize and get rid of this American behaviour .
finiki, the Canadian financial wiki New editors wanted and welcomed, please help collaborate and improve the wiki.
Normal people… believe that if it ain’t broke, don’t fix it. Engineers believe that if it ain’t broke, it doesn’t have enough features yet. – Scott Adams
Normal people… believe that if it ain’t broke, don’t fix it. Engineers believe that if it ain’t broke, it doesn’t have enough features yet. – Scott Adams
Re: Miscellaneous Quicken Questions
To my knowledge, it has always been this way. IOW, I think they only change (from USian version) the things people are likely to use/notice most.
finiki, the Canadian financial wiki The go-to place to bolster your financial freedom
-
- Veteran Contributor
- Posts: 3385
- Joined: 27 May 2008 16:25
Re: Miscellaneous Quicken Questions
Don't forget that in the CG report, for US securities you need to check the "use transaction currency" option for proper calculations.Peculiar_Investor wrote:Using Quicken 2013 Home and Business and doing some tax planning. So I ran the Schedule 3 - Capital Gains report.
I'm not sure if surprised is the right word, maybe disappointed is better. WTF is the Canadian version of Quicken showing Short Term and Long Term sections of the report, with no option to Customize and get rid of this American behaviour .
Re: Miscellaneous Quicken Questions
It depends on how you enter the transactions and which forex rate you use in reporting.queerasmoi wrote:Don't forget that in the CG report, for US securities you need to check the "use transaction currency" option for proper calculations.
Different strokes for different folks.
finiki, the Canadian financial wiki
“It doesn't matter how beautiful your theory is, it doesn't matter how smart you are. If it doesn't agree with experiment, it's wrong.” [Richard P. Feynman, Nobel prize winner]
“It doesn't matter how beautiful your theory is, it doesn't matter how smart you are. If it doesn't agree with experiment, it's wrong.” [Richard P. Feynman, Nobel prize winner]
-
- Veteran Contributor
- Posts: 3385
- Joined: 27 May 2008 16:25
Re: Miscellaneous Quicken Questions
I know the two typical ways to track ACB with forex is either a per-transaction rate, or an average annual exchange rate. My understanding is, if you don't check "use transaction currency", it uses the US$ value to calculate ACB throughout the period of holding the securities. I believe that would produce incorrect results no matter which approach you use.adrian2 wrote:It depends on how you enter the transactions and which forex rate you use in reporting.queerasmoi wrote:Don't forget that in the CG report, for US securities you need to check the "use transaction currency" option for proper calculations.
Different strokes for different folks.
Re: Miscellaneous Quicken Questions
I use the average annual forex and I convert the values from USD to CAD myself, for each transaction.queerasmoi wrote:I know the two typical ways to track ACB with forex is either a per-transaction rate, or an average annual exchange rate. My understanding is, if you don't check "use transaction currency", it uses the US$ value to calculate ACB throughout the period of holding the securities. I believe that would produce incorrect results no matter which approach you use.adrian2 wrote:It depends on how you enter the transactions and which forex rate you use in reporting.queerasmoi wrote:Don't forget that in the CG report, for US securities you need to check the "use transaction currency" option for proper calculations.
Different strokes for different folks.
I do not use automatic updates of security prices, as I don't want "junk" accumulating in my file; if I need prices, I update them myself.
Therefore, I don't need to check "use transaction currency".
finiki, the Canadian financial wiki
“It doesn't matter how beautiful your theory is, it doesn't matter how smart you are. If it doesn't agree with experiment, it's wrong.” [Richard P. Feynman, Nobel prize winner]
“It doesn't matter how beautiful your theory is, it doesn't matter how smart you are. If it doesn't agree with experiment, it's wrong.” [Richard P. Feynman, Nobel prize winner]
-
- Veteran Contributor
- Posts: 3385
- Joined: 27 May 2008 16:25
Re: Miscellaneous Quicken Questions
So what you're saying is, you convert the values from USD to CAD yourself for each transaction, and record 100% of your transactions in Quicken in CAD?adrian2 wrote:
I use the average annual forex and I convert the values from USD to CAD myself, for each transaction.
I do not use automatic updates of security prices, as I don't want "junk" accumulating in my file; if I need prices, I update them myself.
Therefore, I don't need to check "use transaction currency".
Otherwise I am not sure I understand how you record your USD transactions in such a way that Quicken would give a correct CG report without "use transaction currency".
The minimal case I'm imagining here is, suppose you buy 100 shares of security A in year X for US$20, and sell it in year Y also for US$20. However in year X, US$1=CAD$0.95, and in year Y, US$1=CAD$1.05. So a correct accounting for this would see a capital gain of CAD$200. If "use transaction currency" is disabled, Quicken's CG report will give a $0 CG.
Re: Miscellaneous Quicken Questions
Exactly.queerasmoi wrote:So what you're saying is, you convert the values from USD to CAD yourself for each transaction, and record 100% of your transactions in Quicken in CAD?
finiki, the Canadian financial wiki
“It doesn't matter how beautiful your theory is, it doesn't matter how smart you are. If it doesn't agree with experiment, it's wrong.” [Richard P. Feynman, Nobel prize winner]
“It doesn't matter how beautiful your theory is, it doesn't matter how smart you are. If it doesn't agree with experiment, it's wrong.” [Richard P. Feynman, Nobel prize winner]
-
- Veteran Contributor
- Posts: 3385
- Joined: 27 May 2008 16:25
Re: Miscellaneous Quicken Questions
Okay, so let me revise my previous statement, since your method of record-keeping does not record your US$ securities in US$.adrian2 wrote:Exactly.queerasmoi wrote:So what you're saying is, you convert the values from USD to CAD yourself for each transaction, and record 100% of your transactions in Quicken in CAD?
Don't forget that in the CG report, for securities you record in US$ you need to check the "use transaction currency" option for proper calculations.
Re: Miscellaneous Quicken Questions
A similar statement applies to Investment Performance report.queerasmoi wrote:Don't forget that in the CG report, for securities you record in US$ you need to check the "use transaction currency" option for proper calculations.
If you want to calculate an accurate IRR number (why wouldn't you? ), check "Transaction Exchange Rate" option in the Customize dialog.
Re: Miscellaneous Quicken Questions
I have an RRSP account which I track in Quicken. A while ago I made several purchases of US stocks in this account. I realize that my amounts are not being accurately tracked. So I have set up a RRSP US$ account. How do I transfer the pertinent transactions? Do I have to re-enter them all and delete from the Cdn $ account?
Re: Miscellaneous Quicken Questions
This is how I split my accounts as I have not found any other way to manage dual currencies. You will have to re-enter your initial transactions because the ones in your CDN dollar account cannot be switched to a USD account. You will notice stocks will not even show up in the drop down if the currency does not match the account currency.tedster wrote:I have an RRSP account which I track in Quicken. A while ago I made several purchases of US stocks in this account. I realize that my amounts are not being accurately tracked. So I have set up a RRSP US$ account. How do I transfer the pertinent transactions? Do I have to re-enter them all and delete from the Cdn $ account?
--
Ignorance is where learning begins.
Ignorance is where learning begins.
Re: Miscellaneous Quicken Questions
This pertains to how to make a particular entry in Quicken. I have Quicken 2011 and enter all my data manually.
Some iShares for some years issue reinvested distributions. These are not cash payments nor do they result in the issue of more shares. For tax purposes they result in an increase in the ACB.
In the past I recorded this in Quicken as a -ve ROC. But for the last two tax years Quicken will not accept a -ve amount as a ROC.
My question is how do others account for these reinvested distributions in Quicken?
I also keep an Excel file for ACB and have correctly allowed for it there but would like to get my Quicken file correctly identifying this item.
Some iShares for some years issue reinvested distributions. These are not cash payments nor do they result in the issue of more shares. For tax purposes they result in an increase in the ACB.
In the past I recorded this in Quicken as a -ve ROC. But for the last two tax years Quicken will not accept a -ve amount as a ROC.
My question is how do others account for these reinvested distributions in Quicken?
I also keep an Excel file for ACB and have correctly allowed for it there but would like to get my Quicken file correctly identifying this item.
" A verbal contract isn't worth the paper it is written on " Samuel Goldwyn
"The light at the end of the tunnel may be a freight train coming your way" Metallica - No Leaf Clover
"The light at the end of the tunnel may be a freight train coming your way" Metallica - No Leaf Clover
Re: Miscellaneous Quicken Questions
Enter the ROC as positive $1.CROCKD wrote:This pertains to how to make a particular entry in Quicken. I have Quicken 2011 and enter all my data manually.
Some iShares for some years issue reinvested distributions. These are not cash payments nor do they result in the issue of more shares. For tax purposes they result in an increase in the ACB.
In the past I recorded this in Quicken as a -ve ROC. But for the last two tax years Quicken will not accept a -ve amount as a ROC.
My question is how do others account for these reinvested distributions in Quicken?
Save the entry, then go back and edit it: you'll now be able to save it as a negative amount.
finiki, the Canadian financial wiki
“It doesn't matter how beautiful your theory is, it doesn't matter how smart you are. If it doesn't agree with experiment, it's wrong.” [Richard P. Feynman, Nobel prize winner]
“It doesn't matter how beautiful your theory is, it doesn't matter how smart you are. If it doesn't agree with experiment, it's wrong.” [Richard P. Feynman, Nobel prize winner]
Re: Miscellaneous Quicken Questions
Thank you Adrian.
" A verbal contract isn't worth the paper it is written on " Samuel Goldwyn
"The light at the end of the tunnel may be a freight train coming your way" Metallica - No Leaf Clover
"The light at the end of the tunnel may be a freight train coming your way" Metallica - No Leaf Clover
Re: Miscellaneous Quicken Questions
hi folks,
Quicken user here, investing in taxable account (canadian corporation). Like many others, my accountant is currently handling all tax issues. In the next few months i want to get a better hold of this part and deliver him a 'fully prepared package' that he could simply verify at year end instead of compiling the data himself. I would like to make sure that i understand how to handle things in Quicken.
I already enter all buy/sell operation and dividends distributions, its the ROC part that i am not sure. For the record, i dont DRIP in my taxable account.
I know that the tax breakdown of each distribution are disclosed at year end on the CDS Innovation website.I also see that tax breakdown is published for the whole year on various ETF provider website (ex: ROC of 0.00162 for the YEAR)
Does each distribution need to be adjusted at year end or can i simply perform one operation with the 'annual' value found on the ETF provider website ? Is there any walkthrough on how to enter this data in quicken
Best regards !
Quicken user here, investing in taxable account (canadian corporation). Like many others, my accountant is currently handling all tax issues. In the next few months i want to get a better hold of this part and deliver him a 'fully prepared package' that he could simply verify at year end instead of compiling the data himself. I would like to make sure that i understand how to handle things in Quicken.
I already enter all buy/sell operation and dividends distributions, its the ROC part that i am not sure. For the record, i dont DRIP in my taxable account.
I know that the tax breakdown of each distribution are disclosed at year end on the CDS Innovation website.I also see that tax breakdown is published for the whole year on various ETF provider website (ex: ROC of 0.00162 for the YEAR)
Does each distribution need to be adjusted at year end or can i simply perform one operation with the 'annual' value found on the ETF provider website ? Is there any walkthrough on how to enter this data in quicken
Best regards !