Free Rental Property Spreadsheet Template for Canadian Landlords

You do not need expensive software to manage your rental property finances. A well-structured spreadsheet handles everything most small landlords need: income tracking, expense categorization, cash flow analysis, and tax preparation. The key is setting it up correctly from the start.

This guide walks you through building a rental property expense tracker that works for Canadian landlords, with categories aligned to the CRA T776 Statement of Real Estate Rentals.

Why a Spreadsheet Still Works

For landlords with one to five properties, a spreadsheet offers some real advantages over paid software:

• No monthly subscription fees
• Complete control over your data
• Easy to customize for your specific situation
• Works offline
• Simple to share with your accountant

The trade-off is that you need to update it manually. But if you set aside 15 to 20 minutes on the first of each month, that is all it takes to stay current.

Essential Tabs for Your Spreadsheet

Tab 1: Property Overview

Create a summary tab with one row per property. Include these columns:

• Property address
• Purchase date and purchase price
• Current estimated value
• Mortgage balance and monthly payment
• Monthly rent amount
• Number of units
• Insurance policy number and renewal date

This tab gives you a bird's-eye view of your entire portfolio. Update it quarterly or whenever something changes.

Tab 2: Monthly Income Tracker

Track rent collected per unit per month. Your columns should be:

• Date received
• Property address or name
• Unit number (if applicable)
• Tenant name
• Amount due
• Amount received
• Payment method (e-transfer, cheque, cash)
• Notes (late payment, partial payment, etc.)

At the bottom, add a formula that totals income by month and by property. This makes it easy to spot trends and catch missed payments quickly.

Tab 3: Expense Tracker

This is the most important tab. Structure your expense categories to match the CRA T776 form so tax preparation is straightforward:

• Advertising: Listing fees, signage, photography
• Insurance: Landlord insurance premiums
• Interest and bank charges: Mortgage interest, bank fees (not principal payments)
• Maintenance and repairs: Plumbing, electrical, painting, general fixes
• Management and admin fees: Property management, software subscriptions
• Motor vehicle expenses: Mileage to and from properties for management purposes
• Office expenses: Supplies, postage, printing
• Legal, accounting, and professional fees: Accountant, lawyer, LTB filing fees
• Property taxes: Municipal property taxes
• Utilities: Water, hydro, gas, internet (if landlord-paid)
• Other expenses: Anything that does not fit the above categories

Each row in your expense tracker should include: date, property, category, vendor or payee, description, amount, and whether you have the receipt on file.

Tab 4: Cash Flow Summary

This tab pulls data from your income and expense tabs to show your actual cash flow per property per month. The formula is simple: total income minus total expenses equals cash flow. Include mortgage principal and interest payments here (even though principal is not tax-deductible, it is a real cash outflow).

A negative cash flow month is not necessarily a problem if it was caused by a one-time repair. But if you are consistently negative, it is time to revisit your rent pricing or expense structure.

Tab 5: Maintenance Log

Separate from your expense tracker, keep a maintenance log that records:

• Date of request
• Property and unit
• Description of the issue
• Date resolved
• Contractor or vendor used
• Cost
• Notes

This log is invaluable if a tenant ever claims you neglected maintenance. It also helps you identify recurring issues that might warrant a larger repair or replacement.

Setting Up Formulas

Key Formulas You Need

• Monthly income total: SUMIFS to total income by month and property
• Category expense totals: SUMIFS to total expenses by category and property
• Annual summary: SUM of monthly totals for year-end reporting
• Vacancy rate: Number of vacant days divided by total days in the period
• Net operating income: Annual rental income minus annual operating expenses (excluding mortgage)

Conditional Formatting Tips

Use colour coding to flag important items at a glance:

• Red for late or missed rent payments
• Yellow for expenses over a threshold (e.g., over $500)
• Green for months with positive cash flow

Tips for Staying Consistent

1. Update monthly, not quarterly. Waiting too long means you forget what charges were for
2. Keep digital receipts. Take photos of paper receipts immediately. Store them in folders organized by property and year
3. Reconcile with your bank statement. Every month, compare your spreadsheet to your bank statement. They should match
4. Back up your file. Use Google Sheets or save to cloud storage. A lost spreadsheet is a lost year of records

When to Upgrade to Software

Spreadsheets work well for small portfolios. But there are signs it is time to move to dedicated property management software:

• You manage more than five units and manual entry takes over an hour monthly
• You need automated rent reminders or online payment collection
• You want tenant portals for maintenance requests
• You need to generate professional reports for partners or lenders
• Multiple people need access to the financial data

Tax Time Made Easy

If your spreadsheet categories match the T776 form, preparing your taxes (or handing things to your accountant) is straightforward. Export or print your annual expense summary by category and your total rental income. Attach your receipts organized by category. Your accountant will charge you less because they spend less time sorting through your records.

A rental property spreadsheet is not glamorous. But it is the foundation of financially successful landlording. Set it up once, update it regularly, and you will always know exactly where your money is going.