Create a Tax Invoice in Excel for Real Estate with Ease

Tax invoice in excel for Real Estate

[Music] hi guys welcome to another youtube video here today i'm gonna cover um a project i've been working on and this project is gonna save me a lot of time going to year 2022 and i would like to share this with you and see how i i did it as i continue to grow and move forward and get busier i have to find ways to try to save time and be more efficient and this project was one of the things i decided to do for next year going to next year to save some time today i want to share with you guys what i've been working on it's a pretty huge project took me a couple days um to work on it okay so i'm going to show you here this is the old spreadsheet we're using as you can see quite a bit of tap here at the bottom and every time i had to scroll look for things it was i was losing time or seconds and it adds up and then each each unit rental unit had its own spreadsheet expense spreadsheet so every time i had to input some i had to scroll back and forth and as you as you can see that actually it's very time consuming and adds up and i had going up to may up to 15 expense report just for this spreadsheet have madness tab and it goes on you can see here home build rebates tab this was my old spreadsheet and it took it took uh years for me to get to of course where i was at with this spreadsheet but i decided this year going into 2022 to actually save some more time look at how to reduce and every every seconds adds up every little second you do adds up for you more time to run your business do things that you want to do i consolidate my spreadsheets um i simplify it i'm trying to save time um trying to save some time instead i have to scroll down so many tabs that i have from my own my old excel each rental unit had its own expense report so now what it did is i i'm gonna use one row and each row will have a category to correlate with each rental so let's say rental 10 today's an expense here and the location was um i went to say home depot on go road and see how once i click that it calculates my miles and minutes about time that it took me to get there um and put down let's say when they bought some for repairs let's put them out well let's chair let's change the chain to rental once it's right next to so let's go to right here you can see the rents one repair showed up 100 how to generate everything and on my right everything is set up where it will pour everything over it went to one two and three so it makes it really simple let's say a rental let's say rental one had a red pigment okay and so on online say online mail rent payment let's say category is rent i just click on that it's a thousand here and you can see how it generate and pull that information over here and i generate a thousand and i had a condition format where it will actually that's the more brand i get the more it will fill up this bar here that that's just for visual management it's a primary home let's do primary home here just to show how things works here how it works primary home says today date you know let's say primary home okay so let's do rental number two let me show you another one here do rental number two today's date to show you how that condition format bar filled up so you do today since we're just rent payment we're not joining our online payment it's going to be zero okay so let's run payment let's put let's just throw numbers out here so let's do uh 15 000. so you can see it fills up just showing you see how that bar feels all the way up now you can set that bar you can set it uh mount your bim and your max i believe it's set at 16 000 wherever um but it's a nice uh visual management you can have set up for and i did the same thing with the miles as the mods build up that changes that bar also changes color the for the formula i use it's a little bit complicated if i use vlookup here let me show you here this is the formula as you can see i click on it i use category and so that's the red table two is the red the blue is the income expense so it takes all the information pulls over and that's how i i was able to do it because as i get busier i have to find ways to prove improve and be more efficient this is one of the things i'm doing so next year going to year 2022 that i'll be able to save time and um you know the more time i say the more it frees me to do other things or free up time for you to grow and spend some time with your family that's very important [Music] you