monthly rental property expense spreadsheet

#Monthly rental property expense spreadsheet how to#
#Monthly rental property expense spreadsheet update#
#Monthly rental property expense spreadsheet download#

Especially helpful if you have a share house with multiple tenants, or are leasing out rooms in the home you live in Make sure you’ve received all of the rental income you’re owed. Once they have been spent I change the font color to grey. This spreadsheet can be used for scenario analysis to see if a property you are interested in purchasing is likely to be positively or negatively geared. This version has the same income and expenses summary spreadsheet as version 1, but it can be used for any year and is not linked to a summary tab. The summary tab has a pie graph of expenses (by category) and a bar graph for income versus expenses.

#Monthly rental property expense spreadsheet update#

On each of these tabs is a pie graph of the expenses (by category) which will automatically update as you enter values into the spreadsheet, so you can see which expenses are big ticket items, where you might be able to cut back, and also to forecast future maintenance items.Īnything you enter in the tabs for each year will automatically populate the summary tab. The expense categories are pre-filled but you can type over the top of the existing categories and add your own in the blank rows as well. With these spreadsheets you can track positive or negative gearing and how much the property is truly costing you.įor each year, there is a tab to record income and expenses. Record income and expenses for your investment property for up to 10 years (1 tab / spreadsheet per year). I’ve made 2 versions of the spreadsheet: Version 1 Property spreadsheets (use for up to 10 properties).Rental property spreadsheets (use for 1 property).If you’d like a copy of these spreadsheets, they’re available from my online store or Etsy shop: Online store To enlarge the screen of the video, click the square icon in the bottom right hand corner of the video (it will say ‘full screen’ when you hover your mouse over the icon). If you have an investment property as well, or want a spreadsheet to help you forecast how much it’s really going to cost (there’s been a lot more unexpected expenses than I thought there’d be), I’ve recorded a video walkthrough of my spreadsheets: Let’s take a closer look! Now I have an organized system for tracking income, expenses, forecasting future expenses, a comparison calculator when I want to refinance my loan, management fees calculator and spreadsheets I can send to my accountant at tax time. So I made an Excel spreadsheet which, over the years, has turned into many Excel spreadsheets. I want to be able to track it’s historical performance and forecast it’s future performance. I get an annual statement from my property manager but that’s after the year’s gone and is only a historical look at how my investment is performing. I’ve purchased printables from you – how should I set up my planner?ĥ Years ago I purchased an investment property.What is a Printable? What happens when I purchase a printable from you?.Why printables? Do you sell printed versions of your products?.Shop my favorite planner supplies on Amazon.200 Blog Post Title Prompts (For Any Type of Blog).

#Monthly rental property expense spreadsheet how to#

54 Mistakes Etsy Sellers Make (And How to Fix Them).

#Monthly rental property expense spreadsheet download#

200 Blog Post Title Prompts (Exclusive Download Content).1200 Blog Post Ideas (Exclusive Download Content).Free Graphic Design Video Tutorials Library.Digital planners and notebooks in Microsoft PowerPoint.

Free Printables Library – Subscribers Login.

52 Planners in 52 Weeks (The Weekly Spreads).

52 Planning Systems in 52 Weeks (Introduction).