--- title: "Landlord Rent Roll & Property Income Workbook (Excel) | MCC" description: "Excel workbook for small landlords: a unit list with leases, a rent roll for twelve months, who is behind and by how much, vacancy, security deposits…" url: "https://mcc-solutionsnj.com/toolkits/landlord-rent-roll-workbook" --- Excel workbook # Landlord Rent Roll and Property Income Workbook: Rent Due and Received, Delinquency, Vacancy and Property P&L in Excel See what each unit owes and has paid, which leases end soon and what each property really earns after expenses. **$29** one time · 14-day full refund · example and blank copies · download link by email Buy now, $29 🌙 The desk is asleep. The store never is. Every kit and ebook downloads the moment you pay, day or night. Questions get answered after we open in the morning. [Browse the store](/toolkits) Who it is for Small landlords with one to twenty units, and bookkeepers who keep books for them. Not the right fit if You manage more than about twenty units, or you already use property-management software that tracks rent and leases. Why it is different - It shows months behind for every unit, so a late payer stands out at once. - The as-of date is one cell you set, so reports are the same each time you open the file. - A filled example for an invented landlord with three properties and eleven units, and a blank copy with working formulas. What is inside - **Start Here.** Purpose, which cells to fill in and what the workbook is not. - **Setup.** Tax year, your as-of date, late-day grace, your properties, expense categories and the lease warning window. - **Units.** Each unit with tenant, lease dates, rent, deposit and status, with days to lease end and an expiring-soon flag. - **Rent Roll.** Rent due and received by unit for twelve months, with the balance owed, months behind and collection rate. - **Expenses.** Costs by date, property and category. - **Property P&L.** Rent collected, expenses by category and the result before mortgage principal and depreciation, by property. - **Vacancy and Delinquency.** Vacant units, estimated lost rent and the units that owe the most. - **Deposits.** Security deposits held by unit and in total. - **Lease Calendar.** Leases listed in order of end date. - **Checks.** Lease dates out of order, rent received but not due and unknown properties. A look inside ## Example data, real formulas [![Property P&L tab of the Landlord Rent Roll and Property Income Workbook, with example data](/img/toolkits/landlord-rent-roll-workbook/a.png)](/img/toolkits/landlord-rent-roll-workbook/a.png) Property P&L tab with example data. Made-up numbers. [![Vacancy and Delinquency tab of the Landlord Rent Roll and Property Income Workbook, with example data](/img/toolkits/landlord-rent-roll-workbook/b.png)](/img/toolkits/landlord-rent-roll-workbook/b.png) Vacancy and Delinquency tab with example data. Made-up numbers. Get it ## Landlord Rent Roll and Property Income Workbook Or pay with PayPal Uses the email and terms box above. You get the same download link by email. ZIP code (for sales tax) Want every toolkit? The [toolkit membership](/membership) includes all of them, with a lower rate if you pay yearly. Get every update for a year, $29: the [Yearly Updates Pass](/updates-pass?kit=landlord-rent-roll-workbook) gives you each refreshed edition we release of the kits you own. One payment, no automatic renewal. Delivered as a zip with a filled example and a blank copy. Built for Excel, tested in LibreOffice; it should open in Google Sheets but not every feature is tested there. For one business, your own use. General information, not accounting, tax or legal advice. A record-keeping aid, not legal, tax or accounting advice. Rent is not prorated, so enter partial months by hand. Mortgage principal is not an expense and depreciation is for your tax preparer. Lease and deposit rules vary by state. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right. Ways to get it ## Just this kit, or more This kit **$29 one time** Landlord Rent Roll Workbook. Buy this kit The set **$69 one time** 3 kits including this one, $13 less than buying them separately. [See the set](/toolkits/landlord-bundle) Membership **$29 a month** Every kit and document pack in the store, including new ones. Cancel any time. [See the membership](/membership) Questions ## Common questions **What do I get and how is it delivered?** The Landlord Rent Roll Workbook as two Excel files in one zip: a filled-in EXAMPLE so you can see every tab working, and a BLANK copy for your own numbers, plus a README. The download link arrives by email after payment. **Will it open on a Mac, Google Sheets or my phone?** Built for Excel and tested in LibreOffice, which runs on Mac and Windows; it should open in Google Sheets, but not every feature is tested there. Phone spreadsheet apps are not tested. If a file will not open or something looks wrong, reply to your order email and we will make it right. If it is not right for you, email us within 14 days of buying for a full refund. **Is this legal or tax advice?** A record-keeping aid, not legal, tax or accounting advice. **Is it the right fit for me?** It is made for small landlords with one to twenty units, and bookkeepers who keep books for them. Skip it if you manage more than about twenty units, or you already use property-management software that tracks rent and leases. Read the book ### Paperwork for New Jersey Landlords The paperwork of owning one to a few rentals in New Jersey. By Matthew Colt, $9.99 as an ebook (EPUB and PDF). [See the book](/toolkits/nj-landlord-paperwork-ebook) [Read the first pages free](/toolkits/nj-landlord-paperwork-ebook#free-starter) Rather hand it off? ### We can keep the books for you each month If tracking this yourself is more than you want to take on, we do monthly bookkeeping in QuickBooks, Xero or Excel. Tell us what you use and what is behind, and we reply with a written quote after a short review of your books. No obligation. [Get a bookkeeping quote](/bookkeeping/#interest) [Free books health check](/bookkeeping/health-check) Prefer to keep it yourself but want a hand getting started? [Book a 45 minute setup session](/workbook-setup-session) ($65). Buy it with the others [Bundle ### Landlord Bundle This product plus 2 more, in one download. $69 instead of $82 separately](/toolkits/landlord-bundle)[### Month-End Close Workbook A real month-end close in one Excel file. It tells you when a rec does not tie, which variances still need an answer, and when the period is ready to lock. $19](/toolkits/month-end-close-workbook) ## More bookkeeping and business toolkits - [Landlord Tax Organizer](/toolkits/landlord-tax-organizer) $19 - [Landlord-Tenant Notice Organizer](/toolkits/landlord-tenant-notice-organizer) $15 - [Louisiana Employer Compliance Kit 2027](/toolkits/louisiana-employer-compliance-kit-2027) $19 - [Louisiana Landlord Compliance Kit](/toolkits/louisiana-landlord-compliance-kit) $19 - [Louisiana Unemployment Checklist](/toolkits/louisiana-unemployment-checklist) $15 - [Maine Employer Compliance Kit 2027](/toolkits/maine-employer-compliance-kit-2027) $19 [See every toolkit and document pack](/toolkits/all) ## Rather have someone do the books? [Get a Bookkeeping Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)