Deposit processing device, deposit processing method, and deposit processing program

Abstract

To automatically process the registration of subtraction from an orderer and subtraction to a sub-contractor by only performing registration of a deposit slip, thereby reducing a burden on a person in charge of a general contractor.SOLUTION: A deposit processing apparatus comprises: deposit processing means that, when the construction price from which the advance money is subtracted is deposited from an orderer for a target project, generates deposit data, and for the deposit data, generates deposit adjustment data including a deposit number, an adjustment item, an adjustment amount, a cancellation target section designating the amount of subtraction for a company or the amount of subtraction for a sub-contractor, the project when the cancellation target section is the amount of subtraction for the company and a supplier when the cancellation target section is the amount of subtraction for the sub-contractor; and purchasing processing means that, based on the deposit adjustment data, generates purchasing data including a purchasing number, a supplier being the sub-contractor, a deposit item, and a purchasing amount, and when the cancellation target section of the deposit adjustment data is the amount of subtraction for the sub-contractor, generates minus classification data for determining the adjustment amount as a minus purchasing amount, and generates classification data for determining an order amount as the purchasing amount.SELECTED DRAWING: Figure 4

Description

[Technical field]

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

[0002] For example, when a client commissions a construction project to a prime contractor, who then commissions a subcontractor, the client may collectively pay all expenses that should be paid by the prime contractor and subcontractor, such as parking fees, equipment leasing fees, and industrial waste disposal fees, in order to efficiently proceed with the construction project. The client makes a payment to the prime contractor after deducting the amounts borne by the prime contractor and subcontractor, and the prime contractor makes a payment to the subcontractor after deducting the amounts borne by the subcontractor. For example, Patent Document 1 is an example of a conventional system for deducting the payment of construction costs. [Prior art documents] [Patent documents]

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

[0004] However, the above-mentioned Patent Document 1 is silent about the deductions by the prime contractor when the client pays the prime contractor for the work after deducting the advances paid by the prime contractor and subcontractors.

[0005] The present invention has been made in consideration of the above, and has an object to provide a deposit processing device, a deposit processing method, and a deposit processing program that, when a client pays a prime contractor for a construction project after deducting advances from the prime contractor and subcontractors, enables the prime contractor to automatically register deductions from the client and deductions to subcontractors by simply registering a deposit slip, thereby reducing the burden on the prime contractor's staff. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides a deposit processing device equipped with a control unit, in which, when a construction fee, excluding an advance payment, is received from a client for a target project, the control unit generates deposit data including a deposit number, a deposit date, a deposit destination, which is the client, a deposit method, and a deposit amount, and generates deposit adjustment data for the deposit data including a deposit number, an adjustment item, an adjustment amount, an offset target category that specifies the company's deduction amount or a subcontractor's deduction amount, a project when the offset target category is the company's deduction amount, and a supplier when the offset target category is the subcontractor's deduction amount. The system is characterized by comprising a processing means, a purchase processing means which generates purchase data including a purchase number, a purchase date, a payee who is a subcontractor, a payment item, a debt item, and a purchase amount based on the receipt adjustment data, and at that time, when the offset category of the receipt adjustment data is a subcontractor deduction amount, generates negative journal entry data with the adjustment amount as a negative purchase amount, and also generates journal entry data with the order amount as the purchase amount, and a payment processing means which generates payment data including a payment number, a scheduled payment date, a payee who is a subcontractor, a purchase number, a debt item, and a payment amount based on the purchase data.

[0007] According to another aspect of the present invention, the deposit processing means may generate deposit reconciliation data including a deposit number, a deposit reconciliation number, and an amount to be reconciled based on the deposit data and the deposit adjustment data.

[0008] According to another aspect of the present invention, the deposit processing means may generate vendor deduction data including a payee, a purchase number, a deposit number, and a deposit recipient based on the deposit data and the deposit adjustment data.

[0009] According to another aspect of the present invention, the control unit may further include a project cost processing means for generating project cost data including a project, a cost accounting date, a cost element, and a cost amount based on the purchasing data.

[0010] In addition, according to one aspect of the present invention, the control unit may further include an offset agreement processing means for referencing the vendor deduction data, obtaining the payment amount of the payment data using the purchase number as a key, obtaining the payee from the deposit data using the deposit number as a key, and obtaining the adjustment amount from the deposit adjustment data, and generating offset agreement data including the payee, payment number, scheduled payment month, payment amount, purchase number, payee, and adjustment amount.

[0011] In order to solve the above-mentioned problems and achieve the object, the present invention provides a payment processing method executed by an information processing device having a control unit, and when a construction fee, excluding an advance payment, for a target project is received from a client, the control unit generates payment data including a payment number, a payment date, a payment destination which is the client, a payment method, and a payment amount, and for the payment data, generates payment data including a payment number, an adjustment item, an adjustment amount, an offset target category which specifies the company's deduction or a subcontractor's deduction, a project when the offset target category is the company's deduction, and a supplier when the offset target category is the subcontractor's deduction. The method includes a receipt processing step for generating adjustment data, a purchase data generating step based on the receipt adjustment data, the purchase data including the purchase number, purchase date, payee who is a subcontractor, payment item, debt item, and purchase amount, and in that case, if the offset category of the receipt adjustment data is the subcontractor deduction amount, negative journal data is generated with the adjustment amount as the negative purchase amount, and a purchase processing step for generating journal data with the order amount as the purchase amount, and a payment processing step for generating payment data including the payment number, scheduled payment date, payee who is a subcontractor, purchase number, debt item, and payment amount, based on the purchase data.

[0012] In order to solve the above-mentioned problems and achieve the object, the present invention provides a deposit processing program for execution by an information processing device having a control unit, and a deposit processing method executed by an information processing device having a control unit, in which, when a construction fee, excluding an advance payment, for a target project is received from a client, deposit data including a deposit number, a deposit date, a deposit destination which is the client, a deposit method, and a deposit amount are generated, and for the deposit data, the deposit number, an adjustment item, an adjustment amount, an offset target category which specifies the company's deduction or a subcontractor's deduction, a project when the offset target category is the company's deduction, and a project when the offset target category is the subcontractor's deduction. a purchase processing step of generating purchase adjustment data including a purchase number, a purchase date, a payee who is a subcontractor, a payment item, a debt item, and a purchase amount based on the purchase adjustment data, and at that time, if the offset target category of the purchase adjustment data is a subcontractor deduction amount, negative journal entry data is generated with the adjustment amount as a negative purchase amount, and journal entry data with the order amount as the purchase amount is generated; and a payment processing step of generating payment data including a payment number, a scheduled payment date, a payee who is a subcontractor, a purchase number, a debt item, and a payment amount based on the purchase data. Effect of the Invention

[0013] According to the present invention, when a client pays a prime contractor for a construction project after deducting the advances made by the prime contractor and subcontractors, the prime contractor can automatically register deductions from the client and deductions to the subcontractors simply by registering a deposit slip, thereby reducing the burden on the prime contractor's staff. [Brief description of the drawings]

[0014] [Figure 1] FIG. 1 is a diagram for explaining the overall picture of vendor payment deductions at the time of deposit. [Diagram 2] FIG. 2 is a diagram for explaining the operation of a conventional system for deduction from vendor payment at the time of receipt. [Diagram 3]FIG. 3 is a diagram for explaining the system operation of the deposit time trader payment deduction in this embodiment. [Figure 4] FIG. 4 is a block diagram showing an example of the configuration of the deposit processing device according to the present embodiment. [Diagram 5] FIG. 5 is a diagram showing a flow chart for explaining the overall process flow of the control unit of the deposit processing device according to the present embodiment. [Figure 6A] FIG. 6A is a diagram showing sample data for explaining a specific example of the process of the control unit of the deposit processing device according to the present embodiment. [Figure 6B] FIG. 6B is a diagram showing sample data for explaining a specific example of the process of the control unit of the deposit processing device according to the present embodiment. [Figure 6C] FIG. 6C is a diagram showing sample data for explaining a specific example of the process of the control unit of the deposit processing device according to the present embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0015] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to the embodiment.

[0016] [1. Overview] For example, when a client commissions a construction project to a prime contractor, who then commissions a subcontractor, in order to efficiently carry out the construction project, the client may collectively bear all the expenses that should be borne by the prime contractor and subcontractor, such as parking fees, equipment leasing fees, and industrial waste disposal fees. The client makes a payment to the prime contractor after deducting the amounts borne by the prime contractor and subcontractor, and the prime contractor makes a payment to the subcontractor after deducting the amounts borne by the subcontractor.

[0017] However, in the past, the prime contractor had to register separate deposit slips and payment slips for deductions from the client and deductions to the subcontractor. In other words, it was necessary to create the slips twice. In addition, it was not possible to link the deductions from which client were to be deducted from which subcontractor unless the summaries were recorded on the deposit slips and payment slips. In addition, the deduction amounts arising from each slip were Purchase The amounts need to be offset on the invoice, so the person in charge had to take the time to double-check to make sure there were no mistakes in the amounts or expense items, which placed a heavy burden on the person in charge.

[0018] Therefore, in this embodiment, the prime contractor only needs to register the deposit slip, and the deduction from the client is registered, and even the deduction to the subcontractor is automatically generated, reducing the burden on the prime contractor's staff. In other words, in the past, this series of operations was operated by the prime contractor registering the deposit slip and the payment slip separately, but in this embodiment, a function has been implemented that allows the entire process to be completed by only registering the deposit slip.

[0019] Figure 1 is a diagram to explain the overall picture of contractor payment deductions at the time of payment. In Figure 1, if the client advances parking fees, lease fees, industrial waste disposal fees, etc. that should be borne by the prime contractor or subcontractor, the amount advanced is deducted at the time of payment from the client to the prime contractor.

[0020] (T1) First, the client places an order with the prime contractor (order amount: 100,000,000 yen). (T2) The prime contractor places an order with the subcontractor (order amount: 5,000,000 yen). (T3) The client contracts for a parking lot near the construction site during the construction period (contract amount: 3,000,000 yen). (T4) The prime contractor uses the parking lot contracted by the client (usage amount: 1,600,000 yen), and (T5) the subcontractor uses the parking lot contracted by the client (usage amount: 400,000 yen).

[0021] (T6) The subcontractor invoices the prime contractor for the work (invoiced amount: 5 million yen). (T7) The prime contractor invoices the client for the work (invoiced amount: 100 million yen). (T8) The client pays the prime contractor for the work (payment amount: 98 million yen). In this case, the client pays 98 million yen, which is the order amount: 100 million yen minus the parking lot usage by the prime contractor and subcontractor (deduction amount: 1,600 thousand yen + 400 thousand yen). (T9) The prime contractor pays the subcontractor for the work (payment amount: 4,600 thousand yen). In this case, the client pays 4,600 thousand yen, which is the order amount: 5 million yen minus the parking lot usage by the subcontractor (deduction amount: 400 thousand yen).

[0022] FIG. 2 is a diagram for explaining the operation of a conventional system for deduction from vendor payment at the time of receipt.

[0023] (1) Deposit entry When processing payment from the client, the invoice amount of 100,000,000 yen is settled based on the received amount of 98,000,000 yen and the deduction amount of 2,000,000 yen. When creating the payment slip, the deduction amount is registered and the summary indicates which subcontractor it is deductioned from.

[0024] (2) Purchase entry (advance payment registration) The parking fee of 400,000 yen used by the subcontractor, which was deducted from the client, is registered as a payment schedule of -400,000 yen (this does not affect the cost price). A separate negative payment slip is created to offset the deduction amount, and the summary indicates which client it is deducted from.

[0025] (3) Purchase entry From the invoice amount of 5,000,000 yen from the subcontractor, record the cost and the planned payment of 5,000,000 yen.

[0026] (4) Payment and Settlement We will pay 4,600,000 yen to subcontractors out of the planned payment of 5,000,000 yen - 400,000 yen.

[0027] FIG. 3 is a diagram for explaining the system operation of the deposit time trader payment deduction in this embodiment.

[0028] (1) Deposit entry When processing payment from the client, the invoice amount of 100,000,000 yen is settled based on the payment amount of 98,000,000 yen and the deduction amount of 2,000,000 yen. If there is a deduction to a subcontractor when payment is received from the client, the subcontractor to which the deduction was made is registered.

[0029] (2) Deposit entry (deposit adjustment) Of the deduction amount of 2,000,000 yen in (1), the 400,000 yen to the prime contractor is automatically created as a payment schedule of -400,000 yen. A negative payment slip is automatically created from the deduction information for the subcontractor.

[0030] (3) Purchase entry From the invoice amount of 5,000,000 yen from the subcontractor, record the cost and the planned payment of 5,000,000 yen.

[0031] (4) Payment and Settlement We will pay 4,600,000 yen to subcontractors out of the planned payment of 5,000,000 yen - 400,000 yen.

[0032] (5) Offsetting Agreement Notify the subcontractor of the deduction information. Issue a document (offset agreement) that can confirm the link between the client and the subcontractor.

[0033] The deposit processing device of this embodiment is used in construction work, facility construction, civil engineering work, etc. It is widely available to construction contractors, including subcontractors.

[0034] [2. Configuration] An example of a deposit processing device according to this embodiment will be described with reference to Fig. 4. Fig. 4 is a block diagram showing an example of the configuration of the deposit processing device according to this embodiment.

[0035] In Fig. 4, the deposit processing device 100 is a commercially available desktop personal computer. The deposit processing device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, tablet personal computer, etc.

[0036] The deposit processing device 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. Each unit of the deposit processing device 100 is connected to each other so as to be able to communicate with each other via an arbitrary communication path.

[0037] The communication interface unit 104 communicably connects the deposit 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 the communication line. Here, the network 300 has a function of connecting the deposit processing device 100, the sales management system 400, the accounting system 500, the server 200, etc., so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

[0038] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as a monitor 114.

[0039] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106. The storage unit 106 also includes a data file 106a.

[0040] The data file 106a is a file for storing various data such as construction contract data, billing data, payment data, payment adjustment data, payment reconciliation data, contractor deduction data, purchase data, payment data, project cost data, and offset agreement data.

[0041] The construction contract data may include data such as project number, project name, billing code, billing name, and order amount.

[0042] The billing data may include the following data: billing number, expected collection date, billing destination code, billing destination name, billing item code, billing item name, debt item code, debt item name, payment method code, payment method name, and billing amount.

[0043] The deposit data may include the following data: deposit number, deposit date, deposit recipient code, deposit recipient name, deposit method code, deposit method name, and deposit amount.

[0044] The payment adjustment data may include the following data: payment number, adjustment detail number, adjustment item code, adjustment item name, adjustment amount, offset category (1: company's deduction, 2: subcontractor's deduction), offset category name (company's deduction, subcontractor's deduction), project number, project name, supplier code, and supplier name.

[0045] When offset target category = 1, project number can be entered on the input screen, but supplier code cannot be entered. When offset target category = 2, project number cannot be entered on the input screen, but supplier code can be entered. When offset target category = 2, negative purchase data is generated.

[0046] The deposit reconciliation data may include data such as deposit number, deposit reconciliation number, reconciliation line number, and reconciliation amount.

[0047] The vendor deduction data may include the following data: Payee Code, Payee Name, Purchase No, Payment No, Adjustment Detail No, Payee Code, and Payee Name. The vendor deduction data, which links the payment adjustment data to the purchase data, allows for the generation of offset agreements at a later time.

[0048] Purchase data may include purchase number, purchase date, payee code, payee name, payment item code, payment item name, debt item code, debt item name, payment method code, payment method name, purchase amount, project number, and project name.

[0049] Payment data may include the following data: payment number, scheduled payment date, payee code, payee name, purchase number, debt item code, debt item name, payment method code, payment method name, and payment amount.

[0050] The project cost data may include data such as project number, project name, cost accounting date, cost element code, cost element name, and cost amount.

[0051] The offset agreement data may include data such as payee code, payee name, payment number, expected payment month, payment amount, purchase number, payment number, adjustment detail number, payee code, payee name, and adjustment amount.

[0052] The control unit 102 is a CPU or the like that controls the deposit processing device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. The control unit 102 conceptually includes a construction contract processing unit 102a, a billing processing unit 102b, a deposit processing unit 102c, a purchase processing unit 102d, a payment processing unit 102e, a project cost processing unit 102f, an offset agreement processing unit 102g, and a screen display control unit 102h.

[0053] The construction contract processing unit 102a creates construction contract data including the project (project number and / or project name), billing destination (billing destination code and / or billing destination name), and amount received in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0054] The billing processing unit 102b generates billing data based on the construction contract data, including billing number, scheduled collection date, billing recipient (billing recipient code and / or billing recipient name), billing item (billing item code and / or billing item name), credit item (credit item code and / or credit item name), payment method (payment method code and / or payment method name), and billing amount, in response to, for example, operator operations on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0055] When a deposit is made from a payee (billing destination), the deposit processing unit 102c generates deposit data including the deposit number, deposit date, payee (payee code and / or payee name), deposit method (deposit method code and / or deposit method name), and deposit amount, for example in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0056] In addition, when the deposit processing unit 102c creates deposit data, it generates deposit adjustment data including deposit number, adjustment detail number, adjustment item code, adjustment item name, adjustment amount, offset target category, offset target category name, project number, project name, supplier code, and supplier name, for example, in response to operator operations on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0057] In addition, the deposit processing unit 102c generates deposit reconciliation data including a deposit number, a deposit reconciliation number, and an amount to be reconciled based on the deposit data and the deposit adjustment data, for example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0058] In addition, the deposit processing unit 102c generates vendor deduction data based on the deposit data and deposit adjustment data in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0059] The purchase processing unit 102d generates purchase data including a purchase number, a purchase date, a subcontractor payee, a payment item, a debt item, and a purchase amount based on the receipt adjustment data in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a. At that time, if the offset target category of the receipt adjustment data is a subcontractor deduction amount, a negative adjustment amount is registered as a negative purchase amount. Purchase Generate data and set the order amount as the purchase amount Purchase Generate data.

[0060] The payment processing unit 102e generates payment data based on the purchase data, including the payment number, scheduled payment date, the subcontractor payee, purchase number, debt item, and payment amount, in response to, for example, the operator's operations on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0061] The project cost processing section 102f generates project cost data including the project, the cost accounting year and month, the cost elements, and the cost amount based on the purchase data in response to, for example, the operator's operations on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0062] The offset agreement processing unit 102g, for example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, refers to the vendor deduction data, and obtains the payment amount from the payment data using the purchase number as a key, obtains the payment destination from the payment data using the deposit number as a key, and obtains the adjustment amount from the deposit adjustment data, generates offset agreement data including the payment destination, payment number, scheduled payment month, payment amount, purchase number, deposit destination, and adjustment amount, and registers it in the data file 106a.

[0063] The screen display control unit 102h controls, for example, the display of various screens (for example, input screens for various data) displayed on the monitor 114 and the reception of inputs therefor.

[0064] [3. Specific Examples] A specific example of the process of the deposit processing device 100 according to the present embodiment will be described with reference to Figs. 4 to 6. Fig. 5 is a diagram showing a flow for explaining the overall process flow of the deposit processing device 100 according to the present embodiment. Figs. 6A to 6C are diagrams showing sample data for explaining a specific example of the process of the control unit of the deposit processing device 100 according to the present embodiment.

[0065] (3-1. Overall processing) The overall process flow of the deposit processing device 100 according to this embodiment will be described with reference to FIG.

[0066] 5, the construction contract processing unit 102a executes construction contract input processing (step S1). Specifically, in the construction contract input processing, the construction contract processing unit 102a creates construction contract data including a project (project number and / or project name), billing destination (billing destination code and / or billing destination name), and received amount in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, for example, and registers the data in the data file 106a.

[0067] The billing processor 102b executes billing input processing (step S2). Specifically, in the billing input processing, the billing processor 102b generates billing data including billing number, scheduled collection date, billing destination (billing destination code and / or billing destination name), billing item (billing item code and / or billing item name), credit item (credit item code and / or credit item name), payment method (payment method code and / or payment method name), and billing amount based on the construction contract data in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the generated data in the data file 106a.

[0068] The deposit processing unit 102c executes the deposit input process (step S3). This corresponds to (1) in Fig. 3. Specifically, in the deposit input process, when a deposit is received from a deposit destination (billing destination), the deposit processing unit 102c generates deposit data including the deposit number, deposit date, deposit destination (deposit destination code and / or deposit destination name), deposit method (deposit method code and / or deposit method name), and deposit amount in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0069] The deposit processing unit 102c executes the deposit adjustment process (step S4). This corresponds to (2) in Fig. 3. Specifically, in the deposit adjustment process, when the deposit data is created, the deposit processing unit 102c generates deposit adjustment data including the deposit number, adjustment detail number, adjustment item code, adjustment item name, adjustment amount, offset target category, offset target category name, project number, project name, supplier code, and supplier name in response to the operator's operation on the input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0070] The deposit processing unit 102c executes the deposit reconciliation process (step S5). Specifically, in the deposit reconciliation process, the deposit processing unit 102c generates deposit reconciliation data including a deposit number, a deposit reconciliation number, and an amount to be reconciled based on the deposit data and the deposit adjustment data in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, for example, and registers the data in the data file 106a.

[0071] The deposit processing unit 102c executes the business deduction processing (step S6). Specifically, in the business deduction processing, the deposit processing unit 102c generates business deduction data based on the deposit data and the deposit adjustment data in response to the operator's operation on the input screen (not shown) displayed on the monitor 114, for example, and registers the data in the data file 106a.

[0072] The purchase processing unit 102d executes the purchase input process (step S7). This corresponds to (3) in FIG. 3. Specifically, in the purchase input process, the purchase processing unit 102d generates purchase data including the purchase number, purchase date, payee (subcontractor), payment item, debt item, and purchase amount based on the receipt adjustment data in response to the operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a. At that time, if the offset target category in the receipt adjustment data is the subcontractor deduction amount, a negative offset is generated so that the adjustment amount is a negative purchase amount. Purchase Generate data and set the order amount as the purchase amount Purchase Generate data.

[0073] The payment processing unit 102e executes the payment input process (step S8). This corresponds to (4) in Fig. 3. Specifically, in the payment input process, the payment processing unit 102e generates payment data based on the purchase data in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, including a payment number, a scheduled payment date, a payee who is a subcontractor, a purchase number, a debt item, and a payment amount, and registers the generated payment data in the data file 106a.

[0074] The project cost processing section 102f executes a project cost generation process (step S9). Specifically, in the project cost generation process, the project cost processing section 102f generates project cost data including a project, a cost recording date, a cost element, and a cost amount based on purchase data in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, for example, and registers the generated data in the data file 106a.

[0075] The offset agreement processing unit 102g executes offset agreement generation processing (step S10). This corresponds to (5) in FIG. 3. Specifically, in the offset agreement generation processing, the offset agreement processing unit 102g refers to the contractor deduction data in response to the operator's operation on the input screen (not shown) displayed on the monitor 114, for example, acquires the payment amount of the payment data using the purchase number as a key, acquires the payee from the payee data using the payment number as a key, and acquires the adjustment amount from the payee adjustment data, generates offset agreement data including the payee, payment number, scheduled payment month, payment amount, purchase number, payee, and adjustment amount, and registers it in the data file 106a. The offset agreement data is sent (notified) to the subcontractor.

[0076] (3-2. Sample data) A specific example of the process of the deposit processing device 100 according to this embodiment will be described with reference to sample data in FIGS. 6A to 6C.

[0077] (S1: Construction contract input processing). The construction contract processing unit 102a creates construction contract data including the project (project number and / or project name), billing destination (billing destination code and / or billing destination name), and amount received in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0078] Fig. 6A(A) shows an example of construction contract data. The example of construction contract data shown in Fig. 6A(A) includes project number "PJ001", project name "XX Construction", billing code "TSK001", billing name "XX Construction", and order amount "100,000,000".

[0079] (S2: Billing entry processing). The billing processing unit 102b generates billing data based on the construction contract data, including billing number, scheduled collection date, billing recipient (billing recipient code and / or billing recipient name), billing item (billing item code and / or billing item name), credit item (credit item code and / or credit item name), payment method (payment method code and / or payment method name), and billing amount, in response to, for example, operator operations on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0080] Fig. 6A(B) is a diagram showing an example of billing data. In the example of billing data shown in Fig. 6A(B), the first line contains billing number "SK001", expected collection date "20XX / XX", billing code "TSK001", billing name "XX Construction", billing item code "SE001", billing item name "Construction completion", credit item code "SK001", credit item name "Completed construction account receivable", payment method code "NY1001", payment method name "Bank transfer", and billing amount "100,000,000".

[0081] (S3: Deposit input processing) When a deposit is made from a payee (billing destination), the deposit processing unit 102c generates deposit data including the deposit number, deposit date, payee (payee code and / or payee name), deposit method (deposit method code and / or deposit method name), and deposit amount, for example in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0082] Fig. 6B(C) is a diagram showing an example of deposit data. In the example of deposit data shown in Fig. 6B(C), the first line contains deposit number "NY001", deposit date "20XX / X / X", deposit code "TSK001", deposit name "XX Construction", deposit method code "NY1001", deposit method name "transfer", and deposit amount "98,000,000".

[0083] (S4: Deposit adjustment process) When the deposit processing unit 102c creates deposit data, it generates deposit adjustment data including deposit number, adjustment detail number, adjustment item code, adjustment item name, adjustment amount, offset target category, offset target category name, project number, project name, supplier code, and supplier name, for example, in response to operator operations on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0084] Figure 6B(D) is a diagram showing an example of payment adjustment data. On the input screen, when offset target category = 1, project number can be entered but supplier code cannot be entered, and when offset target category = 2, project number cannot be entered but supplier code can be entered. When offset target category = 2, negative purchase data is generated.

[0085] In the example of deposit adjustment data in Figure 6B (D), the first line has the deposit number "NY001," adjustment detail number "1," adjustment item code "TYS001," adjustment item name "parking fee (original)," adjustment amount "1,600,000," offset item category "1," offset item category name "company deduction," project number "PJ001," and project name "○○ construction."

[0086] The second line has the deposit number "NY001", adjustment detail number "2", adjustment item code "TYS002", adjustment item name "Advance payment", adjustment amount "400,000", offset item category "2", offset item category name "Contractor deduction", supplier code "TSH001", and supplier name "○○ Construction Company".

[0087] (S5: Payment reconciliation process) The deposit processing unit 102c generates deposit reconciliation data including a deposit number, a deposit reconciliation number, and an amount to be reconciled based on the deposit data and the deposit adjustment data, for example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0088] Fig. 6B(E) is a diagram showing an example of deposit reconciliation data. In the example of deposit reconciliation data shown in Fig. 6B(E), the first line is deposit number "NY001", deposit reconciliation number "NK001", reconciliation line number "1", reconciliation amount "98,000,000", the second line is deposit number "NY001", deposit reconciliation number "NK001", reconciliation line number "2", reconciliation amount "1,600,000", the third line is deposit number "NY001", deposit reconciliation number "NK001", reconciliation line number "3", reconciliation amount "400,000".

[0089] (S6: Business deduction processing) The deposit processing unit 102c generates vendor deduction data based on the deposit data and the deposit adjustment data in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a. The vendor deduction data is data for linking the deposit adjustment data and the purchase data, and offset agreement data can be generated later based on the vendor deduction data.

[0090] Fig. 6B(F) is a diagram showing an example of contractor deduction data. In the example of contractor deduction data shown in Fig. 6B(F), the payee code is "TSH001", the payee name is "XX Construction", the purchase number is "SY001", the payment number is "NY001", the adjustment detail number is "2", the payee code is "TSK001", and the payee name is "XX Construction".

[0091] (S7: Purchase input processing) The purchase processing unit 102d generates purchase data including purchase number, purchase date, subcontractor payee, payment item, debt item, and purchase amount based on the payment adjustment data in response to the operator's operation on the input screen (not shown) displayed on the monitor 114, and registers it in the data file 106a. At that time, for the payment adjustment data offset target category = 2: for the vendor deduction amount, the adjustment amount is the negative purchase amount. Purchase Data and order amount are used as purchase amount Purchase Generate data. Adjustment data offset category = 1: For the in-house deduction amount, do not generate purchase data since it is the in-house deduction amount.

[0092] Figure 6B(G) is a diagram showing an example of purchase data in the case of offset target category = 2: contractor deduction in the second line of the payment adjustment data in Figure 6B(D). In the example shown in Figure 6B(G), the purchase number is "SY001", purchase date is "20XX / X / X", payee code "TSH001", payee name "XX Construction Company", payment item code "SI099", payment item name "Advance payment", debt subject code "SM001", debt subject name "Construction unpaid", payment method code "SH2001", payment method name "Transfer", and purchase amount "-400,000".

[0093] Figure 6B(H) is based on the invoice amount (order amount) of "5,000,000" from a subcontractor (XX Construction Company). Purchase 6B(H) is a diagram showing an example of data. In the example shown in Fig. 6B(H), the purchase number is "SY002", purchase date is "20XX / X / Y", payee code is "TSH001", payee name is "XX Construction Company", payment item code is "SI001", payment item name is "XX work", payable item code is "SM001", payable item name is "construction unpaid", payment method code is "SH2001", payment method name is "transfer", purchase amount is "5,000,000", project number is "PJ001", and project name is "XX construction".

[0094] (S8: Payment processing unit) The payment processing unit 102e generates payment data based on the purchase data, including the payment number, scheduled payment date, the subcontractor payee, purchase number, debt item, and payment amount, in response to, for example, the operator's operations on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0095] FIG. 6B(I) is a diagram showing an example of payment data. In the example shown in Figure 6B (I), the first line has payment number "SH001", scheduled payment date "Z / Z / 20XX", payee code "TSH001", payee name "○○ Construction Company", purchase number "SY001", debt item code "SM001", debt item name "Unpaid for construction work", payment method code "SH2001", payment method name "Transfer", and payment amount "-400,000". The second line has payment number "SH001", scheduled payment date "Z / Z / 20XX", payee code "TSH001", payee name "○○ Construction Company", purchase number "SY002", debt item code "SM001", debt item name "Unpaid for construction work", payment method code "SH2001", payment method name "Transfer", and payment amount "5,000,000".

[0096] (S9: Project cost generation process) The project cost processing section 102f generates project cost data including the project, the cost accounting year and month, the cost elements, and the cost amount based on the purchase data in response to, for example, the operator's operations on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106a.

[0097] Figure 6C(J) is a diagram showing an example of project cost data. In the example shown in Figure 6C(J), the project number is "PJ001", the project name is "XX construction", the cost recording date is "20XX / Z month", the cost element code is "GK001", the cost element name is "subcontract cost", and the cost amount is "5,000,000". The recorded cost amount is "5,000,000" before offsetting. This can be confirmed in the cost ledger or cost summary sheet.

[0098] (S10: Offsetting Agreement Processing) The offset agreement processing unit 102g, for example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, refers to the vendor deduction data, and obtains the payment amount of the payment data using the purchase number as a key, obtains the payee from the deposit data using the deposit number as a key, and obtains the adjustment amount from the deposit adjustment data, generates offset agreement data including the payee, payment number, scheduled payment month, payment amount, purchase number, deposit destination, and adjustment amount, and registers it in the data file 106a.

[0099] Fig. 6C(K) is a diagram showing an example of offset agreement data. By referring to the contractor deduction data, the payment amount per payment number of the payment data is obtained from the purchase number, and the payment destination and adjustment amount are obtained from the payment data and payment adjustment data from the payment number and its adjustment detail number. In the example shown in Fig. 6C(K), the payee code is "TSH001", the payee name is "XX Construction", the payment number is "SH001", the scheduled payment month is "20XX year Z month", the payment amount is "4,600,000", the purchase number is "SY001", the payment number is "NY001", the adjustment detail number is "2", the payee code is "TSK001", the payee name is "XX Construction", and the adjustment amount is "400,000".

[0100] As described above, according to this embodiment, when the construction fee, excluding the advance payment, for the target project is received from the client, a deposit processing unit 102c generates deposit data including the deposit number, deposit date, payee who is the client, deposit method, and deposit amount, and generates deposit adjustment data for the deposit data including the deposit number, adjustment item, adjustment amount, offset target category specifying the company's deduction or subcontractor's deduction, the project if the offset target category is the company's deduction, and the supplier if the offset target category is the subcontractor's deduction; and generates purchase data including the purchase number, purchase date, payee who is a subcontractor, payment item, debt item, and purchase amount based on the deposit adjustment data, and at that time, if the offset target category of the deposit adjustment data is the subcontractor's deduction, generates a negative purchase amount with the adjustment amount being a negative purchase amount. Purchase Generate data and set the order amount as the purchase amount PurchaseThe system is equipped with a purchase processing unit 102d that generates data, and a payment processing unit 102e that generates payment data including the payment number, scheduled payment date, subcontractor payee, purchase number, debt item, and payment amount based on the purchase data. Therefore, when the client pays the prime contractor for the construction work and deducts the advances of the prime contractor and subcontractor before making the payment, the prime contractor can simply register the deposit slip and automatically register the deductions from the client and the deductions to the subcontractor, thereby reducing the burden on the prime contractor's staff.

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

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

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

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

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

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

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

[0108] For example, the processing functions of the deposit processing device 100, particularly the processing functions performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the deposit processing device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in the storage unit 106 such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into the RAM, and constitutes the control unit 102 in cooperation with the CPU.

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

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

[0111] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.

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

[0113] The deposit 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. The deposit processing device 100 may be realized by implementing software (including programs or data, etc.) that causes the information processing device to realize the processing described in this embodiment.

[0114] Furthermore, the specific form of distribution and integration of the devices is not limited to those 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 function additions. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Explanation of symbols]

[0115] 100 Deposit processing device 102 Control section 102a Construction Contract Department 102b Claims Processing Department 102c Deposit Processing Unit 102d Purchasing Department 102e Payment Processing Unit 102f Project Cost Processing Section 102g Offsetting Agreement Processing Section 102h Screen display control unit 104 Communication interface section 106 Storage section 106a Data File 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. A deposit processing device equipped with a control unit, The control unit is a deposit processing means for generating deposit data including the deposit number, deposit date, deposit recipient (the client), deposit method, and deposit amount, when the construction fee for the target project, less the advance payment, is received from the client in response to an operation by an operator on the input screen, and for the deposit data, generating deposit adjustment data including the deposit number, adjustment item, adjustment amount, offset category specifying the company's deduction or subcontractor's deduction, the project when the offset category is the company's deduction, and the supplier when the offset category is the subcontractor's deduction, in response to an operation by the operator on the input screen; a purchase processing means for generating purchase data including a purchase number, a purchase date, a payee which is a subcontractor, a payment item, a debt item, and a purchase amount based on said payment adjustment data in response to an operator's operation on the input screen, and at that time, generating negative purchase data with the adjustment amount as the negative purchase amount when the offset target category of said payment adjustment data is a subcontractor deduction amount, and generating purchase data with the order amount as the purchase amount; a payment processing means for generating payment data including a payment number, a scheduled payment date, a subcontractor as a payee, a purchase number, a debt item, and a payment amount based on the purchase data in response to an operator's operation on an input screen; A deposit processing device comprising:

2. The deposit processing device according to claim 1, characterized in that the deposit processing means generates deposit reconciliation data including a deposit number, a deposit reconciliation number, and an amount to be reconciled based on the deposit data and the deposit adjustment data in response to an operator's operation on an input screen.

3. The deposit processing device according to claim 1 or 2, characterized in that the deposit processing means generates vendor deduction data including a payee, a purchase number, a deposit number, and a deposit destination based on the deposit data and the deposit adjustment data in response to an operator's operation on an input screen.

4. The control unit further The deposit processing device according to any one of claims 1 to 3, further comprising a project cost processing means for generating project cost data including a project, a cost recording date, a cost element, and a cost amount based on the purchase data in response to an operator's operation on an input screen.

5. The control unit further A deposit processing device as described in claim 3, characterized in that it is equipped with an offset agreement processing means which refers to the vendor deduction data, obtains the payment amount of the payment data using the purchase number as a key, obtains the payee from the deposit data using the deposit number as a key, and obtains the adjustment amount from the deposit adjustment data, and generates offset agreement data including the payee, payment number, scheduled payment month, payment amount, purchase number, payee, and adjustment amount.

6. A deposit processing method executed by an information processing device having a control unit, Executed in the control unit: a deposit processing step for generating deposit data including the deposit number, deposit date, deposit recipient (the client), deposit method, and deposit amount, when the construction fee for the target project is received from the client, in response to the operation of the operator on the input screen, and for the said deposit data, in response to the operation of the operator on the input screen, generating deposit adjustment data including the deposit number, adjustment item, adjustment amount, offset category specifying the company's deduction or subcontractor's deduction, the project if the offset category is the company's deduction, and the supplier if the offset category is the subcontractor's deduction; a purchase processing step of generating purchase data including a purchase number, a purchase date, a payee which is a subcontractor, a payment item, a debt item, and a purchase amount based on the payment adjustment data in response to an operator's operation on the input screen, and at that time, generating negative purchase data with the adjustment amount as the negative purchase amount when the offset target category of the payment adjustment data is a subcontractor deduction amount, and generating purchase data with the order amount as the purchase amount; a payment processing step of generating payment data including a payment number, a scheduled payment date, a subcontractor as a payee, a purchase number, a debt item, and a payment amount based on the purchase data in response to an operator's operation on an input screen; A deposit processing method comprising:

7. A deposit processing program to be executed by an information processing device having a control unit, The control unit, a deposit processing step for generating deposit data including the deposit number, deposit date, deposit recipient (the client), deposit method, and deposit amount, when the construction fee for the target project is received from the client, in response to the operation of the operator on the input screen, and for the said deposit data, in response to the operation of the operator on the input screen, generating deposit adjustment data including the deposit number, adjustment item, adjustment amount, offset category specifying the company's deduction or subcontractor's deduction, the project if the offset category is the company's deduction, and the supplier if the offset category is the subcontractor's deduction; a purchase processing step of generating purchase data including a purchase number, a purchase date, a payee which is a subcontractor, a payment item, a debt item, and a purchase amount based on the payment adjustment data in response to an operator's operation on the input screen, and at that time, generating negative purchase data with the adjustment amount as the negative purchase amount when the offset target category of the payment adjustment data is a subcontractor deduction amount, and generating purchase data with the order amount as the purchase amount; a payment processing step of generating payment data including a payment number, a scheduled payment date, a subcontractor as a payee, a purchase number, a debt item, and a payment amount based on the purchase data in response to an operator's operation on an input screen; A deposit processing program to execute the above.

Images