Offsetting processing device, offsetting processing method, and offsetting processing program

Abstract

To improve the speed and accuracy of billing and payment amount calculations at a rent guarantee company by reducing clerical errors by personnel in charge when they are calculating amounts regarding billing of guarantee fees to management companies and payment of outsourcing commission.SOLUTION: An offset processing device according to the present embodiment includes: a master that has registered presence or absence of offset settings for each type of rent guarantee fee for each management company; contract processing means for entering settlement schedule data including contract identification information, a contractor name, a management company, billing / payment classification of billing for or payment to the management company, a type of rent guarantee fee that is a billing item or a type of fee that is a payment item, and an amount; and settlement processing means for acquiring the presence or absence of offset settings from the master using the management company and the type of rent guarantee fee as keys, for target settlement schedule data, and generating settlement data based on the presence or absence of acquired offset settings.SELECTED DRAWING: Figure 2

Description

[Technical field]

[0001] The present invention relates to an offset processing device, an offset processing method, and an offset processing program. [Background technology]

[0002] For example, in the rent guarantee industry, rental contracts are not concluded directly with tenants, but rather real estate management companies introduce rent guarantee companies to tenants and conclude guarantee contracts, which generates administrative fees (outsourcing fees) in the form of introduction fees, sales commissions, etc. Conventional rent guarantee systems include, for example, Patent Document 1. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2016-177574 A Summary of the Invention [Problem to be solved by the invention]

[0004] However, Patent Document 1 does not state anything about automatically offsetting the amount of guarantee fee billed to the management company and the amount of commission fee paid based on master settings for each management company, thereby reducing clerical errors made by staff when calculating amounts and improving the speed and accuracy of calculating amounts billed and paid to management companies.

[0005] The present invention has been made in consideration of the above, and aims to provide an offsetting processing device, an offsetting processing method, and an offsetting processing program that can reduce clerical errors made by staff at rent guarantee companies when calculating amounts when billing guarantee fees to management companies and paying outsourcing fees, and can improve the speed and accuracy of calculating billing and payment amounts. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides an offsetting processing device that has a memory unit and a control unit and offsets rent guarantee fees and fees, wherein the memory unit stores a master that registers the presence or absence of offsetting settings for each type of rent guarantee fee by management company, and the control unit is characterized by having a contract processing means that inputs settlement schedule data including contract identification information, the name of the contractor, the management company, the billing or payment category of the bill or payment to the management company, the type of rent guarantee fee which is a billing item or the type of fee which is a payment item, and the amount, and a settlement processing means that obtains the presence or absence of offsetting settings from the master for the target settlement schedule data using the management company and the type of rent guarantee fee as keys, and generates settlement data based on the presence or absence of the obtained offsetting settings.

[0007] In addition, according to one aspect of the present invention, the settlement processing means may generate settlement data in which the amount of the billing item and the amount of the payment item are offset when an offset setting is present, and may generate separate settlement data for billing and payment when an offset setting is not present.

[0008] In addition, according to one aspect of the present invention, when an offset setting is present, the settlement processing means assigns the same settlement number for billing and payment to the settlement schedule data for the same contract identification information, and generates settlement data in which the amount of the billing item and the amount of the payment item are offset for each settlement number, and when an offset setting is not present, the settlement processing means assigns different settlement numbers for billing and payment to the settlement schedule data for the same contract identification information, and generates separate settlement data for each settlement number.

[0009] According to another aspect of the present invention, the types of rent guarantee fee may include an initial guarantee fee, a renewal guarantee fee, and an additional guarantee fee.

[0010] According to another aspect of the present invention, the settlement processing means may issue a settlement statement based on the settlement data.

[0011] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention provides an offset processing method executed by an information processing device equipped with a memory unit and a control unit, wherein the memory unit stores a master that registers the presence or absence of offset settings for each type of rent guarantee fee by management company, and the method includes a contract processing step executed by the control unit, which inputs settlement schedule data including contract identification information, the name of the contractor, the management company, the billing or payment category of the bill or payment to the management company, the type of rent guarantee fee which is a billing item or the type of fee which is a payment item, and the amount, and a settlement processing step that obtains the presence or absence of offset settings from the master for the target settlement schedule data using the management company and the type of rent guarantee fee as keys, and generates settlement data based on the obtained presence or absence of offset settings.

[0012] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention is an offset processing program to be executed on an information processing device equipped with a memory unit and a control unit, wherein the memory unit stores a master that registers the presence or absence of offset settings for each type of rent guarantee fee by management company, and the control unit executes a contract processing step of inputting settlement schedule data including contract identification information, the name of the contractor, the management company, the billing or payment category of the bill or payment to the management company, the type of rent guarantee fee which is a billing item or the type of fee which is a payment item, and the amount, and a settlement processing step of obtaining the presence or absence of offset settings from the master for the target settlement schedule data using the management company and the type of rent guarantee fee as keys, and generating settlement data based on the obtained presence or absence of offset settings. Effect of the Invention

[0013] According to the present invention, it is possible to reduce clerical errors made by staff at rent guarantee companies when calculating amounts for billing guarantee fees to management companies and paying outsourcing fees, and to improve the speed and accuracy of calculating billing and payment amounts. [Brief description of the drawings]

[0014] [Figure 1]FIG. 1 is a diagram for explaining an outline of the offset processing device of the present embodiment. [Diagram 2] FIG. 2 is a diagram showing an example of the configuration of the offset processing device of the present embodiment. [Diagram 3] FIG. 3 is a diagram illustrating an example of the configuration of the item master. [Figure 4] FIG. 4 is a diagram illustrating an example of the configuration of the management company master. [Diagram 5] FIG. 5 is a diagram showing a flow for explaining an example of an overall processing procedure of the control unit of the offsetting processing device according to the present embodiment. [Figure 6] FIG. 6 is a diagram for explaining a specific example of the process of the control unit of the offset processing device according to the present embodiment. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the process of the control unit of the offset processing device according to the present embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0015] Hereinafter, an embodiment of an offset processing device, an offset processing method, and an offset processing program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the embodiment.

[0016] [1. Overview] For example, in the rent guarantee industry, rental contracts are not concluded directly with tenants, but rather real estate management companies introduce rent guarantee companies to tenants and conclude guarantee contracts with them, which generates commission fees such as introduction fees and sales commission.

[0017] Previously, monthly guarantee fees to be paid to management companies and payments of commission fees were calculated separately and managed manually using Excel, etc. This resulted in clerical errors.

[0018] Therefore, in this embodiment, a mechanism is created in which the amount of the guarantee fee charged to the management company and the amount of the outsourcing fee paid are automatically offset based on the master settings for each management company.

[0019] According to this embodiment, the offset function is systemized, which reduces clerical errors made by workers when calculating amounts, and contributes to the speed and accuracy of calculation of billing and payment amounts to management companies. In particular, since the offset conditions for billing and payment amounts differ for each management company, the offset conditions can be managed in the master settings, which simplifies business operations.

[0020] FIG. 1 is a diagram for explaining the outline of the offset processing device of this embodiment. The offset processing device of this embodiment can be suitably used in rent guarantee companies and the like. In FIG. 1, the offset processing device registers in the master whether or not offset is set for each type of rent guarantee fee (for example, the initial guarantee fee at the time of contract, the renewal guarantee fee at the time of renewal, etc.) for each management company. In addition, the offset processing device registers, for example, the initial guarantee fee at the time of contract, the renewal guarantee fee at the time of renewal, and the commission fee at the time of contract and renewal for payment, as settlement schedule data for the management company of the rent guarantee company. With reference to the master, if the guarantee fee has an offset setting, the guarantee fee and the commission fee are automatically offset. As a result, if the billing amount is large, an invoice (adjustment statement) for the difference is issued, and if the payment amount is large, a payment statement (adjustment statement) for the difference is issued.

[0021] [2. Configuration] The configuration of the offset processing device 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 the offset processing device 100 according to this embodiment. The offset processing device 100 according to this embodiment can be suitably used in, for example, a rent guarantee company.

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

[0023] 2, the offset processing device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the offset processing device 100 is connected to be able to communicate with each other via an arbitrary communication path.

[0024] The communication interface unit 104 communicably connects the offset processing device 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 offset processing device 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). Note that the data stored in the storage unit 106, which will be described later, may be stored in the server.

[0025] 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 realize a pointing device function. In the following, 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. In addition, the operation by the user using the input device 112 to display on the screen of the output device (monitor) 114 may be referred to as a "user operation via a UI."

[0026] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, optical disks, etc. can be used as the storage unit 106.

[0027] The storage unit 106 includes an item master 106a, a management company master 106b, and a data file 106c. Fig. 3 is a diagram showing an example of the configuration of the item master 106a, and Fig. 4 is a diagram showing an example of the configuration of the management company master 106b.

[0028] The item master 106a can be configured as a table or the like in which data on item keys, item names, and rent categories are registered in association with each other, as shown in FIG.

[0029] In the example of the item master 106a shown in Fig. 3, the first line has an item key "1001", an item name "initial guarantee fee", and a rent category "901", the second line has an item key "1101", an item name "outsourcing fee (initial guarantee fee)", and a rent category "911", the third line has an item key "2001", an item name "renewal guarantee fee", and a rent category "902", the fourth line has an item key "2101", an item name "outsourcing fee (renewal guarantee fee)", and a rent category "912", the fifth line has an item key "3001", an item name "additional guarantee fee", and a rent category "903", and the sixth line has an item key "3101", an item name "outsourcing fee (additional guarantee fee)", and a rent category "913".

[0030] The management company master 106b is a master for registering the presence or absence of offset settings for each type of guarantee fee for each management company. As shown in Fig. 4, the management company master 106b can be configured as a table or the like in which data on the management company key, management company name, offset setting for the initial guarantee fee, offset setting for the renewal guarantee fee, and offset setting for the additional guarantee fee are associated and registered.

[0031] In the example of management company master 106b shown in Figure 4, the management company key is "PM01," the management company name is "Management Company A," the offset setting for the initial guarantee fee is "Offset," the offset setting for the renewal guarantee fee is "Do not offset," and the offset setting for the additional guarantee fee is "Offset."

[0032] The data file 106c is a table for storing various data such as settlement schedule data, settlement data, and journal data.

[0033] The settlement schedule data may include contract identification information (e.g., contract key and / or contractor name), management company (management company key, management company name), billing payment category (billing or payment), item key, item name, amount, settlement number, and scheduled settlement date (see Figure 6).

[0034] The settlement data may include the settlement number, settlement date, billing and payment category, billing / payee key, billing / payee name, amount, and whether or not a settlement statement has been issued (unissued or issued) (see Figure 6).

[0035] Returning to Fig. 2, the control unit 102 is a CPU or the like that comprehensively controls the offset processing device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs. The control unit 102 conceptually includes a master maintenance unit 102a, a contract processing unit 102b, a settlement processing unit 102c, an accounting processing unit 102d, and a screen display control unit 102e.

[0036] The master maintenance unit 102a performs editing such as input, change, and addition of the item master 106a and the management company master 106b in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114, for example.

[0037] The contract processing unit 102b inputs settlement schedule data including contract identification information, the name of the contractor, the management company, the billing or payment category of the bill or payment to the management company, the type of rent guarantee fee which is a billing item or the type and amount of fees which are payment items, in response to, for example, operator operations on an input screen (not shown) displayed on the monitor 114, and stores the data in a data file 106c.

[0038] The settlement processing unit 102c obtains the presence or absence of offset settings from the management company master 106b for the target settlement schedule data using the management company and the type of rent guarantee fee as keys, generates settlement data based on the obtained presence or absence of offset settings, and registers it in the data file 106c.

[0039] In addition, if an offset setting is present, the settlement processing unit 102c may generate settlement data in which the amounts of the billing items and the payment items are offset, and if an offset setting is not present, separate settlement data may be generated for billing and payment.

[0040] In addition, when an offset setting is present, the settlement processing unit 102c may assign the same settlement number for billing and payment to the settlement schedule data for the same contract identification information, and generate settlement data in which the amount of the billing item and the amount of the payment item are offset for each settlement number; when an offset setting is not present, the settlement processing unit 102c may assign different settlement numbers for billing and payment to the settlement schedule data for the same contract identification information, and generate separate settlement data for each settlement number.

[0041] The types of rent guarantee fees may include an initial guarantee fee, a renewal guarantee fee, and an additional guarantee fee.

[0042] The settlement processing unit 102c may also issue a settlement statement based on the settlement data.

[0043] The accounting processing unit 102d automatically creates accounting based on the offsetting results of the settlement schedule data and the accrued sales and costs, and registers the same in the data file 106c.

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

[0045] [3. Specific examples of processing] A specific example of the process of the control unit 102 of the offsetting processing device 100 in this embodiment will be described with reference to Fig. 2 to Fig. 7. Fig. 5 is a diagram showing a flow for explaining an outline of the entire process of the control unit 102 of the offsetting processing device 100 in this embodiment. Figs. 6 and 7 are diagrams showing sample data for explaining a specific example of the process of the control unit 102 of the offsetting processing device 100 in this embodiment.

[0046] (3-1. Overall processing) An outline of the overall processing of the control unit 102 of the offset processing device 100 in this embodiment will be described with reference to Fig. 5. In Fig. 5, as advance preparation, setting (maintenance) of the item master 106a and the management company master 106b is performed.

[0047] The master maintenance unit 102a executes an item master maintenance process (step S1). Specifically, in the item master maintenance process, the master maintenance unit 102a sets data of the item master 106a in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114, for example.

[0048] The master maintenance unit 102a executes management company master maintenance processing (step S2). Specifically, in the management company master maintenance processing, the master maintenance unit 102a sets data of the management company master 106b in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114, for example.

[0049] As part of normal business operations, data is registered in the settlement schedule data, settlement data is created based on the settlement schedule data, and a settlement statement is issued based on the settlement data.

[0050] The contract processing unit 102b executes contract processing (contract conclusion processing when a contract is concluded, contract renewal processing when a contract is renewed, and contract revision processing when a contract is revised) (step S3). Specifically, in the contract processing, the contract processing unit 102b inputs the contract key, contractor name, management company key, management company name, billing payment classification, item key, item name, and amount of the settlement schedule data in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, and stores them in the data file 106c.

[0051] The settlement processing unit 102c executes the settlement process (step S4). Specifically, in the settlement process, the settlement processing unit 102c obtains the presence or absence of offset settings from the management company master 106b using the management company and the type of rent guarantee fee of the target settlement schedule data as keys. If offset settings are present, the settlement processing unit 102c assigns the same settlement number and planned settlement date to the settlement schedule data with the same contract key, and generates settlement data in which the amount of the billing item and the amount of payment are offset for each settlement number. If offset settings are not present, the settlement processing unit 102c does not perform offsetting, and assigns different settlement numbers and the same planned settlement date to the billing and payment for the settlement schedule data with the same contract key, and generates separate settlement data for each settlement number.

[0052] The settlement processing unit 102c executes a settlement statement (invoice, payment statement) issuing process (step S5). Specifically, in the settlement statement issuing process, the settlement processing unit 102c issues a settlement statement based on the settlement data.

[0053] A journal entry is created in the accounting work. The journal entry processing unit 102d executes the journal entry creation process (step S6). Specifically, in the journal entry creation process, the journal entry processing unit 102d automatically creates a journal entry based on the offset result of the settlement schedule data and the accrued sales and cost, and registers it in the data file 106c.

[0054] (3-2. Sample data) A specific example of the process of the control unit 102 of the offset processing device 100 in this embodiment will be described with reference to the sample data in FIG. 6 and FIG.

[0055] FIG. 6 is a diagram showing sample data for explaining the case where offsetting is set (in the case of the initial guarantee fee).

[0056] (Item Master Maintenance Processing S1) The master maintenance unit 102a sets data in the management company master 106b in response to an operation by an operator on a master maintenance screen (not shown) displayed on the monitor 114, for example.

[0057] Fig. 6(A) shows an example of data setting of the item master 106a. In the example of the item master 106a shown in Fig. 3, the first line has an item key "1001", an item name "initial guarantee fee", and a rent category "901", and the second line has an item key "1101", an item name "service commission (initial guarantee fee)", and a rent category "911".

[0058] (Management company master maintenance processing S2) The master maintenance unit 102a sets data in the management company master 106b in response to an operation by an operator on a master maintenance screen (not shown) displayed on the monitor 114, for example.

[0059] Fig. 6(B) is a diagram showing an example of data settings in the management company master 106b. In the example of the management company master 106b shown in Fig. 6(B), the management company key is "PM01", the management company name is "Management Company A", the offset setting for the initial guarantee fee is "Offset", the offset setting for the renewal guarantee fee is "Do not offset", and the offset setting for the additional guarantee fee is "Offset". Here, "Offset" is set for the initial guarantee fee.

[0060] (Contract conclusion process S3) In the contract conclusion process, the contract processing unit 102b inputs the contract key, contractor name, management company key, management company name, billing payment category, item key, item name, and amount of the settlement schedule data in response to, for example, operator operations on an input screen (not shown) displayed on the monitor 114, and stores them in the data file 106c.

[0061] Fig. 6(C) is a diagram showing an example of settlement schedule data registered in the contract conclusion process. In the example of settlement schedule data shown in Fig. 6(C), the first line has a contract key "001", contractor name "Contractor A", PM01 management company key "Management company A", billing payment category "Billing", item key "1001", item name "Initial guarantee fee", and amount "30,000", while the second line has a contract key "001", contractor name "Contractor A", PM01 management company key "Management company A", billing payment category "Payment", item key "1101", item name "Service commission (initial guarantee fee)", and amount "12,000".

[0062] (Settlement process S4) The settlement processing unit 102c obtains whether or not an offset setting is set from the management company master 106b using the management company and type of rent guarantee fee of the target settlement schedule data as keys, and if an offset setting is set, assigns the same settlement number and scheduled settlement date to the settlement schedule data with the same contract key, and generates settlement data in which the amount of the billing item and the payment amount are offset for each settlement number.

[0063] The item name “Initial guarantee fee” for the management company “PM01: Management Company A” in the first line of the settlement schedule data in Figure 6 (C) is set to “Offset” in the management company master 106b in Figure 6 (B), so the two details of the settlement schedule data are subject to offset, and the identical settlement number “0001” and scheduled settlement date “2021 / 01” are updated, as shown in Figure 6 (D).

[0064] Fig. 6(E) is a diagram showing an example of settlement data. The settlement schedule data shown in Fig. 6(D) is offset by the initial guarantee fee of "¥30,000" and the "service commission (initial guarantee fee)" of "¥12,000" in units of settlement number "0001", and the settlement data shown in Fig. 6(E) is created.

[0065] In the example of settlement data shown in Figure 6 (E), the settlement number is "0001," settlement date is "2021 / 01," billing payment category is "billing," billing / payee key is "PM01," billing / payee name is "Management company A," amount is "18,000," and settlement statement issuance status is "not issued." The data on whether a settlement statement has been issued is intended to prevent the mistaken sending of a settlement statement (duplicate sending).

[0066] (Invoice issuing process S5) The settlement processing unit 102c issues a statement (invoice) for settlement data whose statement issuance status is "not issued," and updates the statement issuance status of settlement data for which a statement has been issued to "issued."

[0067] The settlement processing unit 102c issues a statement (invoice) based on the settlement data of FIG. 6(F), and after issuance, updates the statement issuance status of the settlement data to "issued" as shown in FIG. 6(F).

[0068] FIG. 7 is a diagram showing sample data for explaining the case where there is no offset setting (in the case of renewal guarantee fee).

[0069] (Item Master Maintenance Processing S1) Fig. 7(A) shows an example of data setting of the item master 106a. In the example of the item master 106a shown in Fig. 7(A), the third line has an item key of "2001", an item name of "renewal guarantee fee", and a rent category of "902", and the fourth line has an item key of "2101", an item name of "outsourcing fee (renewal guarantee fee)", and a rent category of "912".

[0070] (Management company master maintenance processing S2) Fig. 7(B) is a diagram showing an example of data settings in the management company master 106b. In the example of the management company master 106b shown in Fig. 7(B), the management company key is "PM01", the management company name is "Management Company A", the offset setting for the initial guarantee fee is "Offset", the offset setting for the renewal guarantee fee is "Do not offset", and the offset setting for the additional guarantee fee is "Offset". Here, "Do not offset" is set for the renewal guarantee fee.

[0071] (Contract renewal process S3) Fig. 7(C) is a diagram showing an example of settlement schedule data registered in the contract renewal process. In the example of settlement schedule data shown in Fig. 7(C), the first line has a contract key "001", contractor name "Contractor A", PM01 management company key "Management company A", billing payment category "Billing", item key "2001", item name "Renewal guarantee fee", and amount "10,000", while the second line has a contract key "001", contractor name "Contractor A", PM01 management company key "Management company A", billing payment category "Payment", item key "2101", item name "Service commission (renewal guarantee fee)", and amount "6,000".

[0072] (Settlement process S4) The settlement processing unit 102c obtains whether or not there is an offset setting from the management company master 106b using the management company and type of rent guarantee fee of the target settlement schedule data as keys, and if there is no offset setting, the settlement processing unit 102c does not perform offsetting, and for settlement schedule data with the same contract key, it assigns different settlement numbers and the same planned settlement date for billing and payment, and generates separate settlement data for each settlement number.

[0073] The item name "Renewal Guarantee Fee" for the management company "PM01: Management Company A" in the first line of the settlement schedule data in Figure 7 (C) is set to "Do not offset" in the management company master 106b in Figure 7 (B) and is not subject to offset, so as shown in Figure 7 (D), the separate settlement numbers "0002" and "0003" and the same scheduled settlement date "2022 / 01" are updated.

[0074] Fig. 7(E) is a diagram showing an example of settlement data. For the settlement schedule data shown in Fig. 7(D), separate settlement data as shown in Fig. 7(E) is created for each of the settlement numbers "0002" and "0003".

[0075] In the example of settlement data shown in Figure 7 (E), for settlement number "0002", the settlement month and year are "2022 / 01", billing payment category "billing", billing / payee key "PM01", billing / payee name "Management company A", amount "10,000", and whether or not a settlement statement has been issued is "not issued". For settlement number "0003", the settlement month and year are "2022 / 01", billing payment category "payment", billing / payee key "PM01", billing / payee name "Management company A", amount "6,000", and whether or not a settlement statement has been issued is "not issued".

[0076] (Invoice issuing process S5) The settlement processing unit 102c issues a statement for settlement data for which the statement issuance status is "not issued," and updates the statement issuance status of settlement data for which a statement has been issued to "issued."

[0077] The settlement processing unit 102c issues a settlement statement (invoice, payment statement) based on the settlement data of FIG. 7(E), and after issuance, updates the statement issuance status of the settlement data to "issued" as shown in FIG. 7(F).

[0078] As described above, according to this embodiment, there is provided a master in which the presence or absence of offset settings for each type of rent guarantee fee are registered for each management company, a contract processing means for inputting settlement schedule data including contract identification information, contract holder name, management company, billing and payment category of billing or payment to the management company, type of rent guarantee fee which is a billing item or type of fee which is a payment item, and amount, and a settlement processing means for obtaining the presence or absence of offset settings from the master for the target settlement schedule data using the management company and type of rent guarantee fee as keys, and generating settlement data based on the obtained presence or absence of offset settings. Therefore, it is possible to reduce clerical errors made by personnel at the rent guarantee company when calculating amounts for billing guarantee fees to management companies and paying outsourcing fees, and to improve the speed and accuracy of calculation of billing and payment amounts.

[0079] [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 goals 8 and 9 of the SDGs.

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

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

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

[0083] 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.

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

[0085] Moreover, with regard to the offset processing device 100, the components shown in the figures are merely functional concepts, and the device does not necessarily have to be physically configured as shown in the figures.

[0086] For example, the processing functions of the offsetting device 100, particularly the processing functions 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, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is mechanically read by the offsetting device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.

[0087] In addition, this computer program may be stored in an application program server connected to the offset processing device 100 via any network, and it is also possible to download all or a part of it as necessary.

[0088] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "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.

[0089] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. 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, may use well-known configurations and procedures.

[0090] The various databases etc. 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 etc. used for various processes and providing websites.

[0091] The offsetting device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The offsetting device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

[0092] 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 functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Explanation of symbols]

[0093] 100 Offsetting device 102 Control section 102a Master Maintenance Department 102b Contract Processing Department 102c Payment Processing Unit 102d Journal entry processing section 102e Screen display control unit 104 Communication interface section 106 Storage section 106a Item Master 106b Management company master 106c Data File 108 Input / Output Interface Section 112 Input Devices 114 Output Device 300 Network

Claims

1. An offsetting device that includes a memory unit and a control unit and offsets a rent guarantee fee and a commission fee, The storage unit includes: Master data is stored for each management company, with or without offset settings for each type of rent guarantee fee. The control unit is a contract processing means for inputting settlement schedule data including contract identification information, the name of the contractor, the management company, the billing or payment category of the bill or payment to the management company, the type of rent guarantee fee which is a billing item, or the type and amount of fees which are payment items; A settlement processing means for acquiring the presence or absence of offset settings from the master with the management company and the type of rent guarantee fee as keys for the target settlement schedule data, and generating settlement data based on the presence or absence of the acquired offset settings; Equipped with The settlement processing means includes: If offsetting is enabled, the system generates settlement data that offsets the amount of the invoice item and the amount of the payment item. If offsetting is not set, separate settlement data is generated for billing and payment. Furthermore, the settlement processing means If offsetting is enabled, the same settlement number is assigned to the settlement schedule data for the same contract identification information for billing and payment, and settlement data is generated by offsetting the amount of the billing item and the amount of the payment item for each settlement number. When there is no offset setting, the offset processing device assigns different settlement numbers for billing and payment to the settlement schedule data for the same contract identification information, thereby generating separate settlement data for each settlement number.

2. 2. The offset processing device according to claim 1, wherein the types of the rent guarantee fee include an initial guarantee fee, a renewal guarantee fee, and an additional guarantee fee.

3. 3. The offset processing device according to claim 1, wherein the settlement processing means issues a statement based on the settlement data.

4. An offsetting method executed by an information processing device having a storage unit and a control unit, The storage unit includes: Master data is stored for each management company, with or without offset settings for each type of rent guarantee fee. Executed in the control unit, a contract processing step of inputting settlement schedule data including contract identification information, the name of the contractor, the management company, the billing or payment category of the bill or payment to the management company, the type of rent guarantee fee which is a billing item or the type and amount of the fee which is a payment item; A settlement processing step for acquiring the presence or absence of offset settings from the master data for the target settlement schedule data using the management company and the type of rent guarantee fee as keys, and generating settlement data based on the presence or absence of the acquired offset settings; Including, In the settlement processing step, If offsetting is enabled, the system generates settlement data that offsets the amount of the invoice item and the amount of the payment item. If offsetting is not set, separate settlement data is generated for billing and payment. Furthermore, in the settlement processing step, If offsetting is enabled, the same settlement number is assigned to the settlement schedule data for the same contract identification information for billing and payment, and settlement data is generated by offsetting the amount of the billing item and the amount of the payment item for each settlement number. This offset processing method is characterized in that, when there is no offset setting, different settlement numbers are assigned to billing and payment to the settlement schedule data for the same contract identification information, and separate settlement data is generated for each settlement number.

5. An offset processing program to be executed by an information processing device having a storage unit and a control unit, The storage unit includes: Master data is stored for each management company, with or without offset settings for each type of rent guarantee fee. The control unit, a contract processing step of inputting settlement schedule data including contract identification information, the name of the contractor, the management company, the billing or payment category of the bill or payment to the management company, the type of rent guarantee fee which is a billing item or the type and amount of the fee which is a payment item; A settlement processing step for acquiring the presence or absence of offset settings from the master data for the target settlement schedule data using the management company and the type of rent guarantee fee as keys, and generating settlement data based on the presence or absence of the acquired offset settings; This is an offsetting program for executing In the settlement processing step, If offsetting is enabled, the system generates settlement data that offsets the amount of the invoice item and the amount of the payment item. If offsetting is not set, separate settlement data is generated for billing and payment. Furthermore, in the settlement processing step, If offsetting is enabled, the same settlement number is assigned to the settlement schedule data for the same contract identification information for billing and payment, and settlement data is generated by offsetting the amount of the billing item and the amount of the payment item for each settlement number. This offset processing program is characterized in that, when there is no offset setting, different settlement numbers are assigned to billing and payment for the settlement schedule data of the same contract identification information, and separate settlement data is generated for each settlement number.

Images