#Spreadsheet for monthly expenses renter professional#
#Spreadsheet for monthly expenses renter free#

Office of Science and Technology Policy.Executive Offices Show submenu for “Executive Offices””.Administration Show submenu for “Administration””.The only difference you will notice is if you have set a rent increase to occur after a period of time, the new amount due will be displayed for due dates after this time and the check numbers in the column E are offered to your automatically after entering the first check number.

#Spreadsheet for monthly expenses renter free#

The payments section is used in the same way as in the free version of the spreadsheet. Increase amount - enter the amount that the rent will increase by (not the amount it will increase to) into this box.

Rent increase in - if the rent is due to change part way through the tenancy, for example after a period of 6 months, or at the start of a new year, enter in the number of payment periods the increase will begin in, in this box. Tenancy term - unlike the free version, there is no 12 month limit, so the tenancy term can be set to cover longer periods if required. By changing the logo this way, it will automatically be displayed in the correct size, on the right place of the page. The easiest way of replacing the logo is to right click on the existing logo, and select 'Change picture' from the menu. The text (company name, landlord address, tenant name etc.) can simply be replaced by typing over the template text.

#Spreadsheet for monthly expenses renter professional#

The spreadsheet is designed in such a way that the Spreadsheets123 Trade Marks are outside of the print area, so while visible on screen, will not be shown on the printed rent payment schedule, giving it a more professional look and feel, which is useful for landlords and letting agents wishing to supply a copy to their tenants. Immediately obvious is difference in the space at the top of the page, where you can now enter your company name and logo, as well as the name and address of the landlord. The paid version of this spreadsheet works in much the same way as the free version, but a few additional features.

Place to add your company address and logo.

No Subscription - Pay once, use it for as long you need.

This can be useful if incorrect payments have been made at some stage, or for budgeting for the future. The balance will show the total amount of rent outstanding for the entire rental period.

Should a payment later be disputed, this will make it easy to find evidence of the payment. The check number and receipt number columns are for you to enter information for your records. If the amount equates to an overpayment, the text will be green, while and underpayment will be red. If the correct amount has been paid, the text will appear blue. Entering paymentsĮach time rent has been paid, enter it into the amount paid column (D). Below this, the total amount of rent due (based on the tenancy options) will be displayed. This includes the name of the tenant who will be renting it, and the address of the property itself. To the right of the tenancy options is a space for entering information about the property. As the start date and payment frequency are used to calculate the due dates, much like the deposit, this information is for your records, and not used elsewhere on the spreadsheet. Rented to - enter the last day of the tenancy in this box. This, along with the information in the 'Rent to be Paid' dropdown will be used to populate the dates due in the table below. Rented from and including - enter the first date of the tenancy in this box. This information is for your records, and is not transferred elsewhere on the spreadsheet. Use this box to enter the amount of rent due for each payment.ĭeposit - enter the deposit paid for the property in this box. Rent - the exact wording of this will change to reflect what you have entered in the 'Rent to be Paid' drop down, for example, if the rent is paid monthly, it will read 'Monthly Rent'. There are several options here, from the weekly or bi-weekly, through to annually. Rent to be paid - use the drop-down list in this section to fill out how frequently the rent is paid. The free version of the spreadsheet has a 12 month limit, whereas there are no time constraints on the paid version. Tenancy term - use the box in column D to enter the tenancy term in months (e.g. The spreadsheet is designed to be printed on A4 paper, making it ideal for both keeping a record, and for providing tenants with statements. At the top of the page are a number of options relating to the tenancy, which will be used to populate the table below. The rent payment schedule is designed to be as user friendly as possible.