JP2019121117A - Sales accounting processor, sales accounting method, and sales accounting program - Google Patents

Abstract

To enable a billing party to accurately grasp the sales amount even if billing partner's closing date and billing party's closing date are different.SOLUTION: A sales accounting processor according to the present embodiment includes a control unit and a storage unit configured to store a statement recording the contents of a service provided to a customer and a billing reference date for charging the customer for the service. The control unit includes sales accounting means for recording, if the closing date of a period related to sales accounting differs from the billing reference date, the sum of the countervalue from the first day of the period to the billing reference date in the period and the countervalue after the billing reference date up to the closing date of the period, as the sales amount for the period.SELECTED DRAWING: Figure 2

Description

  The present invention relates to a sales accounting processor, a sales accounting method and a sales accounting program.

  In the rental business, there are multiple contract forms for lending. The contract form includes, for example, daily electricity, monthly electricity, daily rates, duration, and the like. The billed amount of the loaned goods (rental fee) is calculated on the basis of the billing date of the borrower for the reason that the contract form is determined according to the number of days of operation of the loaned goods. Therefore, the amount charged to the borrower is unknown (undetermined) until the closing date of the claim.

  In addition, some companies such as lenders in the rental business may record sales in a predetermined cycle (for example, on a regular basis, such as monthly) in order to grasp the management situation. The sales are recorded on the company closing date (company closing date).

  Patent Document 1 describes a method of distributing maintenance expenses and the like of rental assets rented to a plurality of partners in the rental business and a method of creating a journal. In particular, in paragraph 0007, the problem to be solved by the invention described in Patent Document 1 is “distributed in the type of business where rental assets are frequently moved between sales offices, such as in the rental industry such as construction machinery. There is a problem that it is difficult to accurately manage performance because it is not possible to calculate the correct burden amount for each sales office for the maintenance costs to be made. ”

JP 2001-175779 A

By the way, the bill closing date of the borrower described above may be different from the own closing date of the lender, ie, the rental company. In this case, since the billing amount is in an undetermined state from the billing closing date the next day to the billing closing date of the next month, the billing amount from the billing closing day next day to the company closing date becomes unknown. Therefore, there is a problem that it is not possible to accurately grasp the sales amount corresponding to the period divided by the company's closing date in the company's sales accounting. Furthermore, although the rental business has been described as an example, the problem is not limited to the rental business, but there is a similar problem as long as the service provider makes a request to the service recipient for a predetermined closing date. .
In addition, since the above problems are not recognized in Patent Document 1, it is difficult to solve the above problems.

  The present invention has been made in view of the above, and even if the closing date of the billed party (debtor) and the closing date of the claimant (creditor) are different, the claimant accurately grasps the sales amount Intended to be possible.

  In order to solve the problems described above and achieve the object, the sales accounting processing device according to the present invention includes a control unit and a storage unit, and the storage unit records details of the service provided to the customer Storing a billing reference date for billing the customer for the service, and the control unit is configured to calculate the sales billing period from the first day of the period if the closing date of the period for accounting for sales is different from the billing reference date A sales accounting means is provided for recording the amount of the sum of the consideration up to the billing reference date and the consideration from the day after the billing reference day to the closing date of the period as the sales amount for the period. Do.

  Further, in the sales accrual processing device according to the present invention, the control unit is configured such that the processing date is from the first day of the period to the processing date if the processing date is earlier than the billing reference date, or the processing date is the billing standard. It is characterized by further comprising a bulletin calculation means for obtaining a first estimated sales amount corresponding to the consideration of the processing date from the day after the billing reference date if it is after the day.

  Further, in the sales accrual processing device according to the present invention, if the processing date is earlier than the reference billing date, the control unit is from the first of the period to the closing date, or the processing date is the billing reference. It is characterized by further comprising prediction calculation means for obtaining a second estimated sales amount corresponding to the consideration of the consideration from the day after the billing reference date to the closing date if it is after the day.

  Further, a sales accounting method according to the present invention includes a control unit, a statement recording details of service provided to a customer, and a storage unit storing a billing reference date for billing the customer for the service. According to another aspect of the present invention, there is provided a sales accounting processing method executed by an information processing apparatus, wherein when a closing date of a period pertaining to sales accounting is different from the billing reference date executed by the control unit, the first day of the period Including a sales accounting step of accounting the sum of the consideration up to the billing reference date and the consideration from the next day of the billing reference day to the closing date of the period as the sales amount for the period It features.

  In addition, the sales accounting processing program according to the present invention includes a control unit, a statement that records the content of a service provided to a customer, and a storage unit that stores a billing reference date for billing the customer for the service. A sales accounting processing program for causing the information processing apparatus to execute, when the closing date of the period pertaining to the sales accounting for causing the control unit to execute is different from the billing reference date, the period from the first day of the period Including a sales accounting step of accounting the sum of the consideration up to the billing reference date and the consideration from the next day of the billing reference date to the closing date of the period as sales amount for the period; It is characterized by

  The present invention is effective in that the claimant can accurately grasp the amount of sales even if the due date of the claimant (debtor) and the due date of the claimant (creditor) are different.

FIG. 1 is a block diagram showing an example of the configuration of a sales accounting processor. FIG. 2 is a diagram showing an example of timing when each process is performed by the sales accounting processor. FIG. 3 is a diagram showing an example of the delivery data. FIG. 4 is a diagram showing an example of the day's preliminary sales data and the end-of-month forecast sales data. FIG. 5 is a diagram showing an example of storage data. FIG. 6 is a diagram showing an example of finalized data and sales details. FIG. 7 is a view showing another example of the day-to-day preliminary sales data and the end-of-month forecast sales data. FIG. 8 is a diagram showing another example of the warehousing data. FIG. 9 is a diagram illustrating an example of deemed sales data and data of deemed portions of sales specifications (black data in the current month and red data in the next month).

Hereinafter, embodiments of a sales accounting processing device, a sales accounting processing method, and a sales accounting processing program according to the present invention will be described in detail based on the drawings.
In the present embodiment, the sales accounting apparatus and the like will be described by taking the rental business as a specific example. In the rental business, a rental company charges a customer who has borrowed a product for compensation for a lending service, and uses a sales accounting processor or the like to record sales that can be obtained as a result of the billing. The rental company is a lender (a provider of service) and a claimant (a creditor). The customer is the borrower (the recipient of the service) and the counterpart of the request for the consideration (the debtor).
The present invention is not limited by the present embodiment.

[1. Overview]
Many package systems are built to account for sales. Generally, sales are recorded periodically (for example, on a monthly basis) in a predetermined cycle, which is useful for grasping the management situation and the like. Hereinafter, the case where the predetermined cycle is monthly will be described as an example.
Sales accounting as monthly processing is performed after the closing date or closing date of the current month, based on sales details from the day following the closing date of the previous month to the closing date of the current month. For convenience of explanation, the monthly closing date of the sales accrual process will be referred to as the “company closing date” below. Here, "in-house" is a rental company.

In addition, in many package systems, sales specifications used for sales accrual processing are created by determining billing to a billing partner (customer who is the borrower). It is the billing reference date (hereinafter referred to as the “bill closing date”) for billing the customer (billing party) for the service for which the billing to the billing party is finalized.
Here, if the billing closing date of the billing counterparty is different from the own closing date, the sales amount recorded by the sales accrual processing is only the billing finalization amount. For this reason, the sales amount that is unclaimed but expected to be paid after the billing closing date and before the company closing date was not included in monthly sales.

  Therefore, in the present embodiment, for example, the amount of money expected as the compensation from the billing closing date to the company closing date but not yet invoiced is calculated as a sales amount, and the deemed sales amount and the determined sales amount. We provide sales accounting processing equipment, sales accounting method and sales accounting processing program that can obtain the sales amount including the deemed portion by adding up the current month and the current month. The specific configuration and operation will be described below.

[2. Constitution]
The configuration of the sales accounting processing 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 sales accounting processor 100.

  The sales accounting processing device 100 is a commercially available desktop personal computer. The sales accounting processing apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, and a portable personal computer such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, etc. It may be a type information processing apparatus.

  The sales account processing apparatus 100 includes a control unit 110, a storage unit 120, a communication interface unit 130, and an input / output interface unit 140. The units included in the sales accrual processing device 100 are communicably connected via an arbitrary communication path.

  The communication interface unit 130 communicably connects the sales accounting processing device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 130 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the sales accrual processing device 100 and the server 200 in a mutually communicable manner, and is, for example, the Internet, a local area network (LAN), or the like. Note that data stored in the storage unit 120 described later may be stored in the server 200.

  An input device 150 and an output device 160 are connected to the input / output interface unit 140. For the output device 160, in addition to a monitor (including a home television), a speaker or a printer can be used. The input device 150 can be a keyboard, a mouse, a microphone, and a monitor that cooperates with the mouse to realize a pointing device function. Hereinafter, the output device 160 may be described as the monitor 160 and the input device 150 may be described as the keyboard 150 or the mouse 150.

  The storage unit 120 stores various databases, tables, files, and the like. The storage unit 120 stores a computer program for giving instructions to a central processing unit (CPU) in cooperation with an operating system (OS) to perform various processes. As the storage unit 120, for example, a memory device such as a random access memory (RAM) or a read only memory (ROM), a fixed disk device such as a hard disk, a flexible disk, an optical disk or the like can be used.

  The storage unit 120 stores the delivery data storage unit 121, the warehousing data storage unit 122, the day's breaking sales data storage unit 123, the end of the year forecast sales data storage unit 124, the deemed sales data storage unit 125, and the sales statement storage unit 126 There is. The sales statement storage unit 126 includes a finalized data storage unit 126a, a current black data storage unit 126b, and a next month red data storage unit 126c.

Although all of these are provided in the storage unit 120 in FIG. 1, it is not necessary to provide all of them in a single storage medium in implementation.
The outline of the contents included in each of the data storage units 121 to 125, 126a to 126c is as follows, but the details of the items included in each of the above-mentioned data storage units 121 to 125, 126a to 126c are described in [3 . Specific Example of Processing].

  In the following description, as an example, it is assumed that the company closing date is the last day of the month (the end of the month) and the billing closing date is the 20th every month. FIG. 2 is a diagram showing an example of the timing at which each processing is performed by monthly sales accrual processing in July 2017. The implementation date may be any number of days, including the company's closing date and the billing closing date. Furthermore, in implementation, the cycle may not be monthly.

First, the data storage units 121 to 125, 126a to 126c described above store data in the form of, for example, a table. In this case, the record included in the table is an example of “details recording the content of the service provided to the customer”.
In the present embodiment, the case where each data storage unit 121 to 125, 126a to 126c stores data in the form of a table will be described as an example, but each data storage unit 121 to 125, 126a to 126c The data may be stored in a format other than the table.

The delivery data storage unit 121 stores data (delivery data) related to delivery, that is, lending of a product. The delivery data includes, for example, a date when lending starts, a date when return is scheduled, information on a customer, information on a product, information on contract content, and the like.
The warehousing data storage unit 122 stores warehousing, that is, data (warehousing data) related to the return of the product. The warehousing data includes, for example, the date of return, information of a customer, information of a product, information of contract contents, and the like.

The day's flash sales data storage unit 123 stores sales data (on the day flash sales data) corresponding to the consideration from the present day 1 (the day after the company's closing date of the previous month) to the day of the flash calculation process described later. .
The predicted sales data storage unit 124 at the end of the month stores sales data (estimated sales data at the end of the month) corresponding to the consideration from the present day 1 to the end date (one cycle including the company's closing date of the present month). In addition, one cycle including the company's closing date of the current month is the period from the day after the company's closing date of the previous month to the company's closing date of the current month.

  The deemed sales data storage unit 125 stores sales data (considered sales data) corresponding to the consideration from the 21st of the month to the last day (from the day after the invoice closing date of the current month to the company closing date of the current month).

The sales statement storage unit 126 stores data of sales recorded as receivables.
The finalized data storage unit 126a stores data (finalized data) of sales for which billing to the billing partner is finalized.

Among the data of sales corresponding to the consideration during this month from the first day of the month to the end of the month (one cycle including the company's closing date of the month), the data of the sales for which the request to the billing partner is undetermined This month's black data is stored. This current black data corresponds to deemed sales data.
Next month's red data storage unit 126c is the item of the current month's black data minus one times "quantity" and "amount", and the data for making the portion recorded as sales considered in the current month negative in the next month (The following month red data).

  The control unit 110 is a CPU or the like that controls the sales accounting processing device 100 in a centralized manner. The control unit 110 has an internal memory for storing control programs such as the OS, programs defining various processing procedures, required data, etc., and performs various information processing based on the stored programs. Run.

The control unit 110 includes functional units of the leaving recording unit 111, the storage recording unit 112, the breaking news calculation unit 113, the prediction calculation unit 114, the billing calculation unit 115, and the deemed sales calculation unit 116 in functional concept. .
Each of the functional units 111 to 116 requests the operator to input data via the output device 160 during processing performed by each of the functional units 111 to 116, and receives input from the operator via the input device 150.

The delivery recording unit 111 executes delivery processing. That is, the delivery recording unit 111 causes the delivery data storage unit 121 to store, as delivery data, the data relating to the lending input by the operator.
The warehousing recording unit 112 performs warehousing processing. That is, the warehousing recording unit 112 causes the warehousing data storage unit 122 to store, as warehousing data, data relating to the return input by the operator upon goods return.

  The breaking news calculation unit 113 is an example of breaking news calculation means, and performs breaking news calculation processing. That is, the breaking news calculation unit 113 creates breaking sales data on the present day based on the goods leaving data and the warehousing data, stores it on the breaking sales data storage unit 123 on the day, and calculates the first estimated sales amount obtained by totaling the breaking sales data on the day. Do. The first estimated sales amount is an amount estimated as the consideration from the first day of the current month to the day of the preliminary calculation processing (an aggregate value of the estimated amounts of the consideration for each item).

  The prediction calculation unit 114 is an example of a prediction calculation unit, and performs prediction calculation processing. That is, the forecasting calculation unit 114 creates the forecasted sales data at the end of the month based on the goods issue data and the warehousing data, stores them in the forecasted sales data storage unit 124 at the end of the month, and calculates the second estimated sales amount totaling the forecasted sales data at the end of the month. Do. The second estimated sales amount is an amount estimated as the consideration from the first day of the month to the end of the month (an aggregate value of the estimated amounts of the consideration for each item).

  The billing calculation unit 115 performs billing confirmation processing to finalize billing for the customer who has reached the billing closing date. That is, the claim calculation unit 115 calculates the billed amount for the details of the period from the next day of the last month billing date to the current month billing date, adds up the bill amount of each statement and bills the customer for this month Calculate the forehead). Further, the charge calculation unit 115 stores the fixed data including the charged amount in the fixed data storage unit 126a, and stores the fixed charge in the fixed data storage unit 126a in association with the fixed data.

  The deemed sales calculation unit 116 performs assumed sales calculation processing. That is, the deemed sales calculation unit 116 calculates the deemed sales amount estimated as the consideration for the current month, although the billing to the billed party is undecided at the closing date. Also, the assumed sales calculation unit 116 stores data including the assumed sales amount in the assumed sales data storage unit 125.

  Further, the assumed sales calculation unit 116 generates the current month black data and the next month red data based on the assumed sales data, and stores them in the respective storage units 126 b and 126 c.

  The control unit 110 functions as an example of the sales accounting unit, and calculates the sales amount of the current month based on the fixed data, the current black data, and the next month red data.

  In addition, about the detail of the process which each part performs, the following [3. Specific Example of Processing] will be described in detail.

[3. Specific example of processing]
Specific examples of the process according to the present embodiment will be described in detail with reference to FIGS. As described above, FIG. 2 is a diagram showing an example of the timing at which each process is performed by the monthly sales accrual process of July 2017. A description will be given below along the timing shown in FIG.

(1) July 7, 2017: Delivery The delivery storage unit 111 requests the operator to input delivery data via the output device 160, and the data input via the input device 150 is output from the delivery data storage unit It is stored in 121.

  FIG. 3 is a diagram showing an example of the delivery data. Goods issue data is: delivery slip number, line number, issue date, customer code, customer name, item code, item name, quantity, contract classification, start date, scheduled end date, number of days for suspension, number of days (billing days), unit price (contract Depending on the form), monthly polar day discount rate, etc. items are included.

  The delivery slip number is a number common to the items handled in one process. The line numbers are different for each item handled in one process. The line number is assigned, for example, for each type of product to be a loaned item or for each contract category. The issue date is the day of the beginning of the term of the loan agreement. The start date is the same as the departure date. The scheduled end date is a date scheduled as the date for closing the contract. The customer code is a unique number for each customer. The customer name is the name of the customer. The product code is a number different for each product. The product name is the name of the product. The quantity is the number of loans of the product specified by the product code. Contract classification is classification of the method of lending products. Contract classifications include daily, monthly, monthly polar, and monthly contracts.

(Contract classification: About daily)
The Japan Post is a type of rental sales transaction, and is a contract form in which the billed amount of a loaned item is billed on a daily basis. The billed amount is calculated, for example, by the following equation (1).
Billing amount = Quantity x Daily pole price x Number of days billed ... Formula (1)
The number of days billed in the above equation (1) is determined by the following equation (2).
Number of days for billing = start date-number of days for end date-number of rest days formula (2)
The start date and the end date in the above equation (2) are determined as follows.
Start date: The contract month (first time) is the start date of goods issue input,
The next month after the contract month (continuation) is the day after the last billing date.
End date: Contract end month (goods receipt) is the end date of goods receipt input,
The date before the last month of the contract termination month (continuation) is the current billing date.
Here, on a daily basis, there may be a pause date set. The number of rest days in the above equation (2) is the number of rest days included between the start date and the end date. In this example, 9,16,23,30 days are set as the suspension date of July 2017 for the loaned item A and the loaned item B.

(Contract classification: about monthly pole)
Monthly is a type of rental sales transaction, and is a contract form in which the billed amount of a loaned item is charged on a monthly basis. The billed amount is calculated, for example, by the following equation (3).
Billing amount = Quantity x Monthly pole price ... Formula (3)

(Contract classification: about monthly installment)
The monthly polar daily allowance is a type of rental sales transaction, and the unit price per month (monthly polar unit price) divided by the number of days per day denominator (the monthly polar day relative unit price) is the unit price per day and the billed amount of the loaned goods It is a contract form to request. The billed amount is calculated, for example, by the following equation (4).
Invoiced amount = Quantity x Monthly pole day discounted unit price × Number of days billed ... Formula (4)
The monthly polar day discount unit price in the equation (4) is calculated by the following equation (5).
Monthly pole day discount unit price = monthly pole unit price ÷ day division division mother day (setting value: 30 days) ... Formula (5)
Here, the day division denominator number in the equation (5) is a numerical value appropriately set by the operator as a reference value of the number of days included in one month, and is set to “30 days” in this embodiment.
In addition, a monthly unit price limiter is set for the monthly polar day discount. The monthly unit price limiter is, for example, such a rule that the monthly unit price is used as the billed amount when the value of the billed amount calculated by the above equation (4) is larger than the monthly unit price.
The number of days billed in equation (4) is determined by the following equation (6).
Number of days for billing = day of start to day of end date ... Formula (6)
The start date and the end date in the above equation (6) are the same as the above-mentioned daily pole, but in the monthly polar date distribution, there is no setting of a day off like the daily pole.

(Contract classification: about period)
A term is a type of rental sales transaction, and is a contract form in which a billed amount of a loaned product is collectively billed with an amount (term unit price) applied to the entire rental contract term. In this contract form, for example, the billing amount calculated by the following equation (7) is charged at the first billing, and billing processing is not performed as “billed” on the subsequent billing closing date.
Invoiced amount = Quantity x Period unit price ... Formula (7)
In addition, although it is not used by said Formula (7), the start date and completion date of this contract form are the same as the above-mentioned daily polar and monthly polar day discount. Furthermore, although it is not used by said Formula (7), the billing days of this contract form are the days of a start date-the end date.

(2) July 10, 2017: On-the-day bulletin, end-of-month forecast When the output of the on-the-day bulletin is instructed via the input device 150, the on-the-spot bulletin calculation unit 113 It is generated and stored in the preliminary sales data storage unit 123 on the day. Further, the breaking news calculation unit 113 calculates a first estimated sales amount obtained by totaling the billing amount included in the breaking sales data on that day, and stores the first estimated sales amount in the breaking sales data storage unit 123 on the day.

  Further, when the output of the end of month prediction is instructed via the input device 150, the prediction calculation unit 114 generates the end of month predicted sales data based on the goods leaving data and the warehousing data, and stores it in the end of month predicted sales data storage unit 124. . Further, the prediction calculation unit 114 calculates a second estimated sales amount obtained by totaling the billing amounts included in the predicted sales data at the end of the month, and stores the second estimated sales amount in the predicted sales data storage unit 124 at the end of the month.

As of July 10, 2017, since none of the products have been returned for lending (not received), the preliminary calculation unit 113 and the prediction calculation unit 114 are based on the delivery data and the day's preliminary sales data and Generate end-of-month forecast sales data.
FIG. 4 is a diagram showing an example of the day's breaking sales data and the end of month forecast sales data generated based on the goods leaving data of FIG. 3.

  Daily sales data and forecasted sales data at the end of the month are: rental slip number and line number, billing date, customer code, customer name, product code, product name, quantity, contract category, start date, end date, days off, days Items such as number of days), unit price, amount (billing amount), issue document number and line number, receipt document number and line number, etc.

  The rental slip number is a number common to the items handled in one process. The line numbers are different for each item handled in one process. The rental slip number and the line number are assigned based on the delivery slip number and the line number registered in the delivery data. Further, the contents registered in the delivery data are taken over for the customer code, the customer name, the product code, the product name, the quantity, the contract classification, the quantity, the start date and the unit price.

The billing date means the date on which the billing amount is billed. Also, the start date and the end date mean the start date and the end date of the lending contract based on the billing date.
The bulletin calculation unit 113 sets a processing date (July 10, 2017) on the billing date. Further, as of the processing date (July 10, 2017), none of the products has reached the scheduled end date (refer to the delivery data), so the alert calculation unit 113 sets the date of the processing date on the end date. Furthermore, there is no bill closing date (20th of every month) between the beginning of the month and the processing date (July 10, 2017), and there is an issue date (July 7, 2017). 113 sets the delivery date (July 7, 2017) on the start date.

  The number of rest days is the number of rest days included between the start date and the end date. As described above, the rest days can be set for each pole, and in July 2017, 9, 16, 23 and 30 days are set. The suspension dates of the loan products A and B of Japan are included one day between the start date (July 7, 2017) and the end date (July 7, 2017). Therefore, the bulletin calculation unit 113 sets “1” as the number of days for which the loaned items A and B are inactive.

  The billing days (item: days) is the number of days from the start date to the end date. The bulletin calculation unit 113 sets the number of days until July 7 to 10 for the loaned items C to E, “4”. In addition, for the loaned items A and B, the bulletin calculation unit 113 sets “3” obtained by subtracting the number of days of rest “1” from the number of days “4” until July 7 to 10 of the loaned items.

The billed amount (item: amount of money) means the amount charged as compensation from the start date to the end date. Based on the contract classification, unit price, number of days, etc., the preliminary calculation unit 113 calculates the billed amount for the start date to the end date for each loaned product, and sets it in the corresponding bill column. Note that the preliminary calculation unit 113 regards the contract category as a monthly polar day discount and calculates the billed amount as a monthly polar day relative price for a loan item whose contract category is “monthly pole”. For example, with respect to the monthly loaned item C, the flash reporting unit 113 considers the contract category as the monthly installment and calculates the billed amount.
Further, the bulletin calculation unit 113 sets the total value of the billed amount calculated for each loaned product in the total column and the bulletin column. The aggregate value is a preliminary value (an example of a first estimated sales amount) as of the processing date.

  The prediction calculation unit 114 performs the same processing as the flash calculation unit 113 to calculate a preliminary value when the billing date is at the end of the month (July 31, 2017) as a prediction value. Specifically, the prediction calculation unit 114 sets the end of the date of billing (July 31, 2017). Further, the prediction calculation unit 114 sets the scheduled end date of the delivery data for the product scheduled to be returned before the end of the month to the end date of the forecast sales data for the end of the month, and sets the end date for the other products at the end of the month. The prediction calculation unit 114 sets the leaving date on the start date as in the case of the preliminary calculation unit 113.

The prediction calculation unit 114 regards the contract category as monthly polar installment for the monthly loan product C, and calculates the billed amount as the monthly polar day deployable unit price.
In addition, the prediction calculation unit 114 sets a total value obtained by totaling the charge amounts of all the loaned items A to E in the total column and the bulletin column. This tabulated value is the preliminary value for the end of month forecast (an example of the second estimated sales amount).

(3) Goods receipt: July 18, 2017: Goods receipt Here, the goods E for lending that were scheduled to be received on the 18th and the goods A for loan that were scheduled to be received on the 20th were received on 18th (that is, the goods for lending A). Let's take as an example the case where goods are received earlier than scheduled.
When the warehousing data is input through the input device 150, the warehousing recording unit 112 stores the received warehousing data in the warehousing data storage unit 122 (warehousing process).

FIG. 5 is a diagram showing an example of storage data. Goods receipt data includes items such as receipt document number and line number, receipt date, customer code, customer name, article code, article name, quantity, contract category, start date, end date, issue document number and line number, etc. There is. Here, the customer code, the customer name, the product code, the product name, the quantity, the contract category and the start date are taken over from the delivery data (see FIG. 3) corresponding to the delivery slip number and the line number.
The receipt recording unit 112 sets the receipt processing date (July 18, 2017) as the receipt date and the end date.

(4) July 20, 2017; billing closing date, billing determination On the billing closing date, the content to be billed to the customer is determined (charging determination).
When the output of the fixed billing amount is instructed via the input device 150, the billing calculation unit 115 generates fixed data based on the leaving data and the warehousing data, and stores the generated data in the fixed data storage unit 126a.
Further, the billing calculation unit 115 calculates a fixed billing amount obtained by aggregating the billing amount included in the fixed data, and stores the calculated billing amount in the fixed data storage unit 126a in association with the fixed data.

  In addition, although all of the loaned items A to E are issued on or after July 1, 2017, temporarily, the products being loaned continuously from at least one of June 21 to 30, 2017 to July If there is any, the fixed data also includes the consideration for June.

  FIG. 6 is a diagram showing an example of finalized data and sales details. The fixed data includes rental slip number and line number, billing date, customer code, customer name, product code, product name, quantity, contract category, start date, end date, number of days left (days billed), unit price, amount It includes such items as invoiced amount), issue slip number and line number, receipt slip number and line number, and the like.

  The rental slip number is a number common to the items handled in one process. The line numbers are different for each item handled in one process. The rental slip number and the line number are assigned based on the delivery slip number and the line number registered in the delivery data. Further, the contents registered in the delivery data are taken over for the customer code, the customer name, the product code, the product name, the quantity, the contract classification, the quantity, the start date and the unit price.

  The sales item is sales number and line number, sales date, customer code, customer name, product code, product name, quantity, contract classification, start date, end date, number of days (days to be billed), unit price, amount (billing It includes such items as amount of money, issue document number and line number, receipt document number and line number, rental document number and line number, and the like.

  The sales number is a number common to the items handled in one process. The line numbers are different for each item handled in one process. The sales number and the line number are assigned based on the delivery slip number and the line number registered in the delivery data. Further, the contents registered in the delivery data are taken over for the customer code, the customer name, the product code, the product name, the quantity, the contract category, the quantity and the unit price.

  The billing calculation unit 115 sets the billing closing date as the billing date and the sales date.

  In addition, if the delivery date is after the day after the closing date of the previous month, the billing calculation unit 115 sets the delivery date to the start date, and if the delivery date is before the closing date of the previous month, the closing date of the previous month Set the next day to the start date.

  Further, the billing calculation unit 115 sets the warehousing date for the loaned goods A and E that have received the goods, and sets the billing closing date for the lent goods B and D that has not received the goods, on the end date. Since the loaned item C which has not been received is a monthly pole, the billing calculation unit 115 sets the previous day of the same day following the start date to the end date.

Since the suspension date of loanable items A and B of Japan is included between the start date and the end date, 2 days (9/16 of July 9, 16, 23 and 30 2017) The calculation unit 115 sets “2” as the number of days for which the loanable items A and B are closed.
The billing calculation unit 115 sets, as the number of billing days (item: days), a value obtained by subtracting the number of rest days from the number of days from the start date to the end date.

  Further, the charge calculation unit 115 calculates the charge amount (item: amount) of each record, totals the charge amount, calculates the fixed charge amount, and sets the fixed charge amount in the total column and the fixed column.

(5) July 24, 2017: On-the-day bulletin, end-of-the-month prediction When the output of the on-the-day bulletin is instructed via the input device 150, the bulletin calculation unit 113 determines that as of July 10, 2017 in (2) above. By performing the same processing, quick sales data on the day is generated. In addition, when the output of the end of month prediction is instructed via the input device 150, the prediction calculation unit 114 performs the same process as that of July 10, 2017 in the above (2) to obtain the end of month forecast sales data. Generate

  In addition, since the loaned items A and E have been returned (received) before July 20, 2017, which is the closing date for billing, as of July 24, 2017, the preliminary calculation unit 113 and the prediction calculation unit 114 On the basis of the delivery data, for the loaned items B to D excluding the loaned items A and E, the on-the-day preliminary sales data and the estimated end-of-month sales data are generated.

  FIG. 7 is a view showing another example of the day-to-day preliminary sales data and the end-of-month forecast sales data. The breaking news calculation unit 113 and the prediction calculation unit 114 handle records of the product being loaned. Goods which have not been received as of this processing date are loaned goods B to D.

The bulletin calculation unit 113 sets a processing date (July 24, 2017) on the billing date. In addition, as of the processing date (July 24, 2017), since the loaned items B to E have not reached the scheduled end date (refer to delivery data), the bulletin calculation unit 113 sets the current date of the processing date. Do.
Furthermore, since the billing calculation date (20th of every month) exists between the beginning of the month and the processing date (July 24, 2017), the preliminary calculation part 113, the loaned item B of Japan and the loaned item of the monthly allowance On the start date of D, set the day after the closing date of this month (July 21, 2017).
In addition, since the preliminary calculation part 113 has completed the billing until the scheduled closing date (August 6, 2017, refer to the delivery data) for the monthly loaned item C, it will be scheduled to finish on the start date. Set the day after the day (August 7, 2017). As a result, for the loaned item C, since the start date is a date later than the end date, the bulletin calculation unit 113 sets the number of days to be billed (item: days) to the number of days from the start date to the end date (negative value) , Here, "-13" is set.
Then, the breaking news calculation unit 113 appropriately sets the number of billing days and the unit price, calculates the billing amount, tabulates the billing amounts of the loaned items B to D, and releases the breaking rate as of the processing date (first estimated sales amount Example).

The prediction calculation unit 114 performs the same processing as the flash calculation unit 113 to calculate a preliminary value when the billing date is at the end of the month (July 31, 2017) as a prediction value.
Specifically, the prediction calculation unit 114 first sets the end of the billing date to the end of the month (July 31, 2017).
Further, the prediction calculation unit 114 sets the scheduled end date of the delivery data to the end date for products to be returned before the end of the month, and sets the end date to the end date for the other products.
Further, the prediction calculation unit 114 sets the day after the closing date of the billing date of the current month (July 21, 2017), as in the case of the preliminary calculation unit 113, on the start date of the loaned item B of Japan and the loaned item D of the monthly allowance. Do.
Further, the prediction calculation unit 114 sets the next day (August 7, 2017) of the scheduled end date to the start date of the loaned item C, similarly to the preliminary calculation unit 113. As a result, for the loaned item C, since the start date is a future date than the end date, the prediction calculation unit 114 sets the number of days for billing (item: days) to the number of days from the start date to the end date (negative value) , Here set "-6").

  Then, the forecasting calculation unit 114 appropriately sets the billing days and the unit price, calculates the billing amount, tabulates the billing amounts of the loaned items B to D, and obtains the preliminary value of the end of month forecast (the second estimated sales amount). An example)

(6) Goods Receipt: July 25, 2017 Here, it is assumed that the loaned item B, which was scheduled to be received on the 25th, is received on the 25th as scheduled. When the warehousing data is input through the input device 150, the warehousing recording unit 112 stores the received warehousing data in the warehousing data storage unit 122 (warehousing process).

  FIG. 8 is a diagram showing another example of the warehousing data. The receipt recording unit 112 sets the receipt processing date (July 25, 2017) as the receipt date and the end date.

(7) At the end of July 31, 2017: At the end of the year, the company's closing date The company's sales will be the sum of the sales amount and the final billed amount for the current month (fixed amount). Forehead In addition, the deemed sales amount does not request details (goods B to D) of goods (loan goods B to D) which are on loan (no receipt data registered) as of their own closing date (July 31, 2017). Calculated based on the statement.

  When the output of the deemed sales amount is instructed via the input device 150, the considered sales calculation unit 116 generates deemed sales data based on the goods issue data and the warehousing data, and stores it in the considered sales data storage unit 125, The current month black data and the next month red data are generated and stored in the respective storage units 126b and 126c.

  FIG. 9 is a diagram illustrating an example of deemed sales data and data of deemed portions of sales specifications (black data in the current month and red data in the next month). The deemed sales data includes the same items as the fixed data shown in FIG. The sales statement (assumed portion) includes the same items as the sales statement shown in FIG. The top three lines of the sales statement (assumed) are black data for the current month, and the bottom three lines are red data for the next month.

The assumed sales calculation unit 116 sets the end date of the estimated sales data billing date. In addition, the deemed sales calculation unit 116 sets the start date of the Japanese loan item B and the monthly fixed date loan item D on the day following the closing date of the claim (July 21, 2017).
In addition, since the deemed sales calculation unit 116 has completed billing for the monthly loan item C, the billing date is due until the scheduled closing date (August 6, 2017, refer to the delivery data), so the termination date will be closed. Set the day after the scheduled date (August 7, 2017). As a result, for the loaned item C, since the start date is later than the end date, the considered sales calculation unit 116 sets the number of days for billing (item: days) to the number of days from the start date to the end date (negative Set the value, here "-6").

In addition, the deemed-sales calculation unit 116 sets the warehousing date (refer to the warehousing data) as the end date for the loaned item B that has been lent out between the end of the month and the day after the closing date of the billing date. Further, the deemed-sales calculation unit 116 sets the end date for the end date of the loan products C and D which are in the ongoing loan status at the end of the month.
In addition, the deemed sales calculation unit 116 sets the number of days of pause included in the start date to the end date as the number of pause days, and subtracts the number of days of pause from the number of days of start date to end date on the number of billing days (item: days). Set the number of days
In addition, the deemed sales calculation unit 116 considers the monthly pole as a monthly pole and sets the unit price, calculates the billed amount, and totals the billed amount of each item.

The deemed sales calculation unit 116 generates current month black data based on the deemed sales data. The sales date of the current black data is the same as the billing date of the deemed sales data. Other items have the same contents as deemed sales data.
Also, the considered sales calculation unit 116 generates next month red data corresponding to the current month black data. The sales date of the next month red data is the next day of the current month black data (that is, the beginning of the next month). In addition, the quantity and the amount of the red data of the next day are values obtained by reversing the positive and negative of the amount and the amount of the black data of the present month. The other items are the same as the current month black data.

  In addition, the control part 110 calculates the total value (fixed amount) of the billed amount corresponding to the statement for the current month among the fixed data as the sales accruing means, and sums it with the aggregated value of the billed amount of the present black data. It is possible to calculate the sales amount including the deemed portion. In addition, when calculating the fixed amount, the control unit 110 sums up the red data (red data for July) generated by the sales calculation unit 116 in the previous month (June) and the amount obtained by totaling the fixed data of the current month (fixed By adding to the billed amount), the fixed amount of the current month is calculated.

As described above, according to the present embodiment, even if the closing date of the billed party (debtor) and the closing date of the claimant (creditor) are different, the claimant can accurately grasp the sales amount. Can.
Further, according to the present embodiment, it is possible to obtain a preliminary forecast value of sales forecast from the beginning of the month to the present day.
Then, according to this embodiment, it is possible to obtain a sales forecast on the day from the beginning of the month to the end of the month.

[4. Other embodiments]
The present invention may be practiced in various different embodiments within the scope of the technical idea described in the claims in addition to the embodiments described above.

  For example, among the processes described in the embodiment, all or part of the process described as being automatically performed may be manually performed, or all the processes described as being manually performed. Alternatively, some of them can be performed automatically by known methods.

  In addition, information including processing procedures, control procedures, specific names, registered data of each processing, parameters such as search conditions, screen examples, and database configurations shown in the present specification and the drawings are described unless otherwise specified. Can be changed arbitrarily.

  Further, regarding the sales accrual processing device 100, each component in the drawing is functionally conceptual, and does not necessarily have to be physically configured as illustrated.

  For example, all or any part of the processing functions of the sales accounting processing device 100, in particular each processing function performed by the control unit 110, are realized by a CPU and a program executed by the CPU. It may be realized as hardware by wired logic. The program is recorded in a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the processing described in the present embodiment, and the sales accrual processing may be performed as necessary. The device 100 is mechanically read. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). The computer program is executed by being loaded into the RAM, and cooperates with the CPU to configure the control unit.

  Also, this computer program may be stored in an application program server connected to sales accounting processing apparatus 100 via any network, and it is possible to download all or a part of it as needed. It is.

  Furthermore, the program for executing the processing 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" means a memory card, a universal serial bus (USB) memory, a secure digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an erasable programmable read only memory (EPROM), and an EEPROM (registration). Trademarks (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Blu-ray (registered trademark) Disc etc. Any "portable physical media It is intended to include. Therefore, a recording medium storing a program for executing the processing or the processing method as described in the present specification also constitutes the present invention.

  The “program” is a data processing method described in any language or description method, and may be in any format such as source code or binary code. Note that the “program” is not necessarily limited to one that is configured in a single way, and achieves its function in cooperation with a separate program represented by a plurality of modules or libraries or a separate program represented by the OS. Including things. In addition, as 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, a known configuration and procedure can be used.

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

  Further, the sales account recording processing apparatus 100 may be configured as an information processing apparatus such as a known personal computer or a work station, or may be configured as the information processing apparatus to which any peripheral device is connected. In addition, the sales accounting processing device 100 may be realized by implementing software (including a program or data, etc.) that causes the device to realize the processing described in the present embodiment.

  Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them may be functionally or physically in any unit in accordance with various additions or according to functional load. It can be distributed and integrated. That is, the embodiments described above may be implemented in any combination, and the embodiments may be implemented selectively.

  The present invention is useful in a business condition in which a service provider bills a service recipient on a predetermined closing date, particularly in the rental industry.

100 ... sales accounting processing unit 110 ... control unit 111 ... delivery recording unit 112 ... warehousing recording unit 113 ... preliminary calculation unit 114 ... prediction calculation unit 115 ... claim calculation unit 116 ... considered sales calculation unit 120 ... storage unit 121 ... delivery data storage Unit 122 ... warehousing data storage unit 123 ... present day preliminary sales data storage unit 124 ... end of the month forecast sales data storage unit 125 ... considered sales data storage unit 126 ... sales statement storage unit 126a ... confirmed data storage unit 126b ... this month black data storage unit 126c ... next month red data storage unit 130 ... communication interface unit 140 ... input / output interface unit 150 ... input device 160 ... output device 200 ... server 300 ... network

Claims (5)

A sales accounting apparatus comprising a control unit and a storage unit, wherein
The storage unit stores a statement in which the content of the service provided to the customer is recorded, and a billing reference date for charging the customer for the service,
The control unit
If the closing date of the period for recording sales differs from the billing reference date, the consideration from the first day of the period to the billing base date in the period, and the next day of the billing reference date to the closing date of the period A sales accrual processing apparatus comprising: a sales accrual means for accommodating the sum of the above-mentioned consideration and the sum as a sales amount for the period. The control unit
From the first day of the period to the treatment date if the treatment date is earlier than the billing reference date, or from the next day of the billing reference date to the treatment date if the treatment date is later than the billing reference date 2. The sales accounting apparatus according to claim 1, further comprising: a bulletin calculation unit for obtaining a first estimated sales amount corresponding to the consideration of. The control unit
From the first day of the period to the closing date if the processing date is earlier than the billing reference date, or from the next day of the billing reference date to the closing date if the processing date is later than the billing reference date 3. The sales accounting processing device according to claim 1, further comprising a prediction calculation unit for obtaining a second estimated sales amount corresponding to the consideration of. Sales accounting processing method to be executed by an information processing apparatus including a control unit, a statement recording the contents of a service provided to a customer, and a storage unit storing a billing reference date for charging the customer for the service And
Executed by the controller
If the closing date of the period for recording sales differs from the billing reference date, the consideration from the first day of the period to the billing base date in the period, and the next day of the billing reference date to the closing date of the period A sales accounting step including a sales accounting step for accounting the sum of the above-mentioned consideration and the amount as sales for the period. Sales accounting processing to be performed by an information processing apparatus provided with a control unit, a statement that records the content of a service provided to a customer, and a storage unit that stores a billing reference date for charging the customer for the service A program,
For the control unit to execute
If the closing date of the period for recording sales differs from the billing reference date, the consideration from the first day of the period to the billing base date in the period, and the next day of the billing reference date to the closing date of the period A sales accounting processing program including a sales accounting step for accounting the sum of the above-mentioned consideration and the amount as sales for the period.

Images