Create a Rent Receipt Template Excel for Teams Seamlessly

Rent receipt template excel for teams

hey there it's Erin with time saving templates and today I'm going to be going over a template that we have here in the rental property management section at time saving templates if you have rental properties and you want to have an easy way to track your rental income and expenses and at the same time be able to print or send or email a Rental receipt to the tenant or tenants this template includes an upgrade to add the Rental receipt process and make it a little bit easier for you so let me jump into the template so this is actually a variation of the landlord template which tracks rental income and expenses and summarizes everything and the main difference is that you will now have just a quick snapshot of how this works you'll see different tabs and pages of at the bottom we have rental property one two three and for each Toronto property you will have a one page to enter your rental income details as well as your expense expenses per property with different expense categories and so you can use this to enter the income you receive the expenses and it will summarize a monthly summary as well as an expenses summary and the gray cells are formulas that will update and then there's also a main summary page that's going to list out each property we have different versions starting with a five property version so you'll be able to to see all properties together and the annual totals but I have another video that goes more in detail how to use like the basic version of this template which doesn't include the rental receipts but I wanted to do this version to go over how to use this rent receipt you'll see that each property has two tabs so each property will have a Rental receipt tab that is linked to your your page as you're entering the the details so let me just do a couple of examples say that you receive the rental income you would just there's several columns here the only columns you have to really enter are going to be date paid if you want that allocated to to a particular month so I'll just put three one and rent paid 700 and then the rest of the columns you don't actually have to put something in but it's there if you want that's enough to populate the rental income for March in our summary Tab and then if you are wanting to track this remaining balance you also have to enter how much you're charging for rent so that it can calculate any balance due so if I were say I was charging a thousand a month and they paid 700 then it would calculate that we still have our remaining balance and that's going to carry over every month until it's paid for this example I'm just going to put it at 700 so we have no remaining balance keep it simple and so now we want to go and print or email the rent receipt so we're going to click here so you would enter this information up here your name your contact information and then for the receipt part we're just going to enter the date paid so we have March 1st for this one so I'm just gonna do March 1st and it's pulling in that 700 now if I let's see customer name if I were to track the customer names then it'll pull that information over too there's a place for notes Here really that's all you have to do it's gonna print a receipt or save the receipt based on the date you have here so if you have multiple dates you could put in you would just add the date again well obviously you don't want to add March 1st twice so a couple things to note if there's multiple payments on one day you're gonna want them in one row because it's not it's just gonna pick up the first occurrence on March 1st so if there's another check you want to include put on another date you could do that so if March 2nd then they pay a 50 late fee or something like that you can it that part will work to update the amount paid but if it's all within one day you want it to be on one row so say that we have it ready to go this is the receipt we want to go ahead and send it to the customer a couple ways you can do this so you could either just print this straight out it's set for one page and just print or if you want to email this I would recommend saving as a PDF that way you're not emailing them all this other this Excel file with all these tabs and with a PDF they can't really change anything if you send this as an Excel I mean they could come in and edit this but PDF seems to be the better option in most cases so to save as a PDF I would so first I would save your Excel file first just so you have it as a backup so we saved the Excel version we have that and then now we want to save this page as a PDF so we're going to do file save as and go to browse and we're going to save find a place where you want to save the receipts to maybe a receipt folder and then save as type you're going to click in this box and change it to PDF and then you also want probably want to change the file name so rental one March receipt or you could put your customers name and then click save so that's going to open up a PDF here and it just saved that one page as PDF so now that is ready to send so that is how you can save a PDF of just the rent receipt page but be sure you save the Excel file before you do that because well the Excel files still still here you want it saved in both Excel and PDF so that is how I would do it for saving as a PDF if for some reason you don't want to save as a PDF and you just want a copy of the Excel you can also right click this rent receipt tab click on move or copy and click create a copy and then select new book and okay that way you want create a copy so the original stays in your main file and then when you create a new book it's just gonna pull over that rent receipt one and it's going to pull it over to excel now if I click in here it's still linking to the this formula is still in here linking to the file so that's why when you save it as a PDF all the formulas are removed and you don't have to worry about anything changing if for some reason you delete something in the main file but that's just another way you could do it so back to the main template that is how you would print out your rental receipts there's a lot more features in here that I really didn't have a chance to go over such as entering the expense categories but it really works very much the same as the income you would just enter an expense category enter a date we'll stick with March and then enter an amount and then there's other columns if you want to add more detail but that's going to then total as an expense in your monthly summary and in your expense category summary as well as the main annual summary page so I'll link to the original landlord video as well as this is a separate listing the one that has the rental receipts so if you're interested in finding this one this Rental receipt template I'll link to it but also you can go to timesavingtemplates.com and then go to the shop and then Property Management that's where you're going to find all the rental property management templates that we have as well as a couple videos helping and a quiz that will help you decide which rental template to get and if you scroll this is the Rental receipt template right here in the middle section so feel free to check that out and then we also have some free resources if you go to Time savingtemplates.com free resources there's going to be a rental property management section and that will have a free property Improvement tracker template that can help you keep track of things so feel free to check that out we also have a free guide to getting started with Excel if you enjoyed this video please like And subscribe and until next time don't forget I'm here to help you streamline and save time with your Excel spreadsheets whether you're using Excel to manage your rental properties or we also have small business templates as well as HR and compensation related templates which is my corporate background so thank you again and I will see you next time