Join our investing community

tracking spreadsheet for property

Discussion in 'Real Estate' started by Triu, 22nd Jan, 2007.

  1. Triu

    Triu Well-Known Member

    Joined:
    1st Sep, 2006
    Posts:
    161
    Location:
    WA
    Hi has anyone got a spreadsheet for tracking income and expenditure for invesment properties. I was using excel rentalworkbook but they want to charge $99 every year for the licence.

    Has anyone got a free one or should just slave away and make my own.

    any tips?
     
  2. Redwing

    Redwing Well-Known Member

    Joined:
    9th Jun, 2006
    Posts:
    476
    Location:
    PERTH..WA
    You can try EZ RENT..Go to the Peach HomeLoans site for a free Download.

    Property Manager Pro is another one to look at (not free)

    (PS- I use the Excel Rental Workbook)
     
  3. Dunsborough

    Dunsborough Active Member

    Joined:
    16th Aug, 2006
    Posts:
    32
    Location:
    Bunbury WA
    All my finances are tracked with Quicken Personal Plus, i cant praise enough the things it does, ie graphs, reports etc. Again this costs but is way in front of any freebies i have seen
     
  4. Simon Hampel

    Simon Hampel Co-founder Staff Member

    Joined:
    9th Jun, 2005
    Posts:
    4,623
    Location:
    Sydney, Australia
    I agree with Dunsborough ... Quicken Personal Plus and Quickbooks are excellent tools for this purpose (I use both).
     
  5. Triu

    Triu Well-Known Member

    Joined:
    1st Sep, 2006
    Posts:
    161
    Location:
    WA
    Sounds Great Dunsborough, do you have to pay each year for an upgrade like the excel rental workbook?
     
  6. Dunsborough

    Dunsborough Active Member

    Joined:
    16th Aug, 2006
    Posts:
    32
    Location:
    Bunbury WA
    No i bought it outright in 2006 but in the fine print you dont own it, you aquire the rights to use or something along those lines.
    Sim may correct me here, only reason i would go and buy 2007 version is so that the tax module is up to date. At this point i reckon i go and spend another $149 in three or four years as it is doing everything i want for now.
    I had been a MSmoney devotee for many years but liked the fact Quicken have a australian version and online. Ability to download stock quotes online a nice facility with Quicken, but if i start praising it i will be here for hours.
    Took me many hours getting the best out of it, but definately worthwhile.
    I just Bought Somers PIA as well :) but getting bit off subject.
     
  7. Redwing

    Redwing Well-Known Member

    Joined:
    9th Jun, 2006
    Posts:
    476
    Location:
    PERTH..WA
    here's a demo of The Rental Workbook for those that haven't seen it before (flash and powerpoint) Excel Australia - Demo

    I've recently been given version 10 of MYOB by my wife who used to do her Dads books is this any good (better than Quicken or the Rental Workbook)?
     
  8. Dunsborough

    Dunsborough Active Member

    Joined:
    16th Aug, 2006
    Posts:
    32
    Location:
    Bunbury WA
    Different strokes for different folks
    had good look at excel, i am sure it good but i stick with Quicken, while it has been while since i looked i really felt i needed more accountancy skill than i have to use Myob, having said that it is huge in small business all across australia
     
  9. Bob

    Bob Well-Known Member

    Joined:
    16th Aug, 2005
    Posts:
    131
    property software


    And so user friendly....it's great

    Bob
     
  10. coopranos

    coopranos Well-Known Member

    Joined:
    11th Oct, 2006
    Posts:
    498
    Location:
    Perth
    Another option is Simple Invest: BGL / Simple Invest / Sales

    I have only downloaded a trial version of the software, but it looks pretty comprehensive.
    You can track assets and income/expenses. The extra benefit is that if you have a managed fund portfolio you can track the actual distribution components (tax deferred, capital returns, etc etc) so working out capital gains is a breeze as it tracks all the cost base changes (essential as anyone who has sold units in managed funds and put it on a reinvestment plan for a few years and then tried to work out the cost base can testify!).
    The drama is that it is $165 to purchase, then $110 a year subscription renewal, which I think is probably a bit steep, but I guess if you enter everything as you get it, you would save at least this amount in accounting fees.
     
  11. MrM

    MrM New Member

    Joined:
    7th Feb, 2007
    Posts:
    2
    Location:
    Perth, WA
    Mortgage Checker

    Dunsborough, do you know if you can use Quicken to check the interest charges on your loans (sorry if this is slightly off-topic)?

    I use a Mortgage Checker by www.HomeMoneyManager.com to make sure all my loan calculations are correct and to make sure I'm not being overcharged by my bank.

    Having already been overcharged three times in the past, do you know if I swap over to Quicken to manage all my finances, whether I will be able to recalculate and check all my interest calculations?

    Thanks
     
  12. Dunsborough

    Dunsborough Active Member

    Joined:
    16th Aug, 2006
    Posts:
    32
    Location:
    Bunbury WA
    In short i would say no, it not a audit program as such, ie it will reconcile accounts etc but i doubt it could do what you after, i would go after the specific software for that:) .
     
  13. MrM

    MrM New Member

    Joined:
    7th Feb, 2007
    Posts:
    2
    Location:
    Perth, WA
    Thanks Dunsborough ... Guess I was hoping for a bit too much! :D