JP2024044063A - Income and expenditure management device, income and expenditure management method, and income and expenditure management program - Google Patents

Abstract

[Problem] To provide an income and expenditure management device, income and expenditure management method, and income and expenditure management program that can compare and output the declared gross profit rate and the current final gross profit rate while a case is in progress, and grasp the current income and expenditure situation. [Solution] The income and expenditure management device according to this embodiment comprises a case basic information input means for inputting case basic information including the case, the customer, and the declared gross profit rate, a voucher input means for inputting voucher data linked to the case, and a case management table output means for outputting, for a target case, a case management table including the declared gross profit rate and the current final gross profit rate by referring to the case basic information and the voucher data while the case is in progress. [Selected Figure] Figure 1

Description

The present invention relates to an income/expense management device, an income/expense management method, and an income/expense management program.

For example, in the wholesale business of electrical equipment materials, etc., it is necessary to manage income and expenditure at each construction site, but there are many variables in the cost, such as specifications being changed midway due to site conditions, and the time span until sales increase is long. Due to the long period of time, it is difficult to estimate the current income and expenditure situation and the likely outcome. Conventionally, as a system for managing income and expenditure, there is, for example, Patent Document 1.

Japanese Patent Application Publication No. 2017-91279

However, Patent Document 1 does not describe anything about comparing the declared gross profit rate and the current final gross profit rate while the project is in progress to understand the current income and expenditure situation.

The present invention has been made in view of the above, and is an income and expenditure management system that can compare and output the declared gross profit rate and the current final gross profit rate while the project is in progress, and grasp the current income and expenditure situation. The purpose is to provide devices, income and expenditure management methods, and income and expenditure management programs.

In order to solve the above-mentioned problems and achieve the objectives, the present invention provides an income and expenditure management device that includes a control section, and the control section inputs basic project information including the project, customer, and declared gross profit rate. a slip input means for inputting slip data linked to the case; project management table output means for outputting a project management table including the interest rate and the current final gross profit rate;
It is characterized by having the following.

According to one aspect of the present invention, the invoice data may include order data, purchase data, purchase data, and sales data.

Furthermore, 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.

Further, according to one aspect of the present invention, the case management table may include a cost difference calculated by calculating the cumulative purchase amount minus the cumulative cost of sales.

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 a declared gross profit rate, a final gross profit rate, and a cost difference for a target case when the case is completed, by referring to the case basic information and the invoice data.

Moreover, in order to solve the above-mentioned problems and achieve the purpose, the present invention provides an income and expenditure management method executed by an information processing device equipped with a control unit, the method of managing matters and customers, which is executed in the control unit. , a case basic information input step of inputting basic case information including the declared gross profit rate; a slip input step of inputting slip data linked to the case; and a case management table output step of referencing the slip data and outputting a case management table including the declared gross profit rate and the current final gross profit rate.

Further, in order to solve the above-mentioned problems and achieve the purpose, the present invention provides an income and expenditure management program to be executed by an information processing device equipped with a control section, in which the control section can manage matters, customers, etc. A case basic information input step in which basic case information including the declared gross profit rate is input; a slip input step in which slip data associated with the case is input; and the case basic information and The present invention is characterized by an income and expenditure management program for executing a case management table output step of referring to the slip data and outputting a case management table including the declared gross profit rate and the final gross profit rate at the present time.

The present invention has the effect of making it possible to grasp the current income and expenditure situation by comparing and outputting the declared gross profit margin rate and the current final gross profit margin rate while a project is in progress.

FIG. 1 is a block diagram showing an example of the configuration of an income and expenditure management device according to the present embodiment. FIG. 2 is a diagram showing a flow for explaining an outline of the overall processing of the control unit of the income and expenditure management device according to the present embodiment. FIG. 3 is a diagram for explaining a specific example of the process of the control unit of the income and expenditure management device according to the present embodiment. FIG. 4 is a diagram for explaining a specific example of the process of the control unit of the income and expenditure management device according to the present embodiment. FIG. 5 is a diagram for explaining a specific example of processing of the control unit of the income and expenditure management device according to the present embodiment. FIG. 6 is a diagram for explaining a specific example of processing of the control unit of the income and expenditure management device according to the present embodiment. FIG. 7 is a diagram for explaining a specific example of the process of the control unit of the income and expenditure management device according to the present embodiment. FIG. 8 is a diagram for explaining a specific example of processing of the control unit of the income and expenditure management device according to the present embodiment. FIG. 9 is a diagram for explaining a specific example of processing of the control unit of the income and expenditure management device according to the present embodiment. FIG. 10 is a diagram for explaining a specific example of processing of the control unit of the income and expenditure management device according to the present embodiment.

An embodiment of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to this embodiment.

[1: Overview]
For example, in the construction industry, there are many cases in which custom-made products are ordered from manufacturers and used rather than using standard products. It is characterized by the fact that sales do not increase on a product sales basis, but sales are recorded for a single set, and that it takes a long time for sales to increase. In addition, there are many factors that fluctuate costs, such as cases where it is necessary to change the planned components to components with different specifications depending on the site situation, making it difficult to estimate the current income and expenditure situation and forecast the final result. There is.

Therefore, in the present embodiment, while the project is in progress, the declared gross profit rate and the current final gross profit rate are compared and output, making it possible to grasp the current income and expenditure situation.

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 forecast information such as backlogs and orders, rather than just calculations based on actual sales and purchases.

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 projected information such as backlog of orders and backlog of orders. It is also possible to link this to sales activities aimed at increasing profits so as to approach the declared gross profit margin as the project is finally completed.

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

[2. composition]
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 an income and expenditure management device.

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 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.

The income and expenditure management device 100 includes a control section 102, a communication interface section 104, a storage section 106, and an input/output interface section 108. Each unit included in the income and expenditure management device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicatively connects the income/expense 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/expense 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).

An input device 112 and an output device 114 are connected to the input/output interface unit 108 . As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. Note that in the following description, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs that work with the OS (Operating System) to give commands to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can 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.

Data file 106a is a file for storing various data and information such as basic case information, invoice data (order data, order data, purchase data, sales data, etc.), case management tables, case completion reports, etc.

Project basic information may include parent project number, project number, project name, customer, and declared gross profit rate.

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).

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).

Purchase data may include purchase number, purchase category, purchase date, supplier, project number, product code, product name, purchase quantity, purchase price, and purchase amount.

Sales data may include sales number, sales category, sales date, customer, case number, product code, product name, sales volume, sales price, order amount, cost price, cost amount, and gross profit amount.

The project management table may contain header data (project number, project name, declared gross profit rate, final gross profit rate), income and expenditure data (data category, date, document 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).

The project completion report may include header data (project number, project name, declared gross profit margin) and income/expense 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 margin, cost difference, final gross profit margin).

The control unit 102 is a CPU or the like that centrally controls the income and expenditure management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs specifying various processing procedures, required data, etc., and performs various information processing based on these stored programs. Execute. Functionally, the control unit 102 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. ing.

The project basic information input unit 102a inputs project basic information including the project, customer, declared gross profit rate, and inputs the data in accordance with the operation of an operator or the like on the project basic information input screen displayed on the monitor 114, for example. The data is stored in the file 106a.

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

The case management table output unit 102c references the case basic information and invoice 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 during the progress of the target case, 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.

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.

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

The screen display control unit 102e controls, for example, the display of various screens (a matter basic information input screen, a slip input screen, a matter management table and a matter completion report extraction condition screen) to be displayed on the monitor 114, and the reception of their input. .

[3. Concrete example]
A specific example of the processing of the income and expenditure management device 100 in this embodiment will be described with reference to FIGS. 1 to 10. FIG. 2 is a flowchart illustrating an overview of the overall processing of the control unit 102 of the income and expenditure management device 100 in this embodiment. With reference to FIG. 2, an overview of the overall processing of the control unit 102 of the income and expenditure management device 100 in this embodiment will be explained.

(3-1. Overall processing)
In FIG. 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 the case, the client, and the declared gross profit rate, for example, according to the operation of an operator or the like on the input screen displayed on the monitor 114. The basic information of the case is input and stored in the data file 106a.

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

The invoice input process S2 includes an order input process S2-1 for inputting order data, an order input process S2-2 for inputting order data, a purchase input process S2-2 for inputting purchase data, and a sales input process for inputting sales data.

The case management table output unit 102c executes the case management table output process (step S3). Specifically, in the case management table output process, the case management table output unit 102c references the case basic information and slip data in the data file 106a based on the extraction conditions specified by the operator on the case management table extraction conditions 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 it in the data file 106a.

The final gross profit rate may be calculated as final gross profit rate=(cumulative sales amount−cumulative purchase amount)/cumulative sales amount×100. Further, the project management table may include a cost difference calculated by calculating the cumulative purchase amount minus the cumulative cost of sales.

The matter completion report output unit 102d executes matter completion report output processing (step S4). Specifically, in the matter completion report output process, the matter completion report output unit 102d outputs, for example, the matter completion report extraction conditions screen displayed on the monitor 114 when the matter is completed. Based on the extraction conditions specified by the operator above, refer to the basic project information and slip data in the data file 106a to display and output a project completion report including declared gross profit rate, final gross profit rate, and cost difference. , and stored in the data file 106a.

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

(Project basic information input process: S1)
The case basic information input process will be explained with reference to FIG. The project basic information input unit 102a inputs project basic information including the project, customer, declared gross profit rate, and inputs the data in accordance with the operation of an operator or the like on the project basic information input screen displayed on the monitor 114, for example. The data is stored in the file 106a.

FIG. 3A is a diagram showing a display example of the case basic information input screen. The project basic information input screen has areas for entering the parent project number, project number (child project number), office, registration date, customer, person in charge, project name (construction name), declared gross profit rate, and construction period. ing. When a registration button (not shown) is pressed, case basic information corresponding to the data input on the case basic information input screen is registered in the data file 106a.

Figure 3 (B) is a diagram showing an example of basic project information data. Basic project information data has fields for parent project number, project number, project name, customer, and declared gross profit rate. "Project numbers" are managed by construction classification, such as electrical, piping, lighting, and wires, even within the same project. When making a contract, 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 index for each construction classification, and is set so that the contract amount does not fall below the estimated cost.

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%.

(Invoice input process: S2)
The slip input processes (received order input process S2-1, order placement input 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 input unit 102b inputs slip data (received order data, order placement data, purchase data, and sales data) linked to an item in response to operations by an operator or the like on the slip input screen displayed on the monitor 114, for example, 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.

The case of receiving and placing an order will be described with reference to Figure 4. Figure 4 (A) is a diagram showing an example of order data. The order data includes the following fields: 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).

FIG. 4(B) is a diagram showing an example of order data. The order data includes the order number, order classification, order date, supplier, case number, product code, product name, order quantity, order unit price, order amount, scheduled purchase date, and status (backorder, completed purchase). Equipped with items.

Referring to FIG. 5, a case will be described in which individual arrangements are made without being linked to orders. If you want to make individual arrangements without linking them to orders, register the order data from the order input. FIG. 5 is a diagram showing an example of order data when individual arrangements are made without being linked to orders.

The case of accounting for purchases will be explained with reference to FIG. Here, a case will be described in which purchase accounting is performed for the record (4) of the order data in FIG. 4(B). FIG. 6(A) is a diagram showing an example of purchase data. The purchase data includes the following items: purchase number, purchase classification, purchase date, supplier, case number, product code, product name, purchase quantity, purchase unit price, and purchase amount.

FIG. 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 the status of record (4) in the order data in Figure 6 (B) has been changed from "Backordered" to "Purchased". Change it to "Complete". Additionally, as shown in record (5) of FIG. 6(B), order data for "product C" is newly registered.

The case of recording sales will be described with reference to Fig. 7. Here, the case of recording sales for record (2) of the order data in Fig. 4(A) will be described. Fig. 7(A) is a diagram showing an example of sales data. The sales data includes the following items: 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.

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."

(Matter management table output processing: S3)
Details of the matter management table output processing will be explained with reference to FIGS. 8 and 9. The matter management table output unit 102c stores information in the data file 106a based on the extraction conditions specified by the operator on the matter management table extraction condition screen displayed on the monitor 114 while the matter is in progress. Referring to the case basic information and slip data, a case management table including the declared gross profit rate, current final gross profit rate, and cost difference is displayed and stored in the data file 106a.

The case management table is output by, for example, a sales person in charge or a sales manager. Periodically, the sales person in charge or the sales manager checks the discrepancy between the declared gross profit margin and 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, use this as an indicator to take steps to improve profits, such as revising the prices of future transactions until the project is completed.

Figure 8 is a diagram showing an example of the extraction conditions screen for the case management table. On the extraction conditions screen for the case management table shown in Figure 8, the following extraction conditions can be specified: target year and month, business establishment, customer, case number, completion category (completed, incomplete), output category (based on actual results, based on planned posting date), target from next month onwards, and output order (payables → receivables, receivables → payables, by date).

The "output classification" is used to specify the date on which orders are to be extracted. "Results based" is the date on which orders are received, and "accounting date based" is on the scheduled sales/purchasing date. . "Next month target category" specifies whether to include the next month and subsequent months when the output category is based on the scheduled accounting date. "Output order" is for specifying the output order of details. "Debts → Receivables" means orders/purchases (in date order) → Orders/Sales (in date order), "Receivables → Payables" , Orders/Sales (in date order) → Orders/Purchases (in date order), and "Date order" is in date order (receivables and payables are not grouped).

When the execute button (not shown) is pressed, the case basic information and invoice data are referenced based on the extraction conditions specified on the extraction condition screen, and a case management table is output.

Figure 9 is a diagram for explaining the output image of the case management table. Figure 8 is a diagram showing an example of the output image of the case management table when the case basic information and voucher data of Figures 3 to 7 are registered and 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.).

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, document 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 document data.

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 get closer to the declared gross profit margin.

The “cost of sales” in the income and expenditure data is calculated as: cost of sales = main amount of sales × (1 - declared gross profit rate / 100).

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 checked and is 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 the sales price and investigating the purchase prices of other suppliers in order to cover this amount in future transactions. In this example, the current final cost variance is "￥50", and improvement is required.

The income/expense 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.

If the "output category" of the income/expense data is "based on planned accounting date," orders will be output as the planned purchase date, and orders will be output as the planned sales date.

Monthly case 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.

(Case completion report output process: 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 difference, and stores it in the data file 106a.

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 what the final gross profit margin was compared to the declared gross profit margin, how much the cost price difference was, and if there is a large discrepancy, to analyze the causes. It is also used as material for reviewing prices based on past project completion reports when similar projects arise in the future.

FIG. 10A is a diagram illustrating a display example of an extraction condition screen for a case completion report. On the case completion report extraction condition screen shown in FIG. 10, extraction conditions such as completion date, office, case number, etc. are specified.

When the execute button (not shown) is pressed, the project basic information and invoice data are referenced based on the extraction conditions specified on the extraction condition screen, and a project completion report is output.

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

The project completion report contains header data (project number, project name, declared gross profit rate) and income/expense 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).

If there is a large discrepancy based on the "cost difference" and "final gross profit margin" at the time of completion, an analysis of the causes 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 "¥1,200" - cumulative purchase amount "¥1,120") / cumulative sales amount "1,200" x 100), which is below the declared gross profit margin of "10.00%." In addition, the cost difference is ¥40 (= cumulative purchase amount "¥1,120" - cumulative cost of sales "¥1,080"), which is over the cost.

As described above, this embodiment includes a case basic information input unit 102a for inputting case basic information including the case, the customer, and the declared gross profit rate, a voucher input unit 102b for inputting voucher 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 voucher 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.

[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 making it possible to contribute to goals 8 and 9 of the SDGs.

Furthermore, this embodiment can contribute to reducing waste loss and promoting paperless and electronic systems, making it possible to contribute to Goals 12, 13, and 15 of the SDGs.

In addition, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

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

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 a known method.

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

Furthermore, with regard to the income/expense management device 100, each component shown in the figure is a functional concept, and does not necessarily have to be physically configured as shown in the figure.

For example, all or any part of the processing functions provided in the income and expenditure management device 100, especially each processing function performed by the control unit, may be realized by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processing described in this embodiment, and the program is Machine read to 100. That is, a storage unit such as a ROM or an HDD (Hard Disk Drive) stores a computer program that cooperates with an OS to give instructions to a CPU and perform various processes. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

This computer program may also be stored in an application program server connected to the income/expense management device 100 via any network, and may be downloaded in whole or in part as needed.

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

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

The various databases stored in the memory unit are storage devices such as RAM, ROM, etc., 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.

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

Furthermore, the specific form of dispersion and integration of devices is not limited to what is shown in the diagram, and all or part of them can be functionally or physically divided into arbitrary units according to various additions or functional loads. It can be configured in a distributed/integrated manner. That is, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively.

REFERENCE SIGNS LIST 100 Income and expenditure management device 102 Control unit 102a Case basic information input unit 102b Voucher input unit 102c Case management table output unit 102d Case completion report output unit 102e Screen display control unit 104 Communication interface unit 106 Storage unit 106a Data file 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (7)

A revenue and expenditure management device including a control unit,
The control unit is
a project basic information input means for inputting project basic information including a project, a customer, and a declared gross profit rate;
A 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 during the progress of the case;
An income/expenditure management device comprising: The income and expenditure management device according to claim 1, characterized in that the invoice data includes order data, purchase data, purchase data, and sales data. The income and expenditure management device according to claim 2, wherein the final gross profit rate is calculated by final gross profit rate = (cumulative sales amount - cumulative purchase amount) / cumulative sales amount x 100. The income/expense management device according to claim 2, characterized in that the case management table includes a cost difference calculated by cumulative purchase amount minus cumulative cost of sales. The control unit further
The income/expenditure management device according to any one of claims 1 to 4, further comprising a case completion report output means for outputting a case completion report including a declared gross profit rate, a final gross profit rate, and a cost difference when a target case is completed, by referring to the case basic information and the invoice data. A method for managing income and expenditures 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, the customer, and the declared gross profit rate;
a slip input process for inputting slip data associated with the case;
a case management table output step of 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 during the progress of the case;
A method for managing income and expenditure, comprising: An income/expenditure management program to be executed by an information processing device having a control unit,
In the control unit,
a project basic information input step for inputting project basic information including the project, the customer, and the declared gross profit rate;
a slip input process for inputting slip data associated with the case;
a case management table output step of 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 during the progress of the case;
An income and expenditure management program to implement.

Images