Create Your Monthly Rent Invoice Template Excel for Government

Monthly rent invoice template excel for Government

hey there it's Aaron with time-saving templates and today I want to show you how to track your rental properties in an Excel worksheet so I have this template at time-saving templates calm the system landlords template and I have several versions of the same template depending on how many properties you have it starts with you'll see at the bottom there's a different page for each template and I have them starting at five properties and then ten 15 25 and 30 property versions so basically how it works is on each rental property page you would put the name of your brenell property here because that way it'll show up in the summary so you can tell which one and also in the standard expenses if you have a monthly expense that's the same every month then you'll want to assign it to that rental property but let me go go through a couple examples first so you would just enter the income details here and then the expenses details here and for the income just be sure to enter a date and the amount and then you can enter any of the other information comments for expenses you can select from expense categories so an expense category a date and amount so the rest of that out if you'd like so the summary in the front of the page will show the total income and expenses and profit loss per month for that specific property not all of my templates have the late fee and other fee or the remaining balance that's an upgraded version that shows the remaining balance say that the rent was 600 then it would show that it's $100 remaining balance and then if you scroll down it shows the standard expenses and variable expenses now the standard expenses is going to be pulling in from what you enter in this tab so let me just do an example of this one as well select an expense category management fees would be a good one and it's anything that's a monthly rate so say we're paying 200 a month for something and then it will populate for all 12 months here that way you're not having to continue entering the same amount every month and this tab only comes with the I believe it's the 10 property and up versions I don't think the 5 property version has that one so anyhow that's just an overview of how it works and then everything gets populated into the summary page and the summary page will show the annual total so it will continue adding up the totals as you enter them and for the version that has the remaining balance you can also select the remaining balance as of a certain month because it's going to show it's gonna carry over the remaining balance through December so it will just if it's not paid in a certain month it will continue carrying over that balance each month so I hope that helps and you can find this template and even more templates at time-saving templates com thanks