JP2020154490A - Amount tabulation device, amount tabulation method and amount tabulation program - Google Patents

Abstract

To provide an amount tabulation device or the like capable of grasping a balance of a contract-based and monthly fluctuation amount after reflecting revision when the contract is revised.SOLUTION: In this embodiment, (1) when there is additional contract revision of a new merchandise or the like, a red record having a date when the additional revision is performed and an amount obtained by adding - to a contract time amount, a black record having a date when the additional revision is performed and the contract time amount, and an additional record including the date when the additional revision is performed and an additional amount being an amount about a new merchandise or the like are generated, and stored in contract data in association with the existing contract number, and when there is contract revision of a change in the contract time amount, a red record having a date when change revision is performed and an amount obtained by adding - to the contract time amount, and a black record including the date when the change revision is performed and a changed amount are generated and stored in the contract data in association with the existing contract number, and (2) an amount belonging to a record in the contract data having a designated contract number and date is tabulated.SELECTED DRAWING: Figure 7

Description

The present invention relates to a monetary summarization device, a monetary summarization method, and a monetary summarization program.

In Patent Document 1, in response to a request made by an opener of an account opened in a financial institution via a mobile phone, information regarding a payment act performed through the account is created, and the created information is transmitted via the mobile phone. A payment information transmission system for transmitting information to an account holder is disclosed (see paragraph 0009 of Patent Document 1). In addition, a usage contract is concluded between the system administrator of the payment information transmission system and the account opener, and personal information (address, name, account number, monthly income, planned payment amount, etc.) related to payment is presented to the system administrator. However, if there is a change in these personal information after the contract, it is disclosed that the contractor (account opener) makes a correction to the system administrator each time there is a change (Patent Document 1). See paragraph 0029).

JP-A-2002-117229

In the field of managing changes in contracts in this way, when a contract is revised, it was not possible to capture the balance of variable amounts by contract and by month, reflecting the revision.

For example, when a contractor performs emergency construction A defined by contract number XX, a provisional quotation is issued, and when the construction is completed later, the formal billing amount is determined (that is,). The sales amount may be revised). For example, if you issue an estimate of a provisional sales amount of 1,000,000 yen in January and complete the construction in February and request a formal sales amount of 1,500,000 yen, if you pay attention only to the balance of sales in February, the contract number ○○ The sales amount for February will be 1,500,000 yen-1,000,000 yen = 500,000 yen. However, in the past, the calculation of the 500,000 yen was performed manually by the person in charge, which required a great deal of labor and labor.

The present invention has been made in view of the above problems, and when a contract is revised, an amount that makes it possible to capture the balance of variable amounts by contract and by month while reflecting the revision. An object of the present invention is to provide an aggregation device, an amount aggregation method, and an amount aggregation program.

In order to solve the above-mentioned problems and achieve the object, the monetary amount totaling device according to the present invention is a monetary amount totaling device including a control unit and a storage unit, and the storage unit is a contract for identifying a contract. The contract data including the contract data having the identification data, the year and month to which the contract date which is the date when the contract is concluded, and the contract amount which is the contract amount for the goods or services provided in the contract is stored is stored. When the contract is revised due to the addition of a new product or service, the control unit determines the year and month to which the date of the revision due to the addition belongs and the amount obtained by adding a minus to the contract amount. A red record having the above, a black record having the same amount as the contract amount and the year and month to which the date of the revision due to the addition belongs, and the year and month to which the date of the revision by the addition belongs and the new An additional record including an additional amount of money related to various goods or services was generated and stored in the contract data in association with the contract identification data, and the contract was revised by changing the contract amount. In the case, a red record having a date to which the revision was made due to the change and an amount obtained by adding a minus to the contract amount, and a year and month to which the revision date due to the change belongs and after the change A black record including the amount of money, a record generating means for generating and storing in the contract data in association with the contract identification data, and the record in the contract data having the specified contract identification data and the year and month. It is characterized in that it is provided with a totaling means for totaling the amount of money possessed by the company.

In order to solve the above-mentioned problems and achieve the object, in the amount totaling device according to the present invention, the control unit aggregates the designated contract identification data, the designated date, and the totaling means. Generates a variable breakdown statement, which is a document for confirming the breakdown of the amount of change in the specified date for the contract defined in the specified contract identification data, including the amount calculated in It is characterized by further providing a means for generating a variable breakdown.

In order to solve the above-mentioned problems and achieve the object, the amount counting device according to the present invention is characterized in that the amount is at least one of a sales amount and a purchase amount.

Further, the amount aggregation method according to the present invention is an amount aggregation method executed by an information processing apparatus including a control unit and a storage unit, and the storage unit contains contract identification data for identifying a contract and the contract. The contract data including the contract data having the contract date to which the contract date is concluded and the contract price which is the contract price for the goods or services provided in the contract is stored, and the control If there is a revision of the contract due to the addition of a new product or service executed by the department, it has the year and month to which the date of the revision due to the addition belongs and the amount of the contract amount minus the amount at the time of the contract. The red record, the black record having the date to which the revision was made due to the addition and the same amount as the contract amount, the year and month to which the revision date due to the addition belongs, and the new product Alternatively, if an additional record including an additional amount of money related to services is generated and stored in the contract data in association with the contract identification data, and the contract is revised due to a change in the contract amount. A red record having a date to which the revision was made due to the change and an amount obtained by adding a minus to the contract amount, and a year and month to which the revision date due to the change belongs and the amount after the change. A black record including the above, a record generation step of generating and storing in the contract data in association with the contract identification data, and the record in the contract data having the specified contract identification data and year / month have. It is characterized by including a totaling step of totaling the amount of money.

Further, the amount aggregation program according to the present invention is an amount aggregation program to be executed by an information processing apparatus including a control unit and a storage unit, and the storage unit contains contract identification data for identifying a contract and the above-mentioned. The contract data including the contract data having the year and month to which the contract date, which is the date when the contract is concluded, and the contract amount, which is the contract amount related to the goods or services provided in the contract, is stored. If there is a revision of the contract due to the addition of a new product or service for the control unit to execute, the date to which the revision was made due to the addition belongs and the amount at the time of the contract minus the amount. A red record having the above, a black record having the same amount as the contract amount and the year and month to which the date of the revision due to the addition belongs, and the year and month to which the date of the revision by the addition belongs and the new An additional record including an additional amount of money related to various goods or services was generated and stored in the contract data in association with the contract identification data, and the contract was revised by changing the contract amount. In the case, a red record having a date to which the revision was made due to the change and an amount obtained by adding a minus to the contract amount, and a year and month to which the revision date due to the change belongs and after the change. A record generation step that generates a black record including the amount of money and stores it in the contract data in association with the contract identification data, and the record in the contract data having the specified contract identification data and the year and month. It is characterized by including a totaling step of totaling the amount of money that the company has.

According to the present invention, when a contract is revised, it is possible to capture the balance of the variable amount for each contract and each month while reflecting the revision.

FIG. 1 is a block diagram showing an example of the configuration of the amount totaling device. FIG. 2 is a diagram showing an example of the correspondence between the slip date and the accounting date. FIG. 3 is a diagram showing an example of contract input and generation of a sales report in December. FIG. 4 is a diagram showing an example of purchase input and sales input in December. FIG. 5 is a diagram showing an example of generating a trading performance report in December. FIG. 6 is a diagram showing an example of contract input in January. FIG. 7 is a diagram showing an example of generation of a trading report and a fluctuation breakdown report in January. FIG. 8 is a diagram showing an example of purchase input and sales input in January. FIG. 9 is a diagram showing an example of generating a trading performance report in January. FIG. 10 is a diagram showing an example of sales input and contract input in February. FIG. 11 is a diagram showing an example of generation of a sales report and a fluctuation breakdown in February. FIG. 12 is a diagram showing an example of sales input and billing input in February. FIG. 13 is a diagram showing an example of monthly results for each project.

Hereinafter, the amount totaling device, the amount amount totaling method, and the embodiment of the amount amount totaling program according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment. Hereinafter, a specific configuration and operation will be described.

[1. Constitution]
An example of the configuration of the amount totaling device 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the amount totaling device 100.

The amount counting device 100 is a commercially available desktop personal computer. The amount counting device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable type such as a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer. It may be an information processing device.

The amount counting device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the amount counting device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the amount counting device 100 to the network 300 so as to be communicable 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 another device via a communication line. Here, the network 300 has a function of connecting the amount counting device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Data of various masters and the like, which will be described later, may be stored in the server 200, for example.

An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). In addition to the keyboard, mouse, and microphone, the input device 112 can use a monitor that cooperates with the mouse to realize the pointing device function. In the following, 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.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving a command to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

The storage unit 106 includes, for example, contract data 106a, purchase data 106b, and sales data 106c.

The contract data 106a is data that holds information regarding a contract with a customer. As shown in FIG. 3, the contract data 106a includes, for example, the case identification data (case number) for identifying the case and the contract identification data (contract number and contract name) for identifying the contract in the same case. ), The contract date which is the date when the contract was concluded, the base date, the customer identification data (customer) for identifying the customer, and the supplier identification data (customer identification data) for identifying the supplier. Supplier), contract status, accounting date, processing category, product identification data (product) for identifying products or services provided within the contract, and products or products provided within the contract. Includes the amount of services (sales amount and purchase amount), etc. Although the contract data 106a is not shown in FIG. 3, the contract data 106a may further include a sales amount that is an amount of the sales amount that has been sold.

The reference date is, for example, the contract date or the revision date which is the date when the contract is revised. As the reference date, the contract date is set at the time of contract, but when the contract is revised later, the revised date is newly set in place of the contract date.

The fiscal year and month is, for example, the year and month to which the contract date or the revision date belongs.

Examples of the processing category include "10: new", "20: modified red (before modification)", and "21: modified black (after modification)". "10: New" is a processing category included in a new record (a record at the time of contract entered at the time of contract, or an additional record input when the contract is revised by adding a new product or service). "20: Corrected red (before correction)" is a processing category of the red record for canceling the amount of money held by the existing record. "21: Corrected black (after correction)" is a processing category of the black record for correcting to the correct amount.

The purchase data 106b is data that holds information regarding purchases. As shown in FIG. 4, the purchase data 106b includes, for example, the matter identification data (case number), the contract identification data (contract number), and purchase identification data (purchase number) for identifying the purchase. ), The purchase date, the supplier identification data (supplier), the year and month (accounting year and month) to which the purchase date belongs, the processing category, and the product identification data (product). , The purchase amount, and the like.

The sales data 106c is data that holds information about sales. As shown in FIG. 4, the sales data 106c includes, for example, the case identification data (case number), the contract identification data (contract number), sales identification data (sales number) for identifying sales, and sales. The date, the customer identification data (customer), the year / month (accounting year / month) to which the sales date belongs, the processing category, the product identification data (product), the sales amount, etc. Including.

The control unit 102 is a CPU or the like that collectively controls the amount totaling device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute.

The control unit 102 functionally conceptually, for example, (1) when the contract is revised due to the addition of a new product or service, the year and month to which the date of the revision due to the addition belongs and the contract amount. A red record with an amount with a minus added to, a black record with the year and month to which the date of the revision due to the addition belongs and the same amount as the contract amount, and the date of the revision due to the addition. An additional record including the year and month to which the new product or service belongs and an additional amount of money related to the new product or service is generated, linked with the contract identification data and stored in the contract data, and the amount at the time of the contract is changed. When the contract is revised, the red record having the year and month to which the date of the revision due to the change belongs and the amount obtained by adding a minus to the contract amount and the date of the revision due to the change are (2) Designated as a record generation unit 102a as a record generation means for generating a black record including the year and month to which it belongs and the changed amount of money and storing it in the contract data in association with the contract identification data. The totaling unit 102b as a totaling means for totaling the amount of money held by the record in the contract data having the contract identification data and the date, and (3) the sales report as a sales report generating means for generating the sales report. The document generation unit 102c, (4) the sales performance report generation unit 102d as the sales performance report generation means for generating the sales performance report, (5) the designated contract identification data, and the designated year. Documents for confirming the breakdown of changes in the amount of money in the specified year and month for the contract defined in the specified contract identification data, including the month and the amount calculated by the aggregation means. It is provided with a fluctuation breakdown generation unit 102e as a fluctuation breakdown generation generation means for generating the fluctuation breakdown statement.

The processing performed by each part will be described below, but as a premise, the contract data 106a includes the contract number and the date to which the contract is concluded, and the amount at the time of the contract regarding the goods or services provided in the contract. Includes a contractual record with a contractual amount that is.

When the contract is revised (revised) by adding a new product or service, the record generation unit 102a adds a minus to the year and month to which the date of the revision due to the addition belongs and the amount at the time of the contract. A red record having the above, a black record having the same amount as the contract amount and the year and month to which the date of the revision due to the addition belongs, and the year and month to which the date of the revision by the addition belongs and the new When an additional record including an additional amount of money related to a product or service is generated and stored in the contract data 106a in association with the contract number, and the contract is revised due to a change in the contract amount. , A red record having a date to which the revision was made due to the change and an amount obtained by adding a minus to the contract amount, and a year and month to which the date of the revision due to the change belongs and after the change. A black record including the amount of money is generated, associated with the contract number, and stored in the contract data 106a.

The aggregation unit 102b aggregates the amount of money held by the record in the contract data 106a having the designated contract number and year and month.

The trading report generation unit 102c generates a trading report (a report showing the schedule of the trading amount).

The trading performance report generation unit 102d generates a trading performance report (a report showing the actual trading amount).

The variable breakdown generation unit 102e includes the specified contract number, the specified year and month, and the amount calculated by totaling with the totaling unit 102b (defined by the specified contract number). (Documents for confirming the breakdown of changes in the amount of money for the specified date) for the contract to be made.

[2. Specific example of processing]
In this item, a specific example of the process according to the present embodiment will be described.

In this item, the explanation will proceed assuming the following situations. First, in December, we will receive a new order for a "valve" under a certain contract. Next, in January, an additional order for "joint" will be received within the certain contract (revision of the certain contract), and a new order for emergency work for "assembly" will be received at a provisional estimated amount in another contract. Then, in February, the emergency work of "assembly" is completed, and the estimated amount is changed to the official billing amount (revision of the other contract). Hereinafter, the processing performed every month will be described in detail by setting items.

As a premise of the processing in this item, it is assumed that the accounting date for the slip date is as shown in FIG. Further, in this item, for convenience of explanation, for example, in the contract data 106a of FIG. 3, a record having the alphabet A on the right side is simply referred to as “record A”.

[2.1.1 Monthly processing for December]
(1) Contract input First, in December, a new order for the product "valve" was received under a contract with the customer "TOK001: □ △ industry", and the contract data 106a shown in Fig. 3 is displayed on the contract input screen (not shown). From, the slip is registered in the "new mode".

(2) Generation of Trading Report Next, the trading report generation unit 102c generates a trading report (a report showing the schedule of the trading amount) as follows.

On the document issuance screen, as shown in (A) of FIG. 3, in order to confirm the planned balance for each contract, "sales report" is selected as the output condition, and the case number "ANKEN1" and the contract number "KEY0001" are selected. Is specified, and when "current" is specified as the output standard, the sales report generation unit 102c has the specified matter number "ANKEN1" and contract number "KEY0001" from the contract data 106a of FIG. However, a record (record A) having a fiscal year up to the present (that is, December) is acquired. Then, as shown in FIG. 3B, the sales report generation unit 102c has the designated contract number “KEY0001”, the sales amount “2,000,000 yen” and the purchase amount “2,000,000 yen” of the acquired record A. Generate a sales report that includes "750,000 yen" and the gross profit amount "1,250,000 yen" calculated by subtracting the purchase amount from the sales amount as the planned balance for the contract of "KEY0001".

On the other hand, on the document issuance screen, as shown in (C) of FIG. 3, in order to confirm the planned balance for each project, "sales report" is selected as the output condition, and the project number "ANKEN1" is selected. Is specified and "current" is specified as the output standard, the sales report generation unit 102c has the specified matter number "ANKEN1" from the contract data 106a of FIG. 3, and is currently (that is, Acquire a record (Record A) having a fiscal year up to (December). Then, as shown in FIG. 3D, the sales report generation unit 102c is used.
● The total amount of the specified matter number "ANKEN1", the sales amount of the acquired record (record A only) "2,000,000 yen", and the total purchase amount of the acquired record (record A only) "750,000""Yen" and the gross profit amount "1,250,000 yen" calculated by subtracting the purchase amount from the sales amount are included as the planned balance of the entire "ANKEN1" project, and
● Calculated by subtracting the purchase amount from the sales amount, the contract number "KEY0001" of the acquired record A, the sales amount "2,000,000 yen" and the purchase amount "750,000 yen" of the acquired record A. Generate a sales report that includes the gross profit amount "1,250,000 yen" and the planned balance for the contract of "KEY0001".

Regardless of whether you are issuing a sales report, a sales performance report, or a fluctuation breakdown, you can check the latest status of the project or contract by selecting "Current" as the output standard on the document issuance screen. On the other hand, if you select "Fiscal year" as the output standard and enter a specific fiscal year, you can check the status of the matter or contract in the entered fiscal year. ..

(3) Purchase input Next, assuming that the purchase is made according to the contents of the contract data 106a registered in (1), the purchase data 106b shown in FIG. 4 is registered from the purchase input screen (not shown). Will be done.

(4) Sales input Next, assuming that sales are performed according to the contents of the contract data 106a registered in (1), the sales data 106c shown in FIG. 4 is registered from the sales input screen (not shown). Here, at the time of sales registration, the sales amount "2,000,000 yen" in the sales data 106c of FIG. 4 is updated to the record A in the contract data 106a having the same contract number "KEY0001" as the sales amount "2,000,000 yen". Will be done.

(5) Generation of Trading Performance Report Finally, the trading performance report generation unit 102d generates a trading performance report (a report showing the actual trading amount) as follows.

On the document issuance screen, as shown in (A) of FIG. 5, in order to confirm the actual balance for each contract, "sales record report" is selected as the output condition, and the case number "ANKEN1" and the contract number "ANKEN1" are selected. When "KEY0001" is specified and "current" is specified as the output standard, the sales performance report generation unit 102d receives the specified item number "ANKEN1" from the contract data 106a in FIG. And the contract number "KEY0001", and the record (record A) having the accounting date up to the present (that is, December) is acquired. Then, as shown in FIG. 5B, the sales performance report generation unit 102d has the designated contract number “KEY0001”, the sales amount “2,000,000 yen” possessed by the acquired record A, and the purchase. Generate a trading performance report that includes the amount of money "750,000 yen" and the gross profit amount "1,250,000 yen" calculated by subtracting the purchase amount from the sales amount as the performance balance for the contract of "KEY0001".

On the other hand, on the document issuance screen, as shown in (C) of FIG. 5, in order to confirm the actual balance for each item, "sales record report" is selected as the output condition, and the item number "ANKEN1" is selected. Is specified, and when "current" is specified as the output standard, the sales performance report generation unit 102d uses the contract data 106a of FIG. 4 in which the sales amount has been updated to indicate the specified item number "ANKEN1". And obtains a record (record A) having a fiscal year up to the present (that is, December). Then, as shown in FIG. 5 (D), the trading performance report generation unit 102d is used.
● The total amount of the specified matter number "ANKEN1", the sales amount of the acquired record (record A only) "2,000,000 yen", and the purchase amount of the acquired record (record A only) ""750,000yen" and the gross profit amount "1,250,000 yen" calculated by subtracting the purchase amount from the sales amount are included as the actual balance of the entire project of "ANKEN1", and
● The contract number "KEY0001" of the acquired record A, the sold amount "2,000,000 yen" and the purchase amount "750,000 yen" of the acquired record A, and the purchased amount minus the purchased amount. Includes the gross profit amount "1,250,000 yen" calculated in the above as the actual balance for the contract of "KEY0001".
Generate a trading performance report.

As described above, the monthly processing for December was completed by the processing from (1) to (5).

[2-2. Monthly processing for 1 month]
(1) Contract input (1-1) Additional order for product "joint" within the same contract Next, in January, an additional order for product "joint" within the contract with contract number "KEY0001" was received, as shown in FIG. The contract data 106a is registered as a slip in the "correction mode" from the contract input screen (not shown). The additional order is a revise (revision) of the contract with the contract number "KEY0001". Hereinafter, in this item (1-1), the revision (revise) process performed by the record generation unit 102a will be described.

As shown in record B of FIG. 6, the record generation unit 102a has the accounting date (2019/1) to which the date (2019/1/10) of the revision due to the addition belongs and the processing category “20: correction”. "Red", the product "SYO001: Valve" ordered at the time of contract, the sales amount of 2,000,000 yen minus the sales amount of the product ordered at the time of contract "-2,000,000 yen", and the purchase amount of the product ordered at the time of contract Generate a red record that includes the amount "-750,000 yen", which is 750,000 yen minus the amount.

As shown in the record C of FIG. 6, the record generation unit 102a has the accounting date (2019/1) to which the date (2019/1/10) of the revision due to the addition belongs and the processing category “21: correction”. "Black", the product "SYO001: Valve" ordered at the time of contract, the same amount of sales "2,000,000 yen" as the sales amount of 2,000,000 yen for the product ordered at the time of contract, and the same purchase amount of 750,000 yen for the product ordered at the time of contract Generate a black record containing the amount "750,000 yen".

As shown in record D of FIG. 6, the record generation unit 102a includes the fiscal year and month (2019/1) to which the date (2019/1/10) of the revision due to the addition belongs and the processing category “10: new”. , And an additional record including the product "SYO002: Joint" that was additionally ordered, the sales amount "500,000 yen" for the product that was additionally ordered, and the purchase amount "200,000 yen" for the product that was additionally ordered. ..

Then, the record generation unit 102a stores the generated records B to D in the contract data 106a of FIG. 6 in association with the contract number “KEY0001”. When the contract is revised, the reference date in the contract data 106a of FIG. 6 is changed to the revision date (2019/1/10).

(1-2) New order for product "assembly" under a separate contract On the other hand, in January, a new order for product "assembly" was received under another contract number "KEY0002", and the contract data 106a shown in FIG. 6 is From the contract input screen (not shown), the slip is registered in the "new mode". Since the new order is an urgent construction project, the sales amount of 1,000,000 yen for the product "assembly" is assumed to be a provisional estimated amount.

(2) Generation of sales report Next, the sales report generation unit 102c generates a sales report as follows.

On the document issuance screen, as shown in (A) of FIG. 7, "sales report" is selected as an output condition in order to confirm the planned balance for each contract, and the case number "ANKEN1" and the contract number "KEY0001" are selected. And the contract number "KEY0002" are specified, and "current" is specified as the output standard. The sales report generation unit 102c has the designated matter number “ANKEN1” and the contract number “KEY0001” from the contract data 106a of FIG. 6, and has the fiscal year and month up to the present (that is, January). Acquire records (records A to D). Then, as shown in FIG. 7B, the designated contract number "KEY0001", the total amount of sales amount of the acquired records A to D "2,500,000 yen", and the acquired records A to Trading that includes the total purchase amount "950,000 yen" that D has and the gross profit amount "1,550,000 yen" calculated by subtracting the purchase amount from the sales amount as the planned balance for the contract of "KEY0001". Generate a report. Further, the sales report generation unit 102c has the designated case number “ANKEN1” and contract number “KEY0002” from the contract data 106a in FIG. 6, and has the accounting date up to the present (that is, January). Acquires the record (record E) having. Then, as shown in FIG. 7 (C), the designated contract number "KEY0002", the sales amount "1,000,000 yen" held by the acquired record E, and the purchase amount "1,000,000 yen" held by the acquired record E " Generate a sales report that includes "550,000 yen" and the gross profit amount "450,000 yen" calculated by subtracting the purchase amount from the sales amount as the planned balance for the contract of "KEY0002".

On the other hand, on the document issuance screen, as shown in (F) of FIG. 7, "buying and selling report" is selected as the output condition and the case number "ANKEN1" is selected in order to confirm the planned balance for each case. Is specified and "current" is specified as the output standard, the sales report generation unit 102c has the specified matter number "ANKEN1" from the contract data 106a of FIG. 6, and is currently (that is, Acquire records (records A to E) having fiscal years up to (January). Then, as shown in FIG. 7 (G), the sales report generation unit 102c is used.
● The total amount of the specified item number "ANKEN1", the total sales amount of the acquired records (records A to E) "3,500,000 yen", and the purchase amount of the acquired records (records A to E). Includes "1,500,000 yen" and the gross profit amount "2,000,000 yen" calculated by subtracting the purchase amount from the sales amount as the planned balance of the entire project of "ANKEN1".
● The contract number "KEY0001" possessed by the acquired records A to D, the total sales amount "2,500,000 yen" possessed by the acquired records A to D, and the total purchase amount "950,000 yen", and the sales. The gross profit amount "1,550,000 yen" calculated by subtracting the purchase amount from the amount is included as the planned balance for the contract of "KEY0001", and
● Calculated by subtracting the purchase amount from the contract number "KEY0002" of the acquired record E, the sales amount "1,000,000 yen" and the purchase amount "550,000 yen" of the acquired record E, and the purchase amount. The gross profit amount "450,000 yen" and the planned balance for the contract of "KEY0002" are included.
Generate a sales report.

(3) Generation of fluctuation breakdown report Next, the aggregation unit 102b requests the fluctuation breakdown report (a document for confirming the breakdown of the fluctuation of the amount of money in the specified year and month for the contract defined by the specified contract identification data. ), The amount of money in the contract data 106a is totaled.

Specifically, on the document issuance screen, as shown in FIG. 7D, "variation breakdown" is selected as the output condition, the matter number "ANKEN1" is specified, the contract number "KEY0001" and the contract number. Suppose that "KEY0002" is specified, "fiscal year / month" is specified as the output standard, and "2019/1" is specified as the accounting date. With reference to the contract data 106a of FIG. 6, the records having the designated matter number “ANKEN1”, contract number “KEY0001” and fiscal year / month “2019/1” are records B to D. Therefore, as shown by the dotted line in FIG. 7, the totaling unit 102b totals the sales amount of the records B to D to calculate the total sales amount of 500,000 yen, and the total sales amount of 500,000 yen is calculated. The total purchase amount is calculated as 200,000 yen by totaling the deposit amount.

Then, the fluctuation breakdown generation unit 102e generates a fluctuation breakdown for January based on the aggregation result in the aggregation unit 102b.

Specifically, as shown in FIG. 7 (E), the fluctuation breakdown generation unit 102e aggregates the specified contract number “KEY0001” and the specified fiscal year / month “2019/1”. The total sales amount "500,000 yen" calculated by the total sales amount 102b, the total purchase amount "200,000 yen" calculated by totaling the total sales amount 102b, and the purchase amount from the total sales amount 500,000 yen. Generate a fluctuation breakdown that includes the gross profit amount "300,000 yen" calculated by subtracting the total amount of 200,000 yen as the breakdown of the fluctuation of the amount in January.

(4) Purchase input Next, assuming that the purchase is made according to the contents of the contract data 106a registered in (1), the purchase data 106b shown in FIG. 8 is registered from the purchase input screen (not shown). Will be done.

(5) Sales input Next, assuming that sales are performed according to the contents of the contract data 106a registered in (1), the sales data 106c shown in FIG. 8 is registered from the sales input screen (not shown). Here, at the time of sales registration, the sales amount "500,000 yen" in the sales data 106c (product sales) in FIG. 8 is stored in the record D in the contract data 106a having the same contract number "KEY0001", and the sales amount "500,000 yen". Is updated as. Further, at the time of sales registration, the sales amount "1,000,000 yen" in the sales data 106c (assembly) of FIG. 8 is added to the record E in the contract data 106a having the same contract number "KEY0002", and the sales amount "1,000,000 yen". Updated as.

(6) Generation of Trading Performance Report Finally, the trading performance report generation unit 102d generates the trading performance report as follows.

On the document issuance screen, as shown in (A) of FIG. 9, in order to confirm the actual balance for each item, "sales record report" is selected as the output condition, and the item number "ANKEN1" is specified. When "current" is specified as the output standard, the sales performance report generation unit 102d has the specified item number "ANKEN1" from the contract data 106a of FIG. 8 in which the sales amount has been updated, and , Acquires records (records A to E) having a fiscal year up to the present (ie, January). Then, as shown in FIG. 9B, the trading performance report generation unit 102d is used.
● The total of the specified item number "ANKEN1", the total amount of sales of the acquired records (records A to E) "3,500,000 yen", and the total purchase amount of the acquired records (records A to E). The amount "1,500,000 yen" and the gross profit amount "2,000,000 yen" calculated by subtracting the purchase amount from the sales amount are included as the actual balance of the entire project of "ANKEN1".
● The contract number "KEY0001" possessed by the acquired records A to D, the total amount of sales amount "2,500,000 yen" possessed by the acquired records A to D, and the total amount of purchase amount "950,000 yen". The gross profit amount "1,550,000 yen" calculated by subtracting the purchase amount from the sales amount is included as the actual balance for the contract of "KEY0001", and
● The contract number “KEY0002” of the acquired record E, the sold amount “1,000,000 yen” and the purchase amount “550,000 yen” of the acquired record E, and the purchased amount minus the purchased amount. Includes the gross profit amount "450,000 yen" calculated in the above as the actual balance for the contract of "KEY0002".
Generate a trading performance report.

On the other hand, on the document issuance screen, as shown in (C) of FIG. 9, in order to confirm the actual balance for each contract, "sales record report" is selected as the output condition, and the case number "ANKEN1" is selected. , Contract number "KEY0001" and contract number "KEY0002" are specified, "fiscal year" is specified as the output standard, and "2019/1" is specified as the accounting year and month. The sales performance report generation unit 102d has the designated matter number "ANKEN1" and the contract number "KEY0001" from the contract data 106a of FIG. 8, and has the designated fiscal year (January). Acquire the records (records B to D) to have. Then, as shown in FIG. 9D, the designated contract number "KEY0001", the total amount of sales amount "500,000 yen" held by the acquired records B to D, and the acquired record B The total purchase amount of ~ D "200,000 yen" and the gross profit amount "300,000 yen" calculated by subtracting the purchase amount from the sales amount are used as the actual balance of the contract of "KEY0001". Generate a sales performance report that includes. Further, the sales performance report generation unit 102d has the designated matter number "ANKEN1" and the contract number "KEY0002" from the contract data 106a of FIG. 8, and has the designated fiscal year and month (January). ) Is acquired (record E). Then, as shown in FIG. 9 (E), the designated contract number "KEY0002", the sold amount "1,000,000 yen" held by the acquired record E, and the purchase amount held by the acquired record E. Generate a sales performance report that includes "550,000 yen" and the gross profit amount "450,000 yen" calculated by subtracting the purchase amount from the sales amount as the performance balance for the contract of "KEY0002".

As described above, the monthly processing for January has been completed by the processing from (1) to (6).

[Monthly processing for 2-3.2 months]
(1) Sales input Finally, since the newly ordered "assembly" in (1-2) of [2-2] was a construction project and an emergency construction, the contract for "assembly" and the reissue of the invoice were required. is necessary. Therefore, the cancellation process is performed from the sales input, and after the revision (revise) process of the initial contract amount (1,000,000 yen), the formal billing amount (1,500,000 yen) is recorded as sales.

By adding a check in the left square of the red slip copy on the sales input screen of FIG. 10, the red slip is created and the contract balance is cleared. Specifically, when "UR00003" is specified as the copy number on the sales input screen and a check is added in the left square of the red slip copy, the sales data having the copy number "UR00003" is shown in FIG. The sales amount "1,000,000 yen" in 106c is changed to "-1,000,000 yen" as shown in the sales data 106c of FIG. Further, when the change is made to "-1,000,000 yen", the sold amount in the record E in the contract data 106a of FIG. 10 having the same contract number "KEY0002" is changed to the original sold amount of 1,000,000 yen. The sales amount -1,000,000 yen is added and updated to 0 yen (that is, the contract balance is cleared and sales can be recorded again).

(2) Contract input Next, by entering the contract, the sales amount (1,000,000 yen) at the time of contract (estimation) of the product "assembly" is changed to the official sales amount (1,500,000 yen), and the contract number " The contract of "KEY0002" will be revised (revised). Hereinafter, in this item (2), the revision (revise) process performed by the record generation unit 102a will be described.

As shown in record F of FIG. 10, the record generation unit 102a has the accounting date (2019/2) to which the date (2019/2/8) of the revision due to the change belongs and the processing category “20: correction”. "Before", the ordered product "Assembly", the sales amount of 1,000,000 yen at the time of contract (estimate) for the ordered product minus the amount "-1,000,000 yen", and the contract (estimate) for the ordered product To generate a red record that includes the purchase amount of 550,000 yen plus the amount "-550,000 yen".

As shown in the record G of FIG. 10, the record generation unit 102a has the accounting date (2019/2) to which the date (2019/2/8) of the revision due to the change belongs and the processing category “21: correction”. "After", the ordered product "Assembly", the (formal) sales amount "1,500,000 yen" after the change, and the same amount "550,000 yen" as the purchase amount 550,000 yen at the time of contract (estimate) for the ordered product Generate a black record containing "yen".

(3) Generation of sales report As shown in (A) of Fig. 11, on the document issuance screen, "sales report" is selected as the output condition in order to confirm the planned balance for each contract, and the item number. When "ANKEN1" and the contract number "KEY0002" are specified and "current" is specified as the output reference, the sales report generation unit 102c uses the contract data 106a of FIG. 10 to indicate the specified item number "ANKEN1". And the record (records EG) having the contract number "KEY0002" and having the accounting date up to the present (that is, February) is acquired. Then, as shown in FIG. 11B, the sales report generation unit 102c has the total amount of the sales amount "1,500,000 yen" of the designated contract number "KEY0002" and the acquired records E to G. A sales report that includes the total purchase amount of "550,000 yen" and the gross profit amount of "950,000 yen" calculated by subtracting the purchase amount from the sales amount as the planned balance for the contract of "KEY0002". To generate.

(4) Generation of Fluctuation Breakdown Statement Next, the aggregation unit 102b aggregates the amounts in the contract data 106a prior to the generation of the fluctuation breakdown statement.

Specifically, on the document issuance screen, as shown in (C) of FIG. 11, "variation breakdown" is selected as the output condition, the case number "ANKEN1" is specified, and the contract number "KEY0002" is specified. , Suppose that "fiscal year / month" is specified as the output standard and "2019/2" is specified as the accounting date. Referring to the contract data 106a of FIG. 10, the records having the designated matter number “ANKEN1”, contract number “KEY0002” and fiscal year / month “2019/2” are records F and G. Therefore, as shown in FIG. 11 surrounded by a dotted line, the aggregation unit 102b aggregates the sales amounts of the records F and G to calculate the total sales amount of 500,000 yen, and the total sales amount of the records F and G is 500,000 yen. The total purchase amount is calculated as 0 yen by totaling the deposit amount.

Then, the fluctuation breakdown generation unit 102e generates the fluctuation breakdown for February based on the aggregation result in the aggregation unit 102b.

Specifically, as shown in (D) of FIG. 11, the fluctuation breakdown generation unit 102e aggregates the specified contract number “KEY0002” and the specified fiscal year / month “2019/2”. The total sales amount "500,000 yen" calculated by the total sales amount 102b, the total purchase amount "0 yen" calculated by totaling the total sales amount 102b, and the purchase amount from the total sales amount 500,000 yen. Generate a fluctuation breakdown that includes the gross profit amount "500,000 yen" calculated by subtracting the total amount of 0 yen as the breakdown of the fluctuation of the amount in February.

As described above, as described in this item (4), in the present embodiment, not only can the balance of the entire contract (the balance described in the sales report of FIG. 11) be confirmed with respect to the contract number “KEY0002”, but also the contract. The point is that the balance for February when the revision of the contract occurred (the balance described in the fluctuation breakdown in FIG. 11) can be confirmed (that is, the balance for each month when the contract revision occurred can also be confirmed).

(5) Sales input Next, assuming that sales are performed according to the contents of the contract data 106a changed in (4), the sales data 106c shown in FIG. 12 is registered from the sales input screen (not shown). Here, at the time of sales registration, the sales amount "1,500,000 yen" in the sales data 106c of FIG. 12 is updated to the record in the contract data 106a having the same contract number "KEY0002" as the sales amount "1,500,000 yen". To.

(6) Billing input Finally, the billing statement shown in FIG. 12 is generated by the billing input.

[Summary of processing results from February to February to February]
Summarizing the contents of [2-1] to [2-3] as described above, the monthly results for the project with the project number "ANKEN1" are as shown in FIG.

[3. Summary of this embodiment]
As described above, according to the amount totaling device 100 according to the present embodiment, when the contract is revised, it is possible to capture the balance of the variable amount for each contract and each month after reflecting the revision.

Here, contract revise needs to be continuously managed within the scope of the initial contract unless the contract itself is completed by both parties, but at that time, it is necessary to grasp the contract balance of each month when the revise was carried out. There is. Until now, the contract itself was revisited and the balance of the contract as a whole could be managed, but the contract balance could not be managed in the variable month.

In addition, until now, when the contract that was initially traded is completed, it is necessary to register individual contracts on the system and it is treated as a separate contract, so income and expenditure management for each contract and monthly for each contract It was not possible to capture the variable amount of money on the system.

Therefore, in the present embodiment, for example, the following functions (1) to (4) have been realized.
(1) For contracts that have not been completed due to the system, the initial (past month) contract can be amended.
(2) It is possible to manage the income and expenditure by the fluctuation amount by grasping the fluctuation amount and fluctuation factor after revise every month.
(3) In construction projects, as in emergency construction, the actual billing amount may be determined after the construction is completed, and in that case, the initial estimated amount and the invoice will be re-rolled, resulting in fluctuations in the amount. When the amount of change occurs, the sales and purchases of the original project are canceled, and the estimated amount and sales amount can be changed, which makes it possible to manage the income and expenditure of the initial project.
(4) In the case of construction projects, product sales and assembly projects also occur. For this reason, it has become possible to manage the balance of each project and the balance of the entire construction project.

As a result, in the present embodiment, for example, the following effects (1) to (4) are exhibited.
(1) By capturing the variable amount for each month, it is possible to manage the balance of the entire contract and capture the variable amount balance on a monthly basis.
(2) It has become possible to change from the idea that "it is only necessary to have a balance for the entire contract" to the idea that "the balance should be grasped on a monthly basis".
(3) By grasping the balance by project and the balance by category of projects, it became possible to visualize the profitable segments.
(4) It has become possible to manage the balance of payments for each contract and the balance of payments for the entire project.

[4. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical ideas described in the claims.

For example, of each of the processes described in the embodiments, all or part of the processes described as being performed automatically may be performed manually, or all the processes described as being performed manually. Alternatively, a part can be automatically performed by a known method.

In addition, the processing procedure, control procedure, specific name, information including parameters such as registration data and search conditions of each processing, screen examples, and database configuration shown in the present specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the amount totaling 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, with respect to the processing functions included in the amount totaling device 100, particularly each processing function performed by the control unit, all or any part thereof may be realized by the CPU and a program interpreted and executed by the CPU. It may be implemented as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and the amount totaling apparatus is required. Read mechanically to 100. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into RAM, and constitutes a control unit in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the amount counting device 100 via an arbitrary network, and all or a part thereof can be downloaded as needed. is there.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disk), MO (Magnet-Optical Disk), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in an arbitrary language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as a plurality of modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. A well-known configuration and procedure can be used for a specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, an installation procedure after reading, and the like.

Various databases and the like stored in the storage unit are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the amount totaling 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 an arbitrary peripheral device is connected. Further, the amount totaling device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

Further, the specific form of the distribution / integration of the device is not limited to the one shown in the drawing, and all or a part thereof may be functionally or physically in an arbitrary unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

The present invention is useful, for example, in all industries and industries where contract revisions occur, but is particularly useful in machinery trading companies.

100 Amount totaling device 102 Control unit
102a Record generator
102b Aggregation section
102c Trading Report Generation Department
102d Trading Performance Report Generation Department
102e Fluctuation breakdown generation unit 104 Communication interface unit 106 Storage unit
106a Contract data
106b Purchase data
106c Sales data 108 Input / output interface 112 Input device 114 Output device 200 Server 300 Network

Claims (5)

A monetary amount counting device including a control unit and a storage unit.
In the storage unit
A contract-time record having contract identification data for identifying a contract, a year and month to which the contract date, which is the date when the contract was concluded, and a contract-time amount, which is the contract-time amount for goods or services provided in the contract. Contains contract data, including
The control unit
If the contract is revised due to the addition of a new product or service, a red record having the year and month to which the date of the revision due to the addition belongs and the amount at the time of the contract minus the amount, and the addition A black record having the date to which the revision was made by the above and the same amount as the contract amount, and the year and month to which the date of the revision by the addition belongs and the amount related to the new goods or services. An additional record including an additional amount is generated and stored in the contract data in association with the contract identification data, and if the contract is revised due to a change in the contract amount, the revision due to the change is made. A red record having the date to which the date was made and the amount at the time of the contract minus the amount, and a black record including the year and month to which the date of the revision due to the change belongs and the amount after the change. , And store it in the contract data in association with the contract identification data.
An aggregation means for aggregating the amount of money held by the record in the contract data having the specified contract identification data and the year and month, and
To prepare
A monetary amount totaling device characterized by. The control unit
The designated contract defined by the designated contract identification data, including the designated contract identification data, the designated date, and the amount calculated by aggregating by the aggregation means. To further provide a means for generating a variable breakdown, which is a document for confirming the breakdown of changes in the amount of money over the years.
The amount totaling device according to claim 1. That the amount is at least one of the sales amount and the purchase amount,
The amount totaling device according to claim 1 or 2. It is an amount counting method executed by an information processing device including a control unit and a storage unit.
In the storage unit
A contract-time record having contract identification data for identifying a contract, a year and month to which the contract date, which is the date when the contract was concluded, and a contract-time amount, which is the contract-time amount for goods or services provided in the contract. Contains contract data, including
Executed by the control unit,
If the contract is revised due to the addition of a new product or service, a red record having the year and month to which the date of the revision due to the addition belongs and the amount at the time of the contract minus the amount, and the addition A black record having the date to which the revision was made by the above and the same amount as the contract amount, and the year and month to which the date of the revision by the addition belongs and the amount related to the new goods or services. An additional record including an additional amount is generated and stored in the contract data in association with the contract identification data, and if the contract is revised due to a change in the contract amount, the revision due to the change is made. A red record having the date to which the date was made and the amount at the time of the contract minus the amount, and a black record including the year and month to which the date of the revision due to the change belongs and the amount after the change. , And store it in the contract data in association with the contract identification data.
An aggregation step that aggregates the amount of money held by the record in the contract data having the specified contract identification data and the year and month, and
Including,
Amount aggregation method characterized by. It is an amount counting program to be executed by an information processing device including a control unit and a storage unit.
In the storage unit
A contract-time record having contract identification data for identifying a contract, a year and month to which the contract date, which is the date when the contract was concluded, and a contract-time amount, which is the contract-time amount for goods or services provided in the contract. Contains contract data, including
To make the control unit execute
If the contract is revised due to the addition of a new product or service, a red record having the year and month to which the date of the revision due to the addition belongs and the amount at the time of the contract minus the amount, and the addition A black record having the date to which the revision was made by the above and the same amount as the contract amount, and the year and month to which the date of the revision by the addition belongs and the amount related to the new goods or services. An additional record including an additional amount is generated and stored in the contract data in association with the contract identification data, and if the contract is revised due to a change in the contract amount, the revision due to the change is made. A red record having the date to which the date was made and the amount at the time of the contract minus the amount, and a black record including the year and month to which the date of the revision due to the change belongs and the amount after the change. , And store it in the contract data in association with the contract identification data.
An aggregation step that aggregates the amount of money held by the record in the contract data having the specified contract identification data and the year and month, and
Including,
A monetary amount aggregation program featuring.