CN108090824B - Data checking method and device, computer equipment and readable storage medium - Google Patents
Data checking method and device, computer equipment and readable storage medium Download PDFInfo
- Publication number
- CN108090824B CN108090824B CN201711491747.1A CN201711491747A CN108090824B CN 108090824 B CN108090824 B CN 108090824B CN 201711491747 A CN201711491747 A CN 201711491747A CN 108090824 B CN108090824 B CN 108090824B
- Authority
- CN
- China
- Prior art keywords
- payment
- record
- same
- paid
- information
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/08—Insurance
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/105—Human resources
-
- 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
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- General Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Economics (AREA)
- Human Resources & Organizations (AREA)
- Physics & Mathematics (AREA)
- Marketing (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Entrepreneurship & Innovation (AREA)
- Data Mining & Analysis (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a data checking method, a device, computer equipment and a readable storage medium, wherein the method comprises the following steps: calculating according to a preset rule to obtain a payment-due standing book table, and receiving a real payment standing book table corresponding to the payment-due standing book table; acquiring the records to be paid with the same employee identification in the account table according to the sequence of the records to be paid in the account table to be paid; comparing whether the first preset information of the due payment records with the same employee identification is the same; when the first preset information of the due payment record with the same employee identification is the same, comparing whether the second preset information of the due payment record in the due payment ledger table is the same as the second preset information of the corresponding real payment record in the real payment ledger table; and when the second preset information of the account payable record in the account payable table is different from the second preset information of the corresponding real payment record in the real payment account table, outputting the information with inconsistent data. The data checking method, the data checking device, the computer equipment and the readable storage medium can improve the data checking efficiency.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a data checking method and apparatus, a computer device, and a readable storage medium.
Background
Social insurance is a non-profit social security system in which a majority of members of the society are forced to participate in order to prevent and share social risks such as aging, unemployment, diseases, death, and the like, and thus social security is realized. The accumulation fund refers to a company accumulation fund and a house accumulation fund. Each company pays a social security and a public accumulation fund to the employees.
Conventionally, in order to ensure the correct payment of social security and public deposit, companies arrange a large number of people to check whether the payment of social security and public deposit by each employee is correct or not every month, and in this case, the checking efficiency is low, and the manual checking is easy to make mistakes.
Disclosure of Invention
In view of the above, it is desirable to provide a data checking method, device, computer device and readable storage medium for improving the efficiency of checking social security public deposit.
A method of data collation, the method comprising:
calculating according to a preset rule to obtain a payment-due standing book table, and receiving a real payment standing book table corresponding to the payment-due standing book table;
acquiring the records to be paid with the same employee identification in the account table according to the sequence of the records to be paid in the account table to be paid;
comparing whether the first preset information of the due payment records with the same employee identification is the same;
when the first preset information of the due payment record with the same employee identification is the same, comparing whether second preset information of the due payment record in the due payment ledger table is the same as second preset information of the corresponding real payment record in the real payment ledger table;
when second preset information of the due payment record in the due payment ledger table is different from second preset information of the corresponding real payment record in the real payment ledger table, outputting information with inconsistent data; and when second preset information of the due payment record in the due payment ledger table is the same as second preset information of the corresponding real payment record in the real payment ledger table, outputting accurate data checking information.
In one embodiment, before the step of obtaining the records to be paid with the same employee identifier in the account book table according to the sequence of the records to be paid in the account book table, the method further includes:
judging whether the employee identification in the account table to be paid is different from the employee identification in the account table to be paid or not;
and when the employee identification in the account table to be paid is different from the employee identification in the account table to be actually paid, outputting a record to be paid in the account table to be paid which is different and a record to be actually paid in the account table to be actually paid which is different.
In one embodiment, the step of comparing whether the first preset information of the due payment records with the same employee identification is the same includes:
comparing whether the basic information of the records of the same employee identification is the same;
when the basic information of the due-payment records with the same employee identification is different, the due-payment records with different basic information are output, and whether the cardinal number information of the due-payment records with the same basic information is the same or not is continuously judged;
when the base number information of the due payment records with the same basic information is different, the first preset information of the due payment records with the same employee identification is different, and the due payment records with different base number information are output;
and when the basic information of the records to be paid is the same, the first preset information of the records to be paid, which is the same as the employee identification, is the same.
In one embodiment, the step of comparing whether the second preset information of the account payable record in the account payable form is the same as the second preset information of the corresponding real payment record in the real payment account form includes:
comparing whether the basic information of the account-paying record in the account-paying table is the same as the basic information of the corresponding real-paying record in the real-paying account-paying table;
when the basic information of the due payment record in the due payment ledger table is different from the basic information of the corresponding real payment record in the real payment ledger table, outputting the due payment record and the real payment record of which the basic information is different, and continuously judging whether the basic information of the due payment record and the real payment record of which the basic information is the same;
when the basic number information of the due payment record and the actual payment record which are the same in basic information is different, outputting the due payment record and the actual payment record which are different in basic number information, and continuously judging whether the amount information of the due payment record and the actual payment record which are the same in basic number information is the same;
when the amount information of the due payment record and the actual payment record with the same base number information is different, second preset information of the due payment record in the due payment ledger table is different from second preset information of the actual payment record corresponding to the actual payment ledger table, and the due payment record and the actual payment record with different amount information are output;
when the amount information of the due payment record and the amount information of the real payment record with the same cardinal number information are the same, the second preset information of the due payment record in the due payment ledger table is the same as the second preset information of the corresponding real payment record in the real payment ledger table.
In one embodiment, the step of calculating the account form to be paid according to the preset rule includes:
acquiring a general account of a to-be-calculated account table to be paid, and acquiring employee records under the general account;
receiving an input specified month transaction;
when the payment initiating effective month in the employee record is equal to the appointed handling month, judging whether payment initiating and supplementing are needed or not according to the payment initiating handling month and the payment initiating effective month in the employee record;
when the additional payment needs to be initiated, acquiring the base number and the proportion of the effective initiating month and each month needing the additional payment, and calculating the payment amount of the effective initiating month and the payment amount of the additional payment according to the base number and the proportion;
when the effective payment initiating month in the employee record is smaller than the appointed month, acquiring the base number and the proportion of the appointed month, and calculating the payment amount of the appointed month according to the base number and the proportion of the appointed month;
and generating a payment account table according to the calculated payment amount.
In one embodiment, the step of generating the account payable form according to the calculated payment amount further includes:
acquiring employee records with the types of individual compensation fees;
when the payment starting and handling month of the individual compensation and refund fee is equal to the appointed handling month, acquiring the base number and the proportion of each month from the payment starting month to the payment stopping month in the employee record of the individual compensation and refund fee type;
calculating to obtain an independent compensation amount according to the obtained base number and proportion of each month from the payment initiating month to the payment stopping month;
and generating a payment account table according to the calculated independent compensation fee and the calculated payment amount.
In one embodiment, the step of generating the payment due standing book table according to the calculated individual refund fee and the calculated payment amount further includes:
when the employee record has the adjusted amount, judging whether the month corresponding to the adjusted amount is equal to the appointed handled month or not;
and when the month corresponding to the adjustment amount is equal to the appointed handling month, generating a payment due standing book table according to the adjustment amount, the calculated independent compensation refund fee and the calculated payment amount.
A data collation apparatus, said apparatus comprising:
the acquisition module is used for calculating according to preset rules to obtain a payment-due standing book table and receiving a real payment standing book table corresponding to the payment-due standing book table;
the first judgment module is used for acquiring the records to be paid with the same employee identification in the account table according to the sequence of the records to be paid in the account table to be paid;
the first comparison module is used for comparing whether the first preset information of the due payment records with the same employee identification is the same or not;
the second comparison module is used for comparing whether second preset information of the records to be paid in the account table to be paid is the same as second preset information of the corresponding records to be paid in the account table to be paid when the first preset information of the records to be paid with the same employee identification is the same;
the output module is used for outputting information with inconsistent data when second preset information of the due-payment record in the due-payment ledger table is different from second preset information of the corresponding real-payment record in the real-payment ledger table; and when second preset information of the due payment record in the due payment ledger table is the same as second preset information of the corresponding real payment record in the real payment ledger table, outputting accurate data checking information.
A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of any of the methods described above when executing the computer program.
A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method of any of the preceding claims.
According to the data checking method, the data checking device, the computer equipment and the readable storage medium, first preset information of records to be paid with the same employee identification in the account table to be paid is matched, the correctness of the account table to be paid is guaranteed, then the account table to be paid is compared with the account table to be paid on the premise that the account table to be paid is correct, pre-screening is carried out, the comparison amount of the account table to be paid and the account table to be paid is reduced, and the comparison is carried out through the computer equipment, so that the efficiency is improved.
Drawings
FIG. 1 is a diagram illustrating an exemplary embodiment of a data collation method;
FIG. 2 is a flow diagram of a data collation method in one embodiment;
FIG. 3 is a flowchart of step S206 in the embodiment shown in FIG. 2;
FIG. 4 is a flowchart of step S208 in the embodiment shown in FIG. 2;
FIG. 5 is a flow chart of a data collation apparatus in one embodiment;
FIG. 6 is an internal block diagram of a computer device in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
Referring to fig. 1, fig. 1 is an application environment diagram of a data checking method in an embodiment, in which a social security center or a public deposit center communicates with a server through a network, and is configured to send a payment ledger table stored in the social security center or the public deposit center to the server, so that the server performs data checking. Wherein the server may be an independent server or a server cluster composed of a plurality of servers.
In one embodiment, referring to fig. 2, fig. 2 is a flowchart of a data checking method in an embodiment, which is described by taking the method as an example applied to the server in fig. 1, and the data checking method includes:
s202: and calculating according to a preset rule to obtain a payment account table, and receiving an actual payment account table corresponding to the payment account table.
Specifically, the preset rule is a rule which is preset in the server and can calculate the amount to be paid of each employee of each company, and the rule is stored in the server in advance, so that when the amount to be paid of the employee is calculated every month, the corresponding rule is directly called according to the employee identification, manual calculation is not needed, workload is reduced, and efficiency is improved. The account form to be paid can be calculated through the preset rule, and for example, the account form can be taken by a company or a department.
The real payment standing book table is generated after the settlement of the social security center or the public accumulation fund center is completed every month, and after the real payment standing book table is generated by the social security center or the public accumulation fund center, the real payment standing book table is sent to the server so as to facilitate the data check of the server. The sending time of the real payment standing book table may be agreed by the server with the social security center or the public deposit center, for example, may be within a preset time period before the data check time. And before the server performs data check, it may be determined in advance whether the acquired real payment ledger sheet is correct, for example, whether the format of the real payment ledger sheet is correct, and if not, the server may notify the social security center or the public deposit center in time to download the correct real payment ledger sheet from the social security center or the public deposit center again before the data check.
The account payable table and the real account payable table can be stored in a database of the server, and measures such as encryption and the like can be set in the database to prevent data from being tampered and the like.
S204: and acquiring the records to be paid with the same employee identification in the account table according to the sequence of the records to be paid in the account table to be paid.
Specifically, after the account payable table and the real account payable table are obtained, in order to reduce the comparison amount between the two tables, the account payable records in the account payable table are firstly compared to obtain the account payable records with the same employee identification. In particular, the employee identification can be determined by several different dimensions, for example by at least one of a name, a certificate number, a payment account, a payment location and a payment category as the employee identification. For convenience, the server sequentially judges according to the order of the records to be paid in the account table to be paid, for example, firstly inquires whether a record to be paid identical to a first record to be paid (as a current record to be paid) in the account table to be paid exists, if not, continuously inquires whether a record to be paid identical to a second record to be paid (as a current record to be paid) in the account table to be paid exists until all the records in the account table to be paid are inquired, if the record to be paid identical to the current record to be paid in the account table to be paid exists, the same record to be paid is marked, so that the record does not need to be compared in the next comparison process, and the comparison amount can be reduced.
Before the step of obtaining the records to be paid, in which the employee identifiers are the same, in the account table according to the sequence of the records to be paid in the account table, the method may further include: and comparing whether the general account information of the corresponding payment standing book table and the actual payment standing book table is the same, if the payment standing book table is generated by taking a company as a unit, the general account information is the company information, and if the payment standing book table is generated by taking a department as a unit, the general account information is the department information, and no specific limitation is imposed on the information. If the general account information of the account table to be paid is different from the general account information of the account table to be paid, the general account can be marked and output so as to search for errors in time. If one account-to-be-paid table or one real-paid table can include a plurality of accounts, it is necessary to compare one by one whether the accounts in the two tables are the same, and if not, for example, if the account exists in the account-to-be-paid table but does not exist in the real-paid table, or if the account exists in the real-paid table but does not exist in the account-to-be-paid table, the account can be output, or marked, for example, as a default account.
S206: and comparing whether the first preset information of the due payment records with the same employee identification is the same.
Specifically, in the account table to be paid, if there is a record to be paid with the same employee identifier, other first preset information of the record to be paid needs to be consistent, so as to ensure that all records to be paid in the account table to be paid are correct, and therefore, in order to ensure that all records to be paid compared with the records to be paid in the account table to be paid are correct, a pre-judgment is firstly performed on the record to be paid in the account table to be paid. In addition, if only one account payable record related to a certain employee identifier exists in the account payable table, pre-judgment of the account payable table is not required.
S208: and when the first preset information of the records to be paid with the same employee identification is the same, comparing whether the second preset information of the records to be paid in the account table to be paid is the same as the second preset information of the corresponding records to be paid in the account table to be paid.
Specifically, after the pre-judgment of the account table to be paid is finished, the records to be paid, which have the same employee identifier and different first preset information, in the account table to be paid, may be output to prompt the user that the records are different, and the records to be paid, which have the same employee identifier and the same first preset information, in the account table to be paid, and the records to be paid, which have the same employee identifier and the same first preset information, are compared with the records to be paid in the account table to judge whether the second preset information of the records to be paid in the account table to be paid is the same as the second preset information of the records to be paid, which are the same employee identifier, in the account table to be paid, so as to judge whether the records are correct. In addition, if only one account payable record related to a certain employee identifier exists in the account payable table, the account payable record can be directly compared with the corresponding real account payable record.
S210: and when the second preset information of the account payable record in the account payable table is different from the second preset information of the corresponding real payment record in the real payment account table, outputting the information with inconsistent data.
S212: and when the second preset information of the due payment record in the due payment ledger table is the same as the second preset information of the corresponding real payment record in the real payment ledger table, outputting accurate data checking information.
Specifically, when the second preset information of the due-payment record in the due-payment ledger table is different from the second preset information of the corresponding real-payment record in the real-payment ledger table, the information with inconsistent data is directly output, so that the user can know the error data in time, for example, the due-payment record and the real-payment record with inconsistent data can be directly output in a correlated manner, and the place with inconsistent data is marked. And if the second preset information of the due payment record in the due payment ledger table is the same as the second preset information of the corresponding real payment record in the real payment ledger table, indicating that the data check is accurate.
The payment record may include different payment types, such as normal payment, additional payment initiation, separate additional payment, separate payment, refund payment with a refund base number difference, fixed adjustment amount, and the like, and the different payment types may be checked according to the checking method.
According to the data checking method, the first preset information of the account to be paid records with the same employee identification in the account table to be paid is matched, the correctness of the account table to be paid is guaranteed, then the account table to be paid is compared with the account table to be paid on the premise that the account table to be paid is correct, pre-screening is conducted, the comparison amount of the account table to be paid and the account table to be paid is reduced, and comparison is conducted through computer equipment, so that the efficiency is improved.
In one embodiment, before the step of obtaining the records to be paid with the same employee identifier in the account book table according to the sequence of the records to be paid in the account book table, that is, before step S204, the method may further include: judging whether the employee identification in the account table to be paid is different from the employee identification in the account table to be paid; and when the employee identification in the account table to be paid is different from the employee identification in the account table to be paid, outputting the record to be paid in the account table to be paid with the difference and the record to be paid in the account table to be paid with the difference.
Specifically, in order to ensure the consistency of the data of the account payable table and the real-payment account table, it may be determined whether the employee identifier in the account payable table and the employee identifier in the real-payment account table are different, so that only by pre-determination, records in the account payable table that are inconsistent with the employee identifier in the real-payment account table may be removed first to reduce subsequent comparison amount, for example, when a certain employee identifier exists in the account payable table but does not exist in the real-payment account table, the account payable record in the account payable table may be output, and a prompt default real-payment record may be output; if a certain employee identifier exists in the real payment standing book but does not exist in the account to be paid, the real payment record in the real payment standing book can be output, and a prompt for the default account to be paid is output. Therefore, the payment records of the account to be paid and the payment records of the account to be paid are output, so that the next processing is convenient.
The output mode may be sending the output data to a mailbox reserved for a corresponding account, or sending the output data to a WeChat corresponding to the account, or notifying a user corresponding to the account of downloading the output data from a server in a short message manner.
In the above embodiment, by comparing the employee identifiers of the account to be paid and the account to be paid in advance, the payment records that are added to the account to be paid and the account to be paid can be output in advance, so that the processing amount of subsequent data is reduced, and the processing efficiency can be improved.
In one embodiment, referring to fig. 3, fig. 3 is a flowchart of step S206 in the embodiment shown in fig. 2, and the step of comparing whether the first preset information of the employee identifiers that are the same in the due-payment record is the same, that is, step S206 may include:
s302: and comparing whether the basic information of the due payment records with the same employee identification is the same.
The basic information comprises at least one of social insurance registration attribute, insurance participation plan, social insurance personal number, endowment insurance personal number, medical insurance personal number, unemployment insurance personal number, industrial injury insurance personal number, fertility insurance personal number and employee number. When the employee identifiers are the same, whether the basic information of the records to be paid, in which the employee identifiers are the same, in the account table to be paid is the same or not can be sequentially compared.
S304: and when the basic information of the due-payment records with the same employee identification is different, outputting the due-payment records with different basic information, and continuously judging whether the cardinal number information of the due-payment records with the same basic information is the same.
Specifically, when the basic information of the due payment records with the same employee identification is different, the due payment records with different basic information are directly output, so that the due payment records do not participate in subsequent comparison any more. When the basic information of the due payment records with the same employee identification is the same, whether the basic information of the due payment records with the same basic information is the same or not can be further compared.
The base number information comprises at least one of a care insurance company payment base number, a care insurance individual payment base number, a medical insurance company payment base number, a medical insurance individual payment base number, an unemployed insurance company payment base number, an unemployed insurance individual payment base number, an industry insurance company payment base number, a fertility insurance company payment base number, a supplementary medical insurance company payment base number and a supplementary medical insurance individual payment base number.
S306: when the basic information of the records to be paid is the same, the employee marks the same first preset information of the records to be paid are different, and the records to be paid with different basic information are output.
When the basic number information of the due-payment records with the same basic information is different, the due-payment records with different basic number information can be output, so that the due-payment records do not participate in the subsequent comparison process, and the comparison amount of data can be reduced.
S308: and when the basic information of the records to be paid is the same, the first preset information of the records to be paid with the same employee identification is the same.
When the basic information of the records to be paid is the same, the first preset information of the records to be paid with the same employee identification is the same, so that the records to be paid can participate in the subsequent matching with the records to be paid in the real payment standing book table.
In the above embodiment, the due-payment records with the same employee identifier are compared first, and the information that an error exists in the due-payment record can be output first, so that the matching amount with the actual payment record in the actual payment standing book table can be reduced, and in addition, according to different output time periods, a data checking error caused by an internal calculation error reason (for example, caused by an error in the due-payment standing book table) or an external error reason (for example, caused by a comparison error between the due-payment standing book table and the actual payment standing book table) of the server can be determined, so that a subsequent query error is facilitated.
In one embodiment, referring to fig. 4, fig. 4 is a flowchart of step S208 in the embodiment shown in fig. 2, and the step S208 of comparing whether the second preset information of the due record in the due ledger table is the same as the second preset information of the corresponding due record in the due ledger table may include:
s402: and comparing whether the basic information of the account-paying record in the account-paying table is the same as the basic information of the corresponding real-paying record in the real-paying account-paying table.
The basic information here is the same as the basic information in the first preset information, and is not described herein again.
When the basic information of the account record in the account table is the same as the basic information of the corresponding real-payment record in the real-payment account table, the next judgment is continued, for example, the cardinal number information is continuously judged.
S404: when the basic information of the due-payment record in the due-payment ledger table is different from the basic information of the corresponding real-payment record in the real-payment ledger table, the due-payment record and the real-payment record with different basic information are output, and whether the basic information of the due-payment record and the real-payment record with the same basic information is the same or not is continuously judged.
Specifically, when the basic information of the due-payment record in the due-payment ledger table is different from the basic information of the corresponding real-payment record in the real-payment ledger table, the different due-payment record and the different real-payment record are directly output, so that the due-payment record and the real-payment record do not participate in subsequent comparison, and the subsequent comparison amount can be reduced. After the output, it is continuously determined whether the cardinal number information of the due payment record and the actual payment record, which have the same basic information, is the same, where the cardinal number information is the same as the cardinal number information in the above, and the description thereof is omitted.
S406: and when the basic number information of the due payment record and the actual payment record with the same basic information is different, outputting the due payment record and the actual payment record with different basic number information, and continuously judging whether the amount information of the due payment record and the actual payment record with the same basic number information is the same.
Specifically, when the base number information of the due payment record and the actual payment record with the same basic information is different, the due payment record and the actual payment record with different base number information are output, so that the due payment record and the actual payment record do not participate in subsequent comparison, and the subsequent comparison amount can be reduced. After the output, whether the sum information of the due payment record and the actual payment record with the same base number information is the same or not is continuously judged.
The calculation method of the amount information is related to the payment type, when the payment type is normal payment, each risk type of the normal payment type in the account table of the accounts to be paid is obtained, the amount calculation rule corresponding to the risk type is obtained, the sum of the amounts of the individuals/companies is calculated according to the amount calculation rule and is compared with the sum of the amounts of the same risk type of the normal payment type in the account table of the actual payment, if the amounts are different, the difference and the specific amount of the difference of the amounts of the companies/individuals to be paid are marked, and the account information of the accounts to be paid and the actual payment of the employee is output. When the payment type is other, the account to be paid is calculated as follows according to the risk: (the total amount of the initiating and reimbursement + the total amount of the independent reimbursement + the total amount of the cardinal number reimbursement) -the total amount of the independent refund. When the types are not distinguished, then the calculation can be made by the following formula: the payment account of the employee in the current month is the sum of the normal payment type, the fixed adjustment sum of the normal payment type, the sum of the payment initiating type, the fixed adjustment sum of the payment initiating type, the sum of the single payment supplementing type, the fixed adjustment sum of the single payment supplementing type, the sum of the single refund type and the sum of the compensation payment/refund base number difference type.
S408: when the amount information of the due payment record and the actual payment record with the same base number information is different, the second preset information of the due payment record in the due payment ledger table is different from the second preset information of the actual payment record corresponding to the actual payment ledger table, and the due payment record and the actual payment record with different amount information are output.
S410: when the amount information of the due payment record and the amount information of the real payment record with the same cardinal number information are the same, the second preset information of the due payment record in the due payment ledger table is the same as the second preset information of the corresponding real payment record in the real payment ledger table.
When the amount information of the due-payment record and the actual-payment record with the same base number information is different, the due-payment record in the due-payment platform account table and the actual-payment record in the actual-payment platform account table are output to facilitate subsequent confirmation and the like, and when the amount information of the due-payment record and the actual-payment record with the same base number information is the same, the fact that the payment record has no problem is shown.
After the error payment record of the account table to be paid and the account table to be paid actually is output, the user can check the error payment record and perform the next processing according to the error type, for example, when the internal error of the account table to be paid currently occurs, only the internal information needs to be confirmed, but if the account table to be paid and the account table to be paid actually are different, the user may need to be butted with a social security center or a public deposit center so as to change the corresponding data.
In the above embodiment, the basic information, the base number information and the amount information of the due payment record and the actual payment record with the same employee identifier are sequentially compared, so that the wrong payment record is output step by step, the subsequent comparison amount is reduced, and meanwhile, the wrong payment record can be classified and counted according to the error type, thereby facilitating the subsequent classification processing of the wrong payment record.
In one embodiment, the step of calculating the account form to be paid according to the preset rule, that is, the step S202 may include: acquiring a general account of a to-be-calculated account table to be paid, and acquiring employee records under the general account; receiving an input specified month transaction; when the payment initiating effective month in the employee record is equal to the appointed handling month, judging whether to initiate payment compensation according to the payment initiating handling month and the payment initiating effective month in the employee record; when the additional payment needs to be initiated, acquiring the base number and the proportion of the effective initiating month and each month needing the additional payment, and calculating the payment amount of the effective initiating month and the payment amount of the additional payment according to the base number and the proportion; when the effective payment initiating month in the employee record is smaller than the appointed month, acquiring the base number and the proportion of the appointed month, and calculating the payment amount of the appointed month according to the base number and the proportion of the appointed month; and generating a payment account table according to the calculated payment amount.
Specifically, the account table includes a social security attribute table, a reimbursement fee refunding base difference and a fixed adjustment amount, wherein the social security attribute table includes a normal payment type, a payment initiating and reimbursing type, an individual reimbursement type and an individual fee refunding type. In this embodiment, a general account, such as a company account, of a to-be-calculated account table to be paid is first obtained, then employee records under the general account are obtained, and a specified month of transaction input by a user is received, for example, if the user wants to calculate the account table to be paid for 9 months, the specified month of transaction is 9 months. The month initiating and dealing refers to the month when a new employee starts to pay social security and public deposit when entering work, and the month initiating and dealing taking effect is the month when the account takes effect after the personnel department registers in the social security center or the public deposit center. When the payment initiating effective month is equal to the appointed payment handling month, whether the payment initiating effective month is smaller than the payment initiating handling month needs to be judged, if the payment initiating effective month is smaller than the payment handling month, the payment initiating and supplementing are required to be judged, therefore, the base number and the proportion of each month of the payment initiating effective month and the payment requiring the payment initiating and supplementing are obtained, and the payment amount of the payment initiating effective month and the payment amount of the payment initiating and supplementing are calculated according to the base number and the proportion. The base numbers and the proportions are input by personnel in advance when the staff enters the job. And when the effective payment starting month in the employee record is smaller than the appointed month and is not in the payment stopping state, the employee is indicated as the employee who normally pays, so that the base number and the proportion of the appointed month are obtained, and the payment amount of the appointed month is calculated according to the base number and the proportion of the appointed month. The base numbers and the proportions are input by personnel in advance when the staff enters the job. And calculating the payment amount of each employee according to the above, and generating a payment account table according to the calculated payment amount after the payment amounts of all the employees are calculated.
In the embodiment, whether the additional payment needs to be initiated or not can be judged according to the effective and command-processed month of initiating the payment, if the additional payment needs to be initiated, the pre-stored base number and proportion of the additional payment initiating and initiating in the system are acquired, so that the corresponding additional payment amount can be accurately generated, if the additional payment does not need to be initiated, the pre-stored normal base number and proportion in the system are directly acquired, and the normal payment amount can be acquired according to the normal base number and proportion, so that the account table to be paid is generated.
In one embodiment, the step of generating the account payable form according to the calculated payment amount may further include: acquiring employee records with the types of individual compensation fees; when the payment starting and handling month of the independent compensation and refund fee is equal to the appointed handling month, acquiring the base number and the proportion of each month from the payment starting month to the payment stopping month in the employee record of the independent compensation and refund fee type; calculating to obtain an independent compensation amount according to the obtained base number and proportion of each month from the payment initiating month to the payment stopping month; and generating a payment account table according to the calculated independent compensation fee and the calculated payment amount.
Specifically, the individual compensation payment type comprises an individual compensation payment type and an individual payment refund type, when the individual compensation payment type or the individual payment type exists in the employee record, the employee pay base number is called according to the corresponding payment month when the payment starting month is equal to the designated payment month according to the individual compensation payment or the individual payment is equal to the designated payment month, an effective pay base number of the latest creation time of the employee base number of the payment month which is less than or equal to the corresponding payment month is taken as the base number of the individual compensation payment or the base number of the individual payment, the compensation proportion of the latest created effective pay is taken as the proportion of the effective pay month which is less than or equal to the corresponding payment month, and the amount of the individual compensation payment is calculated according to the obtained base number and proportion of each month from the payment starting month to the payment stopping month.
In the embodiment, different payment types are fully considered, the account table to be paid is perfected according to different payment types, and the adaptability of the account table to be paid is improved.
In one embodiment, the step of generating the payment due standing book table according to the calculated individual refund fee and the calculated payment amount may further include: when the adjusted amount exists in the employee record, judging whether the month corresponding to the adjusted amount is equal to the appointed month handling; and when the month corresponding to the adjustment amount is equal to the appointed handling month, generating a payment account table according to the adjustment amount, the calculated independent compensation fee and the calculated payment amount.
Specifically, a fixed amount adjustment table and a compensation/refund base number difference table are obtained according to account information and appointed months for transaction, and when the months for normal payment, compensation starting and independent compensation are within the range from the effective month for starting adjustment to the effective month for stopping adjustment of the fixed amount adjustment (the judgment is carried out respectively every month), the fixed adjustment amount is added to the amounts for normal payment, compensation starting and independent refund; when the handling month of the compensation/refund base number difference is equal to the designated handling month, from the initiation of the payment to the month, calculating the sum difference between the adjusted base number multiplied by the proportion and the adjusted base number multiplied by the proportion in each month, namely the compensation/refund base number of each month, and then calculating the total payment sum.
In the embodiment, different payment types are fully considered, the account table to be paid is perfected according to different payment types, and the adaptability of the account table to be paid is improved.
It should be understood that although the various steps in the flow charts of fig. 2-4 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least some of the steps in fig. 2-4 may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performance of the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternating with other steps or at least some of the sub-steps or stages of other steps.
Referring to fig. 5, fig. 5 is a flowchart of a data verification apparatus according to an embodiment, the apparatus includes:
the obtaining module 100 is configured to obtain a payment-due standing book table according to a preset rule, and receive an actual payment standing book table corresponding to the payment-due standing book table.
The first judging module 200 is configured to obtain records to be paid, which have the same employee identifier and are in the account table to be paid, according to the sequence of the records to be paid in the account table to be paid.
The first comparing module 300 is configured to compare whether the first preset information of the due payment records with the same employee identifier is the same.
The second comparing module 400 is configured to compare whether the second preset information of the record to be paid in the account table to be paid is the same as the second preset information of the corresponding record to be paid in the account table to be paid when the first preset information of the record to be paid with the same employee identifier is the same.
The output module 500 is configured to output information with inconsistent data when second preset information of the due-payment record in the due-payment ledger table is different from second preset information of the corresponding real-payment record in the real-payment ledger table; and when the second preset information of the due payment record in the due payment ledger table is the same as the second preset information of the corresponding real payment record in the real payment ledger table, outputting accurate data checking information.
In one embodiment, the data checking apparatus may further include:
and the second judgment module is used for judging whether the employee identification in the account table to be paid is different from the employee identification in the account table to be actually paid or not before the records to be paid, which are the same as the employee identification in the account table to be paid, are obtained according to the sequence of the records to be paid in the account table to be paid.
The output module 500 is further configured to output a due payment record in the due payment account table having a difference and a due payment record in the due payment account table having a difference when the employee identifier in the due payment account table and the employee identifier in the due payment account table have a difference.
In one embodiment, the first comparing module 300 may include:
and the first basic information comparison unit is used for comparing whether the basic information of the due payment records with the same employee identification is the same.
And the first base number information comparison unit is used for outputting the records to be paid with different basic information when the basic information of the records to be paid with the same employee identification is different, and continuously judging whether the base number information of the records to be paid with the same basic information is the same.
The first comparison result output unit is used for outputting the records to be paid with different base number information when the base number information of the records to be paid with the same basic information is different, and the first preset information of the records to be paid with the same employee identification is different; and when the basic information of the records to be paid is the same, the first preset information of the records to be paid with the same employee identification is the same.
In one embodiment, the second comparing module 400 may include:
and the second basic information comparison unit is used for comparing whether the basic information of the due-payment record in the due-payment ledger table is the same as the basic information of the corresponding real-payment record in the real-payment ledger table.
And the second base number information comparison unit is used for outputting the records to be paid and the records to be paid which are different in basic information when the basic information of the records to be paid in the account table to be paid is different from the basic information of the corresponding records to be paid in the account table to be paid, and continuously judging whether the base number information of the records to be paid and the records to be paid which are the same in basic information is the same.
And the amount information comparison unit is used for outputting the due payment record and the actual payment record with different base number information when the base number information of the due payment record and the actual payment record with the same basic information is different, and continuously judging whether the amount information of the due payment record and the actual payment record with the same base number information is the same.
A second comparison result output unit, configured to, when the amount information of the due-payment record and the actual-payment record that are the same in base number information is different, make a second preset information of the due-payment record in the due-payment ledger table different from a second preset information of the actual-payment record corresponding to the actual-payment ledger table, and output the due-payment record and the actual-payment record that are different in amount information; when the amount information of the due payment record and the amount information of the real payment record with the same cardinal number information are the same, the second preset information of the due payment record in the due payment ledger table is the same as the second preset information of the corresponding real payment record in the real payment ledger table.
In one embodiment, the obtaining module 100 may include:
and the employee record acquisition unit is used for acquiring a general account of the account table to be calculated and to-be-paid, and acquiring employee records under the general account.
And the receiving unit is used for receiving the input appointed month handling.
And the payment initiating and supplementing judgment unit is used for judging whether to initiate the payment supplementing according to the payment initiating and processing month and the payment initiating and validating month in the employee record when the payment initiating and validating month in the employee record is equal to the appointed processing month.
The first calculation unit is used for acquiring the base numbers and the proportions of the payment initiating effective month and each month needing the payment initiating and supplementing when the payment initiating and supplementing are needed, and calculating the payment amount of the payment initiating effective month and the payment amount of the payment initiating and supplementing according to the base numbers and the proportions.
And the second calculation unit is used for acquiring the base number and the proportion of the appointed month handling when the effective payment initiating month in the employee record is smaller than the appointed month handling, and calculating the payment amount of the appointed month handling according to the base number and the proportion of the appointed month handling.
And the first generating unit is used for generating a payment account table according to the calculated payment amount.
In one embodiment, the first generating unit may include:
and the individual compensation fee obtaining unit is used for obtaining the employee record of which the type is the individual compensation fee.
The third calculating unit is used for acquiring the base number and the proportion of each month from the payment starting month to the payment stopping month in the employee record of the independent compensation and refund type when the payment starting and refund transacting month of the independent compensation and refund is equal to the appointed transacting month; and calculating to obtain the independent compensation amount according to the base number and the proportion of each month from the payment initiating month to the payment stopping month.
And the second generation unit is used for generating a payment account table according to the calculated independent compensation fee and the calculated payment amount.
In one embodiment, the second generating unit may include:
and the adjustment amount judging unit is used for judging whether the month corresponding to the adjustment amount is equal to the appointed handled month or not when the adjustment amount exists in the employee record.
And the third generating unit is used for generating a payment due standing book table according to the adjustment amount, the calculated independent compensation fee and the calculated payment amount when the month corresponding to the adjustment amount is equal to the appointed handling month.
In one embodiment, a computer device is provided, the computer device is a server shown in fig. 1, and the internal structure diagram of the computer device can be shown in fig. 6. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer equipment is used for storing the account table to be paid and the account table to be paid actually. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a data collation method.
Those skilled in the art will appreciate that the architecture shown in fig. 6 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program: calculating according to a preset rule to obtain a payment-due standing book table, and receiving a real payment standing book table corresponding to the payment-due standing book table; acquiring the records to be paid with the same employee identification in the account table according to the sequence of the records to be paid in the account table to be paid; comparing whether the first preset information of the due payment records with the same employee identification is the same; when the first preset information of the due payment record with the same employee identification is the same, comparing whether the second preset information of the due payment record in the due payment ledger table is the same as the second preset information of the corresponding real payment record in the real payment ledger table; when second preset information of the due payment record in the due payment ledger table is different from second preset information of the corresponding real payment record in the real payment ledger table, outputting information with inconsistent data; and when the second preset information of the due payment record in the due payment ledger table is the same as the second preset information of the corresponding real payment record in the real payment ledger table, outputting accurate data checking information.
In one embodiment, before the step of obtaining the records to be paid with the same employee identifier in the account payable table according to the order of the records to be paid in the account payable table when the processor executes the computer program, the method may further include: judging whether the employee identification in the account table to be paid is different from the employee identification in the account table to be paid; and when the employee identification in the account table to be paid is different from the employee identification in the account table to be paid, outputting the record to be paid in the account table to be paid with the difference and the record to be paid in the account table to be paid with the difference.
In one embodiment, the step of comparing whether the first preset information of the employee identity identical to the first preset information of the due record is identical when the processor executes the computer program may include: comparing whether the basic information of the due payment records with the same employee identification is the same; when the basic information of the due-payment records with the same employee identification is different, the due-payment records with different basic information are output, and whether the cardinal number information of the due-payment records with the same basic information is the same or not is continuously judged; when the base numbers of the records to be paid with the same basic information are different, the first preset information of the records to be paid with the same employee identification is different, and the records to be paid with different base numbers are output; and when the basic information of the records to be paid is the same, the first preset information of the records to be paid with the same employee identification is the same.
In one embodiment, the step of comparing whether the second preset information of the due record in the due ledger table is the same as the second preset information of the corresponding real payment record in the real payment ledger table when the processor executes the computer program may include: comparing whether the basic information of the account-paying record in the account-paying table is the same as the basic information of the corresponding real-paying record in the real-paying account-paying table; when the basic information of the due-payment record in the due-payment ledger table is different from the basic information of the corresponding real-payment record in the real-payment ledger table, outputting the due-payment record and the real-payment record with different basic information, and continuously judging whether the basic information of the due-payment record and the real-payment record with the same basic information is the same; when the basic number information of the due payment record and the actual payment record with the same basic information is different, outputting the due payment record and the actual payment record with different basic number information, and continuously judging whether the amount information of the due payment record and the actual payment record with the same basic number information is the same; when the amount information of the due payment record and the actual payment record with the same base number information is different, the second preset information of the due payment record in the due payment ledger table is different from the second preset information of the actual payment record corresponding to the actual payment ledger table, and the due payment record and the actual payment record with different amount information are output; when the amount information of the due payment record and the amount information of the real payment record with the same cardinal number information are the same, the second preset information of the due payment record in the due payment ledger table is the same as the second preset information of the corresponding real payment record in the real payment ledger table.
In one embodiment, the step of calculating the account payable table according to the preset rule when the processor executes the computer program may include: acquiring a general account of a to-be-calculated account table to be paid, and acquiring employee records under the general account; receiving an input specified month transaction; when the payment initiating effective month in the employee record is equal to the appointed handling month, judging whether to initiate payment compensation according to the payment initiating handling month and the payment initiating effective month in the employee record; when the additional payment needs to be initiated, acquiring the base number and the proportion of the effective initiating month and each month needing the additional payment, and calculating the payment amount of the effective initiating month and the payment amount of the additional payment according to the base number and the proportion; when the effective payment initiating month in the employee record is smaller than the appointed month, acquiring the base number and the proportion of the appointed month, and calculating the payment amount of the appointed month according to the base number and the proportion of the appointed month; and generating a payment account table according to the calculated payment amount.
In one embodiment, the step of generating the account payable form according to the calculated payment amount, which is implemented when the processor executes the computer program, may further include: acquiring employee records with the types of individual compensation fees; when the payment starting and handling month of the independent compensation and refund fee is equal to the appointed handling month, acquiring the base number and the proportion of each month from the payment starting month to the payment stopping month in the employee record of the independent compensation and refund fee type; calculating to obtain an independent compensation amount according to the obtained base number and proportion of each month from the payment initiating month to the payment stopping month; and generating a payment account table according to the calculated independent compensation fee and the calculated payment amount.
In one embodiment, the step of generating the payment due standing book table according to the calculated individual refund fee and the calculated payment amount when the processor executes the computer program further includes: when the adjusted amount exists in the employee record, judging whether the month corresponding to the adjusted amount is equal to the appointed month handling; and when the month corresponding to the adjustment amount is equal to the appointed handling month, generating a payment account table according to the adjustment amount, the calculated independent compensation fee and the calculated payment amount.
In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored, which when executed by a processor performs the steps of: calculating according to a preset rule to obtain a payment-due standing book table, and receiving a real payment standing book table corresponding to the payment-due standing book table; acquiring the records to be paid with the same employee identification in the account table according to the sequence of the records to be paid in the account table to be paid; comparing whether the first preset information of the due payment records with the same employee identification is the same; when the first preset information of the due payment record with the same employee identification is the same, comparing whether the second preset information of the due payment record in the due payment ledger table is the same as the second preset information of the corresponding real payment record in the real payment ledger table; when second preset information of the due payment record in the due payment ledger table is different from second preset information of the corresponding real payment record in the real payment ledger table, outputting information with inconsistent data; and when the second preset information of the due payment record in the due payment ledger table is the same as the second preset information of the corresponding real payment record in the real payment ledger table, outputting accurate data checking information.
In an embodiment, before the step of obtaining the records of due payment with the same employee identifier in the account book table according to the order of the records of due payment in the account book table when the computer program is executed by the processor, the method may further include: judging whether the employee identification in the account table to be paid is different from the employee identification in the account table to be paid; and when the employee identification in the account table to be paid is different from the employee identification in the account table to be paid, outputting the record to be paid in the account table to be paid with the difference and the record to be paid in the account table to be paid with the difference.
In one embodiment, the step of comparing whether the first preset information of the employee identification of the same due record is the same when the computer program is executed by the processor may include: comparing whether the basic information of the due payment records with the same employee identification is the same; when the basic information of the due-payment records with the same employee identification is different, the due-payment records with different basic information are output, and whether the cardinal number information of the due-payment records with the same basic information is the same or not is continuously judged; when the base numbers of the records to be paid with the same basic information are different, the first preset information of the records to be paid with the same employee identification is different, and the records to be paid with different base numbers are output; and when the basic information of the records to be paid is the same, the first preset information of the records to be paid with the same employee identification is the same.
In one embodiment, the step of comparing whether the second preset information of the due record in the due ledger table is the same as the second preset information of the corresponding real payment record in the real payment ledger table when the computer program is executed by the processor may include: comparing whether the basic information of the account-paying record in the account-paying table is the same as the basic information of the corresponding real-paying record in the real-paying account-paying table; when the basic information of the due-payment record in the due-payment ledger table is different from the basic information of the corresponding real-payment record in the real-payment ledger table, outputting the due-payment record and the real-payment record with different basic information, and continuously judging whether the basic information of the due-payment record and the real-payment record with the same basic information is the same; when the basic number information of the due payment record and the actual payment record with the same basic information is different, outputting the due payment record and the actual payment record with different basic number information, and continuously judging whether the amount information of the due payment record and the actual payment record with the same basic number information is the same; when the amount information of the due payment record and the actual payment record with the same base number information is different, the second preset information of the due payment record in the due payment ledger table is different from the second preset information of the actual payment record corresponding to the actual payment ledger table, and the due payment record and the actual payment record with different amount information are output; when the amount information of the due payment record and the amount information of the real payment record with the same cardinal number information are the same, the second preset information of the due payment record in the due payment ledger table is the same as the second preset information of the corresponding real payment record in the real payment ledger table.
In one embodiment, the step of calculating the account payable form according to the preset rule when the computer program is executed by the processor may include: acquiring a general account of a to-be-calculated account table to be paid, and acquiring employee records under the general account; receiving an input specified month transaction; when the payment initiating effective month in the employee record is equal to the appointed handling month, judging whether to initiate payment compensation according to the payment initiating handling month and the payment initiating effective month in the employee record; when the additional payment needs to be initiated, acquiring the base number and the proportion of the effective initiating month and each month needing the additional payment, and calculating the payment amount of the effective initiating month and the payment amount of the additional payment according to the base number and the proportion; when the effective payment initiating month in the employee record is smaller than the appointed month, acquiring the base number and the proportion of the appointed month, and calculating the payment amount of the appointed month according to the base number and the proportion of the appointed month; and generating a payment account table according to the calculated payment amount.
In one embodiment, the step of generating the account payable form according to the calculated payment amount, which is implemented when the computer program is executed by the processor, may further include: acquiring employee records with the types of individual compensation fees; when the payment starting and handling month of the independent compensation and refund fee is equal to the appointed handling month, acquiring the base number and the proportion of each month from the payment starting month to the payment stopping month in the employee record of the independent compensation and refund fee type; calculating to obtain an independent compensation amount according to the obtained base number and proportion of each month from the payment initiating month to the payment stopping month; and generating a payment account table according to the calculated independent compensation fee and the calculated payment amount.
In one embodiment, the step of generating the payable standing book table according to the calculated individual refund fee and the calculated payment amount when the computer program is executed by the processor further includes: when the adjusted amount exists in the employee record, judging whether the month corresponding to the adjusted amount is equal to the appointed month handling; and when the month corresponding to the adjustment amount is equal to the appointed handling month, generating a payment account table according to the adjustment amount, the calculated independent compensation fee and the calculated payment amount.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
The technical features of the embodiments described above may be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the embodiments described above are not described, but should be considered as being within the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A method for data collation, the method comprising:
calculating according to preset rules stored in a server to obtain a payment-due standing book table, and receiving a real payment standing book table corresponding to the payment-due standing book table, wherein the real payment standing book table is generated after a social security center or a public accumulation fund center settles every month and comprises real payment records; before the server checks the data, judging whether the acquired real payment account table is correct or not according to the format of the real payment account table;
acquiring the records to be paid with the same employee identification in the account table according to the sequence of the records to be paid in the account table to be paid, and marking the same records to be paid when the records to be paid are the same as the current records to be paid in the account table to be paid;
comparing whether the first preset information of the due payment records with the same employee identification is the same; outputting the account payable records with the same employee identification but different first preset information in the account payable table;
when the first preset information of the due payment record with the same employee identification is the same, comparing whether second preset information of the due payment record in the due payment ledger table is the same as second preset information of the corresponding actual payment record in the actual payment ledger table;
when second preset information of the due payment record in the due payment ledger table is different from second preset information of the corresponding real payment record in the real payment ledger table, the due payment record and the real payment record with inconsistent data are output in a correlation mode;
when second preset information of the due payment record in the due payment ledger table is the same as second preset information of the corresponding real payment record in the real payment ledger table, outputting accurate data checking information;
and inquiring errors according to the time period of information output.
2. The method according to claim 1, wherein before the step of obtaining the records of due payment with the same employee identification in the account table of due payment according to the sequence of the records of due payment in the account table of due payment, the method further comprises:
judging whether the employee identification in the account table to be paid is different from the employee identification in the account table to be paid or not;
and when the employee identification in the account table to be paid is different from the employee identification in the account table to be actually paid, outputting a record to be paid in the account table to be paid which is different and a record to be actually paid in the account table to be actually paid which is different.
3. The method according to claim 1 or 2, wherein the step of comparing whether the first preset information of the due records with the same employee identification is the same comprises:
comparing whether the basic information of the records of the same employee identification is the same;
when the basic information of the due-payment records with the same employee identification is different, the due-payment records with different basic information are output, and whether the cardinal number information of the due-payment records with the same basic information is the same or not is continuously judged;
when the base number information of the due payment records with the same basic information is different, the first preset information of the due payment records with the same employee identification is different, and the due payment records with different base number information are output;
and when the basic information of the records to be paid is the same, the first preset information of the records to be paid, which is the same as the employee identification, is the same.
4. The method according to claim 3, wherein the step of comparing whether the second preset information of the due record in the due ledger table is the same as the second preset information of the corresponding due record in the due ledger table comprises:
comparing whether the basic information of the account-paying record in the account-paying table is the same as the basic information of the corresponding real-paying record in the real-paying account-paying table;
when the basic information of the due payment record in the due payment ledger table is different from the basic information of the corresponding real payment record in the real payment ledger table, outputting the due payment record and the real payment record of which the basic information is different, and continuously judging whether the basic information of the due payment record and the real payment record of which the basic information is the same;
when the basic number information of the due payment record and the actual payment record which are the same in basic information is different, outputting the due payment record and the actual payment record which are different in basic number information, and continuously judging whether the amount information of the due payment record and the actual payment record which are the same in basic number information is the same;
when the amount information of the due payment record and the actual payment record with the same base number information is different, second preset information of the due payment record in the due payment ledger table is different from second preset information of the actual payment record corresponding to the actual payment ledger table, and the due payment record and the actual payment record with different amount information are output;
when the amount information of the due payment record and the amount information of the real payment record with the same cardinal number information are the same, the second preset information of the due payment record in the due payment ledger table is the same as the second preset information of the corresponding real payment record in the real payment ledger table.
5. The method according to claim 1, wherein the step of calculating the account payable table according to the preset rule comprises:
acquiring a general account of a to-be-calculated account table to be paid, and acquiring employee records under the general account;
receiving an input specified month transaction;
when the payment initiating effective month in the employee record is equal to the appointed handling month, judging whether payment initiating and supplementing are needed or not according to the payment initiating handling month and the payment initiating effective month in the employee record;
when the additional payment needs to be initiated, acquiring the base number and the proportion of the effective initiating month and each month needing the additional payment, and calculating the payment amount of the effective initiating month and the payment amount of the additional payment according to the base number and the proportion;
when the effective payment initiating month in the employee record is smaller than the appointed month, acquiring the base number and the proportion of the appointed month, and calculating the payment amount of the appointed month according to the base number and the proportion of the appointed month;
and generating a payment account table according to the calculated payment amount.
6. The method of claim 5, wherein the step of generating an account payable form according to the calculated payment amount further comprises:
acquiring employee records with the types of individual compensation fees;
when the payment starting and handling month of the individual compensation and refund fee is equal to the appointed handling month, acquiring the base number and the proportion of each month from the payment starting month to the payment stopping month in the employee record of the individual compensation and refund fee type;
calculating to obtain an independent compensation amount according to the obtained base number and proportion of each month from the payment initiating month to the payment stopping month;
and generating a payment account table according to the calculated independent compensation fee and the calculated payment amount.
7. The method of claim 6, wherein the step of generating an account payable form based on the calculated individual refund fee and the calculated payment amount further comprises:
when the employee record has the adjusted amount, judging whether the month corresponding to the adjusted amount is equal to the appointed handled month or not;
and when the month corresponding to the adjustment amount is equal to the appointed handling month, generating a payment due standing book table according to the adjustment amount, the calculated independent compensation refund fee and the calculated payment amount.
8. A data collating apparatus, characterized in that said apparatus comprises:
the acquisition module is used for calculating according to preset rules stored in the server to obtain a payment-due standing book table and receiving a real payment standing book table corresponding to the payment-due standing book table, wherein the real payment standing book table is generated by a social security center or a public deposit center after settlement is completed every month and contains real payment records; before the server checks the data, judging whether the acquired real payment account table is correct or not according to the format of the real payment account table;
the first judgment module is used for acquiring the records to be paid with the same employee identification in the account table according to the sequence of the records to be paid in the account table, and marking the same records to be paid when the records to be paid with the same current records to be paid in the account table exist;
the first comparison module is used for comparing whether the first preset information of the due payment records with the same employee identification is the same or not; outputting the account payable records with the same employee identification but different first preset information in the account payable table;
the second comparison module is used for comparing whether second preset information of the records to be paid in the account table to be paid is the same as second preset information of the corresponding records to be paid in the account table to be paid when the first preset information of the records to be paid with the same employee identification is the same;
the output module is used for associating and outputting the due-payment record and the real-payment record with inconsistent data when second preset information of the due-payment record in the due-payment ledger table is different from second preset information of the corresponding real-payment record in the real-payment ledger table; when second preset information of the due payment record in the due payment ledger table is the same as second preset information of the corresponding real payment record in the real payment ledger table, outputting accurate data checking information; and inquiring errors according to the time period of information output.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the method of any one of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711491747.1A CN108090824B (en) | 2017-12-30 | 2017-12-30 | Data checking method and device, computer equipment and readable storage medium |
PCT/CN2018/077356 WO2019127889A1 (en) | 2017-12-30 | 2018-02-27 | Data check method and apparatus, computer device, and readable storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711491747.1A CN108090824B (en) | 2017-12-30 | 2017-12-30 | Data checking method and device, computer equipment and readable storage medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN108090824A CN108090824A (en) | 2018-05-29 |
CN108090824B true CN108090824B (en) | 2019-12-27 |
Family
ID=62181040
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201711491747.1A Active CN108090824B (en) | 2017-12-30 | 2017-12-30 | Data checking method and device, computer equipment and readable storage medium |
Country Status (2)
Country | Link |
---|---|
CN (1) | CN108090824B (en) |
WO (1) | WO2019127889A1 (en) |
Families Citing this family (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109325102B (en) * | 2018-09-19 | 2021-02-19 | 金蝶软件(中国)有限公司 | Method and device for identifying illegal document |
CN110264369B (en) * | 2019-04-16 | 2023-08-08 | 创新先进技术有限公司 | Checking method and device for fee calculation, electronic equipment and storage medium |
CN110223153A (en) * | 2019-04-17 | 2019-09-10 | 深圳壹账通智能科技有限公司 | Account checking method, device, electronic equipment and storage medium |
CN111429092B (en) * | 2020-03-19 | 2023-06-16 | 中国建设银行股份有限公司 | Method, apparatus, device and computer readable medium for paying an accumulation fund |
CN112579481B (en) * | 2020-12-07 | 2023-01-20 | 海光信息技术股份有限公司 | Data processing method, data processing device and computing device |
Family Cites Families (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7383227B2 (en) * | 2002-05-14 | 2008-06-03 | Early Warning Services, Llc | Database for check risk decisions populated with check activity data from banks of first deposit |
CN103136276A (en) * | 2011-12-02 | 2013-06-05 | 阿里巴巴集团控股有限公司 | System, method and device of verification of data |
CN103577571B (en) * | 2013-10-31 | 2016-11-09 | 北京奇虎科技有限公司 | A kind of data processing method and device |
CN103744948B (en) * | 2013-12-31 | 2018-01-12 | 金蝶软件(中国)有限公司 | Searching data checks the method and system of reason of discrepancies |
CN105243519B (en) * | 2015-11-13 | 2019-04-30 | 广州市社会保险基金管理中心 | A kind of social security financial accounting managing and control system |
CN105719182B (en) * | 2016-01-18 | 2020-03-03 | 北京京东尚科信息技术有限公司 | Automatic account checking method and automatic account checking system |
CN107451136A (en) * | 2016-05-30 | 2017-12-08 | 阿里巴巴集团控股有限公司 | Verification of data method and device |
CN106649500A (en) * | 2016-10-11 | 2017-05-10 | 中国工商银行股份有限公司 | Data verification method and system |
CN107169856A (en) * | 2017-04-19 | 2017-09-15 | 中国建设银行股份有限公司 | A kind of common reserve fund business account checking method and system |
-
2017
- 2017-12-30 CN CN201711491747.1A patent/CN108090824B/en active Active
-
2018
- 2018-02-27 WO PCT/CN2018/077356 patent/WO2019127889A1/en active Application Filing
Also Published As
Publication number | Publication date |
---|---|
WO2019127889A1 (en) | 2019-07-04 |
CN108090824A (en) | 2018-05-29 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108090824B (en) | Data checking method and device, computer equipment and readable storage medium | |
CN109767214B (en) | Method, device, equipment and medium for controlling supply flow of financing of incorporated bill | |
CN110046841B (en) | Logistics information tracing method and device based on block chain and electronic equipment | |
CN109087208B (en) | Pre-loan data processing method, pre-loan data processing device, computer equipment and storage medium | |
CN111444209B (en) | Data processing method, device, equipment and medium based on block chain | |
CN111178894B (en) | Asset type registration and transaction record verification method and system | |
WO2019019750A1 (en) | Annuity management system and method, server, and storage medium | |
CN110633963A (en) | Electronic bill processing method, electronic bill processing device, computer-readable storage medium and equipment | |
CN111428218A (en) | Seal authorization method and device and server | |
WO2019052222A1 (en) | Insurance policy processing method and apparatus, computer device, and readable storage medium | |
CN113077331A (en) | Personal financial credit evaluation system and method based on big data | |
CN109544090A (en) | Order processing method, apparatus, computer equipment and storage medium | |
CN110851298A (en) | Abnormality analysis and processing method, electronic device, and storage medium | |
CN110111208A (en) | Declaration form data processing method, device, computer equipment and storage medium | |
CN113408008B (en) | Data processing method, device, equipment and medium | |
US10366351B2 (en) | Information standardization and verification | |
WO2019019748A1 (en) | Annuity service processing method and system, server, and storage medium | |
CN110941849B (en) | Offline electronic certificate showing method, device and system and computer equipment | |
CN112651716A (en) | Data processing method, device and storage medium | |
CN111709709A (en) | Information processing method, system and computer equipment based on warranty service | |
CN111143512A (en) | Bill information detection method and device and computer equipment | |
US10460116B2 (en) | Access control method, system and storage medium | |
JP6224669B2 (en) | Payment application system, payment application method, and program | |
CN112651824A (en) | Non-silver account opening processing method and device, computer equipment and storage medium | |
CN111027992A (en) | Asset transaction method and device based on blockchain system and hardware equipment |
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 |