WO2019127889A1

WO2019127889A1 - Data check method and apparatus, computer device, and readable storage medium

Info

Publication number: WO2019127889A1
Application number: PCT/CN2018/077356
Authority: WO
Inventors: 李福丽; 江琳
Original assignee: 平安科技（深圳）有限公司
Priority date: 2017-12-30
Filing date: 2018-02-27
Publication date: 2019-07-04
Also published as: CN108090824A; CN108090824B

Abstract

A data check method and apparatus, a computer device, and a readable storage medium. The method comprises: obtaining a payable ledger table by calculating according to a pre-set rule, and receiving a paid-in ledger table corresponding to the payable ledger table; acquiring payable records having the same employee identifier in the payable ledger table in accordance with the sequence of payable records in the payable ledger table; comparing whether first preset information of the payable records having the same employee identifier is the same; when the first preset information of the payable records having the same employee identifier is the same, comparing whether second pre-set information of the payable records in the payable ledger table is the same as second pre-set information of corresponding paid-in records in the paid-in account table; and when the second pre-set information of the payable records in the payable ledger table is different from the second pre-set information of the corresponding paid-in records in the paid-in ledger account table, outputting information indicating inconsistent data.

Description

Data collation method, device, computer device and readable storage medium

This application claims to be filed on Dec. 30, 2017, the Chinese Patent Office, the application number is 2017114917471, and the priority of the Chinese patent application entitled "Data verification method, device, computer equipment and readable storage medium" is applied. The citations are incorporated herein by reference.

Technical field

The present application relates to the field of computer technologies, and in particular, to a data collation method, apparatus, computer device, and readable storage medium.

Background technique

Social insurance, that is, social insurance, refers to a non-profit social security system that has a re-distribution function in order to prevent and share social risks such as old age, unemployment, illness, and death, and to achieve social security. The provident fund refers to the company's provident fund and housing provident fund. Every company has to pay social security and provident fund to employees.

Traditionally, in order to ensure the correct payment of social security and provident fund, the company will arrange a large number of personnel each month to check whether the social security and provident fund fees paid by each employee are correct. In this case, the check efficiency is low and artificial. Checking is extremely error-prone.

Summary of the invention

According to various embodiments disclosed herein, a data collation method, apparatus, computer device, and readable storage medium are provided.

A data collation method, the method comprising:

Calculating the account payment form according to the preset rules, and receiving the actual payment account book corresponding to the account payment form;

Obtaining the payable records with the same employee identification in the account receivable form in the order in which the records should be paid in the account receivable form;

Comparing whether the first preset information of the payable record with the same employee identifier is the same;

When the first preset information of the same payable record of the employee identifier is the same, comparing the second preset information of the payable record in the payable ledger table with the corresponding corresponding in the paid account book Whether the second preset information of the paid record is the same; and

When the second preset information of the payable record in the accounts payable table is different from the second preset information of the corresponding paid record in the paid account book, the information that the data is inconsistent is output; When the second preset information of the payable record in the accounts payable table is the same as the second preset information of the corresponding paid record in the paid account book, the output data collates the accurate information.

A data collation device, the device comprising:

An obtaining module, configured to calculate a payable account book according to a preset rule, and receive a paid account book corresponding to the accountable account book;

The first judging module is configured to obtain, according to the order of the records to be paid in the account payment form, the same payable record of the employee identifier in the account book to be paid;

a first comparison module, configured to compare whether the first preset information of the same payable record of the employee identifier is the same;

a second comparison module, configured to: when the first preset information of the payable record with the same employee identifier is the same, compare the second preset information of the payable record in the payable ledger table with the real Whether the second preset information of the corresponding paid record in the payment account table is the same; and

And an output module, configured to: when the second preset information of the payable record in the accounts payable table is different from the second preset information of the corresponding paid record in the paid account book, output Data inconsistent information; when the second preset information of the payable record in the account receivable form is the same as the second preset information of the corresponding paid record in the paid account book, the data is output Check the exact information.

A computer device comprising a memory, a processor, on which is stored computer readable instructions, and the processor, when executing the computer readable instructions, implements the following steps:

One or more computer readable non-volatile storage media storing computer readable instructions, when executed by one or more processors, cause one or more processors to perform the steps of:

Details of one or more embodiments of the present application are set forth in the accompanying drawings and description below. Other features and advantages of the present invention will be apparent from the description, drawings and claims.

DRAWINGS

In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings to be used in the embodiments will be briefly described below. Obviously, the drawings in the following description are only some embodiments of the present application, Those skilled in the art can also obtain other drawings based on these drawings without any creative work.

1 is an application environment diagram of a data collation method in an embodiment;

2 is a flow chart of a data collation method in an embodiment;

Figure 3 is a flow chart of step S206 in the embodiment shown in Figure 2;

Figure 4 is a flow chart of step S208 in the embodiment shown in Figure 2;

Figure 5 is a flow chart of a data collation apparatus in an embodiment;

Figure 6 is a diagram showing the internal structure of a computer device in an embodiment.

Detailed ways

In order to make the objects, technical solutions, and advantages of the present application more comprehensible, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It is understood that the specific embodiments described herein are merely illustrative of the application and are not intended to be limiting.

Referring to FIG. 1 , FIG. 1 is an application environment diagram of a data collation method in an embodiment, wherein a social security center or a CPF center communicates with a server through a network, and is used to send a real payment account stored in a social security center or a CPF center. Go to the server to facilitate data verification by the server. The server can be a standalone server or a server cluster composed of multiple servers.

In one embodiment, referring to FIG. 2, FIG. 2 is a flowchart of a data collation method in an embodiment. The method is applied to the server in FIG. 1 as an example. The data collation method includes:

S202: Calculate the account payment form according to the preset rule, and receive the actual payment account corresponding to the account payment form.

Specifically, the preset rule is a preset rule in the server that can calculate the payable amount of each employee of each company, and the rule is pre-stored in the server, so that each month when calculating the employee's payable amount, The corresponding rules can be called directly according to the employee identification, and no manual calculation is needed, which reduces the workload and improves the efficiency. Through the preset rule, the account payment form can be calculated, for example, by company or by department.

The actual payment account statement is generated by the social security center or the provident fund center after each month's settlement. After the social security center or the provident fund center generates the actual payment account statement, the actual payment account statement is sent to the server for the server. Perform data verification. The sending time of the paid account book may be agreed by the server and the social security center or the CPF center, for example, may be within a preset time period before the data checking time. And before the server performs data verification, it can pre-determine whether the obtained payment account table is correct, for example, it can determine whether the format of the actual payment account statement is correct, and if not, notify the social security center or the provident fund center in time to Before the data is checked, re-download the correct paid-in account form from the Social Security Center or the Provident Fund Center.

The account payment form and the actual payment account statement can be stored in the database of the server, and the database can be set with encryption and the like to prevent the data from being tampered with.

S204: Obtain the record of the same employee identification in the account payment form in the order of the records to be paid in the account payment form.

Specifically, after obtaining the account payment form and the actual payment account statement, in order to reduce the contrast between the two forms, first compare the accounts payable in the account payment form to obtain the same employee identification. A record should be paid. Specifically, the employee identification can be determined by several different dimensions, such as at least one of a name, a document number, a payment account, a payment place, and a payment category as an employee identification. For the sake of convenience, the server judges in order according to the records to be paid in the account payment form. For example, first query whether there is the same record as the first due record in the account payment form (as the current record of payment). Pay the record, if it does not exist, continue to check whether there is the same record that should be paid in the second payment record (as the current due record) in the account payment form, until all the records in the account payment form are inquired. Completion, if there is the same payable record as the current payable record in the account payment form, the same payable record is marked, so that in the next comparison process, the record does not need to be compared. Thereby the amount of comparison can be reduced.

Wherein, before the steps of obtaining the record of the same employee identification in the account payment form in the order of the records to be paid in the account payment form, the method may further include: comparing the corresponding payment account form and the actual payment account statement The total account information is the same. If the account payment form is generated by the company, the total account information is company information. If the account payment form is generated by department, the total account information is department information. This is not a specific limitation. If the total account information of the account receivable form is not the same as the total account information of the paid-in account statement, the total account can be marked and output to facilitate timely troubleshooting. If a single account payment form or a real payment account statement can include multiple accounts, it is necessary to compare the accounts in the two account statements to the same, if not the same, for example, the account should be paid The account exists in the table, but the account does not exist in the actual payment account table, or the account exists in the actual payment account table, but the account does not exist in the account payment form, then the account can be output. Or mark the account, for example, as a default account.

S206: Compare whether the first preset information of the payable record with the same employee identifier is the same.

Specifically, in the account payment form, if there is an account payable record with the same employee ID, the other first preset information of the payable record needs to be consistent, so as to ensure that the payable records in the account payable table are Correct, therefore, in order to ensure that the records to be paid are compared with the actual payment records in the actual payment account, the pre-judgment is first made corresponding to the records to be paid in the payment account. In addition, if there is only one record of the employee's identification in the accounts payable, there is no need to make a pre-judgment of the account statement.

S208: When the first preset information of the same payable record of the employee identifier is the same, comparing the second preset information of the payable record in the account payment form with the corresponding paid record in the paid account book Whether the second preset information is the same.

Specifically, after the pre-judgment of the account payment form is completed, the payable records in which the employee identifiers in the account book table are the same but the first preset information is different may be output, so as to prompt the user that the record has a difference, and Comparing the accounts payable with the same employee identification and the first preset information in the account book to be compared with the paid records in the actual payment account table to determine the record of the record payable in the account book The second preset information is the same as the second preset information corresponding to the paid-on record in the actual payment account table, that is, the employee identification is the same, thereby determining whether the record is correct. In addition, if there is only one record of the employee's logo in the account payment form, the record should be directly compared with the corresponding paid record.

S210: When the second preset information of the payable record in the account payment form is different from the second preset information of the corresponding paid record in the paid account book, the information inconsistent data is output.

S212: When the second preset information of the payable record in the account payment form is the same as the second preset information of the corresponding paid record in the paid account book, the output data is checked for the accurate information.

Specifically, when the second preset information of the payable record in the account payment form is different from the second preset information of the corresponding paid record in the paid account book, the information inconsistent data is directly output. In order to facilitate the user to know the wrong data in time, for example, the inconsistent record of the data and the paid record can be directly outputted, and the places where the data is inconsistent are marked. If the second preset information of the payable record in the account payment form is the same as the second preset information of the corresponding paid record in the paid account book, it means that the data check is accurate.

Among them, the above-mentioned record of payment may include different types of payment types, such as normal payment, payment of repayment, separate payment, separate refund, payment difference base, fixed adjustment amount, etc., different payment Types can be checked against the above check method.

The above data collation method firstly matches the first preset information of the payable record with the same employee identification in the account book to ensure the correctness of the account book to be paid, and then the correct account statement is correct. On the premise of the comparison, the pre-screening was carried out, and the pre-screening was carried out to reduce the comparison between the accounts payable and the paid-in account book, and the comparison was performed by computer equipment, thereby improving the efficiency. .

In one embodiment, before the step of obtaining the payable record with the same employee identification in the account payment form in the order of the records to be paid in the account payment form, the step S204 may further include: determining the account receivable Whether there is a difference between the employee identification in the table and the employee identification in the actual payment account table; when there is a difference between the employee identification in the account payment form and the employee identification in the actual payment account statement, the output is different. The record of the payment in the account statement and the actual payment record in the actual payment account table.

Specifically, in order to ensure the consistency of the data of the account payment form and the actual payment account statement, it may be first determined whether there is a difference between the employee identification in the account payment form and the employee identification in the actual payment account form, so that only In the pre-judgment, the records in the account receivable table that are inconsistent with the employee identification in the paid-in account statement can be removed first to reduce the subsequent comparison amount, for example, when an employee identification is present in the accounts to be paid, If it does not exist in the paid account, it can output the payable record in the payable ledger, and output the prompt default paying record; if an employee ID exists in the actual payment account but is due If the account does not exist, the actual payment record in the actual payment account can be output, and the default account should be issued. Therefore, the payment records of the account receivable and the actual payment account are outputted for the next step.

The output mode may be that the output data is sent to the mailbox reserved by the corresponding account, or may be sent to the WeChat corresponding to the account, or the user corresponding to the account may be notified by SMS to download the file from the server in time. The output data.

In the above embodiment, by pre-comparing the employee identifications of the accounts payable and the actual payment accounts, the payment records of the accounts payable and the actual payment accounts can be pre-outputted to reduce the processing of subsequent data. Quantity, which can improve processing efficiency.

In one embodiment, referring to FIG. 3, FIG. 3 is a flowchart of step S206 in the embodiment shown in FIG. 2, where the comparing employee identifies whether the first preset information of the same payable record is the same, that is, the step S206 can include:

S302: Compare whether the basic information of the record of the same employee identification is the same.

The basic information includes at least one of a social security household registration attribute, an insurance plan, a social security personal number, an old-age insurance personal number, a medical insurance personal number, an unemployment insurance personal number, a work injury personal number, a maternity insurance personal number, and an employee number. When the employee identification is the same, the basic information of the payable records with the same employee identification in the account payment table can be compared in turn.

S304: When the basic information of the payable records with the same employee identification is different, the recorded records with different basic information are output, and the cardinality information of the accounts to be paid with the same basic information is continuously determined to be the same.

Specifically, when the basic information of the payable records with the same employee identification is different, the record that is not the same as the basic information is directly output, so that the record to be paid is no longer involved in the subsequent comparison. When the basic information of the payable records with the same employee identification is the same, it is possible to further compare whether the cardinality information of the same payable record of the basic information is the same.

The cardinal information includes the payment base of the pension insurance company, the personal payment base of the pension insurance, the payment base of the medical insurance company, the personal payment base of the medical insurance, the payment base of the unemployment insurance company, the personal payment base of the unemployment insurance, and the payment of the work injury insurance company. At least one of the base number, the maturity of the maternity insurance company, the supplementary medical insurance company's supplementary base, and the supplementary medical insurance personal supplementary base.

S306: When the cardinality information of the accounts to be paid with the same basic information is different, the first preset information of the accounts to be paid with the same employee identification is different, and the accounts to be paid with different cardinality information are output.

Wherein, when the cardinality information of the record of the same basic information is different, the record of the account that the cardinality information is different may be output, so that the record of the article to be paid does not participate in the subsequent comparison process, thereby reducing the data. The amount of comparison.

S308: When the cardinality information of the accounts to be paid with the same basic information is the same, the first preset information of the accounts to be paid with the same employee identification is the same.

When the cardinality information of the record of the same basic information is the same, the first preset information indicating that the employee identification has the same record is the same, so that the record of the article can participate in the subsequent and actual payment accounts. Pay the record match.

In the above embodiment, first, the same payable records with the same employee identification are compared, and the information with errors in the payable records may be first output, thereby reducing the matching amount with the paid records in the paid account book, and It is also possible to determine whether the internal error of the server is caused by the internal error of the server (for example, due to an error in the account statement) or the cause of the external error (for example, because the account payment form is compared with the actual payment account table). The data check error caused by the error is convenient for subsequent query errors.

In one embodiment, referring to FIG. 4, FIG. 4 is a flowchart of step S208 in the embodiment shown in FIG. 2, that is, comparing the second preset information of the record to be paid in the account book to be paid. The step of whether the second preset information of the corresponding paid record in the paid account book is the same may include:

S402: It is the same whether the basic information of the payable record in the account book to be compared with the actual paid record in the paid account book table is the same.

The basic information here is the same as the basic information in the first preset information, and is not described here.

When the payable record in the account receivable form is the same as the basic information of the corresponding paid record in the paid account book, proceed to the next step of judgment, for example, continue to judge the cardinality information.

S404: When the basic information of the record to be paid in the account book to be paid is different from the basic information of the corresponding paid record in the actual account payment form, the record of the payment and the actual payment record having different basic information are output. And continue to judge whether the base information of the same payable record and the paid record of the same basic information is the same.

Specifically, when the payable record in the account receivable form is different from the basic information of the corresponding paid record in the paid account book, the difference between the payable record and the paid record is directly output, so that The record of payment and the record of actual payment are not involved in subsequent comparisons, thus reducing the amount of subsequent comparisons. After the output, it is determined whether the base information of the same payable record and the paid record of the same basic information is the same. The cardinality information here is the same as the cardinality information in the above, and will not be described herein.

S406: When the cardinality information of the same payable record and the paid record of the basic information is different, the payable record and the paid record which are different from the base information are output, and the payable record and the paid record with the same base information are continuously judged. Is the amount information the same?

Specifically, when the base information of the same payable record and the paid record of the basic information are different, the payable record and the paid record which are different from the base information are output, so that the payable record and the paid record do not participate in the subsequent The comparison thus reduces the amount of subsequent comparisons. After the output, it is determined whether the amount information of the payable record and the paid record having the same cardinality information are the same.

The calculation method of the amount information is related to the type of payment. When the payment type is normally paid, each type of insurance in the normal payment type in the account payment form is obtained, and the calculation formula for the amount corresponding to the insurance type is obtained, according to The amount calculation rule calculates the sum of the individual/company amount respectively, and compares with the sum of the same type of insurance type in the actual payment type in the actual payment account. If there is a difference, the company/individual payment amount is different and the specific amount of the difference is output and output. The employee's all payable and paid account information. When the payment type is other, the account payable shall be calculated according to the type of insurance: (total payment of the total amount of payment + total payment of the total amount + base to pay the total amount) - the total amount of the individual refund. When the type is not distinguished, it can be calculated by the following formula: the employee should pay the account in the current month = the amount of the normal payment type + the fixed adjustment amount of the normal payment type + the amount of the payment type + the payment of the payment The fixed amount of the type of adjustment + the amount of the individual payment type + the fixed adjustment amount of the individual payment type - the amount of the individual refund type + the amount of the difference / refund base difference type.

S408: When the amount information of the payable record and the paid record of the same cardinality information are different, the second preset information of the record to be paid in the account book and the corresponding paid record in the paid account book form shall be paid. The second preset information is different, and the payable record and the paid record are not the same as the amount information.

S410: When the amount information of the payable record and the paid record of the same cardinality information are the same, the second preset information of the record to be paid in the account book and the corresponding paid record in the paid account book form shall be paid. The second preset information is the same.

When the amount information of the payable record and the paid record of the same base information are different, the payable record in the account receivable form and the paid record in the paid account book are output for subsequent confirmation, etc. When the amount of the record of the same amount of the base information and the amount of the paid record are the same, it means that there is no problem with the record of the payment of the article.

After the error payment record of the account payment form and the actual payment account statement is output, the user can view the error payment record and perform the next processing according to the error type, for example, the internal error of the account statement at the time. At that time, only internal information needs to be confirmed, but if it is different between the account payment form and the actual payment form, it may need to be connected with the social security center or the provident fund center to change the corresponding data.

In the above embodiment, the basic information, the cardinality information, and the amount information of the payable record and the paid record with the same employee identification are sequentially compared, thereby outputting the wrong payment record step by step, and reducing the subsequent comparison amount. The error payment records can be classified and statistic according to the type of error, so as to facilitate the subsequent classification and processing of the error payment records.

In one embodiment, the step of calculating the account payment form is calculated according to the preset rule, that is, the step S202 may include: obtaining a total account of the account book to be calculated, and obtaining the employee record under the total account; The designated processing month of the input; when the effective date of the payment in the employee record is equal to the designated processing month, it is judged according to the payment processing month and the effective date of the payment in the employee record whether it is necessary to pay the payment; At the time of the entry, the base and the proportion of each month in which the payment is effective and the payment of the payment are required, and the payment amount of the effective date of the payment and the payment amount of the payment of the payment are calculated according to the base and the proportion; If the effective date of the payment is less than the designated processing month, the base and proportion of the designated processing month will be obtained, and the payment amount of the designated processing month will be calculated according to the base and proportion of the designated processing month; the accountable account will be generated based on the calculated payment amount. table.

Specifically, the accounts payable table includes the social security property sheet, the difference between the refunded base and the fixed adjustment amount, and the social security property list includes the normal payment type, the payment type, the separate payment type, and the separate withdrawal. Fee type. In this embodiment, first, the total account to be calculated, such as the company account, is obtained, and then the employee record under the total account is obtained, and the designated processing month input by the user is received, for example, the user has to calculate the payable table in September. For the account statement, the designated month is September. The month of payment is the month when the new employee starts to pay social security and provident fund. The effective month of the payment is the month when the personnel department goes to the social security center or the CPF center to register the account. When the effective date of the payment is equal to the designated month, it is necessary to judge whether the effective month of the payment is less than the month of payment. If the effective month is less than the payment month, it means that the payment is required, so the effective payment month is obtained. And the base and proportion of each month that need to be repaid, and the amount of payment for the effective month and the amount of payment for the payment of the payment will be calculated based on the base and the ratio. These bases and ratios are entered in advance by personnel when they are employed. When the effective date of the payment in the employee record is less than the specified processing month and is not in the state of suspension, the employee is the employee who has paid the normal payment. Therefore, the base and the proportion of the specified processing month are obtained, and the base and proportion of the designated month are calculated according to the designated month. Calculate the payment amount for the specified processing month. These bases and ratios are entered in advance by personnel when they are employed. The payment amount of each employee is calculated according to the above. After calculating the payment amount of all employees, the account payment form can be generated based on the calculated payment amount.

In the above embodiment, according to the effective date of the payment and the month of the instruction, it can be judged whether the payment is required to be paid, and if the payment is required to be paid, the base and the proportion of the prepayment stored in the system can be obtained, thereby accurately Generate the corresponding replenishment amount. If the repayment is not required, the normal base and proportion stored in the system will be directly obtained. According to the normal base and the ratio, the normal payment amount can be obtained. Pay the account statement.

In one embodiment, the step of generating an account payment form according to the calculated payment amount may further include: obtaining an employee record of a type of individual reimbursement fee; At the end of the month, the base and proportion of each month in the employee record of the individual reimbursement type are obtained from the month of the payment to the month of the suspension; the base of each month in the month of the payment The proportion calculation calculates the amount of the individual reimbursement fee; the account reconciliation statement is generated based on the calculated individual reimbursement fee and the calculated payment amount.

Specifically, the type of individual reimbursement fee includes separate replenishment and separate reimbursement. When there is a separate reimbursement type or a separate reimbursement type in the employee record, the payment is based on the separate payment or the separate reimbursement. At the time of the month, the employee's salary base is called according to the corresponding payment month, and the effective salary base of the employee's base effective date is less than or equal to the latest creation time of the corresponding payment month as the base of the individual payment or the base of the individual refund. The effective period of the proportional rule is less than or equal to the proportion of the payment of the newly created valid one in the corresponding payment month, and the amount of the individual payment is calculated according to the base and the proportion of each month in the month of the payment.

In the above embodiment, the different payment types are fully considered, and the account payment form is improved according to different payment types, thereby improving the adaptability of the account payment form.

In one embodiment, the step of generating a payable ledger table according to the calculated individual refund fee and the calculated payment amount may further include: when there is an adjustment amount in the employee record, determining to correspond to the adjusted amount Whether the month is equal to the designated processing month; when the month corresponding to the adjustment amount is equal to the designated processing month, the account payment form is generated according to the adjusted amount, the calculated individual replacement fee and the calculated payment amount.

Specifically, according to the account information and the designated processing month, the fixed amount adjustment table and the payment/return base balance amount table are obtained, and when the normal payment, the payment is made, and the individual payment is made, the fixed amount adjustment is effective until the effective date is adjusted. When the suspension is within the effective monthly range (every month, it will be judged separately), the amount of normal payment, repayment and separate refund shall be added to the fixed adjustment amount; when the payment/return base difference is processed It is equal to the specified processing month, from the time of the payment to the payment to the month, the monthly calculation of the base number before adjustment, the difference between the ratio and the adjusted base number multiplied by the ratio, that is, the monthly payment/return base amount, and then Calculate the total payment amount.

It should be understood that although the various steps in the flowcharts of FIGS. 2-4 are sequentially displayed as indicated by the arrows, these steps are not necessarily performed in the order indicated by the arrows. Except as explicitly stated herein, the execution of these steps is not strictly limited, and the steps may be performed in other orders. Moreover, at least some of the steps in FIGS. 2-4 may include a plurality of sub-steps or stages, which are not necessarily performed at the same time, but may be executed at different times, these sub-steps or stages The order of execution is not necessarily performed sequentially, but may be performed alternately or alternately with at least a portion of other steps or sub-steps or stages of other steps.

Referring to FIG. 5, FIG. 5 is a flowchart of a data collating apparatus in an embodiment, where the apparatus includes:

The obtaining module 100 is configured to calculate the account payment form according to the preset rule, and receive the actual payment account table corresponding to the account payment form.

The first judging module 200 is configured to obtain the payable records with the same employee identification in the account payment form in the order of the records to be paid in the account payment form.

The first comparison module 300 is configured to compare whether the first preset information of the payable record with the same employee identifier is the same.

The second comparison module 400 is configured to compare the second preset information of the payable record in the account receivable table with the paid-in account book when the first preset information of the same payable record of the employee identifier is the same Whether the second preset information of the corresponding paid record is the same.

The output module 500 is configured to: when the second preset information of the payable record in the account payment form is different from the second preset information of the corresponding paid record in the paid account book, the output data is inconsistent Information; when the second preset information of the payable record in the account payment form is the same as the second preset information of the corresponding paid record in the paid account book, the output data is checked for accurate information.

In one embodiment, the data collating apparatus may further include:

The second judging module is configured to determine the employee identification and the payment platform in the account payment form before obtaining the payable records with the same employee identification in the account payment form in the order in which the records to be paid in the account payment form are to be paid. Whether there is a difference in the employee ID in the account statement.

The output module 500 is further configured to output the difference between the employee identifier in the accounts payable table and the employee identifier in the actual payment account table, and output the difference between the account receivable record and the difference in the account payment table. Pay the actual record in the account statement.

In one embodiment, the first comparison module 300 can include:

The first basic information comparison unit is configured to compare whether the basic information of the payable records with the same employee identification is the same.

The first cardinality information comparison unit is configured to output the record that the basic information is not the same when the basic information of the record of the employee whose identity is the same is different, and continue to determine whether the cardinality information of the record of the same basic information is the same.

The first comparison result output unit is configured to: when the cardinality information of the accounts to be paid with the same basic information is different, the first preset information of the accounts to be paid with the same employee identification is different, and the output of the cardinality information is different Recording; when the cardinality information of the record of the same basic information is the same, the first preset information of the record of the same employee with the same employee identification is the same.

In one embodiment, the second comparison module 400 can include:

The second basic information comparing unit is configured to compare whether the basic information of the payable record in the account book to be paid and the corresponding paid record in the paid account book is the same.

The second cardinality information comparing unit is configured to: when the basic information of the payable record in the account receivable form is different from the basic information of the corresponding paid record in the paid account book, the output basic information is different Pay the record and pay the record, and continue to judge whether the basic information is the same as the base record of the payable record and the paid record.

The amount information comparison unit is configured to output the payable record and the paid-up record having different cardinality information when the cardinality information of the same payable record and the paid-up record having the same basic information are different, and continue to judge that the cardinality information is the same Whether the amount information of the recorded and paid records is the same.

The second comparison result output unit is configured to: when the amount information of the payable record and the paid record having the same base information are different, the second preset information of the record to be paid in the account book and the paid account The second preset information of the corresponding paid record in the table is different, and the payable record and the paid record with different amount information are output; when the amount of the payable record with the same base information is the same as the amount information of the paid record, then The second preset information of the payable record in the account payment form is the same as the second preset information of the corresponding paid record in the paid account book.

In one embodiment, the obtaining module 100 can include:

The employee record acquisition unit is used to obtain the total account of the account statement to be calculated and obtain the employee record under the total account.

The receiving unit is configured to receive the designated processing month of the input.

The payment and payment judgment unit is used to determine whether the payment is required to be paid according to the payment processing month and the effective payment month in the employee record when the effective date of the payment in the employee record is equal to the designated payment month.

The first calculation unit is configured to obtain the base and proportion of each month of the effective date of the payment and the payment of the payment when the payment is required to be paid, and calculate the payment amount of the effective month of the payment according to the base and the proportion. The amount of payment paid for the payment of the payment.

The second calculating unit is configured to obtain the base number and proportion of the designated processing month when the effective date of the payment in the employee record is less than the designated processing month, and calculate the payment amount of the designated processing month according to the base and the proportion of the designated processing month.

The first generating unit is configured to generate an account payment form according to the calculated payment amount.

In one embodiment, the first generating unit may include:

A separate reimbursement fee acquisition unit for obtaining employee records of the type of individual reimbursement fee.

The third calculating unit is configured to obtain the base and proportion of each month in the employee record of the individual reimbursement fee type to the monthly payment period when the monthly payment repayment fee is equal to the designated processing month The amount of the individual reimbursement fee is calculated based on the base and the proportion of each month in the month of the payment.

And a second generating unit, configured to generate a payable ledger table according to the calculated individual reimbursement fee and the calculated payment amount.

In one embodiment, the second generating unit may include:

The adjustment amount judging unit is configured to judge whether the month corresponding to the adjustment amount is equal to the designated processing month when there is an adjustment amount in the employee record.

The third generating unit is configured to generate, when the month corresponding to the adjusted amount is equal to the designated processing month, generate the accountable account book according to the adjusted amount, the calculated individual refund fee, and the calculated payment amount.

In one embodiment, a computer device is provided, which is the server shown in FIG. 1, and its internal structure diagram can be as shown in FIG. 6. The computer device includes a processor, memory, network interface, and database connected by a system bus. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium, an internal memory. The non-volatile storage medium stores an operating system, computer readable instructions, and a database. The internal memory provides an environment for operation of an operating system and computer readable instructions in a non-volatile storage medium. The database of the computer equipment is used to store the account payment form and the actual payment account statement. The network interface of the computer device is used to communicate with an external terminal via a network connection. The computer readable instructions are executed by a processor to implement a data collation method.

It will be understood by those skilled in the art that the structure shown in FIG. 6 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation of the computer device to which the solution of the present application is applied. The specific computer device may It includes more or fewer components than those shown in the figures, or some components are combined, or have different component arrangements.

In one embodiment, a computer device is provided, including a memory, a processor, and a computer readable instruction stored thereon, and when the processor executes the computer readable instructions, the following steps are implemented: calculating a payable table according to a preset rule The account statement, and receive the actual payment account table corresponding to the account payment form; in accordance with the records in the account payment form, the same record of the employee's identification in the account payment form is obtained; the comparison employee identification is the same Whether the first preset information of the record to be paid is the same; when the first preset information of the same record of the employee's identity is the same, the second preset information of the record to be paid in the account book is compared Whether the second preset information of the corresponding paid record in the payment account table is the same; when the second preset information of the record to be paid in the account book and the corresponding paid record in the paid account book When the two preset information are different, the information of the inconsistent data is output; when the second preset information of the record to be paid in the account book and the second preset information of the paid record corresponding to the paid account book When the same, then lose Data checking and accurate information.

In one embodiment, a computer readable storage medium is provided having stored thereon computer readable instructions that, when executed by a processor, implement the following steps: calculating a due account table according to a preset rule And receiving the actual payment account corresponding to the account payment form; obtaining the record of the same employee identification in the account payment form in the order of the records to be paid in the account payment form; comparing the employee identification with the same Whether the first preset information of the record is the same; when the first preset information of the record of the same employee whose identity is the same is the same, the second preset information of the record to be paid in the account book and the paid-in station are compared. Whether the second preset information of the corresponding paid record in the account statement is the same; when the second preset information of the record to be paid in the account book and the second prepaid record corresponding to the paid record in the actual account book When the information is different, the information of the data inconsistency is output; when the second preset information of the record to be paid in the account book is the same as the second preset information of the corresponding paid record in the paid account book , the output data check is accurate Information.

A person skilled in the art can understand that all or part of the process of implementing the above embodiment method can be completed by computer readable instructions, which can be stored in a non-transitory computer. In the storage medium, the computer readable instructions, when executed, may include the flow of an embodiment of the methods described above. Any reference to a memory, storage, database or other medium used in the various embodiments provided herein may include non-volatile and/or volatile memory. 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 formats, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronization chain. Synchlink DRAM (SLDRAM), Memory Bus (Rambus) Direct RAM (RDRAM), Direct Memory Bus Dynamic RAM (DRDRAM), and Memory Bus Dynamic RAM (RDRAM).

The technical features of the above-described embodiments may be arbitrarily combined. For the sake of brevity of description, all possible combinations of the technical features in the above embodiments are not described. However, as long as there is no contradiction between the combinations of these technical features, All should be considered as the scope of this manual.

The above-mentioned embodiments are merely illustrative of several embodiments of the present application, and the description thereof is more specific and detailed, but is not to be construed as limiting the scope of the invention. It should be noted that a number of variations and modifications may be made by those skilled in the art without departing from the spirit and scope of the present application. Therefore, the scope of the invention should be determined by the appended claims.

Claims

A data collation method, the method comprising:

Calculating the account payment form according to the preset rules, and receiving the actual payment account book corresponding to the account payment form;

Obtaining the payable records with the same employee identification in the account receivable form in the order in which the records should be paid in the account receivable form;

Comparing whether the first preset information of the payable record with the same employee identifier is the same;

When the first preset information of the same payable record of the employee identifier is the same, comparing the second preset information of the payable record in the payable ledger table with the corresponding corresponding in the paid account book Whether the second preset information of the paid record is the same;

When the second preset information of the payable record in the accounts payable table is different from the second preset information of the corresponding paid record in the paid account book, the information that the data is inconsistent is output; and

When the second preset information of the payable record in the accounts payable table is the same as the second preset information of the corresponding paid record in the paid account book, the output data collates the accurate information.
The method according to claim 1, wherein said step of obtaining, in accordance with the order of records to be paid in said account payment form, the step of collecting the record of the employee with the same employee identification in the account book include:

Determining whether there is a difference between the employee identification in the accounts payable table and the employee identification in the paid account book; and

When there is a difference between the employee identification in the accounts payable table and the employee identification in the actual payment account table, the difference between the payable record and the difference in the account payment form is displayed. Pay the actual record in the account statement.
The method according to claim 1 or 2, wherein the step of comparing whether the first preset information of the same payable record of the employee identifier is the same comprises:

Comparing whether the basic information of the payable records with the same employee identification is the same;

When the basic information of the payable records with the same employee identification is different, outputting the record of the difference that the basic information is different, and continuing to determine whether the cardinality information of the record of the same basic information is the same;

When the cardinality information of the accounts to be paid with the same basic information is different, the first preset information of the payable records with the same employee identification is different, and the record of the accounts whose cardinality information is different is output;

When the cardinality information of the accounts to be paid with the same basic information is the same, the first preset information of the payable records with the same employee identity is the same.
The method according to claim 3, wherein the comparing the second preset information of the payable record in the payable ledger table with the corresponding paid record in the paid account book table The steps of whether the two preset information are the same include:

Comparing whether the payable record in the accounts payable table is the same as the basic information of the corresponding paid record in the paid account book;

When the basic information of the record to be paid in the account receivable form is different from the basic information of the corresponding paid record in the paid account book, the record of the difference in the basic information is output and Make a record of the payment, and continue to judge whether the cardinality information of the same payable record and the paid record of the same basic information is the same;

When the cardinality information of the same payable record and the paid record of the basic information is different, the payable record and the paid record which are different in the cardinality information are output, and the record of the same payable record of the cardinality information is continuously determined. Whether the amount information of the paid record is the same;

When the amount information of the payable record and the paid record of the same cardinality information are different, the second preset information of the record to be paid in the accountable account book corresponds to the actual paid account book The second preset information of the paid-in record is different, and outputs the payable record and the paid-up record that the amount information is different; and

When the amount information of the payable record and the paid record of the same cardinality information are the same, the second preset information of the payable record in the accountable account form and the corresponding corresponding in the paid account book The second preset information of the paid record is the same.
The method according to claim 1, wherein the step of calculating the account payment form according to the preset rule comprises:

Obtaining the total account of the account statement to be calculated, and obtaining the employee record under the total account;

The designated processing month for receiving input;

When the effective date of the payment in the employee record is equal to the designated payment month, it is determined according to the payment processing month and the effective payment month in the employee record whether the payment is required to be paid;

When the payment is required to be paid, the base and the proportion of each month in which the payment is effective and the payment of the payment are required, and the payment amount and the payment of the payment in the effective month are calculated based on the base and the ratio. Pay the amount;

When the effective date of the payment in the employee record is less than the designated processing month, the base and the proportion of the designated processing month are obtained, and the payment amount of the designated processing month is calculated according to the base and the proportion of the specified processing month; and

A bill of account is generated based on the calculated payment amount.
The method according to claim 1, wherein the step of generating an account payment form based on the calculated payment amount further comprises:

Obtain an employee record of the type with a separate reimbursement fee;

And obtaining, when the monthly payment processing month of the individual reimbursement fee is equal to the designated processing month, obtaining a base and a proportion of each month in the employee record of the individual reimbursement fee type to the monthly payment period;

Calculate the amount of the individual reimbursement fee based on the base and the proportion of each month of the month from the month of payment to the month of the suspension; and

The account receivable form is generated based on the calculated individual reimbursement fee and the calculated payment amount.
The method according to claim 6, wherein the step of generating a due account form based on the calculated individual reimbursement fee and the calculated payment amount further comprises:

When there is an adjustment amount in the employee record, it is determined whether the month corresponding to the adjustment amount is equal to the designated processing month;

When the month corresponding to the adjustment amount is equal to the designated processing month, the account payment form is generated according to the adjusted amount, the calculated individual replacement fee, and the calculated payment amount.
A data collation device, characterized in that the device comprises:

An obtaining module, configured to calculate a payable account book according to a preset rule, and receive a paid account book corresponding to the accountable account book;

The first judging module is configured to obtain, according to the order of the records to be paid in the account payment form, the same payable record of the employee identifier in the account book to be paid;

a first comparison module, configured to compare whether the first preset information of the same payable record of the employee identifier is the same;

a second comparison module, configured to: when the first preset information of the payable record with the same employee identifier is the same, compare the second preset information of the payable record in the payable ledger table with the real Whether the second preset information of the corresponding paid record in the payment account table is the same; and

And an output module, configured to: when the second preset information of the payable record in the accounts payable table is different from the second preset information of the corresponding paid record in the paid account book, output Data inconsistent information; when the second preset information of the payable record in the account receivable form is the same as the second preset information of the corresponding paid record in the paid account book, the data is output Check the exact information.
The device according to claim 8, wherein the device further comprises:

a second judging module, configured to determine whether there is a difference between the employee identifier in the payable ledger table and the employee identifier in the paid billing account;

The output module is further configured to: when there is a difference between the employee identifier in the payable ledger table and the employee identifier in the paid billing table, output the difference in the accountable account statement The paid record in the paid-in account statement of the record and the difference.
A computer device comprising a memory, a processor, and computer readable instructions stored on the memory and executable on the processor, wherein the processor, when executing the computer readable instructions, implements the following steps:

Calculating the account payment form according to the preset rules, and receiving the actual payment account book corresponding to the account payment form;

Obtaining the same payable records of the employee's logo in the account receivable form in the order in which the records should be paid in the account receivable form;

Comparing whether the first preset information of the payable record with the same employee identifier is the same;

When the first preset information of the same payable record of the employee identifier is the same, comparing the second preset information of the payable record in the payable ledger table with the corresponding corresponding in the paid account book Whether the second preset information of the paid record is the same;

When the second preset information of the payable record in the accounts payable table is different from the second preset information of the corresponding paid record in the paid account book, the information that the data is inconsistent is output; and

When the second preset information of the payable record in the accounts payable table is the same as the second preset information of the corresponding paid record in the paid account book, the output data collates the accurate information.
The computer apparatus according to claim 10, wherein said processor, when said computer readable instructions are executed, obtains said payable in accordance with said record in said payables table Before the steps of the same record of employee identification in the account statement, it also includes:

Determining whether there is a difference between the employee identification in the accounts payable table and the employee identification in the paid account book; and

When there is a difference between the employee identification in the accounts payable table and the employee identification in the actual payment account table, the difference between the payable record and the difference in the account payment form is displayed. Pay the actual record in the account statement.
The computer device according to claim 10 or 11, wherein the first preset information of the payable record that compares the employee identification is implemented when the processor executes the computer readable instruction The same steps, including:

Comparing whether the basic information of the payable records with the same employee identification is the same;

When the basic information of the payable records with the same employee identification is different, outputting the record of the difference that the basic information is different, and continuing to determine whether the cardinality information of the record of the same basic information is the same;

When the cardinality information of the accounts to be paid with the same basic information is different, the first preset information of the payable records with the same employee identification is different, and the record of the accounts whose cardinality information is different is output;

When the cardinality information of the accounts to be paid with the same basic information is the same, the first preset information of the payable records with the same employee identity is the same.
The computer device according to claim 12, wherein said comparing said second predetermined information of said payable record in said payable ledger table implemented by said processor when said computer readable instructions are executed The step of whether the second preset information of the corresponding paid record in the paid account book is the same includes:

Comparing whether the payable record in the accounts payable table is the same as the basic information of the corresponding paid record in the paid account book;

When the basic information of the record to be paid in the account receivable form is different from the basic information of the corresponding paid record in the paid account book, the record of the difference in the basic information is output and Make a record of the payment, and continue to judge whether the cardinality information of the same payable record and the paid record of the same basic information is the same;

When the cardinality information of the same payable record and the paid record of the basic information is different, the payable record and the paid record which are different in the cardinality information are output, and the record of the same payable record of the cardinality information is continuously determined. Whether the amount information of the paid record is the same;

When the amount information of the payable record and the paid record of the same cardinality information are different, the second preset information of the record to be paid in the accountable account book corresponds to the actual paid account book The second preset information of the paid-in record is different, and outputs the payable record and the paid-up record that the amount information is different; and

When the amount information of the payable record and the paid record of the same cardinality information are the same, the second preset information of the payable record in the accountable account form and the corresponding corresponding in the paid account book The second preset information of the paid record is the same.
The computer device according to claim 10, wherein the step of calculating, according to a preset rule, the account receivable form, when the processor executes the computer readable instruction comprises:

Obtaining the total account of the account statement to be calculated, and obtaining the employee record under the total account;

The designated processing month for receiving input;

When the effective date of the payment in the employee record is equal to the designated payment month, it is determined according to the payment processing month and the effective payment month in the employee record whether the payment is required to be paid;

When the payment is required to be paid, the base and the proportion of each month in which the payment is effective and the payment of the payment are required, and the payment amount and the payment of the payment in the effective month are calculated based on the base and the ratio. Pay the amount;

When the effective date of the payment in the employee record is less than the designated processing month, the base and the proportion of the designated processing month are obtained, and the payment amount of the designated processing month is calculated according to the base and the proportion of the specified processing month; and

A bill of account is generated based on the calculated payment amount.
The computer device according to claim 10, wherein the step of generating the payable ledger table according to the calculated payment amount realized when the processor executes the computer readable instruction further comprises:

Obtain an employee record of the type with a separate reimbursement fee;

And obtaining, when the monthly payment processing month of the individual reimbursement fee is equal to the designated processing month, obtaining a base and a proportion of each month in the employee record of the individual reimbursement fee type to the monthly payment period;

Calculate the amount of the individual reimbursement fee based on the base and proportion of each month of the month from the month of payment to the month of the suspension; and

The account receivable form is generated based on the calculated individual reimbursement fee and the calculated payment amount.
The computer apparatus according to claim 15, wherein said processor implements said computer readable instructions to generate said payable table based on said calculated individual reimbursement fee and said calculated payment amount The steps of the statement also include:

When there is an adjustment amount in the employee record, it is determined whether the month corresponding to the adjustment amount is equal to the designated processing month;

When the month corresponding to the adjustment amount is equal to the designated processing month, the account payment form is generated according to the adjusted amount, the calculated individual replacement fee, and the calculated payment amount.
One or more computer readable non-volatile storage media storing computer readable instructions, wherein when the computer readable instructions are executed by one or more processors, cause one or more processors to perform the following step:

Calculating the account payment form according to the preset rules, and receiving the actual payment account book corresponding to the account payment form;

Obtaining the payable records with the same employee identification in the account receivable form in the order in which the records should be paid in the account receivable form;

Comparing whether the first preset information of the payable record with the same employee identifier is the same;

When the first preset information of the same payable record of the employee identifier is the same, comparing the second preset information of the payable record in the payable ledger table with the corresponding corresponding in the paid account book Whether the second preset information of the paid record is the same;

When the second preset information of the payable record in the accounts payable table is different from the second preset information of the corresponding paid record in the paid account book, the information that the data is inconsistent is output; and

When the second preset information of the payable record in the accounts payable table is the same as the second preset information of the corresponding paid record in the paid account book, the output data collates the accurate information.
A storage medium according to claim 17, wherein said computer readable instructions are executed by one or more processors such that said one or more processors execute said Before the steps of paying the record to obtain the record of the same employee ID in the account book to be paid, the method further includes:

Determining whether there is a difference between the employee identification in the accounts payable table and the employee identification in the paid account book; and

When there is a difference between the employee identification in the accounts payable table and the employee identification in the actual payment account table, the difference between the payable record and the difference in the account payment form is displayed. Pay the actual record in the account statement.
A storage medium according to claim 17 or 18, wherein said computer readable instructions are executed by one or more processors such that said comparing said employee identification performed by said one or more processors is the same The steps of whether the first preset information of the record should be the same, including:

Comparing whether the basic information of the payable records with the same employee identification is the same;

When the basic information of the payable records with the same employee identification is different, outputting the record of the difference that the basic information is different, and continuing to determine whether the cardinality information of the record of the same basic information is the same;

When the cardinality information of the accounts to be paid with the same basic information is different, the first preset information of the payable records with the same employee identification is different, and the record of the accounts whose cardinality information is different is output;

When the cardinality information of the accounts to be paid with the same basic information is the same, the first preset information of the payable records with the same employee identity is the same.
A storage medium according to claim 19, wherein said computer readable instructions are executed by one or more processors such that said one or more processors perform said comparison of said payables in a ledger table The step of whether the second preset information of the record to be paid is the same as the second preset information of the corresponding paid record in the paid account book comprises:

Comparing whether the payable record in the accounts payable table is the same as the basic information of the corresponding paid record in the paid account book;

When the basic information of the record to be paid in the account receivable form is different from the basic information of the corresponding paid record in the paid account book, the record of the difference in the basic information is output and Make a record of the payment, and continue to judge whether the cardinality information of the same payable record and the paid record of the same basic information is the same;

When the cardinality information of the same payable record and the paid record of the basic information is different, the payable record and the paid record which are different in the cardinality information are output, and the record of the same payable record of the cardinality information is continuously determined. Whether the amount information of the paid record is the same;

When the amount information of the payable record and the paid record of the same cardinality information are different, the second preset information of the record to be paid in the accountable account book corresponds to the actual paid account book The second preset information of the paid-in record is different, and outputs the payable record and the paid-up record that the amount information is different; and

When the amount information of the payable record and the paid record of the same cardinality information are the same, the second preset information of the payable record in the accountable account form and the corresponding corresponding in the paid account book The second preset information of the paid record is the same.