Rental Property Tracker Spreadsheet – Landlord Rent, Expenses & Cash Flow (Google Sheets & Excel)

Description

Keep your rentals organized in one simple spreadsheet. Log rent and expenses, see who has paid, and know your cash flow for every property.

Made for small landlords with 1 to 10 units. Works in Google Sheets and Microsoft Excel. Instant download.

WHAT IT DOES

✔ Properties: address, tenant, monthly rent and rent due day for up to 10 rentals
✔ Transactions log for up to 1,500 payments. Income vs expense is detected from the category
✔ Landlord categories: rent, late fees, mortgage interest, repairs, insurance, property tax, HOA, utilities, management and more
✔ Rent Tracker: rent received vs rent due for every property and month, filled in from your transactions
✔ Paid in full = green, partial = yellow, missing = red
✔ Dashboard: year-to-date income, expenses, net cash flow, rent collected % and missing rent
✔ Income, expenses, net and margin for every property
✔ Monthly income vs expenses chart and expenses by category

HOW IT WORKS

1. Add your properties and tenants
2. Log rent and expenses as they happen
3. Check the Rent Tracker to see who has paid
4. Review your cash flow on the dashboard

WHAT YOU GET

• 1 spreadsheet file (.xlsx) with Start Here, Dashboard, Properties, Transactions and Rent Tracker tabs
• Example properties and transactions to show how it works
• Step-by-step instructions inside the file, including how to open it in Google Sheets

YOU'LL NEED

• A free Google account (Google Sheets) or Microsoft Excel
• Apple Numbers is not supported.

PLEASE NOTE

• This is a digital product. No physical item will be shipped.
• Due to the nature of digital files, returns are not accepted. If you have any trouble, contact me through the Contact page and I'll help.
• This tracker helps you organize your records. It is not tax or legal advice.
• For use in your own rental business. Please don't resell the file.

After payment, your download link appears right away on the order confirmation page and in your email.

Made by Yellowick 💛