{"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-11-08T07:49:17","modified_gmt":"2026-11-08T07:49:17","slug":"rental-property-management-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/de\/product\/rental-property-management-spreadsheet\/","title":{"rendered":"Landlord &#038; Rental Property Manager Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p><span class=\"eyebrow\">\u2116 \u00b7 Every door, every month<\/span><\/p>\n<h2 id=\"a-landlord-spreadsheet-with-a-rent-roll-a-rent-tracker-and-profit-and-loss-per-property\">A landlord spreadsheet with a rent roll, a rent tracker and profit and loss per property<\/h2>\n<p>The Landlord &amp; Rental Property Manager is for a landlord with a few doors, a duplex up to a small multifamily portfolio, who does not want property management software for it. Start on Properties with what you paid, what each is worth and the loan left, then put every unit on Rent Roll, even the empty ones: tenant, lease dates, rent, deposit and the day rent is due.<\/p>\n<h3>The monthly routine<\/h3>\n<p>Log each payment on Rent Ledger the day it arrives and each bill on Expenses the day you pay it. Rent Tracker sets every unit against the last twelve months, paid, part paid, unpaid or due, coloured so a missed month jumps out. A late payment for last month goes against the month it pays for. Rent is late after the due day plus five grace days, and a lease inside 60 days of its end shows as Ending soon; both are yours to change.<\/p>\n<h3>Does each property earn its keep?<\/h3>\n<p>Profit &amp; Loss gives income, running costs, NOI, mortgage, improvements, cash flow and cap rate per property for any period. Deposits are recorded and never counted as income. What If gives a property&#8217;s break-even rent and how many empty months it can take before the year turns red. Buy Analysis puts three deals side by side: cash-on-cash against your 6% target, DSCR, cap rate, the 1% rule and break-even occupancy.<\/p>\n<p>The download is a short PDF with two Google Sheets buttons, one for a blank copy in your own Drive and one for a copy filled with an example, the same workbook as blank and example Excel files, and a one-page Quick Start for each.<\/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":17034,"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":"1","_templacity_faq":[{"q":"How many properties and units does it hold?","a":"Each building or house is a row on Properties and each unit a row on Rent Roll, so a single family home and a small multifamily sit side by side."},{"q":"A tenant paid last month's rent this month. Where does it go?","a":"On today's ledger line, with last month in 'For month'. It then fills the right square on the Rent Tracker."},{"q":"Are security deposits counted as income?","a":"No. They are recorded on the ledger, but the Income? setting keeps deposits received and returned out of income."},{"q":"How are mortgage payments and improvements treated?","a":"Below NOI. Each expense category is Operating, Debt or Capital on Settings: operating costs count in NOI, the mortgage and improvements come off after it, in cash flow."},{"q":"Can it help me decide on a purchase?","a":"Buy Analysis compares three deals: mortgage, NOI, cap rate, cash flow, cash-on-cash, DSCR, the 1% rule and break-even occupancy."},{"q":"Does it work in Excel?","a":"Yes. The download carries native .xlsx files, one blank and one filled with an example, for Excel 2010 and later, Excel for Mac and Microsoft 365. Every formula is ordinary Excel, with no macros to enable."},{"q":"Is there a year printed in it?","a":"No. No year is printed anywhere in the files, so it starts the day you do and keeps working next year."}]},"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\/de\/wp-json\/wp\/v2\/product\/13021","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/comments?post=13021"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/media\/17034"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/media?parent=13021"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/niche?post=13021"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/template_type?post=13021"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/templacity_topic?post=13021"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/product_brand?post=13021"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/product_cat?post=13021"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/product_tag?post=13021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}