{"id":13021,"date":"2026-09-19T15:07:42","date_gmt":"2026-09-19T15:07:42","guid":{"rendered":"https:\/\/templacity.com\/?post_type=product&#038;p=13021"},"modified":"2026-09-27T15:14:02","modified_gmt":"2026-09-27T15:14:02","slug":"rental-property-management-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/fr\/product\/rental-property-management-spreadsheet\/","title":{"rendered":"Landlord &#038; Rental Property Manager Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p>A rental property spreadsheet for landlords with one door or a small portfolio. Log rent and costs as they happen; the rent roll, the rent tracker and each property&rsquo;s profit and loss work themselves out.<\/p>\n<ul>\n<li><strong>Portfolio<\/strong>: this month at a glance: rent due and collected, occupancy, leases ending, rent still to come in, twelve months of rent and every property&rsquo;s cash flow.<\/li>\n<li><strong>What If<\/strong>: pick a property and it says the rent it cannot go below and how many months it could sit empty before the year turns red. Move the rent and watch both move.<\/li>\n<li><strong>Rent Roll<\/strong>: every unit with tenant, lease dates, rent, deposit and due day, and a status worked out for you.<\/li>\n<li><strong>Rent Ledger<\/strong>: every payment in, one line each: rent, late fees, pet rent, laundry, deposits.<\/li>\n<li><strong>Rent Tracker<\/strong>: every unit against the last twelve months, paid, part paid or unpaid, coloured so a missed month jumps out.<\/li>\n<li><strong>Expenses<\/strong>: every cost against its property.<\/li>\n<li><strong>Profit &amp; Loss<\/strong>: per property for any period: income, running costs, NOI, cash flow and cap rate.<\/li>\n<li><strong>Properties<\/strong>: what you paid, what it is worth, equity and twelve months of cash flow.<\/li>\n<li><strong>Buy Analysis<\/strong>: three deals side by side: NOI, cap rate, cash flow, cash-on-cash, the 1% rule and break-even occupancy.<\/li>\n<li><strong>Settings<\/strong>: lease warning window, grace days, return target and your lists.<\/li>\n<\/ul>\n<p><strong>What you get:<\/strong> a one-page PDF with two buttons. One makes a blank copy of the Google Sheet in your own Drive, the other a copy filled with an example so you can see every tab working first. The same workbook comes as two Excel files, blank and example, checked in Excel with every formula recalculated. No year is printed anywhere, so it starts the day you do.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Rent due against collected, a paid and unpaid grid for every unit, profit and loss per property, and three deals compared before you buy.<\/p>\n","protected":false},"featured_media":13246,"comment_status":"open","ping_status":"closed","template":"single-product-bundle.html","meta":{"rank_math_title":"Rental Property Spreadsheet for Landlords, Sheets and Excel | Templacity","rank_math_description":"A landlord spreadsheet for Google Sheets and Excel: rent roll, rent tracker, expenses, profit and loss per property and a deal analyzer.","rank_math_seo_score":"9","_templacity_copy_live":"","_templacity_faq":[]},"niche":[337],"template_type":[],"templacity_topic":[],"product_brand":[],"product_cat":[24],"product_tag":[44],"class_list":["post-13021","product","type-product","status-publish","has-post-thumbnail","niche-spreadsheets","product_cat-spreadsheets","product_tag-google-sheets","first","instock","downloadable","virtual","purchasable","product-type-simple"],"_links":{"self":[{"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/product\/13021","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/comments?post=13021"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/media\/13246"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/media?parent=13021"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/niche?post=13021"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/template_type?post=13021"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/templacity_topic?post=13021"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/product_brand?post=13021"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/product_cat?post=13021"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/product_tag?post=13021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}