- Joined
- 18 September 2008
- Posts
- 4,041
- Reactions
- 1,185
anyone like to suggest a simpler way?
Depending on the volume of your trading, have you considered maintaining your own records. I use a spreadsheet to record all my trading activity and just use the IB reports for record purposes (in case the ATO were to require verification of my figures). It's not difficult for me to maintain (I trade only once or twice per week) and I have refined my spreadsheets so that I have a real-time view of my Profit & Loss and also my company Balance Sheet.
Although I now do the tax myself, when I did have an accountant I just gave him summary data of the type you are asking for.
Some issues I have found using the IB reports are:-
I always calculate my Closing Stock On Hand by using the "Lower of Cost or Market" method and do this on the basis of each batch of stock purchased. This minimises your reported profit for the year so you pay less tax and have more of your funds to use for trading. Eventually the profit deferred will have to be brought to account (say when you decide you no longer want to trade and close out all your positions), but if you are a successful trader, you should have benefited from having more funds at your disposal in the earlier years. I don't believe that IB can handle "Lower Of Cost or Market". Also, IB, as far as I know, only allows you to select LIFO or FIFO when deciding which batch or part batch of shares are being sold. I prefer to select a batch of my own choosing (which may not be LIFO or FIFO) as that allows me to better control the profit I want to show in a particular year.
I find some of the data from IB difficult to comprehend, particularly shares bought through corporate actions. These purchased shares appear in the corporate actions part of the report and not under trades (where other share purchases are listed) and are often fairly unintelligible, whereas I just treat them as a normal purchases in my spreadsheets.