If you own one to four rental units, you probably don’t have a bookkeeper. You’ve got a shoebox of receipts, a bank statement, and a vague sense of whether you made money this year. That’s normal — but it’s also exactly why a simple rental property profit and loss template is worth ten minutes of your time.
A profit and loss statement (P&L) is just a clean summary of what came in, what went out, and what you actually kept. Once you have a rental property profit and loss template set up, you can update it in minutes each month instead of scrambling every April. It also makes conversations with lenders, partners, or your accountant a lot shorter.
Below is a free, downloadable rental property profit and loss template, plus a plain-English walkthrough of how to calculate ROI and which expense categories most landlords forget.
This article is for informational purposes only and does not constitute legal or tax advice. Laws vary by state. Consult a qualified attorney or tax professional for advice specific to your situation.
What Is a Rental Property Profit and Loss Statement?
A rental property profit and loss statement lists your rental income for a period (usually a month or a year), subtracts your operating expenses, and shows what’s left over — your net operating income, or the number that eventually flows to your tax return.
Unlike a full balance sheet, a P&L doesn’t track what you own or owe — just what you earned and spent. That’s exactly why a rental property profit and loss template works so well for small landlords: it’s one page, it’s fast to update, and it answers the one question everyone actually wants answered — “Am I making money on this property?”
Free Rental Property Profit and Loss Template (Download)
Here’s a simple structure you can copy into a spreadsheet today. Each column below represents a section of this template:
| Column | What Goes Here |
|---|---|
| Month/Period | The month or quarter you’re reporting on |
| Gross Rental Income | Total rent collected, before any deductions |
| Mortgage Interest | Interest portion only — not principal |
| Property Taxes | Annual amount divided by 12, or paid as billed |
| Insurance | Landlord/hazard insurance premiums |
| Repairs & Maintenance | Any repair invoices for the period |
| Property Management Fees | If applicable |
| Utilities (Owner-Paid) | Water, trash, gas if you cover them |
| Other Operating Expenses | HOA dues, landscaping, pest control, etc. |
| Total Expenses | Sum of the rows above |
| Net Operating Income | Gross income minus total expenses |
What to Include in Each Column
Keep the income column strictly to rent actually received — not rent that’s owed. Most small landlords use cash-basis accounting, meaning you record income when it hits your account and expenses when you pay them, not when the bill arrives. This keeps your rental property profit and loss template aligned with how you’ll eventually report income on IRS Schedule E, the form used to report rental real estate income and expenses.
How to Calculate Rental Property ROI
Once your P&L is built, the natural next question is: is this property actually a good investment? That’s where ROI (return on investment) comes in.
Cash-on-Cash Return vs. Cap Rate
These are the two numbers landlords confuse most often:
- Cash-on-cash return measures the cash income you receive relative to the actual cash you invested (down payment, closing costs, initial repairs). It’s the most useful number if you financed the property with a mortgage.
- Cap rate (capitalization rate) measures net operating income relative to the property’s total value or purchase price, ignoring financing. It’s more useful for comparing properties regardless of how they were bought.
Neither number is “the” ROI — they answer slightly different questions, so it’s worth calculating both once your P&L template gives you a reliable net operating income figure.
Simple ROI Calculator Walkthrough
Here’s the basic math using numbers pulled straight from your P&L:
- Cash-on-cash return = Annual net cash flow ÷ Total cash invested × 100
- Cap rate = Net operating income ÷ Property value × 100
Example: if your property generates $4,800 in annual net operating income and you paid $150,000 for it in cash, your cap rate is 3.2%. If you instead put down $30,000 and financed the rest, and your net cash flow after mortgage payments is $2,400 a year, your cash-on-cash return is 8%. Same property, two very different answers — which is exactly why both matter.
Rental Property Expense Categories to Track
A big reason landlords underestimate their real profit is that they only track the obvious expenses. Your rental property profit and loss template should have a line for each category below.
Fixed Costs
- Mortgage interest (not principal — principal is a balance sheet item, not an expense)
- Property taxes
- Landlord/hazard insurance
- Any recurring HOA or condo fees
Variable and Operating Costs
- Repairs (a leaking faucet, a broken garbage disposal)
- Utilities you cover as the owner
- Property management fees, if you use a manager
- Advertising costs when a unit is vacant
Often-Missed Deductible Categories
These are the categories that quietly disappear from a landlord’s mental math but belong on every rental property profit and loss template:
- Mileage driven to the property for inspections or repairs
- Software or apps used to manage the rental (including receipt or rent-tracking tools)
- Legal or accounting fees related to the rental
- Depreciation, which lets landlords recover the cost of a rental building over several years instead of deducting it all at once
For a full breakdown of what qualifies, Nolo’s Top Ten Tax Deductions for Landlords guide is a solid plain-English reference to check against your own list.
If you’re weighing whether a rough year counts as a loss you can use elsewhere on your taxes, Nolo’s guide to deducting rental property losses walks through the income limits and participation rules that apply.
Tracking Rental Income Accurately (Where This Gets Messy)
Every P&L is only as accurate as the income data feeding it — and this is where most small landlords lose the thread.
Why Inconsistent Rent Records Break Your P&L
If you’re collecting rent by check, cash, Venmo, and the occasional money order, and not logging each payment the same way, your “Gross Rental Income” row becomes a guess instead of a fact. That guess compounds — a missed or double-counted payment throws off your net operating income, your ROI math, and eventually your tax return.
Landlords managing multiple units sometimes lean on a full accounting software comparison to solve this, but for 1–4 units, that’s often more system than you need.
Using Rent Receipts as Your Income Log
The simplest fix: log every payment the moment it happens. Each time a tenant pays, generate a dated rent receipt at FreeRentReceipt.com and drop the details straight into the income row of your P&L template. It takes under a minute, and it gives you a dated, exportable record that matches your bank deposits — which makes filling in the top line of your P&L a copy-paste job instead of a memory test.
If you’re currently tracking rent in a spreadsheet, the Excel-based receipt option on FreeRentReceipt.com pairs well with a P&L that already lives in a spreadsheet — same format, no extra software to learn.
Turning Your P&L Into Tax-Ready Records
By the time tax season arrives, your rental property profit and loss template should already have everything your accountant needs — you’re just handing off a finished summary instead of a shoebox.
What to Hand Your Accountant
- Your completed P&L for the full tax year
- Every rent receipt or payment record, organized by month
- Copies of major repair invoices and any 1099s issued or received
- Your prior year’s Schedule E filing, if you have one, so categories stay consistent year over year
For every payment collected in cash or outside a bank statement, generate a free rent receipt at FreeRentReceipt.com so there’s a clean paper trail sitting next to your P&L when your accountant asks for it. The IRS is explicit that landlords generally need documentary evidence — receipts, canceled checks, or bills — to support any expense they deduct. A P&L without backup documents is just a spreadsheet, not proof.
If you’d rather see your monthly numbers laid out automatically before you build a full P&L, the rental property cash flow calculator is a quick way to sanity-check your math before you commit it to a template. For a deeper look at how income and expenses ultimately land on your return, our guide on landlord record-keeping covers the habits that make tax season painless.
For more rental management advice, browse our Landlord Tips category. For receipt templates, documentation help, and proof-of-payment guidance, explore our Rent Receipts category.
A rental property profit and loss template only works if the numbers feeding it are accurate — and rent income is usually the messiest input. Start every payment with a clean, dated record: generate your free rent receipt at FreeRentReceipt.com and keep your P&L honest all year, not just in April.
FAQ
What is a good ROI for a rental property? Most small landlords aim for a cash-on-cash return of 8–12%, though this varies by market. A property in a high-cost metro may show a lower percentage but still build wealth through appreciation.
How do you calculate profit and loss on a rental property? Subtract total operating expenses (mortgage interest, taxes, insurance, repairs, and management fees) from your gross rental income for the period. What’s left is your net operating income.
What expenses can landlords deduct? Common deductible expenses include mortgage interest, property taxes, insurance, repairs, management fees, and depreciation. Rules vary, so confirm specifics with a tax professional.
Is rental income considered profit or revenue? Rental income is revenue. Profit is what remains after subtracting your operating expenses from that revenue — which is exactly what a P&L calculates.
How often should landlords update their P&L? Monthly is ideal for 1–4 unit landlords. It keeps the update quick and catches errors before they pile up into a year-end scramble.
What’s the difference between cash flow and profit for a rental? Cash flow includes loan principal payments; profit (net operating income) typically does not, since principal is a balance-sheet item, not an operating expense.
Do I need an accountant for a rental property P&L? Not necessarily to build one, but a tax professional is worth it for filing, especially once you’re claiming depreciation or have more than one property.
