Countermeasure processing device, countermeasure processing method, and countermeasure processing program

Abstract

To enhance the efficiency of transfer of money with a management company by making a cancellation with a storage rent in the case where a rent guarantee company subrogates an overdue rent of a contractor for the proprietary company and the contractor pays part or all of the overdue rent to the management company, resulting in an overlapping payment.SOLUTION: When there is a report of payment of an overdue rent by a contractor from a management company, a cancellation handling device generates overlapping payment data including overlapping payment identification information, a payment number, a handling method designating a cancellation or a request for refund, and a payment amount, and a payment deletion data including the payment number, a payment deletion date, collection schedule identification information, a main body amount, and a deleted amount, updates the deleted amount in the collection schedule data to the deleted amount of the payment deletion data using the collection schedule identification information as a key, and when the handling method for the overlapping payment data is a cancellation, generates cancellation schedule data including the overlapping payment identification information, the cancellation schedule identification information, a cancellation object item, a contraction number, the main body amount, and a rent month being the next month of a non-paying month on the basis of the collection schedule data.SELECTED DRAWING: Figure 1

Description

Technical Field

[0004] ,

[0006] , , , , , ,

[0005] , , ,

[0003] , , , ,

[0001] The present invention relates to a set-off processing device, a set-off processing method, and a set-off processing program.

Background Art

[0002] For example, when a rental guarantee company subrogates and pays the overdue rent of a contractor to a management company, and the contractor deposits part or all of the overdue rent with the management company, resulting in duplicate deposits, when there is a deposit report from the management company, there is a business of withdrawing the claim for overdue rent from the contractor and claiming a refund of the rent from the management company. Conventionally, as a system related to rental guarantee, for example, there is Patent Document 1.

Prior Art Documents

Patent Documents

[0007] Furthermore, according to one aspect of the present invention, the duplicate deposit registration means may generate a revenue entry based on the offsetting schedule data.

[0008] Furthermore, according to one aspect of the present invention, the control unit may also be provided with billing calculation processing means that calculates the rent to be collected for the current month based on the monthly rent amount in the contract data in the following month and generates data for the collection schedule for the current month.

[0009] Furthermore, according to one aspect of the present invention, the control unit may also include a remittance calculation processing means that generates payment request data for the current month's payment amount based on the collection schedule data, and, if offset schedule data exists, generates payment request data for deducting the offset amount from the current month's payment amount based on the offset schedule data.

[0010] Furthermore, according to one aspect of the present invention, the control unit may also include payment settlement input means for generating payment settlement data including a payment settlement number, payee, payee account, payment date, and principal amount when settlement is completed based on the payment request data.

[0011] Furthermore, according to one aspect of the present invention, the payment settlement input means may generate payment settlement journal entries based on the payment request data.

[0012] To solve the above-mentioned problems and achieve the objective, the present invention provides an offsetting method for performing offsetting when a rent guarantee company pays a tenant's delinquent rent to a management company on their behalf, and the tenant pays part or all of the delinquent rent to the management company, wherein the control unit is configured to access contract data including contract number, management company, tenant, agency method, and monthly rent; collection schedule data including collection schedule identification information, contract number, billing address, item, rent month, principal amount, and settled amount; and payment request data including payment request identification information, payee, contract number, item, principal amount, rent month, and payment status, and the control unit performs offsetting when an information processing device equipped with a control unit performs offsetting The system is characterized by including a duplicate payment registration step, in which, when a contract holder reports payment of overdue rent, duplicate payment data is generated, including duplicate payment identification information, payment number, processing method specifying offset or refund request, and payment amount, and payment reconciliation data is generated, including payment number, payment reconciliation date, collection schedule identification information, principal amount, and reconciled amount; the reconciled amount in the collection schedule data is updated to the reconciled amount in the payment reconciliation data using the collection schedule identification information as a key; and, if the processing method for the duplicate payment data is offset, offset schedule data is generated based on the collection schedule data, including duplicate payment identification information, offset schedule identification information, items to be offset, contract number, principal amount, and rent month which is the month following the month of arrears.

[0013] To solve the above-mentioned problems and achieve the objective, the present invention provides an offsetting processing program for an information processing device equipped with a control unit, which is to be executed when a rent guarantee company pays a tenant's delinquent rent to a management company on their behalf, and the tenant pays part or all of the delinquent rent to the management company, wherein the control unit is configured to access contract data including contract number, management company, tenant, agency method, and monthly rent; collection schedule data including collection schedule identification information, contract number, billing address, item, rent month, principal amount, and settled amount; and payment request data including payment request identification information, payee, contract number, item, principal amount, rent month, and payment status, and the control unit is configured to access information processing devices equipped with a control unit that have received payment from the management company for the tenant's delinquent rent. The offsetting processing program is characterized by executing a duplicate payment registration process that, upon receiving a report of rent payment, generates duplicate payment data including duplicate payment identification information, payment number, processing method specifying offset or refund request, and payment amount, and payment reconciliation data including payment number, payment reconciliation date, collection schedule identification information, principal amount, and reconciled amount, updates the reconciled amount in the collection schedule data to the reconciled amount in the payment reconciliation data using the collection schedule identification information as a key, and, if the processing method for the duplicate payment data is offset, generates offset schedule data including duplicate payment identification information, offset schedule identification information, items to be offset, contract number, principal amount, and rent month following the month of arrears, based on the collection schedule data. [Effects of the Invention]

[0014] According to the present invention, when a rent guarantee company pays the tenant's delinquent rent to the management company on their behalf, and the tenant pays part or all of the delinquent rent to the management company, resulting in duplicate payments, the payment can be offset against the collected rent, thereby streamlining the exchange of money with the management company. [Brief explanation of the drawing]

[0015] [Figure 1] Figure 1 is a block diagram showing an example of the configuration of the counteracting apparatus according to this embodiment. [Figure 2]Figure 2 is a diagram showing the correlation among offset planned data, payment request data, collection planned data, breakdown data of subrogation repayment collection plan, and subrogation repayment data. [Figure 3] Figure 3 is a diagram showing a flow for explaining an overview of the overall processing of the control unit of the offset processing apparatus according to the present embodiment. [Figure 4] Figure 4 is a diagram for explaining a specific example of the processing of the control unit of the offset processing apparatus according to the present embodiment. [Figure 5A] Figure 5A is a diagram for explaining a specific example of the processing of the control unit of the offset processing apparatus according to the present embodiment. [Figure 5B] Figure 5B is a diagram for explaining a specific example of the processing of the control unit of the offset processing apparatus according to the present embodiment. [Figure 5C] Figure 5C is a diagram for explaining a specific example of the processing of the control unit of the offset processing apparatus according to the present embodiment. [Figure 6] Figure 6 is a diagram for explaining a specific example of the processing of the control unit of the offset processing apparatus according to the present embodiment. [Figure 7] Figure 7 is a diagram for explaining a specific example of the processing of the control unit of the offset processing apparatus according to the present embodiment. [Figure 8A] Figure 8A is a diagram for explaining a specific example of the processing of the control unit of the offset processing apparatus according to the present embodiment. [Figure 8B] Figure 8B is a diagram for explaining a specific example of the processing of the control unit of the offset processing apparatus according to the present embodiment. Embodiments for Carrying Out the Invention

[0016] Hereinafter, embodiments of an offset processing apparatus, an offset processing method, and an offset processing program according to the present invention will be described in detail based on the drawings. Note that the present invention is not limited to these embodiments.

[0017] [1. Overview] For example, when a rental guarantee company subrogates and pays the overdue rent of a contractor to a management company, and the contractor deposits part or all of the overdue rent with the management company, resulting in duplicate deposits, when there is a deposit report from the management company, there is a process of withdrawing the claim for overdue rent against the contractor and claiming a refund of the rent from the management company.

[0018] This process occurs after the subrogation payment of overdue rent to the management company. For example, in the case of a collection agency contract, some management companies have a need to offset the rent with the collected rent of the designated rent month in order to reduce the effort of paying the refund claim and the transfer fee.

[0019] Conventionally, a rental guarantee company claims a refund to the management company after reporting a duplicate rent deposit. However, to meet the need of offsetting with the rent of the next month from the management company, the reduction and payment of the payment amount (the remittance amount of the collected rent) were carried out outside the system. The offsetting of rent is a complex and cumbersome task for systemization, such as the upper limit of offsetable rent and the transfer of accounting entries at the time of offsetting. Since the operations were carried out outside the system or by creating separate ACCESS, etc., the transfer of money with the management company could not be carried out efficiently.

[0020] Therefore, in this embodiment, when a rental guarantee company subrogates and pays the overdue rent of a contractor to a management company, and the contractor deposits part or all of the overdue rent with the management company, resulting in duplicate deposits, the offsetting with the collected rent is carried out to improve the efficiency of the transfer of money with the management company.

[0021] The offsetting processing device of this embodiment can be preferably used in the rental guarantee industry. The offsetting processing device of this embodiment has the following functions (1) and (2).

[0022] (1) Based on the deposit report from the management company, when using duplicate deposits to offset claims for overdue rent, a function to specify whether to claim a refund or offset the rent, and when offsetting the rent is specified, create offset planned data with the collected rent of the designated rent month. (2) When calculating the amount to be remitted for collected rent, if there is data to be offset, a function to deduct the offset amount from the amount of rent to be remitted and create payment request data.

[0023] [2. Structure] The configuration of the offsetting processing device 100 according to this embodiment will be described with reference to Figure 1. Figure 1 is a block diagram showing an example of the configuration of the offsetting processing device 100 according to this embodiment. The offsetting processing device 100 according to this embodiment can be suitably used, for example, by a rent guarantee company. Below, we will describe a case in which a rent guarantee company pays the delinquent rent of a tenant to a management company on their behalf, and when a duplicate payment occurs because the tenant pays part or all of the delinquent rent to the management company, the offsetting of the payment with the collected rent will be performed to streamline the exchange of money with the management company.

[0024] The offsetting device 100 is a workstation or a commercially available desktop personal computer. However, the offsetting device 100 is not limited to stationary information processing devices such as desktop personal computers; it may also be a portable information processing device such as a commercially available notebook computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

[0025] As shown in Figure 1, the offsetting processing device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the offsetting processing device 100 is connected to communicate via any communication path.

[0026] The communication interface unit 104 connects the offsetting 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 the function of communicating data with other devices via a communication line. Here, the network 300 has the function of connecting the offsetting device 100 and the server 200, etc., in a way that enables mutual communication, and is, for example, the internet or a LAN (Local Area Network). The data stored in the storage unit 106, which will be described later, may also be stored on the server.

[0027] The input / output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, mouse, microphone, or a monitor that works in conjunction with a mouse to provide pointing device functionality. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 as the keyboard 112 or mouse 112. Furthermore, the act of a user operating the input device 112 on the screen of the output device (monitor) 114 may be referred to as "user operation via UI".

[0028] The storage unit 106 stores various databases, tables, and files. The storage unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 also stores the journal entry pattern master 106a, contract data, subrogation payment data, subrogation payment collection schedule breakdown data, collection schedule data, payment request data, duplicate payment data, payment data, payment reconciliation data, offsetting schedule data, payment settlement data, etc. Figure 2 shows the correlation between offsetting schedule data, payment request data, collection schedule data, subrogation payment collection schedule breakdown data, and subrogation payment data.

[0029] The journal entry pattern master 106a can consist of tables that associate and register items, revenue recognition criteria, accounts receivable, revenue accounts, payment recognition criteria, accounts payable, and payment accounts (see Figure 5C). The journal entry pattern master 106a is referenced when creating revenue generation journal entries and payment settlement journal entries.

[0030] Contract data may include contract number, management company, contract holder, agency method, and monthly rent.

[0031] Subrogation payment data may include the subrogation payment number, contract number, management company, amount of arrears, and rent month.

[0032] The data detailing the planned subrogation payment may include the subrogation payment number, item, planned collection GUID (planned collection identification information), payment request GUID (payment request identification information), principal amount, and consumption tax amount.

[0033] The collection schedule data may include the collection schedule GUID (collection schedule identification information), contract number, billing address, item (e.g., rent, variable costs), rent month, base amount, consumption tax amount, and reconciled amount.

[0034] Duplicate deposit data may include the Duplicate Deposit Guid (Duplicate Deposit Identifier), Deposit Number, Processing Method (1: Offset, 0: Normal (Refund Request)), and Deposit Amount.

[0035] Deposit data may include deposit number, deposit date, and deposit account.

[0036] The offsetting schedule data may include the duplicate deposit GUID, offsetting schedule GUID, item (e.g., rent (offset), variable expenses (offset)), contract number, base amount (offset amount), consumption tax amount, rent month, payment request GUID (payment identification information), and offset payment request GUID (offset identification information). The offsetting schedule data is created when the processing method for duplicate deposit data is "1: Offset".

[0037] Payment request data may include payment request GUID (payment request identification information), payee, contract number, item (e.g., rent, rent (offset), variable expenses, variable expenses (offset)), base amount (payment amount), consumption tax amount, rent month, and payment status.

[0038] Payment settlement data may include payment settlement number, payee, payee account, payment date, and the amount due.

[0039] The control unit 102 is a CPU or the like that comprehensively controls the offsetting processing unit 100. The control unit 102 has an internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.

[0040] The control unit 102 is configured to access the journal entry pattern master 106a, contract data, subrogation payment data, subrogation payment collection schedule breakdown data, collection schedule data, payment request data, duplicate payment data, payment data, payment reconciliation data, offset schedule data, payment settlement data, etc., which are stored in the storage unit 106. Note that the journal entry pattern master 106a, contract data, subrogation payment data, subrogation payment collection schedule breakdown data, collection schedule data, payment request data, duplicate payment data, payment data, payment reconciliation data, offset schedule data, payment settlement data, etc. may be stored in another location (for example, on the server 200), as long as the control unit 102 can access them.

[0041] Functionally, the control unit 102 comprises a data registration unit 102a, a duplicate deposit registration unit 102b, a billing calculation processing unit 102c, a remittance calculation processing unit 102d, a payment settlement input unit 102e, a master maintenance unit 102f, and a screen display control unit 102g.

[0042] The data registration unit 102a generates and updates contract data, subrogation payment data, and subrogation payment recovery breakdown data, etc., in response to operator operations on an input screen (not shown) displayed on the monitor 114, and registers them in the storage unit 106.

[0043] The duplicate deposit registration unit 102b generates and updates duplicate deposit data, deposit data, deposit reconciliation data, collection schedule data, offset schedule data, etc., in response to operator operations on an input screen (not shown) displayed on the monitor 114, and registers them in the storage unit 106.

[0044] Specifically, when the management company reports a payment of overdue rent by a tenant, the duplicate payment registration unit 102b generates duplicate payment data including duplicate payment identification information, payment number, processing method specifying offset or refund request, and payment amount, and payment reconciliation data including payment number, payment reconciliation date, collection schedule identification information, principal amount, consumption tax amount, and reconciled amount. Using the collection schedule identification information as a key, it updates the reconciled amount in the collection schedule data to the reconciled amount in the payment reconciliation data. If the processing method for the duplicate payment data is offset, it creates offset schedule data based on the collection schedule data, including duplicate payment identification information, offset schedule identification information, items to be offset, contract number, principal amount (offset schedule amount), consumption tax amount, and rent month which is the month following the month of arrears.

[0045] The duplicate deposit registration unit 102b generates a revenue-generating journal entry by referring to the journal entry pattern master 106a based on the offsetting schedule data.

[0046] The billing calculation processing unit 102c calculates the monthly rent to be collected for the current month based on the monthly rent amount in the contract data, and generates the data for the expected collection for the current month.

[0047] The remittance calculation processing unit 102d generates and updates duplicate deposit data, deposit data, deposit reconciliation data, collection schedule data, offset schedule data, etc., in response to, for example, the operator's operations on an input screen (not shown) displayed on the monitor 114, and registers them in the storage unit 106.

[0048] Specifically, the remittance calculation processing unit 102d generates payment request data for the current month's payment amount (rent remittance) based on the collection schedule data, and if offset schedule data exists, it generates payment request data that deducts the offset amount from the current month's payment amount based on the offset schedule data.

[0049] When a payment is completed based on the payment request data, the payment settlement input unit 102e generates payment settlement data including the payment settlement number, payee, payee account, payment date, and principal amount, and registers it in the storage unit 106. The payment settlement input unit 102e also generates payment settlement journal entries based on the payment request data by referring to the journal entry pattern master 106a.

[0050] The master maintenance unit 102f is used to configure settings such as data input, addition, modification, and update for the journal entry pattern master 106a in response to operator operations on a master maintenance screen (not shown).

[0051] The screen display control unit 102g controls the display of various input screens to be shown on the monitor 114 and the reception of their inputs.

[0052] [3. Specific examples of processing] Referring to Figures 1 to 8B, a specific example of the processing performed by the control unit 102 of the offsetting device 100 in this embodiment will be described. Figures 3 to 8B are diagrams illustrating a specific example of the processing performed by the control unit 102 of the offsetting device 100 in this embodiment. In the following description, all monetary units will be in "yen (¥)", and the notation may be omitted.

[0053] (3-1: Overall processing) Figure 3 is a flowchart illustrating the overall processing outline of the control unit 102 of the counterfeit processing device 100 in this embodiment. The overall processing outline of the control unit 102 of the counterfeit processing device 100 in this embodiment will be explained with reference to Figure 3.

[0054] In Figure 3, the duplicate payment registration unit 102b executes the duplicate payment registration process (step S1). Specifically, in the duplicate payment registration process, when the management company reports a payment of overdue rent by a tenant, the duplicate payment registration unit 102b generates duplicate payment data including duplicate payment identification information, payment number, processing method specifying offset or refund request, and payment amount, and payment reconciliation data including payment number, payment reconciliation date, collection schedule identification information, principal amount, consumption tax amount, and reconciled amount. Using the collection schedule identification information as a key, it updates the reconciled amount in the collection schedule data to the reconciled amount in the payment reconciliation data. If the processing method for the duplicate payment data is offset, it creates offset schedule data based on the collection schedule data, including duplicate payment identification information, offset schedule identification information, items to be offset, contract number, principal amount (offset schedule amount), consumption tax amount, and rent month which is the month following the month of arrears. The duplicate payment registration unit 102b also generates a revenue generation journal entry by referring to the journal entry pattern master 106a based on the offset schedule data.

[0055] The billing calculation processing unit 102c performs the billing calculation process (step S2). Specifically, the billing calculation processing unit 102c calculates the rent to be collected for the current month based on the monthly rent in the contract data for the following month, and generates the data for the collection schedule for the current month.

[0056] The remittance calculation processing unit 102d executes the remittance calculation process (step S3). Specifically, in the remittance calculation process, the remittance calculation processing unit 102d generates payment request data for the current month's payment amount (rent remittance) based on the collection schedule data. In addition, if offset schedule data exists, the remittance calculation processing unit 102d generates payment request data that deducts the offset amount from the current month's payment amount based on the offset schedule data.

[0057] The payment settlement input unit 102e executes the payment settlement input process (step S4). Specifically, in the payment settlement input process, when a settlement is completed based on the payment request data, the payment settlement input unit 102e generates payment settlement data including the payment settlement number, payee, payee account, payment date, and principal amount. The payment settlement input unit 102e also generates a payment settlement journal entry based on the payment request data by referring to the journal entry pattern master 106a.

[0058] (3-2: Sample Data) Figures 4 to 8B are diagrams showing sample data to illustrate a specific example of the processing performed by the control unit 102 of the offsetting processing device 100 in this embodiment. An example of the business flow of this embodiment will be explained with reference to Figures 4 to 8B.

[0059] (Assumption data) The memory unit 106 is assumed to have pre-registered contract data, subrogation payment data, subrogation payment recovery breakdown data, recovery schedule data, and payment request data as shown in Figure 4.

[0060] The contract data includes fields for contract number, management company, contract holder, agency method (e.g., collection agency, delinquency reporting), and monthly rent. In the example shown in the diagram, the first row contains contract number "0000000001", management company "Management Company A", contract holder "Contract Holder 1", agency method "Collection Agency", and monthly rent "100,000", while the second row contains contract number "0000000002", management company "Management Company B", contract holder "Contract Holder 2", agency method "Delinquency Reporting", and monthly rent "80,000".

[0061] The subrogation payment data includes the following fields: subrogation payment number, contract number, management company, amount in arrears, and rent month. In the example shown in the diagram, the first row contains the subrogation payment number "000000000001", contract number "0000000001", management company "Management Company A", amount in arrears "100,000", and rent month "October". The second row contains the subrogation payment number "000000000002", contract number "0000000002", management company "Management Company B", amount in arrears "3,000", and rent month "October".

[0062] The data for the breakdown of planned subrogation payments includes the following fields: subrogation payment number, item, planned collection GUID, payment request GUID, base amount, and consumption tax amount. In the example shown in the figure, the first row is: subrogation payment number "000000000001", item "rent", planned collection GUID "AAAA", payment request GUID "DDDD", base amount "100,000", consumption tax amount "0", and the second row is: subrogation payment number "000000000002", item "variable expenses", planned collection GUID "BBBB", payment request GUID "EEEE", base amount "3,000", consumption tax amount "300".

[0063] The collection schedule data includes the following fields: Collection Schedule Guid, Contract Number, Billing Address, Item, Rent Month, Base Amount, Consumption Tax Amount, and Reconciled Amount. In the example shown in the diagram, the first row contains: Collection Schedule Guid "AAAA", Contract Number "0000000001", Billing Address "Contractor 1", Item "Rent", Rent Month "October", Base Amount "100,000", Consumption Tax Amount "0", Reconciled Amount "0", and the second row contains: Collection Schedule Guid "BBBB", Contract Number "0000000002", Billing Address "Contractor 2", Item "Variable Cost", Rent Month "October", Base Amount "3,000", Consumption Tax Amount "300", Reconciled Amount "0".

[0064] The payment request data includes the following fields: payment request GUID, payee, contract number, item, base amount, consumption tax amount, rent month, and payment status. In the example shown in the diagram, the first row has the payment request GUID "DDDD", payee "Management Company A", contract number "0000000001", item "rent", base amount "100,000", consumption tax amount "0", rent month "October", and payment status "paid". The second row has the payment request GUID "EEEE", payee "Management Company B", contract number "0000000002", item "variable expenses", base amount "3,000", consumption tax amount "300", rent month "October", and payment status "paid".

[0065] (S1: Duplicate deposit registration processing) Refer to Figures 5A to 5C to explain a specific example of duplicate payment registration processing. The following example explains how to reconcile overdue rent payments based on a payment report from the management company (reported on 2023 / 10 / 23), specify the rent month to be offset, and create offsetting schedule data. In this example, we will explain how to offset a duplicate payment (payment report amount 50,000: partial payment) for contract number: 0000000001 from the November rent when a payment report is generated for overdue rent for October.

[0066] Figure 5A shows the data flow. When the management company reports a payment of overdue rent by a tenant (payment amount: 50,000), duplicate payment data is generated and registered in the storage unit 106. The duplicate payment data includes the fields for duplicate payment identification information, payment number, processing method (1: offset, 0: normal (refund request)), and payment amount. In the example shown in the figure, the duplicate payment Guid is "aaaaa", the payment number is "1234567890", and the processing method is "1: offset". If the processing method is "1: offset", offset scheduled data is generated.

[0067] The system generates deposit data and registers it in the storage unit 106. The deposit data includes the fields for deposit number, deposit date, and deposit account. In the example shown in the figure, the deposit number is "1234567890", the deposit date is "2023 / 10 / 20", and the deposit account is "Dummy".

[0068] The payment reconciliation data is generated and registered in the storage unit 106. The payment reconciliation data includes the following items: payment number, payment reconciliation date, collection schedule GUID, base amount, consumption tax amount, and reconciled amount. In the example shown in the figure, the payment number is "1234567890", payment reconciliation date is "2023 / 10 / 20", collection schedule GUID is "AAAA", base amount is "50,000", consumption tax amount is "0", and reconciled amount is "50,000".

[0069] Using the collection schedule identification GUID as the key, the reconciled amount in the collection schedule data is updated to the reconciled amount in the payment reconciliation data. In this example, for the arrears rent of "100,000", a payment of ¥50,000 is applied using the payment reconciliation data with payment number "1234567890", and the reconciled amount in the collection schedule data is updated from "0" to "50,000".

[0070] Based on the collection schedule data, offset schedule data is generated and registered in the storage unit 106. The offset schedule data includes the following items: duplicate deposit Guid, offset schedule Guid, item, contract number, base amount, consumption tax amount, rent month, payment request Guid, and offset payment request Guid. In this example, a deposit of ¥50,000 for the October overdue rent will be offset against the November rent for the following month. In the example shown in the figure, the duplicate deposit Guid is "aaaaa", the offset schedule Guid is "XXXX", the item is "rent (offset)", the contract number is "0000000001", the base amount is "50,000", the consumption tax amount is "0", the rent month is "November", the payment request Guid is " ", and the offset payment request Guid is " ".

[0071] Figure 5B is a diagram illustrating the offsetting limit check during offsetting. An offsetting limit check is performed during offsetting. When registering the offset, the monthly rent in the contract data and the reported payment amount (planned offsetting amount: "base amount" in the planned offsetting data) are verified. If a reported payment amount exceeding the monthly rent is specified, an error is generated because there are no funds available for offsetting. Monthly rent < reported amount → Error, Monthly rent = reported amount → OK, Monthly rent > reported amount → OK.

[0072] Figure 5C is a diagram illustrating journal entry accounting (system accounting). The journal entry pattern master 106a can consist of tables that associate and register items, revenue recognition criteria, accounts receivable, revenue accounts, payment recognition criteria, accounts payable, and payment accounts. In the example shown in the figure, the first row is item "Rent", revenue recognition criteria "Received", accounts receivable "-", revenue account "Advance Payment", payment recognition criteria "Disbursement", accounts payable "-", and payment account "Advance Payment". The second row is item "Rent (Offset)", revenue recognition criteria "Occurred", accounts receivable "Rent Offset", revenue account "Advance Payment", payment recognition criteria "Disbursement", accounts payable "-", and payment account "Rent Offset".

[0073] Based on the offsetting schedule data, the journal entry for generating income is generated by referring to journal entry pattern master 106a. In the example shown in the figure, the item is "Rent (Offset)" and the income recognition basis is "Generated," so the journal entry for generating income dated 10 / 20 will be Rent Offset: ¥50,000 / Advance Payment: ¥50,000.

[0074] (S2: Invoice calculation processing) Refer to Figure 6 to explain a specific example of the billing calculation process. Based on the monthly rent in the contract data, the rent to be collected for the current month is calculated, and collection schedule data is generated. In this example, collection schedule data for November's rent is created.

[0075] Figure 6 shows the data flow. In Figure 6, the collection schedule data for the current month is generated based on the contract data. As shown in the figure, the third row of the collection schedule data is generated and added with the collection schedule GUID "DDDD", contract number "0000000001", billing recipient "Contractor 1", item "Rent", rent month "November", base amount "100,000", consumption tax amount "0", and settled amount "0".

[0076] (S3: Remittance calculation process) Refer to Figure 7 to explain a specific example of the remittance calculation process. Based on the contract rent, the remittance amount for the current month is calculated, and based on the offsetting scheduled data created in the duplicate payment processing, the offsetting amount is deducted from the payment amount to create payment request data for the November rent.

[0077] In this example, for the payment request data for the November rent with the collection schedule GUID "FFFF" for the collection schedule GUID "DDDD" of the collection schedule data created in the billing calculation process S2, if there is a planned offset data, a payment request GUID "GGGG" for the payment offset is generated. Then, a payment instruction for the November rent is issued.

[0078] First, update the remittance number for the scheduled remittance data with the scheduled remittance GUID "DDDD" to "1234".

[0079] Next, for data where the contract number, rent month, and items in the planned offset data match, the base amount and consumption tax amount from the payment request data are deducted. Specifically, on the third row of the payment request data, a record is generated and added with payment request Guid "FFFF", payee "Management Company A", contract number "0000000001", item "Rent", base amount "100,000", consumption tax amount "0", rent month "November", payment status "Before payment", and remittance number "1234", based on the planned collection Guid "DDDD" record in the planned collection data.

[0080] For the record with payment request GUID "FFFF", a payment offset (deduction) record is generated and added to the 4th row with payment request GUID "GGGG", payee "Management Company A", contract number "0000000001", item "Rent (offset)", base amount "-50,000", consumption tax amount "0", rent month "November", payment status "Before payment", and remittance number "1234".

[0081] The payment of ¥50,000 for the overdue rent for October will be offset against the rent for the following month, November. In the offsetting schedule data, the offsetting payment request GUID will be updated to "FFFF" from the payment request GUID in the payment request data, and the payment request GUID will be updated to "GGGG" from the payment request GUID in the payment request data.

[0082] (S4: Payment settlement input processing) Refer to Figures 8A and 8B to explain a specific example of payment settlement input processing. A CASHOUT settlement will be performed based on the payment request data for November. The payment date will be 2023 / 11 / 10.

[0083] Figure 8A shows the data flow. Once the November settlement is completed, the payment status of the payment request records with payment request GUIDs "FFFF" and "GGGG" in the payment request data is updated to "Paid" and the payment settlement number is updated to "98765".

[0084] Next, payment settlement data is generated based on the payment request data. The payment settlement data includes the following fields: payment settlement number, payee, payee account, payment date, base amount, and consumption tax amount. In the example shown in the figure, the payment settlement data is: payment settlement number "98765", payee "Management Company A", payee account "01", payment date "2023 / 11 / 10", base amount "50,000", and consumption tax amount "0".

[0085] Figure 8B is a diagram illustrating journal entry accounting (system accounting). Based on payment request data, the system generates payment settlement journal entries (disbursement journal entries) by referring to journal entry pattern master 106a. In the example shown in the figure, for payment request Guid "FFFF", the item is "Rent" and the payment accounting basis is "Disbursement", so a journal entry of Advance Payment: ¥100,000 / CASH: ¥100,000 is created. Similarly, for payment request Guid "GGGG", the item is "Rent (Offset)" and the payment accounting basis is "Disbursement", so a journal entry of CASH: ¥50,000 / Rent Offset: ¥50,000 is created.

[0086] As described above, according to this embodiment, when a management company reports a payment of overdue rent by a tenant, the system generates duplicate payment data including duplicate payment identification information, payment number, processing method specifying offset or refund request, and payment amount, and payment reconciliation data including payment number, payment reconciliation date, collection schedule identification information, principal amount, and reconciled amount. The system updates the reconciled amount in the collection schedule data to the reconciled amount in the payment reconciliation data using the collection schedule identification information as a key. If the processing method for the duplicate payment data is offset, the system generates offset schedule data based on the collection schedule data, including duplicate payment identification information, offset schedule identification information, items to be offset, contract number, principal amount, and rent month for the month following the month of arrears. Therefore, when a rent guarantee company pays the tenant's overdue rent to the management company on their behalf, and the tenant pays part or all of the overdue rent to the management company, resulting in a duplicate payment, the system can offset the payment against the collected rent, thereby streamlining the exchange of money with the management company.

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

[0088] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.

[0089] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.

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

[0091] 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 by known methods.

[0092] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.

[0093] Furthermore, with respect to the counteracting device 100, each component shown in the illustration is a functional concept and does not necessarily need to be physically configured as shown.

[0094] For example, the processing functions of the offsetting processing unit 100, particularly those performed by the control unit 102, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for the information processing device to execute the processing described in this embodiment, and is mechanically read by the offsetting processing unit 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) contains a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.

[0095] Furthermore, this computer program may be stored on an application program server connected to the counteracting processing unit 100 via any network, and it is possible to download all or part of it as needed.

[0096] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.

[0097] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.

[0098] The various databases stored in the memory unit 106 include memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0099] Furthermore, the offsetting processing device 100 may be configured as an information processing device such as a known personal computer or workstation, or as an information processing device to which any peripheral device is connected. Alternatively, the offsetting processing device 100 may be implemented by implementing software (including programs or data, etc.) that realizes the processing described in this embodiment on the device.

[0100] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Explanation of Symbols]

[0101] 100 Countermeasure Processing Device 102 Control Unit 102a Data Registration Section 102b Duplicate Deposit Registration Section 102c Billing Calculation Processing Unit 102d Remittance Calculation Processing Unit 102e Payment Settlement Input Section 102f Master Maintenance Department 102g Screen Display Control Unit 104 Communication Interface Section 106 Storage section 106a Journal Entry Pattern Master 108 Input / Output Interface Section 112 Input device 114 Output device 300 Networks

Claims

1. An offsetting processing device equipped with a control unit, which performs offsetting when a rent guarantee company pays the tenant's delinquent rent to the management company on their behalf, and the tenant pays part or all of the delinquent rent to the management company, The control unit, Contract data including contract number, management company, contract holder, agency method, and monthly rent, Collection schedule data including collection schedule identification information, contract number, billing address, item, rent month, base amount, and reconciled amount, Payment request data including payment request identification information, payee, contract number, item, base amount, rent month, and payment status, It is configured to be accessible, An offsetting processing device is characterized by comprising a duplicate payment registration means that, upon receiving a report from a management company of a tenant's payment of overdue rent, generates duplicate payment data including duplicate payment identification information, payment number, processing method specifying offset or refund request, and payment amount, and payment reconciliation data including payment number, payment reconciliation date, collection schedule identification information, principal amount, and reconciled amount, updates the reconciled amount in the collection schedule data to the reconciled amount in the payment reconciliation data using the collection schedule identification information as a key, and, if the processing method for the duplicate payment data is offset, generates offset schedule data including duplicate payment identification information, offset schedule identification information, items to be offset, contract number, principal amount, and rent month following the month of arrears.

2. The offsetting processing device according to claim 1, wherein the duplicate deposit registration means generates a revenue-generating journal entry based on the offsetting schedule data.

3. The control unit further, The offsetting apparatus according to claim 1 or 2, characterized in that it includes a billing calculation processing means that calculates the rent to be collected for the current month based on the monthly rent amount of the contract data in the month following the month, and generates data for the collection schedule for the current month.

4. The control unit further, The offsetting processing device according to claim 3, further comprising a remittance calculation processing means that generates payment request data for the current month's payment amount based on the aforementioned collection schedule data, and, if offsetting schedule data exists, generates payment request data for deducting the offset amount from the current month's payment amount based on said offsetting schedule data.

5. The control unit further, The offsetting processing device according to claim 4, further comprising a payment settlement input means for generating payment settlement data including a payment settlement number, payee, payee account, payment date, and principal amount when settlement is completed based on the payment request data.

6. The offsetting processing device according to claim 5, characterized in that the payment settlement input means generates a payment settlement journal entry based on the payment request data.

7. An offsetting method performed by an information processing device equipped with a control unit for offsetting when a rent guarantee company pays a tenant's delinquent rent to a management company on their behalf, and the tenant pays part or all of the delinquent rent to the management company, The control unit, Contract data including contract number, management company, contract holder, agency method, and monthly rent, Collection schedule data including collection schedule identification information, contract number, billing address, item, rent month, base amount, and reconciled amount, Payment request data including payment request identification information, payee, contract number, item, base amount, rent month, and payment status, It is configured to be accessible, The control unit is executed as follows: An offsetting processing method characterized by including a duplicate payment registration step, which, when a management company reports a tenant's payment of overdue rent, generates duplicate payment data including duplicate payment identification information, payment number, a processing method specifying offset or refund request, and the payment amount, and payment reconciliation data including payment number, payment reconciliation date, collection schedule identification information, principal amount, and reconciled amount, updates the reconciled amount in the collection schedule data to the reconciled amount in the payment reconciliation data using the collection schedule identification information as a key, and, if the processing method for the duplicate payment data is offset, generates offset schedule data including duplicate payment identification information, offset schedule identification information, items to be offset, contract number, principal amount, and rent month following the month of arrears, based on the collection schedule data.

8. An offsetting processing program for an information processing device equipped with a control unit, which is to be executed when a rent guarantee company pays a tenant's delinquent rent to a management company on their behalf, and the tenant pays part or all of the delinquent rent to the management company, The control unit, Contract data including contract number, management company, contract holder, agency method, and monthly rent, Collection schedule data including collection schedule identification information, contract number, billing address, item, rent month, base amount, and reconciled amount, Payment request data including payment request identification information, payee, contract number, item, base amount, rent month, and payment status, It is configured to be accessible, The control unit, An offsetting processing program for executing a duplicate payment registration process, which, upon receiving a report from a management company of a tenant's payment of overdue rent, generates duplicate payment data including duplicate payment identification information, payment number, processing method specifying offset or refund request, and payment amount, and payment reconciliation data including payment number, payment reconciliation date, collection schedule identification information, principal amount, and reconciled amount, updates the reconciled amount in the collection schedule data to the reconciled amount in the payment reconciliation data using the collection schedule identification information as a key, and, if the processing method for the duplicate payment data is offset, generates offset schedule data including duplicate payment identification information, offset schedule identification information, items to be offset, contract number, principal amount, and rent month following the month of arrears.

Images