Canadian Money Forum banner
61 - 80 of 160 Posts

· Registered
Joined
·
86 Posts
In my workbook I always enter Payment date. I do this to match my bank statements with my own generated statements. Side effect is that dividends in your example will be assigned and reported in year 2015. But because I do this consistently year over year, my 2014 dividends include some of the 2013 data and so on.
You could use record date or ex-dividend date and assign distribution to proper month/year, but that would be more work for you - you would have to track each distribution and find these dates.
 

· Registered
Joined
·
86 Posts
Hi Vidm,

Will portfolio slicer work with Microsoft Office Enterprise Excel 2007.

I wanted to know before I register and set up my portfolio

Thanks for your great efforts.

apatel
Hi Apatel,

No, Sorry, Portfolio Slicer will not work with Excel 2007 as it needs PowerPivot add-in that was introduced just in Excel 2010 and then later integrated into Excel 2013.
 

· Registered
Joined
·
86 Posts
Whats in for the next update vidm ? :)

Any big plan for a 1.0 release ?
I am not sure yet, there might be 0.9.9 release before 1.0. But I am close to having release that has features that I believe must be present in Portfolio Slicer. I am working on it every day. There will be option not to track cash and help with dividends :).
 

· Registered
Joined
·
86 Posts
vidm, regarding RESP tracking in portfolioslicer, what TransType/TransSubType would you use for government grant ?
I probably would add this as TransType = 'Deposit', TransSubType = 'Grant'. Alternative would be to add it as TransType = 'DivTA', TransSubType='Grant', but then your dividends would be affected.
In any way you will have to create your own report (Pivot Table) that shows data by TransSubType so you would know what deposits you made and what part was grant.
 

· Registered
Joined
·
1,676 Posts
Discussion Starter · #70 ·
vidm not sure if you still monitor this thread but i have a question regarding recent activity in my non-reg account:

Transaction date: 2015-03-09
Settlement date: 2015-01-06
Description: VANGUARD FTSE CDA IDX ETF
Type: CG DIV
Units: -17 234
Price:5 081,62$
Comm.: 0$

Bascily, its a Capital Gain Dividend, should lower my ACB, how should i enter this in portfolioslicer ?

Best regards :)
 

· Registered
Joined
·
86 Posts
Hi Larry,

In Portfolio Slicer there are 2 transaction types to deal with such distributions:

NotionalDistrib Notional Distribution - Capital Gains Increases Book value!
ReturnOfCapital Return of Capital - Decreases book value!

So you simply enter distribution transaction with type "ReturnOfCapital", Qty=17234 and Price:5081.62
 

· Registered
Joined
·
86 Posts
thanks vidm !!! Any plan for the next update ? ;)
Hi Larry,

I am reviewing my own investments and I also see for XEI "CG DIV" transaction. I believe that these "CG DIV" transactions should "Increase" (!!!!) your ACB, so you should be using NotionalDistrib transaction type.

Here is my look at that:

Let say I invested in XEI stocks. During the year I receive dividends into my account (assuming regular account, NOT RRSP or TFSA), lets say 100$/month. Around March of next year I receive "Summary of Trust Income" from my bank that now tells me that every month (actually values every month could be different) I received:
90$ of "Total Capital gains, box 21"
8$ of "Actual Amount of eligible dividends, box 49"
2$ of "Return of Capital, box 42"
As I receive dividends every month I know that my "Return of Capital" for year is 24$ (12x2$).
For this in portfolio slicer I create 2 transactions for the last day of the year, or if stock was sold during the year, then I enter transactions one day before last sale.
Symbol: XEI, TransType: DivTA, TransSubType: DivTypeAdj, Qty: 1000, Price: -24$
Symbol: XEI, TransType: ReturnOfCapital, TransSubType: DivTypeAdj, Qty: 1000, Price: 24$
So with these 2 transactions I subtracted 24$ from general dividends paid by that symbol and then added 24$ for "Return of Capital" paid by that symbol. Total paid dividend stays the same.
With these transaction ACB will be reduced and that means when I will sell that symbol, my Capital Gain will be bigger.

Some symbols have NotionalDistributions that are "Reinvested distributions". For example symbol XEI on Dec 29, 2014 paid 0.74306$ per share as "Reinvested Distributions". In my TD Waterhouse statement I see this as "CG DIV" transaction followed by "DRIP" transaction. Other banks might not post any transaction for such distribution. In Portfolio Slicer I enter this as one transaction:
Symbol: XEI, TransType: NotionalDistrib, Qty: 1000, Price: 743.06$
This distribution is not really paid out as you do not see any change in your cash values.
This transaction increases ACB by distribution amount and that means when you will sell symbol, your capital gain will be smaller.
Please note that info about this distribution is not included in your "Summary of Trust Income" as separate transaction type, so really if you did not properly identify this transaction and adjust your ACB, you will pay extra tax. But if you carefully review "Summary of Trust Income" usually at the month of December you will see distribution paid that is bigger than amount you received in your account. Please note that if you carefully check T3, you will see that it includes that extra distribution. So really with Notional Distributions you pay Cap Gain tax in the year you receive it and then pay less tax when you sell your symbol.

So please double check what type of distribution is this so that you do not overpay tax!!

Regarding next Portfolio Slicer version - I am working on it every day, I just do not want to rush releasing it before I am happy with functionality. I am not sure when next release will be done.
 

· Registered
Joined
·
86 Posts
Excel on steroids. Pretty slick.
With your server running in the cloud are you having any issues with quote refresh latency?
Can the quote refresh times be modified at all?
In Portfolio Slicer cloud database stock quotes are refreshed few times per day - mostly to accommodate different time zones (many users are from Europe, Asia) and to capture general days trend. Mutual fund prices are updates once a day - 5 hours after market close. Quote refresh time cannot be modified. Portfolio Slicer is designed for reporting on your investment performance, so having few hours delayed quotes should be sufficient for absolute majority of people.
 

· Registered
Joined
·
8,876 Posts
I'm still using it regularly and it's pretty much everything I wanted Quicken to be.

On the dashboard, one of my "top YTD winners" seems to be wrong, possibly counting gains from the book value or something (I repurchased it this year, shows as a YTD winner +24% but it's actually down slightly this year)

When I reconciled the balances I also found that I had input some bank fees backwards (negative) Not sure if you could have a warning for that somehow but it's not a big deal

I like the buttons for CAD/USD/original and the exchange rate impact etc. All the tabs are great insight as well and easy to use. :encouragement:
 

· Registered
Joined
·
35 Posts
i'm trying this but find documentation seems a bit lagging and does not match current version. Can someone explain what's "account" and "portfolio" ? On existing demo and old version there is only portfolio which seems easier to handle. Not sure how I handle account vs. portfolio in the new version when I enter transactions. Thanks !
 

· Registered
Joined
·
86 Posts
i'm trying this but find documentation seems a bit lagging and does not match current version. Can someone explain what's "account" and "portfolio" ? On existing demo and old version there is only portfolio which seems easier to handle. Not sure how I handle account vs. portfolio in the new version when I enter transactions. Thanks !
Account usually matches your bank account.
Portoflio - group of accounts that you group any way you want. For example you might use 2 values in portfolio - one your name and another your spouse name. Portfolio can be used to apply filter to report, for example you want to see just accounts that belong to you and not to your spouse.
 

· Registered
Joined
·
86 Posts
I'm still using it regularly and it's pretty much everything I wanted Quicken to be.
On the dashboard, one of my "top YTD winners" seems to be wrong, possibly counting gains from the book value or something (I repurchased it this year, shows as a YTD winner +24% but it's actually down slightly this year)
When I reconciled the balances I also found that I had input some bank fees backwards (negative) Not sure if you could have a warning for that somehow but it's not a big deal
I like the buttons for CAD/USD/original and the exchange rate impact etc. All the tabs are great insight as well and easy to use. :encouragement:
Hi m3s, I believe that issue with top YTD winners will be fixed in the next release - I changed how Profit % is calculated and that affects YTD winner. I also added option not to track cash, so you will not need to do deposits before buying stocks - and that should simplify PS usage substantially.

Regards,
 

· Registered
Joined
·
35 Posts
Account usually matches your bank account.
Portoflio - group of accounts that you group any way you want. For example you might use 2 values in portfolio - one your name and another your spouse name. Portfolio can be used to apply filter to report, for example you want to see just accounts that belong to you and not to your spouse.
Thanks very much. I spent some time last night to go through the steps. Got most working but today I can't seem to refresh/update as I always get user name/password error when I try to refresh data in power pivot table. Not sure why as it seems to work yesterday. Also got warning about 32 bit version of Excel 2010 which is the one I'm using.
 
61 - 80 of 160 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top