JP2024017967A - Rent guarantee management system, rent guarantee management method, and rent guarantee management program - Google Patents

Abstract

PROBLEM TO BE SOLVED: 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

COPYRIGHT: (C)2024,JPO&INPIT

Description

The present invention relates to a rent guarantee management system, a rent guarantee management method, and a rent guarantee management program.

For example, a rent guarantee company does not conclude a rental contract directly with a tenant, but rather a management company (agency) enters a guarantee contract in the form of introducing the rent guarantee company to the tenant, and the management company Outsourcing guarantee work. Therefore, the rent guarantee company is required to bill the management company for the guarantee commission collected from the tenant and pay the business commission. Conventionally, as a system related to rent guarantee, there is, for example, Patent Document 1.

JP2020-52848A

However, Patent Document 1 does not describe anything about improving the efficiency of settlement operations and preventing clerical errors when cancellation or cancellation of a rent guarantee contract occurs.

The present invention has been made in view of the above, and provides a rent guarantee management system, a rent guarantee management method, and a rent guarantee management system that can improve the efficiency of settlement operations and prevent administrative errors when a rent guarantee contract is canceled or terminated. The purpose is to provide a rent guarantee management program.

In order to solve the above-mentioned problems and achieve the purpose, the present invention provides that the control unit controls the payment date, management company, bill payment classification of billing or payment, payment amount, payment number, completion or non-completion of payment. Settlement header data that includes items such as a settlement completion flag, invoice number, and payment number, and settlement details that include items such as settlement number, management company, guarantee number, customer name, billing or payment classification, expense item, and settlement amount. The storage area in which payment data is stored is configured to be accessible, and in the event of cancellation or termination of the rent guarantee contract, the guarantee number, customer name, and cancellation or cancellation of the rent guarantee contract can be specified. If you create cancellation data that includes the cancellation category, cancellation date, and management company, and the settlement completion flag of the settlement data linked by the settlement details data of the guarantee number and settlement number is "Completed," in the settlement details data, The present invention is characterized by being equipped with a cancellation processing means that automatically creates a record of reverse settlement, and also automatically creates a record of a red slip in the case of "incomplete".

Further, according to one aspect of the present invention, the expenses may include a guarantee commission fee or a business commission fee.

Further, according to one aspect of the present invention, the control unit creates payment data and stores it in the storage area, and at this time, sets a payment completion flag of payment header data as "incomplete" and a bill number of "-". '', the payment number is "-", and the settlement data creation processing means sets the settlement completion flag of the settlement header data to "complete" when confirming the settlement of the target settlement data stored in the storage area. , a settlement confirmation processing means for setting a bill number when the bill payment category is "billing" and setting a payment number when the bill payment category is "payment".

Further, according to one aspect of the present invention, the settlement confirmation processing means, based on the settlement data in which settlement has been confirmed, when the billing payment classification of the settlement header data is "Claim", the billing number, the billing date, Collection schedule data may be created that includes items such as billing party, guarantee number, expense item, billing amount, and sales recording date.

Further, according to one aspect of the present invention, the settlement confirmation processing means may include a payment number, a payment date, a payment number, a payment date, and a Payment schedule data may be created that includes the following items: guarantee number, payment amount, and payment recording date.

Further, in order to solve the above-mentioned problems and achieve the purpose, the present invention provides that the control section includes a journal data creation means for creating journal data based on payment data for which payment has been finalized. good.

Further, in order to solve the above-mentioned problems and achieve the purpose, the present invention provides a rent guarantee management method executed by an information processing device including a control unit, the control unit including , payment classification of billing or payment, payment amount, payment number, payment completion flag indicating completion or incomplete payment, billing number, payment number, payment header data including items such as payment number, management company, warranty number, The control unit is configured to be able to access a storage area in which settlement data is stored, including settlement detail data including items such as customer name, billing or payment classification, expense item, and settlement amount, and is executed by the control unit. , in the event of cancellation or termination of a rent guarantee contract, create 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 payment completion flag of the payment data linked by the payment details data and the payment number is "Completed", a reverse payment record will be automatically created in the relevant payment details data, while if it is "Incomplete", a record of the red slip will be created. It is characterized by including a cancellation processing step that automatically creates a record.

Moreover, in order to solve the above-mentioned problems and achieve the purpose, the present invention provides a rent guarantee management program to be executed by an information processing device including a control unit, the control unit comprising: Settlement header data including items such as management company, invoice payment classification of billing or payment, settlement amount, settlement number, settlement completion flag indicating completion or incompleteness of settlement, billing number, payment number, settlement number, management company, and warranty Settlement details data including number, customer name, invoice/payment classification, expense item, and settlement amount are configured to be accessible to a storage area in which settlement data is stored, and the control unit executes the settlement data. If a rent guarantee contract is canceled or terminated, create 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 by the settlement details data of the number and the settlement number is "Completed", a reverse settlement record will be automatically created for the corresponding settlement details data, but if it is "Uncompleted", a red The present invention is characterized by being a rent guarantee management program for executing a cancellation processing step that automatically creates a slip record.

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.

FIG. 1A is a flow diagram illustrating an example of rent guarantee settlement work. FIG. 1B is a flow diagram illustrating an example of rent guarantee settlement work. FIG. 1C is a flow diagram illustrating an example of rent guarantee settlement work. FIG. 1D is a flow diagram illustrating an example of rent guarantee settlement work. FIG. 1E is a flow diagram illustrating an example of rent guarantee settlement work. FIG. 2 is a block diagram showing an example of the configuration of the rent guarantee management system of this embodiment. FIG. 3A is a diagram for explaining a specific example of processing of the control unit of the rent guarantee management system of this embodiment. FIG. 3B is a diagram for explaining a specific example of processing of the control unit of the rent guarantee management system of this embodiment. FIG. 3C is a diagram for explaining a specific example of processing of the control unit of the rent guarantee management system of this embodiment. FIG. 3D is a diagram for explaining a specific example of processing of the control unit of the rent guarantee management system of this embodiment. FIG. 3E is a diagram for explaining a specific example of processing of the control unit of the rent guarantee management system of this embodiment.

EMBODIMENT OF THE INVENTION Below, embodiments of the rent guarantee management system, the rent guarantee management method, and the rent guarantee management program according to the present invention will be described in detail based on the drawings. Note that the present invention is not limited to this embodiment.

[1. overview]
In the rent guarantee industry, guarantee consignment fees are the basis of sales, and while we handle many guarantee consignment contracts, settlement of guarantee consignment fees with management companies is performed before and after settlement of rent insurance guarantee contracts (hereinafter simply referred to as " In the event of a cancellation or termination of a contract (also referred to as a contract), the refund and billing method for guarantee commissions and business commissions will vary depending on the date of cancellation or termination and the settlement status, and the contract status, transaction, and settlement status may vary. It is necessary to thoroughly confirm this through business operations before proceeding.

Reverse settlement operations due to termination or cancellation of individual contracts will complicate the operations of any rent guarantee company, and in addition to business processing, accounting processing also includes canceling sales and reducing costs on invoices. It is necessary to verify documents and payment slips and issue journal entries. As a result, the workload of the person in charge was heavy and clerical errors were occurring.

Therefore, in this embodiment, the billing process and payment process (refund process) in the settlement process for the management company when a contract is canceled or terminated is systemized. Specifically, when a contract is canceled or terminated, reverse settlement data is automatically created for the management company according to the settlement status, thereby improving the efficiency of billing and payment accounting in settlement operations, and reducing manual work. This will help prevent clerical errors. Further, in this embodiment, a journal entry slip for canceling sales and returning costs is automatically created in accordance with the reverse settlement process.

FIGS. 1A to 1E are flowcharts showing an example of rent guarantee settlement operations. An example of rent guarantee settlement work will be described with reference to FIGS. 1A to 1E.

(T1) For example, the guarantee commission fee and business commission fee to the management company are settled on the settlement date "2022/4", and the settlement data (settlement header data, settlement details data) as shown in Figure 1A is provided. create.

(T2) On the settlement date "2022/4", execute the settlement confirmation process to confirm the settlement of the guarantee outsourcing fee and business outsourcing fee to the management company, and as shown in Figure 1A, settle the settlement data and collect. Create schedule data.

(T3) Based on the settled settlement data for 2022/4, create journal data as shown in FIG. 1B.

(T4) Perform a new settlement of the guarantee outsourcing fee and business outsourcing fee to the management company on the settlement date "2022/5" and create settlement data as shown in Figure 1B.

(T5) Since the warranty number "0000000001" has been canceled and the warranty number "0000000002" has been canceled, cancelation data as shown in FIG. 1C is created.

(T6) The operator manually inputs the payment correction. The payment for April is confirmed, but since the payment for May is not yet settled, the details of the reverse payment for the canceled portion are entered, and the accumulation details data is corrected as shown in FIG. 1C. The operator checks the payment status of the payment data for each guarantee number and makes corrections. Since the settlement number "0001" with the guarantee number "0000000001" has already been settled, the operator inputs a reverse settlement record by inverting "Claim" and "Payment" in the settlement request payment category of the settlement details data. Regarding the settlement number "0003" with the guarantee number "0000000002," the settlement has not been completed, so a record of the red slip is input.

In this way, when a contract is canceled or terminated, operators are required to check the payment status of the relevant guarantee number and manually correct the payment data, resulting in a heavy workload and the risk of clerical errors. etc. occur.

In the present invention, as will be described later, when a contract is canceled or terminated, the settlement status is automatically determined and, depending on the settlement status, reverse settlement data is automatically created for the management company, thereby providing settlement services. Improve the efficiency of billing and payment recording and prevent clerical errors through manual work.

(T7) Recalculate the guarantee outsourcing fee and business outsourcing fee to the management company on the settlement date “2022/5” and update the settlement data as shown in FIG. 1D.

(T8) On the settlement date "2022/5", execute the settlement confirmation process to confirm the settlement of the guarantee consignment fee and business consignment fee to the management company, and finalize the settlement data as shown in FIG. 1D. Furthermore, based on the settled payment data, payment request data is created as shown in FIG. 1D.

(T9) Based on the settled settlement data for 2022/5, create journal data as shown in FIG. 1E (create a reversal journal entry for the settlement for 2022/4).

The rent guarantee management system of the present invention is widely applicable to corporations and industries that operate a rent debt guarantee business.

[2. composition]
The configuration of the rent guarantee management system 100 according to this embodiment will be explained with reference to FIG. 2. FIG. 2 is a block diagram showing an example of the configuration of the rent guarantee management system 100 according to the present embodiment. The rent guarantee management system 100 according to this embodiment can be suitably used in, for example, a rent guarantee company.

The rent guarantee management system 100 is a workstation, a commercially available desktop personal computer, or the like. Note that the rent guarantee management system 100 is not limited to stationary information processing devices such as desktop personal computers, but also mobile devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, and tablet personal computers. It may be a type information processing device.

As shown in FIG. 2, the rent guarantee management system 100 includes a control section 102, a communication interface section 104, a storage section 106, and an input/output interface section 108. Each unit included in the rent guarantee management system 100 is communicably connected via an arbitrary communication path.

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

An input device 112 and an output device 114 are connected to the input/output interface unit 108 . As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. Note that in the following description, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112. Furthermore, the operation that the user displays on the screen of the output device (monitor) 114 and operates using the input device 112 may be referred to as "user operation via UI."

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving instructions to a CPU (Central Processing Unit) to perform various processes in cooperation with an OS (Operating System). As the storage unit 106, 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, an optical disk, etc. can be used. Furthermore, the storage unit 106 includes a data table 106a and the like.

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.

The payment data may include payment header data and payment details data. Settlement header data includes the settlement date, management company, billing and payment classification specifying billing or payment (for example, "0: Billing", "1: Payment"), settlement amount, settlement number, and whether settlement has been completed. It may also include items such as a payment completion FLG (flag) indicating the payment, a billing number, and a payment number. The settlement completion FLG is, for example, "0: Unconfirmed (incomplete)" and "1: Confirmed (completed)."

The settlement details data may include items such as settlement number, management company, guarantee number, customer name, bill payment classification, expense item, and settlement amount. Expenses include, for example, business commission fees and business guarantee fees. A business outsourcing fee is a fee paid by a rent guarantee company when outsourcing a business to a management company. The business guarantee fee is charged to the management company for the rent guarantee fees collected by the management company from customers.

Settlement header data and settlement detail data are linked by a settlement number. Settlement in the settlement header data is aggregation of settlement detail data for each 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 , which is the difference between the billed amount and the paid amount.

The cancellation data may include items such as warranty number, customer name, cancellation category, cancellation date, and management company. The cancellation classification is, for example, "0: Cancellation" and "1: Cancellation." "Cancellation" refers to the case where the rent guarantee contract is canceled before the guarantee start time. “Cancellation” refers to canceling the contract after the warranty start time has passed.

The collection schedule data may include the following items: billing number, billing date, billing destination, warranty number, expense item, billing amount, and sales recording date. Collection schedule data is created when the billing/payment classification of the settlement header data is "billing".

The payment request data may include the following items: payment number, payment date, payee, guarantee number, payment amount, and payment recording date. Collection schedule data is created when the bill payment classification of the settlement header data is "payment".

The control unit 102 is a CPU or the like that centrally controls the rent guarantee management system 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs specifying various processing procedures, required data, etc., and performs various information processing based on these stored programs. Execute.

The control unit 102 is configured to be able to access a data table (storage area) 106a stored in the storage unit 106. Note that the data table 106a may be provided in another location (for example, the server 200), and may have any configuration as long as it can be accessed by the control unit 102.

Functionally, the control unit 102 includes a payment data creation unit 102a, a payment confirmation processing unit 102b, a cancellation processing unit 102c, a journal data creation unit 102d, and a screen display control unit 102e.

The payment data creation unit 102a executes payment data creation processing. Specifically, in the payment data creation process, the payment data creation unit 102a, for example, creates payment data (payment header data, payment details) according to an operator's operation on an input screen (not shown) displayed on the monitor 114. data) is created and stored in the data table 106a. At this time, the settlement completion FLG of the settlement header data is set to "0: unconfirmed", the billing number is "-", and the payment number is "-".

Further, the payment data creation unit 102a executes payment data creation processing (recalculation processing).
Specifically, in the payment data creation process (recalculation process), the payment data creation unit 102a adds the reverse payment to the payment details data of the payment data when the rent guarantee contract is canceled or cancelled, as will be described later. When a record or a red slip record is created, the settlement header data of the corresponding settlement data is recalculated, the total amount of the balance of the settlement amount of the settlement details data is set as the "settlement amount", and the "bill payment classification" is set. is reset according to the plus/minus of income and expenses, and a new "accounting number" is set.

The payment confirmation processing unit 102b executes payment confirmation processing. Specifically, in the settlement confirmation process, the settlement confirmation processing unit 102b sets the settlement completion FLG of the settlement header data to "1: Confirmation" when confirming the settlement of the target settlement data stored in the data table 106a. If the bill payment category is "0: Billing", a bill number is assigned (set), and if the bill payment category is "1: Payment", a payment number is assigned (set).

In addition, based on the finalized payment data, the payment confirmation processing unit 102b determines, when the billing payment classification of the payment header data is "Claim", the billing number, billing date, billing destination, guarantee number, expense item, billing amount, Collection schedule data including the item of sales recording date is created and stored in the data table 106a.

Based on the confirmed settlement data, the settlement confirmation processing unit 102b also provides a payment number, a payment date, a payee, a guarantee number, a payment amount, and a payment recording date when the bill payment classification of the settlement header data is "payment". Payment request data including the items is created and stored in the data table 106a.

The cancellation processing unit 102c executes cancellation input processing. Specifically, in the cancellation input process, the cancellation processing unit 102c responds to an operator's operation on an input screen (not shown) displayed on the monitor 114 when cancellation or termination of the rent guarantee contract occurs. Accordingly, cancellation data including the guarantee number, customer name, cancellation category for specifying cancellation or termination of the contract, cancellation date, and management company is created and stored in the data table 106a. In addition, by referring to the settlement completion FLG of the settlement header data linked with the settlement details data of the guarantee number of the cancellation data and the settlement number, if the settlement completion FLG is "1: Confirmed", the reverse While a settlement record is automatically created, if the settlement completion FLG is "0: unconfirmed", a red slip record is automatically created in the settlement details data.

The journal data creation unit 102d executes journal data creation processing. Specifically, in the journal data creation process, the journal data creation unit 102d creates journal data based on the settled settlement data and stores it in the data table 106a.

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

[3. Specific example of processing]
A specific example of the processing of the control unit 102 of the rent guarantee management system 100 in this embodiment will be described with reference to FIGS. 2 to 3E. 3A to 3E are diagrams showing a processing flow (sample data) for explaining a specific example of the processing of 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 thereto, and the cancellation or termination of the rent guarantee contract may be performed at other timings as well.

(S1: Settlement data creation process)
For example, the guarantee commission fee and business commission fee to the management company are settled in the settlement date "2022/4", and settlement data as shown in FIGS. 3A (A) and (B) is created, for example. The payment data creation unit 102a, for example, creates payment data (payment header data, payment details data) in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and stores it in the data table 106a. Store. At this time, the payment completion FLG of the payment header data is set to "0: unconfirmed", the billing number is "-", and the payment number is "-".

FIG. 3A(A) shows an example of the created settlement header data. The settlement header data includes items such as settlement year and month, management company, bill payment classification, settlement amount, settlement number, settlement completion FLG, billing number, and payment number. In the example shown in the figure, the payment date is "2022/4", the management company is "Management Company A", the billing payment classification is "0: Billing", the payment amount is "¥70,000", the payment number is "00001", and the payment is completed. FLG "0: Unconfirmed", bill number "-", payment number "-".

FIG. 3A(B) shows an example of the settlement details data. The settlement details data includes the following items: settlement number, management company, guarantee number, customer name, bill payment classification, expense item, and settlement amount. In the example shown in the figure, the first line contains the payment number "00001", the management company "Management Company A", the guarantee number "0000000001", the customer name "Tanakata Rō", the billing payment classification "0: Billing", and the expense item " "Initial Guarantee Consignment Fee", Settlement Amount "¥100,000", Second line is Settlement Number "00001", Management Company "Management Company A", Guarantee Number "0000000001", Customer Name "Tanakata Rō", Billing Payment Classification "1: Payment", expense item "outsourcing fee", and settlement amount "¥30,000".

(S2: Settlement confirmation process)
On the settlement date "April 2022," the settlement of the guarantee commission and business commission fee will be finalized with the management company, and the settlement data will be finalized as shown in FIGS. 3A(C) and (D). When confirming the settlement of the target settlement data, the settlement confirmation processing unit 102b sets the settlement completion FLG of the settlement header data to "1: Confirmation", and if the billing payment classification is "0: Billing", it sets the billing number. Assign (set) a number, and if the bill payment classification is "1: Payment", assign (set) a payment number.

Specifically, as shown in FIG. 3A(C), the settlement completion FLG of the settlement header data is updated to "1: Confirmed", and since the billing payment classification is "0: Billing", a new billing number is added. Set "10001".

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

FIG. 3A(E) shows an example of the collection schedule data that is created. The collection schedule data includes the following items: billing number, billing date, billing destination, warranty number, expense item, billing amount, and sales recording date. In the example shown in the figure, the billing number is “10001,” the billing date is “2022/4,” the billing party is “Management Company A,” the guarantee number is “-,” the expense item is “guarantee commission,” and the bill is ¥70,000. ”, and the sales recording date is “2022/4/30”.

(S3: Journal data creation process)
Based on the settlement data finalized in 2022/4, journal data as shown in FIG. 3B(A) is created. The journal data creation unit 102d creates journal data based on the settled settlement data and stores it in the data table 106a.

FIG. 3B(A) is a diagram showing an example of journal data that is created. In the example shown in the figure, the debit side is accounts receivable: ¥100,000/the credit side is sales (guarantee commission): ¥100,000, the debit side is cost/outsourcing commission: ¥30,000/the credit side is accounts payable: ¥30 ,000.

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

FIG. 3B is a diagram showing an example of the created settlement header data. In the example shown in the figure, the payment date is "2022/5", the management company is "Management Company A", the billing payment classification is "0: Billing", the payment amount is "¥7,000", the payment number is "00002", and the payment is completed. FLG "0: Unconfirmed", bill number "-", payment number "-".

FIG. 3B(C) is a diagram showing an example of the created settlement details data. In the example shown in the figure, the first line contains the payment number "00002", the management company "Management Company A", the guarantee number "0000000002", the customer name "Satoichiro", the billing payment classification "0: Billing", and the expense item " Renewal Guarantee Commission Fee'', Settlement Amount: ¥10,000, Second Line: Settlement Number ``00002'', Management Company ``Management Company A'', Guarantee Number ``0000000002'', Customer Name ``Satoichiro'', Billing Payment Classification "1: Payment", expense item "outsourcing fee", and settlement amount "¥3,000".

(S5: Cancellation input processing)
Since the guarantee number "0000000001" has been canceled and the guarantee number "0000000002" has been canceled, cancellation data as shown in FIG. 3C(A) is created. When cancellation or cancellation of a rent guarantee contract occurs, the cancellation processing unit 102c inputs the guarantee number, customer name, contract, etc. according to an operator's operation on an input screen (not shown) displayed on the monitor 114, for example. Cancellation data including a cancellation category, cancellation date, and management company that designates cancellation or cancellation of the contract is created and stored in the data table 106a.

FIG. 3C(A) is a diagram showing an example of cancellation data. The cancellation data includes items such as warranty number, customer name, cancellation category, cancellation date, and management company. In the example shown in the figure, the first line is the guarantee number "0000000001", the customer name "Tanakata Rō", the cancellation category "0: Cancellation", the cancellation date "2022/05/31", and the management company "Management Company A". , the second line contains the warranty number "0000000002", the customer name "Satoichiro", the cancellation category "1: Cancellation", the cancellation date "2022/05/31", and the management company "Management Company A".

Further, the cancellation processing unit 102c refers to the settlement completion FLG of the settlement header data linked by the settlement details data of the guarantee number of the cancellation data and the settlement number, and if the settlement completion FLG is "1: Confirmed", the corresponding settlement In the detailed data, a record of reverse settlement is automatically created, and if the settlement completion FLG is "0: unconfirmed", a record of a red slip is automatically created in the detailed payment data.

FIG. 3C(B) is a diagram showing an example of updated payment details data. Regarding the guarantee number "0000000001", the settlement completion FLG of the linked settlement header data (payment number "00001") is "1: Confirmed", so the settlement request payment category of the settlement details data is "Claim" and "Payment". ” Create a reverse settlement record with the ``” reversed. Specifically, on the third line, the management company "Management Company A", the guarantee number "0000000001", the customer name "Tanakata Rō", the billing payment classification "1: Payment", the expense item "Initial Guarantee Commission Fee", and the settlement amount Record of "¥100,000", on the 4th line, settlement number "00001", management company "Management Company A", warranty number "0000000001", customer name "Tanakata Rō", billing payment classification "0: Billing", Add a record for the expense item “outsourcing fee” and the settlement amount “¥30,000.”

Regarding the guarantee number "0000000002," the settlement completion FLG of the linked settlement header data (payment number "00002") is "0: Unconfirmed," so a record of the red slip is added to the billing details data. Specifically, on the 5th line, the management company "Management Company A", the guarantee number "0000000002", the customer name "Satoichiro", the billing payment classification "0: Billing", the expense item "Renewal guarantee commission", and the settlement amount Record of "¥-10,000", 6th line contains management company "Management Company A", warranty number "0000000002", customer name "Satoichiro", billing payment classification "1: Payment", expense item "Outsourcing fee" ”, and add a record with the payment amount “¥-3,000”.

(S6: Settlement data creation (recalculation process))
The guarantee commission fee and business commission fee to the management company will be recalculated in the settlement date "2022/5", and the settlement data will be updated as shown in FIGS. 3D (A) and (B). When the rent guarantee contract is canceled or canceled and a reverse settlement record or red slip record is created in the settlement details data of the settlement data, the settlement data creation unit 102a creates the settlement header data of the settlement data. Recalculate the amount, set the total amount of the balance of the settlement amount in the settlement details data as the "settlement amount", reset the "bill payment classification" according to the plus/minus of the balance, and set a new "settlement number". do.

FIG. 3D(A) shows an example of recalculated payment header data. As shown in the figure, the bill payment classification of the settlement header data is set to "1: Payment," the settlement amount is set to "¥70,000," and the settlement number is set to "00003."

FIG. 3D(B) shows an example of recalculated payment header data. As shown in the figure, the payment date and month "2022/5" and the payment number "00003" are added to lines 3 to 6 of the payment details data.

(S7: Settlement confirmation process)
On the settlement date "2022/5", the settlement of the guarantee consignment fee and business consignment fee is finalized with the management company, and the settlement data is finalized as shown in FIGS. 3E (A) and (B).

Specifically, as shown in Figure 3E(A), the payment completion FLG in the payment header data is updated to "1: Confirmed", and since the bill payment classification is "1: Payment", a new payment number is added. Set "20001".

Further, the settlement confirmation processing unit 102b creates payment request data based on the confirmed settlement data when the billing payment category of the settlement header data is "payment" and stores it in the data table 106a.

FIG. 3E(C) is a diagram showing an example of payment request data. The payment request data includes the following items: payment number, payment date, payee, guarantee number, payment amount, and payment recording date. In the example shown in the figure, the payment number is "20001," the payment date is "2022/5/31," the payment destination is "A management company," the payment amount is "¥70,000," and the payment recording date is "2022/5/31." It has become.

(S8: Journal data creation process)
Based on the confirmed settlement of 2022/5, journal data as shown in FIG. 3E(D) is created (a reversal of the settlement of 2022/4 is created).

FIG. 3E(D) is a diagram showing an example of journal data to be created. In the example shown in the figure, the debit side is sales (guarantee commission): ¥100,000 / the credit side is accounts receivable: ¥100,000, the debit side is accounts payable: ¥30,000 / the credit side is cost / business commission fee: ¥30 ,000.

As explained above, according to the present embodiment, when a rent guarantee contract is canceled or terminated, the guarantee number, customer name, cancellation category specifying cancellation or termination of the rent guarantee contract, cancellation date, management If cancellation data including the company is created and the settlement completion flag of the settlement data linked by the settlement details data of the guarantee number and the settlement number is "completed", a record of reverse settlement will be automatically created in the settlement details data. On the other hand, in the case of "incomplete", the cancellation processing unit 102c automatically creates a red slip record, which improves the efficiency of settlement operations and prevents clerical errors when a rent guarantee contract is canceled or terminated. becomes possible.

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

Furthermore, this embodiment can contribute to reducing waste loss and promoting paperless and electronic systems, making it possible to contribute to Goals 12, 13, and 15 of the SDGs.

Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

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

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 the processes described as being performed manually can be performed manually. All or part of the process can also be performed automatically using known methods.

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

Further, regarding the rent guarantee management system 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions provided in the rent guarantee management system 100, especially each processing function performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be realized as hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processing described in this embodiment. mechanically read into system 100; That is, a storage unit such as a ROM or an HDD (Hard Disk Drive) stores a computer program that cooperates with an OS to give instructions to a CPU and perform various processes. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the rent guarantee management system 100 via any network, and it is also possible to download all or part of it as necessary. It is.

Further, a program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, this "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 EEPR. OM (registration) Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVDs (Digital Versatile Discs), Blu-ray (registered trademark) Discs, etc. shall include any “portable physical medium”.

Further, a "program" is a data processing method written in any language or writing method, and does not matter in the form of source code or binary code. Note that a "program" is not necessarily limited to a unitary structure, but may be distributed as multiple modules or libraries, or may work together with separate programs such as an OS to achieve its functions. Including things. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, and the installation procedure after reading.

Various databases and the like stored in the storage 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 various databases used for various processing and website provision. Stores programs, tables, databases, web page files, etc.

Furthermore, 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 the information processing device connected to any peripheral device. Furthermore, the rent guarantee management system 100 may be realized by installing software (including programs, data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of dispersion and integration of devices is not limited to what is shown in the diagram, and all or part of them can be functionally or physically divided into arbitrary units according to various additions or functional loads. It can be configured in a distributed/integrated manner. That is, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively.

100 Rent guarantee management system 102 Control unit 102a Settlement data creation unit 102b Settlement confirmation processing unit 102c Cancellation processing unit 102d Journal data creation unit 102e Screen display control unit 104 Communication interface unit 106 Storage unit 106a Data table 108 Input/output interface unit 112 Input device 114 Output device 300 Network

Claims (8)

A rent guarantee management system comprising a control unit,
The control unit includes:
Settlement header data including items such as settlement date, management company, invoice payment classification of billing or payment, settlement amount, settlement number, settlement completion flag indicating completion or incompleteness of settlement, billing number, payment number, settlement number, A storage area in which payment data is stored is configured to be accessible, including payment details data including management company, guarantee number, customer name, billing or payment classification, expense item, and payment amount.
In the event of a cancellation or termination of a rent guarantee contract, we will create 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 make payments for the guarantee number. If the settlement completion flag of the settlement data linked by the detail data and settlement number is "Completed", a reverse settlement record will be automatically created for the corresponding settlement detail data, while if it is "Incomplete", a record of the red slip will be created. A rent guarantee management system characterized by being equipped with a cancellation processing means for automatically creating a contract. 2. The rent guarantee management system according to claim 1, wherein the expense items include a guarantee consignment fee or a business consignment fee. The control unit includes:
Settlement data creation processing means that creates settlement data and stores it in the storage area, and sets a settlement completion flag of settlement header data as "incomplete", bill number "-", and payment number "-";
When confirming the settlement of the target settlement data stored in the storage area, set the settlement completion flag of the settlement header data to "Complete" and set the billing number if the billing payment classification is "Claim". However, if the bill payment classification is "Payment", a settlement confirmation processing means for setting a payment number,
3. The rent guarantee management system according to claim 1, further comprising: The settlement confirmation processing means, based on the settlement data for which settlement has been confirmed, when the billing payment classification of the settlement header data is "Claim", the billing number, billing date, billing destination, guarantee number, expense item, billing amount, 4. The rent guarantee management system according to claim 3, wherein collection schedule data including an item of sales recording date is created. The settlement confirmation processing means, based on the settlement data for which the settlement has been confirmed, when the bill payment classification of the settlement header data is "payment", the payment number, payment date, payee, guarantee number, payment amount, and payment recording date. 4. The rent guarantee management system according to claim 3, wherein payment schedule data including the following items is created. The control unit includes:
4. The rent guarantee management system according to claim 3, further comprising journal data creation means for creating journal data based on the payment data for which payment has been finalized. A rent guarantee management method executed by an information processing device equipped with a control unit, the method comprising:
The control unit includes:
Settlement header data including items such as settlement date, management company, invoice payment classification of billing or payment, settlement amount, settlement number, settlement completion flag indicating completion or incompleteness of settlement, billing number, payment number, settlement number, A storage area in which payment data is stored is configured to be accessible, including payment details data including management company, guarantee number, customer name, billing or payment classification, expense item, and payment amount.
executed in the control unit,
In the event of a cancellation or termination of a rent guarantee contract, we will create 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 make payments for the guarantee number. If the settlement completion flag of the settlement data linked by the detail data and settlement number is "Completed", a reverse settlement record will be automatically created for the corresponding settlement detail data, while if it is "Incomplete", a record of the red slip will be created. A rent guarantee management method characterized by including a cancellation processing step of automatically creating a contract. A rent guarantee management program to be executed by an information processing device equipped with a control unit,
The control unit includes:
Settlement header data including items such as settlement date, management company, invoice payment classification of billing or payment, settlement amount, settlement number, settlement completion flag indicating completion or incompleteness of settlement, billing number, payment number, settlement number, A storage area in which payment data is stored is configured to be accessible, including payment details data including management company, guarantee number, customer name, billing or payment classification, expense item, and payment amount.
executed in the control unit,
In the event of a cancellation or termination of a rent guarantee contract, we will create 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 make payments for the guarantee number. If the settlement completion flag of the settlement data linked by the detail data and settlement number is "Completed", a reverse settlement record will be automatically created for the corresponding settlement detail data, while if it is "Incomplete", a record of the red slip will be created. A rent guarantee management program that automatically creates a cancellation process.

Images