JP7014649B2 - Management report creation device, management report creation method and management report creation program - Google Patents

Description

The present invention relates to a management report creation device, a management report creation method, and a management report creation program.

In Patent Document 1, in order to target a plurality of rental real estate and provide and manage necessary information to a plurality of related parties, the target functions provided in the application mechanism are basic information management and properties. It is classified into management, building management, and comprehensive portfolio analysis (comprehensive evaluation of multiple facilities). Property management includes screen management function, rental contract management function, lease contract management function, budget / balance management function, long-term operation plan management function, risk management function, etc., building area, tenant, budget and balance record, earthquake. It manages various information necessary for property management, such as the risk of fire and fire. In addition, the monthly report application is for maintaining the information of the part that the user is in charge of, the asset management person (asset manager) is the income and expenditure information, the accounting person is the billing payment information, and the leasing person is renting. The contract information is managed by the building engineer, and the area information is managed by the building engineer. Various information such as rental contract information, area information, contract transfer information, budget / actual information, etc., which are managed and accumulated individually, are collected, edited into a form (for example, monthly report) as comprehensive information, and provided.

Japanese Unexamined Patent Publication No. 2005-173957

As described above, in Patent Document 1, when editing the monthly report, the asset management person (asset manager) receives the income and expenditure information, the accounting person receives the billing payment information, and the leasing person obtains the rental contract information. Engineers manage area information from their respective standpoints, and edit forms (monthly reports) using the information that is individually managed and accumulated as comprehensive information. However, the report created is not created from the accounting perspective of the owner who receives it, so when accounting is performed based on the report received by the owner, the breakdown of income and expenditure management is based on the accounting of the owner. It was necessary to change the breakdown.

The present invention has been made in view of the above, and is a management company used by a management company that manages rental properties when creating a management report that reports the operating status and management status of rental properties to the owner. The purpose is to provide a management report creation device, a management report creation method, and a management report creation program that enable accounting data from the viewpoint of the owner to be converted into accounting data from the viewpoint of the owner and manage the income and expenditure.

In order to solve the above-mentioned problems and achieve the object, the management report creating device according to the present invention is provided with a storage unit and a control unit, and the rental property management company informs the owner of the operation status and management status of the rental property. It is a management report creation device that creates a management report for reporting from the accounting viewpoint of the owner, and in the storage unit, management consignment contract data regarding a management consignment contract exchanged between the management company and the owner. The management consignment contract data storage unit that stores the items, the item master that registers the item data related to the payment / payment items by the tenant of the rental property, and the account item data from the accounting viewpoint of the management company that is linked to the item data are registered. A management report summary item in which the journal pattern master, the management consignment contract data, the item data associated with the management consignment contract data, and the income and expenditure management data associated with the item data from the accounting viewpoint of the owner side are registered. The master and the are stored, and the control unit determines the data acquisition means for importing the management consignment contract data and the form of the payment management business for the owner of the management company, and opens an account in the name of the management company. When using to manage deposits and withdrawals, the owner's income is the transfer of deposits deposited in the account in the name of the management company, and the owner's income is the amount that the management company has reimbursed for the advance payment. When deposit / withdrawal management is performed using an account in the name of the owner, it is assumed that the owner's income is deposited in the account in the name of the owner and the owner's expenditure is paid from the account in the name of the owner. , The income and expenditure management changing means for extracting the item data of the management report aggregation item master and the income and expenditure management data on the owner side based on the imported management consignment contract data, and changing the item data to the income and expenditure management data. It is characterized by having a report creation means for creating a management report based on the income and expenditure management data changed from the accounting viewpoint of the owner.

Further, the management report creating device according to the present invention is characterized in that the management report is a property management report and reports to at least one of the owner of the rental property and the asset management company.

Further, the management report creating apparatus according to the present invention is characterized in that the control unit further includes an output means for outputting the created management report on a screen or by printing.

Further, in the management report creating device according to the present invention, the journal pattern master is linked to the item data and linked with financial accounting, and the total account data and the sub-account data are used as account data from the accounting viewpoint of the management company. And the sub-account data are linked, and in the storage unit, the total account master that registers the total account code and the total account name of the total account data, and the sub-account of the sub-account data. The feature is that the supplementary subject master for registering the code and the supplementary subject name and the supplementary breakdown subject master for registering the supplementary breakdown subject code and the supplementary breakdown subject name of the supplementary breakdown subject data are further stored. do.

Further, the management report creation method according to the present invention includes a storage unit and a control unit, and provides a management report for the rental property management company to report the operation status and management status of the rental property to the owner from the accounting viewpoint of the owner. It is a management report creation method executed by the management report creation device created in, and the storage unit stores management consignment contract data related to the management consignment contract exchanged between the management company and the owner. A consignment contract data storage unit, an item master that registers item data related to payment / payment items by the tenant of the rental property, and a journal pattern master that registers account item data from the accounting perspective of the management company linked to the item data. , The management report aggregation item master in which the management consignment contract data, the item data associated with the management consignment contract data, and the income and expenditure management data associated with the item data from the accounting viewpoint of the owner side are registered. The data acquisition step for importing the management consignment contract data, which is stored and executed by the control unit, and the form of the payment management business for the owner of the management company are determined, and the account in the name of the management company is used. If you are managing deposits and withdrawals, the owner's income is the transfer of deposits deposited in the account in the name of the management company, and the owner's income is the amount that the management company has reimbursed for the advance payment. When deposit / withdrawal management is performed using an account in the name of the owner, it is assumed that the owner's income is deposited in the account in the name of the owner and the owner's expenditure is paid from the account in the name of the owner. With the income and expenditure management change step of extracting the item data of the management report summary item master and the income and expenditure management data of the owner side based on the imported management consignment contract data and changing the item data to the income and expenditure management data. It is characterized by including a report creation step of creating a management report based on the income and expenditure management data changed from the accounting viewpoint of the owner side.

Further, the management report creation program according to the present invention includes a storage unit and a control unit, and provides a management report for the rental property management company to report the operation status and management status of the rental property to the owner from the accounting viewpoint of the owner. It is a management report creation program to be executed by the management report creation device created in the above, and stores the management consignment contract data related to the management consignment contract exchanged between the management company and the owner in the storage unit. The management consignment contract data storage unit, the item master that registers the item data related to the payment / payment items by the tenant of the rental property, and the journal pattern master that registers the account item data from the accounting viewpoint of the management company linked to the item data. A management report aggregation item master in which the management consignment contract data, the item data associated with the management consignment contract data, and the income and expenditure management data associated with the item data from the accounting viewpoint of the owner side are registered. Is stored, and the data acquisition step for importing the management consignment contract data to be executed by the control unit and the form of the payment management business for the owner of the management company are determined, and the account in the name of the management company is determined. When deposit and withdrawal management is performed using, the owner income is the transfer of the deposit deposited in the account in the name of the management company, and the owner expenditure is the advance payment reimbursed by the management company. , When deposit / withdrawal management is performed using an account in the name of the owner, it is assumed that the owner income is deposited in the account in the name of the owner and the owner expenditure is paid from the account in the name of the owner. And, based on the imported management consignment contract data, the item data of the management report summary item master and the income and expenditure management data of the owner side are extracted, and the item data is changed to the income and expenditure management data. It is characterized by including a step and a report creation step of creating a management report based on the income and expenditure management data changed from the accounting viewpoint of the owner side.

According to the present invention, when a management company that manages a rental property creates a management report that reports the operating status and management status of the rental property to the owner, the accounting data from the management company's point of view is used from the owner's point of view. It has the effect of making it possible to manage the income and expenditure by changing to the accounting data of.

FIG. 1 is a block diagram showing an example of the configuration of the management report creating device according to the present embodiment. FIG. 2 is a diagram showing an example of the output contents of the PM report. FIG. 3 is a diagram showing an example of the table structure of the management consignment contract data table and the PM report summary item master. FIG. 4 is a diagram showing an example of data in the management consignment contract data table. FIG. 5 is a diagram showing an example of the difference between the viewpoints of the owner and the management company when managing deposits and withdrawals in an account in the name of the management company. FIG. 6 is a diagram showing an example of the difference between the viewpoints of the owner and the management company when managing deposits and withdrawals by depositing an account in the name of the owner. FIG. 7 is a diagram showing an example of the case where the payment / payment items on the tenant side are viewed from the accounting viewpoints of the owner side and the management company side. FIG. 8 is a diagram showing an example of a table structure in which the breakdown of income and expenditure management items on the PM report is changed according to the owner accounting item. FIG. 9 is a diagram showing an example of data of the item master. FIG. 10 is a diagram showing an example of data of the journal pattern master. FIG. 11 is a diagram showing an example of data of the PM report summary item master. FIG. 12 is a diagram showing an example in which the income and expenditure management items of the PM report are created in the owner accounting item based on the PM report summary item master. FIG. 13 is a diagram showing another example in which the income and expenditure management items of the PM report are created in the owner accounting item based on the PM report summary item master. FIG. 14 is a diagram showing an example of processing in the case of managing deposits and withdrawals in the account in the name of the management company of FIG. FIG. 15 is a diagram showing an example of a case where the management company records journals using the journal pattern master in the example of FIG. FIG. 16 is a diagram showing an example of processing in the case of keeping an account in the name of the owner of FIG. 6 and managing deposits and withdrawals. FIG. 17 is an output image diagram showing an example of a case where a stacking plan for PM reports is automatically created. FIG. 18 is a diagram showing an example of a table structure when a stacking plan is automatically created. FIG. 19 is a diagram showing an example of data in the management consignment contract data table. FIG. 20 is a diagram showing an example of data in the data table for each management consignment contract room. FIG. 21 is a block diagram showing an example of data of the property master. FIG. 22 is a block diagram showing an example of room master data. FIG. 23 is a block diagram showing an example of data in the contract data table. FIG. 24 is a diagram showing an example of data of the contractor master. FIG. 25 is a diagram showing an example of room master data in each section of the 6th floor. FIG. 26 is a diagram showing an example of calculating the area ratio of each room to the total floor area.

Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. Overview]
In the past, data related to management reports (PM reports: property management reports) were collected and created manually. In addition, the layout of the management report may differ for each AM company (asset management company) or for each property, which complicates layout management and tabulation work, resulting in a high workload. It was.

The management company that manages rentals creates and outputs a material called PM report (property management report) as a monthly material that reports the operating status and management status of rental properties to the owners of rental properties. The management report creating device according to the present invention enables the balance management of billing / payment data from the viewpoint of the management company used when outputting the PM report from the accounting processing perspective of the owner side.
(B) It is possible to support two patterns of deposit management business forms.
(1) When depositing and withdrawing money is managed from an account in the name of the management company, the owner's income shall be remittance from the management company and the owner's expenditure shall be billed by the management company.
(2) When deposit and withdrawal management is performed with an account in the name of the owner, the owner's income shall be paid from the resident and the owner's expenditure shall be paid from the account.
(B) The breakdown of income and expenditure management items on the PM report can be changed according to the owner accounting item. For example, "report aggregation items" (rental income, parking lot income, building management expenses, etc.) from the perspective of owner accounting and "payment / payment items" (rent, common service expenses, parking) from the accounting perspective of contractors / tenants. It is possible to change the item breakdown by associating the "account items" (deposits, advance payments, etc.) from the management company accounting perspective with the parking lot usage fee, elevator inspection fee, common area cleaning fee, etc.).

[2. Constitution]
An example of the configuration of the management report creating device according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the management report creating device according to the present embodiment.

The management report creating device 100 is a commercially available desktop personal computer. The management report creation device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, or the like on the market. It may be a type information processing device.

The management report creating device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the management report creating device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the management report creating device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the management report creating device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used. Here, the storage unit 106 has a management consignment contract data table 106a as a management consignment contract data storage unit, a PM report aggregation item master 106b as a management report aggregation item master, an item master 106c, a journal pattern master 106d, and a total account master. 106e, sub-subject master 106f, sub-subject master 106g, management consignment contract room-specific data table 106h, property master 106i, room master 106j, contract data table 106k as contract data storage unit , The contractor master 106m and the like are provided.

The management consignment contract data table 106a includes data on the management consignment contract between the management company that manages the rental property and the owner, and a management report (hereinafter, also referred to as PM report) set for each management consignment contract. The management consignment contract data including the layout data of is stored. For example, as shown in FIG. 3, the management consignment contract data table 106a stores data such as the management consignment contract number, the property code, the landlord code, the PM report layout, and the settlement month.

The PM report summary item master 106b is registered by associating the summary items used for the PM report set for each management consignment contract with the management consignment contract number. For example, as shown in FIG. 3, the PM report summary item master 106b has a management consignment contract number, a major classification code as a summary item, a major classification name, a middle classification code, a middle classification name, a minor classification code, and a minor classification name. , And the item code indicating the item (expense item) used by the tenant such as the contractor or the resident of the rental property for deposit / payment is stored.

In the item master 106c, item data related to payment / payment items by the tenant of the rental property is registered. For example, as shown in FIGS. 8 and 9, the item master 106c stores an item code and an item name as item data.

In the journal pattern master 106d, the account item setting data from the accounting viewpoint of the management company associated with the item code as the item data is registered. For example, as shown in FIG. 8, the journal entry pattern master 106d stores account item setting data linked with financial accounting based on an item code. Account setting data includes general ledger code, sub-account code, sub-subject code, and the like.

As shown in FIG. 8, the total account code and the total account name are registered in the total account master 106e.

As shown in FIG. 8, the total account code, the sub-subject code, and the sub-subject name are registered in the sub-subject master 106f.

As shown in FIG. 8, the total account item code, the auxiliary item code, the auxiliary breakdown item code, and the auxiliary breakdown item name are registered in the auxiliary breakdown item master 106g.

As shown in FIG. 18, the management consignment contract room-specific data table 106h stores the management consignment contract number of the management consignment contract data table 106a and the room number that is the target section associated with the management consignment contract number. There is.

As shown in FIG. 18, the property master 106i stores the property code of the management consignment contract data table 106a and the property name associated with the property code.

As shown in FIG. 18, the room master 106j includes floor information associated with the property code of the property master 106i, the room number of the data table 106h for each management consignment contract room, and the occupied area of each target section (room). Is remembered.

The contract data table 106k stores contract data related to the lease contract associated with the property code and the room number of the room master 106j. For example, as shown in FIG. 18, the contract data table 106k stores a contract number, a property code, a room number, a contractor code, a contract date, an expiration date, and the like.

As shown in FIG. 18, the contractor master 106m stores the contractor code of the contract data table 106k and the contractor name as tenant data associated with the contractor code.

An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). As the input device 112, a keyboard, a mouse, and a microphone, as well as a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

The control unit 102 is a CPU or the like that collectively controls the management report creating device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute. Here, the control unit 102 functionally conceptually includes a data acquisition unit 102a as a data acquisition means, a report creation unit 102b as a report creation means, a layout setting unit 102c as a layout setting means, and an output as an output means. Unit 102d, deposit management business form determination unit 102e as a payment management business form determination means, income and expenditure management change unit 102f as a balance management change means, information collection unit 102g as an information collection means, calculation unit 102h as a calculation means, etc. I have.

The data acquisition unit 102a acquires the management consignment contract data regarding the management consignment contract exchanged between the management company that manages the rental property and the owner, and stores it in the management consignment contract data table 106a. Specifically, in addition to the management consignment contract number, property code, and landlord code, the PM report layout as the PM report format set for each management consignment contract characteristic of this embodiment, and the PM report are created. The settlement month is also imported as management consignment contract data.

The report creation unit 102b creates a PM report at least in the settlement month based on the PM report layout extracted by the layout setting unit 102c and the summary items used in the PM report. The PM report is usually created every month, but especially in the settlement month, the sheet of the "results list" of the PM report output contents in Fig. 2 is used to compare the monthly forecasts and actuals within the target accounting period of the owner accounting. The representation is created. In other words, when the year and month are displayed on the form, the settlement month is processed so that it is the last month. For example, if "December" is specified as the settlement month, the notation of "Achievement list" will be "January-December", and if "March" is specified as the settlement month, "Achievement list" will be displayed. The notation of is "April-March".

The layout setting unit 102c has a management consignment contract based on the PM report layout of the management consignment contract data table 106a imported by the data acquisition unit 102a and the aggregation items used for the PM report registered in the PM report aggregation item master 106b. Set the layout of the PM report according to.

The output unit 102d outputs the PM report created by the report creation unit 102b on the screen or by printing. For example, the data required to create a PM report for each management consignment contract number is extracted from the PM report summary item master shown in FIG. 11, and the PM report is created based on the PM report layout of the management consignment contract data table shown in FIG. create. That is, when the management consignment contract number is "0000000001", as shown in FIG. 4, the PM report of "Residence XX" is created in the settlement month of "December" using the "standard layout". The output example shown in FIG. 12 outputs the created PM report. If the management consignment contract number is "0000000002", as shown in FIG. 4, the PM report of "○○ station building" is used in the layout of "for office building" in the settlement month of "March". create. The output of the created PM report is an output example shown in FIG. Further, as an output example of the stacking plan of the PM report, there is one as shown in FIG.

The deposit management business form determination unit 102e determines by setting the operator according to the form of the deposit management business for the owner of the management company. For example, when the management company manages deposits and withdrawals of the owner's rental property using an account in the name of the management company, as shown in FIG. 5, the income of the owner is the deposit deposited in the account in the name of the management company. The money was remitted, and the owner's expenditure will be the amount charged by the management company. In addition, when the management company manages deposits and withdrawals of rental properties using an account in the name of the owner, as shown in Fig. 6, the income of the owner is deposited in the account in the name of the owner, and the expenditure of the owner. Is paid from the account in the name of the owner.

The income and expenditure management change unit 102f has the item data (item code) of the PM report summary item master 106b and the income and expenditure management data (major classification name, middle classification name, minor classification name) on the owner side based on the imported management consignment contract data. And is extracted and the item data is changed to the balance management data. This makes it possible to create a PM report from the owner's accounting perspective.

The information collection unit 102g extracts the room number associated with the management consignment contract number from the data table 106h for each management consignment contract room based on the management consignment contract number of the imported management consignment contract data, and the imported management consignment contract data. Extract the property name associated with the property code from the property master 106i based on the property code of, and extract the floor information and the area information of each target section from the room master 106j using the extracted room number and the property code. .. The information gathering unit 102g automatically creates a drawing list of tenant information in each section of the rental management property called a stacking plan (elevation or bird cage), which is one of the forms included in the PM report. Collect the area information and floor information of each section to create in.

The calculation unit 102h calculates the total floor area based on the area information and floor information of each section collected by the information collection unit 102g, calculates the area ratio of each section to the total floor area, and calculates the area ratio of each section to each section. By calculating the size on the form, the size of each display section of the stacking plan is allocated according to the ratio of the actual occupied area.

[3. Concrete example]
A specific example of the processing of the management report creating apparatus 100 according to the present embodiment will be specifically described with reference to FIGS. 2 to 26. FIG. 2 is a diagram showing an example of the output contents of the PM report. FIG. 3 is a diagram showing an example of the table structure of the management consignment contract data table and the PM report summary item master. FIG. 4 is a diagram showing an example of data in the management consignment contract data table. FIG. 5 is a diagram showing an example of the difference between the viewpoints of the owner and the management company when managing deposits and withdrawals in an account in the name of the management company. FIG. 6 is a diagram showing an example of the difference between the viewpoints of the owner and the management company when managing deposits and withdrawals by depositing an account in the name of the owner. FIG. 7 is a diagram showing an example of the case where the payment / payment items on the tenant side are viewed from the accounting viewpoints of the owner side and the management company side. FIG. 8 is a diagram showing an example of a table structure in which the breakdown of income and expenditure management items on the PM report is changed according to the owner accounting item. FIG. 9 is a diagram showing an example of data of the item master. FIG. 10 is a diagram showing an example of data of the journal pattern master. FIG. 11 is a diagram showing an example of data of the PM report summary item master. FIG. 12 is a diagram showing an example in which the income and expenditure management items of the PM report are created in the owner accounting item based on the PM report summary item master. FIG. 13 is a diagram showing another example in which the income and expenditure management items of the PM report are created in the owner accounting item based on the PM report summary item master. FIG. 14 is a diagram showing an example of processing in the case of managing deposits and withdrawals in the account in the name of the management company of FIG. FIG. 15 is a diagram showing an example of a case where the management company records journals using the journal pattern master in the example of FIG. FIG. 16 is a diagram showing an example of processing in the case of keeping an account in the name of the owner of FIG. 6 and managing deposits and withdrawals. FIG. 17 is an output image diagram showing an example of a case where a stacking plan for PM reports is automatically created. FIG. 18 is a diagram showing an example of a table structure when a stacking plan is automatically created. FIG. 19 is a diagram showing an example of data in the management consignment contract data table. FIG. 20 is a diagram showing an example of data in the data table for each management consignment contract room. FIG. 21 is a block diagram showing an example of data of the property master. FIG. 22 is a block diagram showing an example of room master data. FIG. 23 is a block diagram showing an example of data in the contract data table. FIG. 24 is a diagram showing an example of data of the contractor master. FIG. 25 is a diagram showing an example of room master data in each section of the 6th floor. FIG. 26 is a diagram showing an example of calculating the area ratio of each room to the total floor area.

[Example 1: PM report output setting for each management consignment contract]
The management company that manages rentals creates a management report called PM report (property management report) as a monthly document that reports the operating status and management status of rental properties to the owners of rental properties. Since this type of PM report is often submitted together with the transfer of the owner's remittance, it is necessary to collect various financial information as shown in FIG. 2, and the work load is increased accordingly.

As an example of the output contents of the PM report, as shown in Fig. 2, the "cover", the "property outline" that describes the outline of the property, the "stacking plan" that describes the operating status of each section (room), and each section "Rent roll" that describes the information of the rental contract, "Payment statement" that describes the payment information from the resident within the target period, "Expense statement" that describes the cost borne by the owner within the target period, Target accounting period "Achievement list" that describes the monthly balance and forecast / actual comparison of the owners, "Profit and loss statement" that describes the owner's balance / forecast / actual avoidance for the target period (monthly), and information on the arrears of the occupants of each section " Receivables statement "," Deposit transfer status "that describes the transfer status of the deposit of each rental contract within the target period," New contract information "that describes the information of the new rental contract within the target period, Rental within the target period "Cancellation information" that describes contract cancellation information, "Renewal information" that describes rental contract renewal information within the target period, "Repair information" that describes construction (repair) that occurred and completed within the target period , And there is a "management overview" that describes information on projects (inquiries, complaints, etc.) that have occurred or completed within the target period.

The management report creating device 100 according to the first embodiment creates a PM report for the management company engaged in rental management to report the operation status and management status of the rental property to the owner of the rental property. The data acquisition unit 102a of the management report creating device 100 acquires the management consignment contract data regarding the management consignment contract exchanged between the management company and the owner, and stores the data in the management consignment contract data table 106a. In this management consignment contract data table 106a, as shown in FIGS. 3 and 4, “management consignment contract number”, “property code”, “landlord code”, “PM report layout”, and “PM report layout” are used as management consignment contract data. Contains data for the "closing month".

Further, in the PM report total item master 106b of the management report creation device 100, the total items described in the PM report set for each management consignment contract are registered. Specifically, as shown in FIGS. 3 and 11, the PM report summary item master 106b is associated with the “management consignment contract number” to have a “major classification code”, a “major classification name”, and a “middle classification”. A "code", a "middle classification name", a "minor classification code", a "minor classification name", and an "item code" are registered.

In this way, in the storage unit 106 of the management report creation device 100, the total items and layouts to be described in the PM report are registered for each management consignment contract number by the management consignment contract data table 106a and the PM report total item master 106b. ing. As a result, the layout setting unit 102c of the management report creation device 100 sets the layout data and the aggregation items of the PM report to be created based on the management consignment contract number.

Then, the report creation unit 102b of the management report creation device 100 creates a PM report using the layout data collected and set by the layout setting unit 102c and the aggregated items. For example, when the management consignment contract number is “0000000001”, the “standard layout” is set in the PM report layout of “Residence XX” in the management consignment contract data table 106a shown in FIG. 4, and the PM report aggregation shown in FIG. Create a PM report using the summary items described in the upper half of the item master 106b. When the management consignment contract number is "0000000002", "for office building" is set in the PM report layout of "○○ station building" in the management consignment contract data table 106a shown in FIG. 4, and the PM shown in FIG. 11 is set. A PM report is created using the summary items described in the lower half of the report summary item master 106b.

When the management consignment contract number is "0000000001", the PM report created in this way is output from the output unit 102d by the layout and the total items as shown in "Residence XX" in FIG. Further, when the management consignment contract number is "0000000000002", the PM report is output from the output unit 102d by the layout and the total items as shown in "○○ station building" in FIG. As an output form by the output unit 102d, it can be displayed and output on a display or printed and output on a paper surface.

As described above, according to the management report creating device 100 according to the first embodiment, since the format settings such as the layout of the PM report and the summary items are held for each management consignment contract, the format settings always requested by the owner or the AM company It is possible to automatically create a PM report according to the above. As a result, the load of layout management and tabulation work required when creating a PM report is greatly reduced, and layout mistakes can be prevented.

[Example 2: Balance management from the perspective of the owner of the PM report]
The management company creates the PM report for the owner and the AM company, but since the movement of money changes depending on the form of payment management work, we will create a PM report that allows you to manage the income and expenditure from the perspective of the owner. Create automatically.

The following two patterns (1) and (2) can be considered as the form of payment management work of the management company.
(1) Manage deposits and withdrawals in an account in the name of the management company (see Fig. 5). For example, there is a case where the payment from the resident of the rental property is temporarily stored in the account in the name of the management company and then remitted to the owner in the next month.
(2) Manage deposits and withdrawals by depositing an account in the name of the owner (see Fig. 6). For example, remittance work is not required because the payment from the resident of the rental property is received directly from the account in the name of the owner.

As described above, the management report creating device 100 according to the present embodiment includes a deposit management business form determination unit 102e for determining which of the above two patterns the form of the deposit management business of the management company corresponds to. The deposit management business form determination unit 102e can manage the billing / remittance data of the management company used for the PM report as income / expenditure data on the owner side based on the determination result.

In addition, since the owner performs accounting processing based on the PM report received from the management company, it is necessary to make the breakdown of income and expenditure management in accordance with the accounting of the owner side. Therefore, the “payment / payment items” from the perspective of the contractor or resident are aggregated and displayed under another name on the PM report. The management report creating device 100 according to the second embodiment is an "report aggregation item" which is an accounting item from the owner's point of view or an "account item" which is an accounting item from the management company's point of view for this "payment / payment item". Further, the balance management change unit 102f to be changed to "" is provided. As shown in FIG. 7, the income and expenditure management change unit 102f has "report aggregation items" from the owner's point of view and "report aggregation items" from the management company's point of view, with respect to the "payment / payment items" on the tenant side from the perspective of the contractor and the resident. By changing to "account", the accounting on the owner side and the accounting on the management company side can be managed separately.

The management report creating device 100 according to the second embodiment has a table structure as shown in FIG. That is, as shown in FIG. 7, the master for converting the "payment / payment item" from the tenant's point of view into the "report summary item" from the owner's point of view or the "account item" from the management company's point of view. I have. Specifically, the item master 106c (see FIG. 9) for encoding the "payment / payment item" into the "item code" and the balance used for the PM report from the owner's point of view linked to the "item code". Journal pattern in which the PM report summary item master 106b (see Fig. 11) in which management summary items are registered and the account setting data linked to the above "item code" and linked to financial accounting from the management company's perspective are registered. It is equipped with a master 106d (see FIG. 10). The account setting data registered in the journal pattern master 106d includes a total account code, a sub-account code, a sub-subject code, and the like. Further, the total account master 106e in which the total account name is registered for the total account code, the sub-account master 106f in which the sub-account name is registered for the total account code and the sub-account code, and the above. It is provided with a total account item code, the sub-item code, and a sub-breakdown item master 106 g in which the sub-breakdown item name is registered for the sub-subject item code.

In this way, the income and expenditure management change unit 102f of the management report creating apparatus 100 according to the second embodiment can change the item breakdown of the income and expenditure management of the PM report created by the management company according to the owner accounting item. As a result, it is possible to create and output a PM report as shown in FIG. 12 or 13 in which the item code of the management company viewpoint of the PM report summary item master 106b of FIG. 11 is converted into the accounting item of the owner side.

Further, in the management report creating device 100 according to the second embodiment, when the PM report of “Residence XX” in FIG. 12 is created, the payment management business form of the management company is in the name of the management company in the payment management business form determination unit 102e. As shown in Fig. 14, the management company will remit the May rent of 100 yen to the owner on "2017/05/10" as shown in Fig. 14. At that time, 50 yen will be paid to offset the interior work fee that had been paid in advance. In other words, when the management company remits the rent of 100 yen as a deposit to the owner, the rent of 100 yen as payment data is offset by the interior construction fee of 50 yen as billing data. You only have to pay 50 yen.

In this case, in the management company accounting, the journal shown in FIG. 15 is recorded using the journal pattern master 106d of FIG. That is, in order to record the rent of 100 yen as a deposit on the debit side and the interior work fee of 50 yen as the advance payment on the credit side, the cash of 50 yen after offsetting is remitted.

On the other hand, in the management report creating device 100 according to the second embodiment, when the PM report of “Residence XX” in FIG. 12 is created, the deposit management business form of the management company is owned by the deposit management business form determination unit 102e. Judging that it is the case of (2) where deposits and withdrawals are managed by depositing an account in the name, as shown in Fig. 16, the rent for May is 100 yen from the lessor to the account in the name of the owner on "2017/05/25". There was a deposit. Then, he paid 50 yen for the interior work on "2017/05/30". In other words, in this case, since deposits and withdrawals are made in the owner's name account, there is no effect on the management company accounting and journal entry is not required.

In this way, the management report creating device 100 according to the second embodiment has an item master 106c in which "payment / payment items" are registered from the tenant's viewpoint and a PM report total item in which "report total items" are registered from the owner's viewpoint. Since the master 106b and the journal pattern master 106d in which the "account" is registered from the viewpoint of the management company hold various data in a form linked to the common "item code", it is based on this "item code". The feature is that the correspondence between mutual data can be confirmed.

In this way, according to the management report creating device 100 according to the second embodiment, the accounting data from the management company's viewpoint is changed to the accounting data from the owner's viewpoint according to the payment management business form of the management company, and the income and expenditure is managed. be able to. Further, according to the management report creating device 100 according to the second embodiment, since the owner of the rental property performs accounting processing based on the PM report received from the management company, "payment / payment" from the viewpoint of the contractor or the resident. It is possible to create a PM report by changing the "item" to a breakdown that is in line with accounting from the perspective of the owner.

[Example 3: Automatic creation of stacking plan]
As one of the forms of the PM report, as shown in FIG. 2, there is a stacking plan that describes the operating status of each section (each room). As shown in FIG. 17, for example, the stacking plan is a list in which resident information is described in each section of the rental management property and made into a drawing. By creating the print width of each section displayed in this stacking plan in proportion to the ratio of each section area to the floor area, there is an advantage that the owner can visually grasp the area ratio of the target section. be. Until now, stacking plans have been created manually, and since the lot area and floor layout differ for each managed property, it is necessary to manage the created file for each property, and the occupancy status for all properties. The workload was high due to the work of monthly maintenance.

Therefore, as shown in FIG. 18, the storage unit 106 of the management report creating device 100 according to the third embodiment has a management consignment contract data table 106a for storing a “property code” associated with the “management consignment contract number”. The management consignment contract data table 106h that stores the "room number" associated with the "management consignment contract number" in the management consignment contract data table 106a, and the "property code" associated with the "property code" in the management consignment contract data table 106a. "Floor information" associated with the property master 106i in which "" is registered, the "property code" of the property master 106i, and the "room number" of the data table 106h for each management consignment contract room, and the "floor information" of each target section (room). The room master 106j in which the "occupied area" is registered is stored.

Further, in order to acquire each tenant information in the stacking plan in the storage unit 106 of the management report creating device 100, the “contract number” of the lessor contract is linked to the “property code” and the “room number” of the room master 106j. , "Contractor code", "Contract date" and "Expiration date" are stored in the contract data table 106k, and the "Contractor name" associated with the "Contractor code" in the contract data table 106k is registered. The contractor master 106m and the contractor master 106m are further stored.

As an example of each of the above tables and each master, FIG. 19 shows a management consignment contract data table 106a, FIG. 20 shows a management consignment contract room-specific data table 106h, and FIG. 21 shows a property master 106i. 22 shows the room master 106j, FIG. 23 shows the contract data table 106k, and FIG. 24 shows the contractor master 106m.

First, the data acquisition unit 102a of the management report creating device 100 acquires the management consignment contract data regarding the management consignment contract exchanged between the management company and the owner, and stores the data in the management consignment contract data table 106a. Then, the information collecting unit 102g extracts the "room number" associated with the "management consignment contract number" of the management consignment contract data table 106a from the management consignment contract room-specific data table 106h, and also extracts the "property code" of the property master 106i. Based on the above, "floor information" and "occupied area" information of each room are collected from the room master 106j. Further, the information collecting unit 102g collects information on the lease contract from the contract data table 106k based on the “property code” and the “room number” of the room master 106j, and based on the “contractor code” of the contract data table 106k. Collect tenant information about contractors and tenants associated with the lease contract from the contractor master 106m.

Then, the calculation unit 102h of the management report creating device 100 of each section (each room) displayed in the stacking plan based on the information collected by the information collection unit 102g (for example, the information of the room master shown in FIG. 25). The print width is automatically calculated so that it is proportional to the area ratio of each section to the floor area. Specifically, as shown in the calculation example of the area ratio of each room to the total floor area in FIG. 26, the value obtained by dividing the occupied area of each room by the total floor area (481.63 m ³ ) and converting it into a percentage is calculated. Calculate for each room and round down the fraction. Here, since the fraction is rounded down, the total value is "95" which is "100" or less. In that case, as shown in the proportional division calculation example of FIG. 26, the calculation unit 102h can calculate the number of print cells as an integer by proportionally dividing the difference from "100" by 1 in descending order of the occupied area of the room. This makes it possible to obtain the number of print cells in which the area ratio of each section is substantially proportional to the floor area.

Specifically, since 100-95 = 5 (the number of insufficient print cells), the five room numbers "608", "607", "605", "606", "606" are arranged in descending order of the occupied area of the room. 604 ”is extracted, and the value obtained by adding +1 to the calculated number of print cells is used as the final number of print cells. As a result, as shown in the final result of FIG. 26, the total number of print cells is "100". The above-mentioned proportional division calculation is an example, and is not necessarily limited to this method.

The report creation unit 102b of the management report creation device 100 allocates each section of the stacking plan according to the number of print cells based on the calculation result, and the management consignment contract information and the building (property) collected by the information collection section 102g in each section. Enter information, lot (room) information, lease contract information, and tenant information about the contractor / resident.

Further, when the contractor name of the room master 106j shown in FIG. 25 is blank, the report creation unit 102b creates the room as "vacant" because there is no lease contract to be linked.

As described above, according to the management report creating apparatus 100 according to the third embodiment, the printing width of each section (each room) is calculated by the calculation unit 102h using the data collected by the information collection unit 102g. Can be automatically assigned to the floor area in proportion to the area ratio of each section, and the stacking plan in which the necessary information is inserted in each section is automatically created by the report creation unit 102b, and the output unit 102d. Can be output from. Therefore, it is not necessary to manage the file in which the stacking plan is created for each managed property, and the stacking plan can be easily created without imposing a workload.

[4. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical ideas described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed may be performed manually, or all the processes described as being performed manually may be performed. Alternatively, a part thereof can be automatically performed by a known method.

In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in this specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the management report creating device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the management report creating device 100, particularly each processing function performed by the control unit 102, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and a management report is created as necessary. It is read mechanically by the device 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into the RAM, and constitutes the control unit 102 in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the management report creation device 100 via an arbitrary network, and all or a part thereof can be downloaded as needed. Is.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium and the installation procedure after reading in each device shown in the embodiment.

Various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the management report creating device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the management report creating device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the information processing device.

Further, the specific form of distribution / integration of the device is not limited to the one shown in the figure, and all or a part thereof may be functionally or physically in an arbitrary unit according to various additions or functional additions. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

The present invention is applicable to a rental management business such as real estate, and is particularly useful in an industry in which a management company regularly prepares a management report for rental properties for the owner.

100 Management report creation device 102 Control unit 102a Data acquisition unit 102b Report creation unit 102c Layout setting unit 102d Output unit 102e Payment management Business form judgment unit 102f Balance management change unit 102g Information collection unit 102h Calculation unit 104 Communication interface unit 106 Storage unit 106a Management consignment contract data table 106b PM report summary item master 106c Item master 106d Journal pattern master 106e Total account master 106f Sub-subject master 106g Sub-subject master 106h Management consignment contract Room-specific data table 106i Property master 106j Room master 106k Contract data Table 106m Contractor master 108 Input / output interface unit 112 Input device (keyboard)
114 Output device (monitor)
200 servers 300 networks

Claims (6)

It is a management report creation device that has a storage unit and a control unit and creates a management report for the rental property management company to report the operation status and management status of the rental property to the owner from the accounting viewpoint of the owner.
In the storage unit
A management consignment contract data storage unit that stores management consignment contract data related to the management consignment contract entered into between the management company and the owner,
An item master that registers item data related to payment / payment items by the tenant of the rental property, and
A journal pattern master that registers account data from the accounting perspective of the management company linked to the item data,
A management report aggregation item master in which the management consignment contract data, the item data associated with the management consignment contract data, and the income and expenditure management data associated with the item data from the accounting viewpoint of the owner side are registered.
Is stored,
The control unit
The data acquisition means for importing the management consignment contract data and
If the management company determines the form of deposit management work for the owner and manages deposits and withdrawals using an account in the name of the management company, the owner income remits the deposit deposited in the account in the name of the management company. The owner's expenditure is the one for which the management company has requested the remittance, and if the deposit and withdrawal management is performed using the account in the owner's name, the owner's income is deposited in the account in the owner's name. So, the owner's expenditure is assumed to have been paid from the account in the name of the owner.
An income and expenditure management changing means for extracting the item data of the management report aggregation item master and the income and expenditure management data on the owner side based on the imported management consignment contract data and changing the item data to the income and expenditure management data. ,
A report creation method that creates a management report based on the income and expenditure management data changed from the accounting perspective of the owner,
Being equipped with
A management report creation device featuring. The management report is
It ’s a property management report.
Report to at least one of the rental property owner and the asset management company,
The management report creating apparatus according to claim 1. The control unit
Further provided with an output means for outputting the created management report on the screen or by printing.
The management report creating apparatus according to claim 1 or 2. The journal pattern master is
Total account data, sub-item data, and sub-breakdown item data are linked as account data from the accounting perspective of the management company that is linked to the item data and linked to financial accounting.
In the storage unit
A total account master for registering the total account code and the total account name of the total account data, and
A sub-subject master that registers the sub-subject code and sub-subject name of the sub-subject data,
The auxiliary breakdown subject master that registers the auxiliary breakdown subject code and the auxiliary breakdown subject name of the auxiliary breakdown subject data, and
Is stored further,
The management report creating apparatus according to any one of claims 1 to 3, wherein the management report is created. Management executed by a management report creation device that has a storage unit and a control unit and creates a management report for the rental property management company to report the operation status and management status of the rental property to the owner from the accounting viewpoint of the owner. How to create a report
In the storage unit
A management consignment contract data storage unit that stores management consignment contract data related to the management consignment contract entered into between the management company and the owner,
An item master that registers item data related to payment / payment items by the tenant of the rental property, and
A journal pattern master that registers account data from the accounting perspective of the management company linked to the item data,
A management report aggregation item master in which the management consignment contract data, the item data associated with the management consignment contract data, and the income and expenditure management data associated with the item data from the accounting viewpoint of the owner side are registered.
Is stored,
Executed by the control unit,
The data acquisition step for importing the management consignment contract data,
If the management company determines the form of deposit management work for the owner and manages deposits and withdrawals using an account in the name of the management company, the owner income remits the deposit deposited in the account in the name of the management company. The owner's expenditure is the one for which the management company has requested the remittance, and if the deposit and withdrawal management is performed using the account in the owner's name, the owner's income is deposited in the account in the owner's name. So, the owner expenditure is assumed to have been paid from the account in the name of the owner.
With the income and expenditure management change step that extracts the item data of the management report summary item master and the income and expenditure management data of the owner side based on the imported management consignment contract data, and changes the item data to the income and expenditure management data. ,
A report creation step that creates a management report based on the income and expenditure management data changed from the accounting perspective of the owner,
To include,
How to create a management report featuring. It is equipped with a storage unit and a control unit, and the management company of the rental property can execute the management report for reporting the operation status and management status of the rental property to the owner with the management report creation device that creates the management report from the accounting viewpoint of the owner. It is a management report creation program
In the storage unit
A management consignment contract data storage unit that stores management consignment contract data related to the management consignment contract entered into between the management company and the owner,
An item master that registers item data related to payment / payment items by the tenant of the rental property, and
A journal pattern master that registers account data from the accounting perspective of the management company linked to the item data,
A management report aggregation item master in which the management consignment contract data, the item data associated with the management consignment contract data, and the income and expenditure management data associated with the item data from the accounting viewpoint of the owner side are registered.
Is stored,
To be executed by the control unit
The data acquisition step for importing the management consignment contract data and
If the management company determines the form of deposit management work for the owner and manages deposits and withdrawals using an account in the name of the management company, the owner income remits the deposit deposited in the account in the name of the management company. The owner's expenditure is the one for which the management company has requested the remittance, and if the deposit and withdrawal management is performed using the account in the owner's name, the owner's income is deposited in the account in the owner's name. So, the owner expenditure is assumed to have been paid from the account in the name of the owner.
With the income and expenditure management change step that extracts the item data of the management report summary item master and the income and expenditure management data of the owner side based on the imported management consignment contract data, and changes the item data to the income and expenditure management data. ,
A report creation step that creates a management report based on the income and expenditure management data changed from the accounting perspective of the owner,
To include,
A management reporting program featuring.

Images