Free Rental Property Profit and Loss Template (Excel)
What's in the free rental P&L template
The free version is a single 12-month profit and loss sheet for one property: rental income and your expense categories, laid out month by month with a running annual total. It's built to answer the basic question every landlord asks monthly — did this property make money?
It doesn't include a loan amortization schedule, so it won't split your mortgage payment into principal and interest automatically, and it doesn't calculate cash-on-cash return or DSCR (debt service coverage ratio). Those are the pieces that move you from 'is this profitable' to 'is this a good investment relative to what I put in.'
Free vs. the Real Estate Investor Pack: what's actually different
Free gives you 12 months of income and expenses, totaled, for one property — good enough if you just want a clean record for taxes or a quick month-to-month read. What it can't do is tell you your real return: your mortgage payment is a single number, not split into interest and principal, so you can't see how your equity is building or what your true cash flow looks like after debt service.
The paid Real Estate Investor Pack ($39) adds a full 360-line amortization schedule that feeds interest automatically into the P&L, plus a Returns Dashboard calculating NOI, cash flow, cash-on-cash return, cap rate, and DSCR — the actual numbers you'd use to decide whether to keep, refinance, or sell a property. It also bundles a development proforma and a CMA in the same pack, useful if you're evaluating more than one deal.
Who each version fits
If you own one rental and mainly want a clean, simple monthly record for your own tracking or your tax preparer, the free template does that job without extra complexity to manage.
If you're financing the property, want to know your real cash-on-cash return, or you're comparing this property against others you might buy, the amortization and DSCR in the paid pack are the numbers that actually drive that decision — the free P&L alone can't get you there.
How to use it
- Set up the property with your monthly rental income figure.
- Log expenses each month — taxes, insurance, maintenance, and your mortgage payment as a single line.
- Review the monthly total and running annual total as the year fills in.
- At year-end, use the annual total for your own records or to hand off to your CPA.
Download the free Free Rental Property Profit and Loss Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Real Estate Investor Pack
See the honest comparison above — the paid Real Estate Investor Pack ($39) adds a 360-line amortization schedule, a Returns Dashboard (NOI, cash flow, cash-on-cash, cap rate, DSCR), plus a development proforma and CMA.
See the full versionFrequently asked questions
Can I use this rental P&L template in Google Sheets?
Yes. Upload the downloaded file to Google Drive and open it with Sheets — File > Save as Google Sheets keeps the totals working.
Is this template really free?
Yes. You give an email address to download it, and it's yours to reuse every year at no further cost.
Does the free version calculate cash-on-cash return or cap rate?
No. The free template totals income and expenses only. Cash-on-cash, cap rate, and DSCR are in the paid Real Estate Investor Pack.
Does it split my mortgage payment into interest and principal?
No, the free version treats your mortgage payment as one expense line. The paid pack's amortization schedule breaks it out and feeds interest into the P&L automatically.
What's the usage license?
Personal use or use within one business. It isn't meant to be resold or redistributed as a template product.
How many properties can I track with the free version?
The free sheet covers one property. For multiple properties with amortization and a returns dashboard, see the paid pack.