Managed Fund Tax Statement Reconciliation

Thank you so much for the update on RDV. I’m glad we were able to get to the bottom of it.
Please let us know if you run into any issues with other statements.

Emily

Seriously - if you look through all the queries on this page the treatment of these statements is a major issue for Sharesight … it is making things more difficult, not easier, for Sharesight customers.

Sharesight should have a huge focus on getting this corrected.

Regards Rob

4 Likes

I wish there was an easy way. I simply can’t do this - I can’t even read the blurry example sheet. I thought I did it correctly last year - yet later in the year I checked the pre-fill, basically reset my manual inputs and I was off by a few cents or $ for each my ETFs - not a huge deal perhaps but I still filled an incorrect tax return.

1 Like

I hear you there - I created a custom investment for it. Entered what I thought was correct based on how I do other ETFs and I’m out by between $2-$6 dollars regardless of what I do. At this point $2 different is close enough that I’ve given up and will submit it.

Hi all!

We’ve updated our AMIT help article, adding in a table to guide you with entering each component.

We’ve also added some examples to guide you along with your own statements :pray:

4 Likes

I’ve prepared some notes on how I’ve handled this that might be helpful

Xero guides - Managed Fund Tax Statements (part 1)

Hi Emily,

The “TFN WH” (tax withheld) column is currently greyed out for me, with each value set as “0” which is not true based on the dividend notifications I’ve seen which show i’ve been heavily taxed.

Based on what you’ve said, will the tables be updated around September with actual values without our manual addition?

Hi @L.Q thanks for getting in touch!

Where is the TFN WH greyed out for you? If you have any screenshots or anything you’re willing to share with us (support@sharesight.com) we should be able to help or point you in the right direction.

If you’re referring to an ETF, yes all the data will be sent through to Sharesight by the ETF providers soon. Keep in mind that the updates will only be reflected if you have not yet confirmed the dividends you’ve received last financial year, alternatively you’ll have to “reset” all your payouts. An important thing to note is that when you reset your payouts, any file you may have uploaded will be deleted.

Finally, just making sure you saw the updated help page in case you want to fill out the Pro Rata form (in your the Taxable Income report) yourself. Scroll down on the help page and you’ll see a table/cheat sheet with explanations on how to fill it out, and we’ve also included some real examples from Vanguard and Betashares.

Hope this helps!

Hi Emily, I too am struggling with this. I have shares in ADI (APN Industria REIT) and the annual tax statement is quite different to the examples shown above and in the HELP instructions. If I upload my annual tax statement from them, can someone at Sharesight tell me if I’ve done it correctly please? Sorry I am totally confused and been trying to figure this out for around 4 hours …

Hi @Shirl yes please send through your Annual Tax Statements to support@sharesight.com and the support team should be able to point you in the right direction. You can also share a screenshot here as long as you remove your personal information from the statement too!

I have just entered all my figures for Vanguard VGE and come up $8.23 short (“recalculated net amount” versus the Computershare net cash distribution).

That $8.23 corresponds precisely to the “Non primary production income” attribution shown on the statement, which is not required to be entered anywhere on the Sharesight adjustment page according to the instructions at How Sharesight helps you handle Australian AMIT tax components | Sharesight Australia Help .

How do I account for this?

Hi @hmof

I’d say to look through this section to find what the $8.23 is made up of. If you haven’t already, reach out to our support team regarding this and we’ll be able to help you directly :+1:

Thanks Jack. As I wrote the $8.23 is exactly the figure under "Non primary production income” on the Vanguard statement, but the instructions on the help site don’t require to put that figure in anywhere on Sharesight. However this results in a discrepancy in the end result.

I do not like the confusing way Sharesight handles EOFY Trust and AMMA statements.

The distribution payment advice was intended to notify the investor of the cash distribution and was never intended to record the detailed source of the income. That is the purpose of the EOFY Trust or AMMA statement.

Yet Sharesight over writes the credible data in the distribution payment advices with fictitious pro-rata data. The complex process provides opportunity for things to go wrong.

The process simply lacks rigour. Fortunately the old fashioned basic method can still be used.

I simply create a new payment for the EOFY statement which is usually 30 June.

I then go through the statement carefully adding components. For AMMA statements the fields are all there but are difficult to find. When the net dividend in the box matches the cash payout on the statement it means success. If they do not match the difference can often hint where the mistake lies.

The distribution advices are no longer needed and can be deleted. If you have a DRP this needs to be added manually. Some DRPs round up, some round down, some carry forward so the advantage of doing it manually is you can enter it precisely from the payment advice with no errors.

I understand it. It is simple. It works for me.

1 Like

Here’s part 2 - dealing with linking to Xero
Xero guides - Managed Fund Statements & year-end adjustments (part 2) )

1 Like

Totally agree. It is waste of time and counter productive, what Sharesight does. No way tallying with what accountants are doing where they exactly reflect company’s AMIT statements.

My accountant got it easy and their data tallies with AMIT statement fields.

Now I am deleting all trust distributions, reentering for each period and then for the final payment or zero net payment on 30/06, manually enter all AMIT statement fields.

I’ve many many trust statements. I’ve long way to go but I can trust this way than Sharesight.

Very very disappointed. If this is what it is, it is not helping annual tax return time for SMSF at all.

1 Like

Particularly for funds, AMIT entry changes already reconciled periodical distribution amounts. That caused lot of inconveniences.
Tax statement reconciliation is okay to some extent for ETF’s but not at all for funds.

To make it effective, following way may be of use for further comments and reconsideration:

  1. Store Tax statement entries filed by field as they’re shown in annual statement.
  2. Do not alter any fields of the distribution entries for that year.
  3. Create new entry called “adjustment entry” showing field by field differences between annual statement fields and total of past distribution fields.
  4. No. 3 and total of no.2 all distribution entries should match Annual statement.

This way, No.3 adjustment entry alone will be new and no other existing entries will be altered and (1) remains as reference entry for tax statement calculations.

Any comments are welcome. Request Sharesight to consider this as High priority item, moving forward so that the product remains suitable and competitive product in all angles.

1 Like

Hi @rn233343 @Fractal

Just some points to add here:

We receive data for the below listed ETFs, for any managed funds these need to be manually entered.

The Pro Rata is there mainly to help you keep your CGT and cost base accurate since all that data is only available in your AMMA tax statements. Once your AMIT data is accurate within Sharesight, the CGT report will also be accurate.

Sharesight works best for filing your taxes when you file using the paper form rather than MyTax. I have passed your feedback to our product team for review.

Hi Jack

I understand what Sharesight is doing, what I am trying to understand is why.

We agree the EOFY AMMA statement is a tax statement containing all the taxable components. The question then is why not use it to create a single unambiguous EOFY entry?

Sharesight’s method modifies the cash distribution advice from the ETF. Is that a wise thing to do? It lacks rigour.

If there are 4 distributions for the year that would mean say CGT is pro-rated by 4. I can see rounding errors and people chasing to find the odd cent error. The data now implies the CGT is spread through the quarters. But is that really the case? The ETF may have had all the CGT events in one quarter. But then the quarterly distribution of tax components is of no interest - we are only interested in EOFY. So why do it?

If you wanted to automate it and make it easier for customers the first step could be to have a PDF reader which extracts the relevant Sharesight entry data from the AMMA statement. The AMMA statement is a sea of data and it can be hard to find what you need, e.g. you have to remember you need the grossed up CGT ignoring the discounted CGT and get the AMIT up/down correct. This would not be a trivial exercise since there does not seem to be any sort of standard for statements. The next step could be to load an entry directly for checking.

The cash distribution advices, if recorded in Sharesight would be non-taxable cash income. They would only be used for say adding cash income to a bank account although I am not sure Sharesight does that. The EOFY AMMA would be the taxable entry but the cash income would now be ignored.

You will have gathered that I do manual entry of the AMMA statement. It only takes a couple of minutes and I am happy to keep on doing that. Am interested in any efforts to make it easier which comply with accounting standards.

2 Likes

I had previously entered the Dividends as at the received date manually (including the DRP).

I have been trying to use this process and followed the Help article (Australian ETF distribution components now available for FY20/21 | Sharesight) to distribute the entries.

This looks like it could be good on the service, but if you automatically assign using the information provided (as per the article), then the DRP buttons get wiped from the previous entries. So now my total shares are not correct (new DRP shares missing)

Is it expected that the process for this assisted flow be:

  • automatically distribute the dividends
  • go and edit each dividend to update the DRP flag?

→ does this then overwrite the Sharesight automation entries in a meaningful way?

Or what is the way to add the DRP entries correctly?