Portfolio Management Software

[Waiuta]

I use Google Sheets for an assets register and Direct Broking's 'My Portfolio' function for Australasian share and bond positions. I'm wanting a bit more detail now other than overall unrealised P/L and % of portfolio.
Do members have any sugestions, particularly for individual listings, ie monthly, annulised and commulitive P/L?
I'd be grateful for your comments. Thanks.

[stoploss]

I use Google Sheets for an assets register and Direct Broking's 'My Portfolio' function for Australasian share and bond positions. I'm wanting a bit more detail now other than overall unrealised P/L and % of portfolio.
Do members have any sugestions, particularly for individual listings, ie monthly, annulised and commulitive P/L?
I'd be grateful for your comments. Thanks.
Try Sharesight.com

[Baa_Baa]

Try Sharesight.com

Excellent portfolio tracking system

[Waiuta]

Thanks Stoploss/Baa_Baa,

I agree it is an excellent tracking system. I'm on the free limit of 10 listings but need more. Are you aware of any incentive for upgrading, ie senior discount / coupon, etc? Or, can the charge be claimed legitimately for NZ taxation purposes?

[BeeBop]

I use NUMBERs on my iPhone - it does track tickers (but sometimes can be unreliable). I could not get an app to cover my markets plus dividends etc....I run my own and wouldn’t consider an app now (mind you my workbook is large with many sheets and many years in it now).

[nicknz125]

https://jstock.org (https://jstock.org/)

Can keep track of multiple portfolios in different countries, add dividends, see ROI, etc... software has a nice desktop and phone app interface which can share portfolios through google drive.

Used for a few years now very happy with it.

[Airw0lf]

Try Sharesight.com

I've just been giving Sharesight a go and it's very good but for the price I would not have expected the following niggles:

1. Automated portfolio imports from other sources occasionally resulted in some weird bugs - e.g., share splits were calculated incorrectly and in one case it created duplicate entries for the same holding. This required some manual corrections from me and also getting tech support to fix the duplicate entry bug.
2. Cash account tracking is only available in the highest and second highest tier, but for some bizarre reason it doesn't track growth in those accounts like other assets. So even though it records the balances going up or down as you enter them, it doesn't chart them or show any data on annual capital gain, etc. Bizarrely annoying - if it wasn't for this I could probably track all of my investments (shares, TDs, savings accounts, etc.) all in Sharesight. I've raised the issue with support and they told me it's just not a feature they have right now - I've asked if this could rectified and am awaiting a reply.
3. Cryptocurrency support exists but only for ETH, BTC and a few other coins that seem to have been very arbitrarily chosen. I would have thought they could have added the top 20 or so from coinmarketcap and be done with it.

If they could fix #2 above I'd be really happy. Right now the lack of #2 feels really annoying given that everything else is pretty feature complete.

[Airw0lf]

I've just been giving Sharesight a go and it's very good but for the price I would not have expected the following niggles:

1. Automated portfolio imports from other sources occasionally resulted in some weird bugs - e.g., share splits were calculated incorrectly and in one case it created duplicate entries for the same holding. This required some manual corrections from me and also getting tech support to fix the duplicate entry bug.
2. Cash account tracking is only available in the highest and second highest tier, but for some bizarre reason it doesn't track growth in those accounts like other assets. So even though it records the balances going up or down as you enter them, it doesn't chart them or show any data on annual capital gain, etc. Bizarrely annoying - if it wasn't for this I could probably track all of my investments (shares, TDs, savings accounts, etc.) all in Sharesight. I've raised the issue with support and they told me it's just not a feature they have right now - I've asked if this could rectified and am awaiting a reply.
3. Cryptocurrency support exists but only for ETH, BTC and a few other coins that seem to have been very arbitrarily chosen. I would have thought they could have added the top 20 or so from coinmarketcap and be done with it.

If they could fix #2 above I'd be really happy. Right now the lack of #2 feels really annoying given that everything else is pretty feature complete.

Actually I've got around #2 with a hack - happy for now!

[GTM 3442]

Good morning Airw0lf. . .

What's your hack for cash accounts?

I have a number of foreign currency accounts which drive me nuts. They go up and down like yoyos, and each month I debit the previous month's balance and credit the current balance.

I don't particularly care about the NZD value, only the FX value - I just want to know how the monthend balances are tracking

Thanks

[Airw0lf]

Good morning Airw0lf. . .

What's your hack for cash accounts?

I have a number of foreign currency accounts which drive me nuts. They go up and down like yoyos, and each month I debit the previous month's balance and credit the current balance.

I don't particularly care about the NZD value, only the FX value - I just want to know how the monthend balances are tracking

Thanks

I created a custom investment - e.g., PIE Fund or unlisted company. Then added 1 share at the price of the "opening balance" in my account. I then just keep repricing this share as the balance in the account. It then all works like intended - you can see the balance go up and down and Sharesight works out capital gains, etc.

[GTM 3442]

I created a custom investment - e.g., PIE Fund or unlisted company. Then added 1 share at the price of the "opening balance" in my account. I then just keep repricing this share as the balance in the account. It then all works like intended - you can see the balance go up and down and Sharesight works out capital gains, etc.

Nice. I'll give it a whirl this monthend.

Thanks

[Airw0lf]

Nice. I'll give it a whirl this monthend.

Thanks

I have found that this approach doesn't work well for calculating the capital gains. However, it creates nice charts which can easily show how the account is tracking. So it's good enough for me for now.

[Airw0lf]

In playing around with Sharesight I have found a further issue. It looks like NZ RWT deductions aren't being calculated for foreign dividends (e.g., ASX and US stocks.) I have e-mailed support as this seems like a weird oversight.

[GTM 3442]

In playing around with Sharesight I have found a further issue. It looks like NZ RWT deductions aren't being calculated for foreign dividends (e.g., ASX and US stocks.) I have e-mailed support as this seems like a weird oversight.

I just looked at that since I had a US dividend paid today, and it looks like you're right. I can see the US witholding tax, but no New Zealand tax.

I suspect that it's a database design issue, and that "tax" can only be recorded once for a transaction - probably within the transaction detail table.

After a ten-minute-thought, I think that there would probably have to be a new table - "tax for transaction" or similar - which would be a major exercise to implement, especially in a multi-currency/multi-domicile environment.

Anyway, can you please let us know what they come back with.

PS the "hack" you found works just fine for me - thanks

[Airw0lf]

I just looked at that since I had a US dividend paid today, and it looks like you're right. I can see the US witholding tax, but no New Zealand tax.I suspect that it's a database design issue, and that "tax" can only be recorded once for a transaction - probably within the transaction detail table.After a ten-minute-thought, I think that there would probably have to be a new table - "tax for transaction" or similar - which would be a major exercise to implement, especially in a multi-currency/multi-domicile environment.Anyway, can you please let us know what they come back with.PS the "hack" you found works just fine for me - thanksNo problem - I will see what they come back with. I agree that it might not be a completely trivial exercise to implement but for someone paying at the investor or expert level tier it would not be unreasonable to expect at all IMO. Furthermore, if they don't want to implement their own calculation process for this, the least they could do is just pull the relevant data out of Sharesies, which would solve the problem for me at least since it's through them that I hold my foreign shares.

[GTM 3442]

By a happy circumstance, I had to sort out a "foreign" dividend payment, and there is provision for "foreign" witholding tax and NZ tax for the transaction.

So I'm wrong about the database design.

Now, like you, I'm left wondering why the NZ tax value isn't calculated.

[Airw0lf]

By a happy circumstance, I had to sort out a "foreign" dividend payment, and there is provision for "foreign" witholding tax and NZ tax for the transaction.

So I'm wrong about the database design.

Now, like you, I'm left wondering why the NZ tax value isn't calculated.

Yeah, there are boxes to enter both types of tax, I'm just curious as to why it isn't automatic.

[Airw0lf]

By a happy circumstance, I had to sort out a "foreign" dividend payment, and there is provision for "foreign" witholding tax and NZ tax for the transaction.

So I'm wrong about the database design.

Now, like you, I'm left wondering why the NZ tax value isn't calculated.

Just heard back from support - "Thanks for reaching out to us and sorry for the delayed response. At the moment we do not have the functionality to identify if the foreign shares were purchased via a custodial arrangement or purchased directly, hence RWT field is left blank. For now, you might need to update these data manually. Hover, we are working automating this process."

Does this make sense to you or anyone else?

[JeffW]

Just heard back from support - "Thanks for reaching out to us and sorry for the delayed response. At the moment we do not have the functionality to identify if the foreign shares were purchased via a custodial arrangement or purchased directly, hence RWT field is left blank. For now, you might need to update these data manually. Hover, we are working automating this process."

Does this make sense to you or anyone else?

Happy to admit that it doesn't make sense to me!

However, I think for many it is largely academic, as the FDR rules will apply, and the actual dividend is not taxed

[Airw0lf]

Happy to admit that it doesn't make sense to me!However, I think for many it is largely academic, as the FDR rules will apply, and the actual dividend is not taxedThey also got back to me again and said they are looking into automating for people like me on Sharesies who have the RWT deducted.

[GTM 3442]

Just heard back from support - "Thanks for reaching out to us and sorry for the delayed response. At the moment we do not have the functionality to identify if the foreign shares were purchased via a custodial arrangement or purchased directly, hence RWT field is left blank. For now, you might need to update these data manually. Hover, we are working automating this process."

Does this make sense to you or anyone else?

Yeah, it sort of makes sense.

Once you start moving money around the world it can get complicated as to which parts of the ownership chain have what tax liabilities where.

A US dividend ETF domiciled in Ireland held in custody in Luxembourg by a New Zealand tax resident.

What tax and/or tax credits are available/payable on the dividends received by the ETF
What tax and/or tax credits are available/payable on the dividends paid by the ETF
What tax and/or tax credits are available/payable on the dividends received by the custodian
What tax and/or tax credits are available/payable on the dividends received by the NZ tax resident

And the chain isn't always that simple. . .