Blog Post

The AccountRight Blog
5 MIN READ

Handling a share portfolio

SupportNoteGuy's avatar
SupportNoteGuy
MYOB Staff
9 years ago

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).
Updated 9 years ago
Version 1.0
  • HAL9000's avatar
    HAL9000
    Experienced User

    Just a couple of points of clarification that have come to light wrt my method above:

     

    1) If following that method of recording the disposal of shares to the letter, you'll be left with the original brokerage still left in that share's asset account after disposal.

     

    So this from above:

       Allocate the number of shares sold x the original cost to that share's asset account, with the memo '#sold x original$ paid'

       Allocate the brokerage to Profit/Loss on Shares as a negative, with the memo being eg. 'brokerage on Rio sale'

     

    Should be replaced by:

       Allocate the number of shares sold x the original cost plus the brokerage on the purchase to that share's asset account, with the memo '#sold x original$ + purchase brokerage'

       Allocate the brokerage on the sale to Profit/Loss on Shares as a negative, with the memo being eg. 'brokerage on Rio sale'

     

    2) The ATO apparently does not dictate that the disposal of shares purchased on different occasions needs to be on a first-in-first-out basis. You can nominate this yourself, but one needs to keep a journal noting which shares were sold, so that capital gains/losses can be calculated accordingly.

     

    I hope I've got all that right!

    Julie_A_C DuncanS SupportNoteGuy

  • HAL9000's avatar
    HAL9000
    Experienced User

    DuncanS Julie_A_C

    Duncan,

    You wrote above:

      "As you mention, Receive Money is used for Sale of Shares.

       The total receipt is posted to the Asset Account.

       From the Purchase and Sale Contract Notes, you calculate the Capital Gain/Loss.

       If all the holding is sold, by default, the asset account is nil."

     

    This has been working well for me until recently I needed to record a sale of only a part of a holding. How do I do that? In this case, I need to end up with the asset account not being nil.

     

    Cheers, Hal.

  • DuncanS's avatar
    DuncanS
    Ultimate Partner

    HAL9000 Julie_A_C

     

    Hal,

     

    Say 4000 shares of 10,000 costing $10,000 were sold.

     

    You write on the Buy Contract Note 4000 shares sold on a date.

    This is then filed with the other Contract Notes.

     

    Take a copy of the Buy Contract Note with the sale of 4000 shares noted.

     

    Say the 4000 shares were sold at $6000 - there is a capital gain of $2000.

    $6000 Sale - $4000 Buy is written on the Sale Contract Note (adjusted for Brokerage) ie say $5970 for Sale.

    The copy of Buy Contract Note is attached to the Sale Contract Note.

    You then do a Journal for the Gain/Loss - the Journal Number and date are written on the Sale Contract Note.

     

    Hope this helps.

     

    Duncan

  • HAL9000's avatar
    HAL9000
    Experienced User

    Thanks Duncan. Is there a step missing before we do the Journal Entry, ie. how do we complete the Receive Money window for the example transaction? (I suspect there is supposed to be both a positive entry and a negative entry in that window but figuring it out is doing my head in...) 

     

    Rightly or wrongly, my head says that after the Receive Money and the Journal Entry, the final value of the Asset account ought to be in the order of $6000?

     

    I'm basing this on it having been $10,030 before the sale (the $30 being the brokerage on the purchase), and we've sold just 4000 of the shares that were originally bought @ $1 each.

     

    Cheers, Hal

    DuncanS Julie_A_C

  • HAL9000's avatar
    HAL9000
    Experienced User

    DuncanS Julie_A_C

    I can't delete my last post, but please ignore it as I think I have this figured out. To be sure though, here are 3 screenshots from my test file:

     

     

    Step 1) This is the original share purchase from Duncan's example. I have purchased 10,000 shares @ $1.00 in a company called COY, with $30 brokerage on the purchase. (I know the purchase brokerage doesn't need to be separated out, but I like to do so anyway.)

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Step 2) This where I have sold 4000 shares @ $1.50, with $30 brokerage on the sale.

     

    Because I had originally bought those 4000 shares for $1, $4000 is the value I enter on the first line. (The Memo for that line annotates the original purchase date and value).

     

    The second line is the brokerage, shown as a negative.

     

    The last line is automatically showing $2000, being the profit.

     

     

     

     

     

     

    Finally, here is my accounts list, showing the original value of $10,030 now reduced down to $6030, as I would expect.

     

     

     

     

     

     

     

     

     

    My first question is, of course, "have I done everything correctly?" Other than that, I would appreciate advice (perhaps by way of a screenshot if that's easy enough) showing what I should annotate in the General Journal entry?

     

    Thanks,

    Hal