A method, system, and storage medium for dynamically generating financial statements

Abstract

The application provides a method, a system and a storage medium for dynamically generating a financial statement, which are applied to a dynamic financial statement generation system, the dynamic financial statement generation system comprises a table data configuration node and a target report node, and the method comprises the following steps: obtaining source data to be processed and an output target value set of the target report node; extracting a table configuration data set output by the table data configuration node; performing data processing on the source data to be processed by using the table configuration data set, so as to obtain an intermediate report set; and screening an intermediate report in the intermediate report set which meets the output target value set, as the output of the target report node, so that the system can generate various reports, and it is not necessary to perform hard coding mode responsible for outputting each column one by one, the generation efficiency of the report is effectively improved, and the maintenance and management cost is reduced.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of computer, in particular to a method and system for dynamically generating financial statements and a storage medium. BACKGROUND

[0002] In the field of computer technology, because of different business needs, different reports need to be generated. The traditional report generation method generally uses hard coding to output each column of the report one by one, and sets the format and formula of each column. This generation method is only suitable for generating simple single reports, and if the report needs to be modified later, it needs to be adjusted again by hard coding. It is not suitable for the generation of a large number of reports and dynamically changing reports, and multiple sets of reports cannot be reused. Therefore, this method is relatively inefficient, so for a special report system, a method for dynamically generating reports should be proposed for application, which can facilitate the maintenance and management of the report system and greatly improve the work efficiency. SUMMARY

[0003] The main purpose of the present application is to provide a method and system for dynamically generating financial statements, which aims to solve the technical problem of low efficiency of existing large-scale data report processing.

[0004] To achieve the above purpose, the present application provides a method for dynamically generating financial statements, which is applied to a system for dynamically generating financial statements, the system comprising a table data configuration node and a target report node, the method comprising:

[0005] obtaining source data to be processed and an output target value set of the target report node;

[0006] extracting a table configuration data set output by the table data configuration node;

[0007] performing data processing on the source data to be processed using the table configuration data set to obtain an intermediate report set;

[0008] filtering intermediate reports in the intermediate report set that meet the output target value set as the output of the target report node.

[0009] Optionally, before the step of extracting the table configuration data set output by the table data configuration node, the method comprises:

[0010] obtaining a model table set;

[0011] identifying table header data of each model table in the model table set to obtain table header fields;

[0012] identifying each column of each model table based on a preset identification rule to obtain corresponding column identifiers;

[0013] mapping relationship between the column identifier and the table header field is established to obtain a column encoding dictionary.

[0014] Optionally, after the mapping relationship between the column identifier and the table header field is established to obtain a column encoding dictionary, the method comprises:

[0015] A hierarchical relationship corresponding to each cell in each of the model tables is identified to obtain corresponding basic hierarchical data.

[0016] The cells in each column of each of the model tables are data encoded using the encoding dictionary to obtain corresponding basic column code data.

[0017] The hierarchical data corresponding to each of the cells is embedded into the basic column code data to obtain a basic identifier of each of the cells.

[0018] The basic identifiers of each of the cells in each of the model tables are summarized to obtain the table configuration data set corresponding to each of the model tables.

[0019] Optionally, the dynamic financial statement generation system further comprises a conversion node, and the method comprises:

[0020] In response to a conversion request received by the conversion node, the conversion request comprising the source data to be processed;

[0021] The data to be processed is data encoded according to the table configuration data set to obtain a corresponding intermediate configuration set;

[0022] A field data set corresponding to the source data to be processed is obtained.

[0023] The field data set is mapped to a target position of the model table set using the intermediate configuration set to obtain an intermediate report set.

[0024] Optionally, the method further comprises:

[0025] In response to a report generation instruction received by the target report node, the report generation comprising the output target value set;

[0026] The intermediate report is target condition filtered using the output target value set.

[0027] A target report corresponding to the target condition is output.

[0028] Optionally, the method further comprises:

[0029] acquire updated data and / or extended data of the to-be-processed source data currently;

[0030] update the table configuration data set according to the updated data and / or the extended data

[0031] In addition, to achieve the above object, the application further provides a dynamic financial statement generation system, characterized in that the dynamic financial statement generation system comprises a table data configuration node and a target statement node, and the system comprises:

[0032] a data acquisition module, configured to acquire to-be-processed source data and an output target value set of the target statement node;

[0033] a configuration extraction module, configured to extract a table configuration data set output by the table data configuration node;

[0034] an intermediate conversion module, configured to perform data processing on the to-be-processed source data by using the table configuration data set, to obtain an intermediate statement set;

[0035] a condition screening module, configured to screen an intermediate statement in the intermediate statement set that meets the output target value set as an output of the target statement node.

[0036] Optionally, the dynamic financial statement generation system further comprises:

[0037] a calling subunit, configured to acquire a model table set;

[0038] an identification subunit, configured to identify table header data of each model table in the model table set, to obtain table header fields;

[0039] an identification subunit, configured to identify each column of each model table based on a preset identification rule, to obtain corresponding column identifications;

[0040] a mapping subunit, configured to establish a mapping relationship between the column identifications and the table header fields, to obtain a column encoding dictionary.

[0041] Optionally, the dynamic financial statement generation system further comprises:

[0042] a hierarchical subunit, configured to identify a hierarchical relationship corresponding to each cell in each model table, to obtain corresponding basic hierarchical data;

[0043] a basic encoding subunit, configured to perform data encoding on the cells of each column in each model table by using the encoding dictionary, to obtain corresponding basic column code data;

[0044] a data embedding subunit, configured to embed the hierarchical data corresponding to each cell into the basic column code data, to obtain a basic identification of each cell.

[0045] The aggregation sub-unit is configured to aggregate the basic identifiers of each cell in each model table to obtain a table configuration data set corresponding to each model table.

[0046] In addition, to achieve the above object, the application further provides a computer readable storage medium, wherein the computer readable storage medium stores a data processing program, and the data processing program is executed by a processor to implement the steps of the method for dynamically generating a financial statement.

[0047] Compared with the prior art, the application has the following beneficial effects:

[0048] The method for dynamically generating a financial statement provided by the application is applied to a dynamic financial statement generation system, the dynamic financial statement generation system comprises a table data configuration node and a target report node, and the method comprises the following steps: obtaining source data to be processed and an output target value set of the target report node; extracting a table configuration data set output by the table data configuration node; performing data processing on the source data to be processed by using the table configuration data set to obtain an intermediate report set; and screening an intermediate report in the intermediate report set that meets the output target value set as the output of the target report node, so that various reports can be generated, and the responsible hard coding mode is not required to output each column one by one, the generation efficiency of the report is effectively improved, and the maintenance and management cost is reduced. BRIEF DESCRIPTION OF DRAWINGS

[0049] In order to more clearly illustrate the scheme in the application, the drawings needed in the description of the embodiments of the application will be briefly introduced. Obviously, the drawings in the following description are some embodiments of the application, and other drawings can be obtained by those skilled in the art without creative labor.

[0050] Figure 1 is an exemplary system architecture diagram to which the application can be applied;

[0051] Figure 2 is a flowchart of one embodiment of the method for dynamically generating a financial statement according to the application;

[0052] Figure 3 is a structural diagram of one embodiment of the dynamic financial statement generation system according to the application

[0053] Figure 4 is a structural schematic diagram of one embodiment of the computer device according to the application. DETAILED DESCRIPTION

[0054] The data format determination method provided by the embodiments of the present application is applied to a data processing system. Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs. The terminology used in the description herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the present application. The description and the drawings are to be regarded as illustrative in nature and their objects are to be understood as not limiting the present application. The terms "comprising," "having," "including," and "containing" used in the detailed description and the claims herein are used in their open-ended, non-limiting sense. The terms "first," "second," and the like used in the description and the claims herein are used to distinguish one element from another and are not used to designate a particular order or sequence.

[0055] Reference herein to "embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment can be included in at least one embodiment of the application. The appearances of the phrase in various places in the specification are not necessarily all referring to the same embodiment, nor are they necessarily mutually exclusive of one another. It is expressly understood that the embodiments described herein are merely examples from a

[0056] In order to make the technical personnel in the art better understand the scheme of the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings.

[0057] As shown in Figure 1 The system architecture 100 can include terminal devices 101, 102, 103, a network 104, and a server 105. The network 104 is used to provide a communication link medium between the terminal devices 101, 102, 103 and the server 105. The network 104 can include various connection types, such as wired, wireless communication links, or optical fiber cables, etc.

[0058] A user can use the terminal devices 101, 102, 103 to interact with the server 105 through the network 104 to receive or send messages, etc. Various communication client applications can be installed on the terminal devices 101, 102, 103, such as web browser applications, shopping applications, search applications, instant messaging tools, email clients, social online platform software, etc.

[0059] The terminal devices 101, 102, and 103 can be various electronic devices with display screens and supporting web browsing, including but not limited to smart phones, tablet computers, e-book readers, MP3 (Moving Picture Experts Group Audio Layer III) players, MP4 (Moving Picture Experts Group Audio Layer IV) players, laptop computers, desktop computers, and the like.

[0060] The server 105 can be a server providing various services, such as a background server providing support for a page displayed on the terminal devices 101, 102, and 103.

[0061] It should be noted that the method for dynamically generating a financial statement provided in the embodiments of the present application is generally executed by a server / terminal device, and accordingly, the system for dynamically generating a financial statement is generally arranged in a server / terminal device.

[0062] It should be understood that Figure 1 The number of terminal devices, networks, and servers in

[0063] With reference to Figure 2 , a flowchart of one embodiment of the method for dynamically generating a financial statement according to the present application is shown. The embodiments of the present application can acquire and process relevant data based on artificial intelligence technology. The method for dynamically generating a financial statement includes the following steps:

[0064] S210 acquiring source data to be processed and an output target value set of the target report node;

[0065] It should be noted that the method for dynamically generating a financial statement provided in the embodiments of the present application is applied to a system for dynamically generating a financial statement, which communicates with an external client. The system for dynamically generating a financial statement includes a table data configuration node and a target report node. The table data configuration node can be referred to as a basic configuration acquisition center, and the target report node can be referred to as a report output center. The nodes in the system for dynamically generating a financial statement can communicate through a remote calling interface.

[0066] Specifically, the acquisition manner of the to-be-processed source data can be acquired from any system, and the acquired to-be-processed source data can be sales business data, financial expenditure data, procurement expenditure data, bank guarantee data, etc. The to-be-processed source data is specifically acquired from which system, which is not limited in the present application. In addition, the data type can be any one kind of report data, which is also not limited in the present application.

[0067] S220 extracts the table configuration data set output by the table data configuration node;

[0068] Specifically, after acquiring the to-be-processed source data and the output target value set of the target report node, the table configuration data output by the table structure configuration node is extracted. However, before the operation of extracting the table configuration data output by the table structure configuration node, the table configuration data needs to be constructed first. The specific steps include: acquiring a model table set. It needs to be explained that the model table set can be set according to different user needs and is pre-stored in the computer or server. Each model table in the model table set can acquire field information according to the entity fields in the sales business, engineering time limit data, and engineering completion benefit data. The engineering completion benefit data can include completion date, sales quantity, area, amount, year, etc. The field information of each model table in the model table set can be characterized according to the specific needs of the user.

[0069] The header data in the model table is identified. Taking the EXCEL report generation part as an example, after importing the corresponding report, all column data of the table header are traversed based on the table header, the field data of each column is extracted, and the table header field is obtained. The corresponding column code is generated according to the table header field of each column of the table header. The construction method of the column code can be constructed according to the code of the report itself, or it can be constructed and named by itself, which is not limited here. The column code is positioned as the unique column identifier of this column, and the column name and column code are associated with each other to construct the mapping relationship in turn, and the column code dictionary is obtained.

[0070] Further, after obtaining the column code dictionary, it also includes identifying the corresponding hierarchical relationship of each cell in each model table to obtain the corresponding basic hierarchical data; using the code dictionary to encode the cells of each column in each model table to obtain the corresponding basic column code data; embedding the hierarchical data corresponding to each cell into the basic column code data to obtain the basic identifier of each cell. The basic identifiers of each cell in each model table are summarized to obtain the table configuration data set corresponding to each model table

[0071] In another preferred embodiment, the method further includes first obtaining the hierarchical relationship of each column in the identification model table, and then encoding each column through column coding, wherein the column code of each column includes the hierarchical relationship. The data format of each cell in the model table is extracted, i.e., the expression formula in the report, such as the expression formula of cell A10 being SUM(DC30:DC32). Based on the data format of each cell in the report, it can be classified into summary data and cell data, and its formula can also be called summary formula and cell formula. The data format of the cell is replaced using the previously encoded column code; for example, A10 can be represented as SUMIFS(<-CurrentA->,<-LevelId->,650), where 650 is the child level. The data of all cells in the model table set is extracted according to the above rules, and the summarized data is obtained as the table configuration dataset.

[0072] In another embodiment, the method further includes obtaining updated data and / or extended data of the current source data to be processed, and updating the table configuration dataset based on the updated data and / or extended data.

[0073] Specifically, the updated and / or extended data of the source data to be processed can be manually imported or imported periodically from any database. This can include historical business data or real-time generated business data. The updated and / or extended data are extracted using the extraction method configured in the table data above, and the table configuration dataset is updated accordingly.

[0074] S230 uses the table to configure the dataset to process the source data to be processed, and obtains an intermediate report set;

[0075] It should be noted that, in this embodiment, the dynamic financial statement generation system also includes a conversion node, which can be understood as a configuration conversion center for converting the source data to be processed into reports. Specifically, when the conversion node receives a conversion request, it performs data conversion based on the source data to be processed contained in the conversion request, extracts the table configuration data corresponding to the source data to be processed, and uses the table configuration data to encode the source data to be processed.

[0076] First, the column data of each sub-table and main table in the source data to be processed is obtained, and the corresponding configuration data in the table configuration dataset is matched and determined to update the encoding dictionary. Then, hierarchical recognition is performed, and a basic table structure is constructed based on the hierarchical and column relationships, and table header data is generated based on the basic table structure. This also includes processing the data formulas in each cell. For example, if the encoding dictionary extracts the current cell's level to 400, and the data expression for level 400 is SUMIFS(<-CurrentA->,<-LevelId->,650), then regular expressions are used to extract all column identifiers (CurrentA, LevelId) from the formula. Then, the Excel column name DC is retrieved through column CurrentA, and E is retrieved through LevelId. The row number is calculated based on the child level. Therefore, the final data format written to the report is a cross-table expression, which can be SUMIFS(DC30:DC32,E32:E32,650).

[0077] Furthermore, obtain the field dataset corresponding to the source data to be processed; use the intermediate configuration set to map the field dataset to the target location of the model table set to obtain the intermediate report set.

[0078] In this embodiment, the intermediate report set is generated by filling the corresponding target positions with the corresponding field data associated with the standard configuration dataset in the source data to be processed.

[0079] In this embodiment, the desired report type can also be entered by logging into the system; it can be a consolidated report or a non-consolidated report. The input method for the report type information can be any of a text box, selection box, or drop-down list.

[0080] S240 filters the intermediate reports in the intermediate report set that match the output target value set, and uses them as the output of the target report node.

[0081] In this embodiment, in response to the report generation instruction received by the target report node, the report generation includes outputting a target value set; using the output target value set to filter intermediate reports according to target conditions; and outputting the target report that meets the target conditions.

[0082] Specifically, the output target value set can be the target value of the corresponding report entered by the user in the system interface, the target value corresponding to the specified table header, or the target value of the specified corresponding report that has been pre-built. Intermediate reports that meet the conditions are output, and the corresponding version number information is extracted and written into the version information: the version information exists in cell A1 of each sub-table and parent table, or it can be in cell A2, without limitation. Data identification is performed by writing the name data corresponding to the current task version, the name data of the current output table, and the name data of the corresponding model table into the target table.

[0083] Compared with the prior art, the embodiments of this application have the following main advantages:

[0084] This application proposes a method for dynamically generating financial statements, applied to a system for dynamically generating financial statements. The system includes a table data configuration node and a target report node. The method includes: acquiring source data to be processed and the output target value set of the target report node; extracting the table configuration dataset output by the table data configuration node; processing the source data to be processed using the table configuration dataset to obtain an intermediate report set; and filtering intermediate reports in the intermediate report set that conform to the output target value set as the output of the target report node. This allows for the generation of diverse reports without requiring cumbersome hard-coding to output each column individually, effectively improving report generation efficiency and reducing maintenance and management costs.

[0085] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. This computer program can be stored in a computer-readable storage medium, and when executed, it can include the processes of the embodiments of the methods described above. The aforementioned storage medium can be a non-volatile storage medium such as a magnetic disk, optical disk, or read-only memory (ROM), or random access memory (RAM).

[0086] It should be understood that although the steps in the flowcharts of the accompanying figures are shown sequentially as indicated by the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless explicitly stated herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least some steps in the flowcharts of the accompanying figures may include multiple sub-steps or multiple stages. These sub-steps or stages are not necessarily completed at the same time, but can be executed at different times, and their execution order is not necessarily sequential, but can be performed alternately or in turn with other steps or at least some of the sub-steps or stages of other steps.

[0087] Further reference Figure 4 As a response to the above Figure 2 The implementation of the method shown in this application provides an embodiment of a dynamic financial statement generation system 300, which is similar to... Figure 2 Corresponding to the method embodiments shown, this device can be specifically applied to various electronic devices.

[0088] This invention provides a dynamic financial statement generation system 300, which includes a table data configuration node and a target report node.

[0089] Data acquisition module 301: used to acquire the source data to be processed, and the output target value set of the target report node;

[0090] Configuration extraction module 302: used to extract the table configuration dataset output by the table data configuration node;

[0091] Intermediate conversion module 303: Used to process the source data to be processed using the table configuration dataset to obtain an intermediate report set;

[0092] Condition filtering module 304: used to filter intermediate reports in the intermediate report set that meet the output target value set, and use them as the output of the target report node.

[0093] Optionally, the configuration extraction module 302 further includes: a retrieval subunit, an identification subunit, an identifier subunit, and a mapping subunit.

[0094] The retrieval subunit is used to obtain the model table set;

[0095] The identification subunit is used to identify the header data of each model table in the model table set and obtain the header field.

[0096] The identification subunit is used to identify each column of each model table based on preset identification rules to obtain the corresponding column identifier;

[0097] The mapping subunit is used to establish a mapping relationship between the column identifier and the header field to obtain a column encoding dictionary.

[0098] Optionally, the configuration extraction module 302 further includes: a hierarchical subunit, a basic encoding subunit, a data embedding subunit, and a aggregation subunit.

[0099] The hierarchical sub-unit is used to identify the hierarchical relationship corresponding to each cell in each of the model tables, and to obtain the corresponding basic hierarchical data.

[0100] The basic encoding subunit is used to encode the data of each cell in each column of each model table using the encoding dictionary, so as to obtain the corresponding basic column code data.

[0101] The data embedding subunit is used to embed the hierarchical data corresponding to each cell into the basic column code data to obtain the basic identifier of each cell;

[0102] The aggregation subunit is used to summarize the basic identifier of each cell in each model table to obtain the table configuration dataset corresponding to each model table.

[0103] Compared with the prior art, the embodiments of this application have the following main advantages:

[0104] This application proposes a dynamic financial statement generation system, which includes a table data configuration node and a target report node. The method includes: a data acquisition module for acquiring source data to be processed and the output target value set of the target report node; a configuration extraction module for extracting the table configuration dataset output by the table data configuration node; an intermediate conversion module for processing the source data to be processed using the table configuration dataset to obtain an intermediate report set; and a condition filtering module for filtering intermediate reports in the intermediate report set that meet the output target value set as the output of the target report node. This allows for the generation of diverse reports without requiring cumbersome hard-coding to output each column one by one, effectively improving report generation efficiency and reducing maintenance and management costs.

[0105] To address the aforementioned technical problems, embodiments of this application also provide a computer device. Please refer to [link / reference needed]. Figure 4 , Figure 4 This is a basic structural block diagram of the computer device in this embodiment.

[0106] The computer device 5 includes a memory 51, a processor 52, and a network interface 53 that are interconnected via a system bus. It should be noted that only the computer device 5 with components 51-53 is shown in the figure; however, it should be understood that it is not required to implement all the shown components, and more or fewer components can be implemented alternatively. Those skilled in the art will understand that the computer device described here is a device capable of automatically performing numerical calculations and / or information processing according to pre-set or stored instructions, and its hardware includes, but is not limited to, microprocessors, application-specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), digital signal processors (DSPs), embedded devices, etc.

[0107] The computer device can be a desktop computer, laptop, handheld computer, or cloud server, etc. The computer device can interact with the user via a keyboard, mouse, remote control, touchpad, or voice control.

[0108] The memory 51 includes at least one type of readable storage medium, including flash memory, hard disk, multimedia card, card-type memory (e.g., SD or DX memory), random access memory (RAM), static random access memory (SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), programmable read-only memory (PROM), magnetic memory, magnetic disk, optical disk, etc. In some embodiments, the memory 51 may be an internal storage unit of the computer device 5, such as the hard disk or memory of the computer device 5. In other embodiments, the memory 51 may also be an external storage device of the computer device 5, such as a plug-in hard disk, smart media card (SMC), secure digital (SD) card, flash card, etc., equipped on the computer device 5. Of course, the memory 51 may include both the internal storage unit and its external storage device of the computer device 5. In this embodiment, the memory 51 is typically used to store the operating system and various application software installed on the computer device 5, such as the program code of method X. In addition, the memory 51 can also be used to temporarily store various types of data that have been output or will be output.

[0109] In some embodiments, the processor 52 may be a central processing unit (CPU), controller, microcontroller, microprocessor, or other data processing chip. The processor 52 is typically used to control the overall operation of the computer device 5. In this embodiment, the processor 52 is used to run program code stored in the memory 51 or process data, for example, to run the program code for the X method.

[0110] The network interface 53 may include a wireless network interface or a wired network interface, which is typically used to establish communication connections between the computer device 5 and other electronic devices.

[0111] This application also provides another embodiment, namely, providing a computer-readable storage medium storing the dynamic financial statement generation method program, which can be executed by at least one processor to cause the at least one processor to perform the steps of the dynamic financial statement generation method as described above.

[0112] Through the above description of the embodiments, those skilled in the art can clearly understand that the methods of the above embodiments can be implemented by means of software plus necessary general-purpose hardware online platforms. Of course, they can also be implemented by hardware, but in many cases the former is a better implementation method. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk), and includes several instructions to cause a terminal device (which may be a mobile phone, computer, server, air conditioner, or network device, etc.) to execute the methods described in the various embodiments of this application.

[0113] This application can be used in a wide variety of general-purpose or special-purpose computer system environments or configurations. Examples include: personal computers, server computers, handheld or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set-top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, and distributed computing environments including any of the above systems or devices. This application can be described in the general context of computer-executable instructions executed by a computer, such as program modules. Generally, program modules include routines, programs, objects, components, data structures, etc., that perform specific tasks or implement specific abstract data types. This application can also be practiced in distributed computing environments where tasks are performed by remote processing devices connected via a communication network. In distributed computing environments, program modules can reside in local and remote computer storage media, including storage devices.

[0114] Obviously, the embodiments described above are only some embodiments of this application, not all embodiments. The accompanying drawings show preferred embodiments of this application, but do not limit the patent scope of this application. This application can be implemented in many different forms; rather, the purpose of providing these embodiments is to provide a more thorough and comprehensive understanding of the disclosure of this application. Although this application has been described in detail with reference to the foregoing embodiments, those skilled in the art can still modify the technical solutions described in the foregoing specific embodiments, or make equivalent substitutions for some of the technical features. Any equivalent structures made using the content of this application's specification and drawings, directly or indirectly applied to other related technical fields, are similarly within the scope of patent protection of this application.

Claims

1. A method for dynamically generating financial statements, the method comprising: The method is applied to a dynamic financial statement generation system, the dynamic financial statement generation system comprises a table data configuration node and a target statement node, and the method comprises the following steps: obtaining source data to be processed and an output target value set of the target statement node; extracting a table configuration data set output by the table data configuration node; performing data processing on the source data to be processed by using the table configuration data set to obtain an intermediate statement set; and screening an intermediate statement in the intermediate statement set that meets the output target value set as the output of the target statement node; Before the step of extracting the table configuration data set output by the table data configuration node, the method comprises the following steps: obtaining a model table set; identifying table header data of each model table in the model table set to obtain table header fields; identifying each column of each model table based on a preset identification rule to obtain corresponding column identification; and establishing a mapping relationship between the column identification and the table header fields to obtain a column coding dictionary; After the step of establishing a mapping relationship between the column identification and the table header fields to obtain a column coding dictionary, the method comprises the following steps: identifying a hierarchical relationship corresponding to each cell in each model table to obtain corresponding basic hierarchical data; performing data coding on the cells of each column in each model table by using the coding dictionary to obtain corresponding basic column code data; embedding the hierarchical data corresponding to each cell into the basic column code data to obtain a basic identification of each cell; and summarizing the basic identification of each cell in each model table to obtain the table configuration data set corresponding to each model table.

2. The financial statement dynamic generation method of claim 1, wherein, The dynamic financial statement generation system further comprises a conversion node, and the method of performing data processing on the source data by using the table configuration data set to obtain an intermediate statement set comprises the following steps: responding to a conversion request received by the conversion node, the conversion request comprising the source data to be processed; performing data coding on the source data to be processed according to the table configuration data set to obtain a corresponding intermediate configuration set; obtaining a field data set corresponding to the source data to be processed; mapping the field data set to a target position of the model table set by using the intermediate configuration set to obtain an intermediate statement set.

3. The method of dynamically generating financial statements of claim 1, wherein, The method of screening an intermediate statement in the intermediate statement set that meets the output target value set as the output of the target statement node comprises the following steps: responding to a statement generation instruction received by the target statement node, the statement generation instruction comprising the output target value set; performing target condition screening on the intermediate statement by using the output target value set; outputting a target statement corresponding to the target condition.

4. The method of dynamically generating financial statements of claim 1, wherein, The method further comprises the following steps: obtaining update data and / or expansion data of the source data to be processed; updating the table configuration data set according to the update data and / or expansion data.

5. A system for dynamically generating financial statements, applying the method for dynamically generating financial statements as claimed in claim 1, characterized in that, The dynamic financial statement generation system comprises a table data configuration node and a target statement node, and the system comprises the following steps: a data acquisition module: configured to obtain source data to be processed and an output target value set of the target statement node; a configuration extraction module: configured to extract a table configuration data set output by the table data configuration node; An intermediate conversion module is configured to perform data processing on the source data to be processed by using the table configuration dataset, so as to obtain an intermediate report set; A condition filtering module is configured to filter the intermediate report in the intermediate report set which meets the output target value set as the output of the target report node.

6. The dynamically generated financial statement system of claim 5, wherein, The configuration extraction module further comprises: An acquisition subunit is configured to acquire a model table set; An identification subunit is configured to identify the table header data of each model table in the model table set, so as to obtain a table header field; An identification subunit is configured to identify each column of each model table based on a preset identification rule, so as to obtain a corresponding column identification; A mapping subunit is configured to establish a mapping relationship between the column identification and the table header field, so as to obtain a column encoding dictionary.

7. The dynamically generated financial statement system of claim 5, wherein, The dynamic financial report generation system further comprises: A hierarchical subunit is configured to identify the hierarchical relationship corresponding to each cell in each model table, so as to obtain corresponding basic hierarchical data; A basic encoding subunit is configured to perform data encoding on the cell of each column in each model table by using the encoding dictionary, so as to obtain corresponding basic column code data; A data embedding subunit is configured to embed the hierarchical data corresponding to each cell into the basic column code data, so as to obtain a basic identification of each cell; A collection subunit is configured to collect the basic identification of each cell in each model table, so as to obtain the table configuration dataset corresponding to each model table.

8. A storage medium, characterized by The storage medium has stored thereon a data processing program, and the data processing program, when executed by the processor, implements the steps of the dynamic financial report generation method according to any one of claims 1 to 4.

Images