Home >> Paper and Books >> Notebooks >> Landlords Spreadsheet Template Rent and Expenses Worksheet for Short Term Rentals

Landlords Spreadsheet Template Rent and Expenses Worksheet for Short Term Rentals

Landlords Spreadsheet Template Rent and Expenses Worksheet for Short Term Rentals
Landlords Spreadsheet Template Rent and Expenses Worksheet for Short Term Rentals
Landlords Spreadsheet Template Rent and Expenses Worksheet for Short Term Rentals
Landlords Spreadsheet Template Rent and Expenses Worksheet for Short Term Rentals

Product Details:

This template is designed to help manage the rental income and expenses for up to 5 different properties. Each property has its own page which is linked to an overall summary. This template is set up to more easily track rental income for short term rentals, where the rent due varies from week to week or month to month, however it can also be used for short term and long term rentals.

How it works~
The main summary page will show the annual totals for each property for the annual rental income, and expenses per category. You won’t actually enter anything in the summary page. Underneath each property name, you can click on the link and it will take you to that properties detail page (or you can click on the tabs at the bottom of the worksheet).

Each rental property has its own page, which contains 3 sections-

Section 1 – On the left side – Will contain a monthly summary of income and expenses and if you scroll down you will see the total expenses by category. These are all based on what you enter in section 2 & 3.

Section 2 – This section has the green headers and this is where you can enter your rental income and any fees. For each payment you receive, you will enter the amount paid, date, customer name, etc. There is also a place to enter any remaining amount due and the due date. Also, more for short term rentals, you will be able to enter the start and end dates for when they will be renting and any extra notes or comments.

Section 3 – You can scroll to the right of the page to see the next section with light orange columns. This is where you can enter any expenses related to the property. There is a place to enter the expense description, date and amount, as well as a drop down list with 14 categories that match those categories used for tax purposes.

*You will be able to add up to 8 of your own expense categories to the expense category drop down list (directions included).

*Each page is already set to print. The 3 sections within each properties page will print as 3 separate pages for each section. Summary prints on 1 page.

You will receive an Excel Spreadsheet and a PDF file with directions, MS Office 2007 version, but should work fine with other versions of excel. You will receive this through email.

If you manage long term rentals (vs. short term/vacation rentals) this other template may work better-
https://handmadeartists.com/product-details/Paper%20and%20Books/eBooks/Property%20Management%20Spreadsheet%20Excel%20Template%20for%20Tracking%20Rental%20Income%20and%20Expenses/?pid=20131008151750238a0


If you manage your short term rentals through vrbo.com and use their reservation manager system, this other template may work better - 

https://handmadeartists.com/product-details/Paper%20and%20Books/Notebooks/Vacation%20Rentals%20by%20Owner%20Expenses%20Spreadsheet%20Rental%20Income%20Tracking%20Template/?pid=201308061421249a6f7

See all my templates here -

https://handmadeartists.com/shop/ErinsInspirations

*You do not have permission to distribute or re-sell the template, so please don't do it.
*All templates come personalized with your name or company name.

Thanks for stopping by!


Shipping :
Items ships from : United_States.

Payment Method:

We accept the following forms of payment:
 
Ship To Single Cost With another Item
United_States $ 0 $ 0
Everywhere Else $ 0 $ 0


More Creations from this Artist!

Vacation Rentals by Owner Expenses Spreadsheet Rental Income Tracking Template   Landlords Spreadsheet Template Rent and Expenses Worksheet for Short Term Rentals   Sales Log Multi Venue Monthly Sales Organizer   Project Tracking Program Custom Made Project Plan Template   Business Financial Printables  Shop Sales and Expenses Spreadsheet   Annual Inventory Template Beginning and Ending Year Inventory Tracking   Printable Wedding Budget Template for your Wedding Planning Binder   Personal Budget Template Printable and Editable Budget Planner  



Price: $ 8.50



Product Information
Product name - Landlords Spreadsheet Template Rent and Expenses Worksheet for Short Term Rentals
Price: USD 8.50
In Stock: 0
Stats

Listed On 2013-11-09

22259 views

Shop Owner
Shop Section
Shop Info
9 items for sale
Action
Bookmark and Share    Share
Report this Item - Report this Product

Follow Us

Close
Landlords Spreadsheet Template Rent and Expenses Worksheet for Short Term Rentals
Landlords Spreadsheet Template Rent and Expenses Worksheet for Short Term Rentals
Landlords Spreadsheet Template Rent and Expenses Worksheet for Short Term Rentals