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 email@example.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.
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.