Data converter, recording media, and method for converting aggregated data

Abstract

To provide a data converter capable of converting aggregated data output from aggregation software into data according to a format capable of being taken into specific analysis software, recording media, and a conversion method for aggregated data.SOLUTION: A data-converter 100 is configured to cause a computer to execute a read-function F1 and a conversion function F2. The read-function reads aggregated data 20 output from aggregation software 200 for aggregating a record R composed of a combination of an item A classified into an aggregation item TA or a detail item SA as a breakdown of the aggregation item TA and a numerical value v corresponding to the item A. The conversion function converts, in accordance with a specification of the aggregation software 200, aggregated data 20 into captured data 10 formed in a format that can be captured by specific analysis software 300 for displaying results of analysis based on the aggregation data 20.SELECTED DRAWING: Figure 1

Description

[Technical field]

[0001] The present invention relates to a data converter, a recording medium, and a method for converting aggregated data. [Background technology]

[0002] Traditionally, companies have introduced accounting software to manage accounting information. Generally, accounting software has the function of recording and outputting transaction information, but the specifications vary depending on the provider. Therefore, the format of the accounting data output varies depending on the accounting software.

[0003] However, as in the past, when the format of accounting data output by each accounting software differed, the user had to process the accounting data each time it was input into management analysis software that outputs a management analysis report so that it could be imported into the management analysis software.

[0004] Patent Document 1 discloses a technique for correcting and modifying journal data between an accounting firm and a client, transmitting and receiving the data, and controlling inconsistencies in the journal data that arise from the mutual corrections and modifications. [Prior art documents] [Patent documents]

[0005] [Patent Document 1] JP 2003-141322 A Summary of the Invention [Problem to be solved by the invention]

[0006] An object of the present invention is to provide a data converter, a recording medium, and a method for converting tabulated data, which are capable of converting tabulated data output from tabulation software into data conforming to a format that can be imported into specific analysis software. [Means for solving the problem]

[0007] (1) A data converter according to one embodiment of the present invention is configured to cause a computer to execute a reading function for reading aggregated data output from an aggregation software that aggregates records consisting of combinations of items classified as aggregated items or detailed items that are breakdowns of the aggregated items, and numerical values ​​corresponding to the items, and a conversion function for converting the aggregated data into import data formed in a format that can be imported into specific analysis software that displays the results of an analysis based on the aggregated data, in accordance with the specifications of the aggregation software. (2) In (1) above, a map may be provided that links aggregation items corresponding to the specifications of each of the multiple types of aggregation software with categories that can be imported into the analysis software in response to the aggregation items, and the conversion function may include referring to the map to generate a conversion table in which the categories are assigned to records of the aggregation data. (3) In the above (1) or (2), the imported data may be output in CSV format. (4) A computer-readable recording medium according to one aspect of the present invention may record the data converter described above in (1) or (2). (5) A method for converting aggregated data according to one embodiment of the present invention includes a reading step for reading aggregated data output from an aggregation software that aggregates records (rows) consisting of combinations of items classified as aggregated items or detailed items that are breakdowns of the aggregated items and numerical values ​​corresponding to the items, and a conversion step for converting the aggregated data into import data formed in a format that can be imported into specific analysis software that displays the results of an analysis based on the aggregated data, in accordance with the specifications of the aggregation software. Effect of the Invention

[0008] According to the present invention, it is possible to provide a data converter, a recording medium, and a method for converting tabulated data, which are capable of converting tabulated data output from tabulation software into data conforming to a format that can be imported into specific analysis software. [Brief description of the drawings]

[0009] [Figure 1] FIG. 2 is a conceptual diagram illustrating a function of a data converter according to an embodiment. [Diagram 2] FIG. 2 is an explanatory diagram illustrating a conversion function of a data converter. [Diagram 3] FIG. 11 is a flow diagram illustrating the flow of a method for converting aggregated data. [Figure 4] FIG. 13 is a diagram showing an example of a screen displayed by the data converter. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0010] (Embodiment) Hereinafter, an embodiment of the present invention will be described in detail with reference to the drawings. Fig. 1 is a conceptual diagram showing the functions of a data converter 100 according to an embodiment. Fig. 2 is an explanatory diagram showing a conversion function F2 of the data converter 100. Note that, hereinafter, parts having common functions may be given the same reference numerals or symbols.

[0011] (Data Converter) As shown in FIG. 1, the data converter 100 according to the embodiment basically reads aggregated data 20 output from aggregation software 200, converts the aggregated data 20 into import data 10 that can be imported into analysis software 300, and outputs the data.

[0012] In detail, the data converter 100 is a program for causing a computer to execute a reading function F1 that reads aggregated data 20 (accounting data, attendance data, etc.) output from aggregation software 200 (accounting software, attendance software, etc.) that aggregates records R (transaction data) consisting of a combination of item A classified as aggregate item TA or detailed item SA that is a breakdown of aggregate item TA and numerical value v (amount, working hours, etc.) corresponding to item A, and a conversion function F2 that converts the aggregated data 20 in accordance with the specifications of the aggregation software 200 into import data 10 formed in a format that can be imported into specific analysis software 300 that displays the results of analysis based on the aggregated data 20. In this way, the data converter 100 is a program that causes a computer to execute a reading function F1 that reads the aggregated data 20 output from the aggregation software 200, and a conversion function F2 that converts the aggregated data 20 output from the aggregation software 200 into import data 10 formed in a format that can be imported into a specific analysis software 300 according to the specifications of the aggregation software 200, so that even if the specifications of the aggregation software 200 differ, the aggregated data 20 output from the aggregation software 200 can be read, and the aggregated data 20 can be converted into import data 10 that conforms to a format that can be imported into the specific analysis software 300. Therefore, the service provider of the data converter 100 can encourage a variety of users who use aggregation software 200 with different specifications to use the specific analysis software 300 as a common platform.

[0013] The data converter 100 may be stored in the memory of a computer serving as a cloud server managed by a service provider, or in the memory of a computer serving as a user terminal. The data converter 100 may be recorded in a computer-readable recording medium.

[0014] The data converter 100 is provided with a map M that links the tabulated subjects TA corresponding to the specifications of each of the multiple types of tabulation software 200 with the categories that can be imported into the analysis software 300 in response to the tabulated subjects TA. Here, the categories may be major categories and subcategories that are further subdivided from the major categories.

[0015] Map M shows, for example, a tabular list of character strings for the summary subject TA of the summary data 20 output from accounting software K provided by company α and character strings for the minor and major categories corresponding to that string, character strings for the summary subject TA of the summary data 20 output from accounting software J provided by company β and character strings for the minor and major categories corresponding to that string, and character strings for the summary subject TA of the summary data 20 output from accounting software F provided by company γ. A plurality of maps M may be provided for each type of tallying software 200. In this case, when tallying data 20 is read, a map M corresponding to the type of tallying software 200 that has output the tallying data 20 is selected.

[0016] The conversion function F2 includes generating a conversion table in which a category is assigned to the record R of the aggregated data 20 by referring to the map M. This makes it possible to convert the aggregated data 20 of each specification output from a plurality of types of aggregation software 200 into import data 10 that can be imported into a single analysis software 300.

[0017] (Counting software) For example, when the tabulation software 200 is accounting software, it tabulates records R (also called transaction information or journal data) consisting of a combination of an item A (e.g., ordinary deposit, current account 1, current account 2, liquidity deposit) and a value v (amount value) corresponding to the item A, and outputs tabulated data 20 (see FIG. 2). The item A is classified into tabulated item TA (liquidity deposit) or detailed item SA (ordinary deposit, current account 1, current account 2) which is a breakdown of tabulated item TA. The tabulation software 200 is capable of tabulating on a monthly or annual basis. The tabulation software 200 may be any software that tabulates records R consisting of a combination of an item A and a value v corresponding to the item A, and may be, for example, labor management software that tabulates records R consisting of a combination of an item A (employee name) and a value v (working hours) corresponding to the item A, which are classified into tabulated item TA (department) or detailed item SA (division) which is a breakdown of tabulated item TA.

[0018] Accounting software is a program that has a function of recording transaction information, such as journal entry data, entered by a user, and also has a function of outputting an income statement or a balance sheet based on the transaction information.

[0019] The accounting software aggregates multiple records R and outputs an income statement or balance sheet as appropriate.

[0020] The summary item TA and the detailed item SA of accounting software are, for example, shown together as part of a balance sheet. For example, as shown in Figure 2, the summary item TA of accounting software is liquid deposits, and the detailed items SA that are the breakdown of liquid deposits are ordinary deposits, current account 1, current account 2, etc. As shown in a typical balance sheet, the summary item TA of accounting software includes liquid deposits as well as fixed assets, current liabilities, fixed liabilities, shareholders' equity, retained earnings, etc. As shown in a typical income statement, the summary item TA of accounting software includes sales, cost of sales, selling, general and administrative expenses, non-operating income, non-operating expenses, extraordinary income, extraordinary loss, etc.

[0021] (Aggregated data) The aggregated data 20 is data obtained by aggregating the records R and output from the aggregation software 200. The aggregated data 20 is output from the aggregation software 200 in an appropriate data format such as csv, pdf, or xls.

[0022] As shown in Fig. 2, the aggregated data 20 is, for example, a table in which multiple records R formed by a combination of an item A and a numerical value v are arranged. As shown in Fig. 2, there are cases where a record R is shown in each row and cases where a record R is shown in each column. An aggregated item TA is shown before or after consecutive detailed items SA. There may be one or multiple detailed items SA for one aggregated item TA. The numerical value v in a record R including an aggregated item TA shown before or after consecutive detailed items SA indicates the aggregated value of the numerical values ​​v in the record R including the consecutive detailed items SA.

[0023] For example, in the aggregated data 20 shown in Figure 2, the numerical value v of "Liquidity Deposits", which is the aggregated item TA in the fourth line following the first to third lines, is "130,000", and this numerical value v represents the aggregate value of the numerical values ​​v of "Ordinary Deposits", "Current Account 1", and "Current Account 2", which are the detailed items SA in the first to third lines, which are "10,000", "50,000", and "70,000", respectively.

[0024] (Analysis software) The analysis software 300 is a program that analyzes management indicators, labor productivity, and the like based on input data (including the imported data 10) and visualizes them in graphs or the like.

[0025] The analysis software 300 is, for example, platform software capable of outputting a management analysis report, such as Kizuna PARK operated by Forval Corporation.

[0026] (Imported data) The imported data 10 is data formed in a format that can be imported into a specific analysis software 300 that displays the results of an analysis based on the aggregated data 20. The imported data 10 is output from the data converter 100 in a data format such as CSV format as appropriate. The imported data 10 may be directly imported into the analysis software 300 by API communication.

[0027] 2, the imported data 10 is, for example, arranged in a table format with minor and major categories assigned to each record R of the aggregated data 20. In the imported data 10, a number of imported records RR with minor and major categories assigned are arranged following record R. The minor and major categories assigned to the imported data 10 are assigned with reference to a map M, which is a correspondence table that links the character strings of the aggregated subjects with the character strings of the minor and major categories. Minor categories are subdivisions of major categories and are subordinate concepts to major categories.

[0028] Here, in the imported data 10, the minor and major categories assigned to the imported record RR of the tally subject TA are the strings in the minor and major category columns corresponding to the strings in the tally subject column shown in map M if the strings are the same as those in the tally subject TA shown in record R. In the imported data 10, the minor and major categories assigned to the imported record RR of the detailed item SA are the character strings in the minor and major category columns corresponding to the character string of the summary item TA preceding or following the detailed item SA.

[0029] For example, in the imported data 10 shown in Fig. 2, the fourth line including the summary item TA has the character string "Cash and deposits" as the minor category and "Assets" as the major category. The first to third lines including the detailed item SA have the same character strings as the minor and major categories of the following summary item TA, that is, "Cash and deposits" as the minor category and "Assets" as the major category.

[0030] In this way, the data converter 100 can convert the tabulated data 20 into the imported data 10 , so that the imported data 10 can be imported into the analysis software 300 even if the format of the tabulated data 20 differs depending on the tabulation software 200 .

[0031] (How to convert aggregated data) Next, a method for converting the aggregated data 20 using the data converter 100 will be described with reference to Fig. 3. Fig. 3 is a flow diagram illustrating the flow of the method for converting the aggregated data 20. The data converter 100 is a program for causing a computer to execute the following reading step S1 and conversion step S2.

[0032] The method for converting the aggregated data 20 according to the present embodiment includes a reading step S1 for reading the aggregated data 20 (accounting data, attendance data) output from an aggregation software 200 (accounting software, attendance management software, etc.) that aggregates a record R consisting of a combination of an item A classified as an aggregated item TA or a detailed item SA that is a breakdown of the aggregated item TA and a numerical value v (amount, working hours, etc.) corresponding to the item A, and a conversion step S2 for converting the aggregated data 20 into import data 10 formed in a format that can be imported into a specific analysis software 300 (business analysis software such as Kizuna PARK, etc.) that displays the results of an analysis based on the aggregated data 20, according to the specifications of the aggregation software 200. As a result, even if the specifications of the aggregation software 200 are different, the aggregated data 20 output from the aggregation software 200 can be read, and the aggregated data 20 can be converted into import data 10 conforming to a format that can be imported into the specific analysis software 300. Therefore, a user of the method for converting the aggregated data 20 can use the specific analysis software 300 as a common platform, regardless of the specifications of the aggregation software 200.

[0033] As a premise, a map M linking the character string of the summary subject TA in the summary data 20 with the character strings of the minor and major categories in the imported data 10 is stored in the master.

[0034] The details of the reading step S1 are as follows. (1) A file (e.g., a CSV file) including the aggregated data 20 output from the aggregation software 200 is read, and each record R included in the aggregated data 20 is written into a database in order from the top down, and saved as a conversion table.

[0035] The details of the subsequent conversion step S2 are as follows. (2) If the aggregated subject TA is not at the top (the first row of a matrix with n rows, with 1 at the top), the order of records R in the conversion table is reversed so that the aggregated subject TA is at the top. Note that if the aggregated subject TA is at the top, as in the aggregated data 20 shown in Figure 2, this sorting process is unnecessary.

[0036] (3) Read subject A in the first record R in the conversion table.

[0037] (4) Then, by referring to the map M stored in the master, the conversion table searches the string column of the total subject TA for a string that is the same as the subject A of record R, and picks up the strings of the minor and major categories that correspond to that total subject TA. Next, the strings of the minor and major categories are added to the record R that contains that total subject TA, making it a new imported record RR, and updating the conversion table.

[0038] (5) Next, the next (second) record R in the conversion table is read. Then, it is determined whether the item A included in the read record R is a summary item TA or a detail item SA. If subject A in the next (second) record R is an aggregated subject TA (if the aggregated subject TA column in map M contains a string that is the same as the string of subject A in that record R), map M is referenced in the same manner as in (4) above, and the strings of the minor and major categories that correspond to the string of the aggregated subject TA are added to record R that contains that aggregated subject TA, making it a new imported record RR, and the conversion table is updated. If the item A of the next (second) record R is not a summary item TA, i.e., it is a detailed item SA, the strings of the minor and major categories corresponding to the strings of the previous summary item TA are added to the record R containing the detailed item SA, a new import record RR is created, and the conversion table is updated.

[0039] (6) In this manner, the process (5) above is repeated, and the strings of minor and major categories are added to all records R to create imported records RR, and the conversion table is updated.

[0040] (7) The latest conversion table is output in CSV format as appropriate and used as imported data 10. In this manner, the conversion of the aggregated data 20 into the imported data 10 is completed.

[0041] As described above, the data converter 100 according to the embodiment is for causing a computer to execute a read function F1 for reading the aggregated data 20 output from the aggregation software 200 that aggregates the records R consisting of a combination of the item A classified as the aggregated item TA or the detailed item SA that is a breakdown of the aggregated item TA and the numerical value v corresponding to the item A, and a conversion function F2 for converting the aggregated data 20 into the import data 10 formed in a format that can be imported into a specific analysis software 300 that displays the results of an analysis based on the aggregated data 20, according to the specifications of the aggregation software 200. As a result, even if the specifications of the aggregation software 200 are different, the aggregated data 20 output from the aggregation software 200 can be read, and the aggregated data 20 can be converted into the import data 10 conforming to a format that can be imported into the specific analysis software 300. Therefore, the service provider of the data converter 100 can encourage various users who use the aggregation software 200 with different specifications to use the specific analysis software 300 as a common platform.

[0042] The method for converting the aggregated data 20 according to the embodiment includes a reading step S1 for reading the aggregated data 20 output from the aggregation software 200 that aggregates the records R consisting of a combination of an item A classified as an aggregated item TA or a detailed item SA that is a breakdown of the aggregated item TA and a numerical value v corresponding to the item A, and a conversion step S2 for converting the aggregated data 20 into import data 10 formed in a format that can be imported into a specific analysis software 300 that displays the results of an analysis based on the aggregated data 20, according to the specifications of the aggregation software 200. As a result, even if the specifications of the aggregation software 200 are different, the aggregated data 20 output from the aggregation software 200 can be read, and the aggregated data 20 can be converted into import data 10 conforming to a format that can be imported into the specific analysis software 300. Therefore, a user of the method for converting the aggregated data 20 can use the specific analysis software 300 as a common platform, regardless of the specifications of the aggregation software 200.

[0043] Next, an example of the screen W displayed by the data converter 100 will be shown. FIG. 4, the data converter 100 displays a user interface screen W (window) on a display. When using the data converter 100, the user can intuitively convert the aggregated data 20 into the imported data 10 while looking at the screen W displayed on the display.

[0044] Specifically, when a user is using accounting software K, when converting the tally data 20 output from the accounting software K into the import data 10, as shown in FIG. 4, the user selects and presses a button x1 with a character string "accounting software K" from among the tally software selection buttons x showing the types of a plurality of tally software 200, and in this state, drags and drops a file including the tally data 20 that has been output from the accounting software K and prepared and displayed outside the screen W from outside the screen W to an area surrounded by a dashed line d in the screen W. Alternatively, the user presses the file selection button b to select the corresponding file saved in the user's terminal. Then, a convert button c indicating the execution of conversion becomes active, and when the convert button c is pressed, a file including the tally data 20 is uploaded, and the above-mentioned conversion method is executed by the data converter 100. Instead of the convert button c, a button indicating the execution of download may be used so that the import data 10 can be downloaded as a CSV file to a specified save destination after the execution of conversion. Also, instead of the convert button c, a button indicating execution of the API may be used so that after the conversion is executed, the captured data 10 can be directly transmitted to the analysis software 300 by API communication.

[0045] The technical scope of the present invention is not limited to the above-described embodiment, and various modifications can be made without departing from the spirit of the present invention.

[0046] In addition, the components in the above-described embodiment may be replaced with known components as appropriate without departing from the spirit of the present invention. Furthermore, the above-described modified examples may be combined as appropriate without departing from the spirit of the present invention. [Explanation of symbols]

[0047] 100 Data Converter α, β, γ Company 10 Imported Data 20 Aggregated Data 200 Tabulation software 300 Analysis Software A subject F,J,K accounting software F1 Read function F2 conversion function M-Map R record RR Import record S1 Read step S2 Conversion Step SA Itemized Items TA Aggregation Subjects W Screen b File selection button c Convert button d Dashed line v Number x Tabulation software selection button x1 button

Claims

1. A reading function for reading into the computer aggregate data output from an aggregation software that aggregates records consisting of combinations of items classified as aggregate items or detailed items that are the breakdown of the aggregate items and numerical values ​​corresponding to the items; A conversion function for converting the aggregated data into import data formed in a format that can be imported into a specific analysis software that displays a result of an analysis based on the aggregated data, in accordance with the specifications of the aggregation software. Data converter.

2. a map that links items to be collected corresponding to the specifications of each of the plurality of types of collection software with categories that can be imported into the analysis software in response to the items to be collected; The conversion function includes generating a conversion table in which the categories are assigned to records of the aggregate data by referring to the map.

2. The data converter of claim 1.

3. The imported data is output in csv format.

3. A data converter according to claim 1 or 2.

4. 3. A computer-readable recording medium having recorded thereon the data converter according to claim 1 or 2.

5. a reading step of reading in aggregated data output from an aggregation software that aggregates records consisting of combinations of items classified as aggregated items or detailed items that are the breakdown of the aggregated items and numerical values ​​corresponding to the items; and a conversion step of converting the aggregated data into import data formed in a format that can be imported into a specific analysis software that displays a result of an analysis based on the aggregated data, in accordance with a specification of the aggregation software. How to transform aggregate data.

Images