CN114549151A - Enterprise financial auditing method and system - Google Patents
Enterprise financial auditing method and system Download PDFInfo
- Publication number
- CN114549151A CN114549151A CN202111546261.XA CN202111546261A CN114549151A CN 114549151 A CN114549151 A CN 114549151A CN 202111546261 A CN202111546261 A CN 202111546261A CN 114549151 A CN114549151 A CN 114549151A
- Authority
- CN
- China
- Prior art keywords
- audit
- expense
- data
- assets
- asset
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 51
- 238000012550 audit Methods 0.000 claims abstract description 115
- 238000012795 verification Methods 0.000 claims abstract description 41
- 238000004364 calculation method Methods 0.000 claims description 15
- 230000009467 reduction Effects 0.000 claims description 11
- 238000004590 computer program Methods 0.000 claims description 9
- 238000013524 data verification Methods 0.000 claims description 5
- 238000004422 calculation algorithm Methods 0.000 claims description 3
- 230000006870 function Effects 0.000 description 8
- 238000010586 diagram Methods 0.000 description 7
- 238000012545 processing Methods 0.000 description 5
- 239000000463 material Substances 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 230000008901 benefit Effects 0.000 description 3
- 238000005065 mining Methods 0.000 description 3
- 238000012216 screening Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000007792 addition Methods 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 238000000354 decomposition reaction Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000014509 gene expression Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000006798 recombination Effects 0.000 description 1
- 238000005215 recombination Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The embodiment of the invention discloses a method and a system for enterprise financial audit, wherein the method comprises the following steps: acquiring financial data uploaded by a user; the financial data are verified based on a preset verification rule, and after the financial data are verified, the financial data are converted into data which are supported and stored by a database and are stored in the database; based on a preset expense auditing rule, carrying out expense auditing on the financial data, and after the expense auditing is passed, carrying out auditing and summarizing in a preset expense approval table according to auditing codes to generate an expense approval table; performing asset audit on the financial data based on a preset asset audit rule, and summarizing all assets in a preset asset approval table after the asset audit is passed to generate an asset approval table; generating a candidate approval list based on the expense approval list and the asset approval list; and performing policy examination on the candidate approval list, and generating a final approval list after the policy examination is passed.
Description
Technical Field
The present invention relates to the field of data processing technology, and more particularly, to a method and system for enterprise financial accounting.
Background
The financial problem is the life line of the enterprise economic development, the internal financial auditing work of the enterprise is effectively implemented, the internal control can be enhanced, certain constraint force is generated on subordinate companies, and the improvement of the overall economic benefit of the enterprise is facilitated. Because of the complexity of financial information of enterprises, most enterprises do not have a sound financial information system at present, the enterprises can only export financial data information in the form of electronic files, and auditors need to spend a large amount of time to manually check and check in the face of various financial statements of each unit in the enterprises, so that the pressure of the auditors is increased, and the auditing efficiency and the auditing accuracy are low.
Aiming at the technical problems of low efficiency and low accuracy of enterprise financial audit in the prior art, an effective solution is not provided at present.
Disclosure of Invention
The invention provides the method and the device for auditing the financial affairs of the enterprise, aiming at solving the technical problems of low efficiency and low accuracy of financial auditing of the enterprise. The embodiment of the invention provides a method and a system for enterprise financial audit.
According to an aspect of an embodiment of the present invention, there is provided a method for enterprise financial auditing, the method including:
acquiring financial data uploaded by a user;
the financial data are verified based on a preset verification rule, and after the financial data are verified, the financial data are converted into data which are supported and stored by a database and are stored in the database;
performing expense audit on the financial data based on a preset expense audit rule, and performing audit reduction and summarization in a preset expense approval table according to an audit code after the expense audit is passed to generate an expense approval table;
performing asset audit on the financial data based on a preset asset audit rule, and summarizing all assets in a preset asset approval table after the asset audit is passed to generate an asset approval table;
generating a candidate approval list based on the expense approval list and the asset approval list;
and performing policy examination on the candidate approval tables, and generating a final approval table after the policy examination is passed.
Optionally, the verifying the financial data based on a preset verification rule includes:
performing header verification on the financial data, wherein the financial data is table data in an excel format;
performing data specification verification on the financial data;
and carrying out field rule verification on the financial data.
Optionally, the method further comprises: and sending the failed prompt information to the user terminal when the verification fails, wherein the prompt information is used for prompting the user to upload the financial data again.
Optionally, based on a preset expense audit rule, expense audit is performed on the financial data, and after the expense audit is passed, deduction and summarization are performed in a preset expense approval table according to an audit code to generate an expense approval table, including:
according to the detail data in the financial data comprising the keywords, matching enterprises and audit codes, and establishing an irrelevant expense table;
manually examining detail data corresponding to the specific audit code, and writing the non-compliant detail data into an irrelevant expense table;
partially removing the detail data of the specific audit codes in proportion in a mode of calculating the proportion of parameter configuration, and writing the detail data into an irrelevant expense table;
and manually auditing the data in the irrelevant expense list, and performing audit reduction and summarization in a preset expense approval list according to the audit code after the audit is passed to generate the expense approval list.
Optionally, based on a preset asset audit rule, performing asset audit on the financial data, and after the asset audit is passed, summarizing the assets in a preset asset approval table to generate an asset approval table, where the method includes:
classifying the assets of the financial data, classifying the assets into two categories of important assets and general assets, and classifying the important assets into right-of-use assets and leased assets again;
setting a blind correlation coefficient for each type of assets, presetting a depreciation amortization calculation method according to actual business, and auditing by removing irrelevant assets and depreciation amortization calculation;
and after the assets are approved, summarizing all the assets in a preset asset approval table to generate an asset approval table.
According to another aspect of an embodiment of the present invention, there is provided a system for enterprise financial auditing, the system comprising:
the data uploading module is used for acquiring financial data uploaded by a user;
the data verification module is used for verifying the financial data based on a preset verification rule, converting the financial data into data which is supported and stored by a database after the financial data passes the verification and storing the data in the database;
the expense auditing module is used for auditing the expense of the financial data based on a preset expense auditing rule, and performing auditing and summarizing according to auditing codes in a preset expense approval table after the expense auditing is passed to generate an expense approval table;
the asset auditing module is used for auditing the assets of the financial data based on a preset asset auditing rule, summarizing the assets in a preset asset approval table after the assets are approved, and generating an asset approval table;
the candidate approval table generating module is used for generating a candidate approval table based on the expense approval table and the asset approval table;
and the final approval table generating module is used for performing policy audit on the candidate approval tables and generating the final approval table after the policy audit is passed.
Optionally, the data checking module is specifically configured to:
performing header verification on the financial data, wherein the financial data is table data in an excel format;
performing data specification verification on the financial data;
and carrying out field rule verification on the financial data.
Optionally, the system further comprises: and the prompting module is used for sending the failed prompting information to the user terminal when the verification is failed, wherein the prompting information is used for prompting the user to upload the financial data again.
Optionally, the fee auditing module is specifically configured to:
according to the detail data in the financial data comprising the keywords, matching enterprises and audit codes, and establishing an irrelevant expense table;
manually examining detail data corresponding to the specific audit code, and writing the non-compliant detail data into an irrelevant expense table;
partially removing the detail data of the specific audit codes in proportion in a mode of calculating the proportion of parameter configuration, and writing the detail data into an irrelevant expense table;
and manually auditing the data in the irrelevant expense list, and performing audit reduction and summarization in a preset expense approval list according to the audit code after the audit is passed to generate the expense approval list.
Optionally, the asset auditing module is specifically configured to:
classifying the financial data into two categories, namely important assets and general assets, and classifying the important assets into the assets with the right of use and the assets to be rented;
setting a non-communicated correlation coefficient for each type of assets, presetting a depreciation amortization calculation method according to actual business, and auditing by removing irrelevant assets and depreciation amortization calculation;
and after the assets are approved, summarizing all the assets in a preset asset approval table to generate an asset approval table.
According to still another aspect of an embodiment of the present invention, there is provided an electronic apparatus including: a processor; for storing the processor-executable instructions; the processor is configured to read the executable instructions from the memory and execute the instructions to implement the method according to any of the above embodiments of the present invention.
According to yet another aspect of embodiments of the present invention, there is provided a computer-readable storage medium storing a computer program for executing the method according to any one of the above-mentioned embodiments of the present invention.
Therefore, the enterprise financial auditing method provided by the invention can automatically perform part of conventional auditing and data summarizing calculation, reduce the working pressure for internal auditors and improve the working efficiency. The uploaded excel data can be converted into a database storage form, a multi-dimensional screening function is provided, in the auditing process, convenience conditions are provided for auditing detailed data by auditors in the auditing process accurately, the system has an automatic summarizing function, summarized data of an approval table can be updated in real time, and the accuracy of auditing results is guaranteed. The invention automatically realizes the data verification and check among financial statements by utilizing the characteristics of quick, efficient and accurate program calculation. Most of manual audit work inside an enterprise is converted into automatic statistical calculation, the current situation that manual audit tasks inside the enterprise are heavy is changed, the burden of a basic enterprise is reduced, and the financial audit efficiency and the accuracy of financial audit results are improved. The invention provides an automatic auditing mode in the aspects of expense auditing and asset auditing, and the auditing data can be traced back to the financial data of a specific financial statement, thereby ensuring the accuracy of financial auditing.
The technical solution of the present invention is further described in detail by the accompanying drawings and embodiments.
Drawings
The above and other objects, features and advantages of the present invention will become more apparent from the following detailed description of the embodiments of the present invention when taken in conjunction with the accompanying drawings. The accompanying drawings are included to provide a further understanding of the embodiments of the invention, and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the principles of the invention and not to limit the invention. In the drawings, like reference numbers generally represent like parts or steps.
FIG. 1 is a schematic flow chart diagram of a method for enterprise financial auditing provided by an exemplary embodiment of the present invention;
FIG. 2 is a flowchart illustrating an overall method of enterprise financial auditing provided by an exemplary embodiment of the present invention;
FIG. 3 is a block diagram of a system for enterprise financial auditing provided by an exemplary embodiment of the present invention;
fig. 4 is a structure of an electronic device according to an exemplary embodiment of the present invention.
Detailed Description
Hereinafter, example embodiments according to the present invention will be described in detail with reference to the accompanying drawings. It is to be understood that the described embodiments are merely some embodiments of the invention and not all embodiments of the invention, with the understanding that the invention is not limited to the example embodiments described herein.
It should be noted that: the relative arrangement of parts and steps, numerical expressions, and numerical values set forth in these embodiments do not limit the scope of the present invention unless specifically stated otherwise.
It will be understood by those of skill in the art that the terms "first," "second," and the like in the embodiments of the present invention are used merely to distinguish one element, step, device, module, or the like from another element, and do not denote any particular technical or logical order therebetween.
It should also be understood that in embodiments of the present invention, "a plurality" may refer to two or more, and "at least one" may refer to one, two or more.
It is also to be understood that any reference to any component, data, or structure in the embodiments of the invention may be generally understood as one or more, unless explicitly defined otherwise or stated otherwise.
In addition, the term "and/or" in the present invention is only one kind of association relationship describing the associated object, and means that there may be three kinds of relationships, for example, a and/or B, which may mean: a exists alone, A and B exist simultaneously, and B exists alone. In addition, the character "/" in the present invention generally indicates a relationship in which a front and rear related objects are one kind of or.
It should also be understood that the description of the embodiments of the present invention emphasizes the differences between the embodiments, and the same or similar parts may be referred to each other, so that the description is omitted for brevity.
Meanwhile, it should be understood that the sizes of the respective portions shown in the drawings are not drawn in an actual proportional relationship for the convenience of description.
The following description of at least one exemplary embodiment is merely illustrative in nature and is in no way intended to limit the invention, its application, or uses.
Techniques, methods, and apparatus known to those of ordinary skill in the relevant art may not be discussed in detail, but are intended to be part of the specification where appropriate.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be discussed further in subsequent figures.
Embodiments of the invention are operational with numerous other general purpose or special purpose computing system environments or configurations. Examples of well known terminal devices, computing systems, environments, and/or configurations that may be suitable for use with electronic devices, such as terminal devices, computer systems, servers, and the like, include, but are not limited to: personal computer systems, server computer systems, thin clients, thick clients, hand-held or laptop devices, microprocessor-based systems, set top boxes, programmable consumer electronics, network pcs, minicomputers, mainframe computer systems, distributed cloud computing environments that include any of the above systems, and the like.
Electronic devices such as terminal devices, computer systems, servers, etc. may be described in the general context of computer system-executable instructions, such as program modules, being executed by a computer system. Generally, program modules may include routines, programs, objects, components, logic, data structures, etc. that perform particular tasks or implement particular abstract data types. The computer system/server may be practiced in distributed cloud computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed cloud computing environment, program modules may be located in both local and remote computer system storage media including memory storage devices.
Exemplary method
FIG. 1 is a flow diagram illustrating a method 100 for enterprise financial auditing provided by an exemplary embodiment of the present invention. The embodiment can be applied to an electronic device, as shown in fig. 1, and includes the following steps:
102, verifying the financial data based on a preset verification rule, converting the financial data into data which is supported and stored by a database after the financial data passes the verification, and storing the data in the database;
optionally, the verifying the financial data based on a preset verification rule includes: performing header verification on the financial data, wherein the financial data is table data in an excel format; performing data specification verification on the financial data; and carrying out field rule verification on the financial data.
Optionally, the method further comprises: and sending the failed prompt information to the user terminal when the verification fails, wherein the prompt information is used for prompting the user to upload the financial data again.
In the embodiment of the invention, the system provides a material uploading function, and supports the functions of uploading excel header verification, data specification verification and field rule verification in order to ensure the regularity of audit materials in an enterprise. And if the material verification is not passed, prompting to upload again, and if the material verification is passed, automatically converting the financial data in the excel into data which can support the storage of the database by the system and storing the data in the database.
103, performing expense audit on the financial data based on a preset expense audit rule, and performing audit reduction and summarization in a preset expense approval table according to an audit code after the expense audit is passed to generate an expense approval table;
optionally, based on a preset expense audit rule, expense audit is performed on the financial data, and after the expense audit is passed, deduction and summarization are performed in a preset expense approval table according to an audit code to generate an expense approval table, including: matching enterprises and audit codes according to detailed data in the financial data comprising keywords, and establishing an irrelevant expense table; manually examining detail data corresponding to the specific audit code, and writing the non-compliant detail data into an irrelevant expense table; partially removing the detail data of the specific audit codes in proportion in a mode of calculating the proportion by parameter configuration, and writing the detail data into an irrelevant expense table; and manually auditing the data in the irrelevant expense table, and after the audit is passed, carrying out audit reduction and summarization in a preset expense approval table according to the audit code to generate the expense approval table.
In the embodiment of the invention, the expense audit aims to eliminate the data which do not need to be included in the financial audit, and the method comprises the following steps:
1) matching enterprises and auditing codes according to the detailed data of the financial statement containing the keywords to establish an irrelevant expense table;
2) manually examining detail data corresponding to the specific audit code, and writing the non-compliant data into an irrelevant expense table;
3) partially removing the detail data of the specific audit codes in proportion in a mode of calculating the proportion by parameter configuration, and writing the detail data into an irrelevant expense table;
4) and manually auditing the data in the irrelevant expense table, and after the audit is passed, carrying out reduction and summarization in the expense approval table according to the audit code to generate the final expense approval code.
104, performing asset audit on the financial data based on a preset asset audit rule, summarizing all assets in a preset asset approval table after the asset audit is passed, and generating an asset approval table;
optionally, based on a preset asset audit rule, performing asset audit on the financial data, and after the asset audit is passed, summarizing the assets in a preset asset approval table to generate an asset approval table, where the method includes: classifying the assets of the financial data, classifying the assets into two categories of important assets and general assets, and classifying the important assets into right-of-use assets and leased assets again; setting a blind correlation coefficient for each type of assets, presetting depreciation amortization algorithm according to actual business, and auditing by removing irrelevant assets and depreciation amortization calculation; and after the assets are approved, summarizing all the assets in a preset asset approval table to generate an asset approval table.
In the embodiment of the invention, the purpose of asset auditing is to calculate the depreciation cost of pricing after screening and removing irrelevant, illegal and unreasonable asset data. The method comprises the following specific steps:
1) the assets are classified, the system classifies the assets into two categories of important assets and general assets, and the important assets are divided into a series of assets such as use right assets and rent assets again;
2) setting a blind correlation coefficient for each type of assets, presetting a depreciation amortization calculation method according to actual business, and auditing by removing irrelevant assets and depreciation amortization calculation;
3) and summarizing all the assets to generate an asset approval table.
105, generating a candidate approval list based on the expense approval list and the asset approval list;
and 106, performing policy examination on the candidate approval list, and generating a final approval list after the policy examination is passed.
In the embodiment of the present invention, as shown in fig. 2, the fee approval table and the asset approval table are summarized to generate a temporary final approval table, and the system performs policy approval on the temporary final approval table, and generates the final approval table according to the requirements of the national relevant regulations.
Therefore, through the technical scheme provided by the invention, part of conventional auditing and data summarizing calculation can be automatically performed, the working pressure of internal auditors is reduced, and the working efficiency is improved. The uploaded excel data can be converted into a database storage form, a multi-dimensional screening function is provided, in the auditing process, convenient conditions are provided for auditors to audit detailed data accurately in the auditing process, the system has an automatic summarizing function, summarized data of the audit list can be updated in real time, and the accuracy of the auditing result is guaranteed. The invention automatically realizes the data verification and check among financial statements by utilizing the characteristics of quick, efficient and accurate program calculation. Most of manual audit work inside an enterprise is converted into automatic statistical calculation, the current situation that manual audit tasks inside the enterprise are heavy is changed, the burden of basic enterprises is reduced, and the financial audit efficiency and the accuracy of financial audit results are improved. The invention provides an automatic auditing mode in the aspects of expense auditing and asset auditing, and the auditing data can be traced back to the financial data of a specific financial statement, so that the accuracy of financial auditing is ensured.
Exemplary System
FIG. 3 is a block diagram of a system for enterprise financial auditing provided by an exemplary embodiment of the present invention. As shown in fig. 3, the system 300 for enterprise financial auditing according to the present embodiment includes:
the data uploading module 310 is used for acquiring financial data uploaded by a user;
the data checking module 320 is used for checking the financial data based on a preset checking rule, converting the financial data into data which is supported and stored by a database after the financial data passes the checking, and storing the data in the database;
the expense auditing module 330 is configured to perform expense auditing on the financial data based on a preset expense auditing rule, perform audit reduction and summarization in a preset expense approval table according to an audit code after the expense auditing is passed, and generate an expense approval table;
the asset auditing module 340 is configured to perform asset auditing on the financial data based on preset asset auditing rules, and aggregate the assets in a preset asset approval table after the asset auditing is passed, so as to generate an asset approval table;
a candidate approval table generation module 350, configured to generate a candidate approval table based on the cost approval table and the asset approval table;
and a final approval table generating module 360, configured to perform policy audit on the candidate approval table, and generate a final approval table after the policy audit is passed.
Optionally, the data checking module 320 is specifically configured to:
performing header verification on the financial data, wherein the financial data is table data in an excel format;
performing data specification verification on the financial data;
and carrying out field rule verification on the financial data.
Optionally, the system further comprises: and the prompting module is used for sending the failed prompting information to the user terminal when the verification is failed, wherein the prompting information is used for prompting the user to upload the financial data again.
Optionally, the fee auditing module 330 is specifically configured to:
according to the detail data in the financial data comprising the keywords, matching enterprises and audit codes, and establishing an irrelevant expense table;
manually examining detail data corresponding to the specific audit code, and writing the non-compliant detail data into an irrelevant expense table;
partially removing the detail data of the specific audit codes in proportion in a mode of calculating the proportion by parameter configuration, and writing the detail data into an irrelevant expense table;
and manually auditing the data in the irrelevant expense list, and performing audit reduction and summarization in a preset expense approval list according to the audit code after the audit is passed to generate the expense approval list.
Optionally, the asset auditing module 340 is specifically configured to:
classifying the assets of the financial data, classifying the assets into two categories of important assets and general assets, and classifying the important assets into right-of-use assets and leased assets again;
setting a blind correlation coefficient for each type of assets, presetting a depreciation amortization calculation method according to actual business, and auditing by removing irrelevant assets and depreciation amortization calculation;
and after the assets are approved, summarizing all the assets in a preset asset approval table to generate an asset approval table.
The system 300 for enterprise financial auditing according to an embodiment of the present invention corresponds to the method 100 for enterprise financial auditing according to another embodiment of the present invention, and will not be described herein again.
Exemplary electronic device
Fig. 4 is a structure of an electronic device according to an exemplary embodiment of the present invention. The electronic device may be either or both of the first device and the second device, or a stand-alone device separate from them that may communicate with the first device and the second device to receive the acquired input signals therefrom. FIG. 4 illustrates a block diagram of an electronic device in accordance with an embodiment of the disclosure. As shown in fig. 4, electronic device 40 includes one or more processors 41 and memory 42.
The processor 41 may be a Central Processing Unit (CPU) or other form of processing unit having data processing capabilities and/or instruction execution capabilities, and may control other components in the electronic device to perform desired functions.
The input device 43 may also include, for example, a keyboard, a mouse, and the like.
The output device 44 can output various information to the outside. The output devices 44 may include, for example, a display, speakers, a printer, and a communication network and remote output devices connected thereto, among others.
Of course, for simplicity, only some of the components of the electronic device relevant to the present disclosure are shown in fig. 4, omitting components such as buses, input/output interfaces, and the like. In addition, the electronic device may include any other suitable components, depending on the particular application.
Exemplary computer program product and computer-readable storage Medium
In addition to the above-described methods and apparatus, embodiments of the present disclosure may also be a computer program product comprising computer program instructions that, when executed by a processor, cause the processor to perform the steps in the method of information mining of historical change records according to various embodiments of the present disclosure described in the "exemplary methods" section above of this specification.
The computer program product may write program code for performing the operations of embodiments of the present disclosure in any combination of one or more programming languages, including an object oriented programming language such as Java, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device and partly on a remote computing device, or entirely on the remote computing device or server.
Furthermore, embodiments of the present disclosure may also be a computer-readable storage medium having stored thereon computer program instructions that, when executed by a processor, cause the processor to perform the steps in the method of information mining of historical change records according to various embodiments of the present disclosure described in the "exemplary methods" section above of this specification.
The computer-readable storage medium may take any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. A readable storage medium may include, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium include: an electrical connection having one or more wires, a portable disk, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
The foregoing describes the general principles of the present disclosure in conjunction with specific embodiments, however, it is noted that the advantages, effects, etc. mentioned in the present disclosure are merely examples and are not limiting, and they should not be considered essential to the various embodiments of the present disclosure. Furthermore, the foregoing disclosure of specific details is for the purpose of illustration and description and is not intended to be limiting, since the disclosure is not necessarily limited to the specific details set forth.
In the present specification, the embodiments are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same or similar parts in the embodiments are referred to each other. The system embodiment basically corresponds to the method embodiment, so the description is relatively simple, and the relevant points can be referred to the partial description of the method embodiment.
The block diagrams of devices, apparatuses, systems referred to in this disclosure are only given as illustrative examples and are not intended to require or imply that the connections, arrangements, configurations, etc. must be made in the manner shown in the block diagrams. The devices, apparatuses, devices, systems may be connected, arranged, configured in any manner, as will be appreciated by those skilled in the art. Words such as "including," "comprising," "having," and the like are open-ended words that mean "including, but not limited to," and are used interchangeably therewith. As used herein, the words "or" and "refer to the word" and/or "and are used interchangeably herein unless the context clearly dictates otherwise. The word "such as" is used herein to mean, and is used interchangeably with, the phrase "such as but not limited to".
The methods and apparatus of the present disclosure may be implemented in a number of ways. For example, the methods and apparatus of the present disclosure may be implemented by software, hardware, firmware, or any combination of software, hardware, and firmware. The above-described order for the steps of the method is for illustration only, and the steps of the method of the present disclosure are not limited to the order specifically described above unless specifically stated otherwise. Further, in some embodiments, the present disclosure may also be embodied as a program recorded in a recording medium, the program including machine-readable instructions for implementing a method according to the present disclosure. Thus, the present disclosure also covers a recording medium storing a program for executing the method according to the present disclosure.
It is also noted that in the systems, apparatus and methods of the present disclosure, various components or steps may be decomposed and/or re-combined. These decompositions and/or recombinations are to be considered equivalents of the present disclosure. The previous description of the disclosed aspects is provided to enable any person skilled in the art to make or use the present disclosure. Various modifications to these aspects will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other aspects without departing from the scope of the disclosure. Thus, the present disclosure is not intended to be limited to the aspects shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
The foregoing description has been presented for purposes of illustration and description. Furthermore, this description is not intended to limit embodiments of the disclosure to the form disclosed herein. While a number of exemplary aspects and embodiments have been discussed above, those of skill in the art will recognize certain variations, modifications, alterations, additions and sub-combinations thereof.
Claims (12)
1. A method of enterprise financial auditing, comprising:
acquiring financial data uploaded by a user;
the financial data are verified based on a preset verification rule, and after the financial data are verified, the financial data are converted into data which are supported and stored by a database and are stored in the database;
performing expense audit on the financial data based on a preset expense audit rule, and performing audit reduction and summarization in a preset expense approval table according to an audit code after the expense audit is passed to generate an expense approval table;
performing asset audit on the financial data based on a preset asset audit rule, and summarizing the assets in a preset asset approval table after the asset audit is passed to generate an asset approval table;
generating a candidate approval list based on the expense approval list and the asset approval list;
and performing policy examination on the candidate approval list, and generating a final approval list after the policy examination is passed.
2. The method of claim 1, wherein verifying the financial data based on a predetermined verification rule comprises:
performing header verification on the financial data, wherein the financial data is table data in an excel format;
performing data specification verification on the financial data;
and carrying out field rule verification on the financial data.
3. The method of claim 1, further comprising: and sending the failed prompt information to the user terminal when the verification fails, wherein the prompt information is used for prompting the user to upload the financial data again.
4. The method of claim 1, wherein performing a fee audit on the financial data based on a predetermined fee audit rule, and performing a deduction and a summarization in accordance with an audit code in a predetermined fee approval table after the fee audit is passed, to generate a fee approval table, comprising:
matching enterprises and audit codes according to detail data in the financial data comprising the keywords, and establishing an irrelevant expense table;
manually examining detail data corresponding to the specific audit code, and writing the non-compliant detail data into an irrelevant expense table;
partially removing the detail data of the specific audit codes in proportion in a mode of calculating the proportion of parameter configuration, and writing the detail data into an irrelevant expense table;
and manually auditing the data in the irrelevant expense table, and after the auditing is passed, performing audit and summarization in a preset expense approval table according to audit codes to generate an expense approval table.
5. The method of claim 1, wherein performing an asset audit on the financial data based on a preset asset audit rule, and after the asset audit is passed, summarizing the assets in a preset asset approval table to generate an asset approval table, comprises:
classifying the assets of the financial data, classifying the assets into two categories of important assets and general assets, and classifying the important assets into right-of-use assets and leased assets again;
setting a blind correlation coefficient for each type of assets, presetting a depreciation amortization algorithm according to actual business, and auditing by removing irrelevant assets and performing depreciation amortization calculation;
and after the assets are approved, summarizing all the assets in a preset asset approval table to generate an asset approval table.
6. A system for financial auditing of an enterprise, comprising:
the data uploading module is used for acquiring financial data uploaded by a user;
the data verification module is used for verifying the financial data based on a preset verification rule, converting the financial data into data which is supported and stored by a database after the financial data passes the verification and storing the data in the database;
the expense auditing module is used for auditing the expense of the financial data based on a preset expense auditing rule, and performing audit reduction and summarization in a preset expense approval table according to an audit code after the expense audit is passed to generate an expense approval table;
the asset auditing module is used for auditing the assets of the financial data based on a preset asset auditing rule, summarizing the assets in a preset asset approval table after the assets are approved, and generating an asset approval table;
the candidate approval table generating module is used for generating a candidate approval table based on the expense approval table and the asset approval table;
and the final approval table generating module is used for performing policy audit on the candidate approval tables and generating the final approval table after the policy audit is passed.
7. The system of claim 6, wherein the data verification module is specifically configured to:
performing header verification on the financial data, wherein the financial data is table data in an excel format;
performing data specification verification on the financial data;
and carrying out field rule verification on the financial data.
8. The system of claim 6, further comprising: and the prompt module is used for sending the failed prompt information to the user terminal when the verification fails, wherein the prompt information is used for prompting the user to upload the financial data again.
9. The system of claim 6, wherein the fee auditing module is specifically configured to:
according to the detail data in the financial data comprising the keywords, matching enterprises and audit codes, and establishing an irrelevant expense table;
manually examining detail data corresponding to the specific audit code, and writing the non-compliant detail data into an irrelevant expense table;
partially removing the detail data of the specific audit codes in proportion in a mode of calculating the proportion of parameter configuration, and writing the detail data into an irrelevant expense table;
and manually auditing the data in the irrelevant expense table, and after the audit is passed, carrying out audit reduction and summarization in a preset expense approval table according to the audit code to generate the expense approval table.
10. The system of claim 6, wherein the asset audit module is specifically configured to:
classifying the assets of the financial data, classifying the assets into two categories of important assets and general assets, and classifying the important assets into right-of-use assets and leased assets again;
setting a blind correlation coefficient for each type of assets, presetting a depreciation amortization algorithm according to actual business, and auditing by removing irrelevant assets and performing depreciation amortization calculation;
and after the assets are approved, summarizing all the assets in a preset asset approval table to generate an asset approval table.
11. An electronic device, characterized in that the electronic device comprises: a processor and a memory; wherein,
the memory to store the processor-executable instructions;
the processor is configured to read the executable instructions from the memory and execute the instructions to implement the method of any one of claims 1-5.
12. A computer-readable storage medium, characterized in that it stores a computer program for performing the method of any of the preceding claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111546261.XA CN114549151A (en) | 2021-12-16 | 2021-12-16 | Enterprise financial auditing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111546261.XA CN114549151A (en) | 2021-12-16 | 2021-12-16 | Enterprise financial auditing method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114549151A true CN114549151A (en) | 2022-05-27 |
Family
ID=81670112
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111546261.XA Pending CN114549151A (en) | 2021-12-16 | 2021-12-16 | Enterprise financial auditing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114549151A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115242349A (en) * | 2022-06-21 | 2022-10-25 | 苏州盈数智能科技有限公司 | Enterprise-level data verification method and device, computer equipment and storage medium |
-
2021
- 2021-12-16 CN CN202111546261.XA patent/CN114549151A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115242349A (en) * | 2022-06-21 | 2022-10-25 | 苏州盈数智能科技有限公司 | Enterprise-level data verification method and device, computer equipment and storage medium |
| CN115242349B (en) * | 2022-06-21 | 2023-11-14 | 苏州盈数智能科技有限公司 | Enterprise-level data verification method, enterprise-level data verification device, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3308297B1 (en) | Data quality analysis | |
| US20120116984A1 (en) | Automated evaluation of compliance data from heterogeneous it systems | |
| US20140279384A1 (en) | Monitoring financial risks using a quantity ledger | |
| US9292579B2 (en) | Method and system for document data extraction template management | |
| US20080208780A1 (en) | System and method for evaluating documents | |
| CN111144697A (en) | Data processing method, data processing device, storage medium and electronic equipment | |
| US20140149470A1 (en) | Systems and methods for storing and populating forms | |
| CN111667225A (en) | Financial data processing method and device and computer system | |
| CN115409590A (en) | Unified account checking method, device, equipment and storage medium | |
| CN114187082A (en) | Financial accounting and reimbursement method and system | |
| CN114549151A (en) | Enterprise financial auditing method and system | |
| CN110704273B (en) | Processing method and device of configuration information, electronic equipment and storage medium | |
| CN110991992B (en) | Processing method and device of business process information, storage medium and electronic equipment | |
| CN112288402A (en) | Data processing method, device, equipment and storage medium | |
| US10235719B2 (en) | Centralized GAAP approach for multidimensional accounting to reduce data volume and data reconciliation processing costs | |
| CN114782117A (en) | Electronic accounting entry voucher generation method and system based on invoice | |
| CN114445164A (en) | Invoice data processing method and device, storage medium and electronic equipment | |
| US7236909B1 (en) | Autonomic data assurance applied to complex data-intensive software processes by means of pattern recognition | |
| CN113609407B (en) | Regional consistency verification method and device | |
| CN113901125B (en) | Data display method and device, storage medium and electronic equipment | |
| US20060195393A1 (en) | Creation of recurring transactions | |
| CN117057938A (en) | Bank bad asset management method and device, electronic equipment and storage medium | |
| CN115658727A (en) | Method and device for realizing bidirectional analysis of SQL (structured query language) statement and configuration information | |
| JP7441188B2 (en) | Business support devices, business support methods, and business support programs | |
| US20230252008A1 (en) | Systems and methods for data verification |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |