A financial data verification system and method

Abstract

The present application relates to the field of financial auditing technology, and in particular to a financial data verification system and method. The system includes: a financial data collection module for receiving financial data files uploaded by each subsidiary of an enterprise group; a financial data verification module for verifying the name, content and format of the financial data files uploaded by each subsidiary; a financial data comparison and analysis module for performing a comprehensive comparison on the financial data of each verified financial file to obtain a comparison result, and analyzing the accuracy of the financial data files uploaded by each subsidiary based on the comparison result.

Description

Technical Field

[0001] The present application relates to the technical field of financial auditing, and in particular to a financial data verification system and method. Background Art

[0002] At present, there are still many loopholes and problems in the financial management of enterprise groups in my country that need to be solved urgently. The lack of effective financial monitoring measures is one of the problems currently faced by enterprise groups. The financial monitoring of most enterprise groups in my country focuses on post-event monitoring, and the pre-event and in-event control measures are not perfect. Pre-event control lacks a budget, and in-event control is a formality, only using the annual profit plan as a basis for monitoring, and not concretizing the plan. This phenomenon still exists in some enterprise groups. For their own interests, the accountants of some subordinate institutions do not use accounting laws and regulations as a basis when conducting accounting processing, but only act according to the intentions of the leaders of the enterprise, which leads to chaos in the group's financial management and distortion of accounting information.

[0003] Only by strengthening financial supervision can we timely discover problems in the daily operation of enterprises, remind and urge enterprises to make corrections. To strengthen financial monitoring, enterprise groups should set up independent internal audit committees within the group to conduct financial audits of subsidiaries regularly or irregularly, so as to timely discover and correct problems in the financial activities of subsidiaries, enhance their internal control awareness, and reduce the probability of financial risks.

[0004] As the group was unable to quickly establish a sound financial information system, the audited units could only export financial data information in the form of electronic files as data materials for supervision by the internal audit committee. Auditors were faced with multiple financial statements from various units within the group, and needed to spend a lot of time manually checking and verifying them, which led to increasing pressure on auditors and low work efficiency. Summary of the invention

[0005] The present application provides a financial data verification system and method to solve the problem of low efficiency of financial data auditing within a group existing in the prior art.

[0006] In a first aspect, the present application provides a financial data verification system, the system comprising:

[0007] The financial data collection module is used to receive financial data files uploaded by each subsidiary of the enterprise group;

[0008] A financial data verification module, used to verify the name, content and format of the financial data files uploaded by each subsidiary company;

[0009] The financial data comparison and analysis module is used to perform comprehensive comparison processing on the financial data of each financial file that has passed the verification, obtain the comparison results, and analyze the accuracy of the financial data files uploaded by each subsidiary company based on the comparison results.

[0010] Optionally, the system further comprises:

[0011] The comparison and analysis result processing module is used to display the comparison and analysis results, receive the audit problem descriptions entered by the auditors, and return the financial data files that fail the verification analysis results to the corresponding subsidiary companies, so as to prompt the subsidiary companies to re-upload accurate financial data files.

[0012] Optionally, the financial data collection module is configured with a list of financial data files that each subsidiary company needs to upload;

[0013] The financial data collection module is also used to send the list of financial data files that each subsidiary company needs to upload to each subsidiary company.

[0014] Optionally, when receiving financial data files uploaded by each subsidiary of the enterprise group, the financial data collection module is specifically used to:

[0015] Receive the financial data files uploaded by each of the subordinate companies based on their corresponding financial data file list.

[0016] Optionally, when verifying the name, content and format of the financial data files uploaded by the subsidiaries, the financial data verification module is specifically used to:

[0017] Verify the Excel header of the financial data file in Excel format;

[0018] Verify whether the file content of each financial data file is empty, the file data format, and whether the file data value meets the preset requirements;

[0019] Check whether the file format of the specified type of financial data file conforms to the preset file format.

[0020] In a second aspect, the present application provides a financial data verification method, which is applied to a financial data verification system, and the method includes:

[0021] Receive financial data files uploaded by subsidiaries of the enterprise group;

[0022] Verify the name, content and format of the financial data files uploaded by each of the subsidiaries;

[0023] The financial data of each financial document that has passed the verification is comprehensively compared and processed to obtain the comparison results, and the accuracy of the financial data files uploaded by each subsidiary company is analyzed based on the comparison results.

[0024] Optionally, the method further comprises:

[0025] Receive the audit problem description entered by the auditor, and return the financial data files that fail the verification analysis to the corresponding subsidiary company, so as to prompt the subsidiary company to re-upload the accurate financial data files.

[0026] Optionally, the financial data verification system is configured with a list of financial data files that each subsidiary company needs to upload; the method further includes:

[0027] The list of financial data files that each subsidiary company needs to upload is sent to each subsidiary company respectively.

[0028] Optionally, the step of receiving the financial data files uploaded by the subsidiaries of the enterprise group includes:

[0029] Receive the financial data files uploaded by each of the subordinate companies based on their corresponding financial data file list.

[0030] Optionally, the step of verifying the name, content and format of the financial data files uploaded by each subsidiary company includes:

[0031] Verify the Excel header of the financial data file in Excel format;

[0032] Verify whether the file content of each financial data file is empty, the file data format, and whether the file data value meets the preset requirements;

[0033] Check whether the file format of the specified type of financial data file conforms to the preset file format.

[0034] In a third aspect, the present application provides a financial data verification device, the device comprising:

[0035] A memory for storing program instructions;

[0036] The processor is used to call the program instructions stored in the memory and execute the steps of the method as described in any one of the second aspects according to the obtained program instructions.

[0037] In a fourth aspect, an embodiment of the present application further provides a computer-readable storage medium, wherein the computer-readable storage medium stores computer-executable instructions, and the computer-executable instructions are used to enable the computer to execute the steps of the method described in any one of the second aspects above.

[0038] In summary, the financial data verification system provided in the embodiment of the present application comprises: a financial data collection module for receiving financial data files uploaded by each subsidiary company of an enterprise group; a financial data verification module for verifying the name, content and format of the financial data files uploaded by each subsidiary company; a financial data comparison and analysis module for performing a comprehensive comparison on the financial data of each financial file that has passed the verification, obtaining a comparison result, and analyzing the accuracy of the financial data files uploaded by each subsidiary company based on the comparison result.

[0039] By adopting the financial data verification system and method provided in the embodiment of the present application, the manual audit method within the enterprise group is transformed into an automated comparison system, which changes the current situation of heavy manual internal audit tasks, reduces the burden on grassroots enterprises, reduces human errors, enables the enterprise group to effectively control the finances of its subsidiaries, promptly discovers problems of subsidiaries, goes straight to the source, and reduces the probability of financial risks. BRIEF DESCRIPTION OF THE DRAWINGS

[0040] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments of the present application or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in this application. For ordinary technicians in this field, other drawings can also be obtained based on these drawings of the embodiments of the present application.

[0041] Figure 1 A schematic diagram of the structure of a financial data verification system provided in an embodiment of the present application;

[0042] Figure 2 A detailed flow chart of a financial data verification method provided in an embodiment of the present application;

[0043] Figure 3 A schematic diagram of the structure of a financial data verification device provided in an embodiment of the present application;

[0044] Figure 4 A schematic diagram of the structure of another financial data verification device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0045] The terms used in the embodiments of the present application are only for the purpose of describing specific embodiments, rather than limiting the present application. The singular forms of "a", "said" and "the" used in the present application and claims are also intended to include plural forms, unless the context clearly indicates other meanings. It should also be understood that the term "and / or" used herein refers to any or all possible combinations of one or more associated listed items.

[0046] It should be understood that, although the terms first, second, third, etc. may be used to describe various information in the embodiments of the present application, these information should not be limited to these terms. These terms are only used to distinguish the same type of information from each other. For example, without departing from the scope of the present application, the first information may also be referred to as the second information, and similarly, the second information may also be referred to as the first information. Depending on the context, in addition, the word "if" used may be interpreted as "at..." or "when..." or "in response to determination".

[0047] For example, see Figure 1 As shown, it is a structural schematic diagram of a financial data verification system provided in an embodiment of the present application, the system includes a financial data collection module, a financial data verification module and a financial data comparison and analysis module, wherein the financial data collection module is used to receive financial data files uploaded by each subsidiary of the enterprise group; the financial data verification module is used to verify the name, content and format of the financial data files uploaded by each subsidiary; the financial data comparison and analysis module is used to perform comprehensive comparison processing on the financial data of each financial file that has passed the verification, obtain comparison results, and analyze the accuracy of the financial data files uploaded by each subsidiary based on the comparison results.

[0048] In an embodiment of the present application, the financial data collection module is configured with a list of financial data files that each subsidiary company needs to upload, and the financial data collection module is also used to send the list of financial data files that each subsidiary company needs to upload to each subsidiary company respectively.

[0049] In actual applications, in order to ensure the integrity of the group's internal audit materials (financial data files), the system provides a list of audit materials that each subsidiary company needs to upload. For example, the list of financial data files that subsidiary company 1 needs to upload includes financial data file 1, financial data file 2, and financial data file 3; the list of financial data files that subsidiary company 2 needs to upload includes financial data file 1, financial data file 3, and financial data file 5.

[0050] As can be seen from the above, when receiving the financial data files uploaded by the subsidiaries of the enterprise group, the financial data collection module is specifically used to:

[0051] Receive the financial data files uploaded by each of the subordinate companies based on their corresponding financial data file list.

[0052] That is, each subsidiary company uploads its own financial data files to the system based on the list of financial data files to be uploaded issued by the system. The system receives the financial data files uploaded by each subsidiary company.

[0053] In the embodiment of the present application, when verifying the name, content and format of the financial data files uploaded by each subsidiary company, the financial data verification module is specifically used to:

[0054] Verify the Excel header of the financial data file in Excel format; verify whether the file content of each financial data file is empty, the file data format, and whether the file data value meets the preset requirements; verify whether the file format of the specified type of financial data file meets the preset file format.

[0055] Furthermore, in an embodiment of the present application, the financial data verification system also includes a comparison analysis result processing module, wherein the comparison analysis result processing module is used to display the comparison analysis results, receive the audit problem description input by the auditor, and return the financial data file whose analysis result is that it fails the verification to the corresponding subsidiary company, so as to prompt the subsidiary company to re-upload accurate financial data files.

[0056] In actual applications, the financial data verification module of the financial data verification system can realize the data verification function of the materials reported by each subsidiary of the enterprise group. For example, in order to ensure the compliance of the internal audit of the group, the system supports the Excel header verification and data specification verification functions; in order to ensure the authenticity, validity and authority of the report, some financial data files need to upload PDF format files. Therefore, the financial data verification module supports OCR text recognition of specific reports and verification of the original text data after recognition. If the file fails to pass the verification after uploading, the system supports the return operation. The auditor can feedback the returned file and the reason to the corresponding subsidiary company and ask the subsidiary company to re-upload it.

[0057] Among them, the comparison analysis result processing module includes a comparison result display unit and a problem processing unit.

[0058] The comparison result display unit, after the subordinate enterprises upload the financial data files, the system will calculate and compare the multiple financial statements reported by each subordinate company according to the built-in comparison rules, and output the comparison results and difference values. The comparison result display unit compares the reconciliation difference values ​​in each comparison rule respectively, and outputs the difference notes of each reconciliation difference value according to the comparison results. Furthermore, according to the comparison results, you can drill down to query the detailed data and query the data files reported by each unit.

[0059] In the problem handling unit, the system has set up problem description, file re-upload, and voucher upload entrances. If the auditor verifies that the problem data does not need to be re-uploaded, the problem description can be added to the current comparison rule result, and supplementary explanatory materials can be added if necessary; if the auditor finds that the comparison rules are inconsistent due to incorrect financial data files uploaded by the subsidiary after verification, the financial data file problem under the current rule can be returned and re-uploaded in the financial data collection module.

[0060] For example, see Figure 2 FIG. 1 is a detailed flow chart of a financial data verification method provided in an embodiment of the present application. The method is applied to a financial data verification system. The method includes the following steps:

[0061] Step 200: Receive financial data files uploaded by each subsidiary company of the enterprise group.

[0062] In the embodiment of the present application, the financial data verification system is configured with a list of financial data files that each subsidiary company needs to upload; the method further includes:

[0063] The list of financial data files that each subsidiary company needs to upload is sent to each subsidiary company respectively.

[0064] Then, in the embodiment of the present application, when receiving the financial data files uploaded by the subsidiaries of the enterprise group, a preferred implementation method is to receive the financial data files uploaded by the subsidiaries based on their corresponding financial data file list.

[0065] Step 210: Verify the name, content and format of the financial data files uploaded by each subsidiary company.

[0066] In an embodiment of the present application, when verifying the name, content and format of the financial data files uploaded by the subsidiaries, a preferred implementation method is to verify the Excel header of the financial data files in Excel format; verify whether the file content of each financial data file is empty, the file data format, and whether the file data value meets the preset requirements; and verify whether the file format of the financial data file of a specified type meets the preset file format.

[0067] Step 220: Perform a comprehensive comparison process on the financial data of each financial file that has passed the verification to obtain a comparison result, and analyze the accuracy of the financial data files uploaded by each subsidiary company based on the comparison result.

[0068] Furthermore, in the embodiment of the present application, the above financial data verification method further includes the following steps:

[0069] Receive the audit problem description entered by the auditor, and return the financial data files that fail the verification analysis to the corresponding subsidiary company, so as to prompt the subsidiary company to re-upload the accurate financial data files.

[0070] The financial data verification process provided by the embodiment of the present application is described in detail below in conjunction with specific application scenarios. For example, see Figure 3 FIG. 1 is a detailed flow chart of a financial data verification method provided in an embodiment of the present application, which specifically includes the following steps:

[0071] Materials submitted by the audited unit;

[0072] Verify the materials;

[0073] Comparison of asset data and expense data;

[0074] Verification of discrepancies;

[0075] The verification results will be fed back to the audited unit.

[0076] The above units may be one or more integrated circuits configured to implement the above methods, such as one or more application specific integrated circuits (ASIC), or one or more digital singnal processors (DSP), or one or more field programmable gate arrays (FPGA). For another example, when a certain unit above is implemented in the form of a processing element scheduling program code, the processing element may be a general-purpose processor, such as a central processing unit (CPU) or other processors that can call program codes. For another example, these units may be integrated together and implemented in the form of a system-on-a-chip (SOC).

[0077] Furthermore, the financial data verification device provided in the embodiment of the present application, from the hardware level, the hardware architecture diagram of the financial data verification device can be seen in Figure 4 As shown, the financial data verification device may include: a memory 40 and a processor 41,

[0078] The memory 40 is used to store program instructions; the processor 41 calls the program instructions stored in the memory 40 and executes the above method embodiment according to the obtained program instructions. The specific implementation method and technical effect are similar and will not be repeated here.

[0079] Optionally, the present application also provides a financial data verification device, comprising at least one processing element (or chip) for executing the above method embodiment.

[0080] Optionally, the present application also provides a program product, such as a computer-readable storage medium, which stores computer-executable instructions, and the computer-executable instructions are used to enable the computer to execute the above method embodiments.

[0081] Here, the machine-readable storage medium may be any electronic, magnetic, optical or other physical storage device that may contain or store information, such as executable instructions, data, etc. For example, the machine-readable storage medium may be: RAM (RadomAccess Memory), volatile memory, non-volatile memory, flash memory, storage drive (such as hard disk drive), solid state drive, any type of storage disk (such as CD, DVD, etc.), or similar storage medium, or a combination thereof.

[0082] The systems, devices, modules or units described in the above embodiments may be implemented by computer chips or entities, or by products with certain functions. A typical implementation device is a computer, which may be in the form of a personal computer, a laptop computer, a cellular phone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email transceiver, a game console, a tablet computer, a wearable device or a combination of any of these devices.

[0083] For the convenience of description, the above device is described in various units according to their functions. Of course, when implementing the present application, the functions of each unit can be implemented in the same or multiple software and / or hardware.

[0084] 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 embodiments of 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 contain computer-usable program code.

[0085] 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 embodiments of 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 generate 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.

[0086] Moreover, these computer program instructions can also be stored in a computer-readable memory that can guide a computer or other programmable data processing device to work in a specific manner, so that the instructions stored in the computer-readable memory produce a product including an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 The function specified in one or more boxes.

[0087] 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 executing on the computer or other programmable device to implement the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0088] The above description is only a preferred embodiment of the present application and is not intended to limit the present application. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present application shall be included in the scope of protection of the present application.

Claims

1. A financial data verification system, characterized in that: The system comprises: The financial data collection module is used to receive financial data files uploaded by each subsidiary of the enterprise group; A financial data verification module, used to verify the name, content and format of the financial data files uploaded by each subsidiary company; The financial data comparison and analysis module is used to perform a comprehensive comparison of the financial data of each financial file that has passed the verification, obtain the comparison results, and analyze the accuracy of the financial data files uploaded by each subsidiary company based on the comparison results; The checking and processing of the names, contents and formats of the financial data files uploaded by the subsidiaries includes: checking and processing the Excel headers of the financial data files in Excel format; Verify whether the file content of each financial data file is empty, the file data format, and whether the file data value meets the preset requirements; Verify whether the file format of the specified type of financial data file complies with the preset file format; Perform OCR text recognition on a specific report and verify it with the original text data after recognition, wherein the specific report includes a financial data file in PDF format.

2. The system according to claim 1, characterized in that The system further comprises: The comparison and analysis result processing module is used to display the comparison and analysis results, receive the audit problem descriptions entered by the auditors, and return the financial data files that fail the verification analysis results to the corresponding subsidiary companies, so as to prompt the subsidiary companies to re-upload accurate financial data files.

3. The system according to claim 1, characterized in that The financial data collection module is configured with a list of financial data files that each subsidiary company needs to upload; The financial data collection module is also used to send the list of financial data files that each subsidiary company needs to upload to each subsidiary company.

4. The system according to claim 3, characterized in that When receiving financial data files uploaded by subsidiaries of the enterprise group, the financial data collection module is specifically used to: Receive the financial data files uploaded by each of the subordinate companies based on their corresponding financial data file list.

5. A financial data verification method, characterized in that: Applied to a financial data verification system, the method comprises: Receive financial data files uploaded by subsidiaries of the enterprise group; Verify the name, content and format of the financial data files uploaded by each of the subsidiaries; Perform comprehensive comparison and processing on the financial data of each verified financial document to obtain the comparison results, and analyze the accuracy of the financial data files uploaded by each subsidiary company based on the comparison results; The checking and processing of the names, contents and formats of the financial data files uploaded by the subsidiaries includes: checking and processing the Excel headers of the financial data files in Excel format; Verify whether the file content of each financial data file is empty, the file data format, and whether the file data value meets the preset requirements; Verify whether the file format of the specified type of financial data file complies with the preset file format; Perform OCR text recognition on a specific report and verify it with the original text data after recognition, wherein the specific report includes a financial data file in PDF format.

6. The method according to claim 5, characterized in that The method further comprises: Receive the audit problem description entered by the auditor, and return the financial data files that fail the verification analysis to the corresponding subsidiary company, so as to prompt the subsidiary company to re-upload the accurate financial data files.

7. The method according to claim 5, characterized in that The financial data verification system is configured with a list of financial data files that each subsidiary company needs to upload; the method also includes: The list of financial data files that each subsidiary company needs to upload is sent to each subsidiary company respectively.

8. The method according to claim 7, characterized in that The steps for receiving financial data files uploaded by subsidiaries of the enterprise group include: Receive the financial data files uploaded by each of the subordinate companies based on their corresponding financial data file list.

Images