JP4885285B2 - Accounting information collection / analysis system, method and program thereof - Google Patents

Description

  The present invention relates to a system for performing financial processing relating to accounting information, and more specifically, it is possible to collect and analyze various transaction data to calculate management indicators as needed, and to collect and analyze accounting information that supports analysis of financial statements. The present invention relates to an analysis system, a method thereof, and a program.

  Conventionally, when a company grasps the management situation, it has been grasped by a management index used as an index for grasping the management situation. For example, as shown in FIG. 16, in an accounting system, transaction data for performing accounting processing is input from another business system (for example, sales management system, accounting system or salary system), and accounting processing such as settlement processing is performed. The amount of profits, assets and liabilities was clarified, financial statements were prepared as a result of settlement, and management indicators used for management analysis were calculated using the numerical values of the account items of the financial statements.

  In recent years, XBRL (eXtensible Business Reporting Language) has begun to be used as an electronic format for financial information, and an accounting system having a financial statement output function based on the XBRL specification has increased. XBRL is a standardized structured language based on XML (eXtensible Markup Language), and is a standard specification for describing financial information in an XML format. XBRL consists of an XML schema that defines the structure of an instance document, and a taxonomy that is composed of a link base that is defined by using the external link function of XLink, including the relationship between items and additional information for each item. A standardized financial statement taxonomy is provided.

However, in the conventional accounting system, it is only possible to aggregate the results in a certain cycle such as monthly or semi-annual, and it is not suitable for grasping the daily management situation in real time.
In other words, there are many companies that set a target value for management indicators and grasp the management situation. However, in the calculation of the management indicators described above, the accounting system calculates the transaction data for each preset cycle. Therefore, it is not possible to flexibly respond to changes in the management indicators that are emphasized due to the management policy and management environment that change from day to day.

  Therefore, a management index calculation system that allows users to flexibly change the management index and calculation logic to be calculated when calculating the management index based on the plan information as a system that can grasp the management situation at any time. Has been developed (see, for example, Patent Document 1).

JP 2005-11278 A

However, in Patent Document 1 described above, when investigating the factors that increase or decrease the numerical value of the calculated management index, the journal information held in the accounting system uses information necessary for the investigation (for example, in units of departments). Sales and purchases, etc.) are in short supply, and it takes a lot of time to investigate the details, and more time is needed than the detailed analysis of the financial results.
In addition, the above-mentioned Patent Document 1 is configured so that the user can perform editing processing such as registration, deletion, and search for the definition of the management index calculation procedure and the connection of the calculation logic. However, it is not configured to use data from a plurality of business systems, and necessary information is insufficient.

In addition, as a management, after closing the accounts in the accounting system, the financial statements obtained are analyzed, and the management status is reported to interested parties.
The information on the financial statements is at the journal information level of accounting. The journal information includes information on the detailed contents of the original transaction data (transaction attribute data, for example, which business unit the sales are from, which customer There are few sales).
In other words, as described above, the conventional accounting system is not linked to the business system in which the current transaction information is stored, and when performing the above-described analysis, it is necessary to extract the content of the current transaction from the business system. There will be more time than necessary for analysis.

  The present invention has been made in view of such circumstances, and in cooperation with a plurality of business systems, collects various transaction data, converts and accumulates them in a unified structured language data format, and uses the data to manage The index can be calculated at any time, and it can be linked with the original transaction data related to the accounts of the financial statements, so that information that enables detailed analysis of the management index is obtained, and changes in the management policy and management environment are easily reflected. The purpose is to provide an accounting information collection and analysis system that seeks management indicators that flexibly respond to changes.

The accounting information collection / analysis system of the present invention converts transaction data input from a plurality of business systems, which are original transaction data related to standardized financial statement account items, into a unified structured language data format and converts it into a database. An accounting information collection / analysis system that supports analysis of business conditions by accumulating the financial data for generating financial information data obtained by converting the transaction data into financial information data in the data format of the structured language A rule for defining an element name of information data, and when the element name is an element name of an account, a data conversion structure rule that uses the same element name as the element name of the account item of the standardized financial statement, Data conversion structure rule storage unit that stores in advance for each transaction type, item name of the transaction data, and element name of the data conversion structure rule A mapping file storage unit that stores a mapping file indicating a correspondence relationship for each transaction type in advance, and reads transaction data input from the plurality of business systems, and reads the mapping file corresponding to the transaction type of the transaction data Read from the mapping file storage unit, read the data conversion structure rule corresponding to the type from the data conversion structure rule storage unit, detect the item corresponding to the read mapping file from the transaction data, the item of the detected transaction data A data conversion unit that generates the financial information data and sequentially stores the financial information data in the financial information data storage unit by converting the element name defined in the read data conversion structure rule, and the standardized financial statement Account item elements, the calculation of the element, and the calculation A financial statement structure rule storage unit that stores in advance financial statement structure rules that define lower-level elements for the data format for each type of financial statement, elements necessary for calculation of management indicators, and their arithmetic expressions are expressed in the data format If the element is an element name of an account item, the management index calculation rule that uses the same element name as the account item element of the financial statement structure rule is Management index comparison rule storage unit storing in advance for each type, management index type, management index calculation rule, and management index comparison in which the target calculation target element calculated by the management index calculation rule is associated A management index comparison table storage unit for storing a table and the management index calculation rule corresponding to the selected management index using the management index comparison table; Management and the calculation target element, the corresponding management index calculation rule is read from the management index calculation rule storage unit, and the element related to the calculation target element is extracted from the read management index calculation rule as the first account item An index account item extraction unit and a financial statement structure rule including the first account item as an element are read from the financial statement structure rule storage unit, and an element of the first account item is determined from the read financial statement structure rule. A financial statement including a financial statement account extracting unit that extracts an element used for calculation as a second account item, and a second account item extracted by the financial statement account extracting unit from the financial information data storage unit in the element name Account information accumulating unit that reads out information data, accumulates financial information data for each account, and outputs the accumulated data. A financial index data generation unit that calculates and outputs the financial index data obtained by calculating the output of the integrated data based on the calculation formula of the financial statement structure rule and calculating the data of the first account item, and the financial index data Calculates the value of the selected management index by calculating the financial index data output from the generation unit based on the calculation formula of the management index calculation rule, and generates management index data corresponding to the management index calculation rule And a management index data generation unit.

  In the accounting information collection / analysis system according to the present invention, the account item accumulating unit, from the financial information data storage unit, in the processing range input by the user, the financial information data including the elements used for the calculation of the calculation target element Reading, integrating each element, and outputting the integration result to the financial index data generating unit.

The accounting information collection / analysis system of the present invention converts transaction data input from a plurality of business systems, which are original transaction data related to account items of standardized financial statements, into a unified structured language data format, An accounting information collection / analysis system that supports analysis of business conditions by accumulating in the database, wherein the transaction data is converted into financial information data in the structured language data format to generate financial information data A rule for defining element names of financial information data, and when the element name is an account element name, a data conversion structure rule that uses the same element name as the account name of the standardized financial statement A data conversion structure rule storage unit that stores in advance for each transaction type, an item name of the transaction data, and an element of the data conversion structure rule A mapping file storage unit that stores a mapping file indicating a correspondence relationship for each transaction type in advance, transaction data input from the plurality of business systems, and a mapping file corresponding to the transaction type of the transaction data Read from the mapping file storage unit, read the data conversion structure rule corresponding to the type from the data conversion structure rule storage unit, detect the item corresponding to the read mapping file from the transaction data, the item of the detected transaction data Is converted according to the element name defined in the read data conversion structure rule, thereby generating financial information data and sequentially storing it in the financial information data storage unit, and the standardized financial statement Account element and calculation processing to find the element are defined. A financial statement structure rule storing a financial statement structure rule that defines an arithmetic expression and subordinate elements used in the arithmetic expression for the data format in advance for each type of financial statement, and an external component of the structured language. Analytical item input section that reads financial data in data format, accepts selection of account for analysis, and outputs selected account for analysis, and account for analysis output from analysis item input section The financial statement structure rule including the item as an element is read from the financial statement structure rule storage unit, the account item element corresponding to the account item to be analyzed is extracted from the financial statement structure rule, and the extracted account item element is extracted. Analyzes whether or not an arithmetic expression for the account item is defined, and if an arithmetic expression is defined for the extracted account element, it is used in the arithmetic expression. If a subordinate element is an analysis target element and no arithmetic expression is defined for the extracted account element, the account information element is the analysis target element, and the financial information is set using the analysis target element as a key. And a financial statement linkage unit that reads out corresponding financial information data from the data storage unit and outputs it as transaction data related to the account item to be analyzed.

  The accounting information collection / analysis system of the present invention is characterized in that the financial statement linkage unit reads financial information data to be analyzed from the financial information data storage unit within a processing range input by a user.

  In the accounting information collection / analysis system of the present invention, the data conversion structure rule includes an arithmetic expression that defines a relationship between elements, and the data conversion unit converts data of items detected from the transaction data to the data The financial information data is generated after calculating the value of the element based on the arithmetic expression of the conversion structure rule.

The accounting information collection / analysis system of the present invention includes a data conversion structure rule storage unit, a mapping file storage unit, a data conversion unit, a financial statement structure rule storage unit, a management index calculation rule storage unit, a management index comparison table storage unit, and a management index. Multiple business systems that are original transaction data related to account items of standardized financial statements, comprising an account item extraction unit, a financial statement account extraction unit, an account accumulation unit, a financial index data generation unit, and a management index data generation unit The accounting information collection and analysis method in the accounting information collection and analysis system that supports the analysis of the business situation by converting the transaction data input from the database into a unified structured language data format and storing it in the database, For generating financial information data obtained by converting the transaction data into financial information data in the data format of the structured language A rule for defining an element name of the financial information data, wherein the element name is the same as the element name of the account item of the standardized financial statement when the element name is an element name of the account Is stored in advance in the data conversion structure rule storage unit for each transaction type, and a mapping file indicating the correspondence between the item name of the transaction data and the element name of the data conversion structure rule is stored in advance for each transaction type. The process of storing in the mapping file storage unit, the data conversion unit reads transaction data input from the plurality of business systems, and reads the mapping file corresponding to the transaction type of the transaction data from the mapping file storage unit, A data conversion structure rule corresponding to the type is read from the data conversion structure rule storage unit and read. An item corresponding to the ping file is detected from the transaction data, and the detected transaction data item is converted to correspond to the element name defined in the read data conversion structure rule, thereby generating financial information data, Financial statement structure rule that defines the process for sequentially storing in the financial information data storage section, the elements of the account items of the standardized financial statements, the calculation of the elements, and the subordinate elements used for the calculation for the data format Are stored in the financial statement structure rule storage unit in advance for each type of financial statements, and management index calculation rules for defining the elements necessary for calculating the management indices and their arithmetic expressions for the data format, Is the element name of the account item, the management index calculation rule that uses the same element name as the account item element of the financial statement structure rule is Management in which the process stored in the management index calculation rule storage unit in advance for each class, the type of management index, the management index calculation rule, and the calculation target element to be calculated by the management index calculation rule are associated with each other The management index calculation rule and the calculation target element corresponding to the process of storing the index comparison table in the management index comparison table storage unit and the management index selected by the management index account item extraction unit using the management index comparison table Extracting a management index calculation rule from the management index calculation rule storage unit, extracting an element related to the calculation target element from the read management index calculation rule as a first account item, and a financial statement account The item extraction unit reads the financial statement structure rule including the first account item as an element from the financial statement structure rule storage unit and reads it. A process of extracting an element used to calculate the element of the first account item from the extracted financial statement structure rule as a second account item, and an account accumulation unit from the financial information data storage unit to the financial statement account A process of reading financial information data including the second account item extracted by the item extraction unit in the element name from the financial information data storage unit, integrating the financial information data for each account item, and outputting the integration data; The index data generation unit calculates the data of the first account item by calculating the integration data output from the account item integration unit based on the calculation formula of the financial statement structure rule, and corresponds to the financial statement structure rule Generating and outputting the financial index data, and the management index data generating unit calculates the financial index data output from the financial index data generating unit by calculating the management index It calculates the value of the selected management index by calculating based on the arithmetic expression Lumpur, and having a step of generating a management index data corresponding to the management index calculation rules.

The accounting information collection / analysis method of the present invention comprises a standardized financial system comprising a data conversion structure rule storage unit, a mapping file storage unit, a data conversion unit, a financial statement structure rule storage unit, an analysis item input unit, and a financial statement linkage unit. Accounting information that supports analysis of business conditions by converting transaction data input from multiple business systems, which are the original transaction data related to the account items in the tables, into a unified structured language data format and storing it in the database A method for collecting and analyzing accounting information in a collection and analysis system, wherein element names of the financial information data for generating financial information data obtained by converting the transaction data into financial information data in the structured language data format are defined. If the element name is an account element name, the same as the element name of the standardized financial statement account The data conversion structure rule using the element name of the process is stored in advance in the data conversion structure rule storage unit for each type of transaction, the correspondence between the item name of the transaction data and the element name of the data conversion structure rule The mapping file to be stored is stored in advance in the mapping file storage unit for each transaction type, and the data conversion unit reads the transaction data input from the plurality of business systems, and mapping corresponding to the transaction type of the transaction data A file is read from the mapping file storage unit, a data conversion structure rule corresponding to the type is read from the data conversion structure rule storage unit, an item corresponding to the read mapping file is detected from the transaction data, and the detected transaction data Elements defined in the data transformation structure rules that read the items of The process of generating financial information data and sequentially storing it in the financial information data storage unit, the elements of the account items of the standardized financial statements, and the arithmetic processing for obtaining the elements are defined. A process for storing financial statement structure rules in which the formulas and subordinate account items used in the formulas are defined for the data format in the financial statement structure rule storage unit for each type of financial statements, and analysis The course input unit reads financial statement data in the structured language data format from the outside, accepts the selection of the account item to be analyzed, and outputs the selected account item to be analyzed. A financial statement structure rule including the analysis target account item output from the analysis item input unit as an element is read from the financial statement structure rule storage unit, and the financial statement The account element corresponding to the account to be analyzed is extracted from the structure rule, and whether or not an arithmetic expression of the element of the account is defined in the extracted account element is analyzed. If an arithmetic expression is defined for the element, the subordinate elements used in the arithmetic expression are the analysis target elements, and if no arithmetic expression is defined for the extracted account item, the account item A process of reading the corresponding financial information data from the financial information data storage unit using the analysis target element as a key, and outputting the data as transaction data related to the account item to be analyzed. Features.

  The program of the present invention is an accounting information collection / analysis program for causing a computer to function as the accounting information collection / analysis system described above.

As described above, according to the present invention, transaction data input from an external business system is unified using a data conversion structure rule that includes the same name as the account name of a standardized financial statement structure rule. By converting it into a structured language (XBRL or the like) and accumulating it as financial information data, it becomes possible to reuse the data without depending on the OS (operating system) or platform.
For example, even if the financial statement is not completed by defining the management index and its calculation formula that the user wants to set in advance as the management index calculation rule using the same name as the element name of the financial statement structure rule The user can calculate a desired management index at any time using the accumulated financial information data.

  Further, according to the present invention, when calculating the management index, the account items necessary for this calculation are used in the detailed account items of the financial statement structure rules, that is, the calculation formulas in cooperation with the financial statement structure rules. Since transactions related to account items are collected from financial data and management index values are calculated, it is possible to define management index calculation rules without being aware of the detailed account items of the financial statement structure rules.

  In addition, according to the present invention, by using the financial statement structure rules, the financial statement created by an external accounting system and the accumulated financial data are linked with the financial statement linkage using the element name of the account item as a key. This makes it possible to collect the original transaction data of each account item of the financial statements, thereby enabling more detailed management analysis of financial statements, which has been impossible in the past.

According to the present invention, it is also possible to construct a verification function as an internal control environment by defining business rules and calculation formulas between elements in the arithmetic expression of the data conversion structure rule. As a result, according to the present invention, since the arithmetic expression is information given as an external file, verification items and contents can be flexibly changed in accordance with changes in the importance of monetary and qualitative effects on financial reports. Become.
Furthermore, according to the present invention, since it is not necessary to modify the transaction data output by the existing business system, it becomes possible to cope with changes in management policy and management environment without affecting the business system.

It is a block diagram which shows the structural example of the accounting information collection and analysis system by one Embodiment of this invention. It is a conceptual diagram explaining the data conversion process in the data conversion part 2. FIG. It is a conceptual diagram which shows the example of the XBRL description of the structure definition part (schema) of a financial statement taxonomy. It is a conceptual diagram which shows the example of the XBRL description of the structure definition part (link base) of a financial statement taxonomy. It is a conceptual diagram explaining the structure of a mapping table. It is a conceptual diagram which shows the structure of the data of the table format in a business system. It is a conceptual diagram explaining the operation | movement of the financial statement cooperation process by the analysis subject input part 4 and the financial statement cooperation process part 5. FIG. It is a conceptual diagram explaining operation | movement of the financial statement cooperation process part. It is a conceptual diagram explaining the structure of a management index taxonomy comparison table. It is a conceptual diagram explaining the structure of a management index calculation taxonomy and a financial statement taxonomy. It is a conceptual diagram for demonstrating the flow of operation | movement of an accounting information collection / analysis system. It is a conceptual diagram explaining the data conversion process in the data conversion part 2. FIG. It is a conceptual diagram explaining the operation | movement of the analysis process of a management index calculation taxonomy and a financial statement taxonomy. It is a conceptual diagram explaining the process of the account item integrating | accumulating part 7 which accumulate | stores a corresponding account item from a financial information instance. It is a conceptual diagram explaining the production | generation process of the management index instance using the management index calculation taxonomy and the financial statement taxonomy. It is a conceptual diagram explaining the process of the accounting system which performs an accounting process using transaction data inputted from business systems, such as sales management system 100, accounting system 101, and salary system 102.

  In the present invention, transaction data (for example, data such as sales, sales date, product name, price, etc. in the case of a sales management system) input from a business system such as a sales management system, an accounting system, and a salary system, Each transaction is converted into an instance document (financial information instance in this embodiment) which is a structured file (XBRL specification in XML format) that can be reused on a computer, and sequentially into an instance database (financial information instance database). Accumulate. And when it is necessary to calculate management indicators, it is possible to search for instance documents necessary for the management indicators to be calculated from the instance database, and to create management indicator instances by calculating the management indicators using the management indicator calculation taxonomy created in advance. To do. That is, the subordinate elements of the management index calculation taxonomy are extracted, the element names of the account items of the financial statement taxonomy that are used as standard are extracted using the element name of this account as a key, and the element name of this account is the key The financial information instance database is searched to create a financial index instance and a management index instance. Furthermore, by using the financial information instance database in which the financial information instances are accumulated and searching for the corresponding instance document from the instance database using the element name of the account item in the financial statement taxonomy as a key, Supports detailed analysis of accounting information by linking with current transaction data corresponding to account items.

  Hereinafter, an accounting information collection / analysis system according to an embodiment of the present invention will be described with reference to the drawings. FIG. 1 is a block diagram showing a configuration example of an accounting information collection / analysis system according to the embodiment. In this figure, the accounting information collection / analysis system 50 of the above embodiment includes a data conversion taxonomy database 1, a data conversion unit 2, a financial information instance database 3, an analysis subject input unit 4, a financial statement linkage unit 5, a management index calculation unit. 8. A financial statement taxonomy database 9, a management index taxonomy comparison database 10, a management index input unit 11, a management index calculation taxonomy database 12, and a mapping file database 15. The management index calculation unit 8 includes a management index calculation taxonomy extraction unit 70, a financial index extraction / calculation unit 20, a management index extraction / calculation unit 21, and an account item integration unit 81. Further, the financial index extraction / calculation unit 20 includes a financial statement account item extraction unit 72 and a financial index instance generation unit 82, and the management index extraction / calculation unit 21 includes a management index account item extraction unit 71 and a management index. The instance generating unit 83 is configured. In FIG. 1, the accounting information collection / analysis system 50 is connected to a sales management system 100, an accounting system 101, and a salary system 102 as business systems, and an accounting system 200 that performs accounting processing using transaction data. Yes.

  The data conversion taxonomy database 1, the financial statement taxonomy database 9, and the management index calculation taxonomy database 12 each store a taxonomy that defines a data structure in the XBRL specification. This taxonomy includes an XBRL schema (hereinafter referred to as schema and description) that defines the structure of an XBRL instance (hereinafter referred to as instance and description), and information related to calculation processing such as calculation links and formula links, which are associated with this schema. It consists of two types of files, the link base.

A schema defines the structure of an instance and defines items such as specific account items and notes. In this schema, link-based references are also defined. The calculation link, which is one of the above link bases, defines an addition / subtraction formula for element values. For example, a process that only performs simple addition and subtraction of numerical values between each element of an account item is defined. Has been. Formula link, which is another type of link base, defines a logical structure between elements and a calculation that performs logical operations on element data (such as names and types of people and things). For example, a business rule for determining a result obtained from element data of each element is defined by a mathematical expression or a logical operation expression.
In other words, calculation links and formula links are set as external files different from the schema, and flexibly change the elements to be evaluated as the importance of monetary and qualitative effects on the required financial reporting changes. It is possible to change the calculation formulas, parameters as elements necessary for the calculation, and the contents of the logical calculation formula.

In the data conversion taxonomy database 1, data conversion used when changing transaction data input from a business system such as the sales management system 100, accounting system 101, and salary system 102 to a financial information instance (XBRL instance). A taxonomy is created in advance for each business system and for each type of transaction in the business system, and is stored corresponding to identification information indicating each business system and each type of transaction.
FIG. 2A is a conceptual diagram showing a configuration example of the data conversion taxonomy. A financial information instance having elements described in the schema is generated from the schema in FIG. That is, in the schema of the data conversion taxonomy described in FIG. 2A, the transaction data for “sales” is converted into a financial information instance (sales) as the type of transaction input from the sales management system 100. The element for is defined. In other words, the elements are “sales”, “date”, “business department”, “in charge”, “approval”, “customer”, “product”, “unit price”, “quantity”, “business rule 1”, “business” Rule 2 ”is described.

Among the elements used in this data conversion taxonomy, the element name of the account item (for example, “sales”) is the same as the element name (for example, “sales”) used in the financial statement taxonomy provided as a standard specification. Use the same one. The standard financial statement XBRL taxonomy is described in, for example, “http://www.xbrl-jp.org/download/index.htm#Tax Financial Statement XBRL Taxonomy (see December 12, 2006)” It is what.
FIG. 2B is a conceptual diagram showing an example of the structure of the financial statement taxonomy. It consists of a schema that defines the account items of the above-mentioned standard financial statements as element names, and a calculation link that is linked to the schema and defines addition and subtraction processing between elements. FIG. 3 shows an example of a financial statement schema file described in the XBRL specification, and FIG. 4 shows an example of a calculation link described in the XBRL specification. Thus, in the taxonomy, a link base file is set as an external file of the schema file.

  Here, the transaction data input from the business system such as the sales management system 100, the accounting system 101, and the salary system 102 is tabular data as shown in FIG. 6, for example, and is spreadsheet software (for example, EXCEL (registered)). Trademark)) and a fixed-length bit data string. The transaction data is output from each business system to the data converter 2 by a user operation.

  The mapping file database 15 stores mapping files indicating the correspondence between elements described in the data conversion taxonomy schema and items used in the transaction data file. Here, the mapping file is created in advance by the user for each type of transaction data from the business system, and stored in correspondence with identification information indicating the type. For example, the mapping file shown in FIG. 5 is prepared for transaction data of “sales” that associates items in transaction data of “sales” as the transaction type with elements described in the data conversion schema for sales transaction data. It is what has been.

  The data conversion unit 2 reads the transaction data input from the sales management system 100, the accounting system 101, and the salary system 102, reads and references the mapping file corresponding to the identification information of this transaction type, and is described in the schema. An item corresponding to the selected element is detected from the transaction data, and item data corresponding to this item is read (extracted). The data conversion unit 2 reads a data conversion taxonomy corresponding to the identification information corresponding to the type of input transaction data from the data conversion taxonomy database 1 and corresponds to the definition described in the schema of the data conversion taxonomy. The instance document is generated by associating and describing the element and the element data corresponding to the element, for example, the financial information instance R having the configuration shown in FIG. 8 is generated. FIG. 8 is a conceptual diagram showing a configuration of the financial information instance database 3 that accumulates financial information instances generated based on the data conversion taxonomy corresponding to “sales”.

The management index input unit 11 displays the management index selection screen shown in FIG. 9A on the display unit in order to cause the management index calculation unit 8 to execute the management index calculation process, and displays the management index item to be calculated to the user. And the management index name selected by the user is output to the management index calculation taxonomy extraction unit 70. At this time, the user specifies, as the processing range, a management index processing range, for example, a calculation period, a period for performing arithmetic processing such as a calculation target business unit, a department or a person name, etc. be able to. This processing range is input to the account item accumulating unit 81 via the management index calculation taxonomy extraction unit 70, the management index account item extraction unit 71, and the financial statement account item extraction unit 72. 9A, “gross profit margin” is displayed in the selection column as the management index selected by the user.
This management index is set in advance by the user, and management index calculation taxonomy corresponding to each of a plurality of different management indexes to be calculated by the user is accumulated in the management index calculation taxonomy database 12. Yes.

For example, the management index calculation taxonomy shown in FIG. 10A is a taxonomy defined to calculate “gross profit margin”, and the schema includes elements “margin of sales”, “sales” and “ "Gross profit" is set. In the link base (formula link) associated with this schema, an arithmetic expression for calculating “gross profit margin” that is an element in the schema is defined. The formula link in FIG. 10A is configured to calculate “gross profit margin” by dividing “gross profit” by “sales” and multiplying this division result by 100. .
Similar to the data conversion taxonomy, the management index calculation taxonomy uses the same name as the element name of the financial statement taxonomy when the schema element is an account item.

  The management index taxonomy comparison database 10 includes a management index (management index name) input from the management index input unit 11, a management index calculation taxonomy corresponding to the management index (management index name), and a calculation target based on the schema. A management index taxonomy comparison table showing the correspondence with the element names defined as the elements is stored. The management index taxonomy comparison table is set in advance by the user. FIG. 9B shows a specific example of the management index taxonomy comparison table.

The management index calculation taxonomy extraction unit 70 refers to the management index taxonomy comparison table stored in the management index taxonomy comparison database 10 according to the management index, and stores the file name of the management index calculation taxonomy corresponding to the management index selected by the user. The element to be calculated is read and output to the management index account item extraction unit 71.
The management index account item extraction unit 71 reads a management index calculation taxonomy corresponding to the file name input from the management index calculation taxonomy extraction unit 70, and detects an element to be calculated from the schema of the management index calculation taxonomy. read out.
Further, when a link base is described in the schema, the management index account item extraction unit 71 refers to the link base and analyzes whether or not the calculation of the calculation target element is defined. The management index account item extraction unit 71 extracts the calculation target element as “first sub-account item” when the calculation of the calculation target element is not defined in the link base or the link base is not described. And output to the financial statement account item extraction unit 72. On the other hand, when the calculation of the calculation target element is defined in the link base, the management index account item extraction unit 71 extracts the lower element used in the link base calculation as the “first lower account item”. To the financial statement account item extraction unit 72.

The financial statement account item extracting unit 72 extracts the financial statement taxonomy corresponding to the “first sub-account item” extracted by the management index account item extracting unit 71 from the financial statement taxonomy database 9 to obtain the financial statement taxonomy. The first sub-account is extracted from the schema.
Further, when the link base is described in the schema of the financial statement taxonomy, the financial statement account item extraction unit 72 refers to the link base and analyzes whether or not the operation of the first lower account item is defined. To do. If the calculation of the first subordinate account item is not defined in the link base, or if the link base is not described, the financial statement account extracting unit 72 uses the first subordinate account item as it is as “second”. As a subordinate account item ”and output to the account item accumulating unit 81. On the other hand, when the calculation of the first lower account item is defined in the link base, the financial statement account item extraction unit 72 sets the lower element used for the link base operation as the “second lower account item”. Extracted and output to the account item accumulating unit 81.

  The account item accumulating unit 81 extracts (reads out) the instance (data) of the element of the second lower account item input from the financial statement instance extracting unit 72 from the financial information instance database 3, and the data for each element. And is output to the financial index instance generating unit 82 as integrated data. At this time, when there is a processing range specified by the user input from the management index input unit 11, the account item accumulating unit 81 extracts a corresponding financial information instance in the processing range, and the processing range for each element. Accumulate the data within.

  When the link base of the financial statement taxonomy is defined for the integration data of the second subordinate account input from the account item integration unit 81, the financial index instance generation unit 82 uses the calculation link or the formula link, By calculating the value of the first sub-account and writing the value of the first sub-account corresponding to the schema element (first sub-account) of the financial statement taxonomy, At the same time, the data of the first lower account item is output to the management index instance generating unit 83.

The management index instance generating unit 83 uses the value of the first sub-account item input from the financial index instance generating unit 82. If the link base of the management index calculation taxonomy is defined, the calculation link and Calculate the value of the management index to be calculated by formula link.
Further, the management index instance generation unit 83 generates a management index instance by writing the value of the management index in association with the element described in the schema of the management index calculation taxonomy.

  The analysis item input unit 4 displays the financial statement instance input from the external accounting system 200, as shown in the display unit S of FIG. 7, and financially analyzes the account item to be analyzed selected by the user on this selection screen. The tables are output to the financial statement linkage unit 5.

The financial statement cooperation unit 5 reads the financial statement taxonomy corresponding to the item from the financial statement taxonomy database 9 using the item of the account item input from the analysis item input unit 4 as a key. Further, the financial statement cooperation unit 5 extracts (detects) an element corresponding to the selected account item from the schema of the read financial statement taxonomy. Furthermore, when the link base is described in the read financial statement taxonomy schema, the financial statement linkage unit 5 refers to the link base and analyzes whether or not the calculation of the element of the account item is defined. . When the calculation of the element of the account item is not defined in the link base, the financial statement linkage unit 5 reads out the financial information instance of the transaction data including the element of the account item from the financial information instance database 3 and outputs it. On the other hand, when the calculation of the element of the account item is defined in the link base, the financial statement linkage unit 5 provides the financial information of the transaction data including the element of the lower account item used for the link-based calculation. The instance is read out from the financial information instance database 3 and output.
As described above, the processing of the financial statement linkage unit 5 can associate each item of the financial statement taxonomy with the financial information instance generated from each transaction data by using the item name of the account as a key. It becomes possible to analyze even matters that could not be analyzed.

Next, operations of data conversion processing, management status analysis processing, and financial statement linkage processing in the accounting information collection / analysis system according to the present embodiment will be described with reference to the drawings.
<Data conversion process>
The operation of the data change process in the present embodiment will be described with reference to FIGS. 1, 2, 5, 6, 11, and 12. Here, FIG. 11 is a conceptual diagram for explaining the overall system operation of the present embodiment. FIG. 12 is a conceptual diagram showing the flow of data conversion processing.
When a transaction is performed, the sales management system 100, the accounting system 101, and the salary system 102 each output transaction data indicating the transaction result to the accounting information collection / analysis system.

  When the transaction data is input from the sales management system 100, the accounting system 101, and the salary system 102, the data conversion unit 2 performs mapping corresponding to the transaction type from the mapping file database 15 based on the identification information indicating the transaction type. In addition to reading the file, the data conversion taxonomy corresponding to the input transaction data is similarly read from the data conversion taxonomy database 1 based on the identification information.

Based on the read mapping file, the data conversion unit 2 reads the instance that is the data of the element described in the schema of the read data conversion taxonomy from the data of the corresponding transaction data item, or the read data To generate a financial information instance.
At this time, the data conversion unit 2 may generate data of different elements from account item elements or other element data by a calculation link or formula link defined by the link base described in the data conversion taxonomy. .

For example, FIG. 12 shows a formula link for calculating data of business rules 1 and 2 that are elements defined in the financial information instance.
The business rule 1 in this formula link is to determine whether approval other than the person in charge is necessary if “sales” is “100” or more, and to determine whether approval is necessary if it is less than “100”. Here, since the sales are “100” or more and the approval is performed by a person different from the principal, the element of the business rule 1 in the financial information instance is “OK” as the calculation result of the formula link. Is described.

Business rule 2 determines whether the data of the element “sales” is equal to the value obtained by multiplying the data of the element “unit price” by the data of the element “number”. Here, since “100” in “sales” is equal to “100” in “unit price” multiplied by “1” in “number”, the element of business rule 2 in the financial information instance is a formula link. "OK" is described as the result of the operation.
Then, the data conversion unit 2 includes the financial information instance R corresponding to the account items “sales”, “purchase”, etc. as shown in FIG. 8 including the items obtained by the calculation link and the formula link. Each transaction is sequentially stored in the financial information instance database 3.

<Business condition analysis processing>
The operation of the financial statement linkage processing in this embodiment will be described with reference to FIGS. 1, 9, 11, 13, 14, and 15.
The management index input unit 11 displays the management index selection screen shown in FIG. 9A on the display unit in order to cause the management index calculation unit 8 to execute the calculation processing of the management index. To select. When the user selects a management index on the management index selection screen, the management index input unit 11 extracts the selected management index, for example, “margin of sales turnover” in FIG. 9A, as a management index calculation taxonomy extraction unit. Output to 70. At this time, the user inputs a management index processing range, for example, a calculation period and a business unit to be calculated, to the management index input unit 11. This processing range is input to the account item accumulating unit 81 via the management index calculation taxonomy extraction unit 70, the management index account item extraction unit 71, and the financial statement account item extraction unit 72.

The management index calculation taxonomy extraction unit 70 refers to the management index taxonomy comparison database 10 using the management index item input from the management index input unit 11 as a key, and determines the name of the management index calculation taxonomy to be used and the element name of the account item. Extract (read).
That is, in the management index taxonomy comparison table of FIG. 9, the management index calculation taxonomy extraction unit 70 stores the file name of the management index calculation taxonomy of “gross profit margin. Xsd” and the account item “margin of sales”. Extract element names. (Step S11).

Next, the management index account item extraction unit 71 uses the management index calculation taxonomy file name extracted by the management index calculation taxonomy extraction unit 70 to extract the management index calculation taxonomy of the corresponding file name from the management index calculation taxonomy database 12. Read, detect whether the link base is defined in the schema of this management index calculation taxonomy, and if the link base is defined, refer to this link base and whether the calculation of the calculation target element is defined Analyze. If the management index account item extraction unit 71 detects that the calculation target element is not defined in the link base, or if the link base is not described, the calculation target element is referred to as “first sub account item”. And output to the financial statement account item extraction unit 72. On the other hand, when the management index account item extraction unit 71 detects that the calculation of the calculation target element is defined in the link base, the subordinate element used in the link base calculation is defined as “first account item”. And output to the financial statement account item extraction unit 72 (step S12).
That is, the management index account item extraction unit 71 extracts the elements of “sales” and “gross profit” as the first sub-account items from the schema of the management index calculation taxonomy in FIG.

Next, the financial statement account item extraction unit 72 extracts the financial statement taxonomy including the “first subordinate account item” extracted by the management index account item extraction unit 71 from the financial statement taxonomy database 9, and The schema of the financial statement taxonomy is referred to for one sub-account (“Sales” and “Gross profit” in FIG. 13). Then, the financial statement account item extraction unit 72 detects whether or not the link base is defined in the schema of the financial statement taxonomy, and when the link base is defined, the link base is defined, It is analyzed whether or not the calculation of “one account item” is defined. If the financial statement account extracting unit 72 detects that the “first account item” is not defined in the link base, or if the link base is not described, the “first account item” is selected. It is extracted as “second subordinate account item” as it is and output to the account item accumulating unit 81. On the other hand, when the financial statement account extracting unit 72 detects that the calculation of the “first account item” is defined in the link base, the subordinate element used in the link base calculation is set to “second”. The account item ”is extracted and output to the account item accumulating unit 81 (step S13).
That is, the financial statement account item extraction unit 72 extracts “sales” and “purchase” as the second lower account item in FIG. 13.

Next, the account item accumulating unit 81 reads the financial information instance corresponding to the account item (second subordinate account item) and the processing range input from the financial statement account item extracting unit 72 from the financial information instance database 3. . (Step S14)
For example, in FIG. 14, the account item accumulating unit 81 extracts instances of “sales” of 100, 200, and 300 and instances of “purchasing” of 80, 160, and 240, respectively.
Next, the account item accumulating unit 81 integrates the extracted instances for each second account item, and outputs the accumulated result as accumulated data to the financial index instance generating unit 82 (step S15). .
For example, in FIG. 14, the account item accumulating unit 81 sets the accumulated data of the instance of the “sales” account item as “600” and the accumulated data of the instance of the “purchasing” account item as “480”. Output.

Next, the financial index instance generating unit 82 uses the accumulated data of the account items input from the account item accumulating unit 81, and uses the financial statement taxonomy as shown in FIG. The numerical value of the first subordinate account item is calculated. Here, when the calculation link is not set, the financial index instance generation unit 82 outputs the integrated data of the second lower account item as the calculated value of the first lower account item. That is, “120” is calculated as the calculated value of “gross profit”.
Then, the financial index instance generating unit 82 creates a financial index instance by writing the integrated data and the calculated value calculated from the integrated data corresponding to each corresponding element of the schema of the financial statement taxonomy.
Next, the financial index instance generating unit 82 inputs the first lower account item input from the management index account extracting unit 71 as the lower account item of the management index calculation taxonomy and the first lower account item. The calculated value is output to the management index instance generation unit 83 (for example, “600” as “sales” and “120” as “gross profit”).

Next, the management index instance generation unit 83 generates a link base (calculation link or formula link) based on the value of the second sub-account item of the management index calculation taxonomy input from the financial index instance generation unit 82. A management index is calculated with reference to “20” as “margin of sales”.
Then, the management index instance generation unit 83 creates a management index instance by writing the integrated data and the numerical value calculated based on the link base corresponding to the elements in the instance of the management index calculation taxonomy, and creates an index for the external system. (Step S16).

  As described above, the accounting information collection / analysis system 50 of this embodiment creates a financial information instance including the original transaction data information as it is, that is, including attribute data such as date, division, person in charge, etc. Since it is stored in the database 3, attribute data can be used as journal information, and for each account item (element name of the account item of the management indicator calculation taxonomy) necessary for calculation of the management indicator, Financial information instance and management depending on the period (for example, from the beginning to the time of aggregation or for the most recent month) and the target transaction (sales for the entire company, sales of a given business unit, sales of a given product, etc.) Since the index instance can be read, information for grasping more detailed management status can be calculated.

<Financial statement linkage processing>
The operation of the financial statement linkage process in the present embodiment will be described with reference to FIGS.
When the instance document obtained by converting the financial statement data output from the accounting system 200 shown in the conventional example into the XBRL format is input by the user, the analysis item input unit 4 receives the element of each account item from the instance document. The element data of this element is extracted and displayed on the display unit.

When the user selects the account item displayed on the display unit shown in FIG. 7 with a pointing device or the like, the analysis item input unit 4 displays the item of the account item, for example, “gross profit” as the financial statement. It outputs to the cooperation part 5 (step S1).
Next, the financial statement linkage unit 5 reads the financial statement taxonomy relating to the “gross profit” from the financial statement taxonomy database 9.
When the corresponding financial statement taxonomy is read, the financial statement linkage unit 5 refers to “gross profit” that is an element of the account item of the schema of the read financial statement taxonomy, and a link base is defined for it. Read out the subordinate account items used in the link base. For example, the financial statement cooperation unit 5 reads “sales” and “purchase” of the account items from the schema of the financial statement taxonomy in FIG. 7 (step S2).

Then, the financial statement cooperation unit 5 reads out the financial information instance including the read (extracted) lower-level account items, that is, “sales” and “purchase” from the financial information instance database 3. Outputs data for the courses “Sales” and “Purchase”. (Step S3).
As a result, the financial statement linkage unit 5 determines from which transaction data the element data of each account item is obtained in the financial statements calculated by the accounting system. Can be easily related by making the element names of the financial statement taxonomy and the data conversion taxonomy identical, and can be analyzed only with the journal information obtained by the accounting system The read financial information instance is output as the financial statement analysis data including the detailed matters that did not exist.
In this embodiment, the system is constructed by XBRL. However, the system is not limited to XBRL, and may be constructed by another structured language such as XML.

  The program for realizing the functions of the accounting information collection / analysis system in FIG. 1 is recorded on a computer-readable recording medium, and the program recorded on the recording medium is read into the computer system and executed. Data conversion processing, financial statement linkage processing, and management status analysis processing may be performed. Here, the “computer system” includes an OS and hardware such as peripheral devices. The “computer system” includes a WWW system having a homepage providing environment (or display environment). The “computer-readable recording medium” refers to a storage device such as a flexible medium, a magneto-optical disk, a portable medium such as a ROM and a CD-ROM, and a hard disk incorporated in a computer system. Further, the “computer-readable recording medium” refers to a volatile memory (RAM) in a computer system that becomes a server or a client when a program is transmitted via a network such as the Internet or a communication line such as a telephone line. In addition, those holding programs for a certain period of time are also included.

  The program may be transmitted from a computer system storing the program in a storage device or the like to another computer system via a transmission medium or by a transmission wave in the transmission medium. Here, the “transmission medium” for transmitting the program refers to a medium having a function of transmitting information, such as a network (communication network) such as the Internet or a communication line (communication line) such as a telephone line. The program may be for realizing a part of the functions described above. Furthermore, what can implement | achieve the function mentioned above in combination with the program already recorded on the computer system, and what is called a difference file (difference program) may be sufficient.

DESCRIPTION OF SYMBOLS 1 ... Data conversion taxonomy database 2 ... Data conversion part 3 ... Financial information instance database 4 ... Analysis subject input part 5 ... Financial statement cooperation part 8 ... Management index calculation part 9 ... Financial statement taxonomy database 10 ... Management index taxonomy contrast database 11 ... Management index input unit 12 ... Management index calculation taxonomy database 15 ... Mapping file database 20 ... Financial index extraction / calculation unit 21 ... Management index extraction / calculation unit 50 ... Accounting information collection / analysis system 70 ... Management index calculation taxonomy extraction unit 71 ... Management Index Account Extraction Unit 72 ... Financial Statement Account Extraction Unit 81 ... Account Item Integration Unit 82 ... Financial Index Instance Generation Unit 83 ... Management Index Instance Generation Unit 100 ... Sales Management System 101 ... Accounting System 102 ... Salary System 200 ... Accounting system

Claims (5)

Analyze business conditions by converting transaction data input from multiple business systems, which are the original transaction data for standardized financial statement account items, into a unified structured language data format and storing it in the database A supporting accounting information collection / analysis system,
A rule defining an element name of the financial information data for generating financial information data obtained by converting the transaction data into financial information data in the structured language data format, wherein the element name is an element name of an account item In this case, a data conversion structure rule storage unit that stores in advance a data conversion structure rule that uses the same element name as the element name of the account item of the standardized financial statement for each transaction type;
A mapping file storage unit that stores in advance a mapping file indicating the correspondence between the item name of the transaction data and the element name of the data conversion structure rule for each type of transaction;
Read transaction data input from the plurality of business systems, read a mapping file corresponding to the transaction type of the transaction data from the mapping file storage unit, and convert the data conversion structure rule corresponding to the type to the data conversion structure rule An item corresponding to the mapping file read out from the storage unit is detected from the transaction data, and the detected transaction data item is converted in accordance with the element name defined in the read data conversion structure rule. A data conversion unit for generating information data and sequentially storing the data in a financial information data storage unit;
Financial statement structure rules that define, for the data format, the elements of the account items of the standardized financial statements, the arithmetic expression in which the calculation process for obtaining the element is defined, and the subordinate elements used in the arithmetic expression Financial statement structure rule storage unit stored in advance for each type of tables,
An analysis item input unit that reads financial statement data in the data format of the structured language from outside, accepts selection of an account for analysis, and outputs the selected account for analysis,
A financial statement structure rule including the analysis target account item output from the analysis item input unit as an element is read out from the financial statement structure rule storage unit, and an account corresponding to the analysis target account item from the financial statement structure rule If you extract the element of the item, analyze whether the arithmetic expression of the element of the account is defined in the extracted account element, and if the arithmetic expression is defined in the element of the extracted account, If the lower level element used in the calculation formula is an analysis target element and no calculation formula is defined in the extracted account item element, the account item element is set as the analysis target element, and the analysis target element is set as the analysis target element. And a financial statement linkage unit that reads out the corresponding financial information data from the financial information data storage unit as a key and outputs it as transaction data related to the account item to be analyzed. Accounting information collection and analysis system. In the processing range in which the financial statement linkage unit inputs financial information data to be analyzed by the user,
2. The accounting information collection / analysis system according to claim 1, wherein the accounting information is read from the financial information data storage unit. The data conversion structure rule includes an arithmetic expression defining a relationship between elements,
The said data conversion part produces | generates financial information data, after calculating the value of an element based on the said arithmetic expression of the said data conversion structure rule for the data of the item detected from the said transaction data. The accounting information collection / analysis system according to claim 2. A plurality of original transaction data relating to account items of standardized financial statements, comprising a data conversion structure rule storage unit, a mapping file storage unit, a data conversion unit, a financial statement structure rule storage unit, an analysis item input unit, and a financial statement linkage unit Accounting information collection / analysis method in an accounting information collection / analysis system that supports analysis of business conditions by converting transaction data input from business systems into a unified structured language data format and storing it in a database Because
A rule defining an element name of the financial information data for generating financial information data obtained by converting the transaction data into financial information data in the structured language data format, wherein the element name is an element name of an account item In this case, a process of storing a data conversion structure rule that uses the same element name as the element name of the account item of the standardized financial statement in the data conversion structure rule storage unit in advance for each transaction type;
Storing a mapping file indicating a correspondence relationship between the item name of the transaction data and the element name of the data conversion structure rule in a mapping file storage unit in advance for each type of transaction;
A data conversion unit reads transaction data input from the plurality of business systems, reads a mapping file corresponding to the transaction type of the transaction data from the mapping file storage unit, and sets a data conversion structure rule corresponding to the type. The item corresponding to the mapping file read from the data conversion structure rule storage unit is detected from the transaction data, and the detected transaction data item is converted in accordance with the element name defined in the read data conversion structure rule. To generate financial information data and sequentially store it in the financial information data storage unit,
Financial statement structure rules that define the elements of the standardized financial statement account, the arithmetic expression in which the calculation process for obtaining the element is defined, and the subordinate account element used in the arithmetic expression for the data format Is stored in advance in the financial statement structure rule storage unit for each type of financial statement,
An analysis item input unit reads financial statement data in the data format of the structured language from the outside, accepts selection of an account for analysis, and outputs the selected account for analysis;
A financial statement linkage unit reads a financial statement structure rule including the analysis target account item output from the analysis item input unit as an element from the financial statement structure rule storage unit, and reads the analysis target account from the financial statement structure rule. The element of the account corresponding to the item is extracted, whether or not an arithmetic expression of the element of the account is defined in the extracted account element, and the arithmetic expression is defined in the extracted account element. If the calculation formula is not defined in the extracted account item element, the subordinate element used in the calculation formula is set as the analysis target element. Reading the corresponding financial information data from the financial information data storage unit using the element to be analyzed as a key, and outputting the data as transaction data relating to the account item to be analyzed. Accounting information collection and analysis method characterized by   An accounting information collection / analysis program for causing a computer to function as the accounting information collection / analysis system according to claim 1.

Images