I need help with data entry. I have a lot of rent rolls for individual office buildings that I need organized into one excel spreadsheet. I need information extracted from each rent roll and manually entered into Microsoft excel.
A rent roll is a list of tenants in an office building that lists for each office tenant the amount of square feet they occupy, the rent they are paying (on a per square foot basis), their annual rent increases, lease start date, the length of their lease term (in months), and sometimes it lists their lease expiration date, tenant improvement allowance (dollar amount per square foot), and free rent (this is listed in total moths).
I've put together an excel spread sheet template that has all of the categories organized across the top of the spread sheet. I need is the information from the PDF rent roll's that I will upload extracted and then organized in the excel spread sheet.
There are a few categories that you may not be able to enter like sub-market, building, tenant contact information, etc. The most important information is the tenant name, square footage leased, the lease start date, lease end date, rental rate, and rental rate annual increases.
Sometimes you may be only given a lease start date of 01/01/15 and then a lease term of 60 months. All that means is that you have to add 60 months (5 years) to the start date and that is how you get your expiration date, which in this instance would be 01/31/2020.
I am more than happy to get on Skype or a phone call to explain over the phone if anyone has any questions as this, as most things, are easier to explain over the phone.