The Properties/Units table contains detailed information about each property or rental unit. Key fields include Property/Unit #, Property Title, Address, City, State, and Suite #, providing a complete location overview. The Unit Type and Unit Status help track the kind of space and its availability, while Square Feet, Monthly Rent, and Standard Rent ($ per sq. ft.) define the size and cost of the unit. Additional features such as Kitchen Area, Reception Area, and Fiber-optic and ISDN telephone service are also documented, ensuring a clear understanding of the unit’s amenities. The # of Leases field tracks the number of lease agreements associated with each unit.
The Leases table manages all aspects of lease agreements. It tracks lease information such as Property/Unit #, Tenant #, Tenant Company Name, and Primary Contact, ensuring that each lease is linked to the right tenant and property. It also records essential details like Lease Term, Lease Start, Lease End, Move In Date, and Move Out Date. Financial data, including Deposit Amt, Deposit Received Date, Mo Debt Total, and Monthly Rent, is also tracked, allowing managers to maintain financial oversight. Additionally, fields like Status, Reason for Moving, and Months Before Lease End provide important insights into tenant behaviors and lease statuses.
The Tenants/Prospects table stores data on potential and current tenants. It includes information such as Company Name, Primary Contact, Address, City, State, Zip, and multiple contact numbers. The Status and Probability of Close fields help in managing leads and determining the likelihood of converting prospects into tenants. The table also records the Property/Unit Interested In #, Monthly Rent, and Unit Type, linking tenant interest to specific units.
In summary, this database is an essential tool for property managers to organize properties, handle leases, and manage tenant relationships efficiently. By keeping all relevant details in one place, it simplifies the leasing process and improves operational effectiveness.
Any support materials, such as spreadsheets and real-life work samples would be very helpful as they would help us better understand your business process.