Handling a share portfolio

MYOB Staff Post SupportNoteGuy
31 Posts
MYOB Staff Post

Your MYOB software isn't specifically designed to track the buying and selling of shares, but it's flexible enough to be customised for this purpose. We'll step you through one method you can use to track shares using inventoty items.

 

This article is provided for guidance only - it might not be suitable for your business requirements. If you need clarification, check with your accounting advisor or post your question below.

 

Setting up your company file

 

The following things need to be set up in your company file:

  1. An Asset Account for shares: this can either be a single account or a header account with various detail accounts for different shares.
  2. An Income or Other Income account called Profit/Loss on Sales of XYZ where XYZ refers to the company issuing the shares in question.
    Note: If you are reporting PAYG Instalments on a Cash Basis, you will need to separate these by creating an income account for Profit on sale of shares and an expense account, other expense or cost of sale account for Loss on sale of shares.
  3. An Income account called Dividends to record the receipt of cash dividends. Again you can choose to have separate accounts for each company.
  4. A Customer and Supplier card both with the details of your stockbroker.
  5. An inventory item for shares. If you like, you can use the Stock Exchange Codes as the item numbers. We also recommend that you enter the date on which the shares were purchased to make reporting of items easier and include the date they were purchased. As shown in our example below, the item numbers used for MYOB Limited could be S-MYO-100700.
    Select the options I Buy This Item, I Sell This Item, I Inventory This Item. The linked Cost of Sales Account and linked Income Account for Tracking Sales should be the Income/Other Income account created in step 2 above. The linked Asset Account for Item Inventory should be the asset account you set up in step 1 above.
    Ignore any warnings you receive upon selecting the account.

Note: For users reporting PAYG Instalments on a Cash Basis, you will need to link an income account for 'Income Account for Tracking Sales' and an expense or Cost of Sales account for the 'Cost of Sales Account'.

 

 

Shares1.png

 

 

Recording shares already on hand

 

If you have already purchased shares and the value is only reflected in the Assets section of the ledger accounts but not in your Items List, you can use the Count Inventory window to update the list.

  1. Go to the Inventory command centre and click Count Inventory.
  2. Enter the quantity of shares you have for each item, and click Adjust Inventory.
  3. When the "Default Adjustment Account" message appears, select the share's asset account. If you have different asset accounts for each share, choose the asset account in the Item setup. You can then enter the purchase value of the shares.
    Note: This will only add the Shares to the Items list. It will not change any figures on your Balance Sheet.
  4. When you purchase additional shares, make sure you create a new item in the Inventory list. Use an Item Purchase bill, and select the appropriate Supplier card. The original cost and number of shares purchased will be maintained. When the shares are sold, the cost of the purchase needs to be ascertained for capital gains' tax purpose. Generally, brokerage is included in the cost base of the shares purchased.

 

Purchasing shares

 

Create a new Bill. On the first line of the bill, enter the brokerage fee amount. On the second line of the bill, enter the amount of shares you are buying and at what unit prices your are paying per share. See our example below.

Shares2.png


Note:
In the above example, we have bought 500 shares at the rate of $8 each with a brokerage fee of $24 incl GST. This is an example only. Please refer to your contract note for details of GST charged.

Enter the payment through Pay Bills and select your bank to pay this amount from.

 

 

Selling shares

 

 

  1. Create a contra account for Share Trading, used to offset sales and purchases from the same company.
    Note: A contra account is only required for individuals who are able to claim the GST input credit. For private individuals who are unable to claim the GST input credit, there is no need to create this account. When selling shares, the Sales shown on Steps 2 and 4 would be combined on the same Sale, but with the brokerage amount being a negative amount to reduce the amount being received. This money would be simply deposited straight tour your normal bank account.

    Image

  2. Create a Purchase for Brokerage. For correct reporting on the Business Activity Statement, brokerage needs to be recorded as a purchase. Disregard any messages about the account selected.

    Image

    Note:
    This is an example only. Please refer to your contract note for details of GST charged.

  3. Record payment of brokerage through the Share Trading contra account. This amount will be offset against the sale proceeds in Step 5.

    Image

  4. Use an item invoice to record the sale, selecting the appropriate customer and item number or parcel of shares you want to sell. Enter the number of shares sold and their value. When recorded, your accounting package will calculate the cost of sale on the original cost of the shares and produce an accounting profit or loss on sale.

    Note: Generally, brokerage is deducted from the proceeds of the shares sold.

    Image

  5. Record receipt of brokerage to the Share Trading contra account.

    Image

  6. Record Receipt of Net Balance from Stockbroker.

    Image

    Note:
    Please obtain the advice of your accountant or the Australian Taxation Office in relation to reporting of share sales on your Business Activity Statement (BAS).

  7. Enter cash dividends received, by crediting them to the appropriate income account in the Receive Money window. Our support note  shows different ways of treating dividends and dividend reinvestment plans.
  8. Report on the value of your shares. If you have set up a prefix for each item, you can easily report the value of the shares. In the Filter for the Items List (Summary) report, you can enter From: S-AAA To: S-ZZZ (where AAA and ZZZ are your first and last share items listed in the Items List) to view only your share items in the report. This report produces a useful listing of the number and value of investments on hand. Note: If you want to record the market value of the shares in your accounting software, you can enter them using the Set Item Prices button in the Inventory command centre. Simply override the existing Current Price with the new price. This figure will then appear in the Items List (Summary) report along with the original cost and quantities.

    Image

    This report shows the market price of the shares in the Current Price column, as well as the original cost in the Average Cost column. The Total Value and Grand Total in this report should match the Totals for the Asset Accounts set up to purchase the shares. Use the Analyse Sales (Item) report to display the income, cost of sale and profit for each company, as well as the number of shares sold (in the filter, enter S-* to show all items beginning with S- in the report).
25 Comments
Ultimate Partner Seattle
1,412 Posts
Ultimate Partner

Adrian,

 

Thank you for your post.

I have some ideas, comments and procedures that I have listed below.

 

For tax and accounting purposes for shares, it is necessary to decide whether one is a Trader or Non-Trader.

 

The accounting that I record for my clients is that of a Non - Trader and this is the basis for my comments.

 

A Non -Trader will setup the Share Portfolio as a Non-Current Asset with headers such as ASX Listed Shares, Overseas Shares, Shares in Non-Listed Companies and Shares in Associated Companies.

I will limit my discussion to ASX Listed Shares.

 

On purchase, the Stockbroker will issue a Buy Contract Note.

I would set up a ledger called 1-2010 ANZ Banking Group Limited 200u     200u being the number of shares held.

I would setup up a Card called ANZ Banking Group Limited - Purchase

I would use Spend Money to record the purchase of the shares.

Chq # would be name of the Stockbroker eg ETrade.

Date would be the date of the Contract Note being the Transaction date on the Contract Note. 

Amount is Total Amount $ on Contract Note.

None of my clients are able to claim the GST on the Brokerage so I do not need to use a separate line for the Brokerage.

 

On sale, the Stockbroker will issue a Sell Contract Note.

Lets say the above 200 ANZ shares are sold.

I would setup up a Card called ANZ Banking Group Limited - Sale  

I would use Receive Money to record the sale of the shares.

 

The Buy Contract Note and Sell Contract Note are stapled and the difference between the Sale Price and the Purchase Price calculated. This is the Capital Gain/Loss on these shares.

There may be additional shares in the 1-2010 ledger if a Dividend Reinvestment Plan had been utilised.

The Capital Gain/Loss is calculated on any Dividend Reinvestment shares.

 

Under Other Income, I setup up a Header called Capital Gains/Losses.

I setup 3 accounts being Capital Gains <12 months, Capital Gains > 12 months and Capital Losses.

 

A journal is used to record the Capital Gain /Losses.

The amount in the 1-2010 ledger should be nil.

The 200u is changed to sold March 2016.

 

I mark to market by using a ledger called Inc/Dec ASX Shares FY16.

I keep a separate Mark to Market Ledger for the past 4 years.

The Share Portfolio lIsting provided by the Stockbroker agrees with the Header total of ASX Listed Shares.

 

Internet Access to the Stockbroker and the Share Registry should be arranged.

 

On purchase of shares, the Company's Share Registry on behalf of the Company will write asking for TFN (if not held by the Share Register), Bank Account Detail as few listed companies issue dividend cheques,

Dividend Reinvestment Plan details if offered by the company etc. 

 

Chess Holding Statements are issued on a monthly basis (if Chess sponsored by your Stockbroker)..

The details on the Chess Holding Statements should be agreed to MYOB.

 

Contract Notes and Holding Statements should be keep for five years after disposal of shares

 

Duncan Smith

Business Advice + Tax

Community Manager Suja_P
5,446 Posts
Community Manager

Hi Duncan (@Seattle),

 

Thank you very much for taking the time to share your thoughts and providing details of how you handle a share portfolio in MYOB software.

 

Regards,
Suja

 

 

Ultimate Partner Julie_A_C
3,039 Posts
Ultimate Partner

As Duncan has stated, the situation needs to be assessed as to whether someone is a share holder or a share trader.

 

This will also impact on the coding of the sale and purchase coding of the entry, as if you are an actual share trader, these purchases and sales should be coded GST Free and included on a BAS, not coded as N-T (not reportable).

 

Whether you can claim the GST back then gets back to the fact that they are financial supplies and there is a financial threshold limit, on when GST can and can not be claimed back. 

 

Very tricky subject to be discussing.

Community Manager Suja_P
5,446 Posts
Community Manager

Thank you for your comments, Julie (@Julie_A_C).

 

I encourage community members to use the above article and its comments as a guide. Should you have any specific queries, please post your question here, and seek advice from your accountant.

 

Cheers,

Suja

 

Experienced User John_P
43 Posts
Experienced User

Is there any chance that MYOB Account Right can be updated to handle Shares distribution of Return of Capital.

 

Some clients receive a Return of Capital to go towards previous Share parcel purchases. Lots of Banks and other major Shares purchased will distribute a Return on Capital. Some clients end up buying up to 30 parcels of shares over period of time. When the Return of Capital is later to be spread across the parcel purchases, this has done as ratio of each parcel held. A single payment received from Shares would then have to be manually calculated to be distributed across the entire parcel purchases.

 

There's a lot of time spent handling these types of transactions.

 

Thanks,

 

John P

MYOB Moderator Steven_M
20,820 Posts
MYOB Moderator

Hi @John_P


Thanks for the feedback in regards to AccountRight. 

I see you have posted your particular feedback as an idea on the AccountRight Idea Exchange - Return of Capital Share distribution. I would encourage other users that do come across this post and would like to see that particular idea added to vote and comment if required for its possible inclusion in future releases of the software. To vote for an idea on the AccountRight Idea Exchange select the + VOTE button to the left of the idea's name.

Experienced User HAL9000
22 Posts
Experienced User

 Hi @SupportNoteGuy

Thanks for these notes. I'm just setting this up and so far have 2 questions:

 

1) In your screenshot under Purchasing Shares, the first line item (for brokerage fee) doesn't make sense to me. The quantity you have enetered is zero, and the price is zero, yet the total is $24. Shouldn't the total be zero in this case?

 

2) After I have entered my share purchase and I return to my items list, I see that the number of items on hand is one more than the actual number of shares purchased. This is because the brokerage fee is also counted as an item. Is this intentional, or have I misinterpreted something?

 

Thank you in advance,

Ralph

MYOB Moderator Steven_M
20,820 Posts
MYOB Moderator

Hi @HAL9000

 

Having the first line on the Enter Purchases window set to a Bill value of 0 and a Price of 0.00 but a Total* with the amount of the brokerage fee doesn't impact the item's quantity and value. 

*The brokerage fee would need to be entered manually into the Amount column as AccountRight will calculate it manually (quantity of 0 x Price of 0 = 0).

Experienced User HAL9000
22 Posts
Experienced User

Thanks @Steven_M and @SupportNoteGuy - that answers both queries. Following the example of the screenshot, AccountRight had been calculating the brokerage, resulting in a total of zero; so assuming the screenshot must be erroneous, I'd entered it with a quantity of 1 instead of zero. This ensured that the total amount was correct (eg. $24, to stick with the example in the screenshot) but increased the inventory by one in the process! I didn't realise you could just enter a total and leave the preceding values without a value.

Ultimate Partner Seattle
1,412 Posts
Ultimate Partner

@HAL9000 @SupportNoteGuy @Steven_M

 

Hal,

 

In over 15 years of using MYOB for share portfolios, I have never used Purchases or items.

 

My preference is to use Spend Money and Receive Money.

The Portfolios that I handle have less than 20 Investments so each Investment is listed separately on the Balance Sheet.

 

Some Accountants might prepare a Balance Sheet with a total of ASX Listed Shares.

If that was the case, then a list outside MYOB would be kept.

This list is provided continually by the Broker during trading hours.

I print out the portfolio from the Broker website say quarterly and agree the Market Value to MYOB.

 

Duncan

Experienced User HAL9000
22 Posts
Experienced User

Thanks @Seattle I think that is actually the way I do it in my personal MYOB account...? I just have a "Share Purchases" Other Expense account, a "Share Sales" Other Income account, and a "Share Dividends" Income account. Is that what you mean?

 

I have no way of listing each equity separately that way, but I wasn't really concerned about that for the personal account.

 

For the business account though, I thought it might be better to have each equity listed, as in the tutorial, and it's also neat that the Inventory shows the amount of shares held for each equity which I'm not sure would be the case with your method?

 

 EDIT: I've just re-read your comment above from March, which I think explains what you meant, and is much more involved than the simple method I use for my personal account.

 

Also, yes the accountant has direct information from the broker, so setting up the MYOB account in this way is mainly for my own benefit.

Experienced User HAL9000
22 Posts
Experienced User

Now that tax time is here, I have a further question about this method that I've been using, as described in the tutoral.

 

Looking at my P&L report via Reports... Accounts... Small Business Entity... Proft & Loss [Cash] - it's indicating at the end of the report:

Other Expenses

   Loss on share sales  (and gives a $ figure exactly equal to what I've spent on shares, matching the figure in my Shares Asset account.)

 

But I've not sold any shares, I've only bought them. So I'm confused as to why it's reporting my purchases as a Loss, which in turn affects my bottom line Net Profit.

 

Moreover, when I drill down into my Loss on share sales account (which I've placed under Other Expenses) there are no transactions appearing there at all, as expected.

 

Is this what I should expect from the P&L figure, or does it look like I've done something wrong?

Ultimate Partner Seattle
1,412 Posts
Ultimate Partner

@HAL9000 @SupportNoteGuy @Suja_P

 

If you have not sold any shares, then there should not be any amount in Loss on Share Sales.

 

The Bank Account that you use for your Share Trading should be reconciled on a regular basis.

 

When I buy shares, I use Spend Money from my ANZ Share Trading Account with the debit to the individual share bought.

 

The yearly summary from your Broker should be reviewed to MYOB.

The Portfolio should be agreed to your Balance Sheet, the Dividends/Interest should be agreed to MYOB and Capital Gains/Losses should be agreed to MYOB.

 

Hope this helps.

 

Duncan

Experienced User HAL9000
22 Posts
Experienced User

Thanks @Seattle / @SupportNoteGuy @Suja_P

 

I haven't sold any shares, so as expected, there is no amount showing in the "Loss On Share Sales" expense account. This being so, what's confusing me is why the Proft & Loss [Cash] report is showing a loss on share sales.

 

All banks accounts are reconciled monthly.

 

Using "Spend Money" from your Share Trading Account with the debit to the individual share bought sounds like a simpler method; nevertheless, I have implemented the method described in the tutorial and am now stuck with it.

 

My accountant receives information directly from my financial advisor, so I'm sure he'll work it out for himself and not be fazed by the fact that MYOB thinks my company has made a massive loss due to the purchase of some shares.

 

I'd just like to know why, having followed the tutorial to the letter as far as I'm aware, I am seeing that apparently erroneous figure as the bottom line result in the Proft & Loss [Cash] report.

Ultimate Partner Seattle
1,412 Posts
Ultimate Partner

@HAL9000 @SupportNoteGuy @Steven_M @Suja_P

 

I hope that MYOB can resolve your issue.

 

It maybe that MYOB should/could rewrite the Support Note using my simpler method that you prefer - I am prepared to assist MYOB if they ask for my assistance.

 

Duncan

Experienced User HAL9000
22 Posts
Experienced User

Would indeed be helpful.

 

I have 28 items (various equities purchased on various dates) in my Company file, and 76 in my SMSF file; as well as all the various dividends that have come in during the year.

 

Whilst not impossible, I expect it would be a good day or two's work to unreconcile the accounts; then delete every dividend payment; then delete every equity purchase; then delete every item; then re-enter everything using using the alternative method; and finally re-reconcile accounts...

 

Good thing I haven't started a new FY for 2018 yet, eh.

JulieAC
3 Posts
Cover User

hi @HAL9000, @SupportNoteGuy, @Seattle, @Steven_M

 

The only way the support note works on the cash basis, is if you go and change the COGS account for the item to a COGS account (5-xxxx) called Share purchases.

 

You can do this now.  Drill down own each purchase and put a slight change at the end of the description line (eg add a fullstop) and okay the entry.

 

You will also need to then do an entry at the end of the year for opening and closing stock values.  The difference between the two values will need to go to an Equity account, maybe called share adjustment account.  This would get back to nil, once all shares are sold.

 

If you are on an accruals basis for Tax, the difference in opening and closing stock would go to the COGS Share purchases account.

 

MYOB is not built for running inventory properly on share purchases and it would be better to just keep an excel worksheet to record shares bought, at what price and the date and what sold and when.  Or even easier would be to use the statement from your broker at year end, Margin lender or bank if doing it via these methods.

 

Personally I just use a spend money and receive money for my share transactions, as below

 

As at the beginning of every year I pass a general journal to get the opening value of stock into the books.

 

When I was trading shares quite a lot I was classified as a Trader, so I would also bring into account the revaluation of shares at the end of each year ad take this up as a loss, or declare as income in that year.

 

The below will work for either accruals or cash basis.

 

.GJ opening balGJ opening balshare purchaseshare purchaseshare saleshare sale

 

Experienced User HAL9000
22 Posts
Experienced User

Thanks @JulieAC et al. 

 
This is all rather a bit complex for the likes of me. I think that in following the tutorial, what I've done is make things more complex than MYOB really "needs" them to be, and even following Julie and Duncan's methods may be more than I need. 
 
Please let me know if you feel this simpler idea might work? Please note: for anyone reading this post - WHAT FOLLOWS BELOW IS NOT ADVICE - it's merely asking the question as to whether the method I'm suggesting might work...
 
As far as my accountant is concerned, he gets all the info he needs from my financial adviser, so he's not relying on MYOB to see what shares I've purchased, when, or how many; and as far as MYOB is concerned, all it needs to do is account for overall purchases, sales and income - MYOB doesn't really need to "care" about which shares I'm purchasing (eg Woolworths, ANZ or whatever) or how many. All it needs to do is make sure the books balance.
 
Purchasing shares isn't really an 'expense' as such - and I believe that the reason MYOB thinks my business has made a loss equal to the value of shares purchased, is because using the tutorial, it's been treating them as an expense, rather than as an investment.
 
So rather than accounting for share purchases via an expense account, or via an item purchase, perhaps they should be accounted for just as a regular asset account?
I would setup a new 'Other Asset' account (in my case these are in the range 1-2000 to 1-2999) and call it 'Shares'.
Whenever I buy shares, I would do a transfer from my share trading account (which is a regular Bank account) to 'Shares'.
This way, 'the money stays in the company', rather than appearing on the P&L as a loss.
 
Whenever I sell shares, I would do a transfer back from my 'Shares' account to my bank account.
 
The Shares account doesn't care about the changing value of the stock from day to day, so likewise, it shouldn't be concerned that the price I sold a stock for was different to the price originally paid. But I'm not sure how to account for the profit/loss on share sales using this method?
 
I both cases, brokerage can be accounted for as an expense, and I would setup a separate expense account for that under 'Misc Expenses' (which in my case is in the range 6-1200 to 6-1299).
 
Income from Dividends would be accounted for in the same way as I currently do, which is via an 'Other Income' account called 'Dividends'.
 
What do you think, is this too simplistic?
Ultimate Partner Julie_A_C
3,039 Posts
Ultimate Partner

Hi @HAL9000, @Seattle, @Steven_M< @SupportNoteGuy

 

I answered the previous post under an old email address but all advice given needs to take into account whether you are a share TRADER or INVESTOR.

 

Share trader would do as you are suggesting, but not even expense out the brokerage.  This gets taken into account when you actually sell the capital item (shares), so in you your case would be added to the asset cost. When the brokerage cost of selling will also reduce your profit margin.

 

Adjustments would just then be done at end of year for the Accountant to advise once he has the yearly brokerage statement.

 

My advices would be more for a Share TRADER who can expense out the brokerage immediately and also can claim back the GST.  More applicable to your SMSF.

 

I think the support notes should not have even have 'gone there' with shares. 

 

So many different scenarios that could apply.

 

Ultimate Partner Julie_A_C
3,039 Posts
Ultimate Partner
****THIS IS A REPOST OF PREVIOUS POST MADE UNDER AN OLD EMAIL ADDRES IN ERROR.****

 

The only way the support note works on the cash basis, is if you go and change the COGS account for the item to a COGS account (5-xxxx) called Share purchases.

 

You can do this now.  Drill down own each purchase and put a slight change at the end of the description line (eg add a fullstop) and okay the entry.

 

You will also need to then do an entry at the end of the year for opening and closing stock values.  The difference between the two values will need to go to an Equity account, maybe called share adjustment account.  This would get back to nil, once all shares are sold.

 

If you are on an accruals basis for Tax, the difference in opening and closing stock would go to the COGS Share purchases account.

 

MYOB is not built for running inventory properly on share purchases and it would be better to just keep an excel worksheet to record shares bought, at what price and the date and what sold and when.  Or even easier would be to use the statement from your broker at year end, Margin lender or bank if doing it via these methods.

 

Personally I just use a spend money and receive money for my share transactions, as below

 

As at the beginning of every year I pass a general journal to get the opening value of stock into the books.

 

When I was trading shares quite a lot I was classified as a Trader, so I would also bring into account the revaluation of shares at the end of each year ad take this up as a loss, or declare as income in that year.

 

The below will work for either accruals or cash basis.

 

.GJ opening bal GJ opening balshare purchase share purchaseshare sale share sale

 

Ultimate Partner Seattle
1,412 Posts
Ultimate Partner

@HAL9000 @Julie_A_C

 

Hal,

 

Whether you are a Share Trader or not, is a decision for you and your Tax Accountant.

From my knowledge, you are perhaps on the verge, conservatively I would say not, and it may be worth contacting the ATO.

 

As Julie mentions, the recording of the share transactions is different depending on whether you are a Share Trader or not.

 

I do prefer the Spend Money and Receive Money.

 

I would obtain a copy of the Annual Summary from your Financial Planner and agree it to MYOB.

 

Duncan  

Experienced User HAL9000
22 Posts
Experienced User

@Julie_A_C @Seattle

Thanks. As far as the Company account is concerned, I'd assume I'm not a share trader, since I run a very small business and have simply decided to invest some of the profits into shares rather than leave it sitting in the bank. The stocks will be held long-term, not traded regularly.

 

As far as the SMSF account goes, perhaps the focus is share trading since it's not a business as such. But then again, the stocks will be held long-term. So in my view, in both cases I'm an investor, not a share trader.

 

I use a cash basis in both accounts.

 

I do not claim back the GST in either case. But now you've got me wondering whether I ought to have done with the Company purchases, since the coy is GST registered... what a minefield this has turned out to be!

 

I'm really struggling to understand the concept, eg. why annual opening/closing stock values should be of concern at all, until such time as the stocks are sold.

Ultimate Partner Julie_A_C
3,039 Posts
Ultimate Partner

Hi @HAL9000, @SupportNoteGuy, @Seattle,

 

If you aren't classified as an actual Trader, then whether the Company is registered for GST or not is beside the point.  You can't claim the GST back.

 

Bringing in opening and closing stock is only if you are going to do the entry as per the support notes.

 

I would suggest that you just do a spend money transaction allocated to the Asset account and record in the notes how many shares you bought and price per share.

 

When you sell them do a receive money for the nett amount. 

 

Allocate the amount of shares sold times the orginal cost to the asset account, allocate the brokerage to Profit/Loss on shares (as a minus with the memo being brokerage fees) and allocate the remainder t the same Profit/Loss on shares account.

Experienced User HAL9000
22 Posts
Experienced User

Thanks @Julie_A_C When I get the chance, I'll make a copy of my MYOB file and do some experimenting along those lines. I'm bound to have some additional questions once I attempt this. Thanks for your patience and help!

Ultimate Partner Julie_A_C
3,039 Posts
Ultimate Partner

Hi @HAL9000,

 

You are welcome.

 

Doing shares in MYOB or any program can be really complicated and is usually just made simpler by allocting the whole purchase cost to the asset account and receipt on the sale to an icome account, being share sales.  Then the Tax accountant can work any profit/loss, taking into account capital gains reductions available (discounting or indexation)  from the  Broker's statement.

 

This though doesn't show you properly your income to date to manage your future tax liabilities, so it can become a bit of a 'minefield'.

 

There are so many 'go to pages' if you search capital gains/loss on shares on the ATO website that you will just give up!

 

My best advice would be to work on the assumption that you bought a share at $10, sold it at $15, made a profit of $5, and tax will be $1.35 (say 27.5%).

 

That way you should be over provided if you put that away.

 

Always better to be prepared than being caught short at tax time!