CN109582940B - Report data testing method and device, computer equipment and storage medium - Google Patents
Report data testing method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109582940B CN109582940B CN201811253435.1A CN201811253435A CN109582940B CN 109582940 B CN109582940 B CN 109582940B CN 201811253435 A CN201811253435 A CN 201811253435A CN 109582940 B CN109582940 B CN 109582940B
- Authority
- CN
- China
- Prior art keywords
- data
- report
- abnormal
- financial
- statement
- 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.)
- Active
Links
- 238000012360 testing method Methods 0.000 title claims abstract description 33
- 230000002159 abnormal effect Effects 0.000 claims description 73
- 238000012545 processing Methods 0.000 claims description 22
- 238000012795 verification Methods 0.000 claims description 6
- 238000004364 calculation method Methods 0.000 claims description 5
- 238000000034 method Methods 0.000 description 25
- 238000010586 diagram Methods 0.000 description 9
- 230000006854 communication Effects 0.000 description 6
- 238000004891 communication Methods 0.000 description 6
- 238000002360 preparation method Methods 0.000 description 5
- 230000006978 adaptation Effects 0.000 description 2
- 230000008901 benefit Effects 0.000 description 2
- 230000007175 bidirectional communication Effects 0.000 description 2
- 230000001413 cellular effect Effects 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000007774 longterm Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012546 transfer Methods 0.000 description 2
- 230000002547 anomalous effect Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 230000001186 cumulative effect Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 238000010998 test method Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Physics & Mathematics (AREA)
- General Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (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 report data testing method, a report data testing device, computer equipment and a storage medium, which comprise the following steps: acquiring billing data from a plurality of systems; filling the accounting data into a preset template to generate a financial statement; and comparing the generated financial statement with a target financial statement acquired in advance to confirm the correctness of the statement data in the target financial statement. Accounting data in each system is automatically acquired and filled into a preset template to generate a financial statement, and the financial statement is compared with a pre-acquired financial statement to test the correctness of the statement data, so that the operation condition of a financial statement forecast enterprise can be obtained at any time, and the system is convenient and efficient, thereby improving the working efficiency.
Description
Technical Field
The embodiment of the invention relates to the field of finance, in particular to a report data testing method, a report data testing device, computer equipment and a storage medium.
Background
Financial statements are accounting statements that reflect the status of funds, profit, and other financial factors of an enterprise or budget unit over a period of time. The types, formats and reporting requirements of the financial statement are all specified by a unified accounting system, and the enterprise is required to report regularly. Typically, financial statements include balance sheets, damage sheets, cash flow sheets or financial condition change sheets, balance sheets, and notes.
Generally, a financial report is generated by report data input into a system, but in practical application, a huge company generally comprises a plurality of systems responsible for different departments, for example, an A system is responsible for a liability statement of assets, a B system is responsible for a damage statement and the like, when the financial report is generated, the report data is generally respectively exported from different systems by manpower, then input into the same system for general report data input into the system by manpower, and then uploaded into the system, so that report data errors often occur. In addition, financial reports can be summarized only when the month is generally concluded, and the operation condition of an enterprise cannot be predicted in time in the method.
Disclosure of Invention
The embodiment of the invention provides a method for pushing an insurance product to a client according to simple operation of a user or a seller and highlighting a key point in the insurance product.
In order to solve the technical problems, the embodiment of the invention adopts the following technical scheme: the report data testing method comprises the following steps:
Acquiring billing data from a plurality of systems;
filling the accounting data into a preset template to generate a financial statement;
And comparing the generated financial statement with a target financial statement acquired in advance to confirm the correctness of the statement data in the target financial statement.
Further, the step of filling the accounting data into a preset template to generate a financial report, including:
classifying the accounting data acquired from each system according to the subject type to which the accounting data belongs;
calculating the classified billing data according to a preset first formula to obtain first report data;
and adding the first report data into a preset first template to obtain a first financial report.
Further, the step of filling the accounting data into a preset template to generate a financial report, including:
acquiring report data of each subsidiary from each system;
Calculating the report data of each subsidiary according to a preset second formula to obtain second report data;
and adding the second baby data into a preset second template to obtain a second financial statement.
Further, after comparing the generated financial report with a target financial report acquired in advance to confirm the correctness of the report data in the target financial report, the method includes:
when the comparison is inconsistent, acquiring abnormal data information of the inconsistent comparison from the financial statement;
acquiring an association search relation according to the abnormal data information;
And sending a search request to each system according to the parameters in the association search relation, so that each system returns a plurality of billing data associated with the abnormal data information for verification.
Further, the abnormal data information includes: an anomaly value; the obtaining the association search relation according to the abnormal data information comprises the following steps:
acquiring associated parameters related to calculation of the abnormal constant value from the abnormal data information;
and correlating the plurality of correlation parameters according to the retrieval priority to obtain a correlation retrieval relation.
Further, the associated parameters are associated subjects; the obtaining the associated parameters related to calculating the abnormal constant value from the abnormal data information comprises the following steps:
extracting a formula for calculating the abnormal value from the abnormal data information;
and taking the subject type involved in the formula as the associated subject.
Further, the association parameters include: company name, billing time limit, and associated subject.
In order to solve the above technical problems, an embodiment of the present invention further provides a report data testing device, including:
The acquisition module is used for acquiring accounting data from a plurality of systems;
The processing module is used for filling the accounting data into a preset template to generate a financial statement;
and the execution module is used for comparing the generated financial statement with a target financial statement acquired in advance so as to confirm the correctness of the statement data in the target financial statement.
Further, the processing module includes:
the first processing sub-module is used for classifying the accounting data acquired from each system according to the subject type to which the accounting data belongs;
the second processing sub-module is used for calculating the classified billing data according to a preset first formula to obtain first report data;
And the third processing sub-module is used for adding the first report data into a preset first template to obtain a first financial report.
Further, the processing module includes:
The first acquisition sub-module is used for acquiring report data of each sub-company from each system;
the third processing sub-module is used for calculating the report data of each sub-company according to a preset second formula to obtain second report data;
and the first execution sub-module is used for adding the second baby data into a preset second template to obtain a second financial statement.
Further, the method further comprises the following steps:
the second acquisition sub-module is used for acquiring abnormal data information of inconsistent comparison from the financial statement when the comparison is inconsistent;
The third acquisition sub-module is used for acquiring an association retrieval relation according to the abnormal data information;
And the second execution sub-module is used for sending a search request to each system according to the parameters in the association search relation so as to enable each system to return a plurality of billing data associated with the abnormal data information for verification.
Further, the abnormal data information includes: an anomaly value; the third acquisition submodule includes:
A fourth obtaining sub-module, configured to obtain, from the abnormal data information, a correlation parameter related to calculating the abnormal value;
And the fourth processing sub-module is used for correlating a plurality of correlation parameters according to the retrieval priority to obtain a correlation retrieval relation.
Further, the associated parameters are associated subjects; the fourth acquisition submodule includes:
a fifth obtaining sub-module, configured to extract a formula for calculating the abnormal value from the abnormal data information;
And the fifth processing sub-module is used for taking the subject type involved in the formula as the associated subject.
Further, the association parameters include: company name, billing time limit, and associated subject.
In order to solve the above technical problems, an embodiment of the present invention further provides a computer device, including a memory and a processor, where the memory stores computer readable instructions, and when the computer readable instructions are executed by the processor, the processor is caused to execute the steps of the report data testing method.
To solve the above technical problem, an embodiment of the present invention further provides a storage medium storing computer readable instructions, where the computer readable instructions when executed by one or more processors cause the one or more processors to execute the steps of the report data testing method.
The embodiment of the invention has the beneficial effects that: the method not only can ensure the accuracy of the report data, but also can obtain the operation condition of a financial report forecast enterprise at any time, is convenient and efficient, thereby improving the working efficiency.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the description of the embodiments will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a basic flow chart of a report data testing method according to an embodiment of the present invention;
FIG. 2 is a basic flow chart of a method for generating a financial statement by filling accounting data into a preset template according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of a basic flow chart of another method for generating a financial statement by filling accounting data into a preset template according to an embodiment of the present invention;
FIG. 4 is a basic flow chart of a method for obtaining abnormal data according to an embodiment of the present invention;
FIG. 5 is a basic flow chart of a method for obtaining association search relationships according to abnormal data information according to an embodiment of the present invention;
FIG. 6 is a basic flow chart of a method for obtaining correlation parameters related to calculating abnormal values from abnormal data information according to an embodiment of the present invention;
FIG. 7 is a basic structural block diagram of a report data testing device according to an embodiment of the present invention;
FIG. 8 is a basic block diagram of a computer device according to an embodiment of the present invention.
Detailed Description
In order to enable those skilled in the art to better understand the present invention, the following description will make clear and complete descriptions of the technical solutions according to the embodiments of the present invention with reference to the accompanying drawings.
In some of the flows described in the specification and claims of the present invention and in the foregoing figures, a plurality of operations occurring in a particular order are included, but it should be understood that the operations may be performed out of order or performed in parallel, with the order of operations such as 101, 102, etc., being merely used to distinguish between the various operations, the order of the operations themselves not representing any order of execution. In addition, the flows may include more or fewer operations, and the operations may be performed sequentially or in parallel. It should be noted that, the descriptions of "first" and "second" herein are used to distinguish different messages, devices, modules, etc., and do not represent a sequence, and are not limited to the "first" and the "second" being different types.
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to fall within the scope of the invention.
Examples
As used herein, a "terminal" includes both a device of a wireless signal receiver having no transmitting capability and a device of receiving and transmitting hardware having receiving and transmitting hardware capable of performing bi-directional communications over a bi-directional communication link, as will be appreciated by those skilled in the art. Such a device may include: a cellular or other communication device having a single-line display or a multi-line display or a cellular or other communication device without a multi-line display; PCS (Personal Communications Service, personal communications System) that may combine voice, data processing, facsimile and/or data communications capabilities; PDA (Personal DIGITAL ASSISTANT ) that may include a radio frequency receiver, pager, internet/intranet access, web browser, notepad, calendar and/or GPS (Global Positioning System ) receiver; a conventional laptop and/or palmtop computer or other appliance that has and/or includes a radio frequency receiver. As used herein, "terminal," "terminal device" may be portable, transportable, installed in a vehicle (aeronautical, maritime, and/or land-based), or adapted and/or configured to operate locally and/or in a distributed fashion, to operate at any other location(s) on earth and/or in space. The "terminal" and "terminal device" used herein may also be a communication terminal, a network access terminal, and a music/video playing terminal, for example, may be a PDA, a MID (Mobile INTERNET DEVICE ) and/or a Mobile phone with a music/video playing function, and may also be a smart tv, a set top box, and other devices.
The client terminal in this embodiment is the above-described terminal.
Specifically, referring to fig. 1, fig. 1 is a basic flow chart of a report data testing method according to the present embodiment.
As shown in fig. 1, the report data testing method includes the following steps:
S1100, acquiring accounting data from a plurality of systems;
Typically, there are different systems for billing and accounting for different subjects or sub-companies, respectively, for group companies with a large amount of traffic, a large variety of industries, and a large number of sub-companies. Therefore, in order to conveniently obtain the business data of the whole group company, the report generating system is associated with each system, and the billing data of each system is obtained at any time.
The accounting data is data for recording business formed according to the accounting vouchers, wherein the accounting vouchers are classified according to economic business properties, accounting entry is determined as one kind of vouchers for registering accounts, accounting staff can fill the accounting vouchers according to the original vouchers or the original vouchers summary table without errors, and the accounting vouchers are classified into collection vouchers, payment vouchers, transfer vouchers and the like according to the recorded economic business and cash and bank deposit receipt and payment. For example, if a certain accounting voucher is a 10000 ten thousand bank transfer voucher transferred to a bank account where the company X is located after the company X purchases goods, the company finance can record the accounting voucher as a borrow: accounts receivable 10000 ten thousand, credit: bank deposit: 10000 yuan.
S1200, filling accounting data into a preset template to generate a financial statement;
The financial statement includes: asset liability statement, damage benefit statement, cash flow statement or financial condition change statement, balance statement and balance notes. Wherein the liability statement is a statement reflecting all of the assets, liabilities, and owner equity of the business on a particular date. The profit-loss table is a report for reflecting profit realization or loss of an enterprise during a certain period. The cash flow table indicates the increase/decrease of cash of the enterprise. The data in the table are all obtained by accounting according to accounting subjects through business data which are daily generated by enterprises.
The preset template is a form document set in the form of a financial statement. In the embodiment of the invention, the terminal calculates the acquired accounting data to generate the accounting data to be filled in the financial report, and for the annual financial report, the accounting data in1 year acquired from a plurality of systems can be subjected to cumulative addition operation, and for the monthly report or the report with any date, all the accounting data in the term can be acquired according to the term of the report and calculated according to a preset method, and the calculated report data is filled in a preset report template.
For example, assets in the asset liability table include: a liquidity asset and a non-liquidity asset, wherein the liquidity asset comprises: monetary funds, receivables, accounts receivable, pre-paid money, interest receivable, inventory, and the like. Taking monetary funds as an example, accounting data about the monetary funds in each system is acquired, the amount of the accumulated monetary funds is calculated according to the deadlines, and the calculated monetary funds are filled into the report.
S1300, comparing the generated financial statement with a target financial statement acquired in advance to confirm the correctness of the statement data in the target financial statement.
The target financial report is a report with the same term as the financial report generated in the embodiment of the invention, for example, the generated financial report is a month report of 20XX year X month, and the target financial report is also a month report of 20XX year X month, wherein the target financial report can be a report which is pre-manufactured by accountants or a report which is manufactured by a system and is used for comparing with the financial report generated in the embodiment of the invention so as to test the accuracy of the report generated by the system.
In the embodiment of the invention, each item of data in the generated financial statement is respectively subjected to one comparison with the data in the financial statement acquired in advance, when the data are completely consistent, the correctness of the generated statement is high, and when the comparison is inconsistent, the correctness is low.
According to the report data testing method, the accounting data in each system are automatically acquired and filled into the preset templates, the financial report is generated and compared with the pre-acquired financial report, so that the accuracy of the report data is tested, the operation condition of a financial report forecast enterprise can be obtained at any time, and the method is convenient and efficient, and therefore the working efficiency is improved.
The embodiment of the invention provides a method for filling accounting data into a preset template, as shown in fig. 2, fig. 2 is a basic flow diagram of a method for filling accounting data into a preset template to generate a financial statement according to the embodiment of the invention.
As shown in fig. 2, step S1200 includes the steps of:
s1211, classifying the account data acquired from each system according to the subject type to which the account data belongs;
The subject type is a subject in financial accounting for facilitating accounting setting, and is used for representing the type of accounting data, including: accounts receivable, bank borrowing, accounts payable, etc. In the embodiment of the invention, the financial report is the summary of report data at a certain stage, so the report data acquired from each system is classified according to the subject types. In the classification, classification is performed in units of systems.
S1212, calculating the classified billing data according to a preset first formula to obtain first report data;
The first formula is a formula used for calculating first report data in the financial report, wherein the first report data is report data to be filled in the financial report. For example, in the liability statement, the first report data includes: a liquidity asset and a non-liquidity asset, wherein the liquidity asset comprises: monetary funds, receivables, accounts receivable, pre-paid money, accounts receivable, stakeholders, and the like. The non-mobile asset includes: financial assets available for sale, hold to expiration investments, long term payouts, long term equity investments, investment intelligence real estate, fixed assets, on-building projects, engineering materials, and the like. For example, in the profit sheet, the first report data includes: total revenue, operating profits, profit totals, net profits, etc., wherein the total revenue includes: business costs, tax and add-ons, sales fees, management fees, financial fees, asset reduction losses, investment benefits, etc., business revenues include: and (5) business income and business expenditure.
In the embodiment of the present invention, the first formula includes: monetary funds = cash + bank deposit + other monetary funds; accounts receivable = accounts receivable (borrow) +pre-accounts receivables (borrow) -accounts receivable "bad account preparation" prepaid accounts = accounts payable (credit) +prepaid accounts (credit) -corresponding bad account preparation. It should be noted that, the foregoing describes the first report data and the first formula in the financial report by way of example only, and in practical application, the first report data and the first formula further include other non-enumerated formulas and data names, which are not described herein again.
In the embodiment of the invention, the classified billing data is calculated according to the first formula to generate the first report data in the financial report.
S1213, adding the first report data into a preset first template to obtain a first financial report.
In the embodiment of the present invention, when an enterprise is divided into a plurality of systems for managing liabilities, profits, cash flows, etc., the first template is a template of an enterprise financial statement, including: and adding the first report data obtained by each system into a first template to obtain the financial report of the enterprise, namely a first financial report.
In another embodiment of the present invention, when each system is used to manage finances of one sub-company in a plurality of systems separated by an enterprise, the acquired accounting data includes accounting data of each sub-company, so in order to obtain a financial statement of the enterprise, another method for generating the financial statement by filling the accounting data into a preset template is provided in the embodiment of the present invention, as shown in fig. 3, fig. 3 is a basic flow diagram of another method for generating the financial statement by filling the accounting data into the preset template provided in the embodiment of the present invention.
As shown in fig. 3, step S1200 includes the steps of:
S1221, acquiring report data of each sub-company from each system;
The statement data of the subsidiary is data representing the financial condition of each subsidiary, that is, data in the financial statement of each subsidiary. Specifically, the obtaining report data of each sub-company from each system includes: and acquiring the billing data of each subsidiary from the system, and calculating report data of each subsidiary according to a first formula. The step of calculating the report data according to the first formula is described with reference to the embodiment of fig. 2, and is not described herein.
S1222, calculating report data of each subsidiary according to a preset second formula to obtain second report data;
The second report data is report data of the enterprise obtained by combining all the sub-companies. The second formula is a formula for performing operations such as merging report data of each subsidiary, for example, a certain enterprise includes a subsidiary a and a subsidiary B, where accounts payable of the subsidiary a is 100 ten thousand yuan, accounts payable of the subsidiary B is 200 ten thousand yuan, and accounts payable of the enterprise is 100+200=300 ten thousand yuan.
S1223, adding the second report data into a preset second template to obtain a second financial report.
In the embodiment of the invention, the second template is preset with tables of the financial data of each subsidiary, and when the second financial report is generated, the second report data and the financial data of the subsidiary are added into the second template to generate the financial report of the enterprise.
In practical application, when the generated financial report is inconsistent with the target financial report, that is, when an error occurs in one of the two reports, in order to timely know the accounting data with the error, the embodiment of the invention provides a method for acquiring the abnormal data, as shown in fig. 4, and fig. 4 is a basic flow diagram of the method for acquiring the abnormal data in the embodiment of the invention.
As shown in fig. 4, after step S1300, the method further includes:
s1310, when the comparison is inconsistent, acquiring abnormal data information of the inconsistent comparison from the financial statement;
The abnormal data information is data inconsistent with the comparison in the target financial statement, and comprises a numerical value and a category to which the numerical value belongs. For example, the anomaly data is accounts payable: 50 ten thousand yuan. When the data in the generated financial statement is inconsistent with the data of the target financial statement, determining inconsistent data information in the generated statement as abnormal data information, and extracting abnormal data from the generated financial statement.
S1320, acquiring an association search relation according to the abnormal data information;
when the abnormal data information is an abnormal value, that is, the values are different, the embodiment of the invention provides a method for acquiring the association search relation according to the abnormal data information. Fig. 5 is a basic flow chart of a method for acquiring association search relationships according to abnormal data information according to an embodiment of the present invention, as shown in fig. 5.
As shown in fig. 5, step S1320 includes:
S1321, acquiring related parameters related to calculating abnormal constant values from abnormal data information;
The associated parameters are parameters associated with abnormal values, including: company name, billing time limit, and associated subject, etc. When the abnormal data information is an abnormal value, that is, the compared values are inconsistent, which may be caused by omission or more calculations, in order to further analyze the cause of the abnormal value, an embodiment of the present invention provides a method for obtaining an associated parameter related to calculating the abnormal value from the abnormal data information, as shown in fig. 6, and fig. 6 is a basic flow chart of a method for obtaining an associated parameter related to calculating the abnormal value from the abnormal data information provided in the embodiment of the present invention.
As shown in fig. 6, step S1321 includes the steps of:
S13211, extracting a formula for calculating an abnormal value from abnormal data information;
Wherein the associated parameter is an associated subject. The following will exemplify: report data in a financial report is typically the result of each accounting data calculation. For example, receivables = receivables (borrows) +pre-receivables (borrows) -bad account preparation that shall be accounted for "receivables", when the receivables are of abnormal value, then the formula for calculating the receivables is extracted, i.e. the above formula.
S13212, taking the subject type related in the formula as the associated subject.
In the embodiment of the present invention, in order to find billing data related to abnormal data, all subjects involved in the formula, that is, accounts receivable (borrowing), accounts pre-receivable (borrowing), and "bad account preparation" by which accounts are to be submitted "accounts receivable" are determined as associated subjects.
S1322, associating the plurality of association parameters according to the search priority, thereby obtaining an association search relation.
When 50 ten thousand yuan of accounts payable is abnormal information, establishing an association retrieval relation as follows: "bad account preparation" of "accounts receivable (borrow) and accounts pre-receivables (borrow) and accounts receivables". In the embodiment of the invention, the priority can be determined according to the preset parameter sequence.
S1330, sending a search request to each system according to the parameters in the association search relationship, so that each system returns a plurality of billing data associated with the abnormal data information for verification.
The search request is a request for requesting the system to search the association parameters, wherein the search request comprises: and (5) associating parameters.
In order to solve the technical problems, the embodiment of the invention also provides a report data testing device. Referring specifically to fig. 7, fig. 7 is a basic structural block diagram of a report data testing apparatus according to this embodiment.
As shown in fig. 7, a report data testing apparatus includes: an acquisition module 2100, a processing module 2200, and an execution module 2300. Wherein, the obtaining module 2100 is configured to obtain billing data from a plurality of systems; the processing module 2200 is used for filling the accounting data into a preset template to generate a financial statement; and the execution module 2300 is used for comparing the generated financial statement with a target financial statement acquired in advance so as to confirm the correctness of the statement data in the target financial statement.
The report data testing device automatically acquires the accounting data in each system, fills the accounting data into the preset template, generates the financial report, compares the accounting data with the pre-acquired financial report, tests the correctness of the report data, can acquire the operation condition of a financial report forecast enterprise at any time, is convenient and efficient, and improves the working efficiency.
In some embodiments, the processing module comprises: the first processing sub-module is used for classifying the accounting data acquired from each system according to the subject type to which the accounting data belongs; the second processing sub-module is used for calculating the classified billing data according to a preset first formula to obtain first report data; and the third processing sub-module is used for adding the first report data into a preset first template to obtain a first financial report.
In some embodiments, the processing module comprises: the first acquisition sub-module is used for acquiring report data of each sub-company from each system; the third processing sub-module is used for calculating the report data of each sub-company according to a preset second formula to obtain second report data; and the first execution sub-module is used for adding the second baby data into a preset second template to obtain a second financial statement.
In some embodiments, the report data testing apparatus further comprises: the second acquisition sub-module is used for acquiring abnormal data information of inconsistent comparison from the financial statement when the comparison is inconsistent; the third acquisition sub-module is used for acquiring an association retrieval relation according to the abnormal data information; and the second execution sub-module is used for sending a search request to each system according to the parameters in the association search relation so as to enable each system to return a plurality of billing data associated with the abnormal data information for verification.
In some embodiments, the anomalous data information comprises: an anomaly value; the third acquisition submodule includes: a fourth obtaining sub-module, configured to obtain, from the abnormal data information, a correlation parameter related to calculating the abnormal value; and the fourth processing sub-module is used for correlating a plurality of correlation parameters according to the retrieval priority to obtain a correlation retrieval relation.
In some embodiments, the associated parameter is an associated subject; the fourth acquisition submodule includes: a fifth obtaining sub-module, configured to extract a formula for calculating the abnormal value from the abnormal data information; and the fifth processing sub-module is used for taking the subject type involved in the formula as the associated subject.
In some embodiments, the association parameters include: company name, billing time limit, and associated subject.
In order to solve the technical problems, the embodiment of the invention also provides computer equipment. Referring specifically to fig. 8, fig. 8 is a basic structural block diagram of a computer device according to the present embodiment.
As shown in fig. 8, the internal structure of the computer device is schematically shown. As shown in fig. 8, the computer device includes a processor, a non-volatile storage medium, a memory, and a network interface connected by a system bus. The nonvolatile storage medium of the computer equipment stores an operating system, a database and a computer readable instruction, the database can store a control information sequence, and the computer readable instruction can enable the processor to realize a report data testing method when being executed by the processor. The processor of the computer device is used to provide computing and control capabilities, supporting the operation of the entire computer device. The memory of the computer device may have stored therein computer readable instructions that, when executed by the processor, cause the processor to perform a report data testing method. The network interface of the computer device is for communicating with a terminal connection. It will be appreciated by those skilled in the art that the structure shown in FIG. 8 is merely a block diagram of some of the structures associated with the present inventive arrangements and is not limiting of the computer device to which the present inventive arrangements may be applied, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
The processor in this embodiment is configured to execute the specific contents of the acquisition module 2100, the processing module 2200, and the execution module 2300 in fig. 7, and the memory stores program codes and various types of data required for executing the above modules. The network interface is used for data transmission between the user terminal or the server. The memory in this embodiment stores program codes and data required for executing all the sub-modules in the report data test method, and the server can call the program codes and data of the server to execute the functions of all the sub-modules.
The computer equipment automatically acquires the accounting data in each system, fills the accounting data into a preset template, generates a financial statement, compares the accounting data with the pre-acquired financial statement, tests the correctness of the statement data, can acquire the operation condition of a financial statement forecast enterprise at any time, is convenient and efficient, and improves the working efficiency.
The present invention also provides a storage medium storing computer readable instructions that, when executed by one or more processors, cause the one or more processors to perform the steps of the report data testing method of any of the embodiments described above.
Those skilled in the art will appreciate that implementing all or part of the above-described methods in accordance with the embodiments may be accomplished by way of a computer program stored in a computer-readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. The storage medium may be a nonvolatile storage medium such as a magnetic disk, an optical disk, a Read-Only Memory (ROM), or a random access Memory (Random Access Memory, RAM).
It should be understood that, although the steps in the flowcharts of the figures are shown in order as indicated by the arrows, these steps are not necessarily performed in order as indicated by the arrows. The steps are not strictly limited in order and may be performed in other orders, unless explicitly stated herein. Moreover, at least some of the steps in the flowcharts of the figures may include a plurality of sub-steps or stages that are not necessarily performed at the same time, but may be performed at different times, the order of their execution not necessarily being sequential, but may be performed in turn or alternately with other steps or at least a portion of the other steps or stages.
The foregoing is only a partial embodiment of the present invention, and it should be noted that it will be apparent to those skilled in the art that modifications and adaptations can be made without departing from the principles of the present invention, and such modifications and adaptations are intended to be comprehended within the scope of the present invention.
Claims (6)
1. The report data testing method is characterized by comprising the following steps of:
Acquiring billing data from a plurality of systems;
Filling the accounting data into a preset template to generate a financial statement, wherein the accounting data comprises: classifying the accounting data acquired from each system according to the subject type to which the accounting data belongs; calculating the classified billing data according to a preset first formula to obtain first report data; adding the first report data into a preset first template to obtain a first financial report; acquiring report data of each subsidiary from each system; calculating the report data of each subsidiary according to a preset second formula to obtain second report data; adding the second report data into a preset second template to obtain a second financial report;
Comparing the generated financial statement with a target financial statement acquired in advance to confirm the correctness of the statement data in the target financial statement;
when the comparison is inconsistent, acquiring abnormal data information of the inconsistent comparison from the financial statement;
Acquiring an association search relation according to the abnormal data information, wherein the association search relation comprises the following steps:
Acquiring association parameters related to calculation of abnormal values from the abnormal data information, and associating a plurality of association parameters according to retrieval priority to obtain an association retrieval relation, wherein the abnormal data information comprises: an anomaly value;
And sending a search request to each system according to the parameters in the association search relation, so that each system returns a plurality of billing data associated with the abnormal data information for verification.
2. The report data testing method of claim 1, wherein the associated parameters are associated subjects; the acquiring the associated parameters related to calculating the abnormal constant value from the abnormal data information comprises the following steps:
extracting a formula for calculating the abnormal value from the abnormal data information;
and taking the subject type involved in the formula as the associated subject.
3. The report data testing method of claim 1, wherein the associated parameters comprise: company name, billing time limit, and associated subject.
4. A report data testing device, comprising:
The acquisition module is used for acquiring accounting data from a plurality of systems;
the processing module is used for filling the accounting data into a preset template to generate a financial statement, and comprises the following steps: classifying the accounting data acquired from each system according to the subject type to which the accounting data belongs; calculating the classified billing data according to a preset first formula to obtain first report data; adding the first report data into a preset first template to obtain a first financial report; acquiring report data of each subsidiary from each system; calculating the report data of each subsidiary according to a preset second formula to obtain second report data; adding the second report data into a preset second template to obtain a second financial report;
the execution module is used for comparing the generated financial statement with a target financial statement acquired in advance so as to confirm the correctness of the statement data in the target financial statement;
The execution module is specifically used for:
when the comparison is inconsistent, acquiring abnormal data information of the inconsistent comparison from the financial statement;
Acquiring an association search relation according to the abnormal data information; acquiring association parameters related to calculation of abnormal values from the abnormal data information, and associating a plurality of association parameters according to retrieval priority to obtain an association retrieval relation, wherein the abnormal data information comprises: an anomaly value;
And sending a search request to each system according to the parameters in the association search relation, so that each system returns a plurality of billing data associated with the abnormal data information for verification.
5. A computer device comprising a memory and a processor, the memory having stored therein computer readable instructions that, when executed by the processor, cause the processor to perform the steps of the report data testing method of any of claims 1 to 3.
6. A storage medium storing computer readable instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of the report data testing method of any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811253435.1A CN109582940B (en) | 2018-10-25 | 2018-10-25 | Report data testing method and device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811253435.1A CN109582940B (en) | 2018-10-25 | 2018-10-25 | Report data testing method and device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109582940A CN109582940A (en) | 2019-04-05 |
| CN109582940B true CN109582940B (en) | 2024-05-10 |
Family
ID=65920653
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811253435.1A Active CN109582940B (en) | 2018-10-25 | 2018-10-25 | Report data testing method and device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109582940B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111159234A (en) * | 2019-12-19 | 2020-05-15 | 中国建设银行股份有限公司 | Method and device for comparing reports |
| CN113407534B (en) * | 2021-06-02 | 2023-11-28 | 广州零端科技有限公司 | Medical data recording method, query method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103714480A (en) * | 2013-12-30 | 2014-04-09 | 山东中创软件工程股份有限公司 | Self-defined financial statement generation system |
| CN107527280A (en) * | 2017-10-12 | 2017-12-29 | 北京军秀咨询有限公司 | A kind of financial data processing method based on cloud computing |
| CN107767005A (en) * | 2016-08-23 | 2018-03-06 | 上海宝信软件股份有限公司 | Profit flow table injustice checking method and system based on bookkeeping voucher |
| CN108241603A (en) * | 2016-12-26 | 2018-07-03 | 航天信息股份有限公司 | A kind of financial statement generation method and system |
-
2018
- 2018-10-25 CN CN201811253435.1A patent/CN109582940B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103714480A (en) * | 2013-12-30 | 2014-04-09 | 山东中创软件工程股份有限公司 | Self-defined financial statement generation system |
| CN107767005A (en) * | 2016-08-23 | 2018-03-06 | 上海宝信软件股份有限公司 | Profit flow table injustice checking method and system based on bookkeeping voucher |
| CN108241603A (en) * | 2016-12-26 | 2018-07-03 | 航天信息股份有限公司 | A kind of financial statement generation method and system |
| CN107527280A (en) * | 2017-10-12 | 2017-12-29 | 北京军秀咨询有限公司 | A kind of financial data processing method based on cloud computing |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109582940A (en) | 2019-04-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Isayas | Determinants of banks’ profitability: Empirical evidence from banks in Ethiopia | |
| US20130159151A1 (en) | Determining Change in Interchange Rate | |
| US8280787B1 (en) | Method and system for recommending a change of bank account based on actual financial data | |
| CN108241603A (en) | A kind of financial statement generation method and system | |
| Mattes et al. | Do information rents in loan spreads persist over the business cycles? | |
| CN113205402A (en) | Account checking method and device, electronic equipment and computer readable medium | |
| CN109582940B (en) | Report data testing method and device, computer equipment and storage medium | |
| Rahmayanti et al. | Digital accounting for small to medium enterprises using mobile applications | |
| EP1563422A1 (en) | Electronic interpretation of financials | |
| US7856389B2 (en) | Dynamic book yield analysis | |
| CN110148049A (en) | A kind of risk control method, device, computer equipment and readable storage medium storing program for executing | |
| CN110750302B (en) | Assembly line account making method for accountant | |
| CN109614607B (en) | Report data processing method, device, computer equipment and storage medium | |
| CN114463107A (en) | Intelligent financial working system based on artificial intelligence and method thereof | |
| Otero-González et al. | The main determinants of subprime securitization in the Spanish RMBS securities | |
| Tran et al. | The impact of adopting IFRS on corporate ETR and book-tax income gap | |
| Karismariyanti | A Proposed Framework for Accounts Receivable Information System (ARIS) Development | |
| CN116342315A (en) | Method and device for clearing up to and from money, computer equipment and storage medium | |
| Hellerstein et al. | The determinants of international flows of US currency | |
| Horvat et al. | Analysis of Assets in Balance Sheet of Construction Company | |
| Kadafi et al. | Preparation of financial statements based on SAK EMKM using Android-based UKM accounting computer applications | |
| Dekle et al. | The Thai currency crisis: Financing constraints, high fixed costs, and corporate governance | |
| Westland et al. | Substantive Tests | |
| Chen | Analysis of the Development Trend of E-Commerce Based on Network Intelligence Technology: The Case of Jing Dong (JD) | |
| Sannii | VALUE RELEVANCE OF INTERNATIONAL FINANCIAL REPORTING STANDARD 7 (IFRS 7) FINANCIAL INSTRUMENTS DISCLOSURES FOR LISTED INSURANCE FIRMS IN NIGERIA |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |