Collaborate on Property Management Invoice Template for Non-profit Organizations with Ease Using airSlate SignNow

Property management invoice template for non-profit organizations

what's going on everyone my name is andrew and welcome to real estate basics at the time of recording this video i have three deals under my belt with a fourth that's under contract and soon to close a little bit of background about myself i am a seven year submarine veteran and i'm currently an active navy reservist with a full-time w-2 job today i'll be walking you through revision one of my bookkeeping spreadsheet for how i keep track of all my recurring and periodic expenses associated with my rental properties now this is a working document and i'm always open to suggestions so if there's something you feel like i can improve to make this tool a better fit for you please let me know by leaving a comment down below with that let's go ahead and get started so for this spreadsheet there are two main tabs you need to focus on there's the year at which you're keeping your expenses and there's also an overall summary tab but more on that in a minute you'll see for the year that you're keeping track your expenses on there are three main sections there's recurring expenses summary and expenses so start with the easy one recurring so these are your monthly payments to happen on a regular basis such as your pity any utilities that you may or may not cover for your tenants hoa and property manager fees along with your rental income all you need to do is type in the month type in the associated numbers and that's it now real quick let's take a look at these categories for our expenses so i've assigned a letter to each one a for advertising c for cleaning so on and so forth that comes into play all the way over here to the right so this is a table within excel if you're not super familiar with tables they're not very hard to work with they're very easy but if you're unsure a quick google will help you figure them out so all you need to do is let's say we have a new expense for today you just come right below the table make a new entry say today is 7 august 2021 and let's say it was a 200 expense it was going to be a legal fee and we're going to say we talked with our cpa some notes associated with that expense to help you remember what that expense was for and you'll see over here in this expense summary this 200 fee in august just got populated so what this table does this expense summary does is it'll pull for each category and each month what those expenses are and then for each month you'll see the summation of all the expenses you had for that month and for each year you can see the total that you spent in that particular category and last but not least you have your overall summation of all the expenses for that given year now going back to the summary tab this is pretty manual unfortunately this is revision one like i said but it will quickly show you how your expenses are stacking up year over year so how i have this set up is just basically grabbing the values from the associated tables and dumping them here so you can see the total expenses your total rental income and what your net profit or loss would be for the year and that's it it's pretty basic spreadsheet it's a little bit labor intensive but in my opinion it gets the job done now i am open to suggestions for making this a better tool for you to use so like i said in the beginning please leave a comment down below if you have any tips or ideas for how to make this spreadsheet a better tool for you to use and with that the link to download this spreadsheet absolutely free is down below in the description so please check it out and let me know what you think that's all for this one so if you like this content please like and subscribe and until next time take care