Rent guarantee management system, rent guarantee management method, and rent guarantee management program

Abstract

To provide a rent guarantee management system capable of improving the efficiency of settlement operations when cancellation or termination of a rent guarantee contract occurs while preventing clerical error, a rent guarantee management method, and a rent guarantee management program.SOLUTION: A rent guarantee management system in an embodiment includes termination processing means that is configured so as to, when a rent guarantee contract is canceled or terminated, create termination data including guarantee number, customer name, termination category specifying cancellation or termination of rent guarantee contract, termination date, and management company, and when the settlement completion flag of the settlement details data of the guarantee number and the settlement data linked by the settlement number is "Complete", automatically create a reverse settlement record in the settlement details data, and when "Incomplete", automatically create a red slip record.SELECTED DRAWING: Figure 2

Description

[Technical Field]

[0001] The present invention relates to a rent guarantee management system, a rent guarantee management method, and a rent guarantee management program. [Background technology]

[0002] For example, rent guarantee companies do not enter into lease agreements directly with tenants, but rather a management company (agency) introduces the rent guarantee company to the tenant and enters into a guarantee agreement with the management company, which then entrusts the rent guarantee business to the management company. As a result, the rent guarantee company must bill the management company for the guarantee commission fee collected from the tenant and pay the commission fee. Conventional rent guarantee systems include, for example, Patent Document 1. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Publication No. 2020-52848 Summary of the Invention [Problem to be solved by the invention]

[0004] However, Patent Document 1 does not state anything about improving the efficiency of settlement procedures or preventing administrative errors when a rent guarantee contract is canceled or terminated.

[0005] The present invention has been made in consideration of the above, and aims to provide a rent guarantee management system, a rent guarantee management method, and a rent guarantee management program that can improve the efficiency of settlement operations and prevent clerical errors when a rent guarantee contract is canceled or terminated. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention is characterized in that the control unit is configured to be able to access a memory area in which settlement data having settlement header data including items such as settlement year and month, management company, billing or payment billing payment category, settlement amount, settlement number, settlement completion flag indicating whether the settlement is complete or not, billing number, and payment number, and settlement detail data including items such as settlement number, management company, guarantee number, customer name, billing or payment billing payment category, expense item, and settlement amount is stored, and in the event of cancellation or termination of a rent guarantee contract, cancellation data is created including the guarantee number, customer name, cancellation category specifying the cancellation or termination of the rent guarantee contract, cancellation date, and management company, and if the settlement completion flag of the settlement detail data for the guarantee number and the settlement data linked by the settlement number is ``completed,'' a reverse settlement record is automatically created in the settlement detail data, while if it is ``incomplete,'' a red slip record is automatically created.

[0007] According to another aspect of the present invention, the expenses may include a guarantee fee or a commission fee.

[0008] In addition, according to one aspect of the present invention, the control unit may be provided with a settlement data creation processing means that creates settlement data and stores it in the memory area, and at that time sets the settlement completion flag of the settlement header data to "incomplete", the invoice number to "-", and the payment number to "-", and a settlement confirmation processing means that, when finalizing the settlement of the target settlement data stored in the memory area, sets the settlement completion flag of the settlement header data to "completed", and if the invoice payment category is "invoice", sets the invoice number, and if the invoice payment category is "payment", sets the payment number.

[0009] In addition, according to one aspect of the present invention, the settlement confirmation processing means may create collection schedule data including items such as billing number, billing year and month, billing recipient, guarantee number, expense item, billing amount, and sales recording date based on the settlement data for which settlement has been confirmed, when the billing payment category of the settlement header data is ``billing.''

[0010] In addition, according to one aspect of the present invention, the settlement confirmation processing means may create payment schedule data including items such as payment number, payment date, payee, guarantee number, payment amount, and payment accounting date based on the settlement data for which settlement has been confirmed, when the billing payment category of the settlement header data is "payment."

[0011] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention may be configured so that the control unit is provided with a journal data creation means for creating journal data based on settlement data for which settlement has been confirmed.

[0012] In order to solve the above-mentioned problems and achieve the object, the present invention provides a rent guarantee management method executed by an information processing device having a control unit, wherein the control unit accesses a memory area in which settlement data having settlement header data including items of settlement year and month, management company, billing or payment billing payment classification, settlement amount, settlement number, settlement completion flag indicating whether settlement is complete or not, billing number, and payment number, and settlement detail data including items of settlement number, management company, guarantee number, customer name, billing or payment billing payment classification, expense item, and settlement amount is stored. The control unit is configured to be able to process the rent guarantee contract, and when the rent guarantee contract is cancelled or terminated, the control unit creates cancellation data including the guarantee number, customer name, cancellation category specifying the cancellation or termination of the rent guarantee contract, cancellation date, and management company, and if the settlement completion flag of the settlement data linked to the settlement number and the settlement detail data of the guarantee number is "completed," a reverse settlement record is automatically created in the settlement detail data, but if it is "incomplete," a red slip record is automatically created.

[0013] In order to solve the above-mentioned problems and achieve the object, the present invention provides a rent guarantee management program to be executed by an information processing device having a control unit, wherein the control unit is configured to be able to access a storage area in which settlement data having settlement header data including items such as settlement year and month, management company, billing or payment classification, settlement amount, settlement number, settlement completion flag indicating whether the settlement is complete or not, billing number, and payment number, and settlement detail data including items such as settlement number, management company, guarantee number, customer name, billing or payment classification, expense item, and settlement amount is stored. The rent guarantee management program is characterized by being a program executed by the control unit, and which, when a rent guarantee contract is cancelled or terminated, creates cancellation data including the guarantee number, customer name, cancellation category specifying the cancellation or termination of the rent guarantee contract, cancellation date, and management company, and if the settlement completion flag of the settlement data linked to the settlement number and the settlement detail data of said guarantee number is "completed," automatically creates a reverse settlement record in said settlement detail data, while if it is "incomplete," automatically creates a red slip record. [Effects of the Invention]

[0014] According to the present invention, it is possible to improve the efficiency of settlement operations and prevent clerical errors when a rent guarantee contract is canceled or terminated. [Brief explanation of the drawings]

[0015] [Figure 1A] FIG. 1A is a flow diagram showing an example of a rent guarantee settlement process. [Figure 1B] FIG. 1B is a flow diagram showing an example of a rent guarantee settlement process. [Figure 1C] FIG. 1C is a flow diagram showing an example of a rent guarantee settlement process. [Figure 1D] FIG. 1D is a flow diagram showing an example of a rent guarantee settlement process. [Figure 1E] FIG. 1E is a flow diagram showing an example of a rent guarantee settlement process. [Figure 2]FIG. 2 is a block diagram showing an example of the configuration of the rent guarantee management system according to this embodiment. [Figure 3A] FIG. 3A is a diagram for explaining a specific example of the processing of the control unit of the rent guarantee management system of this embodiment. [Figure 3B] FIG. 3B is a diagram for explaining a specific example of the processing of the control unit of the rent guarantee management system of this embodiment. [Figure 3C] FIG. 3C is a diagram for explaining a specific example of the processing of the control unit of the rent guarantee management system of this embodiment. [Figure 3D] FIG. 3D is a diagram for explaining a specific example of the processing of the control unit of the rent guarantee management system of this embodiment. [Figure 3E] FIG. 3E is a diagram for explaining a specific example of the processing of the control unit of the rent guarantee management system of this embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0016] Hereinafter, embodiments of a rent guarantee management system, a rent guarantee management method, and a rent guarantee management program according to the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to these embodiments.

[0017] [1. Overview] In the rent guarantee industry, guarantee fees are the basis of sales, and while many guarantee contracts are handled, the process of settling guarantee fees with management companies varies depending on the date of cancellation or termination and the settlement status when a rent guarantee contract (hereinafter simply referred to as "contract") is cancelled or terminated before or after settlement, and the refund and billing methods for guarantee fees and commission fees vary depending on the date of cancellation or termination and the settlement status, so it is necessary to thoroughly check the contract status, transaction, and settlement status in business operations before carrying out the procedures.

[0018] The reverse settlement process for the termination or cancellation of individual contracts is cumbersome for any rent guarantee company, and in addition to the business processing, it is also necessary to verify invoices and payment slips and record journal entries for sales cancellations and cost reductions. This places a heavy workload on the staff and leads to clerical errors.

[0019] Therefore, in this embodiment, the billing process and payment process (refund process) in the settlement work for the management company when a contract is canceled or terminated are systemized. Specifically, when a contract is canceled or terminated, reverse settlement data for the management company is automatically created according to the settlement status, thereby realizing efficient accounting of billing and payment in the settlement work and preventing clerical errors caused by manual work. Furthermore, in this embodiment, journal vouchers for canceling sales and returning costs are automatically created according to the reverse settlement process.

[0020] 1A to 1E are flow diagrams showing an example of the settlement process for rent guarantee. An example of the settlement process for rent guarantee will be described with reference to FIGS. 1A to 1E.

[0021] (T1) For example, the guarantee fee and business outsourcing fee to the management company are settled in the settlement date "2022 / 4", and settlement data (settlement header data, settlement detail data) such as that shown in Figure 1A is created.

[0022] (T2) In the settlement date "2022 / 4", execute the settlement confirmation process to confirm the settlement of the guarantee fee and business commission fee to the management company, and finalize the settlement data and create collection schedule data as shown in Figure 1A.

[0023] (T3) Based on the finalized settlement data for April 2022, journal entry data as shown in Figure 1B is created.

[0024] (T4) In the settlement date "2022 / 5", a new settlement is made for the guarantee fee and business outsourcing fee to the management company, and settlement data such as that shown in Figure 1B is created.

[0025] (T5) Since cancellation of warranty number "0000000001" and termination of warranty number "0000000002" have occurred, cancellation data such as that shown in FIG. 1C is created.

[0026] (T6) The operator manually inputs the settlement corrections. The settlement for April is confirmed, and as May has not yet been settled, details of the reverse settlement for the cancelled amount are entered, and the accumulated detail data is corrected as shown in Figure 1C. The operator checks the settlement status of the settlement data for each guarantee number and makes corrections. For settlement number "0001" for guarantee number "0000000001", the operator enters a reverse settlement record in which "billing" and "payment" are reversed in the settlement claim payment category of the settlement detail data, as settlement has already been made. For settlement number "0003" for guarantee number "0000000002", the settlement has not yet been completed, so a red slip record is entered.

[0027] In this way, when a contract is canceled or terminated, the operator must check the settlement status of the guarantee number and manually correct the settlement data, which places a heavy workload on the operator and can lead to clerical errors.

[0028] As will be described later, this invention automatically determines the settlement status when a contract is cancelled or terminated, and automatically creates reverse settlement data for the management company based on the settlement status, thereby improving the efficiency of billing and payment accounting in settlement operations and preventing clerical errors caused by manual work.

[0029] (T7) Recalculate the guarantee fee and business outsourcing fee to the management company for the settlement date "2022 / 5" and update the settlement data as shown in Figure 1D.

[0030] (T8) In the settlement date "2022 / 5", execute the settlement confirmation process to confirm the settlement of the guarantee commission fee and the business commission fee to the management company, and confirm the settlement data as shown in Figure 1D. Also, based on the confirmed settlement data, create payment request data as shown in Figure 1D.

[0031] (T9) Based on the finalized settlement data for May 2022, create journal entry data as shown in Figure 1E (create a reversal journal entry for the settlement for April 2022).

[0032] The rent guarantee management system of the present invention is widely applicable to corporations and industries that operate rent debt guarantee businesses.

[0033] [2. Configuration] The configuration of rent guarantee management system 100 according to this embodiment will be described with reference to Fig. 2. Fig. 2 is a block diagram showing an example of the configuration of rent guarantee management system 100 according to this embodiment. Rent guarantee management system 100 according to this embodiment can be suitably used, for example, in rent guarantee companies and the like.

[0034] The rent guarantee management system 100 is a workstation, a commercially available desktop personal computer, etc. The rent guarantee management system 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

[0035] As shown in Figure 2, the rent guarantee management system 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. Each unit of the rent guarantee management system 100 is connected to each other so that they can communicate with each other via any communication path.

[0036] The communication interface unit 104 communicatively connects the rent guarantee management system 100 to the network 300 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 the function of communicating data with other devices via a communication line. Here, the network 300 has the function of connecting the rent guarantee management system 100 and the server 200 etc. so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The data stored in the memory unit 106, which will be described later, may also be stored on the server.

[0037] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to achieve a pointing device function. Note that, hereinafter, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112. Furthermore, displaying on the screen of the output device (monitor) 114 by a user and operating the input device 112 may be referred to as a "user operation via a UI."

[0038] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 stores computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes. The storage unit 106 may be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 also includes a data table 106a, etc.

[0039] The data table 106a is a table for storing various data such as settlement data, cancellation data, collection schedule data, payment request data, and journal data.

[0040] The settlement data may be composed of settlement header data and settlement detail data. The settlement header data may include the following items: settlement year and month, management company, billing or payment classification (e.g., "0: billing" or "1: payment") specifying billing or payment, settlement amount, settlement number, settlement completion FLG (flag) indicating whether the settlement has been completed, billing number, and payment number. The settlement completion FLG is, for example, "0: unconfirmed (incomplete)" or "1: confirmed (completed)."

[0041] The settlement details data may include the following items: settlement number, management company, guarantee number, customer name, billing payment category, expense item, and settlement amount. Expense items include, for example, outsourcing fees and business guarantee fees. Outsourcing fees are fees paid by rent guarantee companies when outsourcing work to management companies. Business guarantee fees are fees that management companies charge to management companies for the rent guarantee fees they collect from customers.

[0042] The settlement header data and settlement detail data are linked by the settlement number. The settlement of the settlement header data is the aggregation of the settlement detail data by settlement number, and if the balance is positive, the billing payment category is "billing", and if it is negative, it is "payment", and the settlement amount is the difference between the billing amount and the payment amount.

[0043] The cancellation data may include the following items: guarantee number, customer name, cancellation category, cancellation date, and management company. Cancellation categories are, for example, "0: Cancel" and "1: Cancel." "Cancel" refers to the cancellation of the rent guarantee contract before the guarantee start time. "Cancel" refers to the cancellation of the contract after the guarantee start time has passed.

[0044] The collection schedule data may include the following items: billing number, billing year and month, billing recipient, warranty number, expense item, billing amount, and sales posting date. The collection schedule data is created when the billing payment category in the settlement header data is "billing."

[0045] The payment request data may include the following items: payment number, payment date, payee, guarantee number, payment amount, and payment accounting date. The collection schedule data is created when the billing payment category in the settlement header data is "payment."

[0046] The control unit 102 is a CPU or the like that performs overall control of the rent guarantee management system 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs.

[0047] The control unit 102 is configured to be able to access the data table (storage area) 106a stored in the storage unit 106. The data table 106a may be provided in another location (for example, the server 200) as long as it is accessible by the control unit 102.

[0048] The control unit 102 conceptually includes a settlement data creation unit 102a, a settlement confirmation processing unit 102b, a cancellation processing unit 102c, a journal data creation unit 102d, and a screen display control unit 102e.

[0049] The settlement data creation unit 102a executes the settlement data creation process. Specifically, in the settlement data creation process, the settlement data creation unit 102a creates settlement data (settlement header data, settlement detail data) in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, and stores the data in the data table 106a. At that time, the settlement completion FLG of the settlement header data is set to "0: Unconfirmed", the billing number is "-", and the payment number is "-".

[0050] Furthermore, the settlement data creation unit 102a executes a settlement data creation process (recalculation process). Specifically, in the settlement data creation process (recalculation process), as described below, when a rent guarantee contract is terminated or canceled and a reverse settlement record or a red slip record is created in the settlement detail data of the settlement data, the settlement data creation unit 102a recalculates the settlement header data of the settlement data, sets the total amount of income and expenditure of the settlement amount in the settlement detail data as the ``settlement amount,'' resets the ``billing payment category'' according to the positive / negative balance, and sets a new ``settlement number.''

[0051] The settlement confirmation processing unit 102b executes the settlement confirmation processing. Specifically, in the settlement confirmation processing, when the settlement of the target settlement data stored in the data table 106a is confirmed, the settlement confirmation processing unit 102b sets the settlement completion FLG of the settlement header data to "1: confirmed", and if the billing payment classification is "0: billing", it assigns (sets) a billing number, and if the billing payment classification is "1: payment", it assigns (sets) a payment number.

[0052] In addition, based on the confirmed settlement data, if the billing payment category of the settlement header data is "billing", the settlement confirmation processing unit 102b creates collection schedule data including the items of billing number, billing year and month, billing destination, guarantee number, expense item, billing amount, and sales recording date, and stores the data in the data table 106a.

[0053] In addition, based on the confirmed settlement data, if the billing payment category of the settlement header data is "payment", the settlement confirmation processing unit 102b creates payment request data including the items of payment number, payment date, payee, guarantee number, payment amount, and payment accounting date, and stores the data in the data table 106a.

[0054] The cancellation processing unit 102c executes cancellation input processing. Specifically, in the cancellation input processing, when a rent guarantee contract is canceled or terminated, the cancellation processing unit 102c creates cancellation data including the guarantee number, customer name, cancellation category specifying the cancellation or termination of the contract, cancellation date, and management company in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, and stores the created data in the data table 106a. Furthermore, by referencing the settlement completion flag in the settlement header data linked by the settlement number to the settlement detail data of the guarantee number of the cancellation data, if the settlement completion flag is "1: confirmed," a reverse settlement record is automatically created in the settlement detail data, whereas if the settlement completion flag is "0: unconfirmed," a red slip record is automatically created in the settlement detail data.

[0055] The journal data creating unit 102d executes a journal data creating process. Specifically, in the journal data creating process, the journal data creating unit 102d creates journal data based on the finalized settlement data and stores the data in the data table 106a.

[0056] The screen display control unit 102e controls the display of various input screens displayed on the monitor 114 and the reception of inputs thereto.

[0057] [3. Specific examples of processing] A specific example of the processing performed by the control unit 102 of the rent guarantee management system 100 in this embodiment will be described with reference to Figures 2 to 3E. Figures 3A to 3E are diagrams showing a processing flow (sample data) for explaining a specific example of the processing performed by the control unit 102 of the rent guarantee management system 100 in this embodiment. The processing flow of the specific example shown below is an example, and the present invention is not limited to this, and the rent guarantee contract can also be canceled or terminated at other times.

[0058] (S1: Settlement data creation process) For example, the guarantee fee and business outsourcing fee are settled with the management company in the settlement date "2022 / 4", and settlement data such as that shown in Figures 3A(A) and (B) is created. The settlement data creation unit 102a creates settlement data (settlement header data, settlement detail data) in accordance with, for example, operator operations on an input screen (not shown) displayed on the monitor 114, and stores the data in the data table 106a. At this time, the settlement completion FLG of the settlement header data is set to "0: Unconfirmed", the invoice number is set to "-", and the payment number is set to "-".

[0059] Figure 3A (A) shows an example of the settlement header data to be created. The settlement header data includes the following fields: settlement date, management company, billing payment category, settlement amount, settlement number, settlement completion flag, billing number, and payment number. In the example shown in the figure, the settlement date is "2022 / 4," the management company is "Management Company A," the billing payment category is "0: Billing," the settlement amount is "70,000 yen," the settlement number is "00001," the settlement completion flag is "0: Unconfirmed," the billing number is "-," and the payment number is "-."

[0060] Figure 3A(B) shows an example of detailed settlement data. The detailed settlement data includes the following fields: settlement number, management company, guarantee number, customer name, billing payment category, expense item, and settlement amount. In the example shown in the figure, the first line contains the settlement number "00001," the management company "Management Company A," the guarantee number "0000000001," the customer name "Tanaka Takao," the billing payment category "0: Billing," the expense item "Initial warranty commission fee," and the settlement amount "¥100,000." The second line contains the settlement number "00001," the management company "Management Company A," the guarantee number "0000000001," the customer name "Tanaka Takao," the billing payment category "1: Payment," the expense item "Outsourcing fee," and the settlement amount "¥30,000."

[0061] (S2: Settlement confirmation process) The settlement of the guarantee commission fee and outsourcing fee is confirmed to the management company for the settlement date "2022 / 4", and the settlement data is confirmed as shown in Figures 3A (C) and (D). When the settlement confirmation processing unit 102b confirms the settlement of the target settlement data, it sets the settlement completion FLG of the settlement header data to "1: Confirmed", and if the billing payment category is "0: Billing", it assigns (sets) a billing number, and if the billing payment category is "1: Payment", it assigns (sets) a payment number.

[0062] Specifically, as shown in Figure 3A (C), the settlement completion FLG in the settlement header data is updated to "1: Confirmed", and since the billing payment category is "0: Billing", a new billing number "10001" is set.

[0063] The settlement confirmation processing unit 102b creates collection schedule data based on the confirmed settlement data when the bill payment category of the settlement header data is "billing" and registers it in the data table 106a.

[0064] Figure 3A (E) shows an example of the collection schedule data that will be created. The collection schedule data includes the following fields: invoice number, invoice date, invoice recipient, warranty number, expense item, invoice amount, and sales posting date. In the example shown in the figure, the invoice number is "10001," the invoice date is "2022 / 4," the invoice recipient is "Management Company A," the warranty number is "-," the expense item is "guarantee commission fee," the invoice amount is "70,000 yen," and the sales posting date is "2022 / 4 / 30."

[0065] (S3: Journal data creation process) Based on the settlement data finalized in April 2022, the journal data creation unit 102d creates journal data as shown in Fig. 3B(A) based on the finalized settlement data and stores the journal data in the data table 106a.

[0066] 3B(A) is a diagram showing an example of the journal entry data to be created. In the example shown in the figure, the debit is accounts receivable: ¥100,000, the credit is sales (guarantee commission): ¥100,000, the debit is cost / contract commission: ¥30,000, and the credit is accounts payable: ¥30,000.

[0067] (S4: Settlement data creation process) For example, a new settlement of the guarantee fee and business outsourcing fee to the management company is made in the settlement date "2022 / 5", and settlement data such as those shown in Figures 3B(B) and (C) is created.

[0068] 3B(B) shows an example of the settlement header data to be created. In the example shown in the figure, the settlement date is "2022 / 5", the management company is "Management Company A", the billing payment category is "0: Billing", the settlement amount is "7,000 yen", the settlement number is "00002", the settlement completion flag is "0: Unconfirmed", the billing number is "-", and the payment number is "-".

[0069] 3B(C) shows an example of the settlement statement data to be created. In the example shown in the figure, the first line contains the settlement number "00002," management company "Management Company A," guarantee number "0000000002," customer name "Sato Ichiro," billing payment category "0: Billing," expense item "Renewal Guarantee Commission Fee," and settlement amount "¥10,000." The second line contains the settlement number "00002," management company "Management Company A," guarantee number "0000000002," customer name "Sato Ichiro," billing payment category "1: Payment," expense item "Outsourcing Fee," and settlement amount "¥3,000."

[0070] (S5: Cancellation input processing) Since the cancellation of guarantee number "0000000001" and the termination of guarantee number "0000000002" have occurred, the termination data shown in Figure 3C(A) is created. When a rent guarantee contract is cancelled or terminated, the termination processing unit 102c creates termination data including the guarantee number, customer name, termination category specifying the cancellation or termination of the contract, termination date, and management company in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, and stores this data in the data table 106a.

[0071] FIG. 3C(A) is a diagram showing an example of cancellation data. The cancellation data includes the following fields: warranty number, customer name, cancellation category, cancellation date, and management company. In the example shown in the figure, the first line contains the warranty number "0000000001," customer name "Tanakatarou," cancellation category "0: Cancellation," cancellation date "2022 / 05 / 31," and management company "Management Company A." The second line contains the warranty number "0000000002," customer name "Satouichirou," cancellation category "1: Cancellation," cancellation date "2022 / 05 / 31," and management company "Management Company A."

[0072] In addition, the cancellation processing unit 102c refers to the settlement completion FLG of the settlement header data linked by the settlement number and the settlement detail data of the guarantee number of the cancellation data, and if the settlement completion FLG is "1: confirmed", it automatically creates a reverse settlement record in the settlement detail data, while if the settlement completion FLG is "0: unconfirmed", it automatically creates a red slip record in the settlement detail data.

[0073] Figure 3C(B) is a diagram showing an example of the settlement detail data to be updated. For the guarantee number "0000000001", the settlement completion flag of the associated settlement header data (settlement number "00001") is "1: Confirmed", so a reverse settlement record is created by reversing the "invoice" and "payment" in the settlement claim payment category of the settlement detail data. Specifically, on the third line, add a record with the following: management company "Management Company A", warranty number "0000000001", customer name "Tanakatarou", billing payment category "1: Payment", expense item "Initial warranty commission fee", and settlement amount "¥100,000". On the fourth line, add a record with the following: settlement number "00001", management company "Management Company A", warranty number "0000000001", customer name "Tanakatarou", billing payment category "0: Billing", expense item "Outsourcing fee", and settlement amount "¥30,000".

[0074] For warranty number "0000000002," the settlement completion flag in the associated settlement header data (settlement number "00002") is "0: Unconfirmed," so a red slip record is added to the billing detail data. Specifically, on line 5, a record is added for management company "Management Company A," warranty number "0000000002," customer name "Sato Ichiro," billing payment category "0: Billing," expense item "Renewal warranty commission fee," and settlement amount "¥-10,000," and on line 6, a record is added for management company "Management Company A," warranty number "0000000002," customer name "Sato Ichiro," billing payment category "1: Payment," expense item "Outsourcing fee," and settlement amount "¥-3,000."

[0075] (S6: Create settlement data (recalculation process)) The guarantee fee and outsourcing fee to the management company are recalculated for the settlement date "2022 / 5", and the settlement data is updated as shown in Figures 3D(A) and (B). When the rent guarantee contract is terminated or canceled and a reverse settlement record or a red slip record is created in the settlement detail data of the settlement data, the settlement data creation unit 102a recalculates the settlement header data of the settlement data, sets the total amount of the settlement amount in the settlement detail data as the "settlement amount", resets the "billing payment category" according to whether the balance is positive or negative, and sets a new "settlement number".

[0076] Figure 3D(A) shows an example of the recalculated settlement header data. As shown in the figure, the billing payment category of the settlement header data is set to "1: Payment", the settlement amount is set to "70,000 yen", and the settlement number is set to "00003".

[0077] Figure 3D(B) shows an example of the recalculated settlement header data. As shown in the figure, the settlement date "2022 / 5" and settlement number "00003" are added to lines 3 to 6 of the settlement detail data.

[0078] (S7: Settlement confirmation process) The settlement of the guarantee fee and outsourcing fee is confirmed to the management company for the settlement date "2022 / 5", and the settlement data is confirmed as shown in Figures 3E(A) and (B).

[0079] Specifically, as shown in Figure 3E(A), the settlement completion FLG in the settlement header data is updated to "1: Confirmed", and since the billing payment category is "1: Payment", a new payment number "20001" is set.

[0080] Furthermore, the settlement determination processing unit 102b creates payment request data based on the determined settlement data when the bill payment category of the settlement header data is "payment" and stores the data in the data table 106a.

[0081] Figure 3E (C) is a diagram showing an example of payment request data. The payment request data includes the following fields: payment number, payment date, payee, guarantee number, payment amount, and payment accounting date. In the example shown in the figure, the payment number is "20001," the payment date is "2022 / 5 / 31," the payee is "Management Company A," the payment amount is "70,000 yen," and the payment accounting date is "2022 / 5 / 31."

[0082] (S8: Journal data creation process) Based on the finalized settlement for May 2022, create the journal entry data shown in Figure 3E(D) (create a reversal journal entry for the settlement for April 2022).

[0083] Figure 3E(D) shows an example of the journal entry data to be created. In the example shown in the figure, the debit is sales (guarantee commission): ¥100,000 / credit is accounts receivable: ¥100,000, the debit is accounts payable: ¥30,000 / credit is cost price / contract commission: ¥30,000.

[0084] As explained above, according to this embodiment, when a rent guarantee contract is cancelled or terminated, cancellation data is created that includes the guarantee number, customer name, cancellation category specifying the cancellation or termination of the rent guarantee contract, cancellation date, and management company, and if the settlement completion flag of the settlement detail data for that guarantee number and the settlement data linked by the settlement number is "completed," a reverse settlement record is automatically created in that settlement detail data, but if it is "incomplete," a red slip record is automatically created, making it possible to improve the efficiency of settlement operations and prevent clerical errors when a rent guarantee contract is cancelled or terminated.

[0085] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of SDGs Goals 8 and 9.

[0086] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0087] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.

[0088] 5. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0089] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0090] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed as desired unless otherwise specified.

[0091] Furthermore, with regard to the rent guarantee management system 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0092] For example, all or any part of the processing functions of the rent guarantee management system 100, particularly the processing functions performed by the control unit 102, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing an information processing device to execute the processes described in this embodiment, and is mechanically read by the rent guarantee management system 100 as needed. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to issue instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works in cooperation with the CPU to form the control unit.

[0093] In addition, this computer program may be stored in an application program server connected to the rent guarantee management system 100 via any network, and all or part of it may be downloaded as needed.

[0094] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.

[0095] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0096] The various databases stored in the memory unit 106 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

[0097] The rent guarantee management system 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as such an information processing device connected to any peripheral device. The rent guarantee management system 100 may also be realized by installing software (including programs or data, etc.) that causes such a device to perform the processing described in this embodiment.

[0098] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]

[0099] 100 Rent Guarantee Management System 102 Control section 102a Settlement Data Creation Department 102b Settlement confirmation processing section 102c Cancellation processing section 102d Journal Data Creation Department 102e Screen display control unit 104 Communication interface unit 106 Storage section 106a Data Table 108 Input / Output Interface Section 112 Input Device 114 Output Device 300 Network

Claims

1. A rent guarantee management system equipped with a control unit, The control unit The storage device is configured to be accessible to a storage area in which settlement data having settlement header data including items such as settlement year and month, management company, billing or payment classification, settlement amount, settlement number, settlement completion flag indicating whether the settlement is complete or not, billing number, and payment number, and settlement detail data including items such as settlement number, management company, guarantee number, customer name, billing or payment classification, expense item, and settlement amount is stored; A rent guarantee management system characterized by having a cancellation processing means that, in the event of a cancellation or termination of a rent guarantee contract, creates cancellation data including the guarantee number, customer name, termination category specifying the cancellation or termination of the rent guarantee contract, termination date, and management company, and automatically creates a reverse settlement record in the settlement detail data if the settlement completion flag in the settlement header data linked to the settlement number and the settlement detail data for the guarantee number is "completed," but automatically creates a red slip record if the flag is "incomplete."

2. 2. The rent guarantee management system according to claim 1, wherein the expenses include a guarantee commission fee or a commission for business outsourcing.

3. The control unit a settlement data creation processing means for creating settlement data and storing it in the storage area, and at that time setting the settlement completion flag of the settlement header data to "incomplete", the billing number to "-", and the payment number to "-"; a settlement confirmation processing means for, when finalizing the settlement of the target settlement data stored in the storage area, setting a settlement completion flag in the settlement header data to "completed", and if the billing payment category is "billing", setting a billing number, and if the billing payment category is "payment", setting a payment number; 3. The rent guarantee management system according to claim 1, further comprising:

4. The rent guarantee management system described in claim 3, characterized in that the settlement confirmation processing means creates collection schedule data including items such as billing number, billing year and month, billing recipient, guarantee number, expense item, billing amount, and sales recording date based on the settlement data for which settlement has been confirmed, when the billing payment category of the settlement header data is ``billing.''

5. The rent guarantee management system described in claim 3, characterized in that the settlement confirmation processing means creates payment schedule data including items such as payment number, payment date, payee, guarantee number, payment amount, and payment accounting date based on the settlement data for which settlement has been confirmed, when the billing payment category of the settlement header data is ``payment.''

6. The control unit 4. The rent guarantee management system according to claim 3, further comprising a journal data creation means for creating journal data based on settlement data for which settlement has been confirmed.

7. A rent guarantee management method executed by an information processing device having a control unit, The control unit The storage device is configured to be accessible to a storage area in which settlement data having settlement header data including items such as settlement year and month, management company, billing or payment classification, settlement amount, settlement number, settlement completion flag indicating whether the settlement is complete or not, billing number, and payment number, and settlement detail data including items such as settlement number, management company, guarantee number, customer name, billing or payment classification, expense item, and settlement amount is stored; Executed in the control unit: A rent guarantee management method characterized by including a cancellation processing step in which, when a rent guarantee contract is cancelled or terminated, cancellation data is created that includes the guarantee number, customer name, cancellation category specifying the cancellation or termination of the rent guarantee contract, cancellation date, and management company, and if the settlement completion flag in the settlement header data linked to the settlement number and the settlement detail data for that guarantee number is "completed," a reverse settlement record is automatically created in that settlement detail data, but if it is "incomplete," a red slip record is automatically created.

8. A rent guarantee management program to be executed by an information processing device having a control unit, The control unit The storage device is configured to be accessible to a storage area in which settlement data having settlement header data including items such as settlement year and month, management company, billing or payment classification, settlement amount, settlement number, settlement completion flag indicating whether the settlement is complete or not, billing number, and payment number, and settlement detail data including items such as settlement number, management company, guarantee number, customer name, billing or payment classification, expense item, and settlement amount is stored; Executed in the control unit: A rent guarantee management program for executing a cancellation processing step in the event of a rent guarantee contract being cancelled or terminated, which creates cancellation data including the guarantee number, customer name, cancellation category specifying the cancellation or termination of the rent guarantee contract, cancellation date, and management company, and automatically creates a reverse settlement record in the settlement detail data if the settlement completion flag in the settlement header data linked to the settlement number and the settlement detail data for that guarantee number is "completed," but automatically creates a red slip record if the flag is "incomplete."

Images