JP7075294B2 - Rental contract renewal management device, rental contract renewal management method, and rental contract renewal management program - Google Patents

Description

The present invention relates to a rental contract renewal management device, a rental contract renewal management method, and a rental contract renewal management program.

Patent Document 1 discloses a configuration for managing information regarding a renewal fee for each property of a rental housing.

Japanese Unexamined Patent Publication No. 2004-252596

However, in the invention described in Patent Document 1, although the concept of renewal fee management is described, the presence or absence of renewal fee payment and the form of remittance to the landlord are automatically determined, and the claim to the landlord is automatically recorded. There was a problem that I couldn't do it.

The present invention has been made in view of the above problems, and the renewal fee received from the landlord is automatically recorded as a deduction amount at the same timing as the renewal fee collected from the lessee is recorded as the remittance amount to the landlord. The purpose is to provide a rental contract renewal management device, a rental contract renewal management method, and a rental contract renewal management program that can be used.

In order to solve the above-mentioned problems and achieve the object, the rental contract renewal management device according to the present invention is a rental contract renewal management device including a storage unit and a control unit, and the storage unit is a rental property. Contract revision storage means for storing contract revision data including the borrower's borrower identifier, rental contract revision date data, the landlord's identifier of the rental property, and the renewal fee remittance form data to the landlord, and the above. Renewal fee collection schedule storage means for storing the borrower identifier, the scheduled collection date data to the borrower, and the renewal fee collection schedule data including the renewal fee amount of the renewal fee, the borrower identifier, the revised date data, And, the contract revision deduction breakdown storage means for storing the contract revision deduction breakdown data including the renewal fee amount of the renewal fee to the rental management company, and the deposit for storing the payment application data related to the payment application for the renewal fee collection schedule data. The control unit is provided with an application storage means, and the control unit is based on the contract revision data, and when the remittance form is a guaranteed remittance, the renewal is based on the renewal fee collection schedule data and the contract revision deduction breakdown data. Guarantee payment request creation means for creating payment request data to the rental management company including the fee amount, and fee collection schedule data for the landlord including the renewal fee amount, contract revision data, and payment application data. If the remittance form is post-payment remittance and there is the renewal fee that has already been applied, the renewal fee amount will be calculated based on the renewal fee collection schedule data and the contract revision deduction breakdown data. It is characterized by comprising the payment request data for the rental management company, and a post-payment payment request creation means for creating the fee collection schedule data for the landlord, including the renewal fee amount.

Further, in the rental contract renewal management device according to the present invention, the control unit is a remittance journal creation means for creating remittance journal data of the renewal fee and the renewal fee based on the payment request data and the fee collection schedule data. , Further prepared.

Further, in the rental contract renewal management device according to the present invention, the remittance journal creation means creates the remittance journal data of the renewal fee with the debit account as the deposit based on the payment request data, and , The remittance journal data of the renewal fee having the credit account as the fee income is created based on the fee collection schedule data.

Further, in the rental contract renewal management device according to the present invention, the guarantee payment request creation means and the post-payment payment request creation means further create remittance data including the remittance date data of the renewal fee. It is a feature.

Further, in the rental contract renewal management device according to the present invention, the storage unit uses the management consignment contract identifier of the management consignment contract between the landlord and the rental management company, the rental property identifier of the rental property, and the landlord. The management consignment contract storage means for storing the management consignment contract master in which the identifier is set, the borrower identifier, the rental property identifier, and the contract storage means for storing the contract master in which the contract expiration date is set are further provided. The control unit is further provided with a contract revision creation means for creating the contract revision data based on the management consignment contract master and the contract master.

Further, in the rental contract renewal management device according to the present invention, the storage unit uses the management consignment contract identifier of the management consignment contract between the landlord and the rental management company, the rental property identifier of the rental property, and the landlord. A management consignment contract storage means for storing a management consignment contract master in which an identifier is set, a contract storage means for storing the borrower identifier, the rental property identifier, and a contract master in which a contract expiration date is set, the borrower identifier, and Further, the contract rent renewal storage means for storing the contract rent renewal master for which the renewal charge amount is set is further provided, and the control unit has the borrower identifier and the collection based on the contract master and the contract rent renewal master. The borrower identifier, said It is further provided with a collection schedule data, a management consignment contract identifier, and a renewal fee collection schedule creation means for creating the renewal fee collection schedule data including the renewal charge amount.

Further, in the rental contract renewal management device according to the present invention, the storage unit includes a contract storage means for storing the borrower identifier, the rental property identifier of the rental property, and the contract master for which the contract expiration date is set, and the borrower. Further provided with an identifier and a contract rent renewal storage means for storing the contract remittance renewal deduction master for which the renewal fee amount is set, the control unit is based on the contract master and the contract remittance renewal deduction master. , The contract revision deduction breakdown creation means for creating the contract revision deduction breakdown data is further provided.

Further, in the rental contract renewal management device according to the present invention, when the borrower deposits the renewal fee to the rental management company, the control unit collects the renewal fee including the renewal fee amount of the renewal fee. It is further provided with a payment application creation means for creating the payment application data relating to the payment application for the scheduled data.

Further, in the rental contract renewal management device according to the present invention, the control unit is further provided with a payment journal creation means for creating payment journal data for the renewal fee based on the payment application data. do.

Further, in the rental contract renewal management device according to the present invention, the control unit has the borrower identifier, the remittance date data, and the renewal fee amount based on the remittance data, the payment request data, and the fee collection schedule data. , The monthly report creation means for creating the monthly report data including the renewal fee amount and the payment amount to the landlord obtained by subtracting the renewal fee amount from the renewal fee amount, and further provided. do.

Further, the rental contract renewal management method according to the present invention is a rental contract renewal management method for causing a rental contract renewal management device including a storage unit and a control unit to execute, and the storage unit is the lessee of the rental property. Contract revision storage means for storing contract revision data including the borrower identifier, the contract revision date data, the landlord identifier of the landlord of the rental property, and the contract revision data including the renewal fee remittance form data to the landlord, and the borrower identifier. , The renewal fee collection schedule storage means for storing the renewal fee collection schedule data including the renewal fee collection schedule data to the borrower, the borrower identifier, the revised date data, and Contract revision deduction breakdown data including the contract revision deduction breakdown data including the renewal fee amount to the rental management company. When the remittance form is guaranteed remittance based on the contract revision data provided with the storage means and executed by the control unit, the renewal is based on the renewal fee collection schedule data and the contract revision deduction breakdown data. Guarantee payment request creation step to create payment request data to the rental management company including the fee amount and fee collection schedule data to the landlord including the renewal fee amount, contract revision data and payment application data. If the remittance form is post-payment remittance and there is the renewal fee that has already been applied, the renewal fee amount will be calculated based on the renewal fee collection schedule data and the contract revision deduction breakdown data. It is characterized by including the payment request data for the rental management company, and a post-payment payment request creation step for creating the fee collection schedule data for the landlord, including the renewal fee amount.

Further, the rental contract renewal management program according to the present invention is a rental contract renewal management program for causing a rental contract renewal management device including a storage unit and a control unit to execute, and the storage unit is the lessee of the rental property. Contract revision storage means for storing contract revision data including the borrower identifier, the contract revision date data, the landlord identifier of the landlord of the rental property, and the contract revision data including the renewal fee remittance form data to the landlord, and the borrower identifier. , The renewal fee collection schedule storage means for storing the renewal fee collection schedule data including the renewal fee collection schedule data to the borrower, the borrower identifier, the revised date data, and Contract revision deduction breakdown data including the contract revision deduction breakdown data including the renewal fee amount to the rental management company. When the control unit is provided with a storage means and the remittance form is guaranteed remittance based on the contract revision data, the renewal fee amount is based on the renewal fee collection schedule data and the contract revision deduction breakdown data. Based on the guarantee payment request creation step for creating the payment request data for the rental management company, including the payment request data for the rental management company, and the fee collection schedule data for the landlord, including the renewal fee amount, and the contract revision data and the payment application data. If the remittance form is post-payment remittance and there is the renewal fee for which the payment has been applied, the renewal fee amount is included based on the renewal fee collection schedule data and the contract revision deduction breakdown data. It is characterized in that the payment request data for the rental management company and the post-payment payment request creation step for creating the fee collection schedule data for the landlord including the renewal fee amount are executed.

In rental contract management, there are various payments from the lessee such as monthly rent and temporary repair costs on a daily basis, and the payment of renewal fees from the lessee is from the management company (rental management company). Since it occurs irregularly after the time when the contract renewal guidance is started (for example, about 3 months before the contract expiration date), whether or not the renewal fee has been paid and the form of renewal fee remittance is either post-payment or post-payment. It was necessary to manually check whether the remittance was a guaranteed remittance and whether the deduction amount related to the renewal fee was entered to the landlord, but according to the present invention, by automating these operations, It has the effect of improving the business of the rental management company and ensuring the recovery of income.

FIG. 1 is a diagram showing an example of rental contract management. FIG. 2 is a block diagram showing an example of the configuration of the rental contract renewal management device. FIG. 3 is a flowchart showing an example of processing of the rental contract renewal management device in the present embodiment. FIG. 4 is a diagram showing an example of a data structure in the present embodiment. FIG. 5 is a diagram showing an example of the management consignment contract master in the present embodiment. FIG. 6 is a diagram showing an example of a contract master in this embodiment. FIG. 7 is a diagram showing an example of the contract rent renewal master in the present embodiment. FIG. 8 is a diagram showing an example of a contract remittance renewal deduction master in this embodiment. FIG. 9 is a diagram showing an example of contract revision data in the present embodiment. FIG. 10 is a diagram showing an example of billing data at the time of contract revision in the present embodiment. FIG. 11 is a diagram showing an example of contract revision deduction breakdown data in the present embodiment. FIG. 12 is a diagram showing an example of contract revision data in the present embodiment. FIG. 13 is a diagram showing an example of the renewal fee collection schedule data in the present embodiment. FIG. 14 is a diagram showing an example of payment application data in the present embodiment. FIG. 15 is a diagram showing an example of deposit journal data in the present embodiment. FIG. 16 is a diagram showing an example of payment data creation processing in the present embodiment. FIG. 17 is a diagram showing an example of the deduction data creation process in the present embodiment. FIG. 18 is a diagram showing an example of payment data creation processing in the present embodiment. FIG. 19 is a diagram showing an example of the deduction data creation process in the present embodiment. FIG. 20 is a diagram showing an example of an output result in this embodiment. FIG. 21 is a diagram showing an example of remittance journal data in the present embodiment. FIG. 22 is a diagram showing an example of a monthly report in this embodiment.

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]
First, the outline of the present invention will be described with reference to FIG. FIG. 1 is a diagram showing an example of rental contract management.

Traditionally, rental management companies have managed rental contracts for apartments, condominiums, or business properties, and one of the management operations is lease renewal, and in the case of general rental housing, the contract period. However, it is two years, and when the expiration date comes, it is necessary to renew the contract. For example, as shown in Fig. 1, in rental contract management, (1) the rental management company (management company) charges the lessee (lessee) for rent, etc., and (2) the lessee makes the management company. In response to this, the lease contract to pay for the claim, and (3) the management company pays the lender (landlord) the rent collected from the lessee, and (4) the landlord pays the management company each business. We are engaged in management work based on a management consignment contract that pays a fee for.

In addition, in the lease renewal business, the lessee has traditionally paid a remittance fee (for example, January rent) to the landlord when renewing the contract, but the remittance fee is the income of the landlord. The management company collects the renewal fee from the lessee and remits it to the landlord (that is, in the case of "post-payment remittance", the management company remits to the landlord in the next remittance month when the renewal fee is deposited from the lessee. However, in the case of "guaranteed remittance", the management company will remit the remittance in the renewal month even if the lessee does not pay the renewal fee), and the landlord will remit from the renewal fee received to the management company. I'm paying a fee.

Therefore, in this embodiment, both "post-payment remittance" and "guaranteed remittance" patterns are supported, and in either pattern, the renewal fee can be automatically deducted at the timing when the remittance is recorded. ing.

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

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

The rental contract renewal management 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 rental contract renewal management device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the rental contract renewal management 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 rental contract renewal management 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. The storage unit 106 includes a management consignment contract master 106a, a contract master 106b, a contract rent renewal master 106c, a contract remittance renewal deduction master 106d, a contract revision file 106e, a renewal fee collection schedule file 106f, and a contract revision deduction. It includes a breakdown file 106g and a deposit application file 106h.

The management consignment contract master 106a is a master in which the management consignment contract identifier of the management consignment contract between the landlord and the rental management company, the rental property identifier of the rental property, and the landlord identifier are set. Here, the management consignment contract master 106a may include a room identifier and the like of the rental property. Further, in the present embodiment, the identifier may be a number, a code, a character, a symbol and / or a name (for example, a name or the like).

The contract master 106b is a master that sets the lessee identifier (for example, the contract number and the name of the lessee) of the lessee of the rental property, the rental property identifier of the rental property, and the contract expiration date of the rental property. Here, the contract master 106b may include a room identifier of the rental property and the like.

The contract rent renewal master 106c is a master in which the lessee identifier of the lessee of the rental property and the renewal fee amount of the rental property are set. Here, the contract rent renewal master 106c may include an item identifier and the like.

The contract remittance renewal deduction master 106d is a master in which the borrower identifier of the lessee of the rental property and the renewal fee amount of the rental property are set. Here, the contract remittance renewal deduction master 106d may include an item identifier and the like.

The contract revision file 106e stores contract revision data including the borrower identifier of the lessee of the rental property, the revision date data of the rental contract, and the remittance form data of the renewal fee to the landlord. Here, the contract revision data may include the landlord identifier of the landlord of the rental property and / or the remittance date data of the renewal fee to the landlord.

The renewal fee collection schedule file 106f stores the borrower identifier of the lessee of the rental property, the scheduled collection date data to the borrower, and the renewal fee collection schedule data including the renewal fee renewal fee amount. Here, the renewal fee collection schedule data includes the renewal fee collection schedule identifier that identifies the renewal fee collection schedule, the management consignment contract identifier of the management consignment contract between the landlord and the rental management company, the billing partner classification, the item identifier, and / Alternatively, it may include a remittance identifier (for example, a remittance number, etc.) that identifies the renewal fee remittance to the landlord.

The contract revision deduction breakdown file 106g stores the contract revision deduction breakdown data including the borrower identifier of the lessee of the rental property, the revision date data of the rental contract, and the renewal fee amount of the renewal fee to the rental management company. Here, the contract revision deduction breakdown data may include an item identifier and the like.

The deposit application file 106h stores the deposit application data related to the payment application for the update fee collection schedule data. Here, the deposit application data may include a deposit application identifier that identifies the payment application, a renewal fee collection schedule identifier that identifies the renewal fee collection schedule, and / or a renewal fee renewal charge amount. ..

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 touch panel). 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 or a printer 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 comprehensively controls the rental contract renewal management 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. Run. The control unit 102 is functionally conceptually composed of a contract revision creation unit 102a, a contract revision billing creation unit 102b, a renewal fee collection schedule creation unit 102c, a contract revision deduction breakdown creation unit 102d, and a payment application creation unit 102e. It also includes a deposit journal creation unit 102f, a guarantee payment request creation unit 102g, a post-payment payment request creation unit 102h, a remittance journal creation unit 102i, and a monthly report creation unit 102j.

The contract revision creation unit 102a creates contract revision data based on the contract master 106b. Here, the contract revision creation unit 102a may create contract revision data based on the management consignment contract master 106a and the contract master 106b. Further, the contract revision creation unit 102a may store the contract revision data in the contract revision file 106e.

The contract revision billing unit 102b creates contract revision billing data including the borrower identifier, the scheduled collection date, and the renewal fee amount based on the contract master 106b and the contract rent renewal master 106c. Here, the contract revision billing unit 102b may store the contract revision billing data in the renewal fee collection schedule file 106f.

The renewal fee collection schedule creation unit 102c is based on the management consignment contract master 106a and the contract revision billing data, and renewal fee collection schedule data including the borrower identifier, the collection schedule date data, the management consignment contract identifier, and the renewal fee amount. To create. Here, the renewal fee collection schedule creation unit 102c may store the renewal fee collection schedule data in the renewal fee collection schedule file 106f.

The contract revision deduction breakdown creation unit 102d creates contract revision deduction breakdown data based on the contract master 106b and the contract remittance renewal deduction master 106d. Here, the contract revision deduction breakdown creation unit 102d may store the contract revision deduction breakdown data in the contract revision deduction breakdown file 106g.

When the lessee has paid the renewal fee to the rental management company, the payment application creation unit 102e creates the payment application data related to the payment application for the renewal fee collection schedule data including the renewal fee amount of the renewal fee. Here, the deposit application creation unit 102e may store the deposit application data in the deposit application file 106h.

The deposit journal creation unit 102f creates deposit journal data for the renewal fee based on the deposit application data. Here, the deposit journal creation unit 102f may create deposit journal data for the renewal fee with the credit account as the deposit, based on the deposit application data.

The guarantee payment request creation unit 102g pays the rental management company including the renewal fee amount based on the renewal fee collection schedule data and the contract revision deduction breakdown data when the remittance form is the guarantee remittance based on the contract revision data. Create request data and fee collection schedule data for the landlord, including the renewal fee amount. Here, the guarantee payment request creation unit 102g may create remittance data including remittance date data of the renewal fee.

Based on the contract revision data and the payment application data, the post-payment payment request creation unit 102h will collect the renewal fee collection schedule data and the contract if the remittance form is post-payment remittance and there is a renewal fee for which the payment has been applied. Based on the revised deduction breakdown data, the payment request data to the rental management company including the renewal fee amount and the fee collection schedule data to the landlord including the renewal fee amount are created. Here, the post-payment payment request creation unit 102h may create remittance data including remittance date data of the renewal fee. Here, the payment request data includes a payment request identifier, a remittance identifier, a payee code, an item code, a renewal fee amount, a borrower identifier, a management consignment contract identifier, a renewal fee collection schedule identifier, and / or a payment application identifier and the like. It may be included. In addition, the fee collection schedule data may include a fee collection schedule identifier, a borrower identifier, a revised date data, a management consignment contract identifier, a billing business partner classification, an item code, a renewal fee amount, and / or a remittance identifier. good. Further, the remittance data may include a remittance identifier, remittance date data, and / or a management consignment contract identifier and the like.

The remittance journal creation unit 102i creates remittance journal data for renewal fees and renewal fees based on payment request data and fee collection schedule data. Here, the remittance journal creation unit 102i creates the remittance journal data of the renewal fee with the debit account as the deposit based on the payment request data, and the credit account item based on the fee collection schedule data. You may create remittance journal data for renewal fees with.

The monthly report preparation unit 102j calculates the renewal fee amount from the borrower identifier, remittance date data, renewal fee amount, renewal fee amount, and renewal fee amount based on the remittance data, payment request data, and fee collection schedule data. Create monthly report data including the amount paid to the landlord after deduction. Here, the monthly report data may include a rental property identifier and / or a landlord identifier of the rental property. Further, the monthly report creation unit 102j may output the monthly report data via the output device 114.

[3. Concrete example]
Specific examples of this embodiment will be described with reference to FIGS. 3 to 22.

[Rental contract renewal management process]
Here, an example of the rental contract renewal management process in the present embodiment will be described with reference to FIGS. 3 to 22. FIG. 3 is a flowchart showing an example of processing of the rental contract renewal management device 100 in the present embodiment.

As shown in FIG. 3, the guarantee payment request creation unit 102g determines whether or not the form of remittance of the renewal fee to the landlord of the rental property is the guarantee remittance based on the contract revision data stored in the contract revision file 106e. Judgment (step SA-1).

Then, when the guarantee payment request creation unit 102g determines that the remittance form of the renewal fee to the landlord of the rental property is not the guarantee remittance but the remittance after payment (step SA-1: No), the process is performed in step SA-. Move to 2.

Then, the payment application creation unit 102e determines whether or not the renewal fee has been paid by the lessee to the rental management company (step SA-2).

Then, when the payment application creation unit 102e determines that the renewal fee has not been paid by the lessee to the rental management company (step SA-2: No), the process ends.

On the other hand, when the payment request creation unit 102h determines that the renewal fee has been paid from the lessee to the rental management company (step SA-2: Yes), the process shifts to step SA-3.

Then, the payment application creation unit 102e inputs the payment application data related to the payment application for the renewal fee collection schedule data stored in the renewal charge collection schedule file 106f, including the renewal charge amount of the renewal charge from the borrower to the rental management company. It is created and the deposit application data is stored in the deposit application file 106h (step SA-3).

Then, the deposit journal creation unit 102f creates the deposit journal data of the renewal fee based on the deposit application data stored in the deposit application file 106h (step SA-4).

Then, the payment request creation unit 102h after payment remits the renewal fee based on the renewal fee collection schedule data stored in the renewal fee collection schedule file 106f and the contract revision deduction breakdown data stored in the contract revision deduction breakdown file 106g. Create remittance data including year / month data, payment request data to rental management company including renewal fee amount, and fee collection schedule data to landlord including renewal fee amount (step SA-5), and process step SA Move to -7.

On the other hand, when the guarantee payment request creation unit 102g determines that the remittance form of the renewal fee to the landlord of the rental property is the guarantee remittance (step SA-1: Yes), the process shifts to step SA-6.

Then, the guarantee payment request creation unit 102g remits the renewal fee based on the renewal fee collection schedule data stored in the renewal fee collection schedule file 106f and the contract revision deduction breakdown data stored in the contract revision deduction breakdown file 106g. Create remittance data including monthly data, payment request data to the rental management company including renewal fee amount, and fee collection schedule data to the landlord including renewal fee amount (step SA-6).

Then, the remittance journal creation unit 102i creates the remittance journal data of the renewal fee with the debit account as the deposit based on the payment request data, and creates the credit account based on the fee collection schedule data. Create remittance journal data for renewal fees as fee income (step SA-7).

Then, the monthly report preparation unit 102j determines the rental property identifier, the landlord identifier, the borrower identifier, the remittance date data, the renewal fee amount, and the renewal fee based on the remittance data, the payment request data, and the fee collection schedule data. Monthly report data including the amount and the amount paid to the landlord by subtracting the renewal fee amount from the renewal fee amount is created, and the monthly report data is printed out via the output device 114 (step SA-). 8), the process is finished.

Here, an example of the data structure in the present embodiment will be described with reference to FIG. FIG. 4 is a diagram showing an example of a data structure in the present embodiment.

As shown in FIG. 4, in the present embodiment, the management consignment contract master 106a and the contract master 106b are linked via the property code and the room identifier (room number), and the contract master 106b is linked via the contract number. The contract rent renewal master 106c, the contract remittance deduction master 106d, and the contract revision file 106e are linked, and the contract revision file 106e and the renewal fee collection schedule via the borrower identifier (contract number) and the revision date data. The file 106f and the contract revision deduction breakdown file 106g are linked, and the renewal fee collection schedule file 106f and the deposit application file 106h are linked via the renewal fee collection schedule identifier (renewal fee collection schedule number). You may. Then, as shown in FIG. 4, in the present embodiment, the remittance data, the payment request data, and the fee collection schedule data linked by the remittance identifier (remittance number) are collected based on the linked data. You may create it.

Here, an example of the master in the present embodiment will be described with reference to FIGS. 5 to 8. FIG. 5 is a diagram showing an example of the management consignment contract master 106a in the present embodiment. FIG. 6 is a diagram showing an example of the contract master 106b in the present embodiment. FIG. 7 is a diagram showing an example of the contract rent renewal master 106c in the present embodiment. FIG. 8 is a diagram showing an example of the contract remittance renewal deduction master 106d in the present embodiment.

Here, as shown in FIG. 5, the management consignment contract master 106a in the present embodiment may have a management consignment contract number, a property code, a room number, and a landlord code set. Further, in FIG. 6, the contract master 106b in the present embodiment may have a contract number, a property code, a room number, and a contract expiration date set. Further, in FIG. 7, the contract rent renewal master 106c in the present embodiment may have a contract number, an item code, and a renewal fee amount (main unit amount) set. Further, in FIG. 8, the contract number, the item code, and the renewal fee amount (main unit amount) may be set in the contract remittance renewal deduction master 106d in the present embodiment.

Further, an example of the contract renewal data creation process in the present embodiment will be described with reference to FIGS. 9 to 11. FIG. 9 is a diagram showing an example of contract revision data in the present embodiment. FIG. 10 is a diagram showing an example of billing data at the time of contract revision in the present embodiment. FIG. 11 is a diagram showing an example of contract revision deduction breakdown data in the present embodiment.

In this embodiment, contract renewal data is collectively created. Here, as shown in FIGS. 9 to 11, contract renewal data whose contract expiration date is April 2018 may be created for the contract numbers “0001”, “0002”, and “0003”. (Note that the contract number "0004" is not applicable because the revision date is May 2018).

For example, as shown in FIG. 9, in the present embodiment, based on the management consignment contract master 106a shown in FIG. 5 and the contract master 106b shown in FIG. 6, the “remittance form” is set to “after payment” as the initial setting. Contract revision data may be created. Further, as shown in FIG. 10, the contract revision billing data may be created based on the contract master 106b shown in FIG. 6 and the contract rent renewal master 106c shown in FIG. 7. Further, as shown in FIG. 11, the contract revision deduction breakdown data may be created based on the contract master 106b shown in FIG. 6 and the contract remittance renewal deduction master 106d shown in FIG.

Further, with reference to FIG. 12, an example of the contract renewal input process in the present embodiment will be described. FIG. 12 is a diagram showing an example of contract revision data in the present embodiment.

In the present embodiment, when the user wants to make a change to the data shown in FIGS. 9 to 11 created by the contract renewal data creation process, the user inputs the changed content via the input device 112 to remit money. It is possible to change the form or amount.

For example, as shown in FIG. 12, in the present embodiment, the user changes the remittance form of the contract number “0001” of the contract revision data shown in FIG. 9 to “guarantee” via the input device 112, and the change thereof. You may update the contract revision data by entering "April 2018" in the remittance date data, which has become an indispensable item.

Further, with reference to FIG. 13, an example of the billing process in the present embodiment will be described. FIG. 13 is a diagram showing an example of the renewal fee collection schedule data in the present embodiment.

In this embodiment, the renewal fee billing data (renewal fee collection schedule data) to the borrower is created based on the contract revision billing data.

For example, as shown in FIG. 13, in the present embodiment, the contract numbers “0001”, “0002” and “0003” are based on the management consignment contract master 106a shown in FIG. 5 and the contract revision request data shown in FIG. You may create collection schedule data including renewal fee collection schedule number, contract number, applicable month data, management consignment contract number, billing business partner classification, item code, main unit amount and remittance number.

Further, an example of the deposit application input processing in the present embodiment will be described with reference to FIGS. 14 and 15. FIG. 14 is a diagram showing an example of payment application data in the present embodiment. FIG. 15 is a diagram showing an example of deposit journal data in the present embodiment.

In the present embodiment, when the renewal fee is paid, the payment is applied to the data to be collected.

For example, as shown in FIG. 14, in the present embodiment, when there is a payment from the borrower of the contract number “0002”, the payment application data related to the payment application for the collection schedule data of the contract number “0002” is created. You may. Further, as shown in FIG. 15, in the present embodiment, based on the deposit application data shown in FIG. 14, the deposit journal data of the renewal fee in which the debit account is cash and the credit account is deposit. May be created.

Further, an example of the remittance calculation process in the present embodiment will be described with reference to FIGS. 11 to 21. 16 and 18 are diagrams showing an example of payment data creation processing in the present embodiment. 17 and 19 are diagrams showing an example of the deduction data creation process in the present embodiment. FIG. 20 is a diagram showing an example of an output result in this embodiment. FIG. 21 is a diagram showing an example of remittance journal data in the present embodiment.

In the present embodiment, when the remittance date is specified as "2018/4" on the remittance calculation processing screen via the input device 112 by the user, the contract revision deduction breakdown data shown in FIG. 11 and the contract shown in FIG. The remittance calculation process is executed based on the revised data, the renewal fee collection schedule data shown in FIG. 13, and the deposit application data shown in FIG.

First, in the present embodiment, as a process for the contract revision data whose remittance form shown in FIG. 12 is “guarantee”, FIG. 13 targets the contract number “0001” whose remittance form of the contract revision data is “guarantee”. The payment amount of the renewal fee "¥ 100,000" is calculated from the details of the renewal fee collection schedule number "1" of the renewal fee collection schedule data shown in FIG. Calculate the deduction amount of the renewal fee "¥ 30,000" from the contract number "0001" of the contract revision deduction breakdown data and the details of the revision date "2018/4", and perform the fee collection scheduled work shown in Fig. 17. You may create it.

Then, in the present embodiment, as the processing for the contract revision data in which the remittance form shown in FIG. 12 is “after payment”, the contract numbers “0002” and “0003” in which the remittance form of the contract revision data is “after payment”. The contract number "0002" is renewed from the payment application data (payment application number "N1") shown in FIG. 14, which is associated with the collection schedule number "2" of the renewal fee collection schedule data shown in FIG. The payment amount of the fee "¥ 80,000" is calculated, the payment request work shown in FIG. 18 is created, the contract number "0002" of the contract revision deduction breakdown data shown in FIG. 11, and the revision date "2018/4". The deduction amount of the renewal fee “¥ 20,000” may be calculated from the details of the above, and the fee collection scheduled work shown in FIG. 19 may be created.

Then, as shown in FIG. 20, in the present embodiment, the remittance data, the payment request data, and the fee collection schedule data of the remittance date “2018/4” are created based on the work shown in FIGS. 16 to 19. You may.

Further, as shown in FIG. 21, in the present embodiment, based on the payment request data shown in FIG. 20, the remittance journal data of the renewal fee in which the debit account is the deposit and the credit account is the cash is used. You may also create remittance journal data for renewal fees with the debit account as cash and the credit account as fee income, based on the fee collection schedule data shown in FIG. In this embodiment, if the payment request data whose contract number "0001" is remittance form is "guarantee" is not paid by the accounting closing date, the journal data of "advance payment / deposit" is separately provided. May be created.

Further, an example of a monthly report according to the present embodiment will be described with reference to FIG. 22. FIG. 22 is a diagram showing an example of a monthly report in this embodiment.

As shown in FIG. 22, in the present embodiment, based on the remittance data, payment request data, and fee collection schedule data shown in FIG. 20, the rental property name, landlord name, borrower name, and remittance date data of the rental property, Create monthly report data including the renewal fee amount, renewal fee amount, and payment amount to the landlord after deducting the renewal fee amount from the renewal fee amount, and print out the monthly report data via the printer 114. You may let me.

Here, in the present embodiment, in the creation of the payment request data to the rental management company, the landlord code (payee code) of the landlord of the rental property stored in the contract revision file 106e is acquired, and the payee code is used. Although it is processed so that it is included in the payment request data, the landlord may change (the management consignment contract number changes) due to building sales etc. as a characteristic of the rental housing management industry, and at the timing of each processing, that Since it may be necessary to specify the currently valid management consignment contract each time, the property code and room number set in the contract master 106b are set to the management consignment contract master 106a having the same property code and room number. The management consignment contract number may be specified, and the landlord code set in the management consignment contract master 106a may be acquired from the management consignment contract.

[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 idea described in the claims.

For example, of each of the processes described in the embodiments, all or part of the processes described as being automatically performed may be manually performed, or all of the processes described as being performed manually. Alternatively, a part 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 rental contract renewal management 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 rental contract renewal management 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 the rental contract is renewed as necessary. It is read mechanically by the management 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 RAM, and constitutes a control unit in cooperation with a CPU.

Further, this computer program may be stored in the application program server connected to the rental contract renewal management device 100 via an arbitrary network, and all or a part thereof may be downloaded as needed. It is possible.

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 present 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 rental contract renewal management 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 any peripheral device is connected. Further, the rental contract renewal management device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

Furthermore, the specific form of distribution / integration of the device is not limited to that shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional loads. 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 useful in industries such as the real estate management industry that manages rental contracts for rental housing and the like.

100 Rental contract renewal management device 102 Control unit 102a Contract revision creation department 102b Contract revision billing creation department 102c Renewal fee collection schedule creation department 102d Contract revision deduction breakdown creation department 102e Deposit application creation department 102f Guarantee payment request Preparation Department 102h Payment Request Creation Department after Payment 102i Remittance Journal Creation Department 102j Monthly Report Creation Department 104 Communication Interface Department 106 Storage Department 106a Management Consignment Contract Master 106b Contract Master 106c Contract Rent Renewal Master 106d Contract Remittance Renewal Deduction Master 106e Contract Revision file 106f Renewal fee collection schedule file 106g Contract revision deduction breakdown file 106h Deposit application file 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (12)

It is a rental contract renewal management device equipped with a storage unit and a control unit.
The storage unit is
As a contract revision storage means for storing contract revision data including the lessee identifier of the lessee of the rental property, the revision date data of the rental contract, the landlord identifier of the landlord of the rental property, and the remittance form data of the renewal fee to the landlord. ,
A renewal fee collection schedule storage means for storing the renewal fee collection schedule data including the borrower identifier, the collection schedule data to the borrower, and the renewal fee collection schedule data including the renewal fee renewal charge amount.
A contract revision deduction breakdown storage means for storing the contract revision deduction breakdown data including the borrower identifier, the revision date data, and the contract revision deduction breakdown data including the renewal fee amount of the renewal fee to the rental management company.
A payment application storage means for storing payment application data related to payment application for the renewal fee collection schedule data, and a payment application storage means.
Equipped with
The control unit
If the remittance form is guaranteed remittance based on the contract revision data, the payment request data to the rental management company, including the renewal fee amount, based on the renewal fee collection schedule data and the contract revision deduction breakdown data. And, a guarantee payment request creation means for creating fee collection schedule data for the landlord, including the renewal fee amount, and
Based on the contract revision data and the payment application data, if the remittance form is post-payment remittance and there is the renewal fee for which the payment has been applied, the renewal fee collection schedule data and the contract revision deduction breakdown. A post-payment payment request creation means for creating the payment request data to the rental management company including the renewal fee amount and the fee collection schedule data to the landlord including the renewal fee amount based on the data.
A rental contract renewal management device characterized by being equipped with. The control unit
A remittance journal creation means for creating remittance journal data for the renewal fee and the renewal fee based on the payment request data and the fee collection schedule data.
The rental contract renewal management device according to claim 1, further comprising. The remittance journal creation means is
Based on the payment request data, the remittance journal data of the renewal fee with the debit account as the deposit is created, and the credit account is the fee income based on the fee collection schedule data. The rental contract renewal management device according to claim 2, wherein the remittance journal data of the renewal fee is created. The guarantee payment request creation means and the post-payment payment request creation means are
The rental contract renewal management device according to any one of claims 1 to 3, further comprising creating remittance data including the remittance date data of the renewal fee. The storage unit is
A management consignment contract identifier for storing a management consignment contract identifier between the landlord and the rental management company, a rental property identifier for the rental property, and a management consignment contract storage means for storing the management consignment contract master in which the landlord identifier is set.
A contract storage means for storing the borrower identifier, the rental property identifier, and the contract master for which the contract expiration date is set.
Further prepare
The control unit
A contract revision creation means for creating the contract revision data based on the management consignment contract master and the contract master.
The rental contract renewal management device according to any one of claims 1 to 4, further comprising. The storage unit is
A management consignment contract identifier for storing a management consignment contract identifier between the landlord and the rental management company, a rental property identifier for the rental property, and a management consignment contract storage means for storing the management consignment contract master in which the landlord identifier is set.
A contract storage means for storing the borrower identifier, the rental property identifier, and the contract master for which the contract expiration date is set.
A contract rent renewal storage means for storing the borrower identifier and the contract rent renewal master for which the renewal charge amount is set, and
Further prepare
The control unit
A contract revision billing means for creating contract revision billing data including the borrower identifier, the scheduled collection date data, and the contract revision charge amount based on the contract master and the contract rent renewal master.
Based on the management consignment contract master and the contract revision billing data, the renewal fee collection schedule data including the borrower identifier, the collection scheduled date data, the management consignment contract identifier, and the renewal fee amount is created. Renewal fee collection schedule creation method and
The rental contract renewal management device according to any one of claims 1 to 4, further comprising. The storage unit is
A contract storage means for storing the borrower identifier, the rental property identifier of the rental property, and the contract master for which the contract expiration date is set.
A contract rent renewal storage means for storing the borrower identifier and the contract remittance renewal deduction master for which the renewal fee amount is set.
Further prepare
The control unit
A contract revision deduction breakdown creation means for creating the contract revision deduction breakdown data based on the contract master and the contract remittance renewal deduction master.
The rental contract renewal management device according to any one of claims 1 to 4, further comprising. The control unit
When the renewal fee is paid by the lessee to the rental management company, the payment application for creating the payment application data regarding the payment application to the renewal fee collection schedule data including the renewal fee amount of the renewal fee is created. Creation method,
The rental contract renewal management device according to any one of claims 1 to 7, further comprising. The control unit
A deposit journal creation means that creates deposit journal data for the renewal fee based on the deposit application data.
The rental contract renewal management device according to any one of claims 1 to 8, further comprising. The control unit
Based on the remittance data, the payment request data, and the fee collection schedule data, the borrower identifier, the remittance date data, the renewal fee amount, the renewal fee amount, and the renewal fee amount are calculated from the renewal fee amount. Monthly report creation means for creating monthly report data including the deducted payment amount to the landlord,
The rental contract renewal management device according to claim 4, further comprising. It is a rental contract renewal management method for executing a rental contract renewal management device having a storage unit and a control unit.
The storage unit is
As a contract revision storage means for storing contract revision data including the lessee identifier of the lessee of the rental property, the revision date data of the rental contract, the landlord identifier of the landlord of the rental property, and the remittance form data of the renewal fee to the landlord. ,
A renewal fee collection schedule storage means for storing the renewal fee collection schedule data including the borrower identifier, the collection schedule data to the borrower, and the renewal fee collection schedule data including the renewal fee renewal charge amount.
A contract revision deduction breakdown storage means for storing the contract revision deduction breakdown data including the borrower identifier, the revision date data, and the contract revision deduction breakdown data including the renewal fee amount of the renewal fee to the rental management company.
A payment application storage means for storing payment application data related to payment application for the renewal fee collection schedule data, and a payment application storage means.
Equipped with
It is executed by the control unit.
If the remittance form is guaranteed remittance based on the contract revision data, the payment request data to the rental management company, including the renewal fee amount, based on the renewal fee collection schedule data and the contract revision deduction breakdown data. And the guarantee payment request creation step to create the fee collection schedule data for the landlord, including the renewal fee amount, and
Based on the contract revision data and the payment application data, if the remittance form is post-payment remittance and there is the renewal fee for which the payment has been applied, the renewal fee collection schedule data and the contract revision deduction breakdown. A post-payment payment request creation step that creates the payment request data to the rental management company including the renewal fee amount and the fee collection schedule data to the landlord including the renewal fee amount based on the data.
A rental contract renewal management method characterized by including. It is a rental contract renewal management program to be executed by a rental contract renewal management device equipped with a storage unit and a control unit.
The storage unit is
As a contract revision storage means for storing contract revision data including the lessee identifier of the lessee of the rental property, the revision date data of the rental contract, the landlord identifier of the landlord of the rental property, and the remittance form data of the renewal fee to the landlord. ,
A renewal fee collection schedule storage means for storing the renewal fee collection schedule data including the borrower identifier, the collection schedule data to the borrower, and the renewal fee collection schedule data including the renewal fee renewal charge amount.
A contract revision deduction breakdown storage means for storing the contract revision deduction breakdown data including the borrower identifier, the revision date data, and the contract revision deduction breakdown data including the renewal fee amount of the renewal fee to the rental management company.
A payment application storage means for storing payment application data related to payment application for the renewal fee collection schedule data, and a payment application storage means.
Equipped with
In the control unit
If the remittance form is guaranteed remittance based on the contract revision data, the payment request data to the rental management company, including the renewal fee amount, based on the renewal fee collection schedule data and the contract revision deduction breakdown data. And the guarantee payment request creation step to create the fee collection schedule data for the landlord, including the renewal fee amount, and
Based on the contract revision data and the payment application data, if the remittance form is post-payment remittance and there is the renewal fee for which the payment has been applied, the renewal fee collection schedule data and the contract revision deduction breakdown. A post-payment payment request creation step that creates the payment request data to the rental management company including the renewal fee amount and the fee collection schedule data to the landlord including the renewal fee amount based on the data.
Rental contract renewal management program to execute.

Images