{"product_id":"rental-property-spreadsheet","title":"Rental Property Spreadsheet, Rental Property Tracker, Landlord Spreadsheet for Property Management, Tenant Ledger, Google Sheets Excel","description":"\u003cp\u003e\u003cstrong\u003eRENTAL PROPERTY SPREADSHEET FOR GOOGLE SHEETS AND EXCEL\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eA rental property spreadsheet for landlords with one to ten properties: rent in, expenses out, deposits held and Schedule E at tax time.\u003cbr\u003eRent and late fees are charged from each lease by themselves. You type only what happens: a payment, a repair, a trip.\u003cbr\u003eFor houses, duplexes, small apartment buildings and condos you rent out.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003e📊 WHAT IT DOES\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e✓ Log: one line per money event. Pick the unit; the file finds the tenant and the Schedule E line.\u003cbr\u003e✓ Leases: one row per lease, with your due day, grace days and a late fee in dollars or a percent.\u003cbr\u003e✓ Properties: every unit with its tenant, rent, lease end, balance and status, like a rent roll.\u003cbr\u003e✓ Rent Tracker: every unit, month by month: paid on time, paid late or short.\u003cbr\u003e✓ Tenant Ledger: one tenant's statement: the balance after each month, rent paid through, rent owed apart from fees.\u003cbr\u003e✓ Deposits: money you hold, not income. What you kept and why, and the day to return the rest by.\u003cbr\u003e✓ Repairs and Reserves: jobs with their Schedule E line, and what to set aside monthly for the roof or furnace.\u003cbr\u003e✓ Cash Flow and Month: NOI, cash flow, vacancy cost and return on price per property, and any month at a glance.\u003cbr\u003e✓ Schedule E: lines 3 and 5 to 21, property by property, with a depreciation estimate, mileage and a 1099-NEC check.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003e📂 WHAT'S INSIDE: 14 TABS AND 37 CHARTS\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e✓ Start with these three: Start here, Log, Home\u003cbr\u003e✓ Set up once: Properties, Leases, Settings\u003cbr\u003e✓ Rent and tenants: Rent Tracker, Tenant Ledger, Deposits\u003cbr\u003e✓ Money and taxes: Repairs, Reserves, Cash Flow, Month, Schedule E\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003e📝 HOW IT WORKS\u003c\/strong\u003e\u003c\/p\u003e\n\u003col\u003e\n\u003cli\u003eOpen the PDF and click the link to make your own copy in Google Sheets. Or open the Excel file.\u003c\/li\u003e\n\u003cli\u003eOn Start here, type your name. On Properties, add each unit. On Leases, add each lease: the unit, the tenant, the start date and the rent.\u003c\/li\u003e\n\u003cli\u003eFrom then on, type only on Log: a rent payment, an expense, a deposit or a trip, one line each.\u003c\/li\u003e\n\u003cli\u003eEverything else fills in by itself. Home shows who owes you, which leases end soon, this month's rent and the year's cash flow.\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cp\u003e\u003cstrong\u003e📥 WHAT YOU GET\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e✓ Google Sheets version (the link is in the PDF)\u003cbr\u003e✓ Excel version (.xlsx) for desktop Excel on Windows or Mac\u003cbr\u003e✓ A filled example to look around, and a blank copy for your own data\u003cbr\u003e✓ A PDF guide: a picture of every tab and your first five minutes, step by step\u003cbr\u003e✓ A video guide for this planner (the link is in the PDF)\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003e💻 GOOD TO KNOW\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e✓ Works with a free Google account. No add-ons, no subscription, no bank connection. Amounts show in dollars.\u003cbr\u003e✓ Type only in the input cells. Formulas are protected, so you can't break them by accident.\u003cbr\u003e✓ Your state's rules go in Settings once: grace days, the late fee cap, the days to return a deposit.\u003cbr\u003e✓ Payments go to rent first, then to late fees and charges.\u003cbr\u003e✓ A bill logged to All properties is split evenly.\u003cbr\u003e✓ Made for US landlords. Schedule E shows how the file lays out your numbers. Depreciation is an estimate. Check it with your tax preparer.\u003cbr\u003e✓ Room for 30 units, 40 lease rows, 1,500 lines on Log and 10 properties in the reports.\u003cbr\u003e✓ Best on a computer. The Google Sheets app works for quick entries on your phone.\u003cbr\u003e✓ The Excel version may look slightly different from the photos (fonts, colors, charts). The photos show Google Sheets.\u003cbr\u003e✓ English only. Not made for Apple Numbers.\u003cbr\u003e✓ Free updates for life.\u003c\/p\u003e\n\u003cp\u003eThis is a digital download. Nothing will be shipped. Because it is a digital file, it can't be returned, but if anything is unclear, message me and I will help you set it up.\u003cbr\u003eThis planner is a tool for your own records, not financial or tax advice.\u003c\/p\u003e","brand":"GrowlyLab","offers":[{"title":"Default Title","offer_id":67683429613721,"sku":null,"price":13.95,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0738\/8613\/8521\/files\/il_fullxfull.8667203780_4bl7.jpg?v=1791844756","url":"https:\/\/growlylabstudio.com\/products\/rental-property-spreadsheet","provider":"GrowlyLab","version":"1.0","type":"link"}