Investor and Real Estate Agent from Los Angeles · Los Angeles, CA · Member since 2017 · 41 posts · 28 votes
I help manage around 160 units, and we recently needed to create notices alerting tenants to changes in the fees they pay along with their rent.
Each notice needed information unique to the tenant (their name, address, rent amount without the fees, and their new monthly payment amount with the new fees). I'm embarrassed to admit I did most of the work manually, which took way longer than it should (many hours of copying and pasting spread out over multiple days). How do y'all generate notices with unique information for each tenant while also not consuming a ton of time? I imagine a mail merge is an option, but is there anything else that may be better?
Property Manager · Baltimore, MD · Member since 2014 · 1k+ posts · 1k+ votes
4y
Mail merge is definitely your best bet. All office software suites (Microsoft Word/Excel, Mac Pages/Numbers, Google Docs/Sheets) offer this functionality. As Scott points out you can also do this with most rental management software, and IMO at 160 units you're way beyond the point where it makes sense to put the time and money into investing in one of these tools. My team and I just did a ton of research on the options available, cost, pros, and cons - if you'd like me to send me your notes just PM me with your email address.
Real Estate Broker · Rochester Hills, MI · Member since 2009 · 2k+ posts · 2k+ votes
4y
With 160 units I would hope you are using management software of some kind? If not, look into it, it will blow your mind lol. Most management software made for those with that number of units and up will have document creation/signing modules built in. We simply select the tenant, type of notice and done. Everything is put in automatically.
That would be the best solution.
if you are not using management software where is all the data kept? Excel? Quickbooks? Paper? If you are using management software, what one?
Property Manager · Baltimore, MD · Member since 2014 · 1k+ posts · 1k+ votes
4y
Mail merge is definitely your best bet. All office software suites (Microsoft Word/Excel, Mac Pages/Numbers, Google Docs/Sheets) offer this functionality. As Scott points out you can also do this with most rental management software, and IMO at 160 units you're way beyond the point where it makes sense to put the time and money into investing in one of these tools. My team and I just did a ton of research on the options available, cost, pros, and cons - if you'd like me to send me your notes just PM me with your email address.
Real Estate Broker · Cody, WY · Member since 2010 · 28k+ posts · 41k+ votes
4y
I use Propertyware and it has a built-in Mail Merge function. Not the easiest to set up sometimes (formatting is particularly wonky) but it's great once we have something built.
Property Manager / Investor · San Jose, CA · Member since 2013 · 780 posts · 301 votes
4y
@Zach L. The above posts cover your options. Every solution will require some setup / investment time, but once done saves you time for the rest of your real estate life. I spent more hours than I care to admit setting up online applications, now that it is done everything is collected and stored automatically. When converting from a prospect to tenant, all of their information (that they entered) copies over to the tenant info with a few clicks. I no longer have to try an interpret handwriting on applications or do data entry. I use RentManager software fwiw.
Carlsbad, CA · Member since 2018 · 24 posts · 50 votes
4y
I use Buildium and recommend the software. I can't even imagine the workload having 160 units without PM software. Do you reconcile your trust account by excel/ hand every month?