Cancellation handling device, cancellation handling method, and cancellation handling 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

[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 payments, when there is a payment 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 guarantees, for example, there is Patent Document 1.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] However, 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 payments, when claiming a refund of the rent from the management company, it takes time and effort to pay the target rent amount and transfer fees, etc., so the exchange of money between the rental guarantee company and the management company is not efficient.

[0005] The present invention has been made in view of the above, and 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 payments, it is an object of the present invention to provide a set-off processing device, a set-off processing method, and a set-off processing program capable of streamlining the exchange of money with the management company by performing set-off with the collected rent.

Means for Solving the Problems

[0006] In order to solve the above-described problems and achieve the object, the present invention provides a set-off processing apparatus including a control unit, which is configured such that a rental guarantee company makes a subrogation payment of the delinquent rent of a contractor to a management company, and when the contractor pays part or all of the delinquent rent to the management company, a set-off process is performed. The control unit is configured to be accessible to contract data including a contract number, a management company, a contractor, a subrogation method, and a monthly rent, recovery schedule data including recovery schedule identification information, a contract number, a billing destination, an item, a rental month, a principal amount, and an offset amount, and payment request data including payment request identification information, a payment destination, a contract number, an item, a principal amount, a rental month, and a payment status. When there is a payment report of the delinquent rent from the management company by the contractor, the control unit generates duplicate payment identification information, a payment number, a processing method for designating set-off or refund claim, duplicate payment data including a payment amount, and payment offset data including a payment number, a payment offset date, recovery schedule identification information, a principal amount, and an offset amount, updates the offset amount of the recovery schedule data to the offset amount of the payment offset data using the recovery schedule identification information as a key, and when the processing method of the duplicate payment data is set-off, includes duplicate payment registration means for generating set-off schedule data including duplicate payment identification information, set-off schedule identification information, set-off target items, a contract number, a principal amount, and a rental month that is the next month of the delinquent month based on the recovery schedule data.

[0007] Also, according to one aspect of the present invention, the duplicate payment registration means may generate revenue generation journal entries based on the set-off schedule data.

[0008] Also, according to one aspect of the present invention, the control unit may further include billing calculation processing means for calculating the collected rent for the current month based on the monthly rent of the contract data in the next month and generating the recovery schedule data for the current month.

[0009] Also, according to one aspect of the present invention, the control unit may further include remittance calculation processing means for generating payment request data for the payment amount for the current month based on the recovery schedule data, and when there is set-off schedule data, generating payment request data for deducting the set-off amount from the payment amount for the current month based on the set-off schedule data.

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

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

[0012] In order to solve the above-described problems and achieve the object, the present invention provides a set-off processing method for an information processing apparatus including a control unit, in which a rent guarantee company subrogates the delinquent rent of a contractor to a management company and performs a set-off process when the contractor deposits part or all of the delinquent rent with the management company. The control unit is configured to be accessible to contract data including a contract number, a management company, a contractor, a substitution method, and a monthly rent, recovery schedule data including recovery schedule identification information, a contract number, a billing destination, items, a rent month, a principal amount, and an offset amount, and payment request data including payment request identification information, a payee, a contract number, items, a principal amount, a rent month, and a payment status. When there is a deposit report of delinquent rent from the management company by the contractor in the control unit, duplicate deposit identification information, a deposit number, a processing method for designating set-off or refund claim, duplicate deposit data including a deposit amount, and deposit offset data including a deposit number, a deposit offset date, recovery schedule identification information, a principal amount, and an offset amount are generated. Using the recovery schedule identification information as a key, the offset amount of the recovery schedule data is updated to the offset amount of the deposit offset data. When the processing method of the duplicate deposit data is set-off, a duplicate deposit registration step of generating duplicate deposit identification information, set-off schedule identification information, set-off target items, a contract number, a principal amount, and a rent month that is the next month of the delinquent month based on the recovery schedule data is included.

[0013] In order to solve the above-described problems and achieve the object, the present invention provides a set-off processing program for causing an information processing apparatus having a control unit to execute. In this program, a rental guarantee company subrogates and pays the overdue rent of a contractor to a management company, and when the contractor deposits part or all of the overdue rent with the management company, a set-off process is performed. The control unit is configured to be able to access contract data including a contract number, a management company, a contractor, a proxy method, and a monthly rent, recovery schedule data including recovery schedule identification information, a contract number, a billing destination, items, a rental month, a principal amount, and an offset amount, and payment request data including payment request identification information, a payment destination, a contract number, items, a principal amount, a rental month, and a payment status. When a deposit report of overdue rent by the contractor from the management company is received by the control unit, duplicate deposit identification information, a deposit number, a processing method for designating set-off or refund claim, duplicate deposit data including a deposit amount, and deposit offset data including a deposit number, a deposit offset date, recovery schedule identification information, a principal amount, and an offset amount are generated. Using the recovery schedule identification information as a key, the offset amount of the recovery schedule data is updated to the offset amount of the deposit offset data. When the processing method of the duplicate deposit data is set-off, a duplicate deposit registration step is executed to generate set-off schedule data including duplicate deposit identification information, set-off schedule identification information, set-off target items, a contract number, a principal amount, and a rental month which is the next month of the overdue month, based on the recovery schedule data. The set-off processing program is characterized by this.

Effect of the Invention

[0014] According to the present invention, when a rental guarantee company subrogates and pays the overdue rent of a contractor to a management company, and when the contractor deposits part or all of the overdue rent with the management company and duplicate deposits occur, by performing set-off with the collected rent, it is possible to achieve the effect of streamlining the transfer of money with the management company.

Brief Description of the Drawings

[0015]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5A

Figure 5B

Figure 5C

Figure 6

Figure 7

Figure 8A

Figure 8B

[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 with reference to the drawings. Note that the present invention is not limited by this embodiment.

[0017] [1. Overview] For example, when a rent guarantee company subrogates the delinquent rent of a contractor to a management company and the contractor makes a partial or full payment of the delinquent rent to the management company, resulting in duplicate payments, and there is a payment report from the management company, there is a business operation to cancel the claim for delinquent rent against the contractor and request a refund of the rent from the management company.

[0018] This operation occurs after the subrogation payment of delinquent rent to the management company. For example, in the case of a collection agency contract, some management companies have a need to offset it against the collected rent for the specified rent month in order to reduce the trouble of receiving a refund request and paying the transfer fee for the target rent amount.

[0019] Conventionally, a rent guarantee company requests a refund from the management company after reporting a duplicate rent payment. However, in response to the need to offset it against the rent for 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. Regarding the offset of rent, it is a business that causes complexity and complication in systematization, such as the upper limit of offsettable rent and the transfer of accounting entries at the time of offset. Since the business was 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 rent guarantee company subrogates the delinquent rent of a contractor to a management company and the contractor makes a partial or full payment of the delinquent rent to the management company, resulting in duplicate payments, the offset with the collected rent is performed to streamline the transfer of money with the management company.

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

[0022] (1) Based on a payment report from the management company, when using duplicate payments to cover a claim for delinquent rent, specify whether to request a refund or offset the rent. If rent offset is specified, create offset planned data with the collected rent for the specified rent month. (2) When calculating the transfer amount of storage rent, if there is offset-scheduled data, a function that subtracts the offset amount from the transfer rent amount and creates payment request data.

[0023] [2. Configuration] The configuration of the offset processing device 100 according to the present embodiment will be described with reference to FIG. 1. FIG. 1 is a block diagram showing an example of the configuration of the offset processing device 100 according to the present embodiment. The offset processing device 100 according to the present embodiment can be preferably used, for example, in a rent guarantee company or the like. Hereinafter, a case will be described in which the rent guarantee company pays the delinquent rent of the contractor on behalf of the management company, and when the contractor deposits part or all of the delinquent rent with the management company and double payment occurs, the offset with the storage rent is performed to streamline the transfer of money with the management company.

[0024] The offset processing device 100 is a workstation, a commercially available desktop personal computer, or the like. Note that the offset processing device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer.

[0025] As shown in FIG. 1, 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 communicably connected via an arbitrary communication path.

[0026] 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 communicably connecting the offset processing device 100 and the server 200 or the like to each other, and is, for example, the Internet or a LAN (Local Area Network). Note that the data stored in the storage unit 106 described later may be stored in a server.

[0027] An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with the mouse can be used. In the following, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112. Further, the case where the user displays on the screen of the output device (monitor) 114 and operates with the input device 112 may be described as "user operation via the UI".

[0028] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 records a computer program for giving instructions to the CPU (Central Processing Unit) to perform various processes in cooperation with the OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc. can be used. Further, the storage unit 106 stores a journal pattern master 106a, contract data, subrogation payment data, breakdown data of subrogation payment recovery schedule, recovery schedule data, payment request data, duplicate payment data, payment data, payment offset data, offset schedule data, payment settlement data, etc. FIG. 2 is a diagram showing the correlation of offset schedule data, payment request data, recovery schedule data, breakdown data of subrogation payment recovery schedule, and subrogation payment data.

[0029] The journal pattern master 106a can be composed of a table or the like in which items, revenue accounting criteria, outstanding account items, revenue account items, payment accounting criteria, outstanding payment account items, and payment account items are associated and registered (see FIG. 5C). The journal pattern master 106a is referred to when creating revenue generation journals or payment settlement journals.

[0030] The contract data may include a contract number, a management company, a contractor, an agency method, and a monthly rent.

[0031] The subrogation payment data may include a subrogation payment number, a contract number, a management company, an overdue amount, and a rental month.

[0032] The breakdown data of subrogation payment recovery schedule may include a subrogation payment number, an item, a recovery schedule Guid (recovery schedule identification information), a payment request Guid (payment request identification information), a principal amount, and a consumption tax amount.

[0033] The data to be recovered may include the recovery schedule Guid (recovery schedule identification information), contract number, billing address, items (e.g., rent, variable expenses), rental month, principal amount, consumption tax amount, and written-off amount.

[0034] The duplicate payment data may include the duplicate payment Guid (duplicate payment identification information), payment number, processing method (1: offset, 0: normal (claim for refund)), and payment amount.

[0035] The payment data may include the payment number, payment date, and payment account.

[0036] The offset schedule data may include the duplicate payment Guid, offset schedule Guid, items (e.g., rent (offset), variable expenses (offset)), contract number, principal amount (offset amount), consumption tax amount, rental month, payment request Guid (payment identification information), and offset payment request Guid (offset identification information). The offset schedule data is created when the processing method of the duplicate payment data is "1: offset".

[0037] The payment request data may include the payment request Guid (payment request identification information), payee, contract number, items (e.g., rent, rent (offset), variable expenses, variable expenses (offset)), principal amount (payment amount), consumption tax amount, rental month, and payment status.

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

[0039] 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 the OS, programs that define various processing procedures, and required data, and executes various information processes based on these stored programs.

[0040] The control unit 102 is configured to be able to access the journal pattern master 106a, contract data, subrogation payment data, subrogation payment recovery schedule breakdown data, recovery schedule data, payment request data, duplicate payment data, payment data, payment offset data, offset schedule data, payment settlement data, etc. stored in the storage unit 106. Note that the journal pattern master 106a, contract data, subrogation payment data, subrogation payment recovery schedule breakdown data, recovery schedule data, payment request data, duplicate payment data, payment data, payment offset data, offset schedule data, payment settlement data, etc. may be provided in other locations (for example, server 200), as long as the control unit 102 can access them.

[0041] Functionally conceptually, the control unit 102 includes a data registration unit 102a, a duplicate payment 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] For example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, the data registration unit 102a generates and updates contract data, subrogation payment data, and subrogation payment recovery schedule breakdown data, etc., and registers them in the storage unit 106.

[0043] For example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, the duplicate payment registration unit 102b generates and updates duplicate payment data, payment data, payment offset data, recovery schedule data, offset schedule data, etc., and registers them in the storage unit 106.

[0044] Specifically, when there is a payment report of overdue rent by the contractor from the management company, the duplicate payment registration unit 102b generates duplicate payment identification information, payment number, a processing method for specifying offset or refund claim, duplicate payment data including the payment amount, and payment offset data including the payment number, payment offset date, collection schedule identification information, principal amount, consumption tax amount, and offset amount. Using the collection schedule identification information as a key, it updates the offset amount of the collection schedule data to the offset amount of the payment offset data. When the processing method of the duplicate payment data is offset, based on the collection schedule data, it creates offset schedule data including duplicate payment identification information, offset schedule identification information, offset target items, contract number, principal amount (offset amount), consumption tax amount, and the rent month which is the next month of the overdue month.

[0045] Based on the offset schedule data, the duplicate payment registration unit 102b refers to the journal pattern master 106a and generates revenue occurrence journal entries.

[0046] The billing calculation processing unit 102c calculates the collected rent for the current month based on the monthly rent of the contract data in the next month and generates the collection schedule data for the current month.

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

[0048] Specifically, based on the collection schedule data, the remittance calculation processing unit 102d generates payment request data for the payment amount (rent remittance) of the current month. Also, when there is offset schedule data, based on the offset schedule data, it generates payment request data with the offset amount deducted from the payment amount of the current month.

[0049] When the 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, and registers it in the storage unit 106. Also, based on the payment request data, the payment settlement input unit 102e refers to the journal pattern master 106a and generates payment settlement journal entries.

[0050] The master maintenance unit 102f is for performing settings such as data input, addition, change, update, etc. on the journal pattern master 106a according to operations of an operator on a master maintenance screen (not shown).

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

[0052] [3. Specific examples of processing] With reference to FIGS. 1 to 8B, a specific example of the processing of the control unit 102 of the offset processing apparatus 100 in the present embodiment will be described. FIGS. 3 to 8B are diagrams for explaining a specific example of the processing of the control unit 102 of the offset processing apparatus 100 in the present embodiment. In the following description, all units of amount are "yen (￥)", and the notation may be omitted.

[0053] (3-1: Overall processing) FIG. 3 is a diagram showing a flow for explaining an overview of the overall processing of the control unit 102 of the offset processing apparatus 100 in the present embodiment. With reference to FIG. 3, an overview of the overall processing of the control unit 102 of the offset processing apparatus 100 in the present embodiment will be described.

[0054] In FIG. 3, the duplicate payment registration unit 102b executes duplicate payment registration processing (step S1). Specifically, in the duplicate payment registration processing, when there is a payment report of overdue rent by the contractor from the management company, the duplicate payment registration unit 102b generates duplicate payment data including duplicate payment identification information, payment number, processing method for specifying offset or refund claim, and payment amount, and payment offset data including payment number, payment offset date, collection schedule identification information, principal amount, consumption tax amount, and offset amount. Using the collection schedule identification information as a key, the duplicate payment registration unit 102b updates the offset amount of the collection schedule data to the offset amount of the payment offset data. When the processing method of the duplicate payment data is offset, based on the collection schedule data, the duplicate payment registration unit 102b creates offset schedule data including duplicate payment identification information, offset schedule identification information, offset target items, contract number, principal amount (offset amount), consumption tax amount, and rent month which is the month following the delinquent month. Also, based on the offset schedule data, the duplicate payment registration unit 102b refers to the journal pattern master 106a and generates revenue generation journal entries.

[0055] The billing calculation processing unit 102c executes billing calculation processing (step S2). Specifically, the billing calculation processing unit 102c calculates the current month's collected rent based on the monthly rent of the contract data in the next month and generates the collection schedule data for the current month.

[0056] The remittance calculation processing unit 102d executes remittance calculation processing (step S3). Specifically, in the remittance calculation processing, 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. Also, when there is offset schedule data, the remittance calculation processing unit 102d generates payment request data in which the offset amount is deducted from the current month's payment amount based on the offset schedule data.

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

[0058] (3-2: Sample Data) Figures 4 to 8B are diagrams showing sample data for explaining specific examples of the processing of the control unit 102 of the offset processing apparatus 100 in the present embodiment. With reference to Figures 4 to 8B, an example of the business flow of the present embodiment will be described.

[0059] (Premise Data) It is assumed that contract data, subrogation payment data, breakdown of subrogation payment recovery schedule data, recovery schedule data, and payment request data shown in Figure 4 are registered in the storage unit 106 in advance.

[0060] The contract data includes items such as contract number, management company, contractor, agency method (e.g., storage agency, delinquency report), and monthly rent. In the example shown in the figure, the first row has a contract number of "0000000001", a management company of "Management Company A", a contractor of "Contractor 1", an agency method of "storage agency", and a monthly rent of "100,000", and the second row has a contract number of "0000000002", a management company of "Management Company B", a contractor of "Contractor 2", an agency method of "delinquency report", and a monthly rent of "80,000".

[0061] The subrogation payment data includes items such as subrogation payment number, contract number, management company, delinquent amount, and rental month. In the example shown in the figure, the first row has a subrogation payment number of "000000000001", a contract number of "0000000001", a management company of "Management Company A", a delinquent amount of "100,000", and a rental month of "October", and the second row has a subrogation payment number of "000000000002", a contract number of "0000000002", a management company of "Management Company B", a delinquent amount of "3,000", and a rental month of "October".

[0062] The subrogation repayment recovery schedule breakdown data includes items such as subrogation repayment number, item, recovery schedule Guid, payment request Guid, principal amount, and consumption tax amount. In the example shown in the figure, for the first row, the subrogation repayment number is "000000000001", the item is "Rent", the recovery schedule Guid is "AAAA", the payment request Guid is "DDDD", the principal amount is "100,000", and the consumption tax amount is "0". For the second row, the subrogation repayment number is "000000000002", the item is "Variable expenses", the recovery schedule Guid is "BBBB", the payment request Guid is "EEEE", the principal amount is "3,000", and the consumption tax amount is "300".

[0063] The recovery schedule data includes items such as recovery schedule Guid, contract number, billing address, item, monthly rent, principal amount, consumption tax amount, and written-off amount. In the example shown in the figure, for the first row, the recovery schedule Guid is "AAAA", the contract number is "0000000001", the billing address is "Contractor 1", the item is "Rent", the monthly rent is "October", the principal amount is "100,000", the consumption tax amount is "0", and the written-off amount is "0". For the second row, the recovery schedule Guid is "BBBB", the contract number is "0000000002", the billing address is "Contractor 2", the item is "Variable expenses", the monthly rent is "October", the principal amount is "3,000", the consumption tax amount is "300", and the written-off amount is "0".

[0064] The payment request data includes items such as payment request Guid, payee, contract number, item, principal amount, consumption tax amount, monthly rent, and payment status. In the example shown in the figure, for the first row, the payment request Guid is "DDDD", the payee is "Management Company A", the contract number is "0000000001", the item is "Rent", the principal amount is "100,000", the consumption tax amount is "0", the monthly rent is "October", and the payment status is "Paid". For the second row, the payment request Guid is "EEEE", the payee is "Management Company B", the contract number is "0000000002", the item is "Variable expenses", the principal amount is "3,000", the consumption tax amount is "300", the monthly rent is "October", and the payment status is "Paid".

[0065] (S1: Duplicate deposit registration process) Referring to FIGS. 5A to 5C, a specific example of the duplicate payment registration process will be described. In the following example, based on the payment report from the management company (report of 2023 / 10 / 23), the offset of the delinquent rent payment is specified, the rent month to be offset is designated, and the case of creating the offset schedule data will be described. In this example, in the case where a payment report occurs for the delinquent rent for October, the case where the duplicate payment (payment report amount: 50,000, partial payment) for contract number 0000000001 is offset from the rent for November will be described.

[0066] FIG. 5A shows the data flow. When there is a payment report (payment report amount: 50,000) of the delinquent rent from the management company by the contractor, duplicate payment data is generated and registered in the storage unit 106. The duplicate payment data includes items such as duplicate payment identification information, payment number, processing method (1: offset, 0: normal (refund claim)), 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". When the processing method is "1: offset", the offset schedule data is generated.

[0067] Payment data is generated and registered in the storage unit 106. The payment data includes items such as payment number, payment date, and payment account. In the example shown in the figure, the payment number is "1234567890", the payment date is "2023 / 10 / 20", and the payment account is "dummy".

[0068] Offset payment data is generated and registered in the storage unit 106. The offset payment data includes items such as payment number, offset payment date, recovery schedule Guid, principal amount, consumption tax amount, and offset amount. In the example shown in the figure, the payment number is "1234567890", the offset payment date is "2023 / 10 / 20", the recovery schedule Guid is "AAAA", the principal amount is "50,000", the consumption tax amount is "0", and the offset amount is "50,000".

[0069] Using the collection schedule identification Guid as a key, update the written-off amount of the collection schedule data to the written-off amount of the deposit write-off data. In this example, for the overdue rent of "100,000", apply a deposit of ￥50,000 according to the deposit write-off data with the deposit number "1234567890", and update the written-off amount of the collection schedule data from "0" to "50,000".

[0070] Based on the collection schedule data, generate offset schedule data and register it in the storage unit 106. The offset schedule data includes items such as duplicate deposit Guid, offset schedule Guid, item, contract number, principal amount, consumption tax amount, rent month, payment request Guid, and offset payment request Guid. In this example, offset the deposit amount of ￥50,000 for the overdue rent in October from the rent in November of the next month. In the example shown in the same figure, the duplicate deposit Guid is "aaaaa", the offset schedule Guid is "XXXX", the item is "Rent (offset)", the contract number is "0000000001", the principal 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 for explaining the offset upper limit check at the time of offset. Perform the offset upper limit check at the time of offset. At the time of offset registration, verify the monthly rent of the contract data and the reported deposit amount (offset scheduled amount: "principal amount" in the offset schedule data). If the reported deposit amount exceeding the monthly rent is specified, it is considered an error because there is no offset source. Monthly rent < reported amount → error, monthly rent = reported amount → OK, monthly rent > reported amount → OK.

[0072] FIG. 5C is a diagram for explaining journal entry accounting (system accounting). The journal entry pattern master 106a can be composed of a table or the like that registers by associating items, revenue accounting criteria, unbilled accounts, revenue accounts, payment accounting criteria, unpaid accounts, and payment accounts. In the example shown in the figure, the first row has the item "Rent", the revenue accounting criteria "Receipt", the unbilled account "-", the revenue account "Advance payment", the payment accounting criteria "Payment", the unpaid account "-", and the payment account "Advance payment"; the second row has the item "Rent (offset)", the revenue accounting criteria "Occurrence", the unbilled account "Rent offset", the revenue account "Advance payment", the payment accounting criteria "Payment", the unpaid account "-", and the payment account "Rent offset".

[0073] Based on the offset planned data, refer to the journal entry pattern master 106a to generate revenue occurrence journal entries. In the example shown in the figure, since the item is "Rent (offset)" and the revenue accounting criteria is "Occurrence", the revenue occurrence journal entry dated October 20th is Rent offset: ¥50,000 / Advance payment: ¥50,000.

[0074] (S2: Billing calculation process) Referring to FIG. 6, a specific example of the billing calculation process will be described. Based on the monthly rent of the contract data, calculate the current month's rent receivable and generate the collection planned data. In this example, create the collection planned data for the rent in November.

[0075] FIG. 6 shows the data flow. In FIG. 6, based on the contract data, generate the collection planned data for the current month. As shown in the figure, in the third row of the collection planned data, the collection planned Guid "DDDD", contract number "0000000001", billing recipient "Contractor 1", item "Rent", rent month "November", principal amount "100,000", consumption tax amount "0", and written-off amount "0" are generated and added.

[0076] (S3: Remittance calculation process) Referring to FIG. 7, a specific example of the remittance calculation process will be described. Based on the contract rent, calculate the current month's remittance amount, subtract the offset amount from the payment amount based on the offset planned data created in the duplicate receipt process, and create the payment request data for the rent in November.

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

[0078] First, update the remittance number of the collection schedule Guid "DDDD" of the collection schedule data to "1234".

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

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

[0081] Offset the payment amount of ￥50,000 for the October overdue rent from the November rent of the next month. In the offset schedule data, update the offset payment request Guid to the payment request Guid "FFFF" of the payment request data, and update the payment request Guid to the payment request Guid "GGGG" of the payment request data.

[0082] (S4: Payment settlement input process) Referring to FIGS. 8A and 8B, a specific example of payment and settlement input processing will be described. CASHOUT settlement is performed based on the payment request data for November. The payment date is set to 2023 / 11 / 10.

[0083] FIG. 8A is a diagram showing a data flow. When the settlement for November is completed, for the records of payment request Guids "FFFF" and "GGGG" in the payment request data, the payment status is updated to "Paid" and the payment and settlement number is updated to "98765".

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

[0085] FIG. 8B is a diagram for explaining journal entry posting (system posting). Based on the payment request data, referring to the journal entry pattern master 106a, payment and settlement journal entries (debit journal entries) are generated. In the example shown in the figure, for the payment request Guid "FFFF", since the item is "Rent" and the payment posting standard is "Debit", a journal entry of "Advance payment: ￥100,000 / CASH: ￥100,000" is created. Also, for the payment request Guid "GGGG", since the item is "Rent (offset)" and the payment posting standard is "Debit", a journal entry of "CASH: ￥50,000 / Rent offset: ￥50,000" is created.

[0086] As described above, according to the present embodiment, when there is a payment report of overdue rent by a contractor from a management company, duplicate payment identification information, a payment number, a processing method for designating offset or refund claim, duplicate payment data including the payment amount, and payment offset data including the payment number, the payment offset date, the collection schedule identification information, the principal amount, and the offset amount are generated. Using the collection schedule identification information as a key, the offset amount of the collection schedule data is updated to the offset amount of the payment offset data. When the processing method of the duplicate payment data is offset, based on the collection schedule data, a duplicate payment registration unit 102b that generates offset schedule data including duplicate payment identification information, offset schedule identification information, offset target items, contract number, principal amount, and the rent month that is the next month of the overdue month is provided. Therefore, when a rent guarantee company makes a subrogation payment of the contractor's overdue rent to the management company and the contractor pays part or all of the overdue rent to the management company, resulting in duplicate payments, it is possible to streamline the transfer of money with the management company by offsetting with the collected rent.

[0087] [4. Contribution to the United Nations Sustainable Development Goals (SDGs)] According to the present embodiment, it is possible to contribute to promoting business efficiency and appropriate business judgment of enterprises, so it is possible to contribute to Goals 8 and 9 of the SDGs.

[0088] Also, according to the present embodiment, it is possible to contribute to reducing waste loss and promoting paperless and digitization, so it is possible to contribute to Goals 12, 13, and 15 of the SDGs.

[0089] Also, according to the present embodiment, it is possible to contribute to strengthening control and governance, so it is possible to contribute to Goal 16 of the SDGs.

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

[0091] For example, among the various processes described in the embodiments, all or part of the processes described as being automatically performed can be manually performed, or all or part of the processes described as being manually performed can be automatically performed by a known method.

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

[0093] Also, regarding the offset processing apparatus 100, each of the illustrated components is a functional concept, and it is not necessarily physically configured as shown in the figure.

[0094] For example, regarding the processing functions provided by the offset processing apparatus 100, particularly each processing function performed by the control unit 102, all or any part of them may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. Note that the program is recorded in a non-transitory computer-readable recording medium including programmed instructions for causing an information processing apparatus to execute the processes described in this embodiment, and is mechanically read by the offset processing apparatus 100 as necessary. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving commands to the CPU in cooperation with the OS to perform various processes is recorded. This computer program is executed by being loaded into the RAM and constitutes the control unit in cooperation with the CPU.

[0095] In addition, this computer program may be stored in an application program server connected to the offset processing apparatus 100 via an arbitrary network, and all or part of it can be downloaded as necessary.

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

[0097] Also, the "program" is a data processing method described in any language or description method, and is not limited to a form such as source code or binary code. Note that the "program" is not necessarily limited to being configured singly, and also includes those that are distributedly configured as a plurality of modules or libraries, or those that achieve their functions in cooperation with another program represented by an OS. Regarding the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in each device shown in the embodiment, well-known configurations and procedures can be used.

[0098] The various databases and the like stored in the storage unit 106 are storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0099] Further, the offset processing device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. Further, the offset processing device 100 may be realized by installing software (including programs or data, etc.) for realizing the processing described in this embodiment in the device.

[0100] Furthermore, the specific form of the 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 according to the function load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Explanation of Signs

[0101] 100 Offset processing device 102 Control unit 102a Data registration unit 102b Duplicate payment registration unit 102c Billing calculation processing unit 102d Remittance calculation processing unit 102e Payment settlement input unit 102f Master maintenance unit 102g Screen display control unit 104 Communication interface unit 106 Storage unit 106a Journal pattern master 108 Input / output interface unit 112 Input device 114 Output device 300 Network

Claims

1. A set-off processing device that includes a control unit and is for a rental guarantee company to subrogate and pay the overdue rent of a contractor to a management company and perform a set-off process when the contractor deposits part or all of the overdue rent with the management company. The control unit is configured to be accessible to contract data including a contract number, a management company, a contractor, a proxy method, and a monthly rent, recovery schedule data including recovery schedule identification information, a contract number, a billing destination, an item, a rental month, a principal amount, and an offset amount, and payment request data including payment request identification information, a payment destination, a contract number, an item, a principal amount, a rental month, and a payment status. When there is a deposit report of overdue rent from the management company by the contractor, it generates duplicate deposit identification information, a deposit number, a processing method for designating set-off or refund claim, duplicate deposit data including a deposit amount, and deposit offset data including a deposit number, a deposit offset date, recovery schedule identification information, a principal amount, and an offset amount, updates the offset amount of the recovery schedule data to the offset amount of the deposit offset data using the recovery schedule identification information as a key, and includes duplicate deposit registration means for generating set-off schedule data including duplicate deposit identification information, set-off schedule identification information, set-off target items, a contract number, a principal amount, and a rental month that is the month following the overdue month based on the recovery schedule data when the processing method of the duplicate deposit data is set-off. The control unit is configured to: be accessible to contract data including a contract number, a management company, a contractor, a proxy method, and a monthly rent; be accessible to recovery schedule data including recovery schedule identification information, a contract number, a billing destination, an item, a rental month, a principal amount, and an offset amount; be accessible to payment request data including payment request identification information, a payment destination, a contract number, an item, a principal amount, a rental month, and a payment status; generate, when there is a deposit report of overdue rent from the management company by the contractor, duplicate deposit identification information, a deposit number, a processing method for designating set-off or refund claim, duplicate deposit data including a deposit amount, and deposit offset data including a deposit number, a deposit offset date, recovery schedule identification information, a principal amount, and an offset amount, update the offset amount of the recovery schedule data to the offset amount of the deposit offset data using the recovery schedule identification information as a key, and generate set-off schedule data including duplicate deposit identification information, set-off schedule identification information, set-off target items, a contract number, a principal amount, and a rental month that is the month following the overdue month based on the recovery schedule data when the processing method of the duplicate deposit data is set-off.

2. The duplicate deposit registration means is configured to generate a revenue generation journal entry based on the set-off schedule data, as claimed in claim 1.

3. The control unit further includes: claim calculation processing means for calculating the collected rent for the current month based on the monthly rent of the contract data in the following month and generating recovery schedule data for the current month, as claimed in claim 1 or claim 2.

4. The control unit further includes: remittance calculation processing means for generating payment request data for the payment amount for the current month based on the recovery schedule data, and when there is set-off schedule data, generating payment request data with the set-off amount deducted from the payment amount for the current month based on the set-off schedule data, as claimed in claim 3.

5. The control unit further includes: payment settlement input means for generating payment settlement data including a payment settlement number, a payment destination, a payment destination account, a payment date, and a principal amount when the settlement is completed based on the payment request data, as claimed in claim 4.

6. ​ The offset processing apparatus according to claim 5, wherein the payment settlement input means generates a payment settlement journal based on the payment request data.

7. An offset processing method for an information processing apparatus having a control unit to perform an offset process when a rental guarantee company pays in lieu of a contractor's overdue rent to a management company and the contractor pays part or all of the overdue rent to the management company, wherein the control unit is configured to be accessible to contract data including a contract number, a management company, a contractor, a proxy method, and a monthly rent, recovery schedule data including recovery schedule identification information, a contract number, a billing destination, an item, a rental month, a principal amount, and an offset amount, payment request data including payment request identification information, a payment destination, a contract number, an item, a principal amount, a rental month, and a payment status, and is configured to be accessible thereto, and executed in the control unit, when there is a payment report of the overdue rent from the management company by the contractor, generates duplicate payment identification information, a payment number, a processing method for designating offset or refund claim, duplicate payment data including a payment amount, and payment offset data including a payment number, a payment offset date, recovery schedule identification information, a principal amount, and an offset amount, updates the offset amount of the recovery schedule data with the offset amount of the payment offset data using the recovery schedule identification information as a key, and when the processing method of the duplicate payment data is offset, includes a duplicate payment registration step of generating offset schedule data including duplicate payment identification information, offset schedule identification information, an offset target item, a contract number, a principal amount, and a rental month which is the next month of the overdue month based on the recovery schedule data.

8. An offset processing program for causing an information processing apparatus having a control unit to perform an offset process when a rental guarantee company pays in lieu of a contractor's overdue rent to a management company and the contractor pays part or all of the overdue rent to the management company, wherein the control unit is configured to be accessible to contract data including a contract number, a management company, a contractor, a proxy method, and a monthly rent, recovery schedule data including recovery schedule identification information, a contract number, a billing destination, an item, a rental month, a principal amount, and an offset amount, payment request data including payment request identification information, a payment destination, a contract number, an item, a principal amount, a rental month, and a payment status, and is configured to be accessible thereto, and to the control unit When there is a payment report of overdue rent from the contractor to the management company, generate duplicate payment identification information, payment number, processing method for specifying offset or refund claim, duplicate payment data including the payment amount, and payment offset data including the payment number, payment offset date, collection schedule identification information, principal amount, and offset amount. Update the offset amount of the collection schedule data to the offset amount of the payment offset data using the collection schedule identification information as the key. When the processing method of the duplicate payment data is offset, execute a duplicate payment registration process to generate offset schedule data including duplicate payment identification information, offset schedule identification information, offset target items, contract number, principal amount, and rental month set as the month following the delinquent month based on the collection schedule data. A set-off processing program for causing the execution of the above steps.

Images