JP2021033453A - Sales amount/estimated cost calculation device, sales amount/estimated cost calculation method and sales amount/estimated cost calculation program - Google Patents

Abstract

To provide a sales amount/estimated cost calculation device and the like capable of calculating a total amount of sales of a product and an estimated amount of cost required for borrowing of the product.SOLUTION: According to the present embodiment, (1) a sales amount for each product to a lender is calculated based on a quantity in sales detail history data, a billing period in the sales detail history data, and a billing unit price in the sales detail history data; (2) an estimated cost for each product regarding borrowing from a borrower is calculated based on the quantity in the sales detail history data, the billing period in the sales detail history data, and a purchase unit price in the sales detail history data; and (3) the sales amount for the lender is calculated by totalizing the calculated sales amount for each product to the lender with regard to all the products lent to the lender, and the estimated cost of the borrowing from the borrower is calculated by totalizing the calculated estimated cost for each product with regard to the borrowing from the borrower for all the products borrowed from the borrower.SELECTED DRAWING: Figure 5

Description

The present invention relates to a sales amount / estimated cost calculation device, a sales amount / estimated cost calculation method, and a sales amount / estimated cost calculation program.

In Patent Document 1, it is possible to easily grasp the essential information that is lacking in advancing the solution negotiation, and to easily select the solution information that matches the customer value, and to appropriately analyze and evaluate the solution information. The support device, the control method of the solution negotiation support device, the control program, and the recording medium are disclosed (see paragraph 0014 of Patent Document 1), the expected alternative time calculated from the lease / rental period, and the budget preparation of the customer. It is disclosed that the timing and profit information (initially 0) is stored in the RAM as a temporary file (see paragraph 0227 of Patent Document 1 and the like).

Japanese Unexamined Patent Publication No. 2009-163374

However, with the method described in Patent Document 1, the cost could not be grasped at the same timing as the sales recording.

For example, when the rental company lends the product borrowed from the lender to the lender as shown in the relationship diagram of FIG. 2, the sales amount to the lender can be grasped at the timing of the lending. On the other hand, the invoice issued by the lender is not always issued in the month of the loan, and is often issued in the following month. In this case, the rental company cannot grasp the cost price required for borrowing the product at the same timing as the sales of the product is recorded, which has been a problem from the viewpoint of accelerating the settlement of accounts.

The present invention has been made in view of the above problems, and is a sales amount / estimated cost calculation device, a sales amount / The purpose is to provide an estimated cost calculation method and a sales amount / estimated cost calculation program.

In order to solve the above-mentioned problems and achieve the object, the sales amount / approximate cost calculation device according to the present invention is provided with a control unit, and when the rental company lends the product borrowed from the lender to the lender. It is a sales amount / estimated cost calculation device that calculates the estimated borrowing cost, which is an approximate amount of the sales amount to the lender and the cost amount required for the borrowing, and the control unit inputs the borrowing for each product. And the quantity of the lent product, the borrowing and renting period of the product entered for each product, and the product set for each product, per product and per day for the lender. A sales amount calculation means for calculating the sales amount of each product to the lender based on the sales unit price which is the sales amount of the above and is input or automatically set, and is input for each product. Required for the borrowing set for each combination of the borrowing and the lending product, the borrowing and lending period of the product entered for each product, and the combination of the lender and the product. The estimated cost for each product related to the borrowing from the lender is calculated based on the borrowing unit price, which is the cost amount per product and per day, which is input or automatically set. The sales amount to the lender is calculated by totaling the sales amount for each product to the lender calculated by the approximate cost calculation means and the sales amount calculation means for all the products lent to the lender. Then, the estimated cost for each product related to the borrowing from the lender calculated by the estimated cost calculation means is totaled for all the products borrowed from the lender to obtain the above-mentioned borrowing from the lender. It is characterized by being provided with an aggregation means for calculating the estimated borrowing cost.

Further, the sales amount / approximate cost calculation device according to the present invention is characterized in that the period is a period from the first day of the month to the last day of the month, and the means calculates the amount of money on a monthly basis.

Further, in the sales amount / estimated cost calculation device according to the present invention, the borrowing related to the borrowing from the lender calculated by the totaling means from the sales amount to the lender calculated by the control unit by the totaling means. It is characterized by further providing an approximate gross profit calculation means for calculating an approximate gross profit by deducting the approximate cost.

Further, the sales amount / estimated cost calculation device according to the present invention is an approximate journal including the borrowing estimated cost calculated by the control unit by the totaling means, and is recorded in the month when sales are recorded to the lender. It is characterized by further providing a journal creation means for creating a thing.

Further, in the sales amount / estimated cost calculation device according to the present invention, the journal creation means is a cancellation journal including the same amount as the borrowed estimated cost for canceling the borrowed estimated cost, and the sales is recorded. Create a formal journal entry that includes the formal cost of borrowing, which is the formal cost amount for the borrowing notified by the lender in the following month, and the one that is recorded in the month following the month in which the loan is made. It is characterized by that.

Further, the sales amount / estimated cost calculation device according to the present invention is a cost difference calculation means for the control unit to calculate the difference obtained by subtracting the borrowing estimated cost calculated by the aggregation means from the notified formal borrowing cost. It is characterized by further providing.

Further, the sales amount / estimated cost calculation device according to the present invention is characterized in that the product is a traffic safety product.

Further, the sales amount / estimated cost calculation method according to the present invention is executed by an information processing device provided with a control unit, and when a rental company lends a product borrowed from a lender to the lender, sales to the lender. It is a sales amount / estimated cost calculation method for calculating the estimated borrowing cost, which is the approximate amount of the amount and the cost amount required for the borrowing, and the borrowing and the said borrowing entered for each product, which are executed by the control unit. The quantity of the lent product, the borrowing and renting period of the product entered for each product, and the product set for each product, the product per product and per day for the lender. A sales amount calculation step for calculating the sales amount for each product to the lender based on the sales unit price which is the sales amount and is input or automatically set, and the borrowing input for each product. And the quantity of the lent product, the borrowing and renting period of the product entered for each product, and the product required for the borrowing set for each combination of the lender and the product. Approximate cost to calculate the estimated cost for each product related to the borrowing from the lender based on the borrowing unit price, which is the cost amount per piece and per day, which is entered or automatically set. The sales amount to the lender is calculated by totaling the sales amount for each product to the lender calculated in the calculation step and the sales amount calculation step for all the products lent to the lender. By aggregating the estimated cost for each product related to the borrowing from the lender calculated in the estimated cost calculation step for all the products borrowed from the lender, the borrowing approximate cost for the borrowing from the lender is calculated. It is characterized by including, and an aggregation step for calculating the cost.

Further, the sales amount / estimated cost calculation program according to the present invention is applied to the lender when the rental company lends the product borrowed from the lender to the lender in order to execute the information processing device provided with the control unit. It is a sales amount / estimated cost calculation program that calculates the estimated borrowing cost, which is the approximate amount of the sales amount and the cost amount required for the borrowing, and the borrowing input for each product to be executed by the control unit. And the quantity of the lent product, the borrowing and renting period of the product entered for each product, and the product set for each product, per product and per day for the lender. A sales amount calculation step for calculating the sales amount for each product to the lender based on the sales unit price which is the sales amount of the above and is input or automatically set, and is input for each product. Required for the borrowing set for each combination of the borrowing and the lending product, the borrowing and lending period of the product entered for each product, and the combination of the lender and the product. The estimated cost for each product related to the borrowing from the lender is calculated based on the borrowing unit price, which is the cost amount per product and per day, which is input or automatically set. The sales amount to the lender is calculated by totaling the sales amount for each product to the lender calculated in the approximate cost calculation step and the sales amount calculation step for all the products lent to the lender. Then, the estimated cost for each product related to the borrowing from the lender calculated in the estimated cost calculation step is totaled for all the products borrowed from the lender to obtain the above-mentioned borrowing from the lender. It is characterized by including an aggregation step for calculating the estimated borrowing cost.

According to the present invention, there is an effect that the sales amount of the product and the estimated cost amount required for borrowing the product can be calculated together.

FIG. 1 is a block diagram showing an example of the configuration of the sales amount / estimated cost calculation device. FIG. 2 is a diagram showing an example of a relationship diagram between a lender, a rental company, and a lender. FIG. 3 is a diagram showing an example of an approximate journal, a canceled journal, and a formal journal. FIG. 4 is a diagram showing an example of sales detail history data before setting the billing amount and the estimated cost. FIG. 5 is a diagram showing an example of sales detail history data after setting the billing amount and the estimated cost. FIG. 6 is a diagram showing an example of purchase detail history data.

Hereinafter, embodiments of the sales amount / estimated cost calculation device, the sales amount / estimated cost calculation method, and the sales amount / estimated cost calculation 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 sales amount / estimated cost calculation 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 sales amount / estimated cost calculation device 100.

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

The sales amount / estimated cost calculation 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 sales amount / estimated cost calculation device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the sales amount / estimated cost calculation 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 sales amount / estimated cost calculation 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). 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. 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, sales detail history data 106a and purchase detail history data 106b.

Here, according to the sales amount / estimated cost calculation device 100 according to the present embodiment, as shown in the relationship diagram of FIG. 2, the lending when the rental company lends the product borrowed from the lender to the lender. It is possible to calculate the estimated borrowing cost, which is the approximate amount of the sales amount to the borrower and the cost amount required for the borrowing. The user of the sales amount / estimated cost calculation device 100 according to the present embodiment is, for example, the rental company. The product may be any product that can be rented, and is, for example, traffic safety products and construction equipment.

The sales detail history data 106a is the history data of the sales details. As shown in FIGS. 4 and 5, for example, the sales detail history data 106a includes rental company identification data (business establishment) for identifying the rental company and lender identification data for identifying the lender. (Supplier), product identification data (product name) for identifying the product, the quantity (quantity) of the borrowed product and the loaned product entered for each product, and input for each product. It includes the borrowing and lending period (billing period), the number of days (days) of the period, the billing unit price, the billing amount, the purchase unit price, the estimated cost, and the like.

The billing period may be a period from the first day of the month to the last day of the month as shown in FIGS. 4 and 5, or may be a period other than this. The billing period "10/01 to 10/31" shown in FIGS. 4 and 5 corresponds to the period in the former case, and it is said that the loan has been made to the lender from September to October. The period of the case is assumed.

The billing unit price is a sales unit price set for each product, which is the sales amount per product and per day for the lender, and is input or automatically set. In the case of automatic setting, for example, if the product identification data and the billing unit price are set in association with each other in the billing unit price master, the billing can be performed by inputting the product identification data into the sales detail history data 106a. By acquiring the billing unit price associated with the input product identification data from the unit price master, the acquired billing unit price can be automatically set in the sales detail history data 106a.

The billed amount is the sales amount of each product to the lender, which is calculated by the sales amount calculation unit 102a described later.

The purchase unit price is a borrowing unit price set for each combination of the lender and the product, which is the cost amount per product and per day required for the borrowing, and is input or automatically set. It is a thing. In the case of automatic setting, for example, if the lender identification data, the product identification data, and the purchase unit price are set in association with each other in the purchase unit price master, the lender identification data and the product identification data can be set. Is entered in the sales statement history data 106a to acquire the purchase unit price associated with the entered lender identification data and product identification data from the purchase unit price master, and the acquired purchase unit price is entered into the sales statement. It is possible to automatically set the history data 106a.

The estimated cost is an estimated cost for each product related to the borrowing from the lender, which is calculated by the estimated cost calculation unit 102b described later.

The purchase details history data 106b is the purchase details history data. As shown in FIG. 6, the purchase details history data 106b includes, for example, the rental company identification data (business establishment), the lender identification data (supplier), and the classification of the purchase details (purchase details: (Rental by another company), the quantity (quantity) of purchase, the formal cost amount (purchase amount) of the borrowing notified by the lender, and the like.

As the information for associating the sales detail history data 106a with the purchase detail history data 106b, for example, the rental company identification data (business establishment) and the lender identification data (supplier) can be used.

The control unit 102 is a CPU or the like that collectively controls the sales amount / estimated cost calculation 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) the borrowing and the lent out quantity of the goods input for each product, and the borrowing and renting the goods input for each product. The loan is based on a period and a unit price of sales, which is the sales amount per product and per day for the lender, which is set for each product and is input or automatically set. The sales amount calculation unit 102a as a sales amount calculation means for calculating the sales amount of each product with respect to the destination, (2) the amount of the borrowed product and the loaned product input for each product, and each product. Borrowing of the input product, which is the cost amount per product and per day set for each combination of the borrowing and the lending period and the lender and the product. Approximate cost calculation unit 102b as an approximate cost calculation means for calculating the approximate cost for each product related to the borrowing from the lender based on the unit price entered or automatically set, and (3). The sales amount to the lender is calculated by totaling the sales amount for each product to the lender calculated by the sales amount calculation means for all the products lent to the lender, and the estimated cost is calculated. The estimated cost of borrowing from the lender is calculated by aggregating the estimated cost of each product related to the borrowing from the lender for all the products borrowed from the lender. Approximate by subtracting the estimated borrowing cost for the borrowing from the lender calculated by the aggregation means from the totaling unit 102c as the aggregation means and (4) the sales amount to the lender calculated by the aggregation means. Approximate gross profit calculation unit 102d as an approximate gross profit calculation means for calculating the gross profit of, and (5) a rough journal including the borrowing approximate cost calculated by the aggregation means, and the month in which sales are recorded to the lender. The cost difference between the journal creation unit 102e as a journal creation means for creating what is recorded in (6) and (6) the difference between the notified formal borrowing cost and the estimated borrowing cost calculated by the aggregation means. It is provided with a cost difference calculation unit 102f as a calculation means.

The sales amount calculation unit 102a uses the borrowed product input for each product and the quantity of the loaned product (quantity in the sales detail history data 106a) and the product input for each product as the borrowed product and the product. Enter or enter the lending period (billing period in the sales detail history data 106a) and the sales unit price set for each product, which is the sales amount per product and per day for the lender. Based on the automatically set items (billing unit price in the sales detail history data 106a), the sales amount for each product to the lender (billing amount in the sales detail history data 106a) is calculated.

The approximate cost calculation unit 102b uses the borrowed product entered for each product and the quantity of the loaned product (quantity in the sales detail history data 106a) and the product input for each product as the borrowed product and the product. It is the lending period (billing period in the sales statement history data 106a) and the cost amount per product and per day set for each combination of the lender and the product. Based on the borrowing unit price that is entered or automatically set (purchase unit price in the sales detail history data 106a), the estimated cost for each product related to the borrowing from the lender (sales detail history data 106a). Approximate cost in) is calculated.

The aggregation unit 102c calculates the sales amount to the lender by totaling the sales amount for each product to the lender calculated by the sales amount calculation unit 102a for all the products lent to the lender. , The estimated cost for each product related to the borrowing from the lender calculated by the approximate cost calculation unit 102b is totaled for all the products borrowed from the lender, thereby the borrowing from the lender. Calculate the estimated cost. As a result, for example, it becomes possible to grasp the cost required for borrowing the product at the same timing as the sales of the product is recorded, which leads to the early settlement of accounts.

The estimated gross profit calculation unit 102d calculates the estimated gross profit by subtracting the estimated borrowing cost for the borrowing from the borrower calculated by the aggregation unit 102c from the sales amount to the lender calculated by the aggregation unit 102c. calculate. Thereby, for example, the estimated gross profit can be grasped accurately and quickly.

The journal creation unit 102e creates an approximate journal including the estimated borrowing cost calculated by the aggregation unit 102c, which is recorded in the month when sales are recorded to the lender. As a result, for example, although it is an estimated cost amount, it is possible to close the P / L at an early stage.

The journal creation unit 102e further includes a cancellation journal containing the same amount as the estimated borrowing cost for canceling the estimated borrowing cost, which is recorded in the month following the month in which the sales are recorded, and the above from the lender. A formal journal including the formal cost of borrowing, which is the formal cost amount for the borrowing notified in the next month, may be created and recorded in the next month. This makes it possible, for example, to adjust (correct) the estimated cost amount based on the formal cost amount.

The cost difference calculation unit 102f calculates the difference (cost difference) obtained by subtracting the estimated borrowing cost calculated by the aggregation unit 102c from the notified formal borrowing cost. The cost difference can be grasped by recording the formal journal, but if the cost difference calculation unit 102f automatically calculates the cost difference, the cost difference can be grasped accurately and quickly. ..

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

In this item, the process of calculating the sales amount and the estimated borrowing cost based on the sales detail history data 106a of FIG. 4, which records the history of borrowing and lending in October 2018, will be described in the following [2-1]. To do. Next, regarding the creation process of three journals created based on the calculated estimated borrowing cost or the formal cost amount for borrowing notified by the borrower (supplier) in November of the following month, the following [2- 2] will be described.

[2-1: Calculation process of sales amount and estimated borrowing cost]
The sales amount calculation unit 102a calculates the sales amount for each product to the lender based on the sales detail history data 106a of FIG. Specifically, the sales amount calculation unit 102a calculates the sales amount of the product name “building frame 1217” in FIG. 4 by quantity 100 × billing period 10/01 to 10/31 (31 days) × billing unit price 170 yen = 527,000. Calculated as yen, and the sales amount of the product name "building frame 1227" in Fig. 4 is calculated as quantity 100 x billing period 10/01 to 10/31 (31 days) x billing unit price 270 yen = 837,000 yen. Then, the sales amount of the product name “building frame 1237” in FIG. 4 is calculated as quantity 100 × billing period 10/01 to 10/31 (31 days) × billing unit price 370 yen = 1,147,000 yen. FIG. 5 shows sales detail history data 106a in which the calculated sales amount for each product is set as the billing amount.

Subsequently, the aggregation unit 102c aggregates the sales amount for each product to the lender calculated by the sales amount calculation unit 102a, thereby increasing the sales amount to the lender by 527,000 yen + 837,000 yen + 1,147,000 yen = 2,511,000 yen. Is calculated.

On the other hand, the estimated cost calculation unit 102b calculates the estimated cost for each product related to the borrowing from the lender "○○ Rental Co., Ltd." based on the sales detail history data 106a of FIG. Specifically, the estimated cost calculation unit 102b sets the estimated cost of the product name “building frame 1217” in FIG. 4 as quantity 100 × billing period 10/01 to 10/31 (31 days) × purchase unit price 100 yen = Calculated as 310,000 yen, and the estimated cost of the product name "Building frame 1227" in Fig. 4 is calculated as quantity 100 x billing period 10/01 to 10/31 (31 days) x purchase unit price 120 yen = 372,000 yen. Then, the estimated cost of the product name "building frame 1237" in FIG. 4 is calculated as quantity 100 x billing period 10/01 to 10/31 (31 days) x billing unit price 150 yen = 465,000 yen. FIG. 5 shows sales detail history data 106a in which the calculated estimated cost for each product is set.

Subsequently, the aggregation unit 102c aggregates the estimated cost for each product related to the borrowing from the borrower "○○ Rental Co., Ltd." calculated by the approximate cost calculation unit 102b, so that the borrower "○○ Rental Co., Ltd." The estimated cost of borrowing is calculated as 310,000 yen + 372,000 yen + 465,000 yen = 1,147,000 yen.

As described above, according to the sales amount / estimated cost calculation device 100 according to the present embodiment, the sales amount (2,511,000 yen) and the estimated borrowing cost (1,147,000 yen) can be calculated together. As a result, the rental company "XX branch" can grasp the cost required for borrowing the product at the same timing as the sales recording.

Here, the business office of the rental company can grasp the estimated gross profit by obtaining the difference between the sales amount and the estimated borrowing cost, but the estimated gross profit calculation unit 102d automatically performs the gross profit as follows. By calculating, the sales office work and the like can grasp the gross profit more quickly and more accurately.

Specifically, the approximate gross profit calculation unit 102d estimates the borrowing from the lender "○○ Rental Co., Ltd." calculated by the aggregation unit 102c from the sales amount of 2,511,000 yen to the lender aggregated by the aggregation unit 102c. By deducting the cost of 1,147,000 yen, the estimated gross profit of 1,364,000 yen is calculated.

[2-2: Journal creation process]
Next, suppose that in November 2018, the borrower "○○ Rental Co., Ltd." notified the official borrowing cost of 1,150,000 yen, which is the official cost amount for borrowing the three borrowed products. In this case, the business affairs of the rental company "XX Branch" will be the estimated borrowing cost of 1,147,000 yen for the borrowing from the lender "○○ Rental Co., Ltd." calculated in [2-1], and the officially notified borrowing. If there is no problem in comparing the cost of 1,150,000 yen with the cost of 1,150,000 yen, the notified formal borrowing cost of 1,150,000 yen is registered in the purchase details history data 106b. In other words, if the cost difference, which is the difference between the estimated purchase amount (estimated borrowing cost) and the formal purchase amount (formal borrowing cost), is not so large, the sales office work, etc. The deposit amount of 1,150,000 yen is registered in the purchase details history data 106b. In the case of this example, the difference between the estimated purchase amount and the formal purchase amount is only 3,000 yen, so it is judged that there is no problem with sales affairs, etc., and the formal purchase amount of 1,150,000 yen is set as shown in Fig. 6. It shall be registered in the receipt detail history data 106b.

The cost difference calculation unit 102f may automatically calculate the cost difference as follows. That is, the cost difference calculation unit 102f can calculate the cost difference of 3,000 yen by subtracting the estimated borrowing cost of 1,147,000 yen calculated by the aggregation unit 102c from the notified formal borrowing cost of 1,150,000 yen.

Below, regarding the creation process of three journals created based on the estimated borrowing cost of 1,147,000 yen calculated in [2-1] or the formal borrowing cost of 1,150,000 yen registered in the purchase details history data 106b, the following (1) This will be described in (3).

As an overview, the journal entry creation unit 102e records the estimated rental cost of other companies used when calculating gross profit at the time of sales recording as a breaking news in the current month, and records the same amount of minus as a cancellation journal the following month.

(1) Creation of approximate journal First, the journal creation unit 102e makes an estimate in FIG. 3 based on the estimated borrowing cost (rental sales cost) of 1.147 million yen (1,147,000 yen) in the sales detail history data 106a in FIG. Create a journal. The approximate journal is a journal that includes the estimated cost of borrowing from the lender "○○ Rental Co., Ltd." and is recorded in October 2018, which is the month when sales are recorded to the lender.

As a specific process for creating the approximate journal, the journal creation unit 102e has, as shown in FIG.
・ As a debit item, including rental cost
-The debit amount includes the rental sales cost of 1,147,000 yen in the sales statement history data 106a in Fig. 3.
・ As a credit subject, including the headquarters
・ The credit amount includes 1,147,000 yen, which is the same amount as the debit amount.
Create an approximate journal.

The 1,147,000 yen in the rough journal is a rough estimate, not a final purchase, but it is linked as a journal in order to close the P / L at an early stage in accounting.

(2) Creation of Cancellation Journal Next, the journal creation unit 102e creates a cancellation journal shown in FIG. 3 based on the created approximate journal. The cancellation journal is a journal for canceling the estimated cost of borrowing from the borrower "○○ Rental Co., Ltd." and is recorded in November 2018, which is the month following the month of recording sales (October 2018). Will be done.

As a specific process for creating a cancellation journal, the journal creation unit 102e has, as shown in FIG.
・ The debit item includes the headquarters, which is the credit item of the rough journal in Fig. 3.
・ The debit amount includes the same amount of 1,147,000 yen as the credit amount of the approximate journal in Fig. 3.
-The credit item includes the rental cost, which is the debit item of the approximate journal in Fig. 3.
・ The credit amount includes 1,147,000 yen, which is the same amount as the debit amount of the approximate journal in Fig. 3.
Create a cancellation journal.

(3) Creation of formal journals Finally, the journal entry creation unit 102e shows the figure based on the formal borrowing cost (rental purchase amount) of 1.15 million yen (1,150,000 yen) in the purchase details history data 106b of FIG. Create the formal journal shown in 3. The formal journal is a journal that includes the formal borrowing cost, which is the formal cost amount notified by the lender "○○ Rental Co., Ltd.", and is the month following the month in which sales are recorded (October 2018), 2018. It will be recorded in November.

As a specific process for creating a formal journal, the journal creation unit 102e has, as shown in FIG.
・ As a debit item, including rental cost
-The debit amount includes the rental purchase amount of 1,150,000 yen in the purchase details history data 106b in Fig. 3.
・ As a credit item, including accounts payable
・ The credit amount includes 1,150,000 yen, which is the same amount as the debit amount.
Create a formal journal.

In the formal journal, the image is that the difference from the formal purchase will be additionally recorded in November (the cost difference in October will be recorded in November). In other words, the difference between the rental cost and the balance will be adjusted this month as the last month's cost difference.

[3. Summary of this embodiment]
As described above, according to the sales amount / estimated cost calculation device 100 according to the present embodiment, as described in [2-1], the sales amount of the product and the estimated cost amount required for borrowing the product are calculated. It can also be calculated. As a result, for example, it becomes possible to grasp the cost required for borrowing the product at the same timing as the sales of the product is recorded, which leads to the early settlement of accounts.

Here, conventionally, there is a problem that the arrival of the invoice of another company's rental destination (borrowing destination) may be delayed, and if the invoice arrives, the P / L cannot be closed early. Moreover, even if the estimated cost is recorded, the work of calculating the amount (approximate cost) is not easy. Therefore, in the present embodiment, for example, the following three things have been made possible.

First, in the present embodiment, for example, the cost can be grasped at the same timing as the sales recording. In the past, in order to grasp the gross profit for each site of each other company's rental destination, it was not possible to grasp it unless the invoice was entered in the statement from the other company's rental destination, but in this embodiment, it is recorded as sales. At the same time, by calculating the cost roughly, it has become possible to grasp the gross profit without entering the contents of the invoice.

Secondly, in the present embodiment, for example, at the time of formal purchase accounting, it is not necessary to input detailed purchase details, and the total amount of the invoice can be input. In this embodiment, since the information for grasping the gross profit is separately stored (= in the sales detail history data 106a), it is sufficient to input the minimum information for making payment for the purchase. It was.

Thirdly, in the present embodiment, for example, it is easy to match with an invoice from another company's rental destination. In the past, it was difficult to scrutinize the invoice received from the lender because there are many cases where there is no material for checking the invoice, but in this embodiment, it is called an approximate purchase (approximate cost). You can now check invoices by comparison. And when there is a big gap, it has become possible to point out billing mistakes for rentals of other companies.

[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 automatically performed may be manually performed, or all of the processes described as being performed manually. Alternatively, a part thereof 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 sales amount / estimated cost calculation 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 sales amount / estimated cost calculation device 100, particularly each processing function performed by the control unit, all or any part thereof is interpreted and executed by the CPU and the program. It may be realized, or it may be realized 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 sales amount and sales amount can be determined as necessary. It is mechanically read by the approximate cost calculation device 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into the RAM, and cooperates with the CPU to form a control unit.

Further, this computer program may be stored in an application program server connected to the sales amount / estimated cost calculation device 100 via an arbitrary network, and all or a part thereof may be downloaded as needed. It is also possible.

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), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

The "program" is a data processing method described in any 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. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, the 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 sales amount / estimated cost calculation 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. Good. Further, the sales amount / estimated cost calculation 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 the industry of renting goods.

100 Sales amount / estimated cost calculation device 102 Control unit
102a Sales amount calculation department
102b Approximate cost calculation department
102c Aggregation section
102d Approximate gross profit calculation unit
102e Journal Creation Department
102f Cost difference calculation unit 104 Communication interface unit 106 Storage unit
106a Sales statement history data
106b Purchase details history data 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (9)

A sales amount that is equipped with a control unit and calculates the estimated borrowing cost, which is an approximate amount of sales to the lender and the cost required for the borrowing when the rental company lends the product borrowed from the lender to the lender.・ It is an approximate cost calculation device.
The control unit
The quantity of the borrowed product and the loaned product entered for each product, the borrowed and loaned period of the product entered for each product, and the lender set for each product. A sales amount calculation means for calculating the sales amount of each product to the lender based on the sales unit price which is the sales amount per product and per day and is input or automatically set. When,
It is set for each combination of the borrowing and the loaned product entered for each product, the borrowing and lending period of the product entered for each product, and the lender and the product combination. In addition, the product related to the borrowing from the lender is based on the borrowing unit price, which is the cost amount per day and per product required for the borrowing, and is input or automatically set. Approximate cost calculation means for calculating the estimated cost for each, and
The sales amount for each product to the lender calculated by the sales amount calculation means is totaled for all the products lent to the lender to calculate the sales amount to the lender, and the estimated cost is calculated. The estimated cost of borrowing from the lender is calculated by aggregating the estimated cost of each product related to the borrowing from the lender for all the products borrowed from the lender. Aggregation means and
To prepare
A sales amount / estimated cost calculation device characterized by. The above period is the period from the first day of the month to the last day of the month.
The means is to calculate the monthly amount,
The sales amount / estimated cost calculation device according to claim 1. The control unit
An approximate gross profit calculation means for calculating an approximate gross profit by subtracting the borrowing approximate cost for the borrowing from the lender calculated by the aggregation means from the sales amount to the lender calculated by the aggregation means. To prepare further,
The sales amount / estimated cost calculation device according to claim 1 or 2. The control unit
Further provided with a journal creation means for creating an approximate journal including the estimated borrowing cost calculated by the aggregation means, which is recorded in the month in which sales are recorded for the lender.
The sales amount / estimated cost calculation device according to claim 2 or 3. The journal entry means further
Regarding cancellation journals containing the same amount as the estimated borrowing cost for canceling the estimated borrowing cost, which are recorded in the month following the month in which the sales are recorded, and the borrowing notified by the lender in the following month. To create a formal journal that includes the formal cost of borrowing, which is the formal cost amount, and will be recorded in the following month.
The sales amount / estimated cost calculation device according to claim 4. The control unit
Further provided with a cost difference calculation means for calculating the difference obtained by subtracting the estimated borrowing cost calculated by the aggregation means from the notified official borrowing cost.
The sales amount / estimated cost calculation device according to claim 5. That the product is a traffic safety product
The sales amount / estimated cost calculation device according to any one of claims 1 to 6. Borrowing, which is an approximate amount of sales to the lender and the cost required for the borrowing when the rental company lends the product borrowed from the lender to the lender, which is executed by an information processing device provided with a control unit. It is a sales amount / estimated cost calculation method for calculating the estimated cost.
Executed by the control unit,
The quantity of the borrowed product and the loaned product entered for each product, the borrowed and loaned period of the product entered for each product, and the lender set for each product. A sales amount calculation step for calculating the sales amount of each product to the lender based on the sales unit price which is the sales amount per product and per day and is input or automatically set. When,
It is set for each combination of the borrowing and the loaned product entered for each product, the borrowing and lending period of the product entered for each product, and the lender and the product combination. In addition, the product related to the borrowing from the lender is based on the borrowing unit price, which is the cost amount per day and per product required for the borrowing, and is input or automatically set. Approximate cost calculation step to calculate the estimated cost for each, and
The sales amount to the lender is calculated by totaling the sales amount for each product to the lender calculated in the sales amount calculation step for all the products lent to the lender, and the estimated cost is calculated. The estimated cost of borrowing from the lender is calculated by aggregating the estimated cost of each product related to the borrowing from the lender in step for all the products borrowed from the lender. Aggregation steps and
Including,
A sales amount / estimated cost calculation method characterized by. It is an approximate amount of sales to the lender and the cost required for the borrowing when the rental company lends the product borrowed from the lender to the lender for execution by the information processing device provided with the control unit. It is a sales amount / estimated cost calculation program that calculates the estimated cost of borrowing.
To make the control unit execute
The quantity of the borrowed product and the loaned product entered for each product, the borrowed and loaned period of the product entered for each product, and the lender set for each product. A sales amount calculation step for calculating the sales amount of each product to the lender based on the sales unit price which is the sales amount per product and per day and is input or automatically set. When,
It is set for each combination of the borrowing and the loaned product entered for each product, the borrowing and lending period of the product entered for each product, and the lender and the product combination. In addition, the product related to the borrowing from the lender is based on the borrowing unit price, which is the cost amount per day and per product required for the borrowing, and is input or automatically set. Approximate cost calculation step to calculate the estimated cost for each, and
The sales amount to the lender is calculated by totaling the sales amount for each product to the lender calculated in the sales amount calculation step for all the products lent to the lender, and the estimated cost is calculated. The estimated cost of borrowing from the lender is calculated by aggregating the estimated cost of each product related to the borrowing from the lender in step for all the products borrowed from the lender. Aggregation steps and
Including,
A sales amount / estimated cost calculation program featuring.

Images