I've been working on a solution specifically for BC landlords that automates all of this, and I'm wondering if this is a common pain point or if most people have it figured out.
For those managing 5+ properties in BC - what's your system?
Would love to hear what's working (or not working) for you!
I I use a simple spreadsheet to track all of that.
My main page pulls all the dates (renewals, insurance coverage dates (renters), etc.), expenses and income, rental income, tenant contact info, and more from a separate linked sheet (one for each Property). I have them conditionally formatted so the dates turn increasing red as we approach the date in the cell.
One glance at this sheet tells me where I need to focus (Property x is getting very Red so start the leas renewal for example).
Each property (17 of them) has a sub-sheet to track expenses, email contact and subject dates, last rent raise date, rent amount, and a bunch of other items I track. At the top is all the "dates". I manually enter them as they change. All the expenses have a column to separate them into schedule E amounts.
Lastly there is a tax recap pages pulling the totals for schedule E number into one sheet for my accountant.
A second spreadsheet track all my repairs and replacements in the rentals (Just Item and date). I can track the whole repair history for each property.
My final spreadsheet is to track my mileage. I update this every time I make a trip to a property or Lowes/HD. (date an purpose of visit). This is probably my weakest point, as I sometimes forget to update this one. Someday I will link this to the ODB reader in my car to automate it, but it really has not been that big a problem that I want to spend the time...