Development of rental apartment management system: income and expenditure management, property-specific occupancy rate management.

I wanted to streamline work that involves a heavy workload and standardized routine tasks. ▶ I was able to reduce the burden of tasks such as monthly aggregations.

■Trigger Daily management tasks were primarily conducted using "industry-standard software" and centered around Excel. However, with the increase in properties, there was a rise in detailed management tasks (such as occupancy rates, invoicing, and payment checks) and irregular operations that could not be handled by the business software, leading to an increased workload on-site. Given the frequent data entry tasks in Excel, attention was focused on "standardization" and "automation" to consider improving operational efficiency. While searching for methods to alleviate the overtime burden during busy periods, I learned about Excel macro language and decided to adopt a method to automatically process Excel data on the server without changing or customizing the core system. ■Background of Implementation Considering the high investment associated with existing business software and customization, as well as the labor involved in migrating large amounts of Excel data, we focused on "partial optimization of management tasks" that could directly utilize the Excel data accumulated on the server. This approach avoided large-scale data migration or the purchase of new software, and took into account the potential costs that might arise from future specification changes, leading to the adoption of Excel macros.

Inventory Management System