Save Vacationer Name with airSlate SignNow

Save vacationer name

hey there it's Aaron with time-saving templates and today I want to go through a demonstration of one of my templates the VRBO rental income and expenses tracking template this one is specific for if you use VRBO vacation rentals by owner and people book your rental through their website this template involves downloading a CSV with all your data from VRBO and then you can copy and paste your data into the template in the summary page will automatically add up the totals for the fees taxes and income that you receive through that system and I have several options right now you can choose from 1 2 3 up to 4 vrb owes and I also have the same thing available with Airbnb so let me get into the template ok so here it is I'm gonna go over today the for property with the 2 VRB O's versions and this is the summary page you just named the property in the front for properties that you aren't using if you if they're just blank just put something there can also hide them if you highlight those columns right-click and select hide if you wanted to do that just because if you leave it blank it'll start adding in some numbers there and these are the different pages where we'll copy in the CSV from VRBO and run till one in rental - there's also a place to enter you have like a recurring monthly rent you can enter it here and it populates each month for the whole year or if you have a recurring maintenance fee that's the same amount every month you can select it from the expense categories management fee - 50 and then you can also change at one time and select a date for the change and it'll update that you can also enter variable expenses here same thing you select the category and select the expense category and also you need to assign it to a rental property and that will automatically appear based on what you had entered in the summary page for the property name and the amount and the month or the date if you want to track that the summary is just all annual totals so let me go into VRBO and show you how you can download the information log into your account it VRBO and you'll come here to the left to reservation manager and click on that and then click on payments download and them will enter a date 20-17 submit and then open it up and it has a lot of data let me go back and just show you something if you have more than one property three VRBO you'll download two separate CSVs so that downloaded this property and if you need to switch it select it here at the top I've already downloaded the CSV for for this one so okay so back to the CSV that we just downloaded you'll see it has these error these pound signs right here that's just because the columns not wide enough for the information if you put your cursor up here at the top and get that plus sign it'll highlight everything and then put your cursor in between one of the letters and double-click it and that should even everything out so you can see it all and from here if you want to save it you go to file save as browse save it somewhere that you will remember and the save as type needs to be changed to excel workbook and you can change the name of it so now I had number one is done so let me start with dawn which is the first CSV I downloaded so I'm just gonna hold the shift key and then scroll to the right all the way to the end of the data and then I'm still holding holding the shift key and then scroll down to the bottom of the data and a ctrl C will copy it and then go back to the template and a ctrl V will paste it in everything should line up and then the summary should be pulling in the rental income the legal and other fees are the VRBO fees taxes collected that's my example you get two blank categories you could add something in here and what I want to also show you is if you've bought the template more than a year ago or it's been a year since you've used it and you're going to use it again I always recommend that you double check the column headers in fact I have a note up here be sure the current CSV headers match the template headers okay so how you compare the headers is you come up here to the top to view make sure you have the template and the CSV open come to view side by side and select the one you want to review against and if it does that I'm really bad about not closing out my side-by-side view just click this and it'll line it up so now we have two split screens where we can double check that we have the same information in the CSV and in the template so column a is reference ID column B is reservation ID so we're just going along and checking every few to make sure it matches get synchronous scrolling is on if you want to turn that off just go to view and uncheck synchronous scroll hey by guest is P your revenue payment processing payable to you okay so everything lines up that's all that you really need to do so again if you're interested in that template head on over to time-saving templates comm and check out the property management section I have a lot of other templates for property management as well there's also other templates where you can just enter the rent directly into it if you don't want to deal with downloading the CSV x' thanks again for watching and come back soon for more tips on how you can save time with Excel templates