Customize your experience by selecting your role:
Owner, Property Manager, or Traveler
I have two condo's I just started renting and I'm using Excel for the accounting. It would sure help if I could find a template someone smarter than me has developed rather than try to create one from scratch. Any suggestions? Don
I developed a spreadsheet to track and categorize all my rental property expenses, but I can't upload it here -- excel files are not permitted file-types by the Homeaway community. If you'd like a copy, send me a private message with your email.
I have only one property, but I've expanded the spreadsheet to allow you to track multiple properties if you need to. (I've blanked out my item descriptions and payee info except for a few samples, and changed the actual payment amounts around for privacy reasons, but you should be able to get the general idea. )
There are two tabs, one where I record every payment along with the property, the date and quarter, the class of expense ( a list is at the top to remind me what they are), the actual description of what I bought/paid for, the payee, and the amount. I do this every day so it takes only minutes. After you've entered the various classes of payments once, Excel auto-fills so you don't need to type the whole thing over.
The summary tab allows you to summarize the data for any fiscal quarters and years you select using an excel pivot table. For capital expenses, we have to track the actual quarter, while for other expenses, we just use the annual summary. If you update the expense tab, you will need to "refresh" the summary table.
Hope this is helpful!
Message was edited by: carol
I know your post is pretty old but I just came across it today. Would you be able to send me the link for your spreadsheet template? I'm using one by Money Ledgers and it is good but they are executable files and for some reason Avast wiped my spreadsheets right off my computer. Avast says they didn't but I think they did. Anyway, I'm now gunshy and will probably just go with an Excel spreadsheet and keep them in dropbox and put it on the google cloud drive so I don't lose them again. Thank you for your help. Good luck with your business.
Since my post last September I found a template that I started using. It has just been perfect for me. A lady in Houston has a site and builds templates for a number of things. I found one I liked that was a basic one she had built. I bought a template from her for about $5 and we worked together to add the things I needed to make it work for my situation since I needed to keep track of 8 places. Her site has many templates but here is the one that she now offers for $15. I ended up paying her around $40 for it after the changes but now she can offer the same one cheaper because she hopefully will sell it to a number of other managers: The 2nd link is the one that was modified for me. The first link are similar spreadsheets. Her name is Erin Jones and is so easy to work with if you want to modify something to fit your situation.
I am trying to PM you. I clicked on compose message and then clicked on "select people" and when I click on "C" all I see is my own profile. How do I find you?
To send a PM to anyone, click on the person's icon. You'll see their page, and Send a private message is on top at the right.
You can also go to "your stuff", start a PM, and type in the screen name in the To field.