Does anyone have a property lease management template?

[GPTDesign]

I have a few dozen commercial tenants. Each of them will have a different
rent rate per month. Then each of them will likely have an escalation clause
which will increase their rent on their lease anniversary (any of the 12
months of the year). Then typically on January of each year there is an
adjustment on Common Area Management expense reimbursements. I am going
crazy trying to keep up with dozens of leases, dozens of different
escalation dates, dozens of different escalation amounts and then I need to
send out correct bills 15 days before the first of each month. Have
downloaded trial programs off internet but none of them seem to have all the
flexibility to include input for the program to keep up with the scheduled
escalations or doing batch billings to groups of tenants all in the same
shopping center for instance. Does anyone have a template they have
designed which can do these things in MS Accsss for instance? Thanks

 

[John Vinson]

I have a few dozen commercial tenants. Each of them will have a different
rent rate per month. Then each of them will likely have an escalation clause
which will increase their rent on their lease anniversary (any of the 12
months of the year). Then typically on January of each year there is an
adjustment on Common Area Management expense reimbursements. I am going
crazy trying to keep up with dozens of leases, dozens of different
escalation dates, dozens of different escalation amounts and then I need to
send out correct bills 15 days before the first of each month. Have
downloaded trial programs off internet but none of them seem to have all the
flexibility to include input for the program to keep up with the scheduled
escalations or doing batch billings to groups of tenants all in the same
shopping center for instance. Does anyone have a template they have
designed which can do these things in MS Accsss for instance? Thanks

I'm not aware of any templates, and I doubt that they would have
provision for these escalation clauses and other complexities;
however, Access would be quite capable of managing this setup. It
would take a fair bit of work though! You may want to hire a
professional developer; or you can build the database yourself if you
are patient, willing to ask questions here as necessary, and spend
enough time learning the principles and designing the basic table
structures.


John W. Vinson[MVP]