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

Abstract

The embodiment of the invention discloses a method for generating a management report, electronic equipment, a storage medium and a program product, and the method comprises the steps: obtaining at least one piece of accounting data, the accounting data comprises accounting detail data and accounting attribute information, and the accounting attribute information is used for indicating business scene information corresponding to the accounting data; based on the accounting attribute information, determining a management report field corresponding to the accounting data, the management report field being a data identifier of data in the management report, and the management report field conforming to a preset field rule; based on the management report field, the accounting attribute information and the accounting detail data, generating management report data corresponding to the accounting data; and 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, so that the generation efficiency of the management report and the accuracy of the generated management report data can be improved.

Description

Technical Field

[0001] The present disclosure relates to Internet technology and data processing technology, and in particular to a method for generating a management report, an electronic device, a storage medium and a program product. Background Art

[0002] The management and reporting system is one of the enterprise's reporting systems. The management and reporting system is used to integrate data to obtain management reports, which can provide business management information for internal managers of the enterprise. As the enterprise develops, the data source of the management and reporting system includes data from multiple systems, such as accounting systems, allocation systems, human resources systems, financial management systems and other data sources.

[0003] In the related art, data from different systems are integrated and processed by manual integration to obtain management report data, which is then processed to obtain corresponding management reports. This method requires a lot of manual operations and has low data processing efficiency and accuracy. Summary of the invention

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

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

[0006] 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;

[0007] Based on the account attribute information, determining a control report field corresponding to the account data, wherein the control report field complies with a preset field rule;

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

[0009] A management report is generated based on the management report data corresponding to each account data in the at least one account data.

[0010] In an exemplary embodiment, determining the reporting field corresponding to the accounting data based on the accounting attribute information includes:

[0011] Matching the account attribute information with a preset mapping rule to obtain a target mapping rule corresponding to the account attribute information, wherein the preset mapping rule includes an account attribute combination obtained by combining different types of account attributes;

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

[0013] Based on the target field rule, the reporting field corresponding to the account attribute information is determined.

[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 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;

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

[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 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.

[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 includes:

[0018] In the case that the target mapping rule corresponding to the account attribute information is not matched, rule adjustment prompt information is generated, and the rule adjustment prompt information is used to instruct to adjust the preset mapping rule in the target mapping rule base.

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

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

[0021] Based on the management report field and the account attribute information, generating management report business detail data corresponding to the account data, the management report business detail data including business detail information for indicating the 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 the expense detail information corresponding to the account data, and the management report account detail data belongs to the management report data.

[0023] In an exemplary embodiment, generating a management report based on the management report data corresponding to each account data in the at least one account data includes:

[0024] Based on the management business detail data corresponding to each account data in the at least one account data, generating a management business detail report, wherein the management business detail report includes business information corresponding to each account data;

[0025] 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.

[0026] In an exemplary embodiment, obtaining at least one piece of account data includes:

[0027] Determining a data acquisition method for acquiring the account data from the data source based on a data storage method of the account data in the data source;

[0028] Based on the data acquisition method, the at least one piece of account data is acquired from the data source.

[0029] In an exemplary embodiment, after generating the management report, the method further includes:

[0030] Performing 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;

[0031] and / or,

[0032] 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.

[0033] In an exemplary embodiment, after generating the management report, the method further includes:

[0034] 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;

[0035] Display the target management report data corresponding to the target management report field.

[0036] Another aspect of this embodiment provides a management report generation device, including:

[0037] A data acquisition module, used to acquire at least one piece of account data, wherein the account data includes account detail data and account attribute information, wherein the account attribute information is used to indicate business scenario information corresponding to the account data;

[0038] A field determination module, used to determine, based on the account attribute information, a control report field corresponding to the account data, wherein the control report field complies with a preset field rule;

[0039] A data generation module, used to generate management report data corresponding to the account data based on the management report field, the account attribute information and the account detail data;

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

[0041] Another aspect of this embodiment provides an electronic device, including:

[0042] Memory for storing computer programs;

[0043] The processor is used 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] Another aspect of this embodiment provides a computer-readable storage medium on which a computer program is stored. 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] Another aspect of this embodiment provides a computer program product, including a computer program, which, when executed by a processor, implements the method for generating a management report described in any of the above embodiments.

[0046] In the disclosed embodiment, corresponding field rules are pre-set for the control report fields used to identify the management report data in the management report, and the field rules of the control report fields are unified. For the acquired accounting data, the control report fields corresponding to the accounting data are determined according to the accounting attribute information of the accounting data, and then the management report data corresponding to the accounting data are generated based on the control report fields and the accounting data, and the corresponding management report is generated based on the management report data of each accounting data. In this way, the acquired accounting data can be processed by unified control report field information collection, and automatic data processing of the accounting data can be realized. Management reports with unified rules can be automatically generated, which helps to improve the efficiency and accuracy of processing accounting data, thereby helping to improve the generation efficiency of management reports and the accuracy of generated management report data. In addition, the generation of management reports with unified rules can improve the efficiency of data query and data tracing based on management reports.

[0047] The technical solution of the present disclosure is further described in detail below through the accompanying drawings and embodiments. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0049] The present disclosure may be more clearly understood from the following detailed description with reference to the accompanying drawings, in which:

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

[0051] Figure 2 A flowchart of a process for determining a management report field provided by an exemplary embodiment of the present disclosure;

[0052] Figure 3 A flowchart of a process for obtaining account data provided by an exemplary embodiment of the present disclosure;

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

[0054] Figure 5 A schematic diagram of a management report detail query page provided by an exemplary embodiment of the present disclosure;

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

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

[0057] Various exemplary embodiments of the present disclosure will now be described in detail with reference to the accompanying drawings. It should be noted that the relative arrangement of components and steps, numerical expressions and numerical values ​​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" and "second" in the embodiments of the present disclosure are only used to distinguish different steps, devices or modules, etc., and neither represent any specific technical meaning nor indicate the necessary logical order between them.

[0059] It should also be understood that in the embodiments of the present disclosure, “plurality” may refer to two or more than two, and “at least one” may refer to one, two, or more than two.

[0060] It should also be understood that any component, data or structure mentioned in the embodiments of the present disclosure can generally be understood as one or more, unless explicitly limited or otherwise indicated in the context.

[0061] In addition, the term "and / or" in the present disclosure is only a description of the association relationship of associated objects, indicating that three relationships may exist. For example, A and / or B can represent: A exists alone, A and B exist at the same time, and B exists alone. In addition, the character " / " in the present disclosure generally indicates that the associated objects before and after are in an "or" relationship.

[0062] It should also be understood that the description of the various embodiments in the present disclosure focuses on the differences between the various embodiments, and the same or similar aspects thereof can be referenced to each other, and for the sake of brevity, they will not be described one by one.

[0063] At the same time, it should be understood that for the convenience of description, the sizes of the various parts shown in the drawings are not drawn according to the actual proportional relationship.

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

[0065] Technologies, methods, and equipment known to ordinary technicians in the relevant art may not be discussed in detail, but where appropriate, the technologies, methods, and equipment should be considered as part of the specification.

[0066] It should be noted that like reference numerals and letters refer to similar items in the following figures, and therefore, once an item is defined in one figure, it need not be further discussed in subsequent figures.

[0067] The disclosed embodiments can be applied to electronic devices such as terminal devices, computer systems, servers, etc., 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 electronic devices such as terminal devices, computer systems, servers, etc. 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, large 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, etc. can be described in the general context of computer system executable instructions (such as program modules) executed by computer systems. Generally, program modules can include routines, programs, object programs, components, logic, data structures, etc., which perform specific tasks or implement specific abstract data types. Computer systems / servers can be implemented in a distributed cloud computing environment, where tasks are performed by remote processing devices linked through a communication network. In a distributed cloud computing environment, program modules can be located on local or remote computing system storage media including storage devices.

[0069] Figure 1 FIG. 1 is a flow chart of a method for generating a management report according to an exemplary 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, it includes the following steps:

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

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

[0072] In the disclosed embodiments, the accounting data is detailed data indicating the revenue, cost and other expenses of the business in the corresponding business scenario. In a possible implementation, at least one accounting data may be obtained from a data source for storing different types of accounting data. Schematically, different types of accounting data may include external business accounting data from an external data system, human cost accounting data from an internal human resource system, and internal business accounting data from an internal financial management system.

[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 from which the accounting data comes, the business type, the accounting subject, etc.

[0074] Step 102: Determine the reporting 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, which 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 the preset field rules. The field rules may indicate at least one of the field type, field content, and field format of each field to be included in the management report field. In one possible implementation, a unified field rule is pre-set to unify the management report fields in the management report to facilitate query and data tracing.

[0076] Optionally, corresponding field rules may be set for different types of accounting data. After obtaining the accounting data, the field rules corresponding to the accounting data are determined according to the accounting attribute information of the accounting data, and then the reporting fields are extracted from the accounting attribute information based on the field rules.

[0077] Step 103: Generate management report data corresponding to the account data based on the management report fields, account attribute information and account detail data.

[0078] After determining the management report fields based on the accounting attribute information, the management report fields corresponding to the accounting data can be obtained, and then the data information required in the management report data can be extracted from the accounting data. Based on the management report fields and the extracted data information, the management report data corresponding to the accounting data is generated.

[0079] Optionally, the business information required for the management report data can be extracted from the account attribute information, and the expense detail information required for the management report data can be extracted from the account detail data, and then the corresponding management report data can be generated in combination with the management report fields.

[0080] Step 104: Generate a management report based on the management report data corresponding to each account data in the at least one account data.

[0081] After generating the management report data corresponding to each account data, the management report data can be combined to obtain a management report. In one possible implementation, the management report data corresponding to each account data can be combined to obtain a management report summary table. In another possible implementation, the management report data can be divided according to the data type of the account data to obtain different types of management reports. In combination with the above examples, management reports corresponding to external business can be generated according to external business account data, management reports corresponding to human cost can be generated according to human cost account data, and management reports corresponding to internal business can be generated according to internal business account data. In another possible implementation, the account data can be further divided, such as based on different organizational information corresponding to the account data, to obtain management reports corresponding to different organizations.

[0082] In the disclosed embodiment, corresponding field rules are pre-set for the control report fields used to identify the management report data in the management report, and the field rules of the control report fields are unified. For the acquired accounting data, the control report fields corresponding to the accounting data are determined according to the accounting attribute information of the accounting data, and then the management report data corresponding to the accounting data are generated based on the control report fields and the accounting data, and the corresponding management reports are generated based on the management report data of each accounting data. In this way, the acquired accounting data can be processed by unified control report field information collection, and automatic data processing of the accounting data can be realized. Management reports with unified rules can be automatically generated, which helps to improve the efficiency and accuracy of processing accounting data, thereby helping to improve the generation efficiency of management reports and the accuracy of generated management report data. In addition, generating management reports with unified rules can improve the efficiency of data query and data tracing based on management reports.

[0083] In a possible implementation, multiple mapping rules and field rules corresponding to the multiple mapping rules are preset, and the reporting fields corresponding to the account attribute information are determined based on the preset mapping rules and the corresponding field rules. Figure 2 As shown, the above step 102 may include the following steps 201-203:

[0084] Step 201 : Match the account attribute information with the preset mapping rule to obtain the target mapping rule corresponding to the account attribute information. The preset mapping rule includes an account attribute combination composed of different types of account attributes.

[0085] The preset mapping rules are pre-set based on business scenario combinations of different account data. The preset mapping rules include account attribute combinations composed of different types of account attributes, and different account attribute combinations are used to indicate different business scenario combinations. The account attribute information is matched with the account attribute combination corresponding to the preset mapping rule to determine the account attribute combination corresponding to the account data, thereby determining the business scenario combination corresponding to the account data. Optionally, multiple preset mapping rules can be set for different business scenario combinations. Schematically, the preset mapping rules may include mapping rule one: accounting subject + business type + accounting category + legal person company (obtained from four types of account attribute combinations); mapping rule two: accounting subject + business type + legal person company (obtained from three types of account attribute combinations) and other different mapping rules.

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

[0087] Different types of account data correspond to different business scenarios. Optionally, a corresponding mapping rule library can be set for different types of account data, and the mapping rule library contains a variety of preset mapping rules for corresponding types of account data. In an illustrative example, the preset mapping rules included in the mapping rule library set for internal business account data from within may 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 account data from an external taxi business system may include car use authority + department attributes + organization; car use authority + department attributes, etc.

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

[0089] In another possible implementation, the various 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 level of detail of the business scenario combination indicated by the account attribute combination included in the preset mapping rule. The higher the level of detail of the preset mapping rule, the higher the matching priority, that is, the matching priority is positively correlated with the level of detail corresponding to the account attribute combination.

[0090] In one example, 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. The preset mapping rule includes an account attribute combination composed of different types of account attributes. The more different types of account attributes the account attribute combination consists of, the higher the matching priority of the corresponding preset mapping rule. Schematically, mapping rule one (accounting subject + business type + bookkeeping category + legal person company) includes four different types of account attributes, and mapping rule two (accounting subject + business type + legal person company) includes three different types of account attributes. The matching priority of mapping rule one is higher than the matching priority of mapping rule two.

[0091] Furthermore, when different preset mapping rules include the same number of types of account attributes, the matching priority corresponding to the different preset mapping rules can be determined according to the accounting requirements corresponding to the different account attributes contained in the different preset mapping rules, wherein the accounting requirement refers to the degree of need for writing the account attribute into the management report, and the accounting requirements corresponding to the different account attributes can be pre-configured by business personnel according to the needs. Schematically, the number of types of account attributes included in mapping rule three (accounting subject + contract type + legal person company + city) and mapping rule four (accounting subject + accounting category + legal person company + city) are the same, and they include different account attributes: contract type and accounting category, wherein the accounting requirement of the contract type is higher than the accounting requirement of the accounting category, and it can be determined that the matching priority of mapping rule three is higher than the matching priority of mapping rule four.

[0092] It should be noted that the above is only an example of setting rules for the matching priority of the preset mapping rules, but does not constitute a limitation thereto. The matching priority of the preset mapping rules can also be pre-customized by business personnel according to other rules.

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

[0094] Indicatively, in combination with the above example, the matching priority of mapping rule one (accounting subject + business type + accounting category + legal entity company) is higher than the matching priority of mapping rule two (accounting subject + business type + legal entity company). In the matching process based on mapping rule one and mapping rule two, the account attribute information is first matched with mapping rule one. If it matches mapping rule one, mapping rule one is determined as the target mapping rule; if it does not match mapping rule one, it continues to match mapping rule two.

[0095] The business scenario combination corresponding to the preset mapping rules may not be able to completely cover different account data. In a possible implementation, when 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 the preset mapping rules in the target mapping rule library to be adjusted. The rule adjustment prompt information may include the account attribute information that has not been successfully matched, so that the user can add the corresponding mapping rules according to the account attribute information that has not been successfully matched, which can improve the coverage rate of the preset mapping rules for different business scenario combinations.

[0096] Step 202: Determine a target field rule corresponding to the target mapping rule based on a preset corresponding relationship between the preset mapping rule and the preset field rule.

[0097] In one possible implementation, preset field rules corresponding to different preset mapping rules can be pre-set, that is, there is a preset correspondence between different preset mapping rules and different preset field rules. Optionally, the preset correspondence may be a many-to-one relationship or a one-to-one relationship. The many-to-one relationship means that multiple preset mapping rules may 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 determining the target mapping rule corresponding to the account attribute information, the target field rule corresponding to the target mapping rule may be determined according to a preset corresponding relationship between the preset mapping rule and the preset field rule.

[0099] Step 203: Determine the reporting field corresponding to the account attribute information based on the target field rule.

[0100] In a possible implementation, the reporting fields corresponding to the account attribute information are generated according to the field contents and field formats to be included as indicated in the target field rules.

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

[0102] In the disclosed embodiment, preset mapping rules are pre-set to indicate different business scenario combinations, and the accounting attribute information of the accounting data is matched with different preset mapping rules to obtain the corresponding target mapping rules. Then, according to the target field rules corresponding to the target mapping rules, the management report fields corresponding to the accounting attribute information are generated, and the accounting attribute information is processed into management report fields with unified rules to facilitate subsequent management of data query and data traceability of report data.

[0103] Optionally, the management report data may include management report business detail data and management report account detail data. Management report business detail data refers to business detail information of the business scenario corresponding to the account data. In one example, the business detail information may be business information other than expense information, for example, including at least one of business transaction information, order information corresponding to the business, business personnel information, etc. Exemplarily, when the account data is taxi bill data, the generated management report business detail data may include order details of the taxi order, such as distance, time, etc. 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 and expense details, and expenditure details.

[0104] In a possible implementation, based on the management report fields, account attribute information and account detail data, the management report data corresponding to the account data includes management report business detail data corresponding to the account data and management report account detail data corresponding to the account data. Optionally, based on the management report fields and account attribute information, management report business detail data corresponding to the account data is generated; based on the management report fields and account detail information, management report account detail data corresponding to the account data is generated. Based on the management report fields and the business information in the account attribute information, management report business detail data is generated, and the management report business detail data includes management report fields and business detail information. The management report fields are used to indicate the corresponding business scenarios, and the business detail information is used to indicate the detailed business information corresponding to the business scenarios. The business detail information is business execution related information other than the expense details. For example, in the car use scenario, the business detail information includes information such as the specific car order number, the car user and the usage time. The management report accounting detail data generated according to the management report fields and the accounting detail information includes management report fields and expense detail information. The management report fields are used to indicate the business scenarios corresponding to the expense details. The expense details include at least one of the income details and the cost and expense details.

[0105] After the management report data is generated, a management report can be generated based on the management report data. Optionally, based on the management business detail data corresponding to each account data in at least one account data, a management business detail report is generated, and 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 at least one account data, a management account detail report is generated, and the management account detail report includes account detail information corresponding to each account data.

[0106] In a possible implementation, when generating a management business detail report based on the management business detail data corresponding to each account data in at least one account data, different types of management business detail reports can be generated according to the type of account data. That is, the management business detail data corresponding to each account data is classified according to the type of account 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 examples, corresponding management business detail reports can be generated for external business account data, human cost account data, and internal business account data, respectively.

[0107] In a possible implementation, the generated management and reporting account details report may include a primary account details report and a secondary account details report, wherein the primary account details report includes the general ledger data of various account data from different sources, and the secondary account details report includes at least one of detailed sub-account data after classifying the general ledger data and account data not included in the general ledger (such as account data corresponding to virtual currency). In one example, the generated management business details report may also be classified into the secondary account details report to supplement the business details information of the account details report.

[0108] In the disclosed embodiment, corresponding management detail tables are generated for the business information and expense information in the account data, respectively, which can improve the efficiency of users in querying different types of information.

[0109] The accounting data can be obtained from a preset data source, which may include multiple data sources. Figure 3 As shown, obtaining at least one account data from a data source includes the following steps 301-302:

[0110] Step 301 : determining a data acquisition method for acquiring the account data from the data source based on the data storage method of the account data in the data source.

[0111] In a possible implementation, the data acquisition method can be determined according to the data storage method of the data source storing the 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, and the accounting data in the big data system can be extracted 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: Acquire at least one piece of account 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 then each piece of account data in the at least one piece of account data is processed to obtain corresponding management report data, and a management report is generated.

[0114] In a possible implementation, the generation process of the management report is as follows: Figure 4 As shown, first, the accounting data is obtained from each accounting system. The accounting system includes a business and financial data platform, an external business system, a salary 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, 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 is obtained from the external business system, such as taxi bill data from an external taxi system, express bill data from an external express company, salary data and corresponding personnel information from the salary data warehouse, and account entry 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 (including the above-mentioned account attribute information) required for generating the management report field is extracted from the acquired account data, for example, human structure information, organizational information, contract information, labor cost information, and business information, etc. can be obtained. Afterwards, matching is performed according to the preset mapping rules in the rule base to determine the target mapping rules corresponding to each account data. In one example, a first mapping rule base can be set for the Taichung account data in the business and financial data, a second mapping rule base can be set for the billing data of the external business system, a third mapping rule base can be set for the salary data of the salary data warehouse, and a fourth mapping rule base can be set for the account details of the financial management system. After acquiring the Taichung account data in the business and financial data, matching is performed based on the preset mapping rules in the first mapping rule base, after acquiring the billing data of the external business system, matching is performed based on the preset mapping rules in the second mapping rule base, after acquiring the salary data of the salary data warehouse, matching is performed based on the preset mapping rules in the third mapping rule base, and after acquiring the account details for the financial management system, matching is performed based on the preset mapping rules in the fourth mapping rule base.

[0116] After the accounting data is matched, the control report fields can be aggregated and processed, that is, the corresponding target field rules are determined according to the determined target mapping rules, and the control report fields corresponding to the account attribute information of each account data are generated according to the target field rules. Based on the control report fields, account attribute information and account detail data of each account data, a second type of control report detail table (also called a control report business detail report) and a first type of control report detail table (also called a control report account detail report) are generated. The second type of control report detail table may include the corresponding account business detail table (such as gas station business refueling details, advertising business placement details), bill business detail table (car details, express delivery details, etc.) and labor cost detail table, etc. The first type of control report detail table includes an income detail table and a cost and expense detail table.

[0117] In a possible implementation, Oracle Data Integrator 11g may be used as a scheduling tool to execute the above process of acquiring accounting data, converting data to obtain management report fields, and loading management reports.

[0118] In the disclosed embodiment, a data acquisition method for acquiring accounting data from a data source is determined according to the method in which the data source stores data. The accounting data extracted from the data source based on the corresponding data acquisition method is stored in a management and reporting database. Data links can be established between different data sources to achieve data integration of different data sources.

[0119] In the disclosed embodiment, 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 one possible implementation, integrity check is performed on the management report data in the management report to obtain an integrity check result, and the integrity check result is used to indicate the integrity of the management report data including the account data. Integrity check refers to checking the integrity of the management report data contained in the management report to see whether it includes all the acquired account data. During the verification, the data volume (number of data items) of the management report data can be matched with the data volume (number of data items) of the acquired account data, and the integrity check result is determined based on the data volume matching result. When the data volume matching result indicates that the data volume is the same, the integrity check result is determined to be a pass in the verification, and if it is not the same, the integrity check result is determined to be a fail in the verification. In another possible implementation, the total amount corresponding to the management report data can be matched with the total amount corresponding to the account data, and when the total amount matches, the integrity check result is determined to be a pass in the verification. In another possible implementation, the integrity check result can be determined based on the data volume matching result and the total amount matching result, and when the data volume matching result indicates that the data volume is the same and the total amount matching result indicates that the total amount is the same, the integrity check result is determined to be a pass in the verification.

[0121] In a possible implementation, the management report data in the management report may be subjected to a uniqueness check to obtain a uniqueness check result, and the uniqueness check result is used to indicate the uniqueness of each management report data. During the uniqueness check, the check may be performed based on an identification field used to identify unique data, for example, a uniqueness check may be performed based on a financial voucher number, an order number, etc. If there is a non-unique field in the identification field used to identify unique data, that is, there are more than or equal to two fields, it is determined that the management report data identified by the identification field is not unique, and the uniqueness check result is that the check failed.

[0122] If the data verification fails, an early warning message can be generated and displayed to indicate that the management report data is abnormal, so that users can conduct timely investigations. For example, if the integrity check fails, the corresponding early warning message can be displayed to enable users to check the data integrity; if the uniqueness check fails, duplicate data can be displayed to enable users to process the duplicate data.

[0123] In the disclosed embodiment, after the management report is generated, data verification is performed on the management report data 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 data query process may include the following steps:

[0125] Step 1: In response to receiving a query operation on a target management report field, query the target management report data corresponding to the target management report field from the generated management report.

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

[0127] Step 2: Display the target management report data corresponding to the target management report field.

[0128] After the target management report data is obtained through query, the target management report data corresponding to the target management report field is displayed on the management report detail query page.

[0129] In another possible implementation, in addition to providing the ability to query corresponding management report data based on management report fields, the management report details query page can also provide a query for management report data based on source fields, wherein the source field refers to the source field contained in the acquired financial data, and the generated management report data is queried based on the source field. Figure 5 As shown, the source fields may include accounting subjects, sources, items, voucher numbers, contract numbers, business unit codes, etc. The management report details query page includes selection items corresponding to different source fields, which are used to query and obtain corresponding management report data by selecting source fields.

[0130] Figure 6 1 is a schematic diagram of a structure of a device for determining the generation of a management report provided by an exemplary embodiment of the present disclosure. The device can be used for the electronic device involved in the above embodiment. The device includes:

[0131] The data acquisition module 601 is used 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] A field determination module 602 is used to determine, based on the account attribute information, a control report field corresponding to the account data, where the control report field complies with a preset field rule;

[0133] A data generation module 603 is used to generate management report data corresponding to the account data based on the management report field, the account attribute information and the account detail data;

[0134] The report generation module 604 is used to generate a management report based on the management report data corresponding to each account data in the at least one account data.

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

[0136] Matching the account attribute information with a preset mapping rule to obtain a target mapping rule corresponding to the account attribute information, wherein the preset mapping rule includes an account attribute combination obtained by combining different types of account attributes;

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

[0138] Based on the target field rule, the reporting field corresponding to the account attribute information is determined.

[0139] 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 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;

[0140] The field determination module 602 is further used for:

[0141] 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.

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

[0143] The information generation module is used to generate rule adjustment prompt information when the target mapping rule corresponding to the account attribute information is not matched, and the rule adjustment prompt information is used to indicate the adjustment of the preset mapping rule in the target mapping rule library.

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

[0145] The data generation module 603 is further used for:

[0146] Based on the management report field and the account attribute information, generating management report business detail data corresponding to the account data, the management report business detail data including business detail information for indicating the business scenario corresponding to the account data, and the management report business detail data belongs to the management report data;

[0147] Based on the management report field and the account detail information, management report account detail data corresponding to the account data is generated, and the management 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, generating a management business detail report, wherein the management business detail report includes 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, wherein 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 used to:

[0152] Determining a data acquisition method for acquiring the account data from the data source based on a data storage method of the account data in the data source;

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

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

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

[0156] and / or,

[0157] The data verification module is further used 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, configured to query target management report data corresponding to the target management report field from the generated management report in response to receiving a query operation on the target management report field;

[0160] The data display module is used to display the target management report data corresponding to the target management report field.

[0161] The generation device of the management report in the embodiment of the present disclosure corresponds to the embodiment of the generation method of the management report in the present disclosure, and the relevant contents can be referenced to each other, which will not be repeated here. The beneficial technical effects corresponding to the generation device of the management report in the embodiment of the present disclosure can refer to the corresponding beneficial technical effects of the corresponding exemplary method part above, which will not be repeated 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 used 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 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 any one or both of the first device and the second device, or a stand-alone device independent of them, and the stand-alone device may communicate with the first device and the second device to receive the 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, and the computer program product 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 (cache), etc. The non-volatile memory may include, for example, read-only memory (ROM), 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 each embodiment 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 may also include, for example, a keyboard, a mouse, and the like.

[0171] The output device can output various information to the outside, including the determined distance information, direction information, etc. 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, to simplify, Figure 7 Only some of the components related to the present disclosure in the electronic device are shown, and components such as a bus, an input / output interface, etc. are omitted. In addition, according to specific application situations, the electronic device may further include any other appropriate components.

[0173] In addition to the above-mentioned methods and devices, an embodiment of the present disclosure may also be a computer program product, which includes computer program instructions, which, when executed by a processor, enable the processor to execute the steps in the method for generating management reports according to various embodiments of the present disclosure described in the above part of this specification.

[0174] The computer program product may be written in any combination of one or more programming languages ​​to write program code for performing the operations of the disclosed embodiments, including object-oriented programming languages ​​such as Java, C++, etc., and conventional procedural programming languages ​​such as "C" or similar programming languages. The program code may be executed entirely on the user computing device, partially on the user device, as a separate 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 may also be a computer-readable storage medium having computer program instructions stored thereon, which, when executed by a processor, enables the processor to execute the steps of the method for generating a management report according to various embodiments of the present disclosure described in the above part of this specification.

[0176] The computer readable storage medium can adopt any combination of one or more readable media. The readable medium can be a readable signal medium or a readable storage medium. The readable storage medium can include, for example, but is not limited to, a system, device or device of electricity, magnetism, light, electromagnetic, infrared, or semiconductor, or any combination of the above. More specific examples (non-exhaustive list) of readable storage media include: an electrical connection with 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 disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above.

[0177] A person of ordinary skill in the art can understand that all or part of the steps of implementing the above method embodiment can be completed by hardware related to program instructions, and the aforementioned program can be stored in a computer-readable storage medium. When the program is executed, it executes the steps of the above method embodiment; and the aforementioned storage medium includes: ROM, RAM, magnetic disk or optical disk, etc., various media that can store program codes.

[0178] The basic principles of the present disclosure are described above in conjunction with specific embodiments. However, it should be noted that the advantages, strengths, effects, etc. mentioned in the present disclosure are only examples and not limitations, and it cannot be considered that these advantages, strengths, effects, etc. are required by each embodiment of the present disclosure. In addition, the specific details disclosed above are only for the purpose of illustration and ease of understanding, and are not limitations. The above details do not limit the present disclosure to the necessity of adopting the above specific details to be implemented.

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

[0180] The block diagrams of the devices, apparatuses, equipment, and systems involved in this disclosure are only illustrative examples and are not intended to require or imply that they must be connected, arranged, and configured in the manner shown in the block diagrams. As will be appreciated by those skilled in the art, these devices, apparatuses, equipment, and systems can be connected, arranged, and configured in any manner. Words such as "including," "comprising," "having," and the like are open words, referring to "including but not limited to," and can be used interchangeably therewith. The words "or" and "and" used herein refer to the words "and / or," and can be used interchangeably therewith, unless the context clearly indicates otherwise. The word "such as" used herein refers to the phrase "such as but not limited to," and can be used interchangeably therewith.

[0181] The method and apparatus of the present disclosure may be implemented in many ways. For example, the method 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 specifically stated. In addition, in some embodiments, the present disclosure may also be implemented as a program recorded in a recording medium, which includes machine-readable instructions for implementing the method according to the present disclosure. Therefore, the present disclosure also covers a recording medium storing a program for executing the method 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 the widest scope consistent with the principles and novel features disclosed herein.

[0184] The above description has been given 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 multiple example aspects and embodiments have been discussed above, those skilled in the art will recognize certain variations, modifications, changes, 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 account detail data and account attribute information, and the account attribute information is used to indicate business scenario information corresponding to the account data; Based on the account attribute information, determine the management report field corresponding to the account data, the management report field is a data identifier of the data in the management report, and the management report field complies with a preset field rule; Generate management report data corresponding to the account data based on the management report field, the account attribute information and the account detail data; A management report is generated based on the management report data corresponding to each account data in the at least one account data.

2. The method according to claim 1, characterized in that The determining, based on the account attribute information, a control report field corresponding to the account data includes: Matching the account attribute information with a preset mapping rule to obtain a target mapping rule corresponding to the account attribute information, wherein the preset mapping rule includes an account attribute combination obtained by combining different types of account attributes; Determining a target field rule corresponding to the target mapping rule based on a preset corresponding relationship 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.

3. The method according to claim 2, characterized in that 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; The matching of the account attribute information with a preset mapping rule to obtain a target mapping rule corresponding to 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.

4. The method according to claim 3, 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, and the rule adjustment prompt information is used to instruct to adjust the preset mapping rule in the target mapping rule base.

5. The method according to any one of claims 1 to 4, characterized in that: The account attribute information includes business information corresponding to the account data; The generating management report data corresponding to the account data based on the management report field, the account attribute information and the account detail data includes: Based on the management report field and the account attribute information, generating management report business detail data corresponding to the account data, the management report business detail data including business detail information for indicating the business scenario corresponding to the account data, and the management report business detail data belongs to the management report data; Based on the management report field and the account detail data, 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.

6. The method according to claim 5, 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 account data includes: Based on the management business detail data corresponding to each account data in the at least one account data, generating a management business detail report, 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.

7. The method according to any one of claims 1 to 4, characterized in that: The obtaining of at least one piece of account data includes: Determining a data acquisition method for acquiring the account data from the data source based on a data storage method of the account 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.

8. The method according to any one of claims 1 to 4, characterized in that: After generating the management report, the method further includes: Performing 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.

9. The method according to any one of claims 1 to 4, 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.

10. An electronic device, characterized in that: include: Memory for storing computer programs; The processor is used 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 claims 1 to 9 is implemented.

11. 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 described in any one of claims 1 to 9 is implemented.

12. 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 described in any one of claims 1 to 9 is implemented.

Images