If you have multiple dwellings in your rental properties, check out my Multi-Dwelling Rental Property Tracker: There’s so much this template can do! Grab your copy today and get to know your business better! Property Stats - See your income, expenses, and profit by property, location, and class. This worksheet automatically populates based on your entries in the Rental Book. Profit & Loss – See your profitability by month, annually, and over a lifetime. This worksheet automatically takes your financial data and compiles it into 16 easy to understand charts. Tenants - Track tenant details including property address, rent, deposits collected, pets, move-in date, term length, and more.ĭashboard – The Dashboard shows you a snapshot of your company’s performance. Store data such as address, location and class, purchase price, mortgage, insurance, square footage, bedroom and bathroom count, occupancy status, and more. Properties- Keep track of your investment properties on this worksheet.
![rental property expense tracker rental property expense tracker](https://i.etsystatic.com/22069861/r/il/faeaad/3277013165/il_1588xN.3277013165_tpw0.jpg)
Rent Tracker - Track payments received by property, and note whether they were on-time or late. Rental Book – Track your rental payments received, expenses incurred, and more. You'll input certain data into the Headers tab and all other worksheets will automatically populate with the same data where needed. Headers - The Headers tab is the home of all your properties, locations, and classes. See your financial data displayed on 16 easy to understand charts, view your profit and loss by month, annually, and lifetime, and much more.
![rental property expense tracker rental property expense tracker](https://db-excel.com/wp-content/uploads/2019/01/track-your-expenses-spreadsheet-in-screen-shot-at-pm-recent-of-track-your-expenses-spreadsheet.jpg)
Easily track your rental properties, tenants, rent payments received, expenses incurred, and much more.
Rental property expense tracker full#
This all-in-one, ready to go excel spreadsheet is packed full of tools for almost any investor. Excel Spreadsheet / Google Sheets Compatible. Rental Property - Income & Expense Tracker.