Keep track of income and expenses for your rental property using these spreadsheets. I made these for my own rental property and have been testing and tweaking them for the past 7 years.
Video walkthrough of the spreadsheets: https://www.youtube.com/watch?v=gi0i6SOUpiY&t=472s
2 VERSIONS INCLUDED
>>> VERSION 1
Record income and expenses for your investment property for up to 10 years (1 tab / spreadsheet per year). With these spreadsheets you can track positive or negative gearing and how much the property is truly costing you.
For each year, there is a tab to record income and expenses. 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. 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.
Anything you enter in the tabs for each year will automatically populate the summary tab. The summary tab has a pie graph of expenses (by category) and a bar graph for income versus expenses.
>>> VERSION 2
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. 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. I enter forecast costs in red. Once they have been spent I change the font color to grey.
- Income and Expenses Summary tab
- Rental Income - Make sure you've received all of the rental income you're owed. Especially helpful if you have a share house with multiple tenants, or are leasing out rooms in the home you live in
- Ongoing Costs Forecast - Pre-filled with more than 20 ongoing costs such as pool maintenance, gardening, pest control, smoke detector maintenance, insurance etc. You can add your own items as well. This spreadsheet can be used before you even purchase a property so you know how much you're up for. Once you've purchased a property you can transfer these forecasts to the 'income and expenses' tab
- Property Improvements - Improvements made to the investment property (e.g. cost of painting, purchase a new oven). This spreadsheet is not for repairs or regular ongoing expenses such as body corporate. If you live in Australia, send this to your Quantity Surveyor when they are preparing your tax depreciation schedule
- Upfront and selling costs - Use this to record how much you paid for the property (not just the selling price, all of the other on-costs too!)
You can also use this to help determine if a property you are interested in purchasing is actually feasible (and the true costs).
There are sections to record upfront repairs and renovations, as well as the sold price and selling costs. This spreadsheet will assist in calculating Capital Gains Tax and / or guide you to determine how much you need to sell the property for in order to make a profit.
- Loan comparison - Use this when you first obtain the mortgage, and also when you want to refinance. You can compare fixed and variable interest rate loans for up to 3 lenders. There is space to record upfront fees, annual fees, extras (e.g. credit card with no annual fee) and any specials or promotions. There is also a section to record refinance costs such as break-fees so you can determine the total true cost of refinancing
- Management Fees Cost - calculate how much it costs to hire a property manager to perform regular inspections, keep up to date with legislation, handle the lease documents etc. You can see different scenario's of how much you'll pay in property management fees depending on how much rent you charge per week/month/year. You can change their commission % to whatever number you like
______________________________________
If you have multiple rental properties, I have another version of the spreadsheet that can be used for up to 10 investment properties which is available here: https://allaboutplannersshop.etsy.com/listing/962096463
______________________________________
ABOUT THE SPREADSHEETS
- Instant download - start using it straight away!
- Excel file format (can also be used in Google Sheets and Numbers for Mac)
- Formulas will automatically pull the numbers through from the detail tabs (where you input your information) into the summary tab so you don't need to enter things twice
- Can make as many copies of the spreadsheet as you need for each of your rental properties
- Purchase once and re-use again and again each year
These spreadsheets are a perfect, simple and easy to use tool for non-financial people :)
Both a blank version and a pre-filled / example version are included in the download.
Note: I have not included tax implications in this spreadsheet so you can live anywhere in the world and use these spreadsheets
______________________________________
SPREADSHEET FEATURES
- Simple, clean, non-gender specific design
- Formulas automatically calculate
- Tips and examples are in the spreadsheets to help guide you/recommended use (hover your mouse over cells that have a red triangle in the corner)
- Currency can be changed from $ to pounds, Yen or any other currency you like
Files will be available for INSTANT DOWNLOAD after payment has cleared - please check your Etsy registered email address for the link to the download page.
______________________________________
YOU MAY ALSO BE INTERESTED IN:
- Personal budget spreadsheets: https://etsy.me/3odS4ei
- Family budgeting spreadsheets: https://etsy.me/325GpDc
- Budget binder EDITABLE http://etsy.me/1NbYBhS
- Get it all printable planners: http://etsy.me/2cJWKVi
- Tax planner (EDITABLE) http://etsy.me/1OoEykU
- Direct Sales Planner (EDITABLE) http://etsy.me/1RacUE8
______________________________________
TERMS OF USE/USER AGREEMENT
I am unfortunately unable to provide after sales advice/troubleshooting on how to use Microsoft Excel or Google Sheets. Basic excel skills are required. There are no refunds under any circumstances, including if you do not have basic excel skills.
I accept no responsibility for errors that may be made in this spreadsheet. I am not accountant – I have created these spreadsheets based on my years of experience running an Etsy shop and online business. You are responsible for ensuring values are correct. I recommend that you carefully check you have entered the correct vales and have not over-ridden formulas prior to using the information for taxes and financial reporting, and consultant an accountant if required.
These templates are strictly for your personal use only. They are © All About Planners – you may not modify, reproduce or alter the templates, share with others or sell in original and/or modified format. I will not hesitate to proceed with legal action for violation of these terms of use.
By purchasing you accept and agree to the above terms of use.
______________________________________
PLEASE READ
>>>> Software requirements
- These spreadsheets were made in Excel 2016
- They should also work with earlier and later versions of Excel although I cannot guarantee this
- They should also work with earlier version of Excel although I cannot guarantee this
- They will work in numbers on a MAC
- They will work in Google Sheet which is free online: https://www.google.com/sheets/about/
I am not responsible if you are using a different software program and the files do not work. There are no refunds if these files will not work with your PC/laptop, or if you do not have basic excel skills and have problems formatting and/or using the spreadsheets.
The spreadsheets are intending for using on your computer or laptop (digital files to be used digitally).
Most instant download items (and all sets) come in zipped folders. Please ensure your computer can open zipped folders.
The watermarks will NOT appear on your copy.
Colours may vary depending on your monitor and printer.
There are no refunds on digital items.
______________________________________
DOWNLOADING THE FILES
Please note that this is a digital product and no physical product will be sent.
Files will be available for INSTANT DOWNLOAD after payment has cleared - please check your Etsy registered email address for an automatic email containing the link to the download page. If you have changed email addresses or cannot locate the email which may go to your spam/junk folder, instructions for accessing the download page are included in the 'notes from seller' on your order receipt.
______________________________________
(c) AllAboutTheHouse http://www.etsy.com/shop/AllAboutTheHouse
Digital scrapbooking store: https://www.etsy.com/au/shop/PaperCravings
Online store: http://www.allaboutthehouseprintables.com.au/
Blog: www.allaboutthehouseprintablesblog.com