JP6974055B2 - Data collection equipment, data collection methods and data collection programs - Google Patents

Description

The present invention relates to a data collection device, a data collection method and a data collection program.

In Patent Document 1, the parent company prepares consolidated settlement data under the new accounting standard while avoiding double entry under the old accounting standard and the new accounting standard when the accounting staff of the subsidiary inputs the data. , The accounting standard transition system that assists the accounting staff of the subsidiary to easily grasp the data of the result of the change to the new accounting standard is disclosed (see paragraph 0008, etc.).

Japanese Unexamined Patent Publication No. 2014-89653

In such an accounting management field, there may be a time lag between companies within a group company. Delayed means that the accounting period differs between companies. For example, if the closing date of the first company (subsidiary) is December, while the closing date of the second company (parent company) is March (that is, the closing date of the subsidiary is 3 months). If it is early) etc.

In this case, in order to compare the sales amount and the like of a predetermined period between the subsidiary and the parent company, it is indispensable to link and set the predetermined period of both companies by the master. For example, if you set in advance to link January of the subsidiary and April of the parent company, "Sales amount of 10,000 yen" will be based on the collected data of "January sales amount of 10,000 yen of the subsidiary". The yen is the sales amount corresponding to April in the parent company. " As a result, the sales amount can be compared based on April of the parent company. Specifically, assuming that the sales amount of the parent company in April is 20,000 yen, "The sales amount of the subsidiary is 10,000 yen based on April of the parent company, while the sales amount of the parent company is 10,000 yen. Is 20,000 yen. "

However, the setting to link the months of both companies is necessary not only for January and April explained in the above example, but also for all other months, so there is a problem that the operational load is very high. there were. In particular, when the number of companies is large, the amount of association settings is also large, so this problem was remarkable.

The present invention has been made in view of the above, and even if the period of the first company and the period of the second company are not set in advance, the sales amount of the first company for a certain period, etc. Provided are a data collection device, a data collection method, and a data collection program capable of converting data into a sales amount of the second company corresponding to the certain period and collecting the data.

In order to solve the above-mentioned problems and achieve the object, the data collecting device according to the present invention is a data collecting device including a control unit and a storage unit, and the storage unit is a settlement of accounts for the first company. About the first master including the number of periods, the monthly number within the accounting period, the accounting period corresponding to the combination of the period and the monthly number, and the accounting date corresponding to the combination, and the first company. The collection target item and the collection target data including the occurrence date of the collection target item are stored, the control unit includes the same month collection means or the elapsed month collection means, and the same month collection means By referring to the first master, acquiring the accounting period to which the occurrence date belongs, and acquiring the accounting year and month associated with the acquired accounting period, the accounting year and month for the first company and the above The collection result data including the collection target item included in the collection target data associated with the occurrence date is created, and the elapsed month collection means uses the occurrence date, the number of periods included in the first master, and the monthly number. And the period included in the second master, including the accounting period, the number of accounting periods for the second company, the monthly number within the accounting period, the accounting period, and the accounting year and month corresponding to the combination of the accounting period and the accounting period. By acquiring the accounting date included in the second master based on the number and the monthly number, it is included in the accounting date for the second company and the collection target data associated with the occurrence date. It is characterized by creating collection result data including the collection target items to be collected.

Further, in the data collecting device according to the present invention, the control unit includes the same month collecting means and the elapsed month collecting means, and further, the collection result data created by the same month collecting means is designated as a reference destination. If, the collection target item associated with the specified accounting year and month is extracted by referring to the collection result data, and if the collection result data created by the elapsed month collection means is specified as the reference destination, the relevant collection result data is specified. It is characterized in that it is provided with an extraction means for extracting collection target items associated with a specified accounting date by referring to collection result data.

Further, in the data collecting device according to the present invention, in the storage unit, the company identification information of the first company and the accounting date of the second company are set in the accounting date of the first company. After the classification that is the classification when linking with the accounting date of the above, and the classification when the accounting date of the second company is linked to the accounting date of the first company after the accounting date. The division master including the division and any one of the same divisions, which is the division when the accounting date of the second company is associated with the accounting date of the same first company as the accounting date. Further stored, when the division in the division master is the destination division, the elapsed month collecting means refers to the first master to acquire the accounting period to which the occurrence date belongs, and the acquisition. The maximum number of periods associated with the number of periods and monthly number associated with the accounting period, and the number of periods acquired by the means for acquiring the number of periods, etc. with reference to the first master. With reference to the destination-first maximum monthly acquisition means for acquiring the monthly number and the first master, the number of periods acquired by the previous-period number acquisition means and the destination-first maximum monthly acquisition means acquired. The destination-number acquisition means for acquiring the accounting year and month associated with the maximum monthly number, and further, referring to the second master, and acquiring the number of periods associated with the acquired accounting date, and the second master. With reference to the master, the destination-second maximum monthly acquisition means for acquiring the maximum monthly number associated with the period acquired by the previous-period acquisition means and the destination-first maximum monthly acquisition means acquired. It is determined that the destination-determining means for determining whether or not the maximum monthly number and the maximum monthly number acquired by the destination-second maximum monthly acquisition means are the same, and the destination-determining means are the same. If so, refer to the second master and acquire the accounting year and month associated with the number of periods acquired by the previous-period acquisition means and the month number acquired by the previous-period acquisition means. It is characterized by further providing a month acquisition means.

Further, in the data collecting device according to the present invention, in the storage unit, the company identification information of the first company and the accounting date of the second company are set in the accounting date of the first company. After the classification that is the classification when linking with the accounting date of the above, and the classification when the accounting date of the second company is linked to the accounting date of the first company after the accounting date. The division master including the division and any one of the same divisions, which is the division when the accounting date of the second company is associated with the accounting date of the same first company as the accounting date. Further stored, when the division in the division master is the latter division, the elapsed month collecting means refers to the first master to acquire the accounting period to which the occurrence date belongs, and the acquisition. The maximum number of periods associated with the latter-period number acquisition means for acquiring the period number and monthly number associated with the accounting period, and the number of periods acquired by the latter-period number acquisition means with reference to the first master. After acquiring the monthly number-after acquiring the first maximum monthly number acquisition means and the minimum monthly number associated with the period acquired by the latter-term number acquisition means with reference to the first master-minimum With reference to the monthly acquisition means and the first master, the accounting year and month associated with the number of periods acquired by the latter-term number acquisition means and the minimum monthly number acquired by the latter-minimum monthly acquisition means are acquired. Further, with reference to the second master, the latter-term number acquisition means for acquiring the number of periods associated with the acquired accounting year and month, and with reference to the second master, the latter-period number acquisition. After-second maximum monthly acquisition means to acquire the maximum monthly number associated with the number of periods acquired by means, and the maximum monthly number acquired by the above-first maximum monthly acquisition means and the after-second maximum monthly number. When it is determined that the post-determination means for determining whether or not the maximum monthly number acquired by the acquisition means is the same and the post-determination means are the same, the second master is referred to. It is characterized by further providing a post-year / month acquisition means for acquiring the accounting year and month associated with the period number acquired by the latter-term number acquisition means and the month number acquired by the latter-term number acquisition means. And.

Further, in the data collecting device according to the present invention, in the storage unit, the company identification information of the first company and the accounting date of the second company are set in the accounting date of the first company. After the classification that is the classification when linking with the accounting date of the above, and the classification when the accounting date of the second company is linked to the accounting date of the first company after the accounting date. The division master including the division and any one of the same divisions, which is the division when the accounting date of the second company is associated with the accounting date of the same first company as the accounting date. Further stored, when the division in the division master is the same division, the elapsed month collecting means refers to the first master to acquire the accounting period to which the occurrence date belongs, and the acquisition. Same accounting year as the same-first year and month acquisition means to acquire the accounting year and month associated with the same accounting period and the same-first year and month acquisition means with reference to the second master. It is characterized by further providing the same-second year month acquisition means for acquiring the month.

Further, in the data collecting device according to the present invention, the storage unit contains the period number and the monthly number for the first company, and the period number and the monthly number for the second company. The associated master including is further stored, and the elapsed month collection means refers to the first master to acquire the accounting period to which the occurrence date belongs and associates it with the acquired accounting period. The first company acquired by the string-first period acquisition means for acquiring the period number and monthly number of the company and the string-first period acquisition means with reference to the association master. The string-the string for acquiring the period number and the monthly number for the second company, which is associated with the period number and the monthly number of the second company, and the string-the second master with reference to the second master. It is characterized by further providing a string-year / month acquisition means for acquiring the accounting year / month associated with the number of periods acquired by the acquisition means such as the number of periods and the monthly number.

Further, in the data collecting device according to the present invention, the control unit refers to the first master to acquire the accounting period to which the occurrence date belongs, and acquires the accounting period associated with the acquired accounting period. It is characterized by further providing means for acquiring month-year.

Further, the data collection device according to the present invention is characterized in that the first company is a subsidiary within the group company and the second company is a parent company within the group company.

Further, the data collection device according to the present invention is characterized in that the data to be collected is journal detail data, the item to be collected is an amount of money, and the date of occurrence is the date of occurrence of the amount of money. do.

Further, the data collection method according to the present invention is a data collection method executed by an information processing apparatus including a control unit and a storage unit, and the storage unit includes the number of accounting periods for the first company. The first master including the monthly number within the accounting period, the number of periods, the accounting period corresponding to the combination of the monthly numbers, and the accounting year and month corresponding to the combination, and the items to be collected for the first company. The collection target data including the occurrence date of the collection target item and the collection target data including the same month collection step or the elapsed month collection step executed by the control unit are included, and the same month collection step is the first. (I) With reference to the master, by acquiring the accounting period to which the occurrence date belongs and the accounting date associated with the acquired accounting period, the accounting date and the occurrence date for the first company are obtained. The collection result data including the collection target items included in the collection target data associated with the above is created, and the elapsed month collection step includes the occurrence date and the period number, monthly number and accounting included in the first master. The number of periods included in the second master, including the period, the number of period periods for the second company, the month number within the period, the period number, and the accounting year and month corresponding to the combination of the period number and the month number. By acquiring the accounting date included in the second master based on the monthly number, the collection included in the accounting year and month for the second company and the collection target data associated with the occurrence date. It is characterized by creating collection result data including target items.

Further, the data collection program according to the present invention is a data collection program for being executed by an information processing apparatus including a control unit and a storage unit, and the storage unit includes the number of accounting periods for the first company. The first master including the month number in the accounting period, the number of periods, the accounting period corresponding to the combination of the period number, and the accounting year and month corresponding to the combination, and the items to be collected for the first company. And the collection target data including the occurrence date of the collection target item, and includes the same month collection step or the elapsed month collection step for the control unit to execute, and the same month collection step is By referring to the first master, acquiring the accounting period to which the occurrence date belongs, and acquiring the accounting year and month associated with the acquired accounting period, the accounting year and month for the first company and the above The collection result data including the collection target item included in the collection target data associated with the occurrence date is created, and the elapsed month collection step includes the occurrence date, the number of periods included in the first master, and the monthly number. And the period included in the second master, including the accounting period, the number of accounting periods for the second company, the monthly number within the accounting period, the accounting period, and the accounting year and month corresponding to the combination of the accounting period and the accounting period. By acquiring the accounting date included in the second master based on the number and the monthly number, it is included in the accounting date for the second company and the collection target data associated with the occurrence date. It is characterized by creating collection result data including the collection target items to be collected.

According to the present invention, data such as the sales amount of a certain period in the first company corresponds to the certain period without setting the period of the first company and the period of the second company in advance. It has the effect of being able to collect data by converting it as the sales amount for the period of the second company.

FIG. 1 is a block diagram showing an example of the configuration of a data acquisition device. FIG. 2 is a diagram showing companies A, B (with a month lag) and company C (with a time lag) within the group companies. FIG. 3 is a diagram showing an example of data composition in the accounting period master. FIG. 4 is a diagram showing an example of data composition in the monthly period master. FIG. 5 is an image diagram showing a mode of time lag between company A and company C. FIG. 6 is a diagram showing an example of data configuration in the monthly period master. FIG. 7 is a diagram showing an example of data configuration in the association master. FIG. 8 is a diagram showing an example of a flow when creating collection result data (group collection result data) from collection target data (journal detail data) for companies A and B having a monthly deviation. FIG. 9 is an image diagram showing the mode of the time lag between Company G and Company C before and after the change of the settlement period. FIG. 10 is a diagram showing an example of setting of the association master after the accounting period is changed. FIG. 11 is a diagram showing an example of collection target data (journal detail data) and collection result data (group collection result data). FIG. 12 is an image diagram showing a mode of time lag between Company G and Company C. FIG. 13 is a diagram showing an example of data configuration in the company master. FIG. 14 is a diagram showing an example of the flow of data collection processing. FIG. 15 is a diagram showing an example of data collection processing when there is a setting of the association master. FIG. 16 is a diagram showing an example of data collection processing when the association method in the company master is “always the same”. FIG. 17 is a diagram showing an example of data collection processing when the association method in the company master is “first”. FIG. 18 is a diagram showing an example of data collection processing when the associative method in the company master is “after”. FIG. 19 is a diagram showing an example of data extracted according to a designated form output condition with reference to the collection result data (group collection result data). FIG. 20 is a diagram showing the first example of comparison between the period of company G, which is the target of form output, and the period of company C, which is the target of form output. FIG. 21 is a diagram showing a second example of comparison between the period of company G, which is the target of form output, and the period of company C, which is the target of form output. FIG. 22 is a diagram showing a third example of comparison between the period of company G, which is the target of form output, and the period of company C, which is the target of form output.

Hereinafter, embodiments of a data collection device, a data collection method, and a data collection program according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to this embodiment.

[1. Overview]
(1) Differences in the timing of monthly closing in accounting (monthly deviation) The timing of monthly closing in accounting often differs from company to company due to differences in industry business practices, busy seasons, salary closing, etc., for example. There are month-end closing, 15th closing, 20th closing, etc. In particular, the timing of monthly closing is different between companies within a consolidated group company that is a complex of multiple industries and multiple business formats, that is, there is often a monthly shift.

In this way, when the timing of monthly closing differs between the companies in the group companies, there have been the following problems in the past. That is, when conducting an accounting analysis of the entire group company, it was not possible to automatically determine which month of the group company the corresponding month of each company corresponds to. Specifically, when there is a company A with no moon shift and a company B with a moon shift based on the company G in the group company (company G), as shown in FIG. 6, 2016 of the company B Whether the period from / 04/21 to 2016/05/20 corresponds to the period from 2016/04/01 to 2016/04/30 of Company A or the period from 2016/05/01 to 2016/05/31. Could not be determined automatically. In other words, as shown in Fig. 6, it automatically determines whether the monthly number 2 of the accounting period 19 of the individual company B corresponds to April or May of the company A, which is a company in the group company. Could not be determined.

Therefore, in this embodiment, even if there is a monthly deviation between companies in the group company, it is necessary for the master to set the association between the individual periods by analyzing using the same “fiscal year”. I tried to disappear. Specifically, the accounting month of "April" is set for the period from 2016/04/01 to 2016/04/30 of company A, while the accounting month of company B is set to 2016/03 / 21-2016 / 04. If the accounting month "April" is set for the period of / 20, by using the accounting month "April", both of the above can be done without having to link the individual periods with each other by the master. It is possible to perform comparative analysis of sales amount, etc. during the period.

(2) Differences in settlement period (difference) The settlement period may also differ between companies within the group companies, as shown in 1 to 4 below.
1. 1. The accounting period is set for each company.
2. 2. In terms of consolidated accounting, there is also a consolidated group accounting period. In this case, it is often the same as the fiscal year end of major companies in the group.
3. 3. Considering the accounting policy of each company, the legal system of the country where the individual company is located, and the advantages of the consolidated schedule of the parent company, the accounting period differs between the companies in the consolidated group, that is, there is often a time lag. ..
4. If there is a discrepancy between the consolidated accounting period (the accounting period of a consolidated group company) and the accounting period of an individual company (the accounting period of an individual company) in consolidated accounting, the following a to c are shown in Japanese accounting standards. Settle the account as follows.
a. If the difference in the settlement period is within 3 months, the settlement period of each company may be used as it is.
b. If the difference in the settlement period is not within 3 months, or even if it is within 3 months, it is necessary to make a provisional settlement according to the settlement period of the consolidated group companies.
c. By deciding which method to select, a (using the accounting period of the individual company) or b (using the accounting period of the group company), which month is linked at the time of data collection (which amount data is used). Whether to collect it as a month's thing) is decided in a general way.

Here, there are a plurality of comparative analysis methods for settlement of accounts between companies, and for example, the comparative analysis methods shown in 1 and 2 below are often used.
1. 1. The first is the same month comparative analysis method. This analysis method is a method of comparing the current (current year and month) sales amount, etc. between companies in order to grasp the latest business situation every month. Specifically, this analysis method compares the same years and months of both companies, as shown by the vertical arrow in FIG. 5, when there is a three-month lag between company A and company C (as shown by the vertical arrow in FIG. 5). The method is to compare the two companies in April 2017).
2. 2. The second is the elapsed month comparison analysis method. This analysis method is a method of comparing the sales amount, etc. according to the settlement period of the parent company at the timing of the annual settlement or the quarterly settlement. This analysis method is in high demand when you want to compare individual companies with the past years (for example, when you want to compare the first quarters of the first half of this term). Specifically, in this analysis method, when there is a three-month lag between company A and company C, as shown by the diagonal arrow in FIG. 5, the elapsed months from the beginning of the period are the same. It is a method of comparing each other (comparing April 2017, which is the first month of the 50th term of Company A, and January 2017, which is the first month of the 20th term of Company C).

As described above, although there is a demand to switch which of the two comparative analysis methods is used depending on the analysis viewpoint, there have been the following problems in the past. That is, regardless of whether the analysis method of the same month comparison analysis method or the elapsed month comparison analysis method is used, as shown in FIG. 7, the master that links all the combinations of the accounting period and the monthly number of the two companies to be compared. Settings are required. In this case, there is a problem that the operational load becomes very high due to the reasons 1 to 4 shown below.
1. 1. Within the group companies, it is necessary to link the accounting period and monthly number even for individual companies that do not have a time lag and a month lag. Therefore, the amount of data required for linking will gradually increase.
2. 2. If the number of individual companies is large, the amount of linking settings will be large. That is, it is necessary to link (number of companies x number of months).
3. 3. If there is a change in the accounting period at each company, the linked data set in advance must be changed.
4. If you want to perform both the same month comparison analysis method and the elapsed month comparison analysis method, it is necessary to prepare both the master for the same month comparison analysis method and the master for the elapsed month comparison analysis method as shown in FIG. ..

Therefore, in the present embodiment, it is possible to automatically link the months of the two companies to be compared (the accounting period and the monthly number of the two companies to be compared). However, if there is a change in the settlement period, it is exceptionally necessary to set the association in advance by the master.

(3) Summary To summarize the above, the conventional problems when there is a monthly shift or a time shift are as follows. That is, conventionally, by associating the "accounting month start date-accounting month end date" of each individual company with the "accounting month start date-accounting month end date" of the group companies by the master, it is possible between the group companies. It corresponded to the month and the period. However, in this case, it is necessary to retain the association data for each company and each month to be added up, and there is a problem that the operational load of the setting is high (especially when the number of companies is large, the operational load is extremely high).

Therefore, in the present embodiment, in the same month comparison analysis method and the elapsed month comparison analysis method, it is possible to automatically determine and realize the association setting instead of setting it in the master in advance. This makes it possible to dynamically switch between the same month comparison analysis method and the elapsed month comparison analysis method regardless of whether or not the provisional settlement is made due to a delay while reducing the operational load of the setting (for the desired analysis method). Data can be extracted quickly). Hereinafter, a specific configuration and operation will be described.

[2. composition]
The configuration of the data collection 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 data acquisition device 100.

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

As shown in FIG. 1, the data acquisition 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 data collection device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the data acquisition 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 data collection device 100 and the server 200 so as to be communicable with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like. The data stored in the storage unit 106, which will be described later, may be stored in the server 200.

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, a keyboard, a mouse, and a microphone, as well as 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 as a display unit, and the input device 112 may be described 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 an instruction 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) / 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 may, for example, include the settlement period master 106a, the monthly period master 106b as the first master and the second master, the association master 106c, the collection target data 106d, and the group collection result data 106e as the collection result data. And the company master 106f as a division master.

In the following, as shown in FIG. 2, the explanation will proceed assuming that the following companies A to C exist in the group companies.
Parent company A company Closed at the beginning of the end of April Subsidiary company B (with a month lag) Beginning of April 20th closing Subsidiary company C (with a lag) Closed at the beginning of the end of January In order to distinguish between the total information of company A alone and the consolidated accounting information that is the sum of the entire group, in the following explanation, when referring to the parent company alone, it is referred to as "company A" and the entire consolidated group (A). When referring to company, company B and company C), it is expressed as "company G". There is neither a time lag nor a month lag between Company G and Company A.

Further, in the present embodiment, the purpose is to compare the sales amount of the first company and the sales amount of the second company, but the first company is a subsidiary within the group company (Company B). Or company C), and the second company is preferably a parent company (company G or company A) within the group company.

The accounting period master 106a is a master for managing the accounting period of each company. As shown in FIG. 3, the accounting period master 106a includes, for example, the number of accounting periods (accounting period), the beginning date, the ending date, and the like. As shown in FIG. 3, Company G, Company A and Company B are at the beginning of April, while Company C is at the beginning of January (there is a time lag).

The monthly period master 106b is a master for managing the monthly closing date of each company's accounting. As shown in FIG. 4, the monthly period master 106b is, for example, accounting corresponding to the number of periods of the accounting period (accounting period), the monthly number within the accounting period (monthly number), the number of periods, and the combination of the monthly number. Includes the period (the period from the start date of the month to the end date of the month) and the fiscal year / month (fiscal month) corresponding to the combination. As shown in FIG. 4, Company G, Company A and Company C are closed at the end of the month, while Company B is closed on the 20th (there is a month lag).

The associating master 106c is a master for associating the periods of the first company and the second company. As shown in FIG. 7, the association master 106c has, for example, company identification information (company) for the first company, the number of periods of the accounting period (accounting period), and the monthly number (monthly number) within the accounting period. And the company identification information (company) about the second company, the number of periods of the accounting period (accounting period), and the monthly number (monthly number) within the accounting period. In FIG. 7, the first company is the company (company A, company B, and company C) shown in the right column of the linking master 106c, and the second company is the left side of the linking master 106c. The company shown in the column (Company G).

The data to be collected 106d is the data to be collected. The type of data to be collected 106d is not particularly limited, and examples thereof include journal detail data, sales order quantity data, sales order amount data, overtime hours data, customer name list data, and person in charge name list data. Will be. When the collection target data 106d is journal detail data, the collection target data 106d includes, for example, an amount as a collection target item, an occurrence date of the amount as an occurrence date of the collection target item, an account item, and the like. The type of the amount is not particularly limited, and examples thereof include a sales amount (shown in FIG. 11), a purchase amount, and a checking deposit amount.

The group collection result data 106e is the data as a result of collecting the collection target data 106d. As shown by MA3 in FIG. 11, the group collection result data 106e includes the company identification information (company C), the fiscal year and month for the first company (company C) (column of the same month comparison year and month of MA3), and the group collection result data 106e. Includes the fiscal year and month (column of the elapsed month comparison year and month of MA3), account items, collection target items (sales amount), etc. for the second company (Company A).

The company master 106f is a master for setting the rules for associating the period of the first company and the second company when the associating master 106c is not set. As shown in FIG. 13, the company master 106f has, for example, the company identification information (company) of the first company and any one of "first category", "second category", and "same category (always the same)". Includes two categories.

The “first classification” is a classification in which the accounting month of the second company is associated with the accounting month of the first company prior to the accounting month. Generally, when analyzing the entire group, it is often the case that the analysis is based on the fiscal year end of the parent company (second company), and the data of the subsidiary (first company) already exists. Is desirable, so this association is most often used. For example, as shown in FIG. 12, the monthly number (1) of the 50th period of the company G is associated with the monthly number (1) of the 20th period of the company C.

The "post-classification" is a classification in which the accounting month of the second company is associated with the accounting month of the first company after the accounting month. For example, as shown in FIG. 12, the monthly number (1) of the 50th period of the company G is associated with the monthly number (1) of the 21st period of the company C.

The "same category (always the same)" is a category in which the accounting month of the second company is associated with the accounting month of the first company, which is the same as the accounting month. For example, as shown in FIG. 12, April 2017 of Company G is associated with April 2017 of Company C.

The control unit 102 is a CPU or the like that collectively controls the data acquisition 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. Run.

Functionally, the control unit 102 obtains, for example, (1) the accounting period to which the occurrence date belongs, and acquires the accounting date associated with the acquired accounting period, referring to (1) the first master. The same month collection unit as the same month collection means for creating collection result data including the accounting date for the first company and the collection target items included in the collection target data associated with the occurrence date. 102a, (2) the date of occurrence, the number of periods, the monthly number and the accounting period included in the first master, the number of accounting periods for the second company, the monthly number within the accounting period and the accounting period. By acquiring the accounting year and month included in the second master based on the number of periods and the month number included in the second master, including the accounting year and month corresponding to the combination of the number and the month number. Elapsed months for creating collection result data including the accounting year and month for the second company, the collection target items included in the collection target data associated with the occurrence date, and the elapsed month collection unit 102b as a collection means. (3) With reference to the first master, the accounting period to which the occurrence date belongs is acquired, and the period number and monthly number for the first company, which is linked to the acquired accounting period, are acquired. The first company acquired by the string-first period number acquisition means with reference to the string-first period number acquisition unit 102b1 as the first period number acquisition means and (4) the linking master. The string for acquiring the period number and monthly number for the second company, which is associated with the period number and monthly number for the second period, and the string as a means for acquiring the second period number, etc. 5) With reference to the second master, the string-the number of periods acquired by the second period acquisition means and the string for acquiring the accounting year and month associated with the monthly number-the string as the year and month acquisition means-year and month. With reference to the acquisition unit 102b3 and (6) the first master, the accounting period to which the occurrence date belongs is acquired, and the accounting date associated with the acquired accounting period is acquired. -With reference to the first year and month acquisition unit 102b4 and (7) the second master, the same-the same accounting year and month acquired by the first year and month acquisition means- Refer to the same-second year acquisition unit 102b5 as the second year acquisition means and (8) the first master to acquire the accounting period to which the occurrence date belongs and link it with the acquired accounting period. With reference to the first-term number acquisition unit 102b6 as the first-term number acquisition means for acquiring the period number and the monthly number, and (9) the first master, the first-term number acquisition means is used. Destination to acquire the maximum monthly number associated with the obtained number of periods-Destination as the first maximum monthly acquisition means-The first maximum monthly acquisition unit 102b7 and (10) The destination-with reference to the first master. Obtain the number of periods acquired by the acquisition means such as the number of periods and the accounting year and month associated with the maximum monthly number acquired by the previous-first maximum monthly acquisition means, and further, refer to the second master to obtain the acquisition. Acquiring the number of periods associated with the accounting year and month Destination to acquire the maximum monthly number associated with the number of periods To determine whether or not the monthly number of the above-the destination-the maximum monthly number acquired by the second maximum monthly acquisition means is the same-the destination as the determination means-the determination unit 102b10 and (13) the destination- When it is determined that the determination means are the same, the number of periods acquired by the previous-period number acquisition means and the monthly number acquired by the previous-period number acquisition means are linked with reference to the second master. By referring to the destination for acquiring the accounting date-the destination as the means for acquiring the year and month-the year and month acquisition unit 102b11, and (14) the first master, the accounting period to which the occurrence date belongs is acquired, and the acquired accounting is performed. Acquiring the latter-period number, etc. by referring to the latter-term number acquisition unit 102b12 as a means for acquiring the period number and the monthly number associated with the period, and (15) the first master. After acquiring the maximum monthly number associated with the number of periods acquired by the means-after as the first maximum monthly acquisition means-with reference to the first maximum monthly acquisition unit 102b13 and (16) the first master, the said After acquiring the minimum monthly number associated with the number of periods acquired by the acquisition means such as the number of periods, after-after as the minimum monthly acquisition means-minimum monthly acquisition unit 102b14, and (17) refer to the first master. , Acquire the accounting year and month associated with the number of periods acquired by the latter-term number acquisition means and the minimum monthly number acquired by the latter-minimum monthly acquisition means, and further refer to the second master. The latter-term number acquisition unit 102b15 as a later-term number acquisition means for acquiring the period number associated with the acquired accounting date, and (18) the latter-term number acquisition means with reference to the second master. After acquiring the maximum monthly number associated with the number of periods acquired in-after as the second maximum monthly acquisition means-second maximum monthly acquisition unit 102b16, and (19) after-acquired by the first maximum monthly acquisition means After determining whether or not the maximum monthly number obtained is the same as the maximum monthly number acquired by the second maximum monthly acquisition means-after as a determination means-determination unit 102b17, (20) said. When it is determined that the latter-determination means are the same, the number of periods acquired by the latter-period acquisition means and the monthly number acquired by the latter-period acquisition means, etc., with reference to the second master. After acquiring the associated accounting year-after as the year / month acquisition means-when the year / month acquisition unit 102b18 and (21) the collection result data created by the same month collection means are specified as the reference destination, the relevant With reference to the collection result data, the collection target item associated with the specified fiscal year and month is extracted, and when the collection result data created by the elapsed month collection means is specified as the reference destination, the collection result data is used. With reference to the extraction unit 102c as an extraction means for extracting the collection target item associated with the specified fiscal year and month, and (22) the first master, the accounting period to which the occurrence date belongs is acquired. , The month to acquire the accounting year and month associated with the acquired accounting period-the month as the year and month acquisition means-the year and month acquisition unit 102d. For details of the processing executed by each part, see the following [3. Specific example of processing] will be described.

[3. Specific example of processing]
Hereinafter, specific examples of the processing according to the present embodiment will be described.

[3-1. Overview of how to resolve the delay]
In this item, the outline of the method of solving the time lag will be described in detail with reference to FIGS. 9 to 11. In the present embodiment, for example, in the group collection result data 106e, a column for the same month comparison year / month analysis method (a method of comparing the sales amount between the current years between companies) and an elapsed month. By holding a column for the comparison date analysis method (a method of comparing sales amounts, etc. according to the accounting period of one company), the analysis method can be dynamically switched. Further, in the present embodiment, for example, it is possible to determine the state in which the settlement period of an individual company and the settlement period of a group company are different from each other and the difference in the length of the settlement period, and automatically determine the month to be linked according to the rules. I made it.

The monthly association between company G (group company) and company C (subsidiary) when performing the elapsed month comparison analysis method will be described with reference to FIG. As shown before the change of the settlement period in FIG. 9, when the settlement period of C company is 3 months earlier than that of G company, the monthly link is as shown by the diagonal arrow before the change of the settlement period in FIG. Here, if the 20th term of company C is shortened to 3 months, there will be no difference in the settlement period between company G and company C from the 21st term of company C, and it will be tied monthly. Is as shown by the vertical arrow after the change of the accounting period in FIG. At this time, it is necessary to set which month of company G will be linked to the three months of company C's 20th term 1Q (Q refers to the quarter. The same shall apply hereinafter), which was shortened. Become.

The method of associating 1Q of the 20th term of Company C will be described with reference to FIG. There are the following three methods of linking. The first method is to consolidate the 1Q of the 20th term of Company C into the 1st month of the next term of Company G. That is, as shown in the associative master 106c of the setting example (1) of FIG. 10, the monthly numbers (1) to (3) of the 20th period of the company C are all changed to the monthly numbers (1) of the 50th period of the company G. It is a method of associating. The second method is to consolidate the 1Q of Company C's 20th term into the December of the previous term of Company G. That is, as shown in the associative master 106c of the setting example (2) of FIG. 10, the monthly numbers (1) to (3) of the 20th period of the company C are all changed to the monthly numbers (12) of the 49th period of the company G. It is a method of associating. The third method is to not set the association. In this case, as shown in the setting example (3) of FIG. 10, the monthly numbers (1) to (3) of the 20th period of the company C are the monthly numbers (10) to (12) of the 49th period of the company G, respectively. Is tied to.

Even if there is a change in the settlement period due to shortened settlement, etc., whether to set the aggregation destination to the end of the previous term or the beginning of the next term of company G (parent company) without setting the linking master 106c. It may be performed automatically by master control.

Specific examples of the columns for the same month comparative analysis method and the columns for the elapsed month comparative analysis method in the group collection result data 106e will be described with reference to FIG. When the amount of the X month included in the collection target data 106d (journal details) of the company C shown in FIG. 11 is collected as a column for the same month comparison analysis method, the data is collected as the amount of the X month. For example, the amount of 10,000 yen of 2017/01/10 shown in the collection target data 106d of Company C in FIG. 11 is used as the data of "2017/01" as shown by MA1 in the group collection result data 106e of FIG. Will be collected. On the other hand, when the amount of the X month included in the collection target data 106d (journal details) of the company C shown in FIG. 11 is collected as a column for the elapsed month comparison analysis method, the data is the amount of the (X + 3) month. Will be collected. This is because, as explained in the paragraphs before and after, the accounting period of company C is three months earlier than that of company G, so the X month of company C corresponds to the (X + 3) month of company G. Is. For example, the amount of 10,000 yen of 2017/01/10 shown in the collection target data 106d of Company C in FIG. 11 is used as the data of "2017/04" as shown by MA2 in the group collection result data 106e of FIG. Will be collected.

Here, the data collection device 100 according to the present embodiment includes the same month collection unit 102a or the elapsed month collection unit 102b. The data collection performed by the elapsed month collection unit 102b is data collection when the association master 106c is set, data collection when the classification in the company master 106f is "same classification", and the classification in the company master 106f is "first classification". It is divided into four types: data collection when "" and data collection when the classification in the company master 106f is "post-classification". Therefore, items will be described below in this order.

[3-2. Data collection performed by the same month collection unit 102a]
In this item, the data collection performed by the same month collection unit 102a will be described in detail with reference to FIG.

In this item, data shall be collected under the following collection conditions.
(Collecting conditions)
Group companies you want to collect Monthly: 2017/04
Collection target company: Company C (with a time lag)

First, as shown in FIG. 14, when the above (collection condition) is specified, the fiscal year 2017/04 is acquired with reference to the monthly period master 106b of Company G. On the other hand, as shown in FIG. 14, the same month collection unit 102a refers to the monthly period master 106b of company C, and the monthly start date to which the occurrence date (2017/04/10) included in the collection target data 106d belongs. The period from to the end date of the month (2017/04/01 to 2017/04/30) is acquired, and the accounting month (2017/04) associated with the acquired period is acquired. As a result, as shown in the group collection result data 106e of FIG. 14, the same month collection unit 102a collects data associated with the accounting month 2017/04 for company C and the occurrence date (2017/04/10). The group collection result data 106e including the amount (40,000 yen) included in 106d is created. The method of acquiring the fiscal year 2017/07 in the group collection result data 106e will be described in detail in the following item [3-3].

[3-3. Data collection performed by the elapsed month collection unit 102b]
In this item, the data collection performed by the elapsed month collection unit 102b will be described in detail. As described above, the data collection performed by the elapsed month collection unit 102b is further divided into four types of data collection. However, regardless of which of the four types of data collection is performed, the following processing executed by the elapsed month collection unit 102b is common. That is, the elapsed month collection unit 102b includes the date of occurrence included in the data to be collected 106d, the fiscal year end, the monthly number, and the period from the monthly start date to the monthly end date included in the monthly period master 106b of company C (subsidiary). , The accounting month for company G by acquiring the accounting month included in the monthly period master 106b for company G based on the accounting period and monthly number included in the monthly period master 106b of company G (parent company). , The group collection result data 106e including the amount of money included in the collection target data 106d associated with the occurrence date is created.

(A) Data collection when the linking master 106c is set In this item, data collection when the linking master 106c is set will be described in detail with reference to FIGS. 4 and 15. The status and master settings when processing this item are as follows.

Situation: Since there was a change in the accounting period of company C, we would like to consolidate the monthly numbers (1) to (3) of company C's 20th period into the monthly number (1) of company G's next period (50th period). 106c: Settings shown in FIG. 15 Monthly period masters of companies G and C 106b: Settings shown in FIG.

First, the string-first period number acquisition unit 102b1 refers to the monthly period master 106b of company C in FIG. 4, and the occurrence date included in the data to be collected 106d in FIG. 15 (for example, 2017/01/10). The accounting period (2017/01/01 to 2017/01/31) to which the company belongs is acquired, and the accounting period 20 for Company C is linked to the acquired accounting period (2017/01/01 to 2017/01/31). And get the monthly number (1).

Next, the string-second period number acquisition unit 102b2 refers to the linking master 106c in FIG. 15, and the settlement period 20 and the monthly number for company C acquired by the string-first period number acquisition unit 102b1. Obtain the accounting period 50 and monthly number (1) for Company G, which is linked to (1).

Finally, the string-year / month acquisition unit 102b3 refers to the monthly period master 106b of Company G in FIG. Acquire the tied fiscal year (2017/04).

Although detailed description is omitted, the fiscal year (2017/04) is acquired for the occurrence dates 2017/02/10 and 2017/03/10 included in the data to be collected 106d in FIG. 15 by the same method. can do.

In this way, the data shown in the group collection result data 106e of FIG. 15 surrounded by a square can be collected.

(B) Data collection when the classification in the company master 106f is "same classification" In this item, details of data collection when the classification in the company master 106f is "same classification" are described with reference to FIGS. 4 and 16. Explain to. The status and master settings when processing this item are as follows.

Situation: Company C made a provisional settlement in March
Monthly period master 106b of company G and company C: Category in setting company master 106f shown in FIG. 4: "Same category"

First, the same-first year and month acquisition unit 102b4 refers to the monthly period master 106b of company C in FIG. 4, and the occurrence date included in the collection target data 106d in FIG. 16 (square in the collection target data 106d in FIG. 16). Acquire the accounting period (2017/04/01 to 2017/04/30) to which the accounting period (2017/04/10) to which it belongs, and the acquired accounting period (2017/04/01 to 2017/04/30). Acquire the associated accounting month (2017/04).

Next, the same-second year acquisition unit 102b5 is the same as the accounting month (2017/04) acquired by the same-first year acquisition unit 102b4 with reference to the monthly period master 106b of company G in FIG. Acquire the fiscal year (2017/04). As described above, for the occurrence date 2017/04/10 included in the collection target data 106d, the fiscal year 2017/04 can be acquired as shown by enclosing the group collection result data 106e in FIG. 16 in a square. ..

Although detailed description is omitted, the accounting month 2017/01 can be acquired for the occurrence date 2017/01/10 included in the collection target data 106d by the same method, and the occurrence date 2017/02 / For 10, the accounting month 2017/02 can be acquired, for the occurrence date 2017/03/10, the accounting month 2017/03 can be acquired, and for the occurrence date 2017/05/10, the accounting month 2017 can be acquired. 2017/05 can be acquired, and for the occurrence date 2017/06/10, the accounting month 2017/06 can be acquired.

In this way, it is possible to collect the data of the example of the elapsed month comparison year and month of the group collection result data 106e of FIG.

(C) Data collection when the classification in the company master 106f is the "first classification" In this item, details of data collection when the classification in the company master 106f is the "first classification" are described with reference to FIGS. 4 and 17. Explain to. The master settings when processing this item are as follows.

Monthly period master 106b of company G and company C: Category in setting company master 106f shown in FIG. 4: "First category"

(C-1) Acquisition of processing target First, the previous-period number acquisition unit 102b6 refers to the monthly period master 106b of company C in FIG. 4 and includes the occurrence date included in the collection target data 106d in FIG. 17 (FIG. 17). The accounting period (2017/04/01 to 2017/04/30) to which the data to be collected 106d (2017/04/10) belongs is acquired, and the acquired accounting period (2017/04/01 to 2017) is acquired. Acquire the accounting period 20 and the monthly number (4) associated with 2017/04/30). In other words, the previous-period number acquisition unit 102b6 acquires the individual company monthly number (4) from the individual company date 2017/04.

(C-2) Acquisition at the end of the period Next, the first maximum monthly acquisition unit 102b7 refers to the monthly period master 106b of company C in FIG. Get the maximum monthly number (12) associated with. In other words, the destination-first maximum monthly acquisition unit 102b7 acquires the end-of-term month (month number (12) of 2017/12) of the individual company when the "linking method" in the company master 106f is "destination".

(C-3) Group settlement period acquisition Next, the previous-period number acquisition unit 102b8 refers to the monthly period master 106b of company C in FIG. 4, and the previous-period number acquisition unit 102b6 acquires the settlement period 20. And earlier-acquire the fiscal month (2017/12) associated with the maximum monthly number (12) acquired by the first maximum monthly acquisition unit 102b7, and further refer to the monthly period master 106b of company G in FIG. , Acquire the accounting period 50 associated with the acquired fiscal year (2017/12). In other words, the previous-period number acquisition unit 102b8 acquires the settlement period (50 periods from 2017/4 to 2018/3) of the same month of the group.

(C-4) Acquisition of end-of-term monthly number Next, the first-second maximum monthly acquisition unit 102b9 refers to the monthly period master 106b of Company G in FIG. Obtain the maximum monthly number (12) associated with 50. In other words, the first-second maximum monthly acquisition unit 102b9 acquires the maximum monthly period (end-of-term monthly number (12) of the 50th period) acquired in (C-3).

(C-5) Monthly number comparison Next, the first-determination unit 102b10 was acquired by the first-first maximum monthly acquisition unit 102b7 and the first-second maximum monthly acquisition unit 102b9. It is determined whether or not the maximum monthly number (12) is the same. In the case of this example, the destination-determination unit 102b10 determines that they are the same. In other words, the destination-determination unit 102b10 compares the maximum monthly period (individual company: (12), group: (12)) of the accounting period acquired in (C-2) and (C-4).

(C-6) Result Judgment Finally, when the previous-year / month acquisition unit 102b11 determines that the previous-determination unit 102b10 is the same, the previous-year / month acquisition unit 102b11 refers to the monthly period master 106b of company G in FIG. The fiscal year 50 acquired by the period acquisition unit 102b8 and the accounting month number (2017/07) associated with the monthly number (4) acquired by the previous-period number acquisition unit 102b6 are shown in FIG. To get to. In other words, in the comparison of (C-5), if the maximum monthlyity of the individual company and the maximum monthlyity of the group match, the previous-year / month acquisition unit 102b11 will check the individual company month of the group settlement period (50th period). Acquire 2017/07 corresponding to the number (4).

On the other hand, when the previous-year / month acquisition unit 102b11 determines that the previous-determination unit 102b10 is not the same, the previous-year / month acquisition unit 102b11 is included in the data to be collected 106d with reference to the monthly period master 106b of company G in FIG. The accounting period (2017/04) associated with the accounting period (2017/04/01 to 2017/04/30) to which the date of occurrence (2017/04/10 shown by enclosing the data 106d to be collected in FIG. 17) belongs. , As shown in "Inconsistency" in FIG. In other words, in the comparison of (C-5), if the maximum monthlyity of the individual company and the maximum monthlyity of the group do not match (that is, if there is a change in the accounting period), it corresponds to the group monthlyity to be collected 2017 /. Get 04.

Although detailed description is omitted, the accounting month 2017/04 can be obtained for the occurrence date 2017/01/10 included in the collection target data 106d by the same method, and the occurrence date 2017/02 / For 10, the accounting month 2017/05 can be acquired, for the occurrence date 2017/03/10, the accounting month 2017/06 can be acquired, and for the occurrence date 2017/05/10, the accounting month 2017 can be acquired. 2017/08 can be acquired, and for the occurrence date 2017/06/10, the accounting month 2017/09 can be acquired.

In this way, it is possible to collect the data of the example of the elapsed month comparison year and month of the group collection result data 106e of FIG.

(D) Data collection when the category in the company master 106f is "post-category" In this item, details of data collection when the category in the company master 106f is "post-category" are described with reference to FIGS. 4 and 18. Explain to. The master settings when processing this item are as follows.

Monthly period master 106b of company G and company C: Classification in setting company master 106f shown in FIG. 4: "Post-classification"

(D-1) Acquisition of processing target First, the late-period number acquisition unit 102b12 refers to the monthly period master 106b of company C in FIG. 4, and the occurrence date included in the collection target data 106d (shown in FIG. 18). The accounting period (2017/04/01 to 2017/04/30) to which the accounting period (2017/04/10) belongs is acquired, and the acquired accounting period (2017/04/01 to 2017/04) is acquired. Acquire the accounting period 20 and the monthly number (4) associated with / 30). In other words, the late-period number acquisition unit 102b12 acquires the individual company monthly number (4) from the individual company date 2017/04.

(D-2) Acquisition at the end of the period Next, the latter-first maximum monthly acquisition unit 102b13 refers to the monthly period master 106b of company C in FIG. Get the maximum monthly number (12) associated with. In other words, the rear-first maximum monthly acquisition unit 102b13 acquires the term-end monthly number (2017/12 monthly number (12)) of the individual company when the "linking method" in the company master 106f is "after".

(D-2)'Acquisition at the beginning of the period Next, the latter-minimum monthly acquisition unit 102b14 refers to the monthly period master 106b of company C in FIG. Obtain the minimum monthly number (1) to be linked. In other words, the post-minimum monthly acquisition unit 102b14 acquires the beginning month (2017/1 monthly number (1)) of the individual company when the "linking method" in the company master 106f is "post".

(D-3) Acquisition of Group Fiscal Year Period Next, the late-period number acquisition unit 102b15 refers to the monthly period master 106b of Company C in FIG. And later-acquire the accounting month (2017/01) associated with the minimum monthly number (1) acquired by the minimum monthly acquisition unit 102b14, and further refer to the monthly period master 106b of Company G in FIG. Acquire the fiscal year 49 associated with the acquired fiscal year (2017/01). In other words, the late-period acquisition unit 102b15 acquires the settlement period (49 periods, which is 2016/4 to 2017/3) of the same month of the group.

(D-4) Acquisition of period-end monthly number Next, the latter-second maximum monthly acquisition unit 102b16 refers to the monthly period master 106b of Company G in FIG. 4, and the settlement period acquired by the latter-period acquisition unit 102b15. Obtain the maximum monthly number (12) associated with 49. In other words, the latter-second maximum monthly acquisition unit 102b16 acquires the maximum monthly period (end-of-term monthly number (12) of the 49th period) acquired in (D-3).

(D-5) Comparison of Monthly Numbers Next, the rear-judgment unit 102b17 acquired the maximum monthly number (12) acquired by the rear-first maximum monthly acquisition unit 102b13 and the rear-second maximum monthly acquisition unit 102b16. It is determined whether or not the maximum monthly number (12) is the same. In the case of this example, the rear-determination unit 102b17 determines that they are the same. In other words, the post-determination unit 102b17 compares the maximum monthly periods (individual company: (12), group: (12)) of the accounting period acquired in (D-2) and (D-4).

(D-6) Result determination Finally, when the posterior-year / month acquisition unit 102b18 determines that the posterior-determination unit 102b17 is the same, the posterior-year / month acquisition unit 102b18 refers to the monthly period master 106b of Company G in FIG. As shown in FIG. 18, “when matching” shows the accounting month (2016/07) associated with the accounting month number (4) acquired by the period acquisition unit 102b15 and the accounting period 49 acquired by the period acquisition unit 102b15. To get to. In other words, in the comparison of (D-5), if the maximum monthlyity of the individual company and the maximum monthlyity of the group match, the later-year / month acquisition unit 102b18 will check the individual company month of the group settlement period (49th period). Acquire 2016/07 corresponding to the number (4).

On the other hand, when the post-year / month acquisition unit 102b18 determines that the post-determination unit 102b17 is not the same, the post-year / month acquisition unit 102b18 is included in the collection target data 106d with reference to the monthly period master 106b of company G in FIG. The accounting period (2017/04) associated with the accounting period (2017/04/01 to 2017/04/30) to which the date of occurrence (not shown in FIG. 18, but assumed to be 2017/04/10) belongs. , As shown in "At the time of mismatch" in FIG. In other words, in the comparison of (D-5), if the maximum monthlyity of the individual company and the maximum monthlyity of the group do not match (that is, if there is a change in the accounting period), it is the group monthlyity to be collected 2017/04. To get.

As described above, as described in [3-1] to [3-3], if the data collection device 100 according to the present embodiment includes the same month collection unit 102a or the elapsed month collection unit 102b, the first company Even if the period of the first company and the period of the second company are not set in advance, the data such as the sales amount of the first company for a certain period can be obtained as the sales amount of the second company for the period corresponding to the certain period. Data can be collected by converting it as such. For this reason, for example, unlike the conventional case, it is not necessary to link and set the corresponding periods of both companies in advance in the master, so that the operational load of data collection can be significantly reduced.

However, it is preferable that the data collection device 100 according to the present embodiment includes both the same month collection unit 102a and the elapsed month collection unit 102b in order to perform the extraction process described in the following [3-4].

[3-4. Extraction process performed by extraction unit 102c]
In this item, the extraction process performed by the extraction unit 102c will be described in detail with reference to FIG.

As shown in FIG. 19, the data collection device 100 according to the present embodiment includes both the same month collection unit 102a and the elapsed month collection unit 102b, so that the columns for the same month comparative analysis method for company C and C Both columns for the elapsed month comparison analysis method for the company can be collected. As a result, the following extraction processing can be performed.

That is, as shown in the screen at the time of form output in FIG. 19, when the group collection result data 106e created by the same month collection unit 102a is specified as the reference destination (in the screen at the time of form output in FIG. 19 as an analysis method). When "same month comparison analysis" is selected), the extraction unit 102c will use the specified accounting year and month ("2017/04/01 to 2017 /" entered as the target period on the screen at the time of form output in FIG. 06/30 ”) and the collection target items (2017/04, 2017/05, and 2017/06, which are enclosed in squares in the same month comparison year / month column of the group collection result data 106e in FIG. 19, respectively. Some 40,000 yen, 50,000 yen and 60,000 yen) are extracted.

Thereby, for example, it is possible to compare the sales amount and the like based on the period of company A. Specifically, as described in the previous paragraph, the sales amount corresponding to the sales amount of 400,000 in 2017/04 of company A (shown in the data 106d collected by company A in FIG. 19) is 2017 of company C. The sales amount of / 04 is 40,000 yen. "

On the other hand, as shown in the screen at the time of form output in FIG. 19, when the group collection result data 106e created by the elapsed month collection unit 102b is specified as the reference destination (in the screen at the time of form output in FIG. 19). When "elapsed month comparison analysis" is selected as the analysis method), the extraction unit 102c will input "2017/04/01" as the target period on the screen when the form is output in FIG. 19 for the specified accounting year and month. ~ 2017/06/30 ”) and the collection target items (2017/04, 2017/05, and 2017/06, which are enclosed in squares in the column of the elapsed month comparison year and month of the group collection result data 106e in FIG. 19, respectively. The attached amount of 10,000 yen, 20,000 yen and 30,000 yen) is extracted.

Thereby, for example, it is possible to compare the sales amount and the like based on the period of company A. Specifically, as described in the previous paragraph, the sales amount corresponding to the sales amount of 400,000 in 2017/04 of company A (shown in the collection target data 106d of company A in FIG. 19) is 2017 of company C. The sales amount of / 04 is 10,000 yen (note that this sales amount of 10,000 yen is actually the sales of company C 2017/01 as shown in the collection target data 106d of company C in FIG. Regarding the amount of money, since the settlement period of company C is three months earlier than that of company A, it is converted and collected as the sales amount of 2017/04 by the elapsed month collection unit 102b). That is, to put it simply, based on Company A's April 2017 sales amount, Company A's sales amount in April 2017 (400,000 yen) and Company C's sales amount in January 2017 (10,000 yen). Can be compared with.

As described above, the data collection device 100 according to the present embodiment includes both the same month collection unit 102a and the elapsed month collection unit 102b, so that the group collection result data 106e has columns and progress for the same month comparison analysis method. Not only one of the columns for the monthly comparison analysis method, but both columns can be prepared in advance. As a result, the extraction unit 102c can quickly extract the column corresponding to the comparative analysis method selected by the operator, so that the response at the time of outputting the form is significantly faster than in the conventional case.

[3-5. Example of the period for which the form is output]
In this item, FIGS. 20 to 22 show a comparison between the period of company G, which is the target of form output, and the period of company C, which is the target of form output.

First, FIG. 20 is a diagram showing a comparison between the period of company G, which is the target of form output, and the period of company C, which is the target of form output, under the following conditions.

(conditions)
Period specified when outputting the form: "2017/5/1 to 2017/7/31" of Company G
Delay: None Analytical method: Elapsed month comparative analysis method or same month comparative analysis method

As shown by hatching in FIG. 20, the period corresponding to "2017/5/1 to 2017/7/31" of the group company (Company G) is "2017/5/1 to 2017 /" of the subsidiary company (Company C). It turns out that it is "7/31". The meanings of the symbols and terms shown in FIG. 20 are as shown in FIGS. 1 to 8 below, and the same applies to FIGS. 21 and 22 below.
1. 1. The set balance is the balance entered at the start of introduction.
2. 2. The balance carried forward is the balance at the beginning of the target period.
3. 3. The beginning of the table is a virtual beginning that is different from the original beginning. By using the beginning of the table, it is possible to analyze by the virtual accounting period.
4. Balance of BS (Balance Sheet) items at the time of (5) = Set balance of BS items at the time of (1) + Amount of BS items during the period (2) + Amount of BS items during the period (3) 5 .. Balance of PL (Profit & Loss Statement) items carried forward at the time of (5) = Amount of PL items during the period of (3) 6. Amount generated (not related to subject) = Amount for the period of (4) 7. Cumulative amount of BS items = Balance carried forward of BS items at the time of (5) + Amount generated 8. Cumulative amount of PL items = Balance carried forward of PL items at the time of (5) + Amount generated

Next, FIG. 21 is a diagram showing a comparison between the period of company G, which is the target of form output, and the period of company C, which is the target of form output, under the following conditions.

(conditions)
Period specified when outputting the form: "2017/5/1 to 2017/7/31" of Company G
Delay: Yes Analysis method: Elapsed month comparison analysis method

As shown by hatching in FIG. 21, the period corresponding to "2017/5/1 to 2017/7/31" of the group company (Company G) is "2017/2/1 to 2017 /" of the subsidiary company (Company C). It turns out that it is "4/30".

Finally, FIG. 22 is a diagram showing a comparison between the period of company G, which is the target of form output, and the period of company C, which is the target of form output, under the following conditions.

(conditions)
Period specified when outputting the form: "2018/3/1 to 2018/5/31" of Company G
Time lag: Yes Analysis method: Elapsed month comparison analysis method Others: Company C's January-March 2018 will be shortened, and after April, it will be changed to the same fiscal year as Company G (that is, there is no time lag). It became.

As shown by hatching in FIG. 22, the period corresponding to 2018/3 of the group company (Company G) is 2017/12 of the subsidiary company (Company C), and the period corresponding to 2018/4 of the group company (Company G). Is 2018/1 to 4 of the subsidiary (Company C) (shortened settlement of accounts), and the period corresponding to 2018/5 of the group company (Company G) is 2018/5 of the subsidiary (Company C) (there is no time lag). Is.

[3-6. Month-year / month acquisition process performed by the year / month acquisition unit 102d]
In this item, the year / month acquisition process performed by the month-year / month acquisition unit 102d will be described in detail with reference to FIG.

The month-year / month acquisition unit 102d refers to the monthly period master 106b of company B in FIG. 8, and refers to the accounting period (2017 / 03/25) to which the occurrence date (2017/03/25) included in the data to be collected by company B 106d belongs. 03/21 to 2017/04/20) is acquired, and the accounting month (2017/04) associated with the acquired accounting period (2017/03/21 to 2017/04/20) is acquired. In addition, the month-year / month acquisition unit 102d acquires the fiscal year 2017/04 for the occurrence date 2017/04/15 included in the collection target data 106d of Company B in FIG. 8 in the same manner. And for the date of occurrence 2017/04/25, the fiscal year 2017/05 can be obtained. In this way, as shown in the group collection result data 106e of FIG. 8, the month-year / month acquisition unit 102d has an accounting month 2017/04 (sales amount of 1,000 yen) and an accounting month 2017 / for company B. You can get 04 (sales amount is 2,000 yen) and fiscal year 2017/05 (sales amount is 3,000 yen).

The month-year / month acquisition unit 102d can acquire the accounting month as shown in FIG. 8 by the same method as in the previous paragraph for the occurrence date included in the data to be collected by company A in FIG. In this way, as shown in the group collection result data 106e of FIG. 8, the month-year / month acquisition unit 102d has an accounting month 2017/03 (sales amount of 10,000 yen) and an accounting month 2017 / for company A. You can get 04 (sales amount is 20,000 yen) and fiscal year 2017/04 (sales amount is 30,000 yen).

As described above, if the data collection device 100 according to the present embodiment is provided with the month-year / month acquisition unit 102d, it is possible to compare the sales amounts of the first company and the second company by paying attention to the accounting month. .. Therefore, as in the past, for example, 2017/04/21 to 2017/05/20 of Company B, 2017/04/01 to 2017/04/30 and 2017/05/01 to 2017/05 of Company A There is no possibility that it will not be possible to determine which of / 31 corresponds to, and since 2017/04 / 21-2017 / 05/20 of Company B corresponds to the accounting month 2017/05, the same accounting month 2017 It can be immediately determined that it corresponds to 2017/05/01 to 2017/05/31 of Company A having / 05.

In this specification, only an example in which either the time lag or the month lag exists is shown, but according to the data acquisition device 100 according to the present embodiment, both the time lag and the month lag are shown. Even if it exists, the first method is to combine the specific solution of the time lag of [3-2] and [3-3] with the concrete solution of the month lag of [3-6]. It is possible to compare the sales amount, etc. of the corresponding period of the company and the second company.

[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, among the processes described in the embodiments, all or part of the processes described as being automatically performed may be performed manually, or all the processes described as being performed manually may be performed. Alternatively, a part thereof can be automatically performed by a known method.

In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in this specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the data acquisition 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 data acquisition device 100, particularly each processing function performed by the control unit 102, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. 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 data acquisition apparatus is required. Read mechanically to 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 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 data acquisition device 100 via an arbitrary network, and all or a part thereof can be downloaded as needed. be.

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 Protocol Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium". Therefore, a recording medium containing a program for executing a process or a process method as described herein also constitutes the present invention.

Further, 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 multiple 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 and the installation procedure after reading in each device shown in the embodiment.

Various databases and the like stored in the storage unit 106 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 data collecting device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the data acquisition 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.

Furthermore, the specific form of distribution / integration of the device is not limited to the one shown in the figure, and all or part of the device may be functionally or physically in any 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 in all industries, but is particularly useful in industries where there are monthly closings and gaps in the accounting period between affiliated companies within a group company.

100 Data acquisition device
102 Control unit
102a Same month collection department
102b Elapsed month collection department
102b1 String-First term number acquisition section
102b2 String-Second period number acquisition section
102b3 String-Year / Month Acquisition Department
102b4 Same-First Year Acquisition Department
102b5 Same-Second Year Acquisition Department
102b6 Destination-Number of periods, etc. Acquisition section
102b7 Destination-First maximum monthly acquisition unit
102b8 Destination-Number acquisition unit
102b9 Destination-Second maximum monthly acquisition unit
102b10 destination-judgment unit
102b11 Last-year / month acquisition department
102b12 Late-Number of periods, etc. Acquisition section
After 102b13-First maximum monthly acquisition unit
After 102b14-Minimum monthly acquisition unit
102b15 Late-Period number acquisition part
After 102b16-Second maximum monthly acquisition unit
After 102b17-Judgment unit
After 102b18-Year / Month Acquisition Department
102c Extractor
102d Month-Year / Month Acquisition Department
104 Communication interface section
106 Storage unit
106a Accounting period master
106b Monthly period master
106c Linking master
106d Data to be collected
106e Group collection result data
106f Company master
108 Input / output interface section
112 Input device
114 Output device 200 Server 300 Network

Claims (11)

A data acquisition device equipped with a control unit and a storage unit.
In the storage unit
With the first master including the number of accounting periods for the first company, the monthly number within the accounting period, the accounting period corresponding to the number of periods and the combination of the monthly numbers, and the accounting year and month corresponding to the combination. ,
A second master that includes the number of fiscal years for the second company, the monthly number within the fiscal year, the number of periods, and the fiscal year and month corresponding to the combination of the months and numbers.
Collection target data including the collection target item for the first company and the occurrence date of the collection target item,
Is stored,
The control unit
Equipped with same month collection means and elapsed month collection means,
The same month collection means
By referring to the first master, acquiring the accounting period to which the occurrence date belongs, and acquiring the accounting year and month associated with the acquired accounting period, the accounting year and month for the first company and the above Create collection result data including the collection target items included in the collection target data linked to the occurrence date,
The elapsed month collection means is
Said date, the number of periods included in the first master, and monthly number and accounting period, the number of periods and Tsukido number included in said second master, on the basis of the accounting date included in said second master By acquiring, the collection result data including the fiscal year and month for the second company and the collection target items included in the collection target data associated with the occurrence date is created .
The elapsed month collection means is
With reference to the first master, the acquisition means for acquiring the accounting period to which the occurrence date belongs, the number of periods associated with the acquired accounting period, and the monthly number, etc.
With reference to the first master, the destination-first maximum monthly acquisition means for acquiring the maximum monthly number associated with the period acquired by the previous-period number acquisition means, and the first maximum monthly acquisition means.
With reference to the first master, the number of periods acquired by the previous-first maximum monthly acquisition means and the fiscal year and month associated with the maximum monthly number acquired by the previous-first maximum monthly acquisition means are acquired, and further. , With reference to the second master, the destination-number acquisition means for acquiring the number of periods associated with the acquired fiscal year and month,
With reference to the second master, the destination-second maximum monthly acquisition means for acquiring the maximum monthly number associated with the period acquired by the previous-period acquisition means, and
The destination-determining means for determining whether or not the maximum monthly number acquired by the destination-first maximum monthly acquisition means and the maximum monthly number acquired by the destination-second maximum monthly acquisition means are the same.
When it is determined that the first-determination means are the same, the number of periods acquired by the first-period acquisition means and the monthly number acquired by the first-period acquisition means, etc., with reference to the second master. Destination to acquire the fiscal year and month associated with-year and month acquisition means,
To prepare for
A data acquisition device characterized by. Wherein,
If the same month collection means the collection result the created data as ginseng Terusaki is designated, with reference to the collection result data, extracting the specified accounting date and string attached collection target item,
When the collection result data created by the elapsed month collection means is specified as a reference destination, an extraction means for extracting the collection target item associated with the specified accounting year and month by referring to the collection result data is further provided. matter,
The data acquisition device according to claim 1. In the storage unit
The first category, which is the category when the company identification information of the first company and the accounting date of the second company are linked to the accounting date of the first company before the accounting date. The accounting date of the second company is the accounting date of the second company and the accounting date of the second company, which is the classification when the accounting date of the second company is linked to the accounting date of the first company after the accounting date. A division master including any one division of the same division, which is a division when associating with the accounting year and month of the same first company, is further stored.
When the division in the division master is the destination division,
The elapsed month collection means is
With the above-mentioned means for acquiring the number of periods, etc.
The above- the first maximum monthly acquisition means and
With the above-mentioned means for acquiring the number of periods
The above-mentioned destination-second maximum monthly acquisition means and
The above- determination means and
With the above-mentioned previous-year and month acquisition means,
Possible to obtain Bei a,
The data acquisition apparatus according to claim 1 or 2. In the storage unit
The first category, which is the category when the company identification information of the first company and the accounting date of the second company are linked to the accounting date of the first company before the accounting date. The accounting date of the second company is the accounting date of the second company and the accounting date of the second company, which is the classification when the accounting date of the second company is linked to the accounting date of the first company after the accounting date. A division master including any one division of the same division, which is a division when associating with the accounting year and month of the same first company, is further stored.
When the division in the division master is the latter division,
The elapsed month collection means is
With reference to the first master, the accounting period to which the occurrence date belongs is acquired, and the number of periods associated with the acquired accounting period and the monthly number are acquired.
With reference to the first master, after-first maximum monthly acquisition means for acquiring the maximum monthly number associated with the number of periods acquired by the latter-first maximum monthly acquisition means,
With reference to the first master, the post-minimum monthly acquisition means for acquiring the minimum monthly number associated with the period acquired by the late-period acquisition means, and the latter-minimum monthly acquisition means.
With reference to the first master, the fiscal year and month associated with the number of periods acquired by the latter-term number acquisition means and the minimum monthly number acquired by the latter-minimum monthly acquisition means are acquired, and further, the above-mentioned Refer to the second master to acquire the number of periods associated with the acquired fiscal year and month.
With reference to the second master, after acquiring the maximum monthly number associated with the period acquired by the latter-second maximum monthly acquisition means, and the second maximum monthly acquisition means.
After-determining whether or not the maximum monthly number acquired by the first maximum monthly acquisition means and the maximum monthly number acquired by the second maximum monthly acquisition means are the same-after-determining means,
When it is determined that the latter-determination means are the same, the number of periods acquired by the latter-period acquisition means and the monthly number acquired by the latter-period acquisition means, etc., with reference to the second master. After acquiring the fiscal year and month associated with-the means of acquiring the year and month,
To prepare further,
The data acquisition device according to any one of claims 1 to 3. In the storage unit
The first category, which is the category when the company identification information of the first company and the accounting date of the second company are linked to the accounting date of the first company before the accounting date. The accounting date of the second company is the accounting date of the second company and the accounting date of the second company, which is the classification when the accounting date of the second company is linked to the accounting date of the first company after the accounting date. A division master including any one division of the same division, which is a division when associating with the accounting year and month of the same first company, is further stored.
When the division in the division master is the same division,
The elapsed month collection means is
With reference to the first master, the accounting period to which the occurrence date belongs is acquired, and the accounting date associated with the acquired accounting period is acquired.
With reference to the second master, the same-second year-month acquisition means that acquires the same fiscal year and month as the same-first year-month acquisition means.
To prepare further,
The data acquisition device according to any one of claims 1 to 4. In the storage unit
A linking master containing the period number and the monthly number for the first company and the period number and the monthly number for the second company is further stored.
The elapsed month collection means is
With reference to the first master, the accounting period to which the occurrence date belongs is acquired, and the number of periods and the monthly number for the first company, which is associated with the acquired accounting period, is acquired-the first period. Etc. acquisition means and
With reference to the linking master, the term number and monthly number for the second company linked to the term number and monthly number for the first company acquired by the string-first term number acquisition means. String to acquire-the means of acquiring the number of the second period, etc.,
With reference to the second master, the string-the string for acquiring the fiscal year and month associated with the period number and the month number acquired by the second period acquisition means, and the year / month acquisition means.
To prepare further,
The data acquisition device according to any one of claims 1 to 5. The control unit
Further providing a month-year / month acquisition means for acquiring the accounting period to which the occurrence date belongs and acquiring the accounting year / month associated with the acquired accounting period with reference to the first master.
The data acquisition device according to any one of claims 1 to 6, wherein the data acquisition device is characterized. The first company is a subsidiary within the group company,
The second company is the parent company within the group company.
The data acquisition device according to any one of claims 1 to 7. The data to be collected is journal detail data.
The item to be collected is the amount of money.
The date of occurrence is the date of occurrence of the amount.
The data acquisition device according to any one of claims 1 to 8. A data collection method executed by an information processing device including a control unit and a storage unit.
In the storage unit
With the first master including the number of accounting periods for the first company, the monthly number within the accounting period, the accounting period corresponding to the number of periods and the combination of the monthly numbers, and the accounting year and month corresponding to the combination. ,
A second master that includes the number of fiscal years for the second company, the monthly number within the fiscal year, the number of periods, and the fiscal year and month corresponding to the combination of the months and numbers.
Collection target data including the collection target item for the first company and the occurrence date of the collection target item,
Is stored,
Executed by the control unit,
Including same month collection step and elapsed month collection step
The same month collection step
By referring to the first master, acquiring the accounting period to which the occurrence date belongs, and acquiring the accounting year and month associated with the acquired accounting period, the accounting year and month for the first company and the above Create collection result data including the collection target items included in the collection target data linked to the occurrence date,
The elapsed month collection step is
The date of occurrence, the number of periods included in the first master, the monthly number and the accounting period, the number of periods of the accounting period for the second company, the monthly number within the accounting period, the number of the period and the accounting period. About the second company by acquiring the accounting year and month included in the second master based on the number of periods and the month number included in the second master including the accounting year and month corresponding to the combination. Create collection result data including the accounting date, the collection target items included in the collection target data associated with the occurrence date, and the collection result data .
The elapsed month collection step is
With reference to the first master, the acquisition step for acquiring the accounting period to which the occurrence date belongs, the number of periods associated with the acquired accounting period, and the monthly number, etc.
With reference to the first master, the destination-first maximum monthly acquisition step for acquiring the maximum monthly number associated with the period acquired in the previous-period number acquisition step, and
With reference to the first master, the number of periods acquired in the previous-first maximum monthly acquisition step and the fiscal year and month associated with the maximum monthly number acquired in the previous-first maximum monthly acquisition step are acquired, and further. , With reference to the second master, the destination-number acquisition step to acquire the number of periods associated with the acquired fiscal year and month,
With reference to the second master, the destination-second maximum monthly acquisition step for acquiring the maximum monthly number associated with the period acquired in the previous-period acquisition step, and
The destination-judgment step for determining whether or not the maximum monthly number acquired in the first-first maximum monthly acquisition step and the maximum monthly number acquired in the first-second maximum monthly acquisition step are the same.
When it is determined that the first-determination step is the same, the number of periods acquired in the first-period acquisition step and the monthly number acquired in the first-period acquisition step, etc., with reference to the second master. To acquire the fiscal year and month associated with-the year and month acquisition step,
To include,
A data collection method characterized by. It is a data collection program to be executed by an information processing device including a control unit and a storage unit.
In the storage unit
With the first master including the number of accounting periods for the first company, the monthly number within the accounting period, the accounting period corresponding to the number of periods and the combination of the monthly numbers, and the accounting year and month corresponding to the combination. ,
A second master that includes the number of fiscal years for the second company, the monthly number within the fiscal year, the number of periods, and the fiscal year and month corresponding to the combination of the months and numbers.
Collection target data including the collection target item for the first company and the occurrence date of the collection target item,
Is stored,
To make the control unit execute
Including same month collection step and elapsed month collection step
The same month collection step
By referring to the first master, acquiring the accounting period to which the occurrence date belongs, and acquiring the accounting year and month associated with the acquired accounting period, the accounting year and month for the first company and the above Create collection result data including the collection target items included in the collection target data linked to the occurrence date,
The elapsed month collection step is
The date of occurrence, the number of periods included in the first master, the monthly number and the accounting period, the number of periods of the accounting period for the second company, the monthly number within the accounting period, the number of the period and the accounting period. About the second company by acquiring the accounting year and month included in the second master based on the number of periods and the month number included in the second master including the accounting year and month corresponding to the combination. Create collection result data including the accounting date, the collection target items included in the collection target data associated with the occurrence date, and the collection result data .
The elapsed month collection step is
With reference to the first master, the acquisition step for acquiring the accounting period to which the occurrence date belongs, the number of periods associated with the acquired accounting period, and the monthly number, etc.
With reference to the first master, the destination-first maximum monthly acquisition step for acquiring the maximum monthly number associated with the period acquired in the previous-period number acquisition step, and
With reference to the first master, the number of periods acquired in the previous-first maximum monthly acquisition step and the fiscal year and month associated with the maximum monthly number acquired in the previous-first maximum monthly acquisition step are acquired, and further. , With reference to the second master, the destination-number acquisition step to acquire the number of periods associated with the acquired fiscal year and month,
With reference to the second master, the destination-second maximum monthly acquisition step for acquiring the maximum monthly number associated with the period acquired in the previous-period acquisition step, and
The destination-judgment step for determining whether or not the maximum monthly number acquired in the first-first maximum monthly acquisition step and the maximum monthly number acquired in the first-second maximum monthly acquisition step are the same.
When it is determined that the first-determination step is the same, the number of periods acquired in the first-period acquisition step and the monthly number acquired in the first-period acquisition step, etc., with reference to the second master. To acquire the fiscal year and month associated with-the year and month acquisition step,
To include,
A data collection program featuring.

Images