Mar 10, 2012 11:49 AM
Excel template for accounting for rentals
-
Like (0)
Get answers to all of your questions from fellow owners and travelers.
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 developd 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, email me directly at livngstn@gmail.com
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!
In partnership with:
worldwide leader in online vacation rentals
Use of this Web site constitutes acceptance of the HomeAway.com Terms and Conditions & Privacy Policy.
© Copyright 2006-Present HomeAway.com, Inc. All rights reserved.
