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

Abstract

To provide a cancellation processing device, cancellation processing method, and cancellation processing program that can cancel the turnout and the reimbursed amount such as expenses of a construction with a simple and low workload when an order source places an order of the construction to a subcontractor.SOLUTION: A cancellation processing device according to this embodiment includes purchase input means which creates purchase data that includes the purchase number, purchase date, order number, handling business operator, order date, prime cost subject, order amount, current month purchase amount specified by an operator, and liability subject on the basis of order data, refers to associated data, retrieves expense payment schedule data of the expense number associated with the order number of the purchase data as a cancellation candidate against the current month purchase amount of the purchase data, determines the payment schedule data of the expense number specified by the operator as a cancellation target, and creates reimbursed purchase data that includes the purchase number, purchase date, reimbursement destination, order number, reimbursement subject, and reimbursement amount for the determined cancellation target.SELECTED DRAWING: Figure 1

Description

[Technical Field]

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

[0002] For example, in the construction industry, when an ordering party orders construction work from an outsourced contractor, the ordering party often pays for the materials and expenses for the construction work in advance. Conventionally, there is a system for processing construction work fees, for example, as disclosed in Patent Document 1. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2017-91279 Summary of the Invention [Problem to be solved by the invention]

[0004] However, the above-mentioned Patent Document 1 does not state anything about how, when an ordering party places an order with a subcontractor, the amount of work completed and the amount of expenses and other expenses paid in advance can be offset easily and with little work load.

[0005] The present invention has been made in consideration of the above, and aims to provide an offsetting processing device, an offsetting processing method, and an offsetting processing program that, when an ordering party orders construction work from an outsourced contractor, can offset the amount of construction work completed and the amount of expenses and other advance payments simply and with little workload. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides an offsetting processing device equipped with a control unit, the control unit comprising: order input means for, when placing an order for construction work with a subcontractor, creating order data including order number, subcontractor, order subject, cost item, order date, ordered construction period, order amount, and debt item, and registering it in a storage area; expense import means for creating expense payment schedule data for unpaid vouchers and advance vouchers for the construction work, including expense number, date of occurrence, trading company, expense item, amount, and debt item, and registering it in the storage area, as well as creating linking data linking expense numbers and order numbers, and registering it in the storage area; and expense import means for importing purchase number, purchase date, order number, handling company, order date, cost item, order amount, and debt item specified by an operator based on the order data registered in the storage area. and a purchase input means for creating purchase data including the purchase amount and debt item for the current month to be set, referring to the linking data registered in the storage area, reading out from the storage area the scheduled expense payment data for the expense number linked to the purchase order number of the purchase data as a candidate for offset with the purchase amount for the current month of the purchase data, determining the scheduled payment data for the expense number designated by the operator as the offset target, creating advance payment purchase data for the determined offset target including the purchase number, purchase date, advance payment recipient, purchase order number, advance payment item, and advance payment amount, and creating scheduled payment data including the payment number, scheduled payment date, payee company, and scheduled payment amount based on the purchase data and the advance payment purchase data.

[0007] According to another aspect of the present invention, the purchase input means may be configured to be able to designate one or more of the offset candidates as targets for offset with the purchase amount in the following month and thereafter.

[0008] In addition, according to one aspect of the present invention, the control unit is configured to be able to access an item setting master that associates and registers expense items with cost items that serve as debit items in journal entries, and the expense capture means may refer to the item setting master based on the expense payment schedule data and create journal entry data that includes the journal entry number, accounting date, customer, debit item, debit amount, credit item, and credit amount.

[0009] According to one aspect of the present invention, the purchase input means may create journal data including a journal number, a recording date, a customer, a debit item, a debit amount, a credit item, and a credit amount based on the purchase data and the advance purchase data.

[0010] According to another aspect of the present invention, the control unit may further include a payment statement management means for creating and outputting a payment statement based on the purchase data, the advance purchase data, and the payment schedule data.

[0011] Furthermore, in order to solve the above-mentioned problems and achieve the object, the present invention provides an offsetting processing method executed by an information processing device having a control unit, which includes an order input process executed by the control unit to create and register in a storage area order data including an order number, subcontractor, order subject, cost item, order date, ordered construction period, order amount, and debt item when placing an order for construction work with a subcontractor; an expense import process to create and register in the storage area expense payment schedule data including an expense number, occurrence date, trading company, expense item, amount, and debt item for unpaid vouchers and advance vouchers for the construction work, and to create and register in the storage area linking data linking the expense number and order number; and an expense import process to create and register in the storage area purchase number, purchase date, order number, handling company, and other related data based on the order data registered in the storage area. and a purchase input process of creating purchase data including the purchase date, order date, cost item, order amount, purchase amount for the current month designated by the operator, and debt item, referring to the linking data registered in the storage area, reading out from the storage area the scheduled expense payment data for the expense number linked to the purchase number of the purchase data as a candidate for offset with the purchase amount for the current month of the purchase data, determining the scheduled payment data for the expense number designated by the operator as the offset target, creating advance purchase data for the determined offset target including the purchase number, purchase date, advance payment recipient, order number, advance payment item, and advance payment amount, and creating scheduled payment data including the payment number, scheduled payment date, payee vendor, and scheduled payment amount based on the purchase data and the advance purchase data.

[0012] In order to solve the above-mentioned problems and achieve the object, the present invention provides an offset processing program to be executed by an information processing device having a control unit, the offset processing program including an order input step in the control unit for creating order data including an order number, a subcontractor, an order subject, a cost item, an order date, an order construction period, an order amount, and a debt item when placing an order for construction work with a subcontractor, and registering the order data in a storage area; an expense import process for creating and registering in the storage area, with respect to unpaid vouchers and advance vouchers for construction work, scheduled expense payment data including expense number, date of occurrence, business operator, expense item, amount, and debt item, and linking data linking the expense number and purchase order number; and a process for creating and registering in the storage area, based on the purchase order data registered in the storage area, purchase data including purchase number, purchase date, purchase order number, handling business operator, purchase date, cost item, purchase amount, purchase amount for the current month designated by an operator, and debt item, and and a purchase input process of reading out from the storage area the scheduled expense payment data of the expense number linked to the purchase number as a candidate for offsetting with the purchase amount of the purchase data for the current month, determining the scheduled payment data of the expense number specified by the operator as the offset target, creating advance purchase data for the determined offset target, including the purchase number, purchase date, advance payment recipient, order number, advance payment subject, and advance payment amount, and creating payment schedule data, including the payment schedule number, payment schedule date, payment recipient company, and payment schedule amount, based on the purchase data and the advance purchase data. [Effects of the Invention]

[0013] According to the present invention, when an ordering party orders construction work from an outsourced contractor, it is possible to offset the amount of construction work completed and the amount of expenses and other expenses paid in advance, simply and with a low workload. [Brief explanation of the drawings]

[0014] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of the offset processing device according to this embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of the configuration of the subject setting master. [Figure 3] FIG. 3 is a diagram showing a flow for explaining an outline of the overall processing of the control unit of the offset processing device according to this embodiment. [Figure 4] FIG. 4 is a diagram for explaining a specific example of the processing of the control unit of the offset processing device according to this embodiment. [Figure 5] FIG. 5 is a diagram for explaining a specific example of the processing of the control unit of the offset processing device according to this embodiment. [Figure 6] FIG. 6 is a diagram for explaining a specific example of the processing of the control unit of the offset processing device according to this embodiment. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the processing of the control unit of the offset processing device according to this embodiment. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the processing of the control unit of the offset processing device according to this embodiment. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the processing of the control unit of the offset processing device according to this embodiment. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the processing of the control unit of the offset processing device according to this embodiment. [Figure 11] FIG. 11 is a diagram for explaining a specific example of the processing of the control unit of the offset processing device according to this embodiment. [Figure 12] FIG. 12 is a diagram for explaining a specific example of the processing of the control unit of the offset processing device according to this embodiment. [Figure 13] FIG. 13 is a diagram for explaining a specific example of the processing of the control unit of the offset processing device according to this embodiment. [Figure 14] FIG. 14 is a diagram for explaining a specific example of the processing of the control unit of the offset processing device according to this embodiment. DETAILED DESCRIPTION OF THE INVENTION

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

[0016] [1: Overview] For example, in the construction industry, when a client places an order with a subcontractor under an outsourcing contract, the client incurs a large amount of material costs and expenses that are paid in advance to the subcontractor.

[0017] However, in the past, when offsetting subcontractors' progress against unpaid invoices from multiple contractors for materials and expenses, it was difficult to link them to the subcontracting contracts that were the subject of the offset. Furthermore, multiple processes were required, such as unpaid invoices for materials and expenses incurred on behalf of contractors and invoices paid on behalf of subcontractors. It was not possible to manage which contracts and invoices were being paid on behalf of contractors in the system. Therefore, for example, when payment records were used, it was difficult to determine how much was offset against which contract.

[0018] Therefore, in this embodiment, a system is provided that, when construction work is ordered from an outsourced contractor, makes it possible to offset the amount of work completed and the amount of expenses and other expenses paid in advance, simply and with a low workload.

[0019] Specifically, the offset processing device of this embodiment provides the following functions. (1) It allows unpaid invoices and advance invoices for multiple contractors to be generated simultaneously, and enables linking to the contract number of the outsourced work that is subject to offsetting when expenses are imported. (2) Unpaid invoices from multiple contractors, such as parking fees and garbage disposal fees, can be offset as advance payments when recording the progress of outsourced work. (3) In relation to (2), it is also possible to pool the amount of unpaid invoices that have already been generated and that are to be offset, and offset it when the volume of the following month or later is recorded, rather than the volume of the current month.

[0020] The offset processing device of the present invention is widely applicable to industries such as the construction industry (for example, general contractors, large-scale building and apartment construction companies, etc.).

[0021] [2. Configuration] An example of the configuration of the offset processing device according to this 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.

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

[0023] The offsetting processing device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units comprised in the offsetting processing device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0024] The communication interface unit 104 communicably connects the offsetting processing device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the offsetting processing device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

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

[0026] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 stores computer programs that work in conjunction with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 also stores an account setting master 106a, order data, scheduled expense payment data, linking data, journal data, purchase data, advance purchase data, scheduled payment data, etc. Figure 2 is a diagram showing an example of the configuration of the account setting master 106a.

[0027] As shown in FIG. 2, the item setting master 106a can be configured as a table or the like in which expense items and cost items that become the debit side when journalizing are registered in association with each other.

[0028] The order data may include order number, subcontractor, order subject, cost item, order date, order period, order amount, and debt item.

[0029] The expense payment schedule data may include expense number, date of occurrence, supplier, expense item, amount, debt item, and external receipt number.

[0030] The linking data may include an expense number, an order number, and a flag that specifies whether or not to offset with the current month's output ("1" for offset, "0" for no offset).

[0031] The journal data may include journal number, accounting date, customer, debit account, debit amount, credit account, credit amount, and summary.

[0032] The purchase data may include purchase number, purchase date, supplier, order number, order date, cost item, order amount, purchase amount for the current month, and debt item.

[0033] The advance purchase data may include purchase number, purchase date, advance recipient, order number, advance item, and advance amount.

[0034] The payment schedule data may include a payment schedule number, a payment schedule date, a payment destination company, and a payment schedule amount.

[0035] Returning to Fig. 1, the control unit 102 is a CPU or the like that comprehensively controls the offsetting 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.

[0036] The control unit 102 is configured to be able to access the subject setting master 106a, order data, scheduled expense payment data, linking data, journal data, purchase data, advance purchase data, scheduled payment data, etc. stored in the memory unit 106. Note that the subject setting master 106a, order data, scheduled expense payment data, linking data, journal data, purchase data, advance purchase data, scheduled payment data, etc. may be stored in another location (for example, the server 200) as long as the control unit 102 is able to access them.

[0037] The control unit 102 conceptually includes an order input unit 102a, an expense acquisition unit 102b, a purchase input unit 102c, a payment statement management unit 102d, a master maintenance unit 102e, and a screen display control unit 102f.

[0038] When placing an order for construction work with a subcontractor, the order input unit 102a inputs order data including the order number, subcontractor, order subject, cost item, order date, order construction period, order amount, and debt item in response to operations by an operator or the like on an order input screen (not shown) displayed on the monitor 114, and registers the input data in the memory unit 106.

[0039] The expense capture unit 102b, for example, in response to operations by an operator or the like on an expense capture screen (not shown) displayed on the monitor 114, creates expense payment schedule data for unpaid construction vouchers and advance vouchers, including expense number, date of occurrence, trading company, expense item, amount, and debt item, and registers this data in the memory unit 106, and also creates linking data linking the expense number with the order number and registers this data in the memory unit 106.

[0040] In addition, the expense capture unit 102b creates journal data including the journal number, accounting date, business partner, debit account, debit amount, credit account, and credit amount based on the expense payment schedule data registered in the memory unit 106, and registers the data in the memory unit 106 by referring to the account setting master 106a.

[0041] The purchase input unit 102c, for example, in response to operations by an operator or the like on the purchase input screen displayed on the monitor 114, creates purchase data based on the order data registered in the memory unit 106, including the purchase number, purchase date, order number, handling business operator, order date, cost item, order amount, purchase amount for the current month specified by the operator, and debt item; refers to the linking data registered in the memory unit 106, reads out from the memory unit 106 the scheduled expense payment data for the expense number linked to the order number of the purchase data as a candidate for offset with the purchase amount for the current month of the purchase data; determines the scheduled payment data for the expense number specified by the operator as the item to be offset; creates advance payment purchase data for the determined item to be offset, including the purchase number, purchase date, advance payment recipient, order number, advance payment item, and advance payment amount; creates scheduled payment data based on the purchase data and advance payment purchase data, including the scheduled payment number, scheduled payment date, payee, and scheduled payment amount; and registers these created data in the memory unit 106.

[0042] The purchase input unit 102c may be configured to allow one or more of the offset candidates to be designated as the target of offset with the purchase amount in the following month or later.

[0043] The purchase input unit 102c may create journal data including a journal number, accounting date, customer, debit item, debit amount, credit item, and credit amount based on the purchase data and the advance purchase data, and register the data in the storage unit 106.

[0044] The payment statement management unit 102d may, for example, create and output (display and / or print) a payment statement based on purchase data, advance purchase data, and scheduled payment data in response to operator operations on a payment statement management screen (not shown) displayed on the monitor 114.

[0045] The master maintenance unit 102e performs settings such as inputting, adding, changing, and updating data in the subject setting master 106a in response to, for example, an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

[0046] The screen display control unit 102f controls, for example, the display of various screens (for example, an order input screen, an expense import screen, a purchase input screen, a payment statement operation screen, a master maintenance screen, etc.) displayed on the monitor 114 and the reception of inputs therefor.

[0047] [3. Specific Examples] A specific example of the processing performed by the control unit 102 of the offset processing device 100 in this embodiment will be described with reference to FIGS.

[0048] (3-1. Overall processing) FIG. 3 is a diagram showing a flow (flow of piecework calculation) for explaining an outline of the overall processing of the control unit 102 of the offset processing device 100 in this embodiment.

[0049] An overview of the overall processing of the control unit 102 of the offset processing device 100 in this embodiment will be described with reference to Fig. 3. In Fig. 3, the order input unit 102a executes order input processing (step S1). In the order input processing, an order for construction work is placed with a subcontractor. Specifically, in the order input processing, when placing an order for construction work with a subcontractor, the order input unit 102a inputs order data including the order number, subcontractor, order subject, cost item, order date, order construction period, order amount, and debt item in response to operations by an operator or the like on the order input screen displayed on the monitor 114, and stores the data in the memory unit 106.

[0050] The expense capture unit 102b executes expense capture processing (step S2). In the expense capture processing, expense payment schedule data linked to orders is generated. Specifically, in the expense capture processing, the expense capture unit 102b creates expense payment schedule data including expense number, occurrence date, business partner, expense item, amount, and debt item for unpaid vouchers and advance vouchers for construction work in response to operations by an operator or the like on the expense input screen displayed on the monitor 114, and registers the data in the storage unit 106. At the same time, it creates linking data linking expense numbers and order numbers and registers the data in the storage unit 106.

[0051] The purchase input unit 102c executes the purchase input process (step S3). In the purchase input process, the unit receives progress reports from the subcontractor and recognizes the amount of the "progress" payment for the current month. Based on the invoices for materials and expenses used in the construction work that are imported as expenses, unpaid vouchers and advance payment vouchers are registered. In addition, the unit registers the information required to create progress reports and payment reports on the purchase input screen, and acquires the expense payment schedule data linked at the time of recording and generates advance purchase data.

[0052] Specifically, in the purchase input process, the purchase input unit 102c, for example, in response to operations by an operator or the like on the purchase input screen displayed on the monitor 114, creates purchase data based on the order data registered in the memory unit 106, including the purchase number, purchase date, order number, handling company, order date, cost item, order amount, purchase amount for the current month specified by the operator, and debt item; refers to the linking data registered in the memory unit 106, reads out from the memory unit 106 the scheduled expense payment data for the expense number linked to the order number of the purchase data as a candidate for offset with the purchase amount for the current month of the purchase data; determines the scheduled payment data for the expense number specified by the operator as the item to be offset; creates advance payment purchase data for the determined item to be offset, including the purchase number, purchase date, advance payment recipient, order number, advance payment item, and advance payment amount; creates scheduled payment data based on the purchase data and advance payment purchase data, including the scheduled payment number, scheduled payment date, payee, and scheduled payment amount; and registers these created data in the memory unit 106.

[0053] The payment statement operation unit 102d executes payment statement operation processing (step S4). Specifically, in the payment statement operation processing, the payment statement operation unit 102d creates and outputs (displays and / or prints) a payment statement based on purchase data, advance purchase data, and payment schedule data in response to, for example, an operator's operation on a payment statement operation screen (not shown) displayed on the monitor 114. This payment statement is sent to the subcontractor.

[0054] (3-2. Sample data) 4 to 14 are diagrams showing sample data for explaining a specific example of the processing by the control unit 102 of the offsetting processing device 100 in this embodiment. A specific example of the processing by the control unit 102 of the offsetting processing device 100 in this embodiment will be explained with reference to Figs. 4 to 14. In the following explanation, the unit of monetary amount is always "yen", and the notation thereof will be omitted.

[0055] 1. Explain the background information. (S1: Order entry process) The order input process will be described in detail with reference to Figure 4. Order form information for subcontracted work is registered through the order input process. When placing an order for work with a subcontractor, the order input unit 102a inputs order data including the order number, subcontractor, order subject, cost item, order date, order period, order amount, and debt item in response to operations by an operator or the like on an order input screen (not shown) displayed on the monitor 114, and registers the data in the storage unit 106.

[0056] Figure 4 is a diagram showing an example of order data. The order data has the following items: order number, subcontractor, order subject, cost item, order date, order construction period, order amount, and liability item. In the example shown in the figure, the order number is "HAC0001," the subcontractor is "XX Formwork Industry," the order subject is "XX Building Formwork Work," the cost item is "Uncompleted Work Expenditures (Subcontracted)," the order date is "2022 / 3 / 19," the order construction period is "2022 / 4 / 1~2024 / 3 / 31," the order amount is "10,000,000," and the liability item is "Construction Accounts Payable."

[0057] Figure 5 is a diagram that provides an overview of the offsetting example described below. The amount of work completed for outsourced construction work is recorded for subcontractor "XX Formwork Industry." Purchases of 6,000,000 yen are made in June 2022, against a contract amount of 10,000,000 yen. In addition, invoices for unpaid invoices for expenses and materials used in this construction work are received from multiple contractors (XX Recycle, XX Trading, XX Heavy Equipment, XX Crane). The office also receives a detailed breakdown of the amounts advanced to subcontractors (XX Formwork Industry) (totaling 1,000,000 yen) from the site site manager. The unpaid invoices for XX Recycle, XX Heavy Equipment, and XX Crane are offset against the June amount completed by XX Formwork Industry. The portion of XX Trading's unpaid invoices that is to be offset against payments to XX Formwork Industry is to be offset when the amount is recorded the following month, July.

[0058] 2. Use the expense import function to simultaneously create unpaid information and information on planned offsets. (S2: Expense import processing) The expense input process will be described in detail with reference to FIGS. 6 to 8. In the expense input process, unpaid and offsetting vouchers are registered based on invoices for expenses and materials used in subcontracted construction work. The expense capture unit 102b, for example, creates and registers in the storage unit 106 expense payment schedule data for unpaid and advance construction vouchers, including the expense number, date of occurrence, supplier, expense item, amount, and debt item, in response to operations by an operator or the like on an expense input screen (not shown) displayed on the monitor 114. The expense capture unit 102b also creates and registers in the storage unit 106 linking data linking the expense number and the purchase order number. Furthermore, the expense capture unit 102b may refer to the item setting master 106a based on the expense payment schedule data registered in the storage unit 106 to create and register in the storage unit 106 journal data including the journal entry number, posting date, supplier, debit item, debit amount, credit item, and credit amount.

[0059] FIG. 6(A) is a diagram showing an example of the configuration of the item setting master 106a. The item setting master 106a has items for expense items and cost items that are debited when journal entries occur. In the example shown in the figure, for "expense items" such as garbage transportation and disposal costs, miscellaneous hardware, heavy construction machinery, and mobile cranes, "uncompleted construction expenditures" is set as the "cost item." Furthermore, for "expense items" such as advance expense items, "subcontractor advance payments" is set as the "cost item."

[0060] FIG. 6(B) shows an example of an offset schedule received from the site foreman, which lists details of the advance payments.

[0061] First, based on the unpaid information (not shown) and the offset schedule of the unpaid information shown in Figure 6 (B), an expense import format (e.g., an Excel format) is created in accordance with the operator's operations on the expense import screen (not shown).

[0062] Figure 7(A) shows an example of data in the expense import format. The expense import format has fields for temporary voucher number, date of occurrence, vendor, expense item, amount, debt item, and order number. The debt item is set as "unpaid construction costs." In the example shown in the figure, lines 1 to 4 are data about unpaid information. Lines 5 to 8 are data about the offset schedule, which is information about the offset schedule in Figure 6(B). The "order number" is left unset for unpaid information and set for offsetting plans.

[0063] In the example shown in the figure, the first line has the provisional slip number "KAR0001," the date of occurrence "2022 / 6 / 10," the supplier "○○ Recycling," the expense item "Garbage transportation and disposal costs," the amount "80,000," and the debt item "Construction accounts payable." The fifth line has the provisional slip number "KAR0005," the date of occurrence "2022 / 6 / 30," the supplier "○○ Recycling," the expense item "Advance expenses," the amount "20,000," and the debt item "Construction accounts payable."

[0064] Create expense payment schedule data (unpaid vouchers, advance vouchers) based on the expense import format you created.

[0065] Figure 7(B) is a diagram showing an example of expense payment schedule data. Expense payment schedule data includes the following fields: expense number, date of occurrence, supplier, expense item, amount, debt item, and external receipt number. The "provisional voucher number" in the expense import format is stored as the "external receipt number."

[0066] In the example shown in the figure, the first line has the slip number "KEI0001," the date of occurrence "2022 / 6 / 10," the supplier "○○ Recycling," the expense item "Garbage transportation and disposal expenses," the amount "80,000," the debt item "Construction accounts payable," and the external receipt number "KAR0001." The fifth line has the expense number "KEI0005," the date of occurrence "2022 / 6 / 30," the supplier "○○ Recycling," the expense item "Advance expenses," the amount "20,000," the debt item "Construction accounts payable," and the external receipt number "KAR0001."

[0067] FIG. 7(C) is a diagram showing an example of linked data. The linked data includes fields for expense number, order number, and a flag that specifies whether or not to offset with the current month's output ("1" for offset, "0" for no offset). In the expense import format, by specifying the "order number" to be offset with the current month's output, the "expense number" linked to the "external receipt number" which is the "provisional voucher number" linked to the "order number" is obtained in the expense payment schedule data, and linking data is created for the obtained "expense number" and the specified "order number." The "flag" is set to "0" as its initial value.

[0068] Journal data is created based on the expense payment schedule data of Figure 7(B) and the item setting master 106a of Figure 6(A). Figure 8 is a diagram showing an example of the journal data created. The journal data has the following fields: journal entry number, accounting date, business partner, debit item, debit amount, credit item, credit amount, and summary. For "debit item," the cost item obtained from the item setting master 106a is set using the expense item of the expense payment schedule data as a key. In this example, for the expense item "advance expense item," the debit item "subcontract advance payment" is set. For "credit item," the debt item of the expense payment schedule data is set. For "summary," the expense number of the expense payment schedule data is set.

[0069] In the example shown in the figure, the first line has journal entry number "SIW0001," date of occurrence "6 / 10 / 2022," vendor "○○ Recycling," liability item "Uncompleted Construction Expenditures (Expenses)," debit amount "80,000," credit item "Construction Accounts Payable," credit amount "80,000," and summary number "KEI0001." The fifth line has journal entry number "SIW0005," date of occurrence "6 / 30 / 2022," vendor "○○ Formwork Industry," liability item "Subcontractor Advance Payments," debit amount "20,000," credit item "Construction Accounts Payable," credit amount "20,000," and summary number "KEI0005."

[0070] 3. Recognize the offset amount when recording the volume of work. (S3: Purchase input processing) The purchase input process will be specifically described with reference to Figures 9 to 13. The purchase input unit 102c, for example, in response to an operation by an operator or the like on the purchase input screen displayed on the monitor 114, creates purchase data based on the order data registered in the storage unit 106, including the purchase number, purchase date, order number, handling business, order date, cost item, order amount, purchase amount for the current month designated by the operator, and debt item; references the linking data registered in the storage unit 106, reads from the storage unit 106 the scheduled expense payment data for the expense number linked to the order number of the purchase data as a candidate for offset with the purchase amount for the current month of the purchase data; determines the scheduled payment data for the expense number designated by the operator as the offset target; creates advance payment data for the determined offset target, including the purchase number, purchase date, advance payment recipient, order number, advance payment item, and advance payment amount; creates scheduled payment data based on the purchase data and the advance payment data, including the scheduled payment number, scheduled payment date, payee, and scheduled payment amount; and registers the created data in the storage unit 106. In this case, one or more of the offset candidates may be designated as the target for offset with the purchase amount from the following month onwards (see Figure 13). The purchase input unit 102c may create journal data including the journal number, accounting date, business partner, debit item, debit amount, credit item, and credit amount based on the purchase data and the advance purchase data, and register the journal data in the storage unit 106.

[0071] Here, based on the production volume report for the current month, select the relevant purchase order number from the purchase entry screen and enter the purchase details. Here, we will explain how to enter a purchase of 6,000,000 yen in June 2022.

[0072] 9 is a diagram showing a display example of the purchase input screen 400. The purchase input screen 400 has a header area 401 for specifying the purchase date, purchase order number, order subject, subcontractor, and debt item, and a details area 402 for displaying purchase details or advance details according to the switching button.

[0073] In the details area 402, when purchase details are selected with the switch button, purchase information (items for row No., cost item, purchase amount, current month purchase amount, and remaining order amount) and the total purchase amount are displayed (see Figure 9). When advance details are selected with the switch button, the order amount, current month's output amount, advance information (row No., expense No., business partner, expense item, advance amount, and a field for specifying whether or not to offset), the total offset amount, and the expected payment amount (= total purchase amount - total offset amount) are displayed (see Figure 10(C)). On the purchase input screen 400, hatched cells cannot be entered by the operator (automatic input / display), and unhatched cells can be entered by the operator.

[0074] In the header area 401, the operator specifies the purchase date and purchase order number. Using the specified purchase order number as a key, the order subject, subcontractor, and debt item are read from the order data and automatically displayed. In the example shown in the figure, the purchase date "2023 / 6 / 30" and order number "HAC0001" are specified, and the order subject "Formwork work for XX building," subcontractor "XX Formwork Industry," and debt item "Construction accounts payable" are automatically displayed.

[0075] Furthermore, when purchase details are selected in the details area 402, the specified purchase order number is used as a key to read out the cost item and purchase amount from the purchase data and automatically display them in the purchase information. The operator inputs the "purchase amount for this month" in the purchase information. The remaining order amount is automatically calculated by subtracting the purchase amount for this month, and is automatically displayed.

[0076] In the example shown in the figure, the cost item "Uncompleted Work Expenditures (Subcontracted)" and order amount "10,000,000" are automatically displayed, and when the operator specifies the purchase amount for the current month "6,000,000", the remaining order amount "4,000,000 (=10,000,000 - 6,000,000)" is automatically displayed. In addition, the total purchase amount "6,000,000" is automatically displayed.

[0077] Also, as shown in FIG. 10(C), when an advance payment detail is selected in the detail area 402, the order amount and current month's purchase amount of the purchase detail are automatically displayed as the order amount and current month's output amount. For advance payment information, the expense number from the linked data in FIG. 10(A) is retrieved using the specified order number as a key, and offset candidates are read from the expense payment data shown in FIG. 10(B) using the retrieved expense number as a key, and the expense number, business partner, expense item, and advance payment amount of the advance payment information are automatically displayed. The operator specifies (checks) whether each expense number is subject to offset and sets the offset target. In the example shown in the figure, the details with expense numbers "PJ0005," "PJ0007," and "PJ0008" are designated as offset targets, while the detail for "XX Trading Co., Ltd. Miscellaneous Hardware" with expense number "PJ0006" is not designated as an offset target, so that it will not be offset against the current month's output. The total offset amount "1,000,000" and the expected payment amount "5,000,000 (= 6,000,000 - 1,000,000)" will be automatically displayed.

[0078] For expense numbers designated as offset targets, the flag of the linking data is updated to "1" as shown in Figure 11. Items with a flag of "0" can be set as offset targets when recording the amount of work done from the following month onwards.

[0079] When the user presses the register button (not shown), purchase data and advance payment purchase data are created in accordance with the input contents on the purchase input screen 400 and are registered in the storage unit 106. Furthermore, payment schedule data and journal data are created based on the purchase data and advance payment purchase data and are registered in the storage unit 106. In the case of the input contents shown in the examples of Figures 10 and 11, the data shown in Figure 12 is registered.

[0080] Figure 12(A) is a diagram showing an example of purchase data. The purchase data includes the following fields: purchase number, purchase date, supplier, order number, order date, cost item, order amount, purchase amount for the current month, and liability item. In the example shown in the figure, the fields are purchase number "SIR0001", purchase date "2022 / 6 / 30", supplier "XX Formwork Industry", order number "HAC0001", order date "2022 / 3 / 19", cost item "Uncompleted construction expenditure (subcontracted)", order amount "10,000,000", purchase amount for the current month "6,000,000", and liability item "Construction accounts payable".

[0081] Figure 12(B) is a diagram showing an example of advance purchase data. Advance purchase data has the following fields: purchase number, purchase date, advance recipient, order number, advance item, and advance amount. In the example shown in the figure, the first line has purchase number "TSI001," purchase date "2022 / 6 / 30," advance recipient "○○ Formwork Industry," order number "HAC0001," advance item "Subcontractor advance payment," and advance amount "20,000."

[0082] Figure 12(C) is a diagram showing an example of payment schedule data. The payment schedule data has fields for the scheduled payment number, scheduled payment date, payee company, and scheduled payment amount. In the example shown in the figure, the first line is the payment schedule generated from purchase data, and lines 2 to 4 are the payment schedule generated from advance purchase data. The first line has the scheduled payment number "SIH0001," the scheduled payment date "2022 / 8 / 31," the payee company "○○ Formwork Industry," and the scheduled payment amount "6,000,000," while the second line has the scheduled payment number "SIH0002," the scheduled payment date "2022 / 8 / 31," the payee company "○○ Formwork Industry," and the scheduled payment amount "-20,000."

[0083] Figure 12(D) is a diagram showing an example of journal entry data. Journal entry data has the following fields: journal entry number, accounting date, business partner, debit item, debit amount, credit item, and credit amount. In the example shown in the figure, the first line is a journal entry arising from purchase data, and lines 2 to 4 are journal entries arising from advance purchase data. In the example shown in the figure, the first line has journal entry number "SIW0009," occurrence date "6 / 30 / 2022," business partner "○○ Formwork Industry," debt item "Uncompleted construction expenditures (expenses)," debit amount "6,000,000," credit item "Construction accounts payable," and credit amount "6,000,000." The second line has the journal entry number "SIW0010", the date of occurrence "2022 / 6 / 30", the trading company "○○ Formwork Industry", the liability item "Unearned construction costs", the debit amount "20,000", the credit item "Subcontractor advance payment", and the credit amount "20,000".

[0084] (Supplementary Note 1) FIG. 13 is a diagram showing an example of an advance payment detail when the amount of work completed in July 2022 is recorded based on the purchase entry. Here, we will explain the case where the amount of work completed for July is 3,000,000. In FIG. 13, the detail area 402 of the purchase entry screen 400 displays the order amount "10,000" and the amount of work completed for the current month "3,000,000." The advance payment information displays the expense number "PJ0006," the business partner "XX Trading," the expense item "Miscellaneous Hardware," and the advance payment amount "100,000" as offset candidates. The operator specifies (checks) the offset target for expense number "PJ0006" to set it as the offset target. The total offset amount "100,000" and the expected payment amount "2,900,000 (= 3,000,000 - 1,000,000)" are automatically displayed.

[0085] (Supplementary Note 2) If a payment statement is used, it is also possible to utilize the purchase data, advance purchase data, and scheduled payment data processed in 2. The payment statement operation unit 102d creates and outputs (displays and / or prints) a payment statement based on the purchase data, advance purchase data, and scheduled payment data, for example, in response to an operator's operation on a payment statement operation screen (not shown) displayed on the monitor 114. Figure 14 is a diagram showing an example of a payment statement. The payment statement is sent to the subcontractor "XX Formwork Industry."

[0086] As described above, according to this embodiment, there is provided an order input unit 102a which, when placing an order for construction work with a subcontractor, creates order data including order number, subcontractor, order subject, cost item, order date, ordered construction period, order amount, and debt item, and registers this in the storage unit 106; an expense import unit 102b which creates expense payment schedule data for unpaid vouchers and advance vouchers for the construction work, including expense number, date of occurrence, business company, expense item, amount, and debt item, and registers this in the storage unit 106, and also creates linking data linking expense numbers with order numbers and registers this in the storage area; and an expense import unit 102c which creates purchase data including purchase number, purchase date, order number, handling company, order date, cost item, order amount, purchase amount for the current month designated by the operator, and debt item based on the order data registered in the storage unit 106, and stores this in the storage unit 106. and a purchase input unit 102c that refers to the linking data registered in unit 106, reads out from the memory area the scheduled expense payment data for the expense number linked to the purchase order number of the purchase data in question as a candidate for offset with the purchase amount for the current month of the purchase data, determines the scheduled payment data for the expense number specified by the operator as the object of offset, creates advance purchase data for the determined object of offset including the purchase number, purchase date, advance payment recipient, purchase order number, advance payment subject, and advance payment amount, and creates payment schedule data including the scheduled payment number, scheduled payment date, payee contractor, and scheduled payment amount based on the purchase data and the advance purchase data, thereby making it possible for an ordering party to offset the progress of the construction work with an outsourced contractor, easily and with little workload.

[0087] [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 the achievement of SDGs Goals 8 and 9.

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

[0089] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.

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

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

[0092] Furthermore, 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 can be changed as desired unless otherwise specified.

[0093] Furthermore, with regard to the offset processing device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0094] For example, all or any part of the processing functions of the offsetting processing device 100, particularly the processing functions performed by the control unit, may be realized 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 on a non-transitory 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 offsetting processing device 100 as needed. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.

[0095] This computer program may also be stored in an application program server connected to the offset processing device 100 via any network, and all or part of it may be downloaded as needed.

[0096] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "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.

[0097] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. 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, can use well-known configurations and procedures.

[0098] The various databases stored in the memory unit 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 used for various processes and providing websites.

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

[0100] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]

[0101] 100 Offsetting processing device 102 Control section 102a Order input section 102b Expense Capture Department 102c Purchase Input Section 102d Payment Record Management Department 102e Master Maintenance Department 102f Screen display control unit 104 Communication interface unit 106 Storage section 106a Subject Setting Master 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. An offsetting device equipped with a control unit, The control unit an order input means for creating order data including an order number, subcontractor, order subject, cost item, order date, order construction period, order amount, and debt item in response to an operator's operation on an order input screen when placing an order for construction work with a subcontractor, and registering the data in a storage area; an expense capturing means for creating and registering in the storage area, in response to an operator's operation on an expense capturing screen, expense payment schedule data including expense number, occurrence date, business partner, expense item, amount, and debt item for unpaid slips and advance payment slips for construction work, and for creating and registering in the storage area linking data linking expense number and purchase order number; In response to the operator's operation on the purchase input screen, purchase data including the purchase number, purchase date, purchase order number, supplier, order date, cost item, order amount, purchase amount for the current month designated by the operator, and debt item is created based on the purchase order data registered in the storage area, and by referring to the linking data registered in the storage area, the expense payment schedule data of the expense number linked to the purchase order number of the purchase data is read from the storage area as a candidate for offset with the purchase amount for the current month of the purchase data, and the expense payment schedule data of the expense number designated by the operator is set as the target for offset. a purchase input means for determining the offset target by using the above method, creating advance purchase data including a purchase number, purchase date, advance payment recipient, purchase order number, advance payment subject, and advance payment amount for the determined offset target, and creating payment schedule data including a payment schedule number, payment schedule date, payment recipient company, and advance payment amount based on the purchase data and the advance purchase data, respectively, whereby, when based on the purchase data, the "payment recipient company" is set to the trading company, and the "expected payment amount" is set to the purchase amount for the current month, and when based on the advance purchase data, the "payment recipient company" is set to the advance payment recipient, and the "expected payment amount" is set to the negative of the advance payment amount; An offsetting device comprising:

2. 2. The offset processing device according to claim 1, wherein said purchase input means is configured to allow one or more of said offset candidates to be designated as an offset target with a purchase amount in the following month or thereafter.

3. The control unit It is configured to be accessible to the item setting master that associates and registers the expense item with the cost item that will be the debit item of the journal entry, The offsetting processing device described in claim 1 or 2, characterized in that the expense import means, based on the expense payment schedule data, refers to the item setting master and creates journal data including the journal number, accounting date, business partner, debit item, debit amount, credit item, and credit amount, which are set by setting the cost item of the item setting master linked to the expense item of the expense payment schedule data.

4. The offsetting processing device described in claim 1 or 2, characterized in that the purchase input means creates journal entry data including journal entry number, accounting date, business partner, debit account, debit amount, credit account, and credit amount based on the purchase data and the advance purchase data, respectively, and in that, when based on the purchase data, the ``accounting date'' is set as the purchase date, the ``business partner'' is set as the trading company, the ``debit account'' is set as the cost account, the ``debit amount'' is set as the purchase amount for the current month, the ``credit account'' is set as the debt account, and the ``credit amount'' is set as the purchase amount for the current month, and when based on the advance purchase data, the ``accounting date'' is set as the purchase date, the ``business partner'' is set as the advance recipient, the ``debit account'' is set as the construction outstanding, the ``debit amount'' is set as the advance amount, the ``credit account'' is set as the advance account, and the ``credit amount'' is set as the advance amount.

5. An offset processing method executed by an information processing device having a control unit, Executed in the control unit: an order input process for creating and registering order data including an order number, subcontractor, order subject, cost item, order date, order construction period, order amount, and debt item in a storage area in response to an operator's operation on an order input screen when placing an order for construction work with a subcontractor; an expense import process for creating and registering in the storage area, in accordance with the operator's operations on the expense import screen, expense payment schedule data including expense number, occurrence date, business partner, expense item, amount, and debt item for construction unpaid vouchers and advance payment vouchers, and also creating and registering in the storage area linking data linking expense number and purchase order number; In response to the operator's operation on the purchase input screen, purchase data including the purchase number, purchase date, purchase order number, supplier, order date, cost item, order amount, purchase amount for the current month designated by the operator, and debt item is created based on the purchase order data registered in the storage area, and by referring to the linking data registered in the storage area, the expense payment schedule data of the expense number linked to the purchase order number of the purchase data is read from the storage area as a candidate for offset with the purchase amount for the current month of the purchase data, and the expense payment schedule data of the expense number designated by the operator is set as the target for offset. a purchase input process in which, for the determined offset target, advance purchase data including a purchase number, purchase date, advance payment recipient, purchase order number, advance payment subject, and advance payment amount are created, and payment schedule data including a payment schedule number, payment schedule date, payment recipient company, and advance payment amount are created based on the purchase data and the advance purchase data, respectively, and in this case, when based on the purchase data, the "payment recipient company" is set to the trading company, and the "expected payment amount" is set to the purchase amount for the current month, and when based on the advance purchase data, the "payment recipient company" is set to the advance payment recipient, and the "expected payment amount" is set to the negative of the advance payment amount; An offsetting method comprising:

6. An offset processing program to be executed by an information processing device having a control unit, The control unit an order input process for creating and registering order data including an order number, subcontractor, order subject, cost item, order date, order construction period, order amount, and debt item in a storage area in response to an operator's operation on an order input screen when placing an order for construction work with a subcontractor; an expense import process for creating and registering in the storage area, in accordance with the operator's operations on the expense import screen, expense payment schedule data including expense number, occurrence date, business partner, expense item, amount, and debt item for construction unpaid vouchers and advance payment vouchers, and also creating and registering in the storage area linking data linking expense number and purchase order number; In response to the operator's operation on the purchase input screen, purchase data including the purchase number, purchase date, purchase order number, supplier, order date, cost item, order amount, purchase amount for the current month designated by the operator, and debt item is created based on the purchase order data registered in the storage area, and by referring to the linking data registered in the storage area, the expense payment schedule data of the expense number linked to the purchase order number of the purchase data is read from the storage area as a candidate for offset with the purchase amount for the current month of the purchase data, and the expense payment schedule data of the expense number designated by the operator is set as the target for offset. a purchase input process in which, for the determined offset target, advance purchase data including a purchase number, purchase date, advance payment recipient, purchase order number, advance payment subject, and advance payment amount are created, and payment schedule data including a payment schedule number, payment schedule date, payment recipient company, and advance payment amount are created based on the purchase data and the advance purchase data, respectively, and in this case, when based on the purchase data, the "payment recipient company" is set to the trading company, and the "expected payment amount" is set to the purchase amount for the current month, and when based on the advance purchase data, the "payment recipient company" is set to the advance payment recipient, and the "expected payment amount" is set to the negative of the advance payment amount; An offsetting program to execute the above.

Images