Financial data processing method and device, electronic equipment and storage medium

Abstract

The invention discloses a financial data processing method and device, electronic equipment and a storage medium, and relates to the technical field of data processing. The method comprises the following steps: creating N financial statement templates; wherein each of the N financial statement templates is configured with at least one field and a field attribute of the at least one field, and N is an integer greater than 1; in response to a user operation of importing multiple pieces of financial data into a target financial statement template, generating a target financial statement, and verifying multiple pieces of target financial data in the target financial statement; wherein the target financial statement template is selected from the N financial statement templates; and if it is verified that the field attributes to which the multiple pieces of target financial data belong accord with the field attributes configured in the target financial statement template, storing the target financial statement to a database.

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a financial data processing method, device, electronic device and storage medium. Background Art

[0002] With the advent of the Internet age, it has become a trend for companies to use computer equipment to process financial data.

[0003] Currently, when processing financial data, different Excel tables need to be manually created for different financial data each time, and then the different Excel tables need to be associated, and then reviewed, sorted, and other operations need to be performed on them.

[0004] However, in the actual operation process, if an Excel sheet is forgotten to be opened or its position is changed, it will cause formula errors and the corresponding values ​​cannot be obtained. At this time, manual inspection is required to check the reasons, which reduces the efficiency of financial data processing. Summary of the invention

[0005] The present application provides a financial data processing method, device, electronic device and storage medium to improve the processing efficiency of financial data.

[0006] In a first aspect, a financial data processing method is provided, comprising:

[0007] Creating N financial report templates; wherein each of the N financial report templates is configured with at least one field and a field attribute of the at least one field, and N is an integer greater than 1;

[0008] In response to a user operation of importing a plurality of financial data into a target financial report template, a target financial report is generated, and the plurality of target financial data in the target financial report is verified; wherein the target financial report template is selected from the N financial report templates;

[0009] If it is verified that the field attributes of each of the plurality of target financial data are consistent with the field attributes configured in the target financial report template, the target financial report is stored in the database.

[0010] In the embodiment of the present application, since N financial report templates are created, each of the N financial report templates is configured with at least one field and field attributes of the at least one field, a target financial report is generated in response to a user operation of importing multiple financial data into a target financial report template. Therefore, based on user needs, a flexible selection can be made among the N created financial report templates, and there is no need to manually create different Excel tables for different financial data each time, thereby satisfying user experience. Furthermore, multiple target financial data in the target financial report are verified. If it is verified that the field attributes of each of the multiple target financial data are consistent with the field attributes configured in the target financial report template, the target financial report is stored in a database. Therefore, the accuracy of the financial data in the target financial report can be guaranteed, and there is no need for users to perform manual verification by themselves, thereby improving the processing efficiency of financial data.

[0011] In some embodiments of the present application, the method further includes:

[0012] If it is verified that the field attributes of the plurality of target financial data are inconsistent with the field attributes configured in the target financial report template, a prompt box is popped up, and the target financial report is sent to the target object;

[0013] The prompt box includes the reason why the target financial report fails to be stored in the database.

[0014] Through the above embodiment, for the target financial report that fails the verification, a prompt box can be used to remind the target object to process the target financial report in time, thereby satisfying the user experience.

[0015] In some embodiments of the present application, storing the target financial statement in a database includes:

[0016] According to the identifier of the target financial report, a query is performed in the database; wherein the identifier is generated based on a field configured in the target financial report template;

[0017] If a historical financial report with the same identifier as the identifier is queried in the database, the historical financial data identical to the multiple target financial data will be deleted from the historical financial report, and the multiple target financial data in the target financial report will be processed according to the primary key set in the target financial report template, and the processed target financial report will be stored in the database.

[0018] Through the above-mentioned embodiment, when storing in a database, the historical financial statements stored in the database and the target financial statements to be stored can be cleaned up in real time, thereby reducing the storage pressure of the database.

[0019] In some embodiments of the present application, generating a target financial statement includes:

[0020] Converting the plurality of financial data into a financial data matrix, and processing the financial data matrix based on at least one function formula in a function library;

[0021] The target financial statement is generated according to the processed financial data matrix.

[0022] In some embodiments of the present application, the N financial report templates are provided with M permission management objects having modification permissions on the N financial report templates, where M is an integer greater than 0.

[0023] Through the above embodiment, the authority management objects are allocated to the created N financial report templates, so as to facilitate the unified management of the N financial report templates.

[0024] In a second aspect, a financial data processing device is provided, comprising:

[0025] A creation module, used to create N financial report templates; wherein each of the N financial report templates is configured with at least one field and a field attribute of the at least one field, and N is an integer greater than 1;

[0026] A processing module, for generating a target financial report in response to a user operation of importing multiple financial data into a target financial report template, and verifying multiple target financial data in the target financial report; wherein the target financial report template is selected from the N financial report templates; and for storing the target financial report in a database if it is verified that the field attributes of each of the multiple target financial data are consistent with the field attributes configured in the target financial report template.

[0027] In some embodiments of the present application, the processing module is further used to:

[0028] If it is verified that the field attributes of the plurality of target financial data are inconsistent with the field attributes configured in the target financial report template, a prompt box is popped up, and the target financial report is sent to the target object;

[0029] The prompt box includes the reason why the target financial report fails to be stored in the database.

[0030] In some embodiments of the present application, the processing module is specifically used to:

[0031] According to the identifier of the target financial report, a query is performed in the database; wherein the identifier is generated based on a field configured in the target financial report template;

[0032] If a historical financial report with the same identifier as the identifier is queried in the database, the historical financial data identical to the multiple target financial data will be deleted from the historical financial report, and the multiple target financial data in the target financial report will be processed according to the primary key set in the target financial report template, and the processed target financial report will be stored in the database.

[0033] According to a third aspect, an electronic device is provided, including:

[0034] A memory for storing a computer program; a processor for implementing any one of the method steps in the first aspect when executing the computer program stored in the memory.

[0035] According to a fourth aspect, a computer-readable storage medium is provided, wherein a computer program is stored in the computer-readable storage medium, and when the computer program is executed by a processor, the method steps described in any one of the first aspects are implemented.

[0036] For each aspect from the second to the fourth aspect and the technical effects that may be achieved by each aspect, please refer to the above description of the technical effects that can be achieved by the first aspect or various possible schemes in the first aspect, and no further details will be given here. BRIEF DESCRIPTION OF THE DRAWINGS

[0037] Figure 1 A schematic diagram of an application scenario applicable to the embodiments of the present application;

[0038] Figure 2 A flowchart of a financial data processing method provided in an embodiment of the present application;

[0039] Figure 3 A schematic diagram of an interface of a prompt box provided in an embodiment of the present application;

[0040] Figure 4 A schematic diagram of the structure of a financial data processing device provided in an embodiment of the present application;

[0041] Figure 5 A schematic diagram of the structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0042] In order to make the purpose, technical solutions and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings. The specific operating methods in the method embodiments can also be applied to device embodiments or system embodiments. It should be noted that in the description of the present application, "multiple" is understood as "at least two". "And / or" describes the association relationship of associated objects, indicating that three relationships may exist. For example, A and / or B can represent: A exists alone, A and B exist at the same time, and B exists alone. A is connected to B, which can represent: A is directly connected to B and A is connected to B through C. In addition, in the description of the present application, words such as "first" and "second" are only used to distinguish the purpose of description, and cannot be understood as indicating or implying relative importance, nor can they be understood as indicating or implying order.

[0043] In order to better understand the embodiments of the present application, the technical terms involved in the embodiments of the present application are first explained below.

[0044] (1) The primary key is used to uniquely identify each row of data in a table and can be composed of one or more fields in the table.

[0045] (2) Field attributes represent the data type of the field (for example, integer, string, date), field name, length, etc.

[0046] (3) NumPy (Numerical Python) is an open source numerical computing extension of Python. It provides many advanced numerical programming tools, such as matrix data types, vector processing, and precise calculation libraries.

[0047] (4) Pandas is a data analysis package for Python. It is a tool based on NumPy that was created to solve data analysis tasks. Pandas incorporates a large number of libraries and some standard data models, providing the tools needed to efficiently operate large data sets. Pandas provides a large number of functions and methods that enable us to process data quickly and conveniently.

[0048] The following is a brief introduction to the application scenarios to which the technical solutions of the embodiments of the present application can be applied. It should be noted that the application scenarios introduced below are only used to illustrate the embodiments of the present application and are not limited. In specific implementation, the technical solutions provided by the embodiments of the present application can be flexibly applied according to actual needs.

[0049] Figure 1Schematic diagram of an application scenario applicable to the embodiment of the present application. As shown in the figure, the application scenario mainly includes: a terminal 10 and a server 11. Among them, information exchange can be performed between the terminal 10 and the server 11 through a communication network, and the communication mode adopted by the communication network may include: a wireless communication mode and a wired communication mode.

[0050] In some scenarios, the terminal 10 can access the network and communicate with the server 11 through cellular mobile communication technology, and the cellular mobile communication technology may include the fifth generation mobile communication (5th Generation Mobile Networks, 5G) technology.

[0051] In some scenarios, the terminal 10 may access the network and communicate with the server 11 via short-range wireless communication. The short-range wireless communication may include Wireless Fidelity (Wi-Fi) technology.

[0052] The present application embodiment does not impose any restriction on the number of the above-mentioned devices. Figure 1 As shown, only the terminal 10 and the server 11 are described as examples, and the above-mentioned devices and their respective functions are briefly introduced below.

[0053] The terminal 10 is a device that can provide voice and / or data connectivity to the user, including: a handheld terminal device with a wireless connection function, a vehicle-mounted terminal device, etc.

[0054] In some scenarios, the terminal 10 includes but is not limited to: mobile phones, tablet computers, laptop computers, PDAs, mobile Internet devices (MID), wearable devices, virtual reality (VR) devices, augmented reality (AR) devices, wireless terminal devices in industrial control, wireless terminal devices in unmanned driving, wireless terminal devices in smart grids, wireless terminal devices in transportation safety, wireless terminal devices in smart cities, or wireless terminal devices in smart homes, etc.

[0055] In addition, a client related to account data processing may be installed on the terminal 10, and the client may be software (for example, an APP, a browser, etc.), or a web page, a small program, etc. In the embodiment of the present application, the terminal 10 may use the client related to account data processing, and may interact with the server 11 for information related to the account data business scenario.

[0056] In some embodiments, server 11 can be an independent physical server, or a server cluster or distributed system composed of multiple physical servers. It can also be a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, content delivery networks (CDN), as well as big data and artificial intelligence platforms.

[0057] Furthermore, the server 11 may be equipped with an accounting data processing device corresponding to the client, which is used to process various accounting data, specifically: create N financial report templates, each of which is configured with at least one field and field attributes of the at least one field; in response to a user operation of importing multiple financial data into a target financial report template, generate a target financial report, and verify multiple target financial data in the target financial report. If it is verified that the field attributes of each of the multiple target financial data are consistent with the field attributes configured in the target financial report template, the target financial report is stored in the database; if it is verified that the field attributes of each of the multiple target financial data are inconsistent with the field attributes configured in the target financial report template, a prompt box is popped up (such as a prompt box popped up in the user interface of the terminal 10), and the target financial report is sent to the target object (user) for corresponding modification.

[0058] To further illustrate the technical solution provided by the embodiment of the present application, this is described in detail below in conjunction with the accompanying drawings and specific implementation methods. Although the embodiment of the present application provides the method operation steps as shown in the following embodiments or drawings, more or fewer operation steps may be included in the method based on routine or no creative labor. In the steps where there is no necessary causal relationship logically, the execution order of these steps is not limited to the execution order provided by the embodiment of the present application. The method may be executed or executed in parallel in the actual processing process or when the device is executed in accordance with the method sequence shown in the embodiment or drawings.

[0059] Figure 2 The flowchart of a financial data processing method provided in an embodiment of the present application. The flowchart can be executed by a financial data processing device, which can be implemented by software and / or hardware. Figure 1 As shown, the process includes the following steps:

[0060] 201: Create N financial report templates.

[0061] The N (N is an integer greater than 1) financial report templates are each configured with at least one field and field attributes of the at least one field.

[0062] In some embodiments, M (M is an integer greater than 0) permission management objects may be set for N financial report templates, and the M permission management objects have modification permissions for the N financial report templates, thereby facilitating unified management of the created N financial report templates and satisfying user experience. For example, in the configuration of the financial report template, you can add or reduce the fields configured in the financial report template, you can also independently define the field attributes of the respective fields in the reduced financial report template, and you can also set the respective primary key in each financial report template.

[0063] In other implementations, a financial report template may be created for financial data generated under the same business, a financial table template may be created for financial data of the same type generated under the same business, and a financial report template may be created for financial data generated under the same department. Applicable financial data report templates may be created based on actual user needs, and the embodiments of the present application are not limited here.

[0064] 202: In response to a user operation of importing a plurality of financial data into a target financial report template, a target financial report is generated, and the plurality of target financial data in the target financial report is verified.

[0065] The target financial report template is selected from the N financial report templates created above. Specifically, in response to selecting a function button of the target financial report template in a user interface displaying the N financial report templates, the multiple financial data can be imported into the target financial report template to generate a target financial report.

[0066] In some embodiments, generating a target financial statement may include: converting the multiple financial data into a financial data matrix, and processing the financial data matrix based on at least one function formula in a function library; and generating a target financial statement based on the processed financial data matrix. For example, the multiple financial data may be converted into a financial data matrix based on pandas (e.g., ), and then process the financial data matrix based on at least one function formula in a function library (such as the Numpy toolkit) (for example, combining, segmenting, cleaning, screening, etc. of multiple financial data in the financial data matrix), and finally generate a target financial statement based on the processed financial data matrix.

[0067] In other embodiments, when the amount of financial data included in the financial data matrix is ​​too large, the target financial report may include multiple tab pages (sheet pages). In this case, the splicing between different sheet pages can be achieved through the loop function (numpy.append) in the Numpy toolkit.

[0068] 203: If it is verified that the field attributes of the plurality of target financial data are consistent with the field attributes configured in the target financial report template, the target financial report is stored in the database.

[0069] In some embodiments, the target financial statement is stored in a database, which can be specifically: querying the database according to the identifier of the target financial statement, the identifier is generated based on the fields configured in the target financial statement template; if a historical financial statement with the same identifier is queried in the database, it means that the same type of historical financial statement already exists in the database, and the historical financial data identical to the multiple target financial data can be deleted in the historical financial report, thereby cleaning up the historical financial reports stored in the database in real time, reducing the storage pressure of the database; further, according to the primary key set in the target financial report template, the multiple target financial data in the target financial report are processed, and the processed target financial report is stored in the database.

[0070] Furthermore, the primary key can be constructed by specifying one or more fields in the fields configured in the target financial report template. Then, the set primary key can be combined with the groupby, sum, loop functions, etc. in the numpy toolkit to summarize, concatenate, and eliminate invalid data for multiple target financial data in the target financial report, thereby cleaning up the target financial report to be stored, reducing the storage pressure of the database, and ensuring the accuracy of the target financial report.

[0071] In some embodiments, if it is verified that the field attributes of each of the plurality of target financial data are inconsistent with the field attributes configured in the target financial report template, a prompt box is popped up and the target financial report is sent to the target object.

[0072] For example, assuming that the target financial report template is configured with a field attribute of numeric type, and target financial data of string type appears in the numeric type column, or the target financial report template is configured with a field attribute of time type, and non-time type financial data appears in the time type column, it indicates that part of the target financial data does not comply, a prompt box may be popped up, and the target financial report will be returned to the target object.

[0073] In some embodiments, the prompt box may include the reason for the failure to store the target financial report into the database. For example, some financial data in the target financial report is of string type and does not conform to the field attributes configured in the selected target financial report template, thereby reminding the target object to process the target financial table in a timely manner and satisfying the user experience.

[0074] In other embodiments, the prompt box may also include the table name of the target financial report and the specific part of the financial data that does not conform, thereby improving the efficiency of troubleshooting erroneous data.

[0075] In other embodiments, the prompt box may be a floating window displayed at the top level of the user interface, such as Figure 3 As shown, the prompt box 300 includes the table name of the target financial report (XX Table 1), the reason for the failure to store the database (some financial data is of string type and does not conform to the field attributes configured in the selected target financial report template), and the non-conforming data are a1, a2, and a5.

[0076] It should be noted that the type of the above database is not specifically limited and can be reasonably configured according to user needs. The above prompt box is just an example and the content and style of the prompt box are not specifically limited.

[0077] In the embodiment of the present application, since N financial report templates are created, each of the N financial report templates is configured with at least one field and field attributes of the at least one field, a target financial report is generated in response to a user operation of importing multiple financial data into a target financial report template. Therefore, based on user needs, a flexible selection can be made among the N created financial report templates, and there is no need to manually create different Excel tables for different financial data each time, thereby satisfying user experience. Furthermore, multiple target financial data in the target financial report are verified. If it is verified that the field attributes of each of the multiple target financial data are consistent with the field attributes configured in the target financial report template, the target financial report is stored in a database. Therefore, the accuracy of the financial data in the target financial report can be guaranteed, and there is no need for users to perform manual verification by themselves, thereby improving the processing efficiency of financial data.

[0078] Based on the same technical concept, a financial data processing device is also provided in an embodiment of the present application, and the device can implement the above-mentioned financial data processing method flow in the embodiment of the present application.

[0079] Figure 4 The structure diagram of a financial data processing device provided in an embodiment of the present application includes: a creation module 401 and a processing module 402.

[0080] The creation module 401 is used to create N financial report templates; wherein each of the N financial report templates is configured with at least one field and field attributes of the at least one field, and N is an integer greater than 1.

[0081] Processing module 402 is used to generate a target financial report in response to a user operation of importing multiple financial data into a target financial report template, and to verify multiple target financial data in the target financial report; wherein the target financial report template is selected from the N financial report templates; and if it is verified that the field attributes of each of the multiple target financial data are consistent with the field attributes configured in the target financial report template, then the target financial report is stored in a database.

[0082] In some embodiments, the processing module 402 is further configured to:

[0083] If it is verified that the field attributes of each of the multiple target financial data are inconsistent with the field attributes configured in the target financial report template, a prompt box will pop up and the target financial report will be sent to the target object; wherein the prompt box includes the reason for the failure of storing the target financial report in the database.

[0084] In some embodiments, the processing module 402 is specifically configured to:

[0085] According to the identifier of the target financial report, a query is performed in the database; wherein the identifier is generated based on a field configured in the target financial report template;

[0086] If a historical financial report identical to the identifier is queried in the database, the historical financial data identical to the multiple target financial data will be deleted from the historical financial report, and the multiple target financial data in the target financial report will be processed according to the primary key set in the target financial report template, and the processed target financial report will be stored in the database.

[0087] In some embodiments, the processing module 402 is specifically configured to:

[0088] The multiple financial data are converted into a financial data matrix, and the financial data matrix is ​​processed based on at least one function formula in a function library; and the target financial statement is generated according to the processed financial data matrix.

[0089] It should be noted here that the above-mentioned device provided in the embodiment of the present application can implement all the method steps in the above-mentioned method embodiment and can achieve the same technical effect. The parts and beneficial effects of this embodiment that are the same as the method embodiment will not be described in detail here.

[0090] Based on the same technical concept, an electronic device is also provided in an embodiment of the present application, and the electronic device can realize the functions of the aforementioned financial data processing device.

[0091] Figure 5 A schematic diagram of the structure of an electronic device provided in an embodiment of the present application.

[0092] At least one processor 501, and a memory 502 connected to the at least one processor 501. The specific connection medium between the processor 501 and the memory 502 is not limited in the embodiment of the present application. Figure 5 In the example, the processor 501 and the memory 502 are connected via a bus 500. The bus 500 is Figure 5 The connections between other components are shown in bold lines, and are not intended to be limiting. The bus 500 can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Figure 5 Only one thick line is used in the figure, but it does not mean that there is only one bus or one type of bus. Alternatively, the processor 501 can also be called a controller, and there is no limitation on the name.

[0093] In the embodiment of the present application, the memory 502 stores instructions that can be executed by at least one processor 501. The at least one processor 501 can execute a financial data processing method discussed above by executing the instructions stored in the memory 502. The processor 501 can implement Figure 4 The functions of each module in the device shown.

[0094] Among them, the processor 501 is the control center of the device, and can use various interfaces and lines to connect the various parts of the entire control device. By running or executing instructions stored in the memory 502 and calling data stored in the memory 502, the various functions of the device and processing data, the device can be monitored as a whole.

[0095] In one possible design, the processor 501 may include one or more processing units, and the processor 501 may integrate an application processor and a modem processor, wherein the application processor mainly processes an operating system, a user interface, and application programs, and the modem processor mainly processes wireless communications. It is understandable that the modem processor may not be integrated into the processor 501. In some embodiments, the processor 501 and the memory 502 may be implemented on the same chip, and in some embodiments, they may also be implemented separately on separate chips.

[0096] Processor 501 can be a general-purpose processor, such as a central processing unit (CPU), a digital signal processor, an application-specific integrated circuit, a field programmable gate array or other programmable logic device, a discrete gate or transistor logic device, a discrete hardware component, and can implement or execute the various methods, steps and logic block diagrams disclosed in the embodiments of the present application. A general-purpose processor can be a microprocessor or any conventional processor, etc. The steps of a financial data processing method disclosed in the embodiments of the present application can be directly embodied as a hardware processor to be executed, or a combination of hardware and software modules in the processor can be executed.

[0097] The memory 502 is a non-volatile computer-readable storage medium that can be used to store non-volatile software programs, non-volatile computer executable programs and modules. The memory 502 may include at least one type of storage medium, such as a flash memory, a hard disk, a multimedia card, a card-type memory, a random access memory (Random Access Memory, RAM), a static random access memory (Static Random Access Memory, SRAM), a programmable read-only memory (Programmable Read Only Memory, PROM), a read-only memory (Read Only Memory, ROM), an electrically erasable programmable read-only memory (Electrically Erasable Programmable Read-Only Memory, EEPROM), a magnetic memory, a disk, an optical disk, etc. The memory 502 is any other medium that can be used to carry or store a desired program code in the form of an instruction or data structure and can be accessed by a computer, but is not limited thereto. The memory 502 in the embodiment of the present application can also be a circuit or any other device that can realize a storage function, for storing program instructions and / or data.

[0098] By programming the processor 501, the code corresponding to the financial data processing method described in the above embodiment can be fixed into the chip, so that the chip can execute the code when running. Figure 2 The embodiment shown is a method for processing financial data. How to design and program the processor 501 is a technique known to those skilled in the art and will not be described in detail here.

[0099] It should be noted here that the above-mentioned electronic device provided in the embodiment of the present application can implement all the method steps implemented in the above-mentioned method embodiment, and can achieve the same technical effect. The parts and beneficial effects of this embodiment that are the same as the method embodiment will not be described in detail here.

[0100] An embodiment of the present application further provides a computer-readable storage medium, which stores computer-executable instructions, and the computer-executable instructions are used to enable a computer to execute a financial data processing method in the above embodiment.

[0101] An embodiment of the present application also provides a computer program product, which, when called by a computer, enables the computer to execute a financial data processing method in the above embodiment.

[0102] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.

[0103] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0104] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0105] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process in the computer or other programmable device. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

Claims

1. A financial data processing method, characterized in that: include: Creating N financial report templates; wherein each of the N financial report templates is configured with at least one field and a field attribute of the at least one field, and N is an integer greater than 1; In response to a user operation of importing a plurality of financial data into a target financial report template, a target financial report is generated, and the plurality of target financial data in the target financial report is verified; wherein the target financial report template is selected from the N financial report templates; If it is verified that the field attributes of each of the plurality of target financial data are consistent with the field attributes configured in the target financial report template, the target financial report is stored in the database.

2. The method according to claim 1, characterized in that The method further comprises: If it is verified that the field attributes of the plurality of target financial data are inconsistent with the field attributes configured in the target financial report template, a prompt box is popped up, and the target financial report is sent to the target object; The prompt box includes the reason why the target financial report fails to be stored in the database.

3. The method according to claim 1, characterized in that The storing the target financial statement into a database comprises: According to the identifier of the target financial report, a query is performed in the database; wherein the identifier is generated based on a field configured in the target financial report template; If a historical financial report with the same identifier as the identifier is queried in the database, the historical financial data identical to the multiple target financial data will be deleted from the historical financial report, and the multiple target financial data in the target financial report will be processed according to the primary key set in the target financial report template, and the processed target financial report will be stored in the database.

4. The method according to claim 1, characterized in that The generating of the target financial statements includes: Converting the plurality of financial data into a financial data matrix, and processing the financial data matrix based on at least one function formula in a function library; The target financial statement is generated according to the processed financial data matrix.

5. The method according to any one of claims 1 to 4, characterized in that: The N financial report templates are provided with M authority management objects having modification authority on the N financial report templates, where M is an integer greater than 0.

6. A financial data processing device, characterized in that: include: A creation module, used to create N financial report templates; wherein each of the N financial report templates is configured with at least one field and a field attribute of the at least one field, and N is an integer greater than 1; A processing module, for generating a target financial report in response to a user operation of importing multiple financial data into a target financial report template, and verifying multiple target financial data in the target financial report; wherein the target financial report template is selected from the N financial report templates; and for storing the target financial report in a database if it is verified that the field attributes of each of the multiple target financial data are consistent with the field attributes configured in the target financial report template.

7. The device according to claim 6, characterized in that The processing module is further used for: If it is verified that the field attributes of the plurality of target financial data are inconsistent with the field attributes configured in the target financial report template, a prompt box is popped up, and the target financial report is sent to the target object; The prompt box includes the reason why the target financial report fails to be stored in the database.

8. The device according to claim 6, characterized in that The processing module is specifically used for: According to the identifier of the target financial report, a query is performed in the database; wherein the identifier is generated based on a field configured in the target financial report template; If a historical financial report with the same identifier as the identifier is queried in the database, the historical financial data identical to the multiple target financial data will be deleted from the historical financial report, and the multiple target financial data in the target financial report will be processed according to the primary key set in the target financial report template, and the processed target financial report will be stored in the database.

9. An electronic device, characterized in that: include: Memory, used to store computer programs; A processor, configured to implement the method steps of any one of claims 1 to 5 when executing the computer program stored in the memory.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method steps of any one of claims 1 to 5 are implemented.

Images