How do you track maintenance requests for your properties

[Minna Hu]

What do you use to track your maintenance requests? We own 40+ units, right now, we use google spreadsheet to track maintenance requests, unfortunately, it involves lots of manual work in the process.

Request come in through email or phone call-> record it in the maintenance request spreadsheet-> dispatch to handy man->send notification to tenants->follow up the status of a request->close the request We want to automate the work in the above process, such as  1. automatically create issue in the system from email (Lots of our tenants are not tech-savvy, email or phone call is probably easy for them to report problems) 2. when a request is dispatched, email notification to the tenant and handy man are automatically sent out 3. generate report of requests, so that we can track its status
What's your experience and suggestions?