Rental Property Income & Expense Tracker for Small Landlords

A simple record-keeping spreadsheet for small landlords with 1 to 10 properties or units. Log rent and expenses, see at a glance who has paid each month, and get income, expenses and net per property for the year.

★ WHAT YOU GET

• 1 spreadsheet (.xlsx) with 7 tabs: Start here, Summary, Setup, Rent & income, Expenses, Rent check, Maintenance

• Setup for up to 10 properties / units: monthly rent, tenant, lease end date, deposit held, plus up to 20 expense categories

• Rent & income log (600 rows): rent, late fees, other income, deposits received / returned (deposits are kept out of income)

• Expenses log (500 rows) with property drop-down, including 'General (all properties)' for shared costs

• Rent check grid: rent received per property per month. Months that have passed and are short turn red; paid-in-full months turn green

• Summary: rent, other income, expenses and net per property; month-by-month totals; expenses by category; deposits recorded; leases ending in the next 60 days; chart

• Maintenance log (150 rows): issue, contractor, cost, status (Open / Booked / Done)

• 4-page printable PDF in US Letter and A4: tenant & lease info, rent ledger, maintenance log, move-in / move-out inspection checklist

★ COMPATIBILITY

Made for Google Sheets (free Google account; upload the .xlsx to Google Drive, then open it with Google Sheets), Microsoft Excel 2010 or later, and LibreOffice Calc. Formulas were checked for Google Sheets and Excel compatibility (standard functions only, no macros, no add-ins) and tested in LibreOffice Calc. Unzip the download first (double-click on most computers). Best used on a computer or tablet. Enter dates as real dates (e.g. 3/15/2027 or 15/03/2027).

Printable PDFs in US Letter (8.5 × 11 in) and A4. Print at home or at a print shop (choose 'Actual size' or 'Fit'). The PDFs are for printing and writing by hand. They are not fillable forms.

★ GOOD TO KNOW

• This is a record-keeping tool, not tax, legal or financial advice. It doesn't know the rules in your country or state; ask an accountant what you can claim.

• No currency symbol, so it works in any single currency.

• Example rows are included. Delete them before you start.

• Sheets are not locked, so you can rename categories.

★ For your own household or your own small business records. Please don't share, resell or redistribute the files.

★ Digital download: nothing physical is shipped. You get one .zip file; unzip it to get the files.

★ 14-day promise: if a file is faulty or not as described, contact me within 14 days and I'll fix it or refund you.

Made with the help of AI tools (drafting text, layouts and formulas); I chose the content and reviewed and edited every file.