Financial statement generation method and device, electronic equipment and storage medium

Abstract

The invention provides a financial statement generation method and device, electronic equipment and a storage medium. The method comprises the steps of obtaining first financial subject information, target header template information and a target user; generating a report compiling template according to the first financial subject information and the target header template information; displaying the report compiling template in a display interface of the target user, and obtaining target data filled in the report compiling template by the target user; determining second financial subject information and a plurality of target compiled report templates associated with the second financial subject information, and generating a summary report template according to the second financial subject information and the target header template information; and based on the summarized report template, summarizing the target data in the plurality of target compiled report templates, and generating a summarized report. Therefore, the report compiling template and the summary report template can be flexibly configured and generated according to user requirements, and the compiled financial data is automatically summarized and counted based on the summary report template, so that the report generation efficiency and flexibility are improved.

Description

Technical Field

[0001] The present application relates to the field of software development technology, and in particular to a method, device, electronic device and storage medium for generating financial statements. Background Art

[0002] The existing technical solutions require pre-configuration of report templates for different financial statements in the system and the writing of corresponding parsing programs. At the same time, corresponding summary statistical programs must be written for different financial statements. If the subjects and statistical information used in the preparation of financial statements change, the corresponding programs need to be modified, which is not conducive to quickly responding to changes in financial statement needs. Summary of the invention

[0003] The present application aims to solve one of the technical problems in the related art at least to some extent.

[0004] To this end, the first purpose of this application is to propose a method for generating financial statements, which can generate financial statements flexibly and quickly, thereby reducing the development cost of financial statements.

[0005] The second objective of this application is to provide a device for generating financial statements.

[0006] The third objective of the present application is to provide an electronic device.

[0007] A fourth objective of the present application is to provide a computer-readable storage medium.

[0008] A fifth object of the present application is to provide a computer program product.

[0009] To achieve the above-mentioned purpose, the first embodiment of the present application proposes a method for generating financial statements, including:

[0010] Obtain the first financial account information, target header template information and target user;

[0011] Generate a report template according to the first financial account information and the target header template information;

[0012] Displaying a report preparation template in the display interface of the target user, and acquiring target data filled in by the target user in the report preparation template;

[0013] Determine the second financial account information and multiple target report preparation templates associated with the second financial account information, wherein the target header templates corresponding to the multiple target report preparation templates are the same;

[0014] Generate a summary report template according to the second financial account information and the target header template information;

[0015] Based on the summary report template, the target data in the multiple target compilation report templates are summarized and a summary report is generated.

[0016] To achieve the above-mentioned purpose, the second embodiment of the present application proposes a device for generating financial statements, including:

[0017] A first acquisition module is used to acquire first financial account information, target header template information and target user;

[0018] A first generating module, used for generating a report template according to the first financial account information and the target header template information;

[0019] A second acquisition module is used to display the report preparation template in the display interface of the target user and obtain the target data filled in the report preparation template by the target user;

[0020] A determination module, used to determine the second financial account information and a plurality of target report preparation templates associated with the second financial account information, wherein the target header templates corresponding to the plurality of target report preparation templates are the same;

[0021] A second generating module, used for generating a summary report template according to the second financial account information and the target header template information;

[0022] The summary module is used to summarize the target data in the multiple target compilation report templates based on the summary report template and generate a summary report.

[0023] To achieve the above-mentioned purpose, the third aspect of the present application provides an electronic device, including:

[0024] A processor, and a memory communicatively connected to the processor;

[0025] The memory stores computer-executable instructions;

[0026] The processor executes the computer-executable instructions stored in the memory to implement the method as described in the embodiment of the first aspect.

[0027] To achieve the above-mentioned purpose, the fourth aspect embodiment of the present application proposes a computer-readable storage medium, in which computer execution instructions are stored. When the computer execution instructions are executed by a processor, they are used to implement the method described in the first aspect embodiment.

[0028] To achieve the above-mentioned purpose, the fifth aspect of the present application proposes a computer program product, a computer program, which implements the method described in the first aspect when executed by a processor.

[0029] The method, device, electronic device and storage medium for generating financial statements provided in this application are

[0030] In this embodiment, the first financial account information, the target header template information and the target user are obtained; a report preparation template is generated according to the first financial account information and the target header template information; the report preparation template is displayed in the display interface of the target user, and the target data filled in by the target user in the report preparation template is obtained; the second financial account information and multiple target report preparation templates associated with the second financial account information are determined, wherein the target header templates corresponding to the multiple target report preparation templates are the same; a summary report template is generated according to the second financial account information and the target header template information; based on the summary report template, the target data in the multiple target report preparation templates are summarized, and a summary report is generated. In this way, the report preparation template can be flexibly configured and generated according to user needs, and after the financial data is compiled based on the report preparation template, the statistical report data is automatically summarized based on the summary report template, which reduces the difficulty of generating financial reports and improves the generation efficiency and flexibility.

[0031] Additional aspects and advantages of the present application will be given in part in the description below, and in part will become apparent from the description below, or will be learned through the practice of the present application. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] The above and / or additional aspects and advantages of the present application will become apparent and easily understood from the following description of the embodiments in conjunction with the accompanying drawings, in which:

[0033] Figure 1 A flowchart of a method for generating a financial statement provided in an embodiment of the present application; and

[0034] Figure 2 A schematic diagram of the structure of a financial statement generation device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0035] The embodiments of the present application are described in detail below, and examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are intended to be used to explain the present application, and should not be construed as limiting the present application.

[0036] The following describes the method and device for generating financial statements according to an embodiment of the present application with reference to the accompanying drawings.

[0037] Figure 1 A flowchart of a method for generating financial statements provided in an embodiment of the present application.

[0038] like Figure 1As shown, the method for generating the financial statement includes the following steps:

[0039] Step 101, obtaining first financial account information, target header template information and target user.

[0040] In some embodiments, the first financial account information includes at least one of an account code, an account name, an account type, a numerical type, an account formula, and whether to give priority to the account formula corresponding to the first financial account selected by the first user.

[0041] In some embodiments, all basic financial account information of the financial field of the system can be pre-set in the system. Financial accounts refer to the preparation items involved in financial statements. Financial accounts are stored in the account basic table. The account basic table structure can be shown in Table 1:

[0042] Table 1

[0043]

[0044]

[0045] Examples of financial items in the insurance financial rolling forecast system can be shown in Table 2:

[0046] Table 2

[0047]

[0048] In some embodiments, if the first financial account selected by the first user is a formula account, the accounts that make up the formula must also be the first financial account. For example, the account PFT0000005 is selected, and the account PFT0000005 is obtained by subtracting PFT0000003 and PFT0000004, so the two accounts PFT0000003 and PFT0000004 must be selected. Similarly, PFT0000003 is also a formula account, which is obtained by adding PFT0000001+PFT0000002, so the two accounts PFT0000001 and PFT0000002 must also be selected.

[0049] In some embodiments, the first user may also select a target for filling in the generated report template. For example, in an insurance financial rolling forecast system, for forecasting the profit statement, the financial personnel of the head office and the financial personnel of multiple branches may be selected, and the corresponding positions are the general and provincial financial budget management positions.

[0050] In some embodiments, the target header template information includes at least one of the header template number, column code, column name, column type, value type, column formula, and column sequence number of the target header template selected by the user.

[0051] In some embodiments, the header template information corresponding to all report preparation dimensions in the financial field of the system can also be pre-set in the system, such as the commonly used dimensions in the insurance financial system include insurance type, channel, business source, etc. The header template information is stored in the header template table, and the header template table structure can be as shown in Table 3:

[0052] Table 3

[0053]

[0054] An example of initializing the first-level insurance category dimension in the insurance rolling forecast system can be shown in Table 4:

[0055] Table 4

[0056]

[0057] Step 102, generating a report template according to the first financial account information and the target header template information.

[0058] In some embodiments, report template information and report initialization data may also be generated for compiling a report template. The report template information mainly includes a report template main table, a report template appendix, and a report template user table. The report template initialization data mainly includes a report user table and a report detail table.

[0059] (1) The report template master table can be as shown in Table 5, recording the template number and name of the entered report template, the total number of the first financial account selected by the first user and the header template number of the target header template.

[0060] Table 5

[0061]

[0062] (2) The appendix to the report template can be as shown in Table 6, recording the template number of the report template, the account code of the first financial account selected, and the display order.

[0063] Table 6

[0064]

[0065] (3) The user table for preparing a report template can be as shown in Table 7, recording the report user (ie, target user) and the corresponding position selected by the first user.

[0066] Table 7

[0067]

[0068] (4) The report preparation user table may be as shown in Table 8, recording the target users and corresponding configuration status involved in preparing the report template.

[0069] Table 8

[0070]

[0071] (5) The report details table can be prepared as shown in Table 9, which can record the specific data filled in by the target user and record the filled in target data according to financial subjects and header columns.

[0072] Table 9

[0073]

[0074] When initializing report preparation data, one piece of data is initialized for each target user in the report preparation user table, and the configuration status is 01 in preparation; for the report preparation detail table, the preparation template non-formula account and the header non-formula column are looped through, and the target data is generated by cross multiplication of the account and the header column, and the corresponding target data is initialized to 0;

[0075] In some embodiments, the reporting subjects and headers of the report preparation template can be generated according to the subjects and target header template information in the appendix of the report preparation template. When traversing the subject rows and header columns of the report preparation template, for each cell, if it is a preparation item, the amount of the corresponding item is directly obtained from the report preparation details table. If the cell is a formula, it is determined whether it is a row formula or a column formula, and the formula is replaced with the row column expression in the cell and written into the template. The exported report preparation template can be shown in Table 10:

[0076] Table 10

[0077]

[0078] Step 103: display the report template in the display interface of the target user, and obtain the target data filled in by the target user in the report template.

[0079] Step 104, determining the second financial account information and a plurality of target report preparation templates associated with the second financial account information, wherein the target header templates corresponding to the plurality of target report preparation templates are the same.

[0080] In some embodiments, the second financial account information includes at least one of the account code, account name, serial number, account source, account custom formula, and account statistical method corresponding to the second financial account selected by the second user.

[0081] In some embodiments, the second financial account information corresponding to the summary report template may be as shown in Table 11:

[0082] Table 11

[0083]

[0084] In some embodiments, the second financial account selected by the second user from the first financial account of the target report template can be obtained; the second financial account customized by the second user and the corresponding second financial account information can also be obtained.

[0085] In some embodiments, if the second financial account is customized by the second user, the newly added statistical account needs to specify the corresponding account custom formula, and the accounts involved in the account custom formula must all come from the existing accounts in the target report template.

[0086] Step 105: Generate a summary report template according to the second financial account information and the target header template information.

[0087] In some embodiments, the information of the summary report template may also be recorded, and the information table of the summary report template may be as shown in Table 12. It includes the template number of the summary report template, the template name, the account data corresponding to the second financial account, and the header template number corresponding to the target header template.

[0088] Table 12

[0089]

[0090] In some embodiments, the summary report template is also initialized, and the corresponding initialized summary statistics detailed table may be as shown in Table 13.

[0091] Table 13

[0092]

[0093] When initializing the summary data, the second financial subject and the target header template corresponding to the summary report template are traversed, and each data item in the header column of the second financial subject and the target header template is traversed and written into the detail table. The summary data is initialized to 0.

[0094] Step 106, based on the summary report template, summarize the target data in the multiple target compilation report templates and generate a summary report.

[0095] In some embodiments, before aggregating the target data in multiple target report preparation templates, the preparation status of the target report preparation template can also be verified: for a statistical report, obtain all corresponding statistical second financial accounts, if the second financial account is a custom account, obtain the corresponding constituent financial account, find all target report preparation templates corresponding to the second financial account, query the configuration status of the report preparation user table corresponding to the target report preparation template, if the configuration status of all users is completed, perform statistical summary processing.

[0096] In some embodiments, determining the summary data corresponding to the non-customized non-formula account may include the following steps:

[0097] (1) The second financial account that does not have an account formula is determined as the third financial account;

[0098] Among them, the third financial account is a non-customized non-formula account.

[0099] (2) determining the header columns with column formulas in the target header template information as formula header columns, and determining the header columns without column formulas as non-formula header columns;

[0100] For example, in the header template information shown in Table 4, the total of all insurance types is the formula header column, and the rest are non-formula header columns.

[0101] (3) For the non-formula header column, based on the subject statistical method corresponding to the third financial subject, the third financial subject and the non-formula header column are aggregated with target data in multiple target report preparation templates to determine the aggregate data corresponding to the third financial subject in the non-formula header column in the aggregate report;

[0102] (4) For the formula header column, determine the header column involved in the column formula corresponding to the formula header column as the target header column, and based on the column formula corresponding to the formula header column, calculate the summary data corresponding to the third financial account in the summary report in the target header column to obtain the summary data corresponding to the third financial account in the formula header column in the summary report.

[0103] In some embodiments, determining the summary data corresponding to the non-customized formula account may include the following steps:

[0104] (1) A second financial account that has an account formula and is the same as any first financial account is determined as a fourth financial account;

[0105] Among them, the fourth financial account is a non-customized non-formula account.

[0106] (2) determining the header columns with column formulas in the target header template information as formula header columns, and determining the header columns without column formulas as non-formula header columns;

[0107] (3) For the non-formula header column, determine that the second financial account involved in the account formula corresponding to the fourth financial account is the target financial account, and based on the account formula corresponding to the fourth financial account, calculate the summary data corresponding to the target financial account in the non-formula header column in the summary report to obtain the summary data corresponding to the fourth financial account in the non-formula header column in the summary report;

[0108] (4) For the formula header column, when the account formula priority corresponding to the fourth financial account indicates that the priority of the account formula is higher than the priority of the column formula, the account formula corresponding to the fourth financial account is determined as the target formula, and based on the target formula, the summary data corresponding to the second financial account involved in the target formula in the summary report in the formula header column is calculated to obtain the summary data corresponding to the fourth financial account in the non-formula header column in the summary report;

[0109] (5) With respect to the formula header column, when the priority of the account formula priority indicator column formula corresponding to the fourth financial account is higher than the priority of the account formula, the column formula corresponding to the formula header column is determined as the target formula, and based on the target formula, the summary data corresponding to the header column involved in the target formula of the fourth financial account in the summary report is calculated to obtain the summary data corresponding to the non-formula header column of the fourth financial account in the summary report.

[0110] In some embodiments, determining the summary data corresponding to the custom account may include the following steps:

[0111] (1) determining a second financial account that has a custom account formula and is customized by a second user as the fifth financial account;

[0112] Among them, the fifth financial account is a custom account.

[0113] (5) Based on the custom account formula corresponding to the fifth financial account, the summary data corresponding to the second financial account in the header column involved in the custom account formula in the summary report is calculated to obtain the summary data corresponding to the fifth financial account in the header column in the summary report.

[0114] In this embodiment, the first financial account information, the target header template information and the target user are obtained; a report preparation template is generated according to the first financial account information and the target header template information; the report preparation template is displayed in the display interface of the target user, and the target data filled in by the target user in the report preparation template is obtained; the second financial account information and multiple target report preparation templates associated with the second financial account information are determined, wherein the target header templates corresponding to the multiple target report preparation templates are the same; a summary report template is generated according to the second financial account information and the target header template information; based on the summary report template, the target data in the multiple target report preparation templates are summarized, and a summary report is generated. In this way, the report preparation template can be flexibly configured and generated according to user needs, and after the financial data is compiled based on the report preparation template, the statistical report data is automatically summarized based on the summary report template, thereby reducing the difficulty of generating financial reports and improving the generation efficiency.

[0115] In order to implement the above embodiment, the present application also proposes a device for generating financial statements.

[0116] Figure 2 This is a schematic diagram of the structure of a device for generating financial statements provided in an embodiment of the present application. Figure 2 As shown, the financial statement generating device includes:

[0117] The first acquisition module 201 is used to acquire first financial account information, target header template information and target user;

[0118] The first generating module 202 is used to generate a report template according to the first financial account information and the target header template information;

[0119] The second acquisition module 203 is used to display the report preparation template in the display interface of the target user and obtain the target data filled in the report preparation template by the target user;

[0120] The determination module 204 is used to determine the second financial account information and multiple target report preparation templates associated with the second financial account information, wherein the target header templates corresponding to the multiple target report preparation templates are the same;

[0121] The second generating module 205 is used to generate a summary report template according to the second financial account information and the target header template information;

[0122] The summary module 206 is used to summarize the target data in multiple target compilation report templates based on the summary report template and generate a summary report.

[0123] In some embodiments, the first financial account information includes at least one of an account code, an account name, an account type, a value type, an account formula, and whether to use the account formula first, corresponding to the first financial account selected by the first user;

[0124] The target header template information includes at least one of the header template number, column code, column name, column type, value type, column formula, and column sequence number of the target header template selected by the user.

[0125] In some embodiments, the second financial account information includes at least one of the account code, account name, serial number, account source, account custom formula, and account statistical method corresponding to the second financial account selected by the second user.

[0126] In some embodiments, a third acquisition module is further included, which is used to:

[0127] Obtaining a second financial subject selected by a second user from the first financial subject of a target report template; and / or,

[0128] Obtain the second financial account customized by the second user and the corresponding second financial account information.

[0129] In some embodiments, the aggregation module 207 is used to:

[0130] The second financial account without account formula is determined as the third financial account;

[0131] The header columns with column formulas in the target header template information are determined as formula header columns, and the header columns without column formulas are determined as non-formula header columns;

[0132] For the non-formula header column, based on the subject statistical method corresponding to the third financial subject, the third financial subject and the non-formula header column are summarized in the target data of multiple target report preparation templates to determine the summary data corresponding to the third financial subject in the non-formula header column in the summary report;

[0133] For the formula header column, determine the header column involved in the column formula corresponding to the formula header column as the target header column, and based on the column formula corresponding to the formula header column, calculate the summary data corresponding to the third financial account in the summary report in the target header column to obtain the summary data corresponding to the third financial account in the formula header column in the summary report.

[0134] In some embodiments, the aggregation module 207 is used to:

[0135] Determine a second financial account that has an account formula and is the same as any first financial account as a fourth financial account;

[0136] The header columns with column formulas in the target header template information are determined as formula header columns, and the header columns without column formulas are determined as non-formula header columns;

[0137] For the non-formula header column, determine that the second financial account involved in the account formula corresponding to the fourth financial account is the target financial account, and based on the account formula corresponding to the fourth financial account, calculate the summary data corresponding to the target financial account in the non-formula header column in the summary report to obtain the summary data corresponding to the fourth financial account in the non-formula header column in the summary report;

[0138] For the formula header column, when the account formula priority corresponding to the fourth financial account indicates that the priority of the account formula is higher than the priority of the column formula, the account formula corresponding to the fourth financial account is determined as the target formula, and based on the target formula, the summary data corresponding to the second financial account involved in the target formula in the summary report in the formula header column is calculated to obtain the summary data corresponding to the fourth financial account in the non-formula header column in the summary report;

[0139] For the formula header column, when the priority of the account formula priority indicator column formula corresponding to the fourth financial account is higher than the priority of the account formula, the column formula corresponding to the formula header column is determined as the target formula, and based on the target formula, the summary data corresponding to the header column involved in the target formula of the fourth financial account in the summary report is calculated to obtain the summary data corresponding to the non-formula header column of the fourth financial account in the summary report.

[0140] In some embodiments, the aggregation module 207 is used to:

[0141] Determine the second financial account that has a custom account formula and is custom-defined by a second user as the fifth financial account;

[0142] Based on the account custom formula corresponding to the fifth financial account, the summary data corresponding to the second financial account in the header column involved in the account custom formula in the summary report is calculated to obtain the summary data corresponding to the fifth financial account in the header column in the summary report.

[0143] It should be noted that the above explanations of the embodiment of the method for generating financial statements are also applicable to the device for generating financial statements of this embodiment, and will not be described in detail here.

[0144] In this embodiment, the first financial account information, the target header template information and the target user are obtained; a report preparation template is generated according to the first financial account information and the target header template information; the report preparation template is displayed in the display interface of the target user, and the target data filled in by the target user in the report preparation template is obtained; the second financial account information and multiple target report preparation templates associated with the second financial account information are determined, wherein the target header templates corresponding to the multiple target report preparation templates are the same; a summary report template is generated according to the second financial account information and the target header template information; based on the summary report template, the target data in the multiple target report preparation templates are summarized, and a summary report is generated. In this way, the report preparation template can be flexibly configured and generated according to user needs, and after the financial data is compiled based on the report preparation template, the statistical report data is automatically summarized based on the summary report template, thereby reducing the difficulty of generating financial reports and improving the generation efficiency.

[0145] In order to implement the above embodiments, the present application also proposes an electronic device, comprising: a processor, and a memory communicatively connected to the processor; the memory stores computer-executable instructions; the processor executes the computer-executable instructions stored in the memory to implement the method provided by the above embodiments.

[0146] In order to implement the above embodiments, the present application also proposes a computer-readable storage medium, in which computer-executable instructions are stored. When the computer-executable instructions are executed by a processor, they are used to implement the methods provided by the above embodiments.

[0147] In order to implement the above embodiments, the present application also proposes a computer program product, including a computer program, which implements the methods provided by the above embodiments when executed by a processor.

[0148] The collection, storage, use, processing, transmission, provision and disclosure of user personal information involved in this application are in compliance with relevant laws and regulations and do not violate public order and good morals.

[0149] It should be noted that personal information from users should be collected for legitimate and reasonable purposes and should not be shared or sold outside of these legitimate uses. In addition, such collection / sharing should be carried out after receiving the user's informed consent, including but not limited to notifying the user to read the user agreement / user notice and sign the agreement / authorization including authorization of relevant user information before the user uses the function. In addition, any necessary steps should be taken to protect and safeguard access to such personal information data and ensure that others who have access to personal information data comply with its privacy policy and procedures.

[0150] The present application is expected to provide an implementation scheme for users to selectively block the use or access of personal information data. That is, the present disclosure is expected to provide hardware and / or software to prevent or block access to such personal information data. Once the personal information data is no longer needed, the risk can be minimized by limiting data collection and deleting the data. In addition, when applicable, such personal information is de-identified to protect the privacy of the user.

[0151] In the description of the aforementioned embodiments, the description with reference to the terms "one embodiment", "some embodiments", "example", "specific example", or "some examples" etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present application. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner. In addition, those skilled in the art may combine and combine the different embodiments or examples described in this specification and the features of the different embodiments or examples, without contradiction.

[0152] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Therefore, the features defined as "first" and "second" may explicitly or implicitly include at least one of the features. In the description of this application, the meaning of "plurality" is at least two, such as two, three, etc., unless otherwise clearly and specifically defined.

[0153] Any process or method description in a flowchart or otherwise described herein may be understood to represent a module, fragment or portion of code comprising one or more executable instructions for implementing the steps of a custom logical function or process, and the scope of the preferred embodiments of the present application includes alternative implementations in which functions may not be performed in the order shown or discussed, including performing functions in a substantially simultaneous manner or in the reverse order depending on the functions involved, which should be understood by technicians in the technical field to which the embodiments of the present application belong.

[0154] The logic and / or steps represented in the flowchart or otherwise described herein, for example, can be considered as an ordered list of executable instructions for implementing logical functions, and can be embodied in any computer-readable medium for use by an instruction execution system, device or apparatus (such as a computer-based system, a system including a processor, or other system that can fetch instructions from an instruction execution system, device or apparatus and execute the instructions), or in combination with these instruction execution systems, devices or apparatuses. For the purpose of this specification, "computer-readable medium" can be any device that can contain, store, communicate, propagate or transmit a program for use by an instruction execution system, device or apparatus, or in combination with these instruction execution systems, devices or apparatuses. More specific examples of computer-readable media (a non-exhaustive list) include the following: an electrical connection with one or more wires (electronic device), a portable computer disk box (magnetic device), a random access memory (RAM), a read-only memory (ROM), an erasable and programmable read-only memory (EPROM or flash memory), a fiber optic device, and a portable compact disk read-only memory (CDROM). In addition, the computer-readable medium may even be paper or other suitable medium on which the program is printed, since the program may be obtained electronically, for example, by optically scanning the paper or other medium and then editing, interpreting or processing in other suitable ways if necessary, and then stored in a computer memory.

[0155] It should be understood that the various parts of the present application can be implemented by hardware, software, firmware or a combination thereof. In the above-mentioned embodiments, multiple steps or methods can be implemented by software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented by hardware, as in another embodiment, it can be implemented by any one of the following technologies known in the art or their combination: a discrete logic circuit having a logic gate circuit for implementing a logic function for a data signal, a dedicated integrated circuit having a suitable combination of logic gate circuits, a programmable gate array (PGA), a field programmable gate array (FPGA), etc.

[0156] A person skilled in the art may understand that all or part of the steps in the method for implementing the above-mentioned embodiment may be completed by instructing related hardware through a program, and the program may be stored in a computer-readable storage medium, which, when executed, includes one or a combination of the steps of the method embodiment.

[0157] In addition, each functional unit in each embodiment of the present application may be integrated into a processing module, or each unit may exist physically separately, or two or more units may be integrated into one module. The above-mentioned integrated module may be implemented in the form of hardware or in the form of a software functional module. If the integrated module is implemented in the form of a software functional module and sold or used as an independent product, it may also be stored in a computer-readable storage medium.

[0158] The storage medium mentioned above may be a read-only memory, a magnetic disk or an optical disk, etc. Although the embodiments of the present application have been shown and described above, it can be understood that the above embodiments are exemplary and cannot be understood as limiting the present application. A person of ordinary skill in the art may change, modify, replace and modify the above embodiments within the scope of the present application.

Claims

1. A method for generating a financial statement, characterized in that: The following steps are involved: Obtain the first financial account information, target header template information and target user; Generate a report template according to the first financial account information and the target header template information; Displaying a report preparation template in the display interface of the target user, and acquiring target data filled in by the target user in the report preparation template; Determine the second financial account information and multiple target report preparation templates associated with the second financial account information, wherein the target header templates corresponding to the multiple target report preparation templates are the same; Generate a summary report template according to the second financial account information and the target header template information; Based on the summary report template, the target data in the multiple target compilation report templates are summarized and a summary report is generated.

2. The method according to claim 1, characterized in that The first financial account information includes at least one of an account code, an account name, an account type, a value type, an account formula, and whether to use the account formula first, corresponding to the first financial account selected by the first user; The target header template information includes at least one of the header template number, column code, column name, column type, value type, column formula, and column sequence number of the target header template selected by the user.

3. The method according to claim 2, characterized in that The second financial account information includes at least one of an account code, an account name, a serial number, an account source, an account custom formula, and an account statistical method corresponding to the second financial account selected by the second user.

4. The method according to claim 3, characterized in that Also includes: Acquire a second financial subject selected by the second user from the first financial subject of the target report preparation template; and / or, Obtain the second financial subject defined by the second user and the corresponding second financial subject information.

5. The method according to claim 4, characterized in that The target data in the target compilation report templates are summarized based on the summary report template, and a summary report is generated, including: The second financial account without account formula is determined as the third financial account; Determine the header columns with column formulas in the target header template information as formula header columns, and determine the header columns without column formulas as non-formula header columns; For the non-formula header column, based on the subject statistics method corresponding to the third financial subject, the third financial subject and the non-formula header column are aggregated with target data in a plurality of target report preparation templates to determine the aggregate data corresponding to the non-formula header column of the third financial subject in the aggregate report; For the formula header column, determine the header column involved in the column formula corresponding to the formula header column as the target header column, and based on the column formula corresponding to the formula header column, calculate the summary data corresponding to the target header column of the third financial subject in the summary report to obtain the summary data corresponding to the formula header column of the third financial subject in the summary report.

6. The method according to claim 4, characterized in that The target data in the target compilation report templates are summarized based on the summary report template, and a summary report is generated, including: Determine a second financial account that has an account formula and is the same as any first financial account as a fourth financial account; Determine the header columns with column formulas in the target header template information as formula header columns, and determine the header columns without column formulas as non-formula header columns; For the non-formula header column, determine that the second financial account involved in the account formula corresponding to the fourth financial account is the target financial account, and based on the account formula corresponding to the fourth financial account, calculate the summary data corresponding to the non-formula header column of the target financial account in the summary report to obtain the summary data corresponding to the non-formula header column of the fourth financial account in the summary report; For the formula header column, when the account formula priority corresponding to the fourth financial account indicates that the priority of the account formula is higher than the priority of the column formula, the account formula corresponding to the fourth financial account is determined as the target formula, and based on the target formula, the summary data corresponding to the formula header column of the second financial account involved in the target formula in the summary report is calculated to obtain the summary data corresponding to the non-formula header column of the fourth financial account in the summary report; For the formula header column, when the priority of the account formula priority indication column formula corresponding to the fourth financial account is higher than the priority of the account formula, the column formula corresponding to the formula header column is determined as the target formula, and based on the target formula, the summary data corresponding to the header column involved in the target formula of the fourth financial account in the summary report is calculated to obtain the summary data corresponding to the non-formula header column of the fourth financial account in the summary report.

7. The method according to claim 4, characterized in that The target data in the target compilation report templates are summarized based on the summary report template, and a summary report is generated, including: Determine the second financial account that has a custom account formula and is custom-defined by the second user as the fifth financial account; Based on the custom account formula corresponding to the fifth financial account, the summary data corresponding to the second financial account in the header column involved in the custom account formula in the summary report is calculated to obtain the summary data corresponding to the fifth financial account in the header column in the summary report.

8. A device for generating financial statements, characterized in that: include: A first acquisition module is used to acquire first financial account information, target header template information and target user; A first generating module, used for generating a report template according to the first financial account information and the target header template information; A second acquisition module is used to display the report preparation template in the display interface of the target user and obtain the target data filled in the report preparation template by the target user; A determination module, used to determine the second financial account information and a plurality of target report preparation templates associated with the second financial account information, wherein the target header templates corresponding to the plurality of target report preparation templates are the same; A second generating module, used for generating a summary report template according to the second financial account information and the target header template information; The summary module is used to summarize the target data in the multiple target compilation report templates based on the summary report template and generate a summary report.

9. An electronic device, characterized in that: include: A processor, and a memory communicatively connected to the processor; The memory stores computer-executable instructions; The processor executes the computer-executable instructions stored in the memory to implement the method according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-executable instructions, which are used to implement the method according to any one of claims 1 to 7 when executed by a processor.

Images