{"product_id":"rental-property-tracker-spreadsheet-light-dark","title":"Rental Property Tracker Spreadsheet (Light + Dark)","description":"\u003cp\u003eWho paid rent this month, and who is late? What did each property earn after expenses this year? What is coming up next? This simple rental property tracker answers all three for a landlord with 1 to 20 units: a duplex, a few houses, maybe a short-term rental. Light and dark versions are both included.\u003c\/p\u003e\u003cp\u003eYou fill in Setup once, then add to two lists as you go: Rent Log (one row per payment) and Expenses (one row per cost). The Rent Roll, the Dashboard, the Property P\u0026amp;L and every total fill themselves. Each thing is typed once. No locked cells.\u003c\/p\u003e\u003ch3\u003eWHAT YOU GET · 5 FILES\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eRental-Property-Tracker.xlsx: your blank tracker (light), with common landlord expense categories already filled in\u003c\/li\u003e\n\u003cli\u003eRental-Property-Tracker-Dark.xlsx: the same blank file in dark mode\u003c\/li\u003e\n\u003cli\u003eRental-Property-Tracker-EXAMPLE.xlsx and Rental-Property-Tracker-Dark-EXAMPLE.xlsx: the same file filled with a made-up landlord, so you can click around first\u003c\/li\u003e\n\u003cli\u003eRental-Property-Tracker-Quick-Start-Guide.pdf (4 pages): which file to open, the 3 steps, 7 simple rules with example rows, questions and answers, and your Google Sheets \"Make a copy\" links (light and dark)\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003e9 TABS\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eStart Here: three steps and short tips, with links to every tab\u003c\/li\u003e\n\u003cli\u003eSetup: your name, the year and currency symbol, grace days before rent is late; up to 20 properties (address, type, optional purchase date and monthly mortgage payment, next insurance renewal and property tax date); up to 40 leases (property, unit, tenant, monthly rent, due day, deposit, lease start and end, and an optional new rent from a date); expense categories with an optional yearly budget; payment methods\u003c\/li\u003e\n\u003cli\u003eRent Roll: pick a month and see every lease with rent due, paid, balance and a status: Paid, Paid late, Partial, Due now, Late (in red) or Vacant\u003c\/li\u003e\n\u003cli\u003eDashboard: pick a month and see rent collected, expected rent, collection rate, unpaid rent, expenses, net cash flow, vacant units and leases ending soon; a 12-month chart of income, expenses and cash flow; every property's income, expenses, mortgage and cash flow for the year to date\u003c\/li\u003e\n\u003cli\u003eRent Log: one row per payment with date, tenant (pick from a list), amount, late fee, method and an optional \"for month\". Property, unit, month and on time or late fill themselves. 1,000 rows ready.\u003c\/li\u003e\n\u003cli\u003eExpenses: one row per cost with date, property (or All \/ shared), category, vendor, amount and a Receipt ✔. 1,000 rows ready.\u003c\/li\u003e\n\u003cli\u003eProperty P\u0026amp;L: pick one property or all of them and see 12 months of rent, late fees, every expense category, net income and net cash flow, with year totals and your yearly budgets\u003c\/li\u003e\n\u003cli\u003eLeases \u0026amp; Dates: lease ends, insurance renewals and property tax dates, soonest first, plus the deposits you hold\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003ePlus a Lists tab that fills the drop-downs by itself (no need to touch).\u003c\/p\u003e\u003ch3\u003eWHY IT'S SIMPLE\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eType each tenant once. Pick the name in Rent Log and the property, unit and rent follow.\u003c\/li\u003e\n\u003cli\u003eLate is clear: not paid in full after the due day plus your grace days turns the row red.\u003c\/li\u003e\n\u003cli\u003ePartial payments add up. Paid early for next month? Pick the month the payment is for.\u003c\/li\u003e\n\u003cli\u003eType the mortgage payment once in Setup: cash flow takes it off every month.\u003c\/li\u003e\n\u003cli\u003eA tenant moves out? Keep the row and add the new tenant. Empty months show as Vacant.\u003c\/li\u003e\n\u003cli\u003eShort-term rental or laundry income? Add it as a \"tenant\" with no fixed rent.\u003c\/li\u003e\n\u003cli\u003eDeposits are listed apart and never counted as income.\u003c\/li\u003e\n\u003cli\u003eNothing is locked. No passwords, no macros. Click any grey cell to see its formula.\u003c\/li\u003e\n\u003cli\u003eNo video needed. The Start Here tab and the 4-page guide cover everything.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eLIGHT AND DARK\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eBoth versions are in this download, with the same tabs and the same formulas. Pick the one you like.\u003c\/li\u003e\n\u003cli\u003eLight: a soft cream page. Type in the white boxes with a thin border.\u003c\/li\u003e\n\u003cli\u003eDark: every tab is dark, the chart too. Type in the boxes with a thin border. Made for the screen: printing a dark tab uses a lot of ink.\u003c\/li\u003e\n\u003cli\u003eIn both, grey cells fill themselves.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eFROM THE EXAMPLE FILE\u003c\/h3\u003e\u003cp\u003eMade-up numbers, an example only. A landlord with 4 properties and 7 units: a duplex, a house, a triplex and a cabin rented by the night, from January to October 2026. In October, 6,580.00 rent came in against 7,140.00 due: one tenant paid part and one is late, so that row is red on the Rent Roll. A roof repair in April pushed repairs over their yearly budget. Your numbers will be different.\u003c\/p\u003e\u003ch3\u003eHOW IT WORKS\u003c\/h3\u003e\u003col\u003e\n\u003cli\u003eAfter checkout, click the download button on your order confirmation page. The same download link is also in your order confirmation email.\u003c\/li\u003e\n\u003cli\u003eOpen the quick-start guide. Use a Google Sheets link to make your own copy (light or dark), or open a blank .xlsx in Excel.\u003c\/li\u003e\n\u003cli\u003eSetup, about 10 minutes: your properties, then one row per lease.\u003c\/li\u003e\n\u003cli\u003eLog rent and costs as they happen: one row per payment, one row per cost.\u003c\/li\u003e\n\u003cli\u003eEach month, pick the month on the Rent Roll to see who paid and who is late, and check the Dashboard.\u003c\/li\u003e\n\u003c\/ol\u003e\u003ch3\u003eCOMPATIBILITY\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eGoogle Sheets: use the \"Make a copy\" links in the guide (a free Google account is needed)\u003c\/li\u003e\n\u003cli\u003eExcel 2016 or newer on Windows (tested in Excel 2021)\u003c\/li\u003e\n\u003cli\u003eOn a Mac? Use the Google Sheets copy\u003c\/li\u003e\n\u003cli\u003eSet it up on a computer. On a phone or tablet, open your copy in the free Google Sheets app to add entries and check it on the go. Phone web browsers show a read-only view.\u003c\/li\u003e\n\u003cli\u003eNot for Apple Numbers.\u003c\/li\u003e\n\u003cli\u003eAny currency: pick or type your currency symbol. It's a label only; nothing is converted.\u003c\/li\u003e\n\u003cli\u003eReady for 20 properties, 40 leases, 1,000 payments and 1,000 costs. Copy the last row down for more payments or costs.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eGOOD TO KNOW\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eDigital download. No physical item will be shipped.\u003c\/li\u003e\n\u003cli\u003eFor personal use only: use it for your own rentals. You may gift one copy to one person. Please don't share, resell or redistribute the files or the Google Sheets links beyond that.\u003c\/li\u003e\n\u003cli\u003eNot tax or legal advice. This spreadsheet is for your records. It does not calculate depreciation; talk to a tax professional about your taxes, and check your local rules on late fees and deposits.\u003c\/li\u003e\n\u003cli\u003eEnglish only.\u003c\/li\u003e\n\u003cli\u003eColors may look slightly different on different screens.\u003c\/li\u003e\n\u003cli\u003eADHD-friendly by design: short steps, one place to type each thing, nothing hidden behind passwords.\u003c\/li\u003e\n\u003cli\u003eDesigned with the help of AI tools, then checked by hand.\u003c\/li\u003e\n\u003cli\u003eQuestions? Email us at lysansan24@gmail.com and we'll help.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eMORE FROM OUR SHOP\u003c\/h3\u003e\u003cp\u003eWant a budget for your home money too? See our \u003ca href=\"\/products\/simple-monthly-budget-spreadsheet\"\u003eSimple Budget Spreadsheet\u003c\/a\u003e, in light or dark mode. Rentals run like a small business: our \u003ca href=\"\/products\/small-business-bookkeeping-spreadsheet-light-dark\"\u003eSmall Business Bookkeeping spreadsheet\u003c\/a\u003e tracks sales and costs, and our \u003ca href=\"\/products\/task-project-tracker-spreadsheet-light-dark\"\u003eTask \u0026amp; Project Tracker\u003c\/a\u003e keeps every repair and to-do in one list.\u003c\/p\u003e","brand":"Holeless Digital","offers":[{"title":"Default Title","offer_id":59056201662728,"sku":"S-RENTAL","price":16.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1060\/7329\/3064\/files\/11-rental-property-tracker.jpg?v=1791684882","url":"https:\/\/holelesshome.com\/products\/rental-property-tracker-spreadsheet-light-dark","provider":"Holeless Digital","version":"1.0","type":"link"}