Record Keeping - Aussie Stock Forums

Results 1 to 14 of 14

Thread: Record Keeping

  1. #1

    Default Record Keeping


    I have finally decided to become more 'active' with my share investing (rather than just relying on managed funds). One question I would like answered before I start is....What is the best method of keeping records of my transactions (costs, purchases, sales, profits, losses etc etc)?

    Are there any standard templates/spreadsheets available that I could use (as a guide) to keep track of my activities. Does commsec have a back office where you can record this info?

    Many Thanks

  2. #2

    Default Re: Record Keeping


    When ever i make a trade, Comsec will email me a pdf document which summerises everything. So i keep a hard and soft copy of both. Its pretty much all the information you will need.

    Comsec, also has its own portfolio to keep track etc to.

  3. #3

    Default Re: Record Keeping

    Hi Mika

    I keep all my records that I need for tax purposes in a spreadsheet.

    If you know how to use Excel and you understand your tax situation it shouldn't be too difficult to set up your own spreadsheet.

    My spreadsheet does all my tax calculations. Come early July, I simply print it out and hand it over to my accountant along with whatever else he needs.

    The spreadsheet allows me to see what my tax liability is at any time - plus it makes my accountant's life a lot easier.

  4. #4

    Default Re: Record Keeping

    Have a look at Stator, its a Ozzie product and does position sizing, stop loss management and system analysis. Of course captures transaction costs and daily profit/loss.


  5. #5

    Default Re: Record Keeping

    I use spreadsheets. I've trialled Stator and OTrader, and I preferred the latter.

  6. #6

    Default Re: Record Keeping

    Also, if just long stocks or just buying options, you could use Quicken Personal Plus. Not sure if ShareAnalyser or whatever it's called manages your portfolio.

  7. #7

    Default Re: Record Keeping

    What information should be recorded for accounting purposes?
    i.e. brokerage costs, cost of shares, gain/loss, interest expenses.......anything else??

  8. #8
    rowes's Avatar
    Join Date
    Sep 2006
    Woy Woy

    Default Re: Record Keeping


    There is a ton of info, including pdf forms for CGT events and other pdf booklets that explain everything you need for the tax man come that time of year at http://www.ato.gov.au

    good luck

  9. #9

    Default Re: Record Keeping

    I'm an accountant. You don't know how frustrating it is when clients keep poor records. Anyway, a simple excel spreadsheet will do the job.

    I can't seem to attach files here. You can send me a private msg with your email address. I will send an xls file with an example of how the workpaper should be formatted.

    Last edited by ctp6360; 8th-January-2007 at 11:49 PM. Reason: fixed spelling and grammar

  10. #10

    Smile Re: Record Keeping

    ..... just ask ATO to send you a copy of their simple
    spreadsheet on CD, called E-Record ... works a treat
    and also calculates GST figures, for those who need it ...

    happy days


  11. #11

  12. #12

    Thumbs up Re: Record Keeping

    Quote Originally Posted by Mika
    What information should be recorded for accounting purposes?
    i.e. brokerage costs, cost of shares, gain/loss, interest expenses.......anything else??
    All of the information items you mentioned above except interest expenses can be derived from COMSEC's Contract Notes Summary list that you can get to with menu path ... Positions Statemets>Confirmations>Search. You download the summary list to a Xcel spreadsheet then with a bit of Xcel skill you should be able to derive the info required at tax time. No need to keep a separate record keeping since you are a COMSEC online trader already (I assume from your mentioning of Comsec earlier).

  13. #13

    Default Re: Record Keeping

    You can try out Manage Invest. It's also an Australian product. Although it's not out yet but you can register to receive the beta version of it for free, in which case you'll actually even get the final product for free after the beta.

    You can find it at www.manageinvest.com

  14. #14

    Default Re: Record Keeping

    No need to keep a separate record keeping since you are a COMSEC online trader already
    Except for dividends, capital returns stock splits, takeovers etc. If you want to claim expenses then you need to record them as well.

    Also you will probably want better statistics on closed trades then Comsec can give you, even if it's for your own knowledge.

Similar Threads

  1. Question about ex-div date and record date
    By mim168 in forum Beginner's Lounge
    Replies: 3
    Last Post: 7th-April-2008, 10:29 PM
  2. Keeping cash reserves - How does it work?
    By PennyHopeful in forum Beginner's Lounge
    Replies: 2
    Last Post: 4th-September-2007, 10:50 PM
  3. Record Date
    By xjzha1 in forum Beginner's Lounge
    Replies: 0
    Last Post: 23rd-April-2007, 10:54 PM
  4. Record date for loyalty options
    By feeding_the_fire in forum Beginner's Lounge
    Replies: 1
    Last Post: 27th-February-2007, 09:39 PM
  5. New Record
    By sandik17 in forum General Chat
    Replies: 7
    Last Post: 17th-February-2006, 03:11 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Aussie Stock Forums