rental property income and expenses spreadsheet template free download

Rental Property Financial Tracking Ledger

This system provides a standardized framework for tracking monthly cash flow, tax-deductible expenses, and rental income across your portfolio. It is designed for individual landlords to maintain audit-ready records. Update this document monthly to ensure accurate year-end tax reporting.

Monthly Ledger Sample Data

Column Definitions

• Date: [YYYY-MM-DD] Date of the transaction.
• Property ID: [Unique Identifier] Use a consistent code for each unit (e.g., UNIT-01).
• Category: [Dropdown] Select from: Income, Maintenance, Utilities, Insurance, Taxes, Management.
• Description: [Text] Detailed note regarding the transaction (e.g., "Vendor Name - Service Provided").
• Amount: [Currency] Use negative values for expenses and positive values for income.
• Status: [Dropdown] Select from: Cleared, Pending, Disputed.

Essential Formulas

Calculate Total Net Cash Flow:

=SUM(E2:E1000)

Calculate Total Expenses Only:

=SUMIF(E2:E1000, "<0")

Calculate Total Income Only:

=SUMIF(E2:E1000, ">0")

Data Validation & Formatting

1. Category Dropdown (Data Validation): Select the "Category" column, go to Data > Data Validation, and set criteria to "List of items." Enter: Income, Maintenance, Utilities, Insurance, Taxes, Management.

2. Negative Value Highlighting (Conditional Formatting): Select the "Amount" column. Add a new rule: "Format cells if less than 0." Set the cell fill color to light red and the text color to dark red to easily identify expenses.

3. Status Color Coding (Conditional Formatting): Select the "Status" column. Add a rule: "Text contains 'Pending'." Set the background to yellow. Add a second rule: "Text contains 'Cleared'." Set the background to green.