Management report generation method, electronic device, storage medium and program product

Abstract

Embodiments of the present disclosure disclose a management report generation method, an electronic device, a storage medium and a program product. The method comprises: obtaining at least one piece of accounting data, wherein the accounting data comprises accounting detail data and accounting attribute information, and the accounting attribute information is used to indicate business scenario information corresponding to the accounting data; determining a management report field corresponding to the accounting data based on the accounting attribute information, wherein the management report field is a data identifier of data in a management report, and the management report field conforms to a preset field rule; generating management report data corresponding to the accounting data based on the management report field, the accounting attribute information and the accounting detail data; and generating a management report based on the management report data corresponding to each piece of accounting data in the at least one piece of accounting data, which helps to improve the generation efficiency of the management report and the accuracy of the generated management report data.

Description

TECHNICAL FIELD

[0001] The present disclosure relates to the technical fields of Internet technology and data processing technology, and in particular, to a management report generation method, an electronic device, a storage medium, and a program product. BACKGROUND

[0002] A management report system is one of the report systems of an enterprise. The management report system is used to integrate data to obtain a management report. The management report can provide management information for internal management personnel of the enterprise. With the development of the enterprise, the data source of the management report system includes data of multiple systems, such as data of an accounting system, an allocation system, a human resource system, a financial management system, and the like.

[0003] In the related art, data in different systems is integrated and processed to obtain management report data by using an artificial integration manner. The corresponding management report is obtained by further processing. This manner needs a large amount of manual operation, and the data processing efficiency and accuracy are low. SUMMARY

[0004] Embodiments of the present disclosure provide a management report generation method, an electronic device, a storage medium, and a program product to improve the data processing efficiency and accuracy.

[0005] In one aspect of an embodiment of the present disclosure, a management report generation method is provided, including:

[0006] obtaining at least one piece of accounting data, the accounting data including accounting detail data and accounting attribute information, the accounting attribute information being used to indicate business scenario information corresponding to the accounting data;

[0007] determining a management report field corresponding to the accounting data based on the accounting attribute information, the management report field conforming to a preset field rule;

[0008] generating management report data corresponding to the accounting data based on the management report field, the accounting attribute information, and the accounting detail data;

[0009] generating a management report based on the management report data corresponding to each piece of accounting data in the at least one piece of accounting data.

[0010] In one exemplary embodiment, the determining of the management report field corresponding to the accounting data based on the accounting attribute information includes:

[0011] matching the accounting attribute information with a preset mapping rule to obtain a target mapping rule corresponding to the accounting attribute information, the preset mapping rule including an accounting attribute combination composed of different types of accounting attributes;

[0012] determine a target field rule corresponding to the target mapping rule based on the preset correspondence between the preset mapping rule and the preset field rule;

[0013] determine a management report field corresponding to the account attribute information based on the target field rule.

[0014] In an exemplary embodiment, different types of account data are preset with corresponding mapping rule libraries, and different preset mapping rules in the mapping rule libraries have different matching priorities, wherein the matching priority of the preset mapping rule is positively correlated with the number of types of account attributes included in the preset mapping rule.

[0015] The matching of the account attribute information with the preset mapping rule to obtain the target mapping rule corresponding to the account attribute information comprises:

[0016] According to the matching priority of each preset mapping rule in the target mapping rule library corresponding to the account data, the account attribute information is sequentially matched with the preset mapping rules in the target mapping rule library to obtain the target mapping rule corresponding to the account attribute information.

[0017] In an exemplary embodiment, after sequentially matching the account attribute information with the preset mapping rules in the target mapping rule library, the method further comprises:

[0018] In the case where the target mapping rule corresponding to the account attribute information is not matched, a rule adjustment prompt information is generated, and the rule adjustment prompt information is used to indicate adjustment of the preset mapping rules in the target mapping rule library.

[0019] In an exemplary embodiment, the account attribute information includes business information corresponding to the account data.

[0020] The generation of the management report data corresponding to the account data based on the management report field, the account attribute information and the account detail data comprises:

[0021] Based on the management report field and the account attribute information, management report business detail data corresponding to the account data is generated, the management report business detail data includes business detail information indicating a business scenario corresponding to the account data, and the management report business detail data belongs to the management report data.

[0022] Based on the management report field and the account detail information, management report account detail data corresponding to the account data is generated, the management report account detail data includes expense detail information corresponding to the account data, and the management report account detail data belongs to the management report data.

[0023] In an example embodiment, the generating the management report based on the management report data corresponding to each of the at least one piece of accounting data comprises:

[0024] The management business detail report includes the business information corresponding to each of the at least one piece of accounting data.

[0025] The management business detail report includes the business information corresponding to each of the at least one piece of accounting data.

[0026] In an example embodiment, the obtaining the at least one piece of accounting data comprises:

[0027] Based on the data storage mode of the accounting data in the data source, the data acquisition mode for obtaining the accounting data from the data source is determined.

[0028] Based on the data acquisition mode, the at least one piece of accounting data is obtained from the data source.

[0029] In an example embodiment, after the management report is generated, the method further comprises:

[0030] The integrity of the management report data in the management report is verified to obtain an integrity verification result, and the integrity verification result is used to indicate the integrity of the management report data containing the accounting data.

[0031] And / or,

[0032] The uniqueness of the management report data in the management report is verified to obtain a uniqueness verification result, and the uniqueness verification result is used to indicate the uniqueness of each management report data.

[0033] In an example embodiment, after the management report is generated, the method further comprises:

[0034] In response to receiving a query operation on a target management field, the target management report data corresponding to the target management field is queried from the generated management report.

[0035] The target management report data corresponding to the target management field is displayed.

[0036] Another aspect of the embodiment provides a management report generation device, comprising:

[0037] The data acquisition module is configured to acquire at least one piece of account data, wherein the account data comprises account detail data and account attribute information, and the account attribute information is used to indicate business scenario information corresponding to the account data.

[0038] The field determination module is configured to determine a report field corresponding to the account data based on the account attribute information, wherein the report field meets a preset field rule.

[0039] The data generation module is configured to generate management report data corresponding to the account data based on the report field, the account attribute information, and the account detail data.

[0040] The report generation module is configured to generate a management report based on the management report data corresponding to each piece of account data in the at least one piece of account data.

[0041] In another aspect of the embodiment, an electronic device is provided, comprising:

[0042] The memory is configured to store a computer program.

[0043] The processor is configured to execute the computer program stored in the memory, and when the computer program is executed, the method for generating a management report described in any of the above embodiments is implemented.

[0044] In another aspect of the embodiment, a computer readable storage medium is provided, and the computer readable storage medium stores a computer program. When the computer program is executed by a processor, the method for generating a management report described in any of the above embodiments is implemented.

[0045] In another aspect of the embodiment, a computer program product is provided, and the computer program product comprises a computer program. When the computer program is executed by a processor, the method for generating a management report described in any of the above embodiments is implemented.

[0046] In the embodiment of the disclosure, for the report field used to identify the management report data in the management report, a corresponding field rule is preset to unify the field rules of the report fields. For the acquired account data, the report field corresponding to the account data is determined according to the account attribute information of the account data, and the management report data corresponding to the account data is generated based on the report field and the account data. The management report corresponding to each piece of account data is generated based on the management report data of the account data. In this way, the acquired account data can be collected and processed in a unified report field information, automatic data processing of the account data is realized, the management report with a unified rule can be automatically generated, which helps to improve the efficiency and accuracy of processing the account data, thereby helping to improve the efficiency of generating the management report and the accuracy of the generated management report data. In addition, the management report with a unified rule can improve the efficiency of data query and data tracing based on the management report.

[0047] The technical solutions of the present disclosure will be further described in detail below with the aid of the accompanying drawings and examples. BRIEF DESCRIPTION OF DRAWINGS

[0048] The accompanying drawings, which form a part of the specification, illustrate the embodiments of the present disclosure and, together with the description, serve to explain the principles of the present disclosure.

[0049] The present disclosure can be more clearly understood and appreciated by reference to the following detailed description taken in conjunction with the accompanying drawings, in which:

[0050] Figure 1 The flowchart of the method for generating a management report provided for an exemplary embodiment of the present disclosure;

[0051] Figure 2 The flowchart of the method for determining a pipe report field provided for an exemplary embodiment of the present disclosure;

[0052] Figure 3 The flowchart of the method for obtaining accounting data provided for an exemplary embodiment of the present disclosure;

[0053] Figure 4 The flowchart of the method for generating a management report provided for an exemplary embodiment of the present disclosure;

[0054] Figure 5 The page schematic diagram of the pipe report detail query page provided for an exemplary embodiment of the present disclosure;

[0055] Figure 6 The structural schematic diagram of the device for generating a management report provided for an exemplary embodiment of the present disclosure;

[0056] Figure 7 The structural schematic diagram of the electronic device provided for an exemplary embodiment of the present disclosure. DETAILED DESCRIPTION

[0057] Various exemplary embodiments of the present disclosure will now be described in detail below with reference to the accompanying drawings. Note that the relative arrangement, numerical expressions, and values of the components and steps set forth in these embodiments do not limit the scope of the present disclosure unless otherwise specifically stated.

[0058] Those skilled in the art can understand that the terms "first", "second", and the like in the embodiments of the present disclosure are only used to distinguish different steps, devices, or modules, and do not represent any specific technical meaning, nor do they represent a necessary logical sequence between them.

[0059] It should also be understood that in the embodiments of the present disclosure, "a plurality of" can mean two or more, and "at least one" can mean one, two, or more.

[0060] It should also be understood that, for any components, data, or structures mentioned in the embodiments of the present disclosure, one or more can be generally understood unless specifically limited or contrary implications are given in the context.

[0061] In addition, the term "and / or" in the present disclosure is merely a description of the association relationship of the associated objects, which means that there can be three relationships, for example, A and / or B can represent the three cases of A alone, A and B together, and B alone. In addition, the character " / " in the present disclosure generally represents an "or" relationship between the front and rear associated objects.

[0062] It should also be understood that the description of the embodiments of the present disclosure emphasizes the differences between the embodiments, and the same or similar parts can be referred to each other, and for the sake of brevity, will not be repeated.

[0063] At the same time, it should be understood that, for the convenience of description, the size of each part shown in the drawings is not drawn according to the actual proportion relationship.

[0064] The following description of at least one example embodiment is merely illustrative in nature and is in no way intended to limit the present disclosure, its application, or uses.

[0065] Techniques, methods, and devices known to those of ordinary skill in the relevant art can not be discussed in detail, but should be considered part of the specification where appropriate.

[0066] It should be noted that: similar signs and letters represent similar items in the following drawings, so once an item is defined in one drawing, it does not need to be further discussed in the subsequent drawings.

[0067] Embodiments of the present disclosure can be applied to terminal devices, computer systems, servers and other electronic devices, which can operate with many other general or special computing system environments or configurations. Examples of well-known terminal devices, computing systems, environments, and / or configurations suitable for use with terminal devices, computer systems, servers and other electronic devices include, but are not limited to: personal computer systems, server computer systems, thin clients, thick clients, handheld or laptop devices, microprocessor-based systems, set-top boxes, programmable consumer electronics, network personal computers, small computer systems, mainframe computer systems, and distributed cloud computing technology environments including any of the above systems, etc.

[0068] Electronic devices such as terminal devices, computer systems, servers, and the like can be described in the general context of computer system-executable instructions, such as program modules, being executed by a computer system. Generally, program modules can include routines, programs, objects, components, logic, data structures, and the like that perform particular tasks or implement particular abstract data types. Computer systems / server can be practiced in distributed cloud computing environments with other computer systems coupled via communication networks. The program modules can be stored in the local or remote computer system memory devices.

[0069] Figure 1 is a flowchart of a method for generating a management report according to an example embodiment of the present disclosure. The method provided by the embodiment of the present disclosure can be used in an electronic device, such as Figure 1 As shown in FIG. 1, the method includes the following steps:

[0070] Step 101, obtaining at least one piece of accounting data.

[0071] The accounting data includes accounting detail data and accounting attribute information, and the accounting attribute information is used to indicate business scenario information corresponding to the accounting data.

[0072] In the embodiment of the present disclosure, the accounting data is used to indicate the detail data of the income, cost, and the like of the business in the corresponding business scenario. In a possible implementation, at least one piece of accounting data can be obtained from a data source for storing different types of accounting data. Illustratively, the different types of accounting data can include external business accounting data from an external data system, human cost accounting data from an internal human system, internal business accounting data from an internal financial management system, and the like.

[0073] Any accounting data includes accounting detail data and accounting attribute information, wherein the accounting detail data is the corresponding expense detail data in the accounting data, and the accounting attribute information includes the business scenario corresponding to the accounting data, such as the organization, the business type, the accounting subject, and the like from which the accounting data is derived.

[0074] Step 102, determining a management report field corresponding to the accounting data based on the accounting attribute information.

[0075] The management report field is a data identifier of the data in the management report, and is used to indicate the business scenario corresponding to the data in the management report. In the embodiment of the present disclosure, the management report field conforms to a preset field rule. The field rule can indicate at least one of the field type, the field content, and the field format of each field that needs to be included in the management report field. In a possible implementation, a unified field rule is set in advance to unify the management report fields in the management report, so as to facilitate the query and the data traceability.

[0076] Optionally, the field rules corresponding to different types of accounting data can be set, and after the accounting data is obtained, the field rules corresponding to the accounting data are determined according to the accounting attribute information of the accounting data, and then the reporting field is extracted from the accounting attribute information based on the field rules.

[0077] In step 103, the management report data corresponding to the accounting data is generated based on the reporting field, the accounting attribute information and the accounting detail data.

[0078] After the reporting field is determined based on the accounting attribute information, the reporting field corresponding to the accounting data is obtained, and the data information required in the management report data is extracted from the accounting data, and the management report data corresponding to the accounting data is generated based on the reporting field and the extracted data information.

[0079] Optionally, the business information required in the management report data can be extracted from the accounting attribute information, the expense detail information required in the management report data is extracted from the accounting detail data, and then the corresponding management report data is generated in combination with the reporting field.

[0080] In step 104, the management report is generated based on the management report data corresponding to each piece of accounting data in the at least one piece of accounting data.

[0081] After the management report data corresponding to each piece of accounting data is generated, the management report can be obtained by combining the management report data. In one possible implementation, the management report summary table can be obtained by combining the management report data corresponding to each piece of accounting data. In another possible implementation, the management report data can be divided according to the data types of the accounting data, so as to obtain different types of management reports. In combination with the above example, the management report corresponding to the external business can be generated according to the external business accounting data, the management report corresponding to the human cost can be generated according to the human cost accounting data, and the management report corresponding to the internal business can be generated according to the internal business accounting data. In another possible implementation, the accounting data can be further divided, such as being divided based on different organization information corresponding to the accounting data, so as to obtain the management reports corresponding to different organizations.

[0082] In the embodiments of the present disclosure, for the management report field used to identify the management report data in the management report, a corresponding field rule is set in advance, and the field rules of the management report fields are unified. For the obtained accounting data, the management report field corresponding to the accounting data is determined according to the accounting attribute information of the accounting data, and the management report data corresponding to the accounting data is generated based on the management report field and the accounting data. The management report corresponding to each accounting data is generated based on the management report data of each accounting data. In this way, the obtained accounting data can be collected and processed in the unified management report field information, the automatic data processing of the accounting data is realized, the management report with unified rules can be automatically generated, which helps to improve the efficiency and accuracy of processing the accounting data, thereby helping to improve the generation efficiency of the management report and the accuracy of the generated management report data. In addition, the generation of the management report with unified rules can improve the efficiency of data query and data tracing based on the management report.

[0083] In a possible implementation, a plurality of mapping rules are set in advance, and each of the plurality of mapping rules corresponds to a field rule. The management report field corresponding to the accounting attribute information is determined based on the preset mapping rule and the corresponding field rule. Figure 2 As shown in FIG. 2, the step 102 can include steps 201-203.

[0084] In step 201, the accounting attribute information is matched with the preset mapping rule to obtain the target mapping rule corresponding to the accounting attribute information. The preset mapping rule includes an accounting attribute combination composed of different types of accounting attributes.

[0085] The preset mapping rule is obtained based on the combination of different business scenarios of different accounting data. The preset mapping rule includes an accounting attribute combination composed of different types of accounting attributes, and different accounting attribute combinations are used to indicate different business scenario combinations. The accounting attribute information is matched with the accounting attribute combination corresponding to the preset mapping rule to determine the accounting attribute combination corresponding to the accounting data, thereby determining the business scenario combination corresponding to the accounting data. Optionally, a plurality of preset mapping rules can be set for different business scenario combinations. Illustratively, the preset mapping rules can include mapping rule one: accounting subject + business type + accounting category + legal person company (obtained by combining four types of accounting attributes); mapping rule two: accounting subject + business type + legal person company (obtained by combining three types of accounting attributes); and different mapping rules.

[0086] In a possible implementation, the accounting attribute information can be matched with a plurality of preset mapping rules one by one to obtain the target mapping rule corresponding to the accounting attribute information.

[0087] Different types of accounting data correspond to different business scenarios. Optionally, a corresponding mapping rule library can be set for different types of accounting data, and the mapping rule library includes multiple preset mapping rules of the corresponding type of accounting data. In an exemplary example, the preset mapping rules included in the mapping rule library set for internal business accounting data from the internal system can include accounting subject + business type + accounting category + legal person company; accounting subject + business type + legal person company, etc. The preset mapping rules included in the mapping rule library set for external business accounting data from the external taxi service system can include car use permission + department attribute + organization; car use permission + department attribute, etc.

[0088] In a possible implementation, after obtaining the accounting attribute information, the corresponding target mapping rule library can be determined according to the accounting data, and the accounting attribute information is sequentially matched with each preset mapping rule in the target mapping rule library to obtain the target mapping rule corresponding to the accounting attribute information. Optionally, the preset mapping rule with the highest matching degree can be determined as the target mapping rule corresponding to the accounting attribute information.

[0089] In another possible implementation, the multiple preset mapping rules included in the mapping rule library are pre-set with different matching priorities. The matching priority can be determined according to the business scenario combination indicated by the accounting attribute combination included in the preset mapping rule. The higher the degree of detail of the preset mapping rule, the higher the matching priority, that is, the matching priority is positively correlated with the degree of detail of the accounting attribute combination.

[0090] In an example, the matching priority of the preset mapping rule is positively correlated with the number of types of accounting attributes included in the preset mapping rule. The preset mapping rule includes an accounting attribute combination composed of different types of accounting attributes. The more different types of accounting attributes the accounting attribute combination is composed of, the higher the matching priority of the corresponding preset mapping rule. Illustratively, mapping rule one (accounting subject + business type + accounting category + legal person company) includes four different types of accounting attributes, and mapping rule two (accounting subject + business type + legal person company) includes three different types of accounting attributes. The matching priority of mapping rule one is higher than that of mapping rule two.

[0091] Further, when the number of types of the accounting attributes included in different preset mapping rules is the same, the matching priority corresponding to different preset mapping rules can be determined according to the accounting demand degrees corresponding to different accounting attributes included in the different preset mapping rules, wherein the accounting demand degree refers to the demand degree of writing the accounting attribute into the management report, and the accounting demand degrees corresponding to different accounting attributes can be obtained by the business personnel according to the demand in advance. Illustratively, the number of types of the accounting attributes included in the mapping rule three (accounting subject + contract type + legal person company + city) and the mapping rule four (accounting subject + accounting category + legal person company + city) is the same, and different accounting attributes are included, that is, contract type and accounting category, wherein the accounting demand degree of the contract type is higher than the accounting demand degree of the accounting category, and it can be determined that the matching priority of the mapping rule three is higher than the matching priority of the mapping rule four.

[0092] It should be noted that the above only exemplarily illustrates the setting rule of the matching priority of the preset mapping rule, but does not constitute a limitation, and the matching priority of the preset mapping rule can also be obtained by the business personnel according to other rules in advance.

[0093] When the accounting attribute information is sequentially matched with the preset mapping rules in the target mapping rule library, the target mapping rule corresponding to the accounting attribute information can be obtained based on the matching priorities of the preset mapping rules in the target mapping rule library. That is, when the preset mapping rules in the target mapping rule library are sequentially matched based on the priorities of the preset mapping rules, if a corresponding preset mapping rule is matched, the corresponding preset mapping rule is determined as the target mapping rule, and the matching process of the accounting attribute information and the preset mapping rules with a priority lower than the target mapping rule is stopped. Optionally, the preset mapping rules can be pre-stored in the mapping rule table, and the preset mapping rules in the mapping rule table are sorted according to the matching priorities, when the accounting attribute information is sequentially matched with the preset mapping rules in the target mapping rule library, the mapping rule table can be obtained, and each preset mapping rule in the mapping rule table is matched with the accounting attribute information one by one according to the order of the preset mapping rules in the mapping rule table, so as to obtain the target mapping rule corresponding to the accounting attribute information.

[0094] Illustratively, in combination with the above example, the matching priority of the mapping rule one (accounting subject + business type + accounting category + legal person company) is higher than the matching priority of the mapping rule two (accounting subject + business type + legal person company), and in the process of matching based on the mapping rule one and the mapping rule two, the accounting attribute information is first matched with the mapping rule one, if the mapping rule one is matched, the mapping rule one is determined as the target mapping rule, and if the mapping rule one is not matched, the mapping rule two is continued to be matched.

[0095] The business scenario combination corresponding to the preset mapping rule can not completely cover different accounting data. In a possible implementation, in a case where the target mapping rule corresponding to the accounting attribute information is not matched, a rule adjustment prompt information is generated, and the rule adjustment prompt information is used to indicate adjustment of the preset mapping rule in the target mapping rule library. The accounting attribute information that is not matched successfully can be included in the rule adjustment prompt information, so that the user can add the corresponding mapping rule according to the accounting attribute information that is not matched successfully, and the coverage of the preset mapping rule on different business scenario combinations can be improved.

[0096] In step 202, a target field rule corresponding to the target mapping rule is determined based on a preset correspondence between the preset mapping rule and the preset field rule.

[0097] In a possible implementation, the preset field rule corresponding to different preset mapping rules can be preset, that is, there is a preset correspondence between different preset mapping rules and different preset field rules. Optionally, the preset correspondence can be a many-to-one relationship or a one-to-one relationship. The many-to-one relationship means that multiple preset mapping rules can correspond to the same preset field rule, and the one-to-one relationship means that one preset mapping rule corresponds to one preset field rule.

[0098] After the target mapping rule corresponding to the accounting attribute information is determined, the target field rule corresponding to the target mapping rule can be determined according to the preset correspondence between the preset mapping rule and the preset field rule.

[0099] In step 203, a report field corresponding to the accounting attribute information is determined based on the target field rule.

[0100] In a possible implementation, the report field corresponding to the accounting attribute information is generated according to the field content and the field format that need to be included in the target field rule.

[0101] Illustratively, when the accounting attribute information includes the legal person code, the legal person name, the accounting subject code, and the accounting subject name, the target mapping rule matched is the accounting subject+business type+legal person company, the target field rule corresponding to the target mapping rule indicates that the field types in the report field include a report entity and a report subject, the report entity includes two field contents, which are a report entity code ENTITY_CODE and a report entity name ENTITY_NAME, and the report subject includes two field contents, which are a report subject code ACCOUNT_M and a report subject name ACCOUNT_M_NAME. The report entity can be determined according to the legal person company and the business type, and the report subject can be determined according to the accounting subject. The legal person company, the business type, and the accounting subject are extracted from the accounting attribute information to generate the corresponding report entity field and the report subject field.

[0102] In the embodiments of the present disclosure, a preset mapping rule for indicating different business scenario combinations is pre-set, the account attribute information of the account data is matched with different preset mapping rules to obtain a corresponding target mapping rule, and then the target field rule corresponding to the target mapping rule is used to generate the management report field corresponding to the account attribute information, so that the account attribute information is processed into the management report field with a unified rule, facilitating subsequent data query and data traceability of the management report data.

[0103] Optionally, the management report data can include management report business detail data and management report account detail data. The management report business detail data refers to the business detail information of the business scenario corresponding to the account data. In an example, the business detail information can be business information other than expense information, for example, at least one of business correspondence information, order information corresponding to the business, business personnel information, etc. For example, when the account data is a taxi bill data, the generated management report business detail data can include order details of a taxi order, such as distance, time, etc. The management report account detail data refers to the specific expense detail information corresponding to the account data, including at least one of income details, cost expense details, and expense details.

[0104] In a possible implementation, based on the management report field, the account attribute information, and the account detail data, the management report data corresponding to the account data includes the management report business detail data corresponding to the account data and the management report account detail data corresponding to the account data. Optionally, based on the management report field and the account attribute information, the management report business detail data corresponding to the account data is generated; and based on the management report field and the account detail information, the management report account detail data corresponding to the account data is generated. According to the business information in the management report field and the account attribute information, the management report business detail data is generated, which includes the management report field and the business detail information. The management report field is used to indicate the corresponding business scenario, and the business detail information is used to indicate the detailed business information corresponding to the business scenario. The business detail information is business execution related information other than expense details, for example, in a car use scenario, the business detail information includes specific car use order number, car use personnel, and use time information. The management report account detail data generated according to the management report field and the account detail information includes the management report field and the expense detail information. The management report field is used to indicate the business scenario corresponding to the expense detail, and the expense detail includes at least one of income details and cost expense details.

[0105] After the management report data is generated, a management report can be generated according to the management report data. Optionally, based on the management business detail data corresponding to each piece of the at least one piece of accounting data, a management business detail report is generated, and the management business detail report includes the business detail information corresponding to each piece of the accounting data; based on the management accounting detail data corresponding to each piece of the at least one piece of accounting data, a management accounting detail report is generated, and the management accounting detail report includes the accounting detail information corresponding to each piece of the accounting data.

[0106] In a possible implementation, when the management business detail report is generated based on the management business detail data corresponding to each piece of the at least one piece of accounting data, different types of management business detail reports can be generated according to the types of the accounting data. That is, the management business detail data corresponding to each piece of the accounting data is classified according to the types of the accounting data to obtain different types of management business detail data, and then the different types of management business detail data are combined to obtain the corresponding management business detail report. In combination with the above example, the management business detail report corresponding to each type of accounting data can be generated respectively for the external business accounting data, the human cost accounting data, and the internal business accounting data.

[0107] In a possible implementation, the generated management accounting detail report can include a first-level accounting detail report and a second-level accounting detail report, wherein the first-level accounting detail report includes the total accounting data of each piece of accounting data of different sources, and the second-level accounting detail report includes at least one of the classified detailed accounting data of the total accounting data and the accounting data (such as the accounting data corresponding to the virtual currency) not included in the total accounting data. In an example, the generated management business detail report can also be included in the second-level accounting detail report, which is used to supplement the business detail information of the accounting detail report.

[0108] In the embodiments of the present disclosure, the management detail table corresponding to the business information and the cost information in the accounting data is generated respectively, which can improve the efficiency of the user inquiring different types of information.

[0109] The accounting data can be obtained from a pre-set data source, and the pre-set data source can include a plurality of data sources. For example, Figure 3 As shown in FIG. 3, obtaining the at least one piece of accounting data from the data source includes the following steps 301-302:

[0110] In step 301, based on the data storage mode of the accounting data in the data source, a data acquisition mode for acquiring the accounting data from the data source is determined.

[0111] In a possible implementation, the data acquisition method can be determined based on the data storage method of the data source for storing accounting data. Schematically, when the data source uses an Oracle database to store data, the Oracle Database Link method can be used to establish a connection between the Oracle database and the management and reporting database to extract the accounting data in the Oracle database and store it in the management and reporting database. The management and reporting database is the database of the management and reporting automation system for automatically generating management reports. Optionally, the management and reporting database can be an Oracle database. When the data source is a big data system, the Hive2Oracle method can be used to establish a connection between the big data system and the management and reporting database to extract the accounting data in the big data system into the management and reporting database. When the data source provides an application programming interface (API), the accounting data in the data source can be obtained based on the HTTP protocol. When the data source uses the Kafka system, the accounting data in the data source can be obtained based on the Kafka interface protocol.

[0112] Step 302: Obtain at least one piece of accounting data from a data source based on a data acquisition method.

[0113] At least one piece of account data is obtained from a data source according to a determined data acquisition method, and each piece of account data in the at least one piece of account data is processed to obtain corresponding management report data, thereby generating a management report.

[0114] In a possible implementation, the generation process of the management report is as follows: Figure 4 As shown, first, accounting data is obtained from each accounting system. The accounting system includes a business and financial data platform, an external business system, a payroll data warehouse, and a financial management system. The accounting data of the business can be obtained from the business and financial data platform, such as the accounting data of gas station-related businesses and the business data of advertising-related businesses (including cost per successful transaction (Cost Per Sale, CPS), cost per data (Cost Per Lead, CPL) data, etc.), and the billing data of external businesses can be obtained from the external business system, such as taxi bill data from the external taxi system, express bill data from the external express company, salary data and corresponding personnel information from the payroll data warehouse, and account details from the financial management system (which can be an EBS system), for example, it can include general ledger management data (General Ledger, GL), accounts payable management data (Account Payable, AP), fixed asset management data (Fixed Asset, FA), and accounts receivable management data (Account Receivable, AR), etc.

[0115] The basic information required for generating the management report field (including the above-mentioned accounting attribute information) is extracted from the obtained accounting data. For example, human resource structure information, organization information, contract information, labor cost information, and business information can be obtained. Then, the corresponding target mapping rule is determined according to the preset mapping rule in the rule library. In an example, a first mapping rule library can be set for the accounting data in the industry and finance data center, a second mapping rule library can be set for the billing data of the external business system, a third mapping rule library can be set for the salary data of the salary data warehouse, and a fourth mapping rule library can be set for the entry details of the financial management system. After obtaining the accounting data in the industry and finance data center, the preset mapping rule in the first mapping rule library is matched. After obtaining the billing data of the external business system, the preset mapping rule in the second mapping rule library is matched. After obtaining the salary data of the salary data warehouse, the preset mapping rule in the third mapping rule library is matched. After obtaining the entry details of the financial management system, the preset mapping rule in the fourth mapping rule library is matched.

[0116] After the accounting data is matched, the collection and processing of the management report field can be performed. That is, the corresponding target field rule is determined according to the determined target mapping rule, and the management report field corresponding to the accounting attribute information of each accounting data is generated according to the target field rule. Based on the management report field, the accounting attribute information, and the accounting detail data of each accounting data, a second type of management report detail table (also referred to as a management report business detail report) and a first type of management report detail table (also referred to as a management report accounting detail report) are generated. The second type of management report detail table can include corresponding accounting business detail tables (such as gas station business refueling details, advertising business placement details), billing business detail tables (such as vehicle use details, express delivery details), and labor cost detail tables. The first type of management report detail table includes an income detail table and a cost and expense detail table.

[0117] In a possible implementation, Oracle Data Integratorllg can be used as a scheduling tool to perform the above-mentioned processes of obtaining accounting data, data conversion to obtain management report fields, and loading management reports.

[0118] In the embodiments of the present disclosure, the data acquisition manner for obtaining accounting data from the data source is determined according to the data storage manner of the data source. The accounting data obtained by the corresponding data acquisition manner is stored in the management report database. The data link between different data sources can be established to realize data integration of different data sources.

[0119] In the embodiments of the present disclosure, after the management report is generated, data verification is performed on the data in the management report to ensure the accuracy of the management report data in the management report. Optionally, the data verification includes at least one of integrity verification and uniqueness verification.

[0120] In a possible implementation, the management report data in the management report is subjected to integrity checking, and an integrity checking result is obtained, which is used to indicate the integrity of the accounting data contained in the management report data. The integrity checking refers to checking the integrity of the management report data contained in the management report, whether it includes all the obtained accounting data. When checking, the data amount (data quantity) of the management report data can be matched with the data amount (data quantity) of the obtained accounting data, and the integrity checking result is determined based on the data amount matching result. In the case where the data amount matching result indicates that the data amounts are the same, it is determined that the integrity checking result is passed, and if they are not the same, it is determined that the integrity checking result is failed. In another possible implementation, the total amount corresponding to the management report data can be matched with the total amount corresponding to the accounting data, and in the case where the total amounts are matched, it is determined that the integrity checking result is passed. In another possible implementation, the integrity checking result can be determined based on the data amount matching result and the total amount matching result. In the case where the data amount matching result indicates that the data amounts are the same and the total amount matching result indicates that the total amounts are the same, it is determined that the integrity checking result is passed.

[0121] In a possible implementation, the management report data in the management report can be subjected to uniqueness checking, and a uniqueness checking result is obtained, which is used to indicate the uniqueness of each management report data. In the uniqueness checking process, the identification field used to identify the unique data can be checked, for example, the uniqueness checking can be performed based on the financial voucher number, order number, etc. In the case where the identification field used to identify the unique data is not unique, that is, there are more than or equal to two, it is determined that the management report data identified by the identification field is not unique, and the uniqueness checking result is failed.

[0122] In the case where the data checking is failed, the warning information can be generated and displayed to prompt the abnormal management report data, so as to facilitate the user to timely troubleshoot. For example, in the case where the integrity checking is failed, the warning information corresponding to the failed integrity checking can be displayed to make the user troubleshoot the data integrity; in the case where the uniqueness checking is failed, the repeated data can be displayed to make the user process the repeated data.

[0123] In the embodiments of the present disclosure, after the management report is generated, the management report data is subjected to data checking to ensure the accuracy of the management report data.

[0124] In a possible implementation, after the management report is generated, the management report can be stored, and the user can perform corresponding data query. The process of data query can include the following steps:

[0125] Step one, in response to receiving the query operation on the target pipe report field, querying the target management report data corresponding to the target pipe report field from the generated management report.

[0126] Optionally, a pipe report detail query page can be provided, and the pipe report detail query page provides selection items based on pipe report fields, such as Figure 5 As shown, selection items based on pipe report entities and pipe report subjects can be provided, and in response to the pipe report detail query page detecting a selection operation on a target pipe report field, it is determined that a query operation on the target pipe report field is received, and the target management report data corresponding to the target pipe report field can be queried from the generated management report.

[0127] Step two, display the target management report data corresponding to the target pipe report field.

[0128] After querying the target management report data, display the target management report data corresponding to the target pipe report field on the pipe report detail query page.

[0129] In another possible implementation, in addition to enabling the query of the corresponding management report data based on the pipe report field in the pipe report detail query page, the query of the management report data based on the source field can also be provided, wherein the source field refers to the source field included in the obtained financial data, and the generated management report data is queried based on the source field. As shown in Figure 5 The source field can include accounting subjects, sources, items, voucher numbers, contract numbers, and counterpart unit codes, and the pipe report detail query page includes selection items corresponding to different source fields, so that the corresponding management report data can be queried through the selection of the source field.

[0130] Figure 6 An example embodiment of the present disclosure provides a structure diagram of a device for determining the generation of a management report, which can be used in the electronic device involved in the above embodiments, and the device includes:

[0131] The data acquisition module 601 is configured to acquire at least one piece of account data, wherein the account data includes account detail data and account attribute information, and the account attribute information is used to indicate business scenario information corresponding to the account data.

[0132] The field determination module 602 is configured to determine a pipe report field corresponding to the account data based on the account attribute information, wherein the pipe report field meets a preset field rule.

[0133] The data generation module 603 is configured to generate management report data corresponding to the account data based on the pipe report field, the account attribute information, and the account detail data.

[0134] The report generation module 604 is configured to generate a management report based on management report data corresponding to each piece of the at least one piece of accounting data.

[0135] In an example embodiment, the field determination module 602 is further configured to:

[0136] match the accounting attribute information with a preset mapping rule to obtain a target mapping rule corresponding to the accounting attribute information, the preset mapping rule including an accounting attribute combination composed of different types of accounting attributes;

[0137] determine a target field rule corresponding to the target mapping rule based on a preset correspondence between the preset mapping rule and a preset field rule;

[0138] determine a management report field corresponding to the accounting attribute information based on the target field rule.

[0139] In an example embodiment, different types of accounting data are preset with corresponding mapping rule libraries, different preset mapping rules in the mapping rule libraries have different matching priorities, and the matching priority of the preset mapping rule is positively correlated with the number of types of accounting attributes included in the preset mapping rule.

[0140] The field determination module 602 is further configured to:

[0141] match the accounting attribute information with preset mapping rules in a target mapping rule library corresponding to the accounting data in sequence according to the matching priorities of the preset mapping rules in the target mapping rule library to obtain a target mapping rule corresponding to the accounting attribute information.

[0142] In an example embodiment, the apparatus further includes:

[0143] An information generation module configured to generate a rule adjustment prompt information in a case where a target mapping rule corresponding to the accounting attribute information is not matched, the rule adjustment prompt information being used to instruct to adjust a preset mapping rule in the target mapping rule library.

[0144] In an example embodiment, the accounting attribute information includes business information corresponding to the accounting data.

[0145] The data generation module 603 is further configured to:

[0146] generate management report business detail data corresponding to the accounting data based on the management report field and the accounting attribute information, the management report business detail data including business detail information used to indicate a business scenario corresponding to the accounting data, and the management report business detail data belonging to the management report data.

[0147] Based on the pipe report field and the account detail information, pipe report account detail data corresponding to the account data is generated, and the pipe report account detail data belongs to the management report data.

[0148] In an exemplary embodiment, the report generation module 604 is further configured to:

[0149] Based on the management business detail data corresponding to each account data in the at least one account data, a management business detail report is generated, and the management business detail report includes the business detail information corresponding to each account data;

[0150] Based on the management account detail data corresponding to each account data in the at least one account data, a management account detail report is generated, and the management account detail report includes the expense detail information corresponding to each account data.

[0151] In an exemplary embodiment, the data acquisition module 601 is further configured to:

[0152] Based on the data storage mode of the account data in the data source, a data acquisition mode for acquiring the account data from the data source is determined;

[0153] Based on the data acquisition mode, the at least one account data is acquired from the data source.

[0154] In an exemplary embodiment, the apparatus further comprises:

[0155] A data verification module is configured to perform integrity verification on the management report data in the management report to obtain an integrity verification result, and the integrity verification result is used to indicate the integrity of the account data included in the management report data;

[0156] And / or,

[0157] The data verification module is further configured to perform uniqueness verification on the management report data in the management report to obtain a uniqueness verification result, and the uniqueness verification result is used to indicate the uniqueness of each management report data.

[0158] In an exemplary embodiment, the apparatus further comprises:

[0159] A data query module is configured to query target management report data corresponding to a target pipe report field from the generated management report in response to receiving a query operation on the target pipe report field;

[0160] A data display module is configured to display the target management report data corresponding to the target pipe report field.

[0161] The management report generation apparatus of the disclosed embodiments corresponds to the management report generation method of the disclosed embodiments described above, and the relevant contents can be referenced in conjunction with each other, and are not further described here. The beneficial technical effects corresponding to the management report generation apparatus of the disclosed embodiments can be found in the corresponding beneficial technical effects of the exemplary method described above, and are not further described here.

[0162] In addition, an embodiment of the present disclosure further provides an electronic device, including:

[0163] memory for storing computer programs;

[0164] The processor is configured to execute the computer program stored in the memory, and when the computer program is executed, the method for generating a management report described in any one of the above embodiments of the present disclosure is implemented.

[0165] Figure 7 This is a schematic diagram of the structure of an application embodiment of the electronic device disclosed in the present invention. Figure 7 The electronic device according to the embodiment of the present disclosure is described. The electronic device may be either or both of the first device and the second device, or a standalone device independent of them, and the standalone device may communicate with the first device and the second device to receive collected input signals from them.

[0166] like Figure 7 As shown, the electronic device includes one or more processors and memory.

[0167] The processor may be a central processing unit (CPU) or other forms of processing units having data processing capabilities and / or instruction execution capabilities, and may control other components in the electronic device to perform desired functions.

[0168] The memory may include one or more computer program products, which may include various forms of computer-readable storage media, such as volatile memory and / or non-volatile memory. The volatile memory may include, for example, random access memory (RAM) and / or cache memory. The non-volatile memory may include, for example, read-only memory (ROM), a hard disk, flash memory, etc. One or more computer program instructions may be stored on the computer-readable storage medium, and the processor may execute the program instructions to implement the management report generation method of the various embodiments of the present disclosure described above and / or other desired functions.

[0169] In one example, the electronic device may further include an input device and an output device, and these components are interconnected via a bus system and / or other forms of connection mechanisms (not shown).

[0170] In addition, the input device can include, for example, a keyboard, a mouse, and the like.

[0171] The output device can output various information, including the determined distance information, direction information, and the like, to the outside. The output device can include, for example, a display, a speaker, a printer, a communication network and a remote output device connected thereto, and the like.

[0172] Of course, in order to simplify, Figure 7 Only some of the components of the electronic device related to the present disclosure are shown in FIG. 1, and components such as a bus, an input / output interface, and the like are omitted. In addition, the electronic device can further include any other appropriate components according to a specific application.

[0173] In addition to the above-described method and device, an embodiment of the present disclosure can be a computer program product including computer program instructions that, when executed by a processor, cause the processor to perform the steps of the method of generating a management report according to various embodiments of the present disclosure described in the above parts of the specification.

[0174] The computer program product can be written in any combination of one or more programming languages, including an object-oriented programming language such as Java, C++, and the like, and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code can be executed entirely on the user computing device, partially on the user device, as a stand-alone software package, partially on the user computing device and partially on a remote computing device, or entirely on a remote computing device or server.

[0175] In addition, an embodiment of the present disclosure can also be a computer readable storage medium having stored thereon computer program instructions, which, when executed by a processor, cause the processor to perform the steps of the method of generating a management report according to various embodiments of the present disclosure described in the above parts of the specification.

[0176] The computer readable storage medium can be a combination of one or more computer readable media. The computer readable media can be a computer readable signal medium or a computer readable storage medium. The computer readable storage medium can include, for example, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium include the following: an electrical connection having one or more wires, a portable disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0177] Those skilled in the art can understand that all or part of the steps of the above-mentioned method embodiments can be completed by program instruction related hardware, and the foregoing program can be stored in a computer readable storage medium. When the program is executed, the steps of the method embodiments are executed; and the foregoing storage medium includes ROM, RAM, magnetic disk or optical disk and various storage media that can store program codes.

[0178] The above describes the basic principles of the present disclosure in combination with specific embodiments. However, it should be noted that the advantages, advantages, effects and the like mentioned in the present disclosure are only examples and are not limiting. These advantages, advantages, effects and the like cannot be considered as necessary for each embodiment of the present disclosure. In addition, the above specific details are only for the purpose of example and for the purpose of understanding, and the above details do not limit the present disclosure to the above specific details.

[0179] Each embodiment in the specification is described in a progressive manner, and each embodiment focuses on the difference from other embodiments. The same or similar parts between each embodiment can be referred to each other. For system embodiments, since they basically correspond to method embodiments, the description is relatively simple, and the relevant parts can be referred to the part of the method embodiment.

[0180] The block diagrams of the devices, apparatuses, equipment, systems involved in the present disclosure are only illustrative examples and are not intended to require or imply the connection, arrangement, configuration shown in the block diagram. As those skilled in the art will recognize, these devices, apparatuses, equipment, systems can be connected, arranged, configured in any way. Words such as "include", "contain", "have" and the like are open-ended words, which mean "include but not limited to", and can be used interchangeably. The words "or" and "and" used herein mean the word "and / or", and can be used interchangeably unless the context clearly indicates otherwise. The word "such as" used herein means the phrase "such as but not limited to", and can be used interchangeably.

[0181] The methods and apparatus of the present disclosure may be implemented in many ways. For example, the methods and apparatus of the present disclosure may be implemented by software, hardware, firmware, or any combination of software, hardware, and firmware. The above order of steps for the method is for illustration only, and the steps of the method of the present disclosure are not limited to the order specifically described above unless otherwise specified. In addition, in some embodiments, the present disclosure may also be implemented as programs recorded in a recording medium, which include machine-readable instructions for implementing the methods according to the present disclosure. Thus, the present disclosure also covers recording media that store programs for executing the methods according to the present disclosure.

[0182] It should also be noted that in the apparatus, device, and method of the present disclosure, each component or each step can be decomposed and / or recombined. Such decomposition and / or recombination should be regarded as equivalent solutions of the present disclosure.

[0183] The above description of the disclosed aspects is provided to enable any person skilled in the art to make or use the present disclosure. Various modifications to these aspects will be readily apparent to those skilled in the art, and the general principles defined herein may be applied to other aspects without departing from the scope of the present disclosure. Therefore, the present disclosure is not intended to be limited to the aspects shown herein, but rather to be accorded the widest scope consistent with the principles and novel features disclosed herein.

[0184] The above description has been provided for the purpose of illustration and description. In addition, this description is not intended to limit the embodiments of the present disclosure to the forms disclosed herein. Although a number of example aspects and embodiments have been discussed above, those skilled in the art will recognize certain variations, modifications, alterations, additions, and sub-combinations thereof.

Claims

1. A method for generating a management report, characterized in that: The method comprises: Acquire at least one piece of account data, wherein the account data includes detailed account data and account attribute information, wherein the account attribute information is used to indicate business scenario information corresponding to the account data; Determining, based on the account attribute information, a management report field corresponding to the account data, wherein the management report field is a data identifier of data in a management report and the management report field complies with a preset field rule; generating management report data corresponding to the account data based on the management report field, the account attribute information, and the account detail data, the management report data including management report business detail data and management report account detail data, the management report business detail data including business detail information indicating a business scenario corresponding to the account data, and the management report account detail data including expense detail information corresponding to the account data; generating a management report based on the management report data corresponding to each account data in the at least one piece of account data; Wherein, different types of account data are preset with corresponding mapping rule libraries, and different preset mapping rules in the mapping rule library have different matching priorities, wherein the matching priority of the preset mapping rule is positively correlated with the number of types of account attributes included in the preset mapping rule; and determining the corresponding reporting field of the account data based on the account attribute information includes: According to the matching priority of each preset mapping rule in the target mapping rule library corresponding to the account data, the account attribute information is matched with the preset mapping rules in the target mapping rule library in sequence to obtain the target mapping rule corresponding to the account attribute information, wherein the preset mapping rule includes an account attribute combination composed of different types of account attributes; Determining a target field rule corresponding to the target mapping rule based on a preset correspondence between the preset mapping rule and the preset field rule; Based on the target field rule, the reporting field corresponding to the account attribute information is determined.

2. The method according to claim 1, characterized in that After sequentially matching the account attribute information with the preset mapping rules in the target mapping rule library, the method further includes: In the case that the target mapping rule corresponding to the account attribute information is not matched, rule adjustment prompt information is generated, where the rule adjustment prompt information is used to instruct adjustment of the preset mapping rule in the target mapping rule library.

3. The method according to claim 1 or 2, characterized in that The account attribute information includes business information corresponding to the account data; The generating of management report data corresponding to the account data based on the management report field, the account attribute information, and the account detail data includes: Generate detailed management report business data corresponding to the account data based on the management report fields and the account attribute information; Based on the management report fields and the account detail data, management report account detail data corresponding to the account data is generated.

4. The method according to claim 3, characterized in that The generating of a management report based on the management report data corresponding to each account data in the at least one piece of account data includes: generating a management business detail report based on the management business detail data corresponding to each account data in the at least one account data, wherein the management business detail report includes business detail information corresponding to each account data; Based on the management account detail data corresponding to each account data in the at least one account data, a management account detail report is generated, wherein the management account detail report includes the expense detail information corresponding to each account data.

5. The method according to claim 1 or 2, characterized in that The obtaining of at least one piece of account data includes: Determining a data acquisition method for acquiring the accounting data from the data source based on a data storage method of the accounting data in the data source; Based on the data acquisition method, the at least one piece of account data is acquired from the data source.

6. The method according to claim 1 or 2, characterized in that After generating the management report, the method further includes: Performing an integrity check on the management report data in the management report to obtain an integrity check result, wherein the integrity check result is used to indicate the integrity of the management report data including the accounting data; and / or, A uniqueness check is performed on the management report data in the management report to obtain a uniqueness check result, wherein the uniqueness check result is used to indicate the uniqueness of each management report data.

7. The method according to claim 1 or 2, characterized in that After generating the management report, the method further includes: In response to receiving a query operation on a target management report field, querying target management report data corresponding to the target management report field from the generated management report; Display the target management report data corresponding to the target management report field.

8. An electronic device, characterized in that: include: Memory for storing computer programs; The processor is configured to execute the computer program stored in the memory, and when the computer program is executed, the method for generating a management report according to any one of claims 1 to 7 is implemented.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the method for generating a management report according to any one of claims 1 to 7 is implemented.

10. A computer program product comprising a computer program, characterized in that When the computer program is executed by a processor, the method for generating a management report according to any one of claims 1 to 7 is implemented.

Images