Report comparison method and device, storage medium and computer device

Abstract

The application discloses a report comparison method and device, a storage medium and computer equipment, relates to the field of information technology, and mainly aims at improving the efficiency and accuracy of comparing new and old financial reports. The method comprises the following steps: determining the data extraction mapping relationship of a first report in the to-be-compared reports, and the data extraction mapping relationship of a second report in the to-be-compared reports; based on the data extraction mapping relationship of the first report and the data extraction mapping relationship of the second report, a report comparison template corresponding to the to-be-compared reports is constructed; in response to a data query signal triggered in the report comparison template, report data corresponding to the first report and report data corresponding to the second report are acquired; based on the report data corresponding to the first report and the report data corresponding to the second report, the first report and the second report are compared, and a comparison result corresponding to the to-be-compared reports is obtained. The application is suitable for comparing new and old reports.

Description

Technical Field

[0001] This invention relates to the field of information technology, and in particular to a report comparison method, apparatus, storage medium, and computer equipment. Background Technology

[0002] The new insurance contract standard is also known in the industry as the "Chinese version of IFRS 17." IFRS 17, or International Financial Reporting Standard 17—Insurance Contracts, is a set of specific rules developed by the International Accounting Standards Board (IASB) for the accounting measurement of insurance contracts. At the end of 2022, the Accounting Department of the Ministry of Finance issued the "Notice on Revising and Issuing the 2023 Financial Statement Format for Insurance Companies." The new format is a revision of the financial statement format for insurance companies, taking into account the new changes in the insurance standard and the implementation of enterprise accounting standards, laying a solid foundation for the implementation of the new standard. Industry insiders believe that the changes in the new format are comprehensive, incorporating numerous attempts and innovations. The ultimate goal of the format adjustment is always to improve the quality of insurance accounting information, achieving "accurate presentation" and "decision-usefulness." Comparative analysis of the financial statements under the new standard and those under the old standard is essential.

[0003] Currently, the comparison of old and new financial statements is usually done manually by accounting staff. However, this manual comparison method is inefficient, and at the same time, errors can occur due to negligence by accounting staff, resulting in low accuracy in the comparison of old and new financial statements. Summary of the Invention

[0004] This invention provides a method, apparatus, storage medium, and computer equipment for comparing financial statements, which mainly improves the efficiency and accuracy of comparing old and new financial statements.

[0005] According to a first aspect of the present invention, a report comparison method is provided, comprising:

[0006] Determine the data retrieval mapping relationship of the first report in the comparison report, and the data retrieval mapping relationship of the second report in the comparison report;

[0007] Based on the data retrieval mapping relationship of the first report and the data retrieval mapping relationship of the second report, a report comparison template corresponding to the report to be compared is constructed;

[0008] In response to a data query signal triggered in the report comparison template, obtain the report data corresponding to the first report and the report data corresponding to the second report;

[0009] Based on the report data corresponding to the first report and the report data corresponding to the second report, the first report and the second report are compared to obtain the comparison result corresponding to the report to be compared.

[0010] Optionally, the data retrieval mapping relationship includes the mapping relationship between report items and account items. The step of constructing a report comparison template corresponding to the report to be compared based on the data retrieval mapping relationship of the first report and the data retrieval mapping relationship of the second report includes:

[0011] The report items in the first report are merged with the report items with the same meaning in the second report to obtain the merged report items, and the report difference items corresponding to the merged report items are determined.

[0012] Merge the account items in the first report with the account items with the same meaning in the second report to obtain the merged account items, and determine the account difference items corresponding to the merged account items;

[0013] Based on the merged report items and their corresponding report difference items, as well as the merged account items and their corresponding account difference items, a report comparison template corresponding to the report to be compared is constructed.

[0014] Optionally, before responding to a data query signal triggered in the report comparison template, the method further includes:

[0015] Based on the data retrieval mapping relationship of the first report, determine the calculation view corresponding to the first report;

[0016] Calculate the report data corresponding to the first report based on the calculation view corresponding to the first report;

[0017] Based on the data retrieval mapping relationship of the second report, determine the calculation view corresponding to the second report;

[0018] Calculate the report data corresponding to the second report based on the calculation view corresponding to the second report.

[0019] Optionally, after calculating the report data corresponding to the first report based on the calculated view corresponding to the first report, the method further includes:

[0020] Store the report data corresponding to the first report in the first database corresponding to the first report;

[0021] After calculating the report data corresponding to the second report based on the calculation view corresponding to the second report, the method further includes:

[0022] The report data corresponding to the second report is stored in the second database corresponding to the second report.

[0023] Optionally, before responding to a data query signal triggered in the report comparison template, the method further includes:

[0024] Based on the data retrieval mapping relationship of the first report, construct the first query component corresponding to the first database;

[0025] Based on the data retrieval mapping relationship of the second report, construct the second query component corresponding to the second database;

[0026] Configure the first query component and the second query component in the report comparison template.

[0027] Optionally, obtaining the report data corresponding to the first report and the report data corresponding to the second report includes:

[0028] Use the first query component to query the report data corresponding to the first report in the first database;

[0029] Use the second query component to query the report data corresponding to the second report in the second database.

[0030] Optionally, the step of comparing the first report and the second report based on the report data corresponding to the first report and the report data corresponding to the second report to obtain the comparison result corresponding to the report to be compared includes:

[0031] Obtain the first target report data from the first report and the second target report data from the second report corresponding to the merged report item of the same target in the report comparison template;

[0032] Calculate the difference in report item data between the first target report data and the second target report data;

[0033] Obtain the third target report data from the first report and the fourth target report data from the second report corresponding to the merged account items of the same target in the report comparison template;

[0034] Calculate the difference in account item data between the third target report data and the fourth target report data, and determine the difference in report item data and the difference in account item data as the comparison result corresponding to the report to be compared.

[0035] According to a second aspect of the present invention, a report comparison device is provided, comprising:

[0036] The determining unit is used to determine the data acquisition mapping relationship of the first report in the comparison report and the data acquisition mapping relationship of the second report in the comparison report;

[0037] A construction unit is used to construct a report comparison template corresponding to the report to be compared based on the data retrieval mapping relationship of the first report and the data retrieval mapping relationship of the second report;

[0038] The acquisition unit is used to acquire the report data corresponding to the first report and the report data corresponding to the second report in response to the data query signal triggered in the report comparison template.

[0039] The comparison unit is used to compare the first report and the second report based on the report data corresponding to the first report and the report data corresponding to the second report, and obtain the comparison result corresponding to the report to be compared.

[0040] According to a third aspect of the present invention, a computer-readable storage medium is provided having a computer program stored thereon, which, when executed by a processor, implements the above-described report comparison method.

[0041] According to a fourth aspect of the present invention, a computer device is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the above-described report comparison method.

[0042] According to the present invention, a method, apparatus, storage medium, and computer device for comparing financial statements provide a method that, compared with the current method of manually comparing old and new financial statements by accounting personnel, determines the data retrieval mapping relationship of a first report and a second report in the reports to be compared. Based on the data retrieval mapping relationships of the first and second reports, a report comparison template corresponding to the reports to be compared is constructed. Then, in response to a data query signal triggered in the report comparison template, the report data corresponding to the first and second reports is obtained. Finally, based on the report data corresponding to the first and second reports, the first and second reports are compared to obtain the comparison result corresponding to the reports to be compared. Thus, by constructing a report comparison template through the data retrieval mapping relationship between old and new financial statements, and using the report comparison template to obtain the report data from the old and new reports, and finally directly comparing the old and new reports in the new and old report comparison template storing the report data, the low efficiency and low accuracy of manual comparison can be avoided. Therefore, the present invention can improve the efficiency and accuracy of report comparison. Attached Figure Description

[0043] The accompanying drawings, which are included to provide a further understanding of the invention and form part of this application, illustrate exemplary embodiments of the invention and, together with their description, serve to explain the invention and do not constitute an undue limitation thereof. In the drawings:

[0044] Figure 1 A flowchart of a report comparison method provided by an embodiment of the present invention is shown;

[0045] Figure 2 This invention provides a flowchart of another report comparison method according to an embodiment of the invention.

[0046] Figure 3 This diagram illustrates the structure of a report comparison device provided in an embodiment of the present invention.

[0047] Figure 4 This invention provides a schematic diagram of the structure of another report comparison device according to an embodiment of the invention.

[0048] Figure 5 A schematic diagram of the physical structure of a computer device provided in an embodiment of the present invention is shown. Detailed Implementation

[0049] The present invention will be described in detail below with reference to the accompanying drawings and embodiments. It should be noted that, unless otherwise specified, the embodiments and features described in the present application can be combined with each other.

[0050] Currently, the method of manually comparing old and new financial statements by accounting staff results in low efficiency. At the same time, due to the negligence of accounting staff, errors may occur, leading to low accuracy in the comparison of old and new financial statements.

[0051] To address the aforementioned problems, embodiments of the present invention provide a report comparison method, such as... Figure 1 As shown, the method includes:

[0052] 101. Determine the data retrieval mapping relationship of the first report in the comparison report and the data retrieval mapping relationship of the second report in the comparison report.

[0053] The first report can be a financial statement under the new standards, and the second report can be a financial statement under the old standards. The data mapping relationship refers to the mapping relationship between report items and accounts in the new and old reports. The reports include the internal balance sheet, internal profit and loss statement, etc.

[0054] 102. Based on the data retrieval mapping relationship of the first report and the data retrieval mapping relationship of the second report, construct the report comparison template corresponding to the report to be compared.

[0055] Specifically, if the financial statements under the new and old standards are internal balance sheets, the comparison template is the internal balance sheet comparison table under the new and old standards; if the financial statements under the new and old standards are internal profits, the comparison template is the internal profit comparison table under the new and old standards. Different types of financial statements correspond to different comparison templates.

[0056] In this embodiment of the invention, the data retrieval mapping relationship of the financial statements under the new standard can be sorted out in advance, as well as the data retrieval mapping relationship of the financial statements under the old standard. Then, based on the data retrieval mapping relationship of the financial statements under the new standard and the old standard, a comparison template of the financial statements under the new and old standards is constructed. Specifically, the method for constructing the comparison template based on the data retrieval mapping relationship is as follows: the accounting personnel first design the form, such as the internal profit comparison table under the new and old standards, which has a total of 100 report items. For example, the first report under the new standard is named "I. Insurance Service Revenue", which has 10 new standard level 3 accounts starting with 6033. The corresponding second report under the old standard is named "I. Earned Gross Premiums", which has 2 old standard level 3 accounts starting with 6501. This completes the data retrieval logic and account mapping sorting of the first report item. And so on... to complete the data retrieval logic and account mapping sorting of all 100 report items, forming a document, i.e., the report comparison template. Then, the financial statement comparison template is used to compare the differences between the financial statements under the new standard and the financial statements under the old standard. By using the financial statement comparison template for comparison, the comparison results can be clearer and more transparent, avoiding the problems of low comparison efficiency and low accuracy caused by manual comparison item by item. Thus, the embodiments of the present invention can improve the comparison efficiency and accuracy of financial statements.

[0057] 103. In response to the data query signal triggered in the report comparison template, obtain the report data corresponding to the first report and the report data corresponding to the second report.

[0058] Among them, report data refers to the report data calculated based on the data mapping relationship. For example, if the data is the current period's data, then the specific amount corresponding to the current period's data is the report data. If the data is the cumulative amount for the current year, then the specific amount of the cumulative amount for the current year is the report data.

[0059] In this embodiment of the invention, the database stores report data for various reports. It should be noted that the report data for various reports is pre-calculated based on the data mapping relationship in the report comparison template, and the calculation results are stored in the corresponding database. For example, the report data for the new standard is stored in the S / 4HANA or data warehouse BW / 4HANA corresponding to the financial statements of the new standard, and the report data for the financial statements of the old standard is stored in the S / 4HANA or data warehouse BW / 4HANA corresponding to the financial statements of the old standard. Here, HANA is a financial system for both the new and old standards.

[0060] Specifically, the report comparison template contains a data query plugin for new report data and a query plugin for old report data. Using the data query plugin for new report data, the corresponding report data is queried in the database corresponding to the new report data according to the data retrieval mapping relationship. The retrieved new report data is automatically configured in the corresponding position of the new report data retrieval mapping relationship in the report comparison template. Using the data query plugin for old report data, the corresponding report data is queried in the database corresponding to the old report data according to the data retrieval mapping relationship. The retrieved old report data is automatically configured in the corresponding position of the old report data retrieval mapping relationship in the report comparison template. For example, if the data retrieval mapping relationship includes the current period's data, the data query plugin in the report comparison template will be triggered, and the specific amount corresponding to the current period's data, such as 500,000, will be automatically retrieved from the database, and then 500,000 will be automatically configured in the corresponding position of the current period's data. Therefore, by configuring a data query plugin in the report comparison template, the report data corresponding to the data retrieval mapping relationship can be automatically obtained and configured in the report comparison template. This avoids the problem of low data retrieval efficiency caused by manually searching for each report data, and also avoids the situation where data is manually configured in the wrong position. Thus, the embodiments of the present invention can improve the accuracy and efficiency of report data configuration, thereby improving the comparison efficiency and accuracy of reports.

[0061] 104. Based on the report data corresponding to the first report and the report data corresponding to the second report, compare the first report and the second report to obtain the comparison results of the reports to be compared.

[0062] In this embodiment of the invention, after configuring the report data corresponding to each data point in the report comparison template, including the report data corresponding to the data points of the new standard section and the report data corresponding to the data points of the old standard section, if the data points of the new standard section and the data points of the old standard section have the same meaning but different names, the two data points with the same meaning are unified into the same name. For example, if the data point of the new standard section is "cumulative amount for this year" and the data point with the same meaning in the old standard section is "total amount for this year", then the two data points can be merged and collectively referred to as "cumulative amount for this year". Therefore, the new standard section of the report comparison template includes... The new standard includes the year-to-date cumulative figures, and the old standard also includes the year-to-date cumulative figures. At the same time, the financial statement comparison template includes a difference comparison item. For example, if both the new and old standard sections have year-to-date cumulative figures, then the financial statement comparison template also needs to include the year-to-date cumulative difference item. In the financial statement comparison template, the year-to-date cumulative figures in the new standard section correspond to the year-to-date cumulative figures in the new financial statements, and the year-to-date cumulative figures in the old standard section correspond to the year-to-date cumulative figures in the old financial statements. Meanwhile, the year-to-date cumulative difference item corresponds to the difference between the year-to-date cumulative figures in the new financial statements and the year-to-date cumulative figures in the old financial statements. Therefore, by automatically obtaining financial statement data from the old and new standards financial statements based on the data mapping relationship in the financial statement comparison template, and automatically mapping the obtained financial statement data to the corresponding positions in the financial statement comparison template, the differences between the old and new standards financial statements are automatically calculated through the financial statement comparison template. This enables automatic comparison of the old and new standards financial statements and displays the comparison results clearly in the financial statement comparison template. This avoids the problems of low comparison efficiency and accuracy caused by manually comparing the old and new financial statement data one by one. Thus, the embodiments of the present invention can improve the comparison efficiency and accuracy of financial statements under the old and new standards.

[0063] According to the present invention, a report comparison method, compared with the current method of manually comparing old and new financial statements by accounting personnel, determines the data retrieval mapping relationship of a first report and a second report in the report to be compared; and constructs a report comparison template corresponding to the report to be compared based on the data retrieval mapping relationships of the first and second reports; then, in response to a data query signal triggered in the report comparison template, obtains the report data corresponding to the first report and the report data corresponding to the second report; finally, compares the first report and the second report based on the report data corresponding to the first report and the report data corresponding to the second report to obtain the comparison result corresponding to the report to be compared. Thus, by constructing a report comparison template through the data retrieval mapping relationship of old and new financial statements, and using the report comparison template to obtain the report data from the old and new reports, and finally directly comparing the old and new reports in the new and old report comparison template storing the report data, the low efficiency and low accuracy of manual comparison of old and new reports can be avoided. Therefore, the present invention can improve the efficiency and accuracy of report comparison.

[0064] Furthermore, to better illustrate the above process of comparing reports, as a refinement and extension of the above embodiments, this embodiment of the invention provides another method for comparing reports, such as... Figure 2 As shown, the method includes:

[0065] 201. Determine the data retrieval mapping relationship of the first report in the comparison report and the data retrieval mapping relationship of the second report in the comparison report.

[0066] 202. Based on the data retrieval mapping relationship of the first report and the data retrieval mapping relationship of the second report, construct the report comparison template corresponding to the report to be compared.

[0067] In this embodiment of the invention, the data retrieval mapping relationships in the first report and the second report are pre-analyzed. Simultaneously, a template for a report comparison is constructed. Then, based on the data retrieval mapping relationships of the first and second reports and the template for the report comparison, a report comparison template corresponding to both the first and second reports is constructed. When constructing the report comparison template, to clearly compare the differences between the first and second reports, it is necessary to merge title items with the same meaning in both reports into a single title item. Therefore, step 202 specifically includes: merging report items in the first report with report items with the same meaning in the second report to obtain merged report items, and determining the report difference items corresponding to the merged report items; merging account items in the first report with account items with the same meaning in the second report to obtain merged account items, and determining the account difference items corresponding to the merged account items; and constructing a report comparison template corresponding to the report to be compared based on the merged report items and their corresponding report difference items, as well as the merged account items and their corresponding account difference items.

[0068] Specifically, report items and account items can be title items in a report, with account items being subordinate items of report items. Specifically, because the report comparison template is constructed based on the data mapping relationship between the first and second reports, after clarifying the data mapping relationship between the first and second reports, it is determined whether there are data items with the same meaning in the first and second reports, i.e., whether there are report items and account items with the same meaning. If so, the report items and account items with the same meaning are merged into report items and account items with unified names. The purpose is to unify the names of the data items in the first and second reports in the report comparison template. At the same time, the report comparison template should also include report difference items. That is, the report comparison template should include not only the report items of the first and second reports, but also the report difference items between the first and second reports. The report difference items should be configured with difference calculation formulas. For example, if the report difference item is the difference in the current period, the calculation formula should be the current period number in the first report minus the current period number in the second report; if the report difference item is the difference in the cumulative number for the year, the calculation formula should be the cumulative number for the year in the first report minus the cumulative number for the year in the second report.

[0069] 203. Based on the data retrieval mapping relationship of the first report, construct the first query component corresponding to the first database.

[0070] 204. Based on the data retrieval mapping relationship of the second report, construct the second query component corresponding to the second database.

[0071] 205. Configure the first query component and the second query component in the report comparison template.

[0072] In this embodiment of the invention, after determining the data retrieval mapping relationship of the first report and the second report, it is also necessary to calculate the report data corresponding to the first report according to the data retrieval mapping relationship of the first report, and simultaneously calculate the report data corresponding to the second report according to the data retrieval mapping relationship of the second report. Based on this, the method includes: determining the calculation view corresponding to the first report based on the data retrieval mapping relationship of the first report; calculating the report data corresponding to the first report according to the calculation view corresponding to the first report; determining the calculation view corresponding to the second report according to the data retrieval mapping relationship of the second report; and calculating the report data corresponding to the second report according to the calculation view corresponding to the second report. After calculating the report data, the method further includes: storing the report data corresponding to the first report in a first database corresponding to the first report; and storing the report data corresponding to the second report in a second database corresponding to the second report.

[0073] Specifically, in the financial system of the first report, through SAP HANA (a financial system) database layer sinking processing, a HANA calculation view of the report data corresponding to the data retrieval mapping relationship of the first report in the report comparison template is developed, and the calculated report data is stored in the S / 4HANA of the first report financial system or the BW / 4HANA data warehouse. At the same time, in the financial system of the second report, through database layer sinking processing, a calculation view of the report data corresponding to the data retrieval mapping relationship of the second report in the report comparison template is developed, and the calculated report data is stored in the database corresponding to the second report financial system.

[0074] Furthermore, in the financial system corresponding to the first report, within the S / 4HANA or data warehouse BW / 4HANA, according to the data retrieval mapping relationship corresponding to the first report, develop a query component (BW Query) for the first report. The specific development method is as follows: Open the financial system corresponding to the first report and switch the view in the upper right corner of the financial system to "BW Modeling". Then configure the connection address and port of the S / 4HANA or data warehouse BW / 4HANA corresponding to the first report, and double-click to connect and enter the user password of the first report system to log in; in "BW..." In the "Repository (BW Knowledge Base)" directory, create a new composite provider and specify its data source as the database corresponding to the first report's financial system. Then, create a new query component under this composite provider and configure it in the report comparison template. When using this query component to query the report data corresponding to the first report, it will perform a query in the database corresponding to the first report according to the data retrieval logic and mapping relationship in the report comparison template. The query results will be configured in the account dimension of the first report in the report comparison template, and the value range will be set according to the report comparison template. Similarly, develop the query component for the second report in the same way and configure it in the report comparison template. When using this query component to query the report data corresponding to the second report, it will perform a query in the database corresponding to the second report according to the data retrieval logic and mapping relationship in the report comparison template. The "mapping relationship" is queried in the database corresponding to the second report. The query results are configured in the subject dimension of the second report in the report comparison template, and the value range is set according to the report comparison template. It should be noted that an OLAP (Online Analytical Processing) connection can also be established between the query components corresponding to the first and second reports. When the query component corresponding to the first report is triggered in the report comparison template, the query function of the query component corresponding to the second report is automatically triggered based on the OLAP connection between the query components corresponding to the first and second reports. At this time, the query components corresponding to the first and second reports simultaneously query the report data in their respective databases and configure the query results in the corresponding positions in the report comparison template. Therefore, by setting a query component in the report comparison template, the report data in the two reports can be automatically queried and configured in the template, avoiding the slow query efficiency and query errors caused by manual querying one by one. At the same time, by establishing a connection between the two query components, the number of times the query component is triggered can be reduced, ensuring that the data in the two reports is queried simultaneously.

[0075] 206. In response to the data query signal triggered in the report comparison template, obtain the report data corresponding to the first report and the report data corresponding to the second report.

[0076] In this embodiment of the invention, after configuring the query component corresponding to the first report and the query component corresponding to the second report in the report comparison template, it is necessary to query the report data based on the query component. Based on this, step 206 includes: using the first query component to query the report data corresponding to the first report in the first database; and using the second query component to query the report data corresponding to the second report in the second database.

[0077] Specifically, when a user triggers the first query component, the second query component is automatically triggered based on the OLAP connection between the first and second query components. Then, the first query component queries the report data in the database corresponding to the first report according to the data retrieval mapping relationship of the first report section, and the second query component queries the report data in the database corresponding to the second report according to the data retrieval mapping relationship of the second report section. After that, the report data retrieved by the first query component and the report data retrieved by the second query component are configured in the report comparison template, and the differences in the same dimension data in the first report data and the second report data are automatically calculated and configured in the report comparison template, so as to clearly display the comparison results between the first report data and the second report data.

[0078] 207. Based on the report data corresponding to the first report and the report data corresponding to the second report, compare the first report and the second report to obtain the comparison results of the reports to be compared.

[0079] In this embodiment of the invention, after obtaining the report data in the first report and the report data in the second report, it is necessary to compare the first report data and the second report data. Based on this, step 207 includes: obtaining the first target report data in the first report and the second target report data in the second report corresponding to the report items of the same target merged in the report comparison template; calculating the report item data difference between the first target report data and the second target report data; obtaining the third target report data in the first report and the fourth target report data in the second report corresponding to the account items of the same target merged in the report comparison template; calculating the account item data difference between the third target report data and the fourth target report data, and determining the report item data difference and the account item data difference as the comparison result corresponding to the report to be compared.

[0080] The report items and account items include: current period figures, year-to-date figures, etc. Specifically, the difference between the report data in the first report and the report data in the second report corresponding to the same report item in the report comparison template is calculated, and the difference between the report data in the first report and the report data in the second report corresponding to the same account item in the report comparison template is also calculated. Then, the difference is configured in the corresponding difference item. For example, if the current period figure in the first report is 500,000 and the current period figure in the second report is 600,000, then the corresponding difference item for the current period figure should be 100,000; if the current period cumulative figure in the first report is 1,000,000 and the current period cumulative figure in the second report is 800,000, then the corresponding difference item for the current period cumulative figure should be 200,000.

[0081] According to another report comparison method provided by the present invention, compared with the current method of manually comparing old and new financial statements by accounting personnel, the present invention determines the data retrieval mapping relationship of the first report and the data retrieval mapping relationship of the second report in the report to be compared; and constructs a report comparison template corresponding to the report to be compared based on the data retrieval mapping relationship of the first report and the second report; then, in response to the data query signal triggered in the report comparison template, it obtains the report data corresponding to the first report and the report data corresponding to the second report; finally, it compares the first report and the second report based on the report data corresponding to the first report and the report data corresponding to the second report to obtain the comparison result corresponding to the report to be compared. Thus, by constructing a report comparison template through the data retrieval mapping relationship of old and new financial statements, and using the report comparison template to obtain the report data in the old and new reports, and finally directly comparing the old and new reports in the old and new report comparison template storing the report data, the present invention can avoid the problems of low efficiency and low accuracy of manual comparison of old and new reports, thereby improving the efficiency and accuracy of report comparison.

[0082] Furthermore, as Figure 1 In specific implementation, embodiments of the present invention provide a report comparison device, such as... Figure 3 As shown, the device includes: a determining unit 31, a constructing unit 32, an acquiring unit 33, and a comparing unit 34.

[0083] The determining unit 31 can be used to determine the data acquisition mapping relationship of the first report in the comparison report and the data acquisition mapping relationship of the second report in the comparison report.

[0084] The construction unit 32 can be used to construct a report comparison template corresponding to the report to be compared based on the data retrieval mapping relationship of the first report and the data retrieval mapping relationship of the second report.

[0085] The acquisition unit 33 can be used to acquire the report data corresponding to the first report and the report data corresponding to the second report in response to the data query signal triggered in the report comparison template.

[0086] The comparison unit 34 can be used to compare the first report and the second report based on the report data corresponding to the first report and the report data corresponding to the second report, and obtain the comparison result corresponding to the report to be compared.

[0087] In specific application scenarios, in order to construct a report comparison template corresponding to the reports to be compared, such as Figure 4 As shown, the building unit 32 includes a merging module 321 and a building module 322.

[0088] The merging module 321 can be used to merge report items in the first report with report items with the same meaning in the second report to obtain merged report items, and to determine the report difference items corresponding to the merged report items.

[0089] The merging module 321 can also be used to merge the account items in the first report with the account items with the same meaning in the second report to obtain the merged account items, and to determine the account difference items corresponding to the merged account items.

[0090] The construction module 322 can be used to construct a report comparison template corresponding to the report to be compared based on the merged report items and their corresponding report difference items, as well as the merged account items and their corresponding account difference items.

[0091] In specific application scenarios, in order to calculate the report data corresponding to the first report and the report data corresponding to the second report, the device further includes: a calculation unit 35.

[0092] The determining unit 31 can also be used to determine the calculation view corresponding to the first report based on the data retrieval mapping relationship of the first report.

[0093] The calculation unit 35 can be used to calculate the report data corresponding to the first report based on the calculation view corresponding to the first report.

[0094] The determining unit 31 can also be used to determine the calculation view corresponding to the second report based on the data retrieval mapping relationship of the second report.

[0095] The calculation unit 35 can also be used to calculate the report data corresponding to the second report based on the calculation view corresponding to the second report.

[0096] In specific application scenarios, in order to store report data in a database, the calculation unit 35 can also be used to store the report data corresponding to the first report in the first database corresponding to the first report; and store the report data corresponding to the second report in the second database corresponding to the second report.

[0097] In specific application scenarios, in order to configure the first query component and the second query component in the report comparison template, the device further includes: a configuration unit 36.

[0098] The construction unit 32 can also be used to construct a first query component corresponding to the first database based on the data retrieval mapping relationship of the first report.

[0099] The construction unit 32 can also be used to construct a second query component corresponding to the second database based on the data retrieval mapping relationship of the second report.

[0100] The configuration unit 36 ​​can be used to configure the first query component and the second query component in the report comparison template.

[0101] In specific application scenarios, in order to obtain report data, the obtaining unit 33 can be used to query the report data corresponding to the first report in the first database using the first query component; and to query the report data corresponding to the second report in the second database using the second query component.

[0102] In specific application scenarios, in order to determine the comparison result corresponding to the report to be compared, the comparison unit 34 includes an acquisition module 341 and a calculation module 342.

[0103] The acquisition module 341 can be used to acquire the first target report data in the first report and the second target report data in the second report corresponding to the report item of the same target after merging in the report comparison template.

[0104] The calculation module 342 can be used to calculate the difference in report item data between the first target report data and the second target report data.

[0105] The acquisition module 341 can also be used to acquire the third target report data in the first report and the fourth target report data in the second report corresponding to the subject item after merging the same target in the report comparison template.

[0106] The calculation module 342 can also be used to calculate the difference in account item data between the third target report data and the fourth target report data, and determine the difference in report item data and the difference in account item data as the comparison result corresponding to the report to be compared.

[0107] It should be noted that other corresponding descriptions of the functional modules involved in the report comparison device provided in this embodiment of the invention can be found in [reference]. Figure 1 The corresponding descriptions of the methods shown will not be repeated here.

[0108] Based on the above, Figure 1 Accordingly, this embodiment of the invention also provides a computer-readable storage medium storing a computer program that, when executed by a processor, performs the following steps: determining the data retrieval mapping relationship of a first report and a second report in the reports to be compared; constructing a report comparison template corresponding to the reports to be compared based on the data retrieval mapping relationship of the first report and the second report; obtaining report data corresponding to the first report and the second report in response to a data query signal triggered in the report comparison template; and comparing the first report and the second report based on the report data corresponding to the first report and the report data corresponding to the second report to obtain a comparison result corresponding to the reports to be compared.

[0109] Based on the above, Figure 1 The method shown and as Figure 3 The embodiment of the device shown in the invention also provides a physical structure diagram of a computer device, such as... Figure 5 As shown, the computer device includes: a processor 41, a memory 42, and a computer program stored in the memory 42 and executable on the processor. Both the memory 42 and the processor 41 are mounted on a bus 43. When the processor 41 executes the program, it performs the following steps: determining the data retrieval mapping relationship of a first report and a second report in the reports to be compared; constructing a report comparison template corresponding to the reports to be compared based on the data retrieval mapping relationships of the first and second reports; in response to a data query signal triggered in the report comparison template, obtaining report data corresponding to the first report and report data corresponding to the second report; and comparing the first and second reports based on the report data corresponding to the first and second reports to obtain a comparison result corresponding to the reports to be compared.

[0110] Through the technical solution of this invention, the present invention determines the data retrieval mapping relationship of the first report and the second report in the report to be compared; and constructs a report comparison template corresponding to the report to be compared based on the data retrieval mapping relationship of the first report and the second report; then, in response to a data query signal triggered in the report comparison template, it obtains the report data corresponding to the first report and the report data corresponding to the second report; finally, it compares the first report and the second report based on the report data corresponding to the first report and the report data corresponding to the second report to obtain the comparison result corresponding to the report to be compared. Thus, by constructing a report comparison template through the data retrieval mapping relationship between the old and new financial statements, and using the report comparison template to obtain the report data from the old and new reports, and finally directly comparing the old and new reports in the old and new report comparison template storing the report data, the present invention can avoid the problems of low efficiency and low accuracy of manual comparison of old and new reports, thereby improving the efficiency and accuracy of report comparison.

[0111] It is obvious to those skilled in the art that the modules or steps of the present invention described above can be implemented using general-purpose computing devices. They can be centralized on a single computing device or distributed across a network of multiple computing devices. Optionally, they can be implemented using computer-executable program code, thereby storing them in a storage device for execution by a computing device. In some cases, the steps shown or described can be performed in a different order than those presented herein, or they can be fabricated as separate integrated circuit modules, or multiple modules or steps can be fabricated as a single integrated circuit module. Thus, the present invention is not limited to any particular combination of hardware and software.

[0112] The above description is merely a preferred embodiment of the present invention and is not intended to limit the invention. Various modifications and variations can be made to the present invention by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention.

Claims

1. A report comparison method, characterized by, The method comprises: determining a data extraction mapping relationship of a first report in the to-be-compared report and a data extraction mapping relationship of a second report in the to-be-compared report, wherein the first report is a new standard financial report, the second report is an old standard financial report, and the data extraction mapping relationship is a mapping relationship between report items and subjects in the new standard financial report and the old standard financial report; based on the data extraction mapping relationship of the first report and the data extraction mapping relationship of the second report, constructing a report comparison template corresponding to the to-be-compared report; in response to a data query signal triggered in the report comparison template, obtaining report data corresponding to the first report and report data corresponding to the second report; based on the report data corresponding to the first report and the report data corresponding to the second report, comparing the first report and the second report to obtain a comparison result corresponding to the to-be-compared report; wherein, based on the data extraction mapping relationship of the first report and the data extraction mapping relationship of the second report, constructing the report comparison template corresponding to the to-be-compared report comprises: merging report items in the first report with report items of the same meaning in the second report to obtain merged report items and determining report difference items corresponding to the merged report items; merging subject items in the first report with subject items of the same meaning in the second report to obtain merged subject items and determining subject difference items corresponding to the merged subject items; based on the merged report items and the report difference items corresponding thereto, and the merged subject items and the subject difference items corresponding thereto, constructing the report comparison template corresponding to the to-be-compared report; before the response to the data query signal triggered in the report comparison template, the method further comprises: based on the data extraction mapping relationship of the first report, constructing a first query component corresponding to a first database; based on the data extraction mapping relationship of the second report, constructing a second query component corresponding to a second database; configuring the first query component and the second query component in the report comparison template, wherein the first database stores report data corresponding to the first report, and the second database stores report data corresponding to the second report.

2. The method of claim 1, wherein, before the response to the data query signal triggered in the report comparison template, the method further comprises: based on the data extraction mapping relationship of the first report, determining a calculation view corresponding to the first report; calculating the report data corresponding to the first report according to the calculation view corresponding to the first report; determining a calculation view corresponding to the second report according to the data extraction mapping relationship of the second report; calculating the report data corresponding to the second report according to the calculation view corresponding to the second report.

3. The method of claim 2, wherein, after the calculation of the report data corresponding to the first report according to the calculation view corresponding to the first report, the method further comprises: storing the report data corresponding to the first report into a first database corresponding to the first report; after the calculation of the report data corresponding to the second report according to the calculation view corresponding to the second report, the method further comprises: Store the report data corresponding to the second report into a second database corresponding to the second report.

4. The method of claim 1, wherein, The obtaining of the report data corresponding to the first report and the report data corresponding to the second report comprises: querying the report data corresponding to the first report in the first database by using the first query component; querying the report data corresponding to the second report in the second database by using the second query component.

5. The method of claim 1, wherein, The comparison of the first report and the second report based on the report data corresponding to the first report and the report data corresponding to the second report to obtain the comparison result corresponding to the report to be compared comprises: obtaining first target report data in the first report and second target report data in the second report corresponding to the same target merged report item in the report comparison template; calculating the report item data difference between the first target report data and the second target report data; obtaining third target report data in the first report and fourth target report data in the second report corresponding to the same target merged subject item in the report comparison template; calculating the subject item data difference between the third target report data and the fourth target report data, and determining the report item data difference and the subject item data difference as the comparison result corresponding to the report to be compared.

6. A report comparison apparatus, characterized by comprising: comprise: determining unit, configured to determine a data extraction mapping relationship of a first report in a report to be compared, and a data extraction mapping relationship of a second report in the report to be compared, wherein the first report is a new standard financial report, the second report is an old standard financial report, and the data extraction mapping relationship is a mapping relationship between report items and subjects in the new standard financial report and the old standard financial report; a construction unit configured to construct a report comparison template corresponding to the report to be compared based on the data extraction mapping relationship of the first report and the data extraction mapping relationship of the second report, wherein the construction of the report comparison template corresponding to the report to be compared based on the data extraction mapping relationship of the first report and the data extraction mapping relationship of the second report comprises: merging report items in the first report with report items of the same meaning in the second report to obtain merged report items, and determining report difference items corresponding to the merged report items; merging subject items in the first report with subject items of the same meaning in the second report to obtain merged subject items, and determining subject difference items corresponding to the merged subject items; and constructing the report comparison template corresponding to the report to be compared based on the merged report items and the report difference items corresponding thereto, and the merged subject items and the subject difference items corresponding thereto. The acquisition unit is configured to: construct a first query component corresponding to a first database based on a data acquisition mapping relationship of the first report; construct a second query component corresponding to a second database based on a data acquisition mapping relationship of the second report; configure the first query component and the second query component in the report comparison template, wherein the first database stores report data corresponding to the first report, and the second database stores report data corresponding to the second report; and acquire the report data corresponding to the first report and the report data corresponding to the second report in response to a data query signal triggered in the report comparison template. The comparison unit is configured to compare the first report and the second report based on the report data corresponding to the first report and the report data corresponding to the second report, and obtain a comparison result corresponding to the report to be compared.

7. A computer-readable storage medium having stored thereon a computer program, characterized in that, The computer program is executed by the processor to implement the steps of the method in any one of claims 1 to 5.

8. A computer device comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, characterized in that, The computer program is executed by the processor to implement the steps of the method in any one of claims 1 to 5.

Images