CN111813829A - Data settlement method, device, electronic device and storage medium - Google Patents

Abstract

The invention relates to the technical field of artificial intelligence, can be applied to the field of intelligent government affairs of intelligent cities, and provides a data resolution method, a device, electronic equipment and a storage medium, wherein the method comprises the following steps: acquiring data to be settled through a system interface and a preset data warehouse; performing settlement on the data to be settled according to a preset first settlement formula to obtain settlement data; checking the settlement data to obtain a checking result, wherein the checking mode comprises checking according to a preset checking formula and/or a preset access rule and/or table connection operation; if the check result is passed, summarizing the settlement data to obtain summarized data; and sending the summarized data to a preset terminal. Furthermore, the present invention also relates to block chain techniques, which summarized data may be stored in block chains. By using the method and the device, the accuracy of the settlement data can be ensured, and the data settlement efficiency can be improved.

Description

Data settlement method, device, electronic device and storage medium

technical field

The present invention relates to the technical field of artificial intelligence, and in particular, to a data final calculation method, device, electronic device and storage medium.

Background technique

At present, government departments need to finalize various data (such as financial appropriations) according to the latest final accounting rules (formulas) every year. In practice, it is found that due to the huge amount of data, a large number of personnel are required to perform data verification and other work, and the final accounting efficiency is not efficient. high.

Therefore, how to improve the efficiency of data settlement is a technical problem that needs to be solved urgently.

SUMMARY OF THE INVENTION

In view of the above, it is necessary to provide a data settlement method, device, electronic device and storage medium, which can improve the data settlement efficiency.

A first aspect of the present invention provides a data settlement method, the method comprising:

Obtain the data to be finalized through the system interface and the preset data warehouse;

According to the preset first final settlement formula, final settlement is performed on the data to be finalized to obtain final settlement data;

Verifying the final settlement data to obtain a verification result, wherein the verification method includes according to a preset verification formula, and/or, according to a preset number fetching rule, and/or, using a table join operation for verification;

If the verification result is passed, the final settlement data is aggregated to obtain aggregated data;

Send the summary data to a preset terminal.

In a possible implementation manner, the performing verification on the final settlement data, and obtaining the verification result includes:

According to the first final settlement formula, re-final settlement is performed on the data to be finalized to obtain first verification data;

Judging whether the final settlement data is consistent with the first verification data;

If the final settlement data is consistent with the first verification data, it is determined that the verification result is passed; or

If the final settlement data is inconsistent with the first verification data, it is determined that the verification result is not passed.

As an optional implementation manner, the final settlement data has multiple types, and the verification of the final settlement data to obtain a verification result includes:

Using a preset number-taking rule, for each type of final settlement data, obtain a preset numerical threshold range corresponding to the final settlement data;

Judging whether the final settlement data is within the preset value threshold range;

If the final settlement data is within the preset value threshold range, it is determined that the verification result is passed; or

If the final settlement data is not within the preset value threshold range, it is determined that the verification result is not passed.

In a possible implementation manner, the performing verification on the final settlement data, and obtaining the verification result includes:

According to the fetch rule, obtain target data from the data interface or data table specified by the fetch rule;

According to the second final settlement formula corresponding to the target data in the verification formula, determine the second verification data corresponding to the target data;

From the final settlement data, determine the data to be verified corresponding to the target data;

The target data, the second verification data and the to-be-verified data are table-joined to obtain a target data table;

Query whether there is a target row in the target data table, and the second verification data corresponding to the target row is inconsistent with the to-be-verified data corresponding to the target row;

If there is no target row in the target data table, it is determined that the verification result is passed; if there is a target row in the target data table, it is determined that the verification result is not passed.

In a possible implementation manner, the data final accounting method further includes:

If the verification result is not passed, generate an alarm message;

The alarm information is sent to the terminal of the manager.

In a possible implementation manner, the data to be finalized includes first data to be finalized and the second data to be finalized, and the data finalized method further includes:

Obtain pending final settlement data that has not been entered into the system;

Preprocessing the data to be finalized that has not been entered into the system to obtain preprocessing data;

storing the preprocessed data in the data warehouse;

The acquisition of the data to be finalized through the system interface and the preset data warehouse includes:

obtaining the first pending final settlement data through the system interface;

Through the data warehouse, query and acquire the second pending final settlement data from the preprocessed data.

In a possible implementation manner, the data final accounting method further includes:

When receiving the data analysis instruction, determine the source of the data to be settled;

generating a first table according to the data to be finalized;

In the first table, the data to be settled from different sources is marked with a plurality of preset color blocks, and the second table is obtained, wherein the data to be settled from one source corresponds to one color block;

The second table is output.

A second aspect of the present invention provides a device for final settlement of data, the device for final settlement of data includes:

The acquisition module is used to acquire the data to be finalized through the system interface and the preset data warehouse;

A final settlement module, configured to perform final settlement on the data to be finalized according to a preset first final settlement formula, and obtain final settlement data;

A verification module, configured to verify the final settlement data and obtain a verification result, wherein the verification method includes according to a preset verification formula, and/or, according to a preset number-taking rule, and / or, use the table join operation to verify;

a summary module, used for summarizing the final accounts data to obtain summary data if the verification result is passed;

A sending module, configured to send the aggregated data to a preset terminal.

A third aspect of the present invention provides an electronic device, the electronic device includes a processor and a memory, and the processor is configured to implement the data finalization method when executing a computer program stored in the memory.

A fourth aspect of the present invention provides a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the data settlement method is implemented.

According to the above technical solutions, in the present invention, the data to be finalized can be finalized according to the preset first final accounting formula through artificial intelligence technology, and verified, and then the finalized data that has passed the verification can be summarized, and then reported (the The summary data is sent to the preset device terminal), which not only ensures the accuracy of the final settlement data, but also improves the efficiency of the data final settlement.

Description of drawings

FIG. 1 is a flow chart of a preferred embodiment of a data settlement method disclosed in the present invention.

FIG. 2 is a functional block diagram of a preferred embodiment of a data settlement device disclosed in the present invention.

FIG. 3 is a schematic structural diagram of an electronic device according to a preferred embodiment of the method for implementing data final settlement of the present invention.

Detailed ways

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, but not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. The terms used herein in the description of the present invention are for the purpose of describing specific embodiments only, and are not intended to limit the present invention.

The data finalization method of the embodiment of the present invention is applied to an electronic device, and can also be applied to a hardware environment composed of an electronic device and a server connected to the electronic device through a network, and is jointly executed by the server and the electronic device. The network includes, but is not limited to: a wide area network, a metropolitan area network or a local area network.

The server may refer to a computer system that can provide services to other devices (eg, electronic devices) in the network. If a personal computer can provide a file transfer protocol (File Transfer Protocol, referred to as FTP) service, it can also be called a server. In a narrow sense, a server refers to some high-performance computers that can provide services to the outside world through a network. Compared with ordinary personal computers, servers have higher requirements in terms of stability, security, and performance. , chipset, memory, disk system, network and other hardware are different from ordinary personal computers.

The electronic device is a device that can automatically perform numerical calculation and/or information processing according to pre-set or stored instructions, and its hardware includes but is not limited to microprocessors, application-specific integrated circuits (ASICs), field programmable gates Arrays (FPGA), digital processors (DSP), embedded devices, etc. The electronic equipment may also include network equipment and/or user equipment. Wherein, the network device includes but is not limited to a single network device, a server group composed of multiple network devices, or a cloud composed of a large number of hosts or network devices based on cloud computing, wherein cloud computing is distributed computing A super virtual computer consisting of a group of loosely coupled sets of computers. The user equipment includes but is not limited to any electronic product that can interact with the user through a keyboard, a mouse, a remote control, a touchpad or a voice-activated device, for example, a personal computer, a tablet computer, a smart phone, a personal digital Assistant PDA etc.

Please refer to FIG. 1. FIG. 1 is a flowchart of a preferred embodiment of a data final settlement method disclosed in the present invention. Wherein, according to different requirements, the order of the steps in the flowchart can be changed, and some steps can be omitted. Wherein, the execution subject of the data settlement method may be an electronic device.

S11. Acquire data to be finalized through a system interface and a preset data warehouse.

Wherein, the data warehouse stores pre-computed data

The data to be finalized may be social security payment data, government fund income data, and the like.

The pre-operation data may be the summation result of some commonly used data, the average result, etc. These operation results are stored in the data warehouse and can be obtained at any time, and there is no need to perform repeated operations on a large amount of data each time , improve system efficiency.

Wherein, the sources of the data to be finalized include a data warehouse, a third-party input, and a data providing interface for the docking system.

In the embodiment of the present invention, the desired final settlement data can be queried and obtained from the data warehouse, the data to be finalized can be obtained through the data providing interface of the docking system, or the data to be finalized can be entered by a third party.

As an optional implementation manner, the data to be settled includes first data to be settled and second data to be settled, and the method further includes:

Obtain pending final settlement data that has not been entered into the system;

Preprocessing the data to be finalized that has not been entered into the system to obtain preprocessing data;

storing the preprocessed data in the data warehouse;

The acquisition of the data to be finalized through the system interface and the preset data warehouse includes:

obtaining the first pending final settlement data through the system interface;

Through the data warehouse, query and acquire the second pending final settlement data from the preprocessed data.

Wherein, the preprocessing includes but is not limited to data format conversion, data pre-operation and data screening. The data format conversion refers to converting the format of the specified type of data into a preset standard format, such as specifying the number of digits after the decimal point, such as the conversion of date type data (2020.06.28 or June 28, 2020, unified conversion is 2020-06-28); the data pre-operation may be to perform statistics on the income data in the preset practice section, such as annual statistics of salary data; the data screening may be to screen the data to filter out obvious anomalies data, such as negative social security payment data, etc.

Wherein, the data warehouse is used to store and manage data, and may be a database.

Optionally, the target data in each system can be imported into the data warehouse for management, and the data can be classified and stored in detail, such as social security payment data, government fund income data, etc., which can be used in the subsequent final calculation. Read a certain type of data quickly to improve the final settlement efficiency. At the same time, some common operations can be performed in advance, such as the accumulation and averaging of certain types of data for a week, a month, a quarter, and a year (that is, to obtain the preprocessing Data), the results of these operations are stored in the value data warehouse, and the results of these operations can be obtained at any time in the process of final settlement, which saves some calculation steps and further improves the efficiency of final settlement.

S12. Perform final settlement on the data to be finalized according to a preset first final settlement formula to obtain final settlement data.

Wherein, the final accounts may be a process in which units, departments, and countries sort out various annual income and expenditure data according to certain rules, such as calculating asset load data, total income data, and the like.

Wherein, the final settlement data may be total income data, total expenditure data, asset and liability data, and the like.

S13. Perform verification on the final settlement data to obtain a verification result, wherein the verification method includes according to a preset verification formula, and/or, according to a preset number-taking rule, and/or, using Table join operations are validated.

In the embodiment of the present invention, the final settlement data may be checked in various ways to determine the correctness of the final settlement data.

Specifically, performing the verification on the final settlement data and obtaining the verification result includes:

According to the first final settlement formula, re-final settlement is performed on the data to be finalized to obtain first verification data;

Judging whether the final settlement data is consistent with the first verification data;

If the final settlement data is consistent with the first verification data, it is determined that the verification result is passed; or

If the final settlement data is inconsistent with the first verification data, it is determined that the verification result is not passed.

In this optional implementation manner, the data to be finalized can be re-finalized to obtain verification data, and it can be determined whether the finalized data is consistent with the verification data. If they are consistent, the verification result is determined to be passed, and if the final settlement data is not consistent with the verification data, the verification result is determined to be failed.

Specifically, the final settlement data has multiple types, and the verification of the final settlement data to obtain a verification result includes:

Using a preset number-taking rule, for each type of final settlement data, obtain a preset numerical threshold range corresponding to the final settlement data;

Judging whether the final settlement data is within the preset value threshold range;

If the final settlement data is within the preset value threshold range, it is determined that the verification result is passed; or

If the final settlement data is not within the preset value threshold range, it is determined that the verification result is not passed.

In this optional embodiment, a preset numerical threshold range may be set for each type of final settlement data in advance, and the final settlement data within this preset numerical threshold range may be considered normal, and the verification result is determined to be Pass; the final settlement data outside the preset value threshold range can be considered as abnormal, and the verification result is determined to be failed. Optionally, for the final settlement data whose value is obviously abnormal (the final settlement data is not within the preset value threshold range), a preset abnormal prompt word (such as the final settlement data is obviously too large) and the final settlement data can be changed. And the report form of the data to be finalized constitutes abnormal prompt information and outputs abnormal prompt information, so as to prompt the staff to perform data detection in time.

Specifically, performing the verification on the final settlement data and obtaining the verification result includes:

According to the fetch rule, obtain target data from the data interface or data table specified by the fetch rule;

According to the second final settlement formula corresponding to the target data in the verification formula, determine the second verification data corresponding to the target data;

From the final settlement data, determine the data to be verified corresponding to the target data;

The target data, the second verification data and the to-be-verified data are table-joined to obtain a target data table;

Query whether there is a target row in the target data table, and the second verification data corresponding to the target row is inconsistent with the to-be-verified data corresponding to the target row;

If there is no target row in the target data table, it is determined that the verification result is passed; if there is a target row in the target data table, it is determined that the verification result is not passed.

In this optional implementation manner, it is assumed that the fetching rule takes data of type A and type B, and it is assumed that the second final calculation formula corresponding to the target data in the verification formula is A+B=C, and the data of type C is assumed to be A+B=C. For the verification data, namely A, B, C type data belong to the same table, suppose that the final account data corresponding to A and B is D, and D belongs to another table (comprising the pending final account data corresponding to each final account data E, F). You can combine two tables into one table by connecting A, B, C, and D through tables (such as the inner join command of the database). That is, A matches E, B matches F, and the target data table is obtained. Each row of data in the target data table includes a type A data (equal to the type E data of the row, no type E data is displayed), a type B data ( It is equal to the F-type data of the row, and the F-type data is not displayed), a D-type data (the verification data), and a final settlement data (the to-be-verified data). If the verification data is inconsistent, it is determined that the target row of the behavior, that is, the final account data, may be wrong, and error investigation needs to be carried out.

S14, if the verification result is passed, summarize the final accounts data to obtain summary data;

In the embodiment of the present invention, if the verification result is passed, it can be determined that the final settlement data is OK, the final settlement data can be aggregated, and the final settlement data from different units can be aggregated into the aggregated data.

As an optional embodiment, the method further includes:

If the verification result is not passed, generate an alarm message;

The alarm information is sent to the terminal of the manager.

In this optional embodiment, if the verification result is not passed, it is determined that the final settlement data is abnormal, and alarm information may be generated, and the alarm information may carry the reason for the failure of the verification result, such as final settlement data The corresponding pending settlement data is abnormal, the settlement formula is abnormal, etc. The alarm information is sent to the terminal of the administrator, so as to prompt the administrator to perform error investigation.

S15. Send the summary data to a preset terminal.

In this embodiment of the present invention, the aggregated data may be reported to a higher-level institution, a higher-level unit, or a higher-level government by sending the aggregated data to a preset terminal.

As an optional embodiment, the method further includes:

When receiving the data analysis instruction, determine the source of the data to be settled;

generating a first table according to the data to be finalized;

In the first table, the data to be settled from different sources is marked with a plurality of preset color blocks, and the second table is obtained, wherein the data to be settled from one source corresponds to one color block;

The second table is output.

In this optional implementation manner, when a data analysis instruction is received, different color blocks can be used to mark the data to be settled from different sources, so that the data in the generated table is clear at a glance and facilitates analysis.

It should be emphasized that, in order to further ensure the privacy and security of the above-mentioned summary data, the above-mentioned summary data can also be stored in a node of a blockchain.

In the method flow described in FIG. 1, artificial intelligence technology can be used to finalize the data to be finalized according to the preset first final accounting formula, and perform verification, and then summarize the final accounting data that has passed the verification, and then report (the The summary data is sent to the preset device terminal), which not only ensures the accuracy of the final settlement data, but also improves the efficiency of the data final settlement. The present invention can be applied to the field of smart government affairs in smart cities, and helps government personnel to automatically perform final accounts of various annual reports and the like.

FIG. 2 is a functional block diagram of a preferred embodiment of a data settlement device disclosed in the present invention.

Referring to FIG. 2 , the data settlement apparatus 20 may run in an electronic device. The data settlement device 20 may include a plurality of functional modules composed of program code segments. The program codes of each program segment in the data finalization device 20 may be stored in a memory and executed by at least one processor to perform some or all of the steps in the data finalization method described in FIG. 1 .

In this embodiment, the data settlement device 20 can be divided into a plurality of functional modules according to the functions performed by the data settlement device 20 . The functional modules may include: an acquisition module 201 , a final settlement module 202 , a verification module 203 , a summary module 204 and a sending module 205 . The modules referred to in the present invention refer to a series of computer program segments that can be executed by at least one processor and can perform fixed functions, and are stored in a memory.

The obtaining module 201 is used for obtaining the data to be finalized through the system interface and the preset data warehouse.

Wherein, the data warehouse stores pre-computed data

The data to be finalized may be social security payment data, government fund income data, and the like.

The pre-operation data may be the summation result of some commonly used data, the average result, etc. These operation results are stored in the data warehouse and can be obtained at any time, and there is no need to perform repeated operations on a large amount of data each time , improve system efficiency.

Wherein, the sources of the data to be finalized include a data warehouse, a third-party input, and a data providing interface for the docking system.

In the embodiment of the present invention, the desired final settlement data can be queried and obtained from the data warehouse, the data to be finalized can be obtained through the data providing interface of the docking system, or the data to be finalized can be entered by a third party.

The final settlement module 202 is configured to perform final settlement on the data to be finalized according to a preset first final settlement formula to obtain final settlement data.

Wherein, the final accounts may be a process in which units, departments, and countries sort out various annual income and expenditure data according to certain rules, such as calculating asset load data, total income data, and the like.

Wherein, the final settlement data may be total income data, total expenditure data, asset and liability data, and the like.

A verification module 203, configured to verify the final settlement data and obtain a verification result, wherein the verification method includes according to a preset verification formula, and/or, according to a preset number-taking rule, And/or, use a table join operation for validation.

In the embodiment of the present invention, the final settlement data may be checked in various ways to determine the correctness of the final settlement data.

The summarizing module 204 is used for summarizing the final settlement data to obtain summary data if the verification result is passed.

In the embodiment of the present invention, if the verification result is passed, it can be determined that the final settlement data is OK, the final settlement data can be aggregated, and the final settlement data from different units can be aggregated into the aggregated data.

The sending module 205 is configured to send the summary data to a preset terminal.

In this embodiment of the present invention, the aggregated data may be reported to a higher-level institution, a higher-level unit, or a higher-level government by sending the aggregated data to a preset terminal.

As an optional implementation manner, the verification module 203 performs verification on the final settlement data, and the method for obtaining the verification result is as follows:

According to the first final settlement formula, re-final settlement is performed on the data to be finalized to obtain first verification data;

Judging whether the final settlement data is consistent with the first verification data;

If the final settlement data is consistent with the first verification data, it is determined that the verification result is passed; or

If the final settlement data is inconsistent with the first verification data, it is determined that the verification result is not passed.

In this optional implementation manner, the data to be finalized can be re-finalized to obtain verification data, and it can be determined whether the finalized data is consistent with the verification data. If they are consistent, the verification result is determined to be passed, and if the final settlement data is not consistent with the verification data, the verification result is determined to be failed.

Specifically, the final settlement data has various types, and the verification module 203 verifies the final settlement data, and the method for obtaining the verification result is as follows:

Using a preset number-taking rule, for each type of final settlement data, obtain a preset numerical threshold range corresponding to the final settlement data;

Judging whether the final settlement data is within the preset value threshold range;

If the final settlement data is within the preset value threshold range, it is determined that the verification result is passed; or

If the final settlement data is not within the preset value threshold range, it is determined that the verification result is not passed.

In this optional embodiment, a preset numerical threshold range may be set for each type of final settlement data in advance, and the final settlement data within this preset numerical threshold range may be considered normal, and the verification result is determined to be Pass; the final settlement data outside the preset value threshold range can be considered as abnormal, and the verification result is determined to be failed. Optionally, for the final settlement data whose value is obviously abnormal (the final settlement data is not within the preset value threshold range), a preset abnormal prompt word (such as the final settlement data is obviously too large) and the final settlement data can be changed. And the report form of the data to be finalized constitutes abnormal prompt information and outputs abnormal prompt information, so as to prompt the staff to perform data detection in time.

Specifically, the verification module 203 verifies the final settlement data, and the method for obtaining the verification result is as follows:

According to the fetch rule, obtain target data from the data interface or data table specified by the fetch rule;

According to the second final settlement formula corresponding to the target data in the verification formula, determine the second verification data corresponding to the target data;

From the final settlement data, determine the data to be verified corresponding to the target data;

The target data, the second verification data and the to-be-verified data are table-joined to obtain a target data table;

Query whether there is a target row in the target data table, and the second verification data corresponding to the target row is inconsistent with the to-be-verified data corresponding to the target row;

If there is no target row in the target data table, it is determined that the verification result is passed; if there is a target row in the target data table, it is determined that the verification result is not passed.

In this optional implementation manner, it is assumed that the fetching rule takes data of type A and type B, and it is assumed that the second final calculation formula corresponding to the target data in the verification formula is A+B=C, and the data of type C is assumed to be A+B=C. For the verification data, namely A, B, C type data belong to the same table, suppose that the final account data corresponding to A and B is D, and D belongs to another table (comprising the pending final account data corresponding to each final account data E, F). You can combine two tables into one table by connecting A, B, C, and D through tables (such as the inner join command of the database). That is, A matches E, B matches F, and the target data table is obtained. Each row of data in the target data table includes a type A data (equal to the type E data of the row, no type E data is displayed), a type B data ( It is equal to the F-type data of the row, and the F-type data is not displayed), a D-type data (the verification data), and a final settlement data (the to-be-verified data). If the verification data is inconsistent, it is determined that the target row of the behavior, that is, the final account data, may be wrong, and error investigation needs to be carried out.

As an optional implementation manner, the data settlement device 20 further includes:

a first generating module, configured to generate alarm information if the verification result is not passed;

The sending module 205 is further configured to send the alarm information to the terminal of the manager.

In this optional embodiment, if the verification result is not passed, it is determined that the final settlement data is abnormal, and alarm information may be generated, and the alarm information may carry the reason for the failure of the verification result, such as final settlement data The corresponding pending settlement data is abnormal, the settlement formula is abnormal, etc. The alarm information is sent to the terminal of the administrator, so as to prompt the administrator to perform error investigation.

As an optional implementation manner, the data to be finalized includes first data to be finalized and the second data to be finalized, and the acquiring module 201 is further configured to acquire data to be finalized that has not been entered into the system;

The data settlement device 20 also includes:

a preprocessing module, used for preprocessing the data to be finalized that has not been entered into the system to obtain preprocessing data;

A storage module, configured to store the preprocessed data in the data warehouse.

The acquisition module 201 acquires the data to be finalized through the system interface and the preset data warehouse, specifically:

obtaining the first pending final settlement data through the system interface;

Through the data warehouse, query and acquire the second pending final settlement data from the preprocessed data.

Wherein, the preprocessing includes but is not limited to data format conversion, data pre-operation and data screening. The data format conversion refers to converting the format of the specified type of data into a preset standard format, such as specifying the number of digits after the decimal point, such as the conversion of date type data (2020.06.28 or June 28, 2020, unified conversion is 2020-06-28); the data pre-operation may be to perform statistics on the income data in the preset practice section, such as annual statistics of salary data; the data screening may be to screen the data to filter out obvious anomalies data, such as negative social security payment data, etc.

Wherein, the data warehouse is used to store and manage data, and may be a database.

Optionally, the target data in each system can be imported into the data warehouse for management, and the data can be classified and stored in detail, such as social security payment data, government fund income data, etc., which can be used in the subsequent final calculation. Read a certain type of data quickly to improve the final settlement efficiency. At the same time, some common operations can be performed in advance, such as the accumulation and averaging of certain types of data for a week, a month, a quarter, and a year (that is, to obtain the preprocessing Data), the results of these operations are stored in the value data warehouse, and the results of these operations can be obtained at any time in the process of final settlement, which saves some calculation steps and further improves the efficiency of final settlement.

As an optional implementation manner, the data settlement device 20 further includes:

a second determining module, configured to determine the source of the data to be settled when the data analysis instruction is received;

The third generation module is used for generating the first table according to the data to be finalized;

a marking module, configured to use preset multiple color blocks to mark pending settlement data from different sources in the first table to obtain a second table, wherein one source of pending settlement data corresponds to one color block;

The second output module is used for outputting the second table.

In this optional implementation manner, when a data analysis instruction is received, different color blocks can be used to mark the data to be settled from different sources, so that the data in the generated table is clear at a glance and facilitates analysis.

In the data final settlement device 20 described in FIG. 2 , the data to be finalized can be finalized according to the preset first final settlement formula through artificial intelligence technology, and verified, and then the finalized data that has passed the verification can be summarized, and then reported (sending the summary data to the preset device terminal), while ensuring the accuracy of the final settlement data, the efficiency of the data final settlement is also improved.

The present invention can be applied to the field of smart government affairs in smart cities, and helps government personnel to automatically perform final accounts of various annual reports and the like.

It should be emphasized that, in order to further ensure the privacy and security of the above-mentioned summary data, the above-mentioned summary data can also be stored in a node of a blockchain.

As shown in FIG. 3 , FIG. 3 is a schematic structural diagram of an electronic device according to a preferred embodiment of the data settlement method according to the present invention. The electronic device 3 includes a memory 31 , at least one processor 32 , a computer program 33 stored in the memory 31 and executable on the at least one processor 32 , and at least one communication bus 34 .

Those skilled in the art can understand that the schematic diagram shown in FIG. 3 is only an example of the electronic device 3, and does not constitute a limitation on the electronic device 3, and may include more or less components than those shown, or combinations thereof Certain components, or different components, for example, the electronic device 3 may also include input and output devices, network access devices, and the like.

The electronic device 3 also includes, but is not limited to, any electronic product that can interact with the user through a keyboard, a mouse, a remote control, a touchpad or a voice-activated device, for example, a personal computer, a tablet computer, a smart phone, Personal Digital Assistant (Personal Digital Assistant, PDA), game console, Internet Protocol Television (Internet Protocol Television, IPTV), smart wearable devices, etc. The network where the electronic device 3 is located includes but is not limited to the Internet, a wide area network, a metropolitan area network, a local area network, a virtual private network (Virtual Private Network, VPN) and the like.

The at least one processor 32 may be a central processing unit (Central Processing Unit, CPU), and may also be other general-purpose processors, digital signal processors (Digital Signal Processors, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC) ), Field-Programmable Gate Array (FPGA) or other programmable logic devices, transistor logic devices, discrete hardware components, etc. The processor 32 can be a microprocessor or the processor 32 can also be any conventional processor, etc. The processor 32 is the control center of the electronic device 3, and uses various interfaces and lines to connect the entire electronic device 3 of each part.

The memory 31 can be used to store the computer program 33 and/or modules/units, and the processor 32 executes or executes the computer programs and/or modules/units stored in the memory 31 and calls the computer programs and/or modules/units stored in the memory 31. 31 to realize various functions of the electronic device 3 . The memory 31 may mainly include a stored program area and a stored data area, wherein the stored program area may store an operating system, an application program required for at least one function (such as a sound playback function, an image playback function, etc.), etc.; the storage data area may Data and the like created according to the use of the electronic device 3 are stored. In addition, the memory 31 may include non-volatile memory, such as hard disk, internal memory, plug-in hard disk, Smart Media Card (SMC), Secure Digital (SD) card, Flash Card (Flash Card), at least A disk storage device, flash memory device, etc.

1, the memory 31 in the electronic device 3 stores a plurality of instructions to implement a data final calculation method, and the processor 32 can execute the plurality of instructions to implement:

Obtain the data to be finalized through the system interface and the preset data warehouse;

According to the preset first final settlement formula, final settlement is performed on the data to be finalized to obtain final settlement data;

Verifying the final settlement data to obtain a verification result, wherein the verification method includes according to a preset verification formula, and/or, according to a preset number fetching rule, and/or, using a table join operation for verification;

If the verification result is passed, the final settlement data is aggregated to obtain aggregated data;

The summary data is sent to a preset terminal.

Specifically, for the specific implementation method of the above-mentioned instruction by the processor 32, reference may be made to the description of the relevant steps in the corresponding embodiment of FIG. 1, and details are not described herein.

In the electronic device 3 described in Fig. 3, the data to be finalized can be finalized according to the preset first finalized formula by artificial intelligence technology, and the verification is performed, and then the finalized data that has passed the verification is summarized, and then reported ( The summary data is sent to the preset equipment terminal), which not only ensures the accuracy of the final settlement data, but also improves the efficiency of the data final settlement.

If the modules/units integrated in the electronic device 3 are implemented in the form of software functional units and sold or used as independent products, they may be stored in a computer-readable storage medium. Based on this understanding, the present invention can implement all or part of the processes in the methods of the above embodiments, and can also be completed by instructing relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium, and the computer When the program is executed by the processor, the steps of the foregoing method embodiments can be implemented. Wherein, the computer program code may be in the form of source code, object code, executable file or some intermediate form, and so on. The computer-readable medium may include: any entity or device capable of carrying the computer program code, a recording medium, a U disk, a removable hard disk, a magnetic disk, an optical disk, a computer memory, a read-only memory (ROM, Read-Only Memory) .

Further, the computer usable storage medium may mainly include a stored program area and a stored data area, wherein the stored program area may store an operating system, an application program required for at least one function, and the like; using the created data, etc.

The blockchain referred to in the present invention is a new application mode of computer technologies such as distributed data storage, point-to-point transmission, consensus mechanism, and encryption algorithm. Blockchain, essentially a decentralized database, is a series of data blocks associated with cryptographic methods. Each data block contains a batch of network transaction information to verify its Validity of information (anti-counterfeiting) and generation of the next block. The blockchain can include the underlying platform of the blockchain, the platform product service layer, and the application service layer.

In the several embodiments provided by the present invention, it should be understood that the disclosed system, apparatus and method may be implemented in other manners. For example, the apparatus embodiments described above are only illustrative. For example, the division of the modules is only a logical function division, and there may be other division manners in actual implementation.

The modules described as separate components may or may not be physically separated, and components shown as modules may or may not be physical units, that is, may be located in one place, or may be distributed to multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution in this embodiment.

In addition, each functional module in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically alone, or two or more units may be integrated into one unit. The above-mentioned integrated units can be implemented in the form of hardware, or can be implemented in the form of hardware plus software function modules.

It will be apparent to those skilled in the art that the present invention is not limited to the details of the above-described exemplary embodiments, but that the present invention may be embodied in other specific forms without departing from the spirit or essential characteristics of the invention. Therefore, the embodiments are to be regarded in all respects as illustrative and not restrictive, and the scope of the invention is to be defined by the appended claims rather than the foregoing description, which are therefore intended to fall within the scope of the claims. All changes within the meaning and range of the equivalents of , are included in the present invention. Any reference signs in the claims shall not be construed as limiting the involved claim. Furthermore, it is clear that the word "comprising" does not exclude other units or steps and the singular does not exclude the plural. Several units or means recited in the system claims can also be realized by one unit or means by means of software or hardware. Second-class terms are used to denote names and do not denote any particular order.

Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and not to limit them. Although the present invention has been described in detail with reference to the preferred embodiments, those of ordinary skill in the art should understand that the technical solutions of the present invention can be Modifications or equivalent substitutions can be made without departing from the spirit and scope of the technical solutions of the present invention.

Claims (10)

1. a data final accounting method, is characterized in that, described data final accounting method comprises: Obtain the data to be finalized through the system interface and the preset data warehouse; According to the preset first final settlement formula, final settlement is performed on the data to be finalized to obtain final settlement data; Verifying the final settlement data to obtain a verification result, wherein the verification method includes according to a preset verification formula, and/or, according to a preset number fetching rule, and/or, using a table join operation for verification; If the verification result is passed, the final settlement data is aggregated to obtain aggregated data; The summary data is sent to a preset terminal. 2. data final settlement method according to claim 1, is characterized in that, described final settlement data is verified, and obtaining verification result comprises: According to the first final settlement formula, re-final settlement is performed on the data to be finalized to obtain first verification data; Judging whether the final settlement data is consistent with the first verification data; If the final settlement data is consistent with the first verification data, it is determined that the verification result is passed; or If the final settlement data is inconsistent with the first verification data, it is determined that the verification result is not passed. 3. data final settlement method according to claim 1 is characterized in that, described final settlement data has multiple types, and described final settlement data is verified, and obtaining verification result comprises: Using a preset number-taking rule, for each type of final settlement data, obtain a preset numerical threshold range corresponding to the final settlement data; Judging whether the final settlement data is within the preset value threshold range; If the final settlement data is within the preset value threshold range, it is determined that the verification result is passed; or If the final settlement data is not within the preset value threshold range, it is determined that the verification result is not passed. 4. data final settlement method according to claim 1, is characterized in that, described final settlement data is verified, and obtaining verification result comprises: According to the fetch rule, obtain target data from the data interface or data table specified by the fetch rule; According to the second final settlement formula corresponding to the target data in the verification formula, determine the second verification data corresponding to the target data; From the final settlement data, determine the data to be verified corresponding to the target data; The target data, the second verification data and the to-be-verified data are table-joined to obtain a target data table; Querying whether there is a target row in the target data table, and the second verification data corresponding to the target row is inconsistent with the to-be-verified data corresponding to the target row; If there is no target row in the target data table, it is determined that the verification result is passed; if there is a target row in the target data table, it is determined that the verification result is not passed. 5. data final settlement method according to claim 4, is characterized in that, described data final settlement method also comprises: If the verification result is not passed, generate an alarm message; The alarm information is sent to the terminal of the manager. 6. The data final settlement method according to any one of claims 1 to 5, wherein the data to be finalized comprises the first data to be finalized and the second data to be finalized, and the data finalized method further comprises: Obtain pending final settlement data that has not been entered into the system; Preprocessing the data to be finalized that has not been entered into the system to obtain preprocessing data; storing the preprocessed data in the data warehouse; The acquisition of the data to be finalized through the system interface and the preset data warehouse includes: obtaining the first pending final settlement data through the system interface; Through the data warehouse, query and acquire the second pending final settlement data from the preprocessed data. 7. The data final accounting method according to any one of claims 1 to 5, wherein the data final accounting method further comprises: When receiving the data analysis instruction, determine the source of the data to be settled; generating a first table according to the data to be finalized; In the first table, the data to be settled from different sources is marked with a plurality of preset color blocks, and the second table is obtained, wherein the data to be settled from one source corresponds to one color block; The second table is output. 8. A data settlement device, characterized in that the data settlement device comprises: The acquisition module is used to acquire the data to be finalized through the system interface and the preset data warehouse; A final settlement module, configured to perform final settlement on the data to be finalized according to a preset first final settlement formula, and obtain final settlement data; A verification module, configured to verify the final settlement data to obtain a verification result, wherein the verification method includes according to a preset verification formula, and/or, according to a preset number-taking rule, and / or, use the table join operation to verify; a summary module, used for summarizing the final accounts data to obtain summary data if the verification result is passed; A sending module, configured to send the aggregated data to a preset terminal. 9. An electronic device, characterized in that, the electronic device comprises a processor and a memory, and the processor is used to execute a computer program stored in the memory to realize the data settlement according to any one of claims 1 to 7 method. 10. A computer-readable storage medium, wherein the computer-readable storage medium stores at least one instruction, and when the at least one instruction is executed by a processor, the implementation of any one of claims 1 to 7 is realized data settlement method.

Images