Income and expenditure management device, income and expenditure management method, and income and expenditure management program

Abstract

To provide a balance management apparatus, a balance management method and a balance management program, capable of grasping the balance of payment at the present time by comparing and outputting a declared gross-margin rate and a final gross-margin rate at the present time in a progress of a project.SOLUTION: A balance management apparatus according to the present embodiment comprises: project basic-information input means that inputs project basic information including a project, a client and a declared gross-margin rate; slip input means that inputs slip data to be tied to the project, and project-management table output means that, as to a project under consideration, makes reference to the project basic information and the slip data in a progress of the project and outputs a project-management table including a declared gross-margin rate and a final gross-margin rate at the present time.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to an income and expenditure management device, an income and expenditure management method, and an income and expenditure management program. [Background technology]

[0002] For example, in the wholesale business of electrical construction materials, income and expenditure management is required for each construction site, but there are many variable factors in costs, such as changes in specifications midway depending on the situation at the site, and it takes a long time for sales to increase, making it difficult to estimate the current income and expenditure situation and forecast the outcome. [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 comparing the declared gross profit rate with the current final gross profit rate while the case is in progress to grasp the current income and expenditure situation.

[0005] The present invention has been made in consideration of the above, and aims to provide an income and expenditure management device, an income and expenditure management method, and an income and expenditure management program that are capable of comparing and outputting the declared gross profit rate and the current final gross profit rate while a project is in progress, thereby making it possible to grasp the current income and expenditure situation. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides an income and expenditure management device equipped with a control unit, the control unit comprising: a case basic information input means for inputting case basic information including a case, a customer, and a declared gross profit rate; a slip input means for inputting slip data linked to the case; and a case management table output means for outputting a case management table including a declared gross profit rate and a final gross profit rate at the current time for a target case by referring to the case basic information and the slip data while the case is in progress. The present invention is characterized by the following.

[0007] According to another aspect of the present invention, the slip data may include order data, order data, purchase data, and sales data.

[0008] According to one aspect of the present invention, the final gross profit margin may be calculated as follows: Final gross profit margin = (cumulative sales amount - cumulative purchase amount) / cumulative sales amount x 100.

[0009] According to another aspect of the present invention, the project management table may include a cost difference calculated by subtracting the accumulated cost of goods sold from the accumulated purchase amount.

[0010] In addition, according to one aspect of the present invention, the control unit may further include a case completion report output means for outputting a case completion report including the declared gross profit rate, the final gross profit rate, and the cost difference for a target case when the case is completed, by referring to the case basic information and the invoice data.

[0011] In addition, in order to solve the above-mentioned problems and achieve the objective, the present invention is a revenue and expenditure management method executed by an information processing device equipped with a control unit, characterized in that it includes a case basic information input process executed by the control unit for inputting basic case information including the case, customer, and declared gross profit rate, a voucher input process for inputting voucher data linked to the case, and a case management table output process for, for a target case, referring to the case basic information and the voucher data while the case is in progress, outputting a case management table including the declared gross profit rate and the current final gross profit rate.

[0012] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention is an income and expenditure management program to be executed by an information processing device equipped with a control unit, wherein the control unit executes the following: a case basic information input process for inputting basic case information including the case, the customer, and the declared gross profit rate; a voucher input process for inputting voucher data linked to the case; and a case management table output process for outputting a case management table including the declared gross profit rate and the current final gross profit rate for a target case by referring to the case basic information and the voucher data while the case is in progress. [Effects of the Invention]

[0013] According to the present invention, it is possible to compare and output the declared gross profit rate and the current final gross profit rate while a case is in progress, thereby making it possible to grasp the current income and expenditure situation. [Brief explanation of the drawings]

[0014] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of an income and expenditure management device according to this embodiment. [Figure 2] FIG. 2 is a flowchart for explaining an outline of the overall processing of the control unit of the income and expenditure management device according to this embodiment. [Figure 3] FIG. 3 is a diagram for explaining a specific example of the processing of the control unit of the income and expenditure management device according to the present embodiment. [Figure 4] FIG. 4 is a diagram for explaining a specific example of the processing of the control unit of the income and expenditure management device according to the present embodiment. [Figure 5] FIG. 5 is a diagram for explaining a specific example of the processing of the control unit of the income and expenditure management device according to the present embodiment. [Figure 6] FIG. 6 is a diagram for explaining a specific example of the processing of the control unit of the income and expenditure management device according to the present embodiment. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the processing of the control unit of the income and expenditure management device according to the present embodiment. [Figure 8]FIG. 8 is a diagram for explaining a specific example of the processing of the control unit of the income and expenditure management device according to the present embodiment. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the processing of the control unit of the income and expenditure management device according to the present embodiment. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the processing of the control unit of the income and expenditure management device according to the present 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, it is very common to order and use custom-made products from manufacturers rather than using standard products. Sales do not increase on a per-item basis, and sales are recorded as a set, or it takes a long time for sales to increase. Furthermore, there are many variable cost factors, such as cases where planned materials need to be changed to materials with different specifications depending on the situation on-site, making it difficult to predict the current income and expenditure situation and final outcome.

[0017] Therefore, in this embodiment, the reported gross profit rate and the current final gross profit rate are compared and output while the project is in progress, making it possible to grasp the current income and expenditure situation.

[0018] More specifically, in this embodiment, a declared gross profit margin is set in advance for each project, and the deviation from the declared gross profit margin is visualized. It also makes it possible to compare the deviation between the cost of sales, calculated by multiplying the sales amount by the declared gross profit margin, and the actual cost. It also makes it possible to perform simulations that include not only calculations based on actual sales and purchase performance, but also forecast information such as backlogs of orders and orders.

[0019] According to this embodiment, it is also possible to check the discrepancy between the declared gross profit margin and the final gross profit margin, including forecast information such as backlog of orders and backlog of orders, etc. Furthermore, it is possible to link this to sales activities aimed at increasing profits so that the gross profit margin approaches the declared gross profit margin as the project is finalized.

[0020] The income and expenditure management device of the present invention can be widely applied to industries such as large equipment manufacturing and construction work that involve installation work.

[0021] [2. Configuration] An example of the configuration of the income and expenditure management 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 income and expenditure management device.

[0022] The income and expenditure management device 100 is a commercially available desktop personal computer. Note that the income and expenditure management 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, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0023] The income and expenditure management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the income and expenditure management 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 income and expenditure management 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 income and expenditure management 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 an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes. The storage unit 106 may be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 also includes a data file 106a.

[0027] The data file 106a is a file for storing various data and information such as basic case information, slip data (order data, order data, purchase data, sales data, etc.), case management tables, case completion reports, etc.

[0028] The case basic information may include the parent case number, case number, case name, customer, and declared gross profit rate.

[0029] The order data may include order number, order category, order date, customer, case number, product code, product name, order quantity, order price, order amount, cost price, cost amount, gross profit, expected sales date, and status (backlog, sales completed).

[0030] The order data may include order number, order category, order date, supplier, case number, product code, product name, order quantity, order price, order amount, planned purchase date, and status (remaining orders, purchase completed).

[0031] The purchase data may include a purchase number, purchase category, purchase date, supplier, project number, product code, product name, purchase quantity, purchase price, and purchase amount.

[0032] The sales data may include sales number, sales category, sales date, customer, case number, product code, product name, sales quantity, sales price, order amount, cost price, cost amount, and gross profit amount.

[0033] The project management table may include header data (project number, project name, declared gross profit rate, final gross profit rate), income and expenditure data (data category, date, invoice number, product, quantity, unit price, purchase amount, cumulative purchase amount, sales amount, cumulative sales amount, cost of sales, cumulative cost of sales, cost variance), and monthly project balance data (project number, accounting year and month, previous month's cost variance, current month's sales, current month's cost of sales, gross profit, current month's purchases, current month's cost variance, project number, accounting year and month, previous month's cost variance, current month's sales).

[0034] The project completion report may include header data (project number, project name, declared gross profit rate) and income and expenditure data (sales date, sales number, product code, product name, sales amount, cost of sales, total sales (cumulative sales amount), total purchases (cumulative purchase amount), total cost of sales (cumulative cost of sales), final gross profit rate, cost difference, final gross profit rate).

[0035] The control unit 102 is a CPU or the like that performs overall control of the income and expenditure management 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. Functionally, the control unit 102 conceptually includes a case basic information input unit 102a, a slip input unit 102b, a case management table output unit 102c, a case completion report output unit 102d, and a screen display control unit 102e.

[0036] The case basic information input unit 102a inputs case basic information including the case, customer, and declared gross profit rate in response to, for example, an operator's operation on a case basic information input screen displayed on the monitor 114, and stores the input information in the data file 106a.

[0037] The slip input unit 102b inputs slip data linked to the case and stores it in the data file 106a in response to, for example, an operation by an operator or the like on a slip input screen displayed on the monitor 114. The slip data may include order data, order data, purchase data, and sales data.

[0038] The case management table output unit 102c, for a target case, references the case basic information and slip data in the data file 106a based on the extraction conditions specified by the operator on the extraction conditions screen of the case management table displayed on the monitor 114 while the case is in progress, and displays and outputs a case management table including the declared gross profit rate and the current final gross profit rate, and stores it in the data file 106a.

[0039] The final gross profit margin may be calculated as follows: Final gross profit margin = (cumulative sales amount - cumulative purchase amount) / cumulative sales amount x 100. The project management table may also include the cost variance calculated as cumulative purchase amount - cumulative cost of sales.

[0040] When a target project is completed, the project completion report output unit 102d references the project basic information and slip data in the data file 106a based on, for example, the extraction conditions specified by the operator on the project completion report extraction conditions screen displayed on the monitor 114, and displays and outputs a project completion report including the declared gross profit rate, final gross profit rate, and cost difference, and stores it in the data file 106a.

[0041] The screen display control unit 102e controls the display of various screens (item basic information input screen, slip input screen, and extraction condition screen for the item management table and item completion report) displayed on the monitor 114 and the reception of inputs therefor.

[0042] [3. Specific Examples] A specific example of the processing of the income and expenditure management apparatus 100 in this embodiment will be described with reference to Figures 1 to 10. Figure 2 is a diagram showing a flow for explaining an outline of the overall processing of the control unit 102 of the income and expenditure management apparatus 100 in this embodiment. With reference to Figure 2, an outline of the overall processing of the control unit 102 of the income and expenditure management apparatus 100 in this embodiment will be described.

[0043] (3-1. Overall processing) 2, first, the case basic information input unit 102a executes a case basic information input process (step S1). Specifically, in the case basic information input process, the case basic information input unit 102a inputs case basic information including the case, the customer, and the declared gross profit rate in response to an operation by an operator or the like on an input screen displayed on the monitor 114, and stores the information in the data file 106a.

[0044] The slip input unit 102b executes slip input processing (step S2). Specifically, in the slip input processing, the slip input unit 102b inputs slip data linked to the case in response to operations by an operator or the like on an input screen displayed on the monitor 114, for example, and stores the input data in the data file 106a.

[0045] The slip input process S2 includes an order entry process S2-1 for entering order data, an order entry process S2-2 for entering order data, a purchase entry process S2-2 for entering purchase data, and a sales entry process S2-3 for entering sales data.

[0046] The case management table output unit 102c executes a case management table output process (step S3). Specifically, in the case management table output process, the case management table output unit 102c, for a target case, references the case basic information and slip data in the data file 106a based on extraction conditions specified by an operator on the case management table extraction condition screen displayed on the monitor 114 while the case is in progress, and displays and outputs a case management table including the declared gross profit rate and the current final gross profit rate, and stores the table in the data file 106a.

[0047] The final gross profit margin may be calculated as follows: Final gross profit margin = (cumulative sales amount - cumulative purchase amount) / cumulative sales amount x 100. The project management table may also include the cost variance calculated as cumulative purchase amount - cumulative cost of sales.

[0048] The case completion report output unit 102d executes a case completion report output process (step S4). Specifically, in the case completion report output process, when a target case is completed, the case completion report output unit 102d references the case basic information and slip data in the data file 106a based on extraction conditions specified by the operator on the case completion report extraction condition screen displayed on the monitor 114, for example, and displays and outputs a case completion report including the declared gross profit rate, the final gross profit rate, and the cost variance, and stores it in the data file 106a.

[0049] (3-3. Sample data) 3 to 10 are diagrams showing sample data for explaining a specific example of the processing by the control unit 102 of the income and expenditure management apparatus 100 in this embodiment. A specific example of the processing by the control unit 102 of the income and expenditure management apparatus 100 in this embodiment will be explained with reference to FIGS. 3 to 10.

[0050] (Basic project information input process: S1) The case basic information input process will be described with reference to Fig. 3. The case basic information input unit 102a inputs case basic information including the case, customer, and declared gross profit rate in response to, for example, an operation by an operator or the like on a case basic information input screen displayed on the monitor 114, and stores the input information in the data file 106a.

[0051] 3(A) is a diagram showing an example of the display of the case basic information input screen. The case basic information input screen has areas for inputting the parent case number, case number (child case number), business establishment, registration date, customer, person in charge, case name (construction name), declared gross profit rate, and construction period. When the register button (not shown) is pressed, the case basic information corresponding to the data entered on the case basic information input screen is registered in the data file 106a.

[0052] Figure 3(B) is a diagram showing an example of project basic information data. Project basic information data has the following fields: parent project number, project number, project name, customer, and declared gross profit rate. "Project number" is managed by construction classification, such as electricity, piping, lighting, and electrical wiring, even within the same construction project. When making a contract for work, a cost estimate is made and the contract amount is calculated by adding a profit to the estimated cost. "Declared gross profit rate" is a gross profit rate that serves as an indicator for each construction classification, and is set so that the contract amount does not fall below the estimated cost.

[0053] In the example shown in the figure, the first line contains the parent case number "A0001", case number "A0001-1", case name "Midosuji Building Electrical Work", customer "TOK001:□△ Industry", and declared gross profit rate 10.00%.

[0054] (Invoice input process: S2) The slip input processes (received order input process S2-1, order entry process S2-2, purchase input process S2-3, and sales input process S2-4) will be described in detail with reference to Figures 4 to 7. The slip entry unit 102b inputs slip data (received order data, order entry data, purchase data, and sales data) linked to an item in response to operations by an operator or the like on the slip entry screen displayed on the monitor 114, and stores the data in the data file 106a. Various slips are registered linked to item numbers. One or more received orders, sales, orders, and purchases are linked to one item.

[0055] The case of receiving an order and placing an order will be explained with reference to Figure 4. Figure 4(A) is a diagram showing an example of order data. The order data has the following items: order number, order category, order date, customer, case number, product code, product name, order quantity, order price, order amount, cost price, cost amount, gross profit amount, expected sales date, and status (backlog, sales completed).

[0056] 4(B) is a diagram showing an example of order data. The order data includes the following fields: order number, order category, order date, supplier, case number, product code, product name, order quantity, order price, order amount, planned purchase date, and status (remaining orders, purchase completed).

[0057] With reference to Figure 5, we will explain how to make an individual order without linking it to an order. When making an individual order without linking it to an order, order data is registered by entering an order. Figure 5 is a diagram showing an example of order data when making an individual order without linking it to an order.

[0058] The case of accounting for purchases will be explained with reference to Figure 6. Here, the case of accounting for purchases for record (4) of the order data in Figure 4(B) will be explained. Figure 6(A) is a diagram showing an example of purchase data. The purchase data has the following fields: purchase number, purchase category, purchase date, supplier, case number, product code, product name, purchase quantity, purchase price, and purchase amount.

[0059] Figure 6(B) is a diagram showing an example of order data. As shown in Figure 6(A), the purchase of "Product B" has been completed, so for record (4) in the order data in Figure 6(B), the status is changed from "Backorder" to "Purchase Completed." In addition, new order data for "Product C" is registered, as shown in record (5) in Figure 6(B).

[0060] The case of recording sales will be explained with reference to Figure 7. Here, the case of recording sales for record (2) of the order data in Figure 4(A) will be explained. Figure 7(A) is a diagram showing an example of sales data. The sales data includes sales number, sales category, sales date, customer, case number, product code, product name, sales quantity, sales price, order amount, cost price, cost amount, and gross profit amount. It has the following items.

[0061] Figure 7(B) shows an example of order data. As shown in Figure 7(A), sales of "Product B" have been recorded, so for record (2) in the order data in Figure 7(B), the status is changed from "Backordered" to "Sold."

[0062] (Matter management table output processing: S3) The details of the case management table output process will be described with reference to Figures 8 and 9. During the progress of a case, the case management table output unit 102c references the case basic information and slip data stored in the data file 106a based on extraction conditions specified by the operator on the extraction conditions screen of the case management table displayed on the monitor 114, for example, and outputs and displays a case management table including the declared gross profit rate, the current final gross profit rate, and the cost variance, and stores it in the data file 106a.

[0063] The project management table is printed out by, for example, the sales representative or sales manager. The sales representative or sales manager periodically checks the discrepancy between the declared gross profit margin and the final profit margin, as well as the cost difference, based on the project management table. For example, if there is a possibility that the profit margin will fall below the target, the table can be used as an indicator to take steps to improve profits, such as reviewing the prices of future transactions that will occur until the project is completed.

[0064] Figure 8 is a diagram showing an example of the extraction conditions screen for the project management table. On the extraction conditions screen for the project management table shown in Figure 8, the extraction conditions can be specified as follows: target year and month, business establishment, customer, project number, completion category (completed, incomplete), output category (based on actual results, based on planned recording date), target from next month onwards, and output order (debt → credit, credit → debt, date order).

[0065] "Output category" is used to specify the date by which orders are extracted; "Actual results based" extracts by the order date, and "Scheduled accounting date based" extracts by the planned sales and purchase dates. "Next month target category" specifies whether to include the following month and beyond when the output category is based on the planned accounting date. "Output order" is used to specify the order in which details are output; "Payables → Receivables" is orders and purchases (in date order) → orders and sales (in date order), "Receivables → Payables" is orders and sales (in date order) → orders and purchases (in date order), and "Date order" is in date order (without grouping receivables and payables together).

[0066] When an execution button (not shown) is pressed, the case management table is output with reference to the case basic information and slip data based on the extraction conditions specified on the extraction condition screen.

[0067] Figure 9 is a diagram for explaining an output image of the case management table. Figure 8 is a diagram showing an example of an output image of the case management table when output using the extraction conditions of Figure 8 (case number "A0001-1", target year and month "2022 / 7", output category "performance-based", output order "debt → credit", etc.) when the case basic information and slip data of Figures 3 to 7 are registered.

[0068] The project management table contains header data (project number, project name, declared gross profit rate, final gross profit rate), income and expenditure data (data category, date, slip number, product, quantity, unit price, purchase amount, cumulative purchase amount, sales amount, cumulative sales amount, cost of sales, cumulative cost of sales, cost variance), and monthly project balance data (project number, accounting year and month, previous month's cost variance, current month's sales, current month's cost of sales, gross profit, current month's purchases, current month's cost variance, project number, accounting year and month, previous month's cost variance, current month's sales). In the figure, (1) to (7) correspond to the record numbers of the slip data.

[0069] The "final gross profit margin" in the header data is calculated as follows: Final gross profit margin = (cumulative sales amount - cumulative purchase amount) / cumulative sales amount x 100. In the example shown in the figure, it is (¥600 - ¥680) / ¥600 x 100 = -13.33%. The current "final gross profit margin" is -13.33%, which is below the declared gross profit margin of 10.00%, so efforts are needed to bring it closer to the declared gross profit margin.

[0070] The "cost of sales" in the income and expenditure data is calculated as follows: Cost of sales = Net sales amount x (1 - declared gross profit rate / 100).

[0071] The "cost variance" in the income and expenditure data is calculated as follows: Cost variance = Cumulative purchase amount - Cumulative cost of sales. If the current "cost variance" is found to be a positive amount, there is a high possibility that the final cost will exceed the declared gross profit margin, so improvements will be made by reviewing sales prices and investigating purchase prices from other suppliers in order to cover this amount in future transactions. In this example, the current final cost variance is "¥50," which requires improvement.

[0072] The income and expenditure data "Cumulative Purchase Amount," "Cumulative Sales Amount," and "Cumulative Cost of Sales" output the accumulated amounts from the amounts incurred in the previous month and earlier. Monthly project balance data is created during the monthly provisional closing process, and is added to the cumulative purchase amount, cumulative sales amount, and cumulative cost of sales held in the previous month's record.

[0073] If the "output category" of the income and expenditure data is "based on the planned accounting date," orders will output the planned purchase date, and orders will output the planned sales date.

[0074] Monthly project balance data is output by obtaining the cumulative amount for the previous month. In this example, since the accounting year and month of the current month is "2022 / 07", data for the accounting year and month "2022 / 06" is obtained.

[0075] (Issue completion report output processing: S4) The details of the case completion report output process will be described with reference to Fig. 10. When a case is completed, the case completion report output unit 102d references the case basic information and slip data stored in the data file 106a based on extraction conditions specified by the operator on the case completion report extraction condition screen displayed on the monitor 114, for example, and outputs and displays a case completion report including the declared gross profit rate, final gross profit rate, and cost variance, and stores it in the data file 106a.

[0076] For example, when a sales representative completes a project, they print out a project completion report and report it to their superior for approval. The project completion report is used to check the final gross profit margin against the declared gross profit margin, how much the cost difference was, and if there is a large discrepancy, to analyze the cause. It is also used as material for reviewing prices based on past project completion reports when similar projects arise in the future.

[0077] 10A is a diagram showing an example of the display of the extraction condition screen for the project completion report. On the extraction condition screen for the project completion report shown in FIG. 10, extraction conditions such as the completion date, business establishment, project number, etc. are specified.

[0078] When an execution button (not shown) is pressed, the case completion report is output based on the extraction conditions specified on the extraction condition screen, with reference to the case basic information and slip data.

[0079] Figure 10(B) is a diagram for explaining an output image of the case management table. Figure 10(B) is a diagram showing an example of an output image of a case completion report when output using the extraction conditions of Figure 10(A) (case number "A0001-1" etc.). Note that in this explanation, it is assumed that all slip data up to the completion of the case is registered in the data file 106a.

[0080] The project completion report contains header data (project number, project name, declared gross profit rate) and income and expenditure data (sales date, sales number, product code, product name, sales amount, cost of sales, total sales (cumulative sales amount), total purchases (cumulative purchase amount), total cost of sales (cumulative cost of sales), final gross profit rate, cost difference, final gross profit rate).

[0081] If there is a large discrepancy based on the "cost difference" and "final gross profit margin" at the time of completion, a factor analysis is performed. In the example shown in Figure 10(B), the "final gross profit margin" at the time of project completion is 6.67% (= cumulative sales amount "¥1200" - cumulative purchase amount "¥1120") / cumulative sales amount "1200" x 100), which is below the declared gross profit margin of "10.00%." ​​In addition, the cost difference is ¥40 (= cumulative purchase amount "¥1120" - cumulative cost of sales "¥1080"), which is over cost.

[0082] As described above, according to this embodiment, there are provided a case basic information input unit 102a for inputting basic case information including the case, the customer, and the declared gross profit rate, a slip input unit 102b for inputting slip data linked to the case, and a case management table output unit 102c for outputting a case management table including the declared gross profit rate and the current final gross profit rate for a target case by referring to the case basic information and the slip data while the case is in progress.Therefore, it is possible to compare and output the declared gross profit rate and the current final gross profit rate while the case is in progress, and grasp the current income and expenditure situation.

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

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

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

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

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

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

[0089] Furthermore, with regard to the income and expenditure management 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.

[0090] For example, all or any part of the processing functions of the income and expenditure management device 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented 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 income and expenditure management device 100 as needed. That is, a computer program for providing 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.

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

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

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

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

[0095] The income and expenditure management 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 connected to any peripheral device. The income and expenditure management device 100 may be realized by installing software (including programs, data, etc.) that causes the device to perform the processing described in this embodiment.

[0096] 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 according to 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]

[0097] 100 Income and expenditure management device 102 Control section 102a Project basic information input section 102b Slip input section 102c Item management table output part 102d Project completion report output section 102e Screen display control unit 104 Communication interface unit 106 Storage section 106a Data File 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. An income and expenditure management device including a control unit, The control unit a project basic information input means for inputting project basic information including the project, the customer, and the declared gross profit rate; slip input means for inputting slip data linked to the case; a case management table output means for outputting a case management table including a declared gross profit rate and a final gross profit rate at the current time for a target case by referring to the case basic information and the slip data while the case is in progress; Equipped with The income and expenditure management device is characterized in that the slip data includes order data including backlogged orders, order data including backlogged orders, purchase data, and sales data.

2. 2. The income and expenditure management device according to claim 1, wherein the final gross profit margin is calculated by the formula: Final Gross Profit Margin=(Cumulative Sales Amount-Cumulative Purchase Amount) / Cumulative Sales Amount×100.

3. 2. The income and expenditure management device according to claim 1, wherein the case management table includes a cost difference calculated by subtracting a cumulative purchase amount from a cumulative cost of sales.

4. The control unit further The income and expenditure management device according to any one of claims 1 to 3, characterized in that it is provided with a project completion report output means for outputting a project completion report including the declared gross profit rate, the final gross profit rate, and the cost difference for a target project when the project is completed, by referring to the project basic information and the invoice data.

5. An income and expenditure management method executed by an information processing device having a control unit, Executed in the control unit: a project basic information input step for inputting project basic information including the project, customer, and declared gross profit rate; a slip input step of inputting slip data linked to the case; a case management table output step for outputting a case management table including a declared gross profit rate and a final gross profit rate at the current time for a target case by referring to the case basic information and the slip data while the case is in progress; Including, The income and expenditure management method is characterized in that the slip data includes order data including backlogged orders, order data including backlogged orders, purchase data, and sales data.

6. An income and expenditure management program to be executed by an information processing device having a control unit, The control unit a project basic information input step for inputting project basic information including the project, customer, and declared gross profit rate; a slip input step of inputting slip data linked to the case; a case management table output step for outputting a case management table including a declared gross profit rate and a final gross profit rate at the current time for a target case by referring to the case basic information and the slip data while the case is in progress; It is an income and expenditure management program to carry out the following: The income and expenditure management program is characterized in that the slip data includes order data including backlogged orders, order data including backlogged orders, purchase data, and sales data.

Images