I have a client that has had about 150 options trades during the 2018FY. Probably close to a 50/50 mix between Put and Call Options.
This is going to take me ages to process - does anyone have any tips on how to simplify this? Willing to post them all to the one account if that makes any difference. I’ve read the help guide (Exchange Traded Options - Simple Fund 360 Getting Started) however it seems too complicated.
At the moment all of the settlement transactions are in the ‘bank data clearing account’.
Any help is hugely appreciated.
Hi Chris, I just had the same, but had a good financial planner managing the trades so he prepared a spreadsheet of all the trades which was used as a source document. In my case, the daily movement (via a bank account) included a margin amount (up/down) which was taken to an account with the Options Clearing House. If this is applicable, you also need to obtain the balance at 30th June of the funds held at the OCH. I was able to keep all the individual (daily) movements (including trades) in the bank data clearing account, remove from the bank data clearing account the Profit as per the planner’s spreadsheet to ‘Profit on options trading’, remove the balance in the OCH account, bring to account any ‘open’ options costs (apparently they settle on the same day so there is only ASX and brokerage fee costs spent at that point, and then I only had a few hundred dollars difference which I adjusted against the profit. The auditor was happy with this as he had all the paperwork - which included each buy/sell trade of the option referenced to the spreadsheet. It certainly was a nightmare. Good luck. Regards, Linda.
I’ve had a few of these in the past as well. I agree in part with the approach taken in the BGL process but I wouldn’t go so far as to keep track of the units. I tend to have the following:
- Options Clearing Account (generally in Investments/Derivatives as a Non-Unitised Investment) - where all my option trades start
- An “Open Positions as at 30 June” account (generally in current assets) - where any Long (or Purchased) Call and Put positions that are open at 30 June of a particular financial year are reallocated
- (Prior to SF360 in SF Desktop I would also have a Capital Gain account to which I would reallocate the Net Balance of the clearing account but not necessary in SF360)
All Option trades start in the clearing account. Trades that were matched out during the year would remain in the clearing account, with any that were Exercised (Longs)/Allocated (Shorts) being reallocated to the Cost Base of the underlying asset. Long Call & Put Positions that are still open at 30 June of a financial year are reallocated to the Open Positions account.
The remaining balance in the clearing account should then be your Capital Gain or Loss for the year. In SF360, I process a disposal of the clearing account for $Nil, which should then reallocate the balance of the clearing account to the 24700 Change in Value of Investments account and report as a single line item in your Investment Reports.
That’s my approach in a nutshell, feel free to reach out if you would like me to assist in more detail.
Just wondering if you do any adjustments for the options that were recorded in year X0; then exercised in year X1 and (according to our amazing legislation) should be recorded as cost base adjustments – not against Options Gains/Losses?
Just wondering if you could post a copy of the spreadsheet (with anything sensitive redacted of course).
This may be helpful to others doing Option Trading.
I am not sure how to post it, haven’t used the BGL Community for some time. But have attached here, if you want to add it somehow.
(Not a good result for 2018/2019!).
Kind regards, Linda.
P: (08) 8332 9999
F: (08) 8361 2120
Suite 1, 8 Angas Street, Kent Town SA 5067
P Be Green! Read from the screen!
CAUTION: The information in this email is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are hereby
notified that any use, dissemination, distribution or reproduction of this message by you or at your instigation is prohibited. If you have received this message in error please notify us immediately and return the original message to us. Thank you.
Liability limited by a scheme approved under Professional Standards Legislation.
(Attachment OptionsTradingSpreadsheet_Example.xlsx is missing)
My attachment wasn’t allowed and will try as a PDF but that wasn’t on the allowed attachment list. Sorry I can’t convert (either Excel
or PDF) to another format, like JPEG. Kind regards, Linda.
(Attachment OptionsTradingSpreadsheet_Example_PDF.pdf is missing)