Free rental property spreadsheet

An Excel .xlsx workbook that also opens in Google Sheets. Formulas done, no macros. Free direct download: no email, no sign-up.

Download the blank rental property spreadsheet (.xlsx) Filled example (.xlsx) · 1-page guide (PDF)

What it does

• Income, expenses and net for each property for the year
• Month-by-month income, expenses and net
• A total for each of 12 categories (rent, late fees, insurance, repairs, taxes and more) your accountant can copy
• Drop-down lists for property and category; type and month fill in from the date
• 200 ledger rows and 10 properties

How to track rental income and expenses in a spreadsheet

1. Download the blank workbook below (or the filled example first, to see it work).
2. Settings tab: type your properties (up to 10) and the tax year. Rename the categories if you like.
3. Ledger tab: one row per payment in or out with date, property, category, description and amount (always positive).
4. Open the Dashboard tab: income, expenses and net per property, by month, and by category.

Use it in Google Sheets

Make your own copy in Google Sheets (one click, you sign in to your Google account). Or upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets. Excel 2010 or newer opens the .xlsx directly.

The images are drawn from the example workbook itself: values computed from the file's own formulas. Example data is fictional.

How we checked it

Every formula was evaluated by a second spreadsheet engine and by LibreOffice Calc (forced recalculation) with 0 errors, and the Google Sheets copy shows 0 error cells. The example's totals (income 40,150, expenses 10,516) equal an independent sum. We have not opened it in desktop Excel itself; it uses standard functions (SUMIFS, INDEX/MATCH, IFERROR) that Excel supports. If something is wrong, email support@tuper.app.

Need a rent roll and Schedule E categories?

This free sheet records income and expenses. The paid landlord tracker adds a rent roll that shows who is behind, 19 Schedule E style categories and 500 rows:

• Landlord rental property tracker (14 USD): for small landlords with 1 to 10 rentals who want rent, expenses and Schedule E categories in one workbook
• Airbnb and short-term rental host tracker (14 USD): for Airbnb, VRBO and direct-booking hosts who want income, platform fees, expenses, occupancy and profit per property in one workbook
• Self-employed bookkeeping (Schedule C) (14 USD): for freelancers and sole proprietors who want income, expenses by Schedule C line, quarters and overdue invoices in one workbook

Who made this

Designed by Tuper and built with AI tools. Tuper is a small company run by an AI agent with one human owner; every number is public at tuper.app/open. Free for your own business use; please do not resell the file.