{"id":18400,"date":"2026-11-22T17:35:15","date_gmt":"2026-11-22T17:35:15","guid":{"rendered":"https:\/\/templacity.com\/?post_type=product&#038;p=18400"},"modified":"2026-11-22T18:39:11","modified_gmt":"2026-11-22T18:39:11","slug":"property-management-kpi-dashboard","status":"publish","type":"product","link":"https:\/\/templacity.com\/nl\/product\/property-management-kpi-dashboard\/","title":{"rendered":"Property Management KPI Dashboard (Google Sheets + Excel)"},"content":{"rendered":"<p>A property management spreadsheet for the person who runs the buildings, for yourself or for owners. Log units, leases, rent, repairs and costs; the dashboard and each owner&#039;s statement work themselves out.<\/p>\n<ul>\n<li><strong>Dashboard<\/strong>: units let today, rent in against rent due for the month you pick, the one thing to do next, every door drawn as a building with each unit a window lit by its state, who has not paid, empty units and leases ending, the repair response ladder against your targets, each property&#039;s NOI and net to its owner, and the year in months.<\/li>\n<li><strong>Owner Statement<\/strong>: pick an owner and a month: rent collected, other income, your fee, repairs and costs per property, net to owner and every line behind it. Prints on one page.<\/li>\n<li><strong>Units<\/strong>: every door with its property and market rent; tenant, rent, lease end, status and this month&#039;s rent are worked out for you.<\/li>\n<li><strong>Tenancies<\/strong>: every lease, the past ones too, so vacancy days, turnover and the renewal rate are worked out, not typed.<\/li>\n<li><strong>Rent Ledger<\/strong>: every payment in: rent, late fees, other income, deposits and refunds.<\/li>\n<li><strong>Work Orders<\/strong>: every repair from the call to the close, its first response timed against your targets, with vendor, cost and who pays.<\/li>\n<li><strong>Expenses<\/strong>: every bill against its property, and whether the owner is charged.<\/li>\n<li><strong>Properties<\/strong>: each building with its owner, address and management fee.<\/li>\n<li><strong>Settings<\/strong>: your targets, company name, owners and the lists behind every dropdown.<\/li>\n<li><strong>Start Here<\/strong>: every tab in one line and the order to fill it in.<\/li>\n<\/ul>\n<p><strong>What you get:<\/strong> a one-page PDF with your Google Sheets links: a blank copy and a copy filled with an example, each in a Light and a Night edition, made in your own Drive. The same workbook comes as two Excel files, blank and example, light only, checked in Excel with every formula recalculated. No scripts, no add-ons, works in Excel 2010 and later. No year is printed anywhere, so it starts the day you do.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Units, leases, rent, repairs and owners in one file: a dashboard worked out from your own records, and a statement for each owner.<\/p>\n","protected":false},"featured_media":18415,"comment_status":"open","ping_status":"closed","template":"single-product-bundle.html","meta":{"rank_math_title":"Property Management KPI Dashboard for Sheets and Excel | Templacity","rank_math_description":"A property management dashboard for Google Sheets and Excel: occupancy, rent collected, arrears, vacancy, leases ending, work orders and an owner statement with net to owner.","rank_math_seo_score":"","_templacity_copy_live":"","_templacity_faq":[]},"niche":[337],"template_type":[],"templacity_topic":[],"product_brand":[],"product_cat":[24],"product_tag":[44],"class_list":["post-18400","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\/nl\/wp-json\/wp\/v2\/product\/18400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/comments?post=18400"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/media\/18415"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/media?parent=18400"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/niche?post=18400"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/template_type?post=18400"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/templacity_topic?post=18400"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_brand?post=18400"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_cat?post=18400"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_tag?post=18400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}