Get the rental ledger form

Hello this is a quick instructional video on how to use this excel sheet for your rental property so what you're gonna see first is your categories listed over here it's an alphabetical order and it Scrolls up and down for easy navigation what you want to do is add the amount to the right of each category so say for red collected you collected $2,000 in rent just enter that in and maybe the next month you collect the $2,200 in rent and it keeps a running tally over here in this cell and this cell will add all of this up right here and even if you run out of room you could still go over here and add more in it goes out pretty far so even if you add it over here it still changes the number over here in tallies everything up and I try to add every single category possible but if I try to add even more than that this was gonna be way too long so I did include blank areas that for your particular reasons you might have say pool services I thought you paid $200 for just enter that in it will tally it up over here if you keep on scrolling down there will be this part for improvements and if you hover over this you'll see that it gives you a brief explanation of what this is if you want something in more detail just click on it it'll open up a separate link to a webpage that allows you to read it in more detail according to the IRS just enter in the description of what it was a dishwasher entering the date that you put it in and in turn the cost and that's really it once you do this throughout the year you'll get the full totals tallied up over here now I do have another excel sheet that's more detailed for some of my other clients that are more particularly with how they keep track of their records sometimes they want it done by the month so this is a second one where there are tabs per month for each course on your month and then this tab right here we'll just add every month up and give you a total over here you can find this at our web page and there is an instructional video for it as well on our YouTube page along with other videos so please let me know have any questions in a comments below I'll try to answer it my job here is to try to make your life a little easier and I hope I did that