CN117273638A - Payroll auditing method, device, equipment, medium and program product - Google Patents

Payroll auditing method, device, equipment, medium and program product Download PDF

Info

Publication number
CN117273638A
CN117273638A CN202311211527.4A CN202311211527A CN117273638A CN 117273638 A CN117273638 A CN 117273638A CN 202311211527 A CN202311211527 A CN 202311211527A CN 117273638 A CN117273638 A CN 117273638A
Authority
CN
China
Prior art keywords
file
payroll
verification
information
processed
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202311211527.4A
Other languages
Chinese (zh)
Inventor
刘宇
徐鑫
高峰
李伟
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Industrial and Commercial Bank of China Ltd ICBC
Original Assignee
Industrial and Commercial Bank of China Ltd ICBC
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Industrial and Commercial Bank of China Ltd ICBC filed Critical Industrial and Commercial Bank of China Ltd ICBC
Priority to CN202311211527.4A priority Critical patent/CN117273638A/en
Publication of CN117273638A publication Critical patent/CN117273638A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/103Workflow collaboration or project management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/02Banking, e.g. interest calculation or account maintenance

Abstract

The present disclosure provides a payroll auditing method, apparatus, device, medium and program product, which can be applied to the technical field of artificial intelligence, and also can be applied to the financial field. The method comprises the following steps: obtaining a newspaper file uploaded by a user, wherein the newspaper file comprises at least one wage generation invention fine information; performing first verification on at least one piece of wage generation fine information according to a first preset condition, and generating a file to be processed if the first verification passes, wherein the first preset condition characterizes wage issuing content; and carrying out a second verification on the file to be processed according to a second preset condition, and if the second verification passes, generating a release file, wherein the second preset condition represents a file format.

Description

Payroll auditing method, device, equipment, medium and program product
Technical Field
The present disclosure relates to the field of artificial intelligence, and more particularly to a payroll auditing method, apparatus, device, medium, and program product.
Background
Most enterprises in the current environment perform payroll operations mainly through enterprise internet banking or network-going counter provided by banks. In the process of replacing the files, the enterprise needs to upload the batch files (such as Excel files, newspaper file and the like) of the present replacing, and the enterprise internet banking or counter directly issues the batch files one by one according to the detail content in the batch files, so that legal and compliance of the batch files cannot be controlled, and personnel with authority to modify the newspaper file can be led to unauthorized modification of the batch files or repeated wage issuing and excessive issuing of other people.
Disclosure of Invention
In view of the foregoing, the present disclosure provides a payroll auditing method, apparatus, device, medium, and program product.
According to a first aspect of the present disclosure, there is provided a payroll auditing method, comprising: obtaining a newspaper file uploaded by a user, wherein the newspaper file comprises at least one wage generation invention fine information; performing first verification on at least one piece of wage generation fine information according to a first preset condition, and generating a file to be processed if the first verification passes, wherein the first preset condition characterizes wage issuing content; and carrying out a second verification on the file to be processed according to a second preset condition, and if the second verification passes, generating a release file, wherein the second preset condition represents a file format.
According to an embodiment of the present disclosure, performing a first verification on at least one payroll invention fine information according to a first preset condition, and if the first verification passes, generating a file to be processed, including: acquiring the job level of the identity corresponding to each payroll invention fine information and the upper payroll limit preset by the job level; and comparing the issued funds of the identity in each payroll invention fine information with the payroll upper limit corresponding to the identity, and if the issued funds are smaller than the payroll upper limit, performing first verification to generate a file to be processed.
According to an embodiment of the present disclosure, a first verification is performed on at least one payroll invention fine information according to a first preset condition, and if the first verification passes, a file to be processed is generated, which further includes: acquiring identity information corresponding to each piece of wage generation invention fine information; traversing the identity information in the at least one payroll invention fine information, determining whether the identity information in the at least one payroll invention fine information is repeated, and if so, generating early warning data.
According to an embodiment of the present disclosure, a first verification is performed on at least one payroll invention fine information according to a first preset condition, and if the first verification passes, a file to be processed is generated, which further includes: acquiring a plurality of historical wage data of identities corresponding to each wage generation invention fine information; determining a basic credit of the identity according to the plurality of historical wage data; obtaining a floating value; determining a release range corresponding to each identity according to the floating value and the basic limit; judging whether the release funds of each identity are in the release range or not; if yes, the wage generation invention fine information passes the first verification; if not, the payroll invention fine information is not passed for the first verification.
According to an embodiment of the present disclosure, determining a base credit for the identity based on a plurality of historical payroll data includes: calculating the frequency of each historical payroll data; and determining the historical wage data corresponding to the maximum frequency as a basic credit.
According to an embodiment of the present disclosure, a first verification is performed on at least one payroll invention fine information according to a first preset condition, and if the first verification passes, a file to be processed is generated, which further includes: if the first verification is not passed, generating at least one early warning data; responding to the completion of the processing of at least one early warning data to obtain updated data; acquiring an electronic seal corresponding to the updated data; and under the condition that the electronic seal is determined to be correct, updating at least one piece of wage inventing fine information according to the updating data to generate a file to be processed.
According to an embodiment of the present disclosure, performing a second verification on a file to be processed according to a second preset condition, and if the second verification passes, generating a release file, including: checking the format of the file to be processed; under the condition that the format of the file to be processed is determined to be correct, verifying at least one piece of identity information and account information corresponding to the identity information in the file to be processed based on a database; and under the condition that the identity information is consistent with the account information, generating an issuing file.
According to an embodiment of the present disclosure, the method further comprises: calculating the sum of the released funds in at least one piece of payroll invention fine information to obtain a released total value; and under the condition that the total issuing value is smaller than the balance value of the user, payroll issuing is carried out according to the issuing file.
According to an embodiment of the present disclosure, a first verification is performed on at least one payroll invention fine information according to a first preset condition, and if the first verification passes, a file to be processed is generated, which further includes: acquiring at least one identity information in at least one piece of payroll invention fine information; acquiring credit information corresponding to at least one identity information; and generating early warning data according to the identity information corresponding to the credit score difference in the at least one credit information.
A second aspect of the present disclosure provides a payroll audit device comprising: the acquisition module is used for acquiring a newspaper file uploaded by a user, wherein the newspaper file comprises at least one piece of wage generation invention fine information; the first processing module is used for carrying out first verification on at least one piece of wage inventing fine information according to a first preset condition, and generating a file to be processed if the first verification passes, wherein the first preset condition characterizes wage issuing content; and the second processing module is used for carrying out second verification on the file to be processed according to a second preset condition, and generating a release file if the second verification passes, wherein the second preset condition characterizes the file format.
A third aspect of the present disclosure provides an electronic device, comprising: one or more processors; and a memory for storing one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the payroll audit method described above.
A fourth aspect of the present disclosure also provides a computer-readable storage medium having stored thereon executable instructions that, when executed by a processor, cause the processor to perform the payroll audit method described above.
A fifth aspect of the present disclosure also provides a computer program product comprising a computer program which, when executed by a processor, implements the payroll audit method described above.
Drawings
The foregoing and other objects, features and advantages of the disclosure will be more apparent from the following description of embodiments of the disclosure with reference to the accompanying drawings, in which:
FIG. 1 schematically illustrates an application scenario diagram of payroll auditing methods, apparatus, devices, media and program products according to embodiments of the present disclosure;
FIG. 2 schematically illustrates a flow chart of a payroll audit method according to an embodiment of the present disclosure;
FIG. 3 schematically illustrates a flow chart of a first verification method according to an embodiment of the present disclosure;
FIG. 4 schematically illustrates a flow chart of a first verification method according to yet another embodiment of the present disclosure;
FIG. 5 schematically illustrates a flow chart of a first verification method according to yet another embodiment of the present disclosure;
FIG. 6 schematically illustrates a flow chart of a first verification method according to yet another embodiment of the present disclosure;
FIG. 7 schematically illustrates a flow chart of a method of basic credit calculation according to yet another embodiment of the disclosure;
FIG. 8 schematically illustrates a flow chart of a method of generating a pending file for a first verification in accordance with an embodiment of the present disclosure;
FIG. 9 schematically illustrates a flow chart of a second verification method according to an embodiment of the disclosure;
FIG. 10 schematically illustrates a flow chart of a payroll audit method according to yet another embodiment of the present disclosure;
FIG. 11 schematically illustrates a block diagram of a payroll audit device according to an embodiment of the present disclosure; and
fig. 12 schematically illustrates a block diagram of an electronic device adapted to implement a payroll auditing method, according to an embodiment of the present disclosure.
Detailed Description
Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. It should be understood that the description is only exemplary and is not intended to limit the scope of the present disclosure. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the present disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. In addition, in the following description, descriptions of well-known structures and techniques are omitted so as not to unnecessarily obscure the concepts of the present disclosure.
The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. The terms "comprises," "comprising," and/or the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.
All terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art unless otherwise defined. It should be noted that the terms used herein should be construed to have meanings consistent with the context of the present specification and should not be construed in an idealized or overly formal manner.
Where expressions like at least one of "A, B and C, etc. are used, the expressions should generally be interpreted in accordance with the meaning as commonly understood by those skilled in the art (e.g.," a system having at least one of A, B and C "shall include, but not be limited to, a system having a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.).
In the technical scheme of the invention, the related user information (including but not limited to user personal information, user image information, user equipment information, such as position information and the like) and data (including but not limited to data for analysis, stored data, displayed data and the like) are information and data authorized by a user or fully authorized by all parties, and the processing of the related data such as collection, storage, use, processing, transmission, provision, disclosure, application and the like are all conducted according to the related laws and regulations and standards of related countries and regions, necessary security measures are adopted, no prejudice to the public welfare is provided, and corresponding operation inlets are provided for the user to select authorization or rejection.
Before explaining the embodiments of the present disclosure in further detail, terms and terminology involved in the embodiments of the present disclosure are explained, and the terms and terminology involved in the embodiments of the present disclosure are applicable to the following explanation.
And (5) replacing wages: is a financial intermediate service for professional institutions to send out work remuneration for enterprises and institutions, and company staff.
Newspaper file: an offer document contains offer information such as price, quantity, etc.
Gray list: between the white list and the black list. Reference is made in the embodiments of the present disclosure to a list of people who need special monitoring.
ftp: is a standard network protocol for file transfer over a network. It is composed of two parts: a client and a server. File upload, download, or delete files on the server may be performed.
The disc file: the file for checking the account of the current day is used for the bank.
The embodiment of the disclosure provides a wage issuing auditing method, which comprises the following steps: obtaining a newspaper file uploaded by a user, wherein the newspaper file comprises at least one wage generation invention fine information; performing first verification on at least one piece of wage generation fine information according to a first preset condition, and generating a file to be processed if the first verification passes, wherein the first preset condition characterizes wage issuing content; and carrying out a second verification on the file to be processed according to a second preset condition, and if the second verification passes, generating a release file, wherein the second preset condition represents a file format.
Fig. 1 schematically illustrates an application scenario diagram of payroll auditing methods, apparatus, devices, media and program products according to embodiments of the present disclosure.
As shown in fig. 1, an application scenario 100 according to this embodiment may include terminal devices 101, 102, 103, a network 104, and a server 105. The network 104 is used as a medium to provide communication links between the terminal devices 101, 102, 103 and the server 105. The network 104 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.
The user may interact with the server 105 via the network 104 using the terminal devices 101, 102, 103 to receive or send messages or the like. Various communication client applications, such as shopping class applications, web browser applications, search class applications, instant messaging tools, mailbox clients, social platform software, etc. (by way of example only) may be installed on the terminal devices 101, 102, 103.
The terminal devices 101, 102, 103 may be a variety of electronic devices having a display screen and supporting web browsing, including but not limited to smartphones, tablets, laptop and desktop computers, and the like.
The server 105 may be a server providing various services, such as a background management server (by way of example only) providing support for websites browsed by users using the terminal devices 101, 102, 103. The background management server may analyze and process the received data such as the user request, and feed back the processing result (e.g., the web page, information, or data obtained or generated according to the user request) to the terminal device.
It should be noted that the payroll auditing method provided by the embodiments of the present disclosure may be generally performed by the server 105. Accordingly, the payroll audit device provided by embodiments of the present disclosure may be generally disposed in the server 105. The payroll audit method provided by the embodiments of the present disclosure may also be performed by a server or cluster of servers other than server 105 and capable of communicating with terminal devices 101, 102, 103 and/or server 105. Accordingly, the payroll audit device provided by the embodiments of the present disclosure may also be provided in a server or server cluster that is different from the server 105 and capable of communicating with the terminal devices 101, 102, 103 and/or the server 105.
It should be understood that the number of terminal devices, networks and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
The payroll review method of the disclosed embodiment will be described in detail below with reference to fig. 2 to 10 based on the scenario described in fig. 1.
Fig. 2 schematically illustrates a flow chart of a payroll audit method according to an embodiment of the present disclosure.
As shown in fig. 2, the payroll audit method of this embodiment includes operations S210 to S260.
In operation S210, a newspaper file uploaded by a user is acquired, wherein the newspaper file includes at least one payroll invention fine information.
In some embodiments, the newspaper file may be an Excel file, a text file, or a picture file; the newspaper file comprises at least one piece of wage invention fine information, wherein the wage invention fine information is specific information that the enterprise needs to pay wages to staff at the time, and comprises specific information such as the name of each staff, the number of the staff identity card, the telephone number, the staff class, the staff work number, the staff card number, the staff current month wage numerical value and the like.
In other embodiments, a newspaper file and an electronic seal uploaded by a user are obtained.
For example, an enterprise administrator generates a newspaper file and an electronic seal through a system where the newspaper file is located, and uploads the newspaper file and the electronic seal to a server of a bank through https protocol. And when the newspaper file and the electronic seal are generated, the system can carry out first encryption processing on the newspaper file and the electronic seal.
In operation S220, a first verification is performed on at least one piece of payroll invention details information according to a first preset condition, wherein the first preset condition characterizes payroll issue content.
In operation S230, it is determined whether the first verification passes.
In operation S240, if the first verification passes, a file to be processed is generated.
In operation S250, the file to be processed is checked for the second time according to the second preset condition.
In operation S260, if the second verification passes, an issue file is generated.
In some embodiments, operation S270 is also included.
In operation S270, if the first verification or the second verification is not passed, at least one early warning data is generated.
In some embodiments, through the first preset condition and the second preset condition, early warning can be performed on whether a violation exists in the details, illegal contents and whether the file reading format is correct when the payroll is issued. For example, whether the same employee has a problem of multiple payroll issues, whether the employee payroll is issued accurately (too much or too little), and whether the employee payroll is issued accurately.
It will be appreciated that in banking systems, the payroll invention details are verified twice, on the one hand to verify the accuracy of the details and, on the other hand, to verify the format of the payroll issue file. Therefore, the money amount of payroll is not easy to cause problems, and the flow of payroll is not easy to cause problems. The efficiency and the accuracy of enterprise wage distribution are guaranteed in two aspects, and the customer experience is improved.
Fig. 3 schematically illustrates a flow chart of a first verification method according to an embodiment of the present disclosure.
As shown in fig. 3, the first verification is performed on at least one payroll invention fine information according to the first preset condition, and if the first verification passes, a file to be processed is generated, which includes operations S310 to S340.
In operation S310, a job level of the identity corresponding to each payroll invention details and a payroll upper limit preset by the job level are obtained.
In operation S320, the released funds for the identity in each payroll invention details information are compared with the payroll upper limit corresponding to the identity.
In operation S330, it is determined whether the released funds are less than the payroll upper limit.
In operation S340, if the released funds are smaller than the payroll upper limit, the first verification passes, and a pending file is generated.
In some embodiments, a first verification is performed on at least one payroll invention fine information according to a first preset condition, and if the first verification passes, a file to be processed is generated, which further includes operation S350.
In operation S350, if the released funds are greater than the payroll upper limit, at least one alert data is generated.
Specifically, the enterprise matches the corresponding job level, e.g., A, B, C, D and E, for each employee. And determining the upper payroll limit corresponding to each job level according to the maximum value of the payroll values of a plurality of employees under the job level. For example, the upper payroll limit corresponding to job level a is five thousand yuan, the upper payroll limit corresponding to job level B is eight thousand yuan, the upper payroll limit corresponding to job level C is ten thousand yuan, the upper payroll limit corresponding to job level D is ten thousand yuan, and the upper payroll limit corresponding to job level E is ten thousand five thousand yuan.
For example, in newspaper file, staff: zhang three, class A, payroll amount 4800 yuan. The upper payroll limit corresponding to Zhang three is five thousand yuan. Since 4800 is smaller than 5000, employee Zhang Sandi can generate a file to be processed through one verification; if the wage amount of Zhang three is 5500 yuan, 5500 is smaller than 5000, the first verification of the employee Zhang three is not passed, and the wage generation invention corresponding to Zhang three is extracted finely to form early warning data. And sending the early warning data to the enterprise, and reminding the enterprise of exceeding the upper payroll limit corresponding to the job level of the enterprise of the payroll of the third party, so that verification is required.
In other embodiments, the payroll upper limit record is stored and warehoused, and includes information such as an operator account number, time, limit record and the like, so that tracking of operation traces is facilitated. I.e. record the information of the staff of the enterprise setting the payroll upper limit and the operation.
Fig. 4 schematically shows a flow chart of a first verification method according to a further embodiment of the present disclosure.
As shown in fig. 4, the first verification is performed on at least one payroll invention fine information according to the first preset condition, and if the first verification passes, a file to be processed is generated, which further includes operations S410 to S450.
In operation S410, identity information corresponding to each piece of payroll invention details is acquired.
Wherein the identity information includes the name or identification number of the payroll person.
In operation S420, the identity information in the at least one payroll invention fine information is traversed.
In operation S430, it is determined whether the identity information in the at least one payroll invention details information is repeated.
In operation S440, if repeated, early warning data is generated.
In operation S450, if not, a file to be processed is generated.
In some embodiments, for all employees' names or identification numbers in the newspaper file, screening whether there are multiple employees with the same name or identification number. For example, when the employee opens three with two payroll details, the employee agrees with the risk of repeated payroll release, so that two pieces of early warning data are generated for the two details of the employee, the early warning data are sent to the enterprise, and the enterprise is reminded of two payroll release information of the employee opening three, and verification is needed. And if the identity information is not repeated, generating a file to be processed.
Fig. 5 schematically shows a flow chart of a first verification method according to a further embodiment of the present disclosure.
As shown in fig. 5, the first verification is performed on at least one payroll invention fine information according to the first preset condition, and if the first verification passes, a file to be processed is generated, which further includes operations S510 to S530.
At least one identity information of at least one payroll invention fine information is acquired in operation S510.
In operation S520, credit information corresponding to at least one identity information is acquired.
In operation S530, early warning data is generated according to the identity information corresponding to the credit score difference in the at least one credit information.
In some embodiments, the https protocol is used for calling a Chinese people bank credit system interface to acquire credit information of the personnel in the credit file, and the personnel with poor credit scores are added into a gray list for storage and warehousing, and the wage details of the personnel are extracted to form early warning data. And automatically adding the wage detail information of the enterprise personnel with the authority to modify the newspaper file into a gray list so as to prevent the enterprise personnel with the authority to modify the newspaper file from randomly modifying the wage amount of the enterprise personnel. And automatically removing the gray list for the personnel with good credit rating recovery.
Fig. 6 schematically shows a flow chart of a first verification method according to a further embodiment of the present disclosure.
As shown in fig. 6, the first verification is performed on at least one payroll invention fine information according to the first preset condition, and if the first verification passes, a file to be processed is generated, which further includes operations S610 to S670.
In operation S610, a plurality of historical wage data of identities corresponding to each wage generation invention fine information is acquired.
In operation S620, a base credit for the identity is determined based on the plurality of historical payroll data.
In operation S630, a floating value is acquired.
In operation S640, the issuing scope corresponding to each identity is determined according to the floating value and the basic credit.
In operation S650, it is determined whether the released funds for each identity are within the released range.
In operation S660, if so, the payroll invention details are first verified.
If not, the payroll invention details are not checked for the first time in operation S670.
In some embodiments, historical payroll data (i.e., 6 historical payroll data) is obtained for the 6 months prior to the employee's current issuing payroll month. The basic credit may be determined based on an average of 6 month history payroll data, or may be determined based on a mode in 6 month history payroll data. The enterprise sets a floating value for payroll (namely, a maximum payroll value and a minimum payroll value which can be achieved by a staff of a certain job level on the basis of a basic credit line, and the basic credit line is subtracted by the maximum payroll value and the minimum payroll value respectively to obtain an up-down floating value). For example, the base credit of class A is 5000 yuan, the floating value is + -2000 yuan, and the distribution range is 3000-7000 yuan. If the wage value in the wage three-wage issuing list of the A job class is 6000 yuan and belongs to the issuing range, the first verification passes; if the wage value in the wage issuing details of the A job level is 8000 yuan and does not belong to the issuing range, the first verification is not passed, and the wage issuing details of the A job level are extracted to be used as an early warning data place.
Fig. 7 schematically illustrates a flowchart of a basic credit calculation method according to still another embodiment of the present disclosure.
As shown in fig. 7, the basic credit of the identity is determined according to a plurality of historical payroll data in the embodiment, which includes operations S710 to S720.
In operation S710, a frequency of each of the historical wage data is calculated.
In operation S720, the historical payroll data corresponding to the maximum frequency is determined as a base credit.
For example, the payroll value with the largest number of occurrences is selected from the 6 historical payroll data as the base credit. For example, 6 pieces of historical payroll data for sheet three are 4200, 4300, 4800, 4200, 4800 and 4800, respectively, with the greatest frequency of occurrence, the underlying credit for sheet three is 4800 yuan.
Fig. 8 schematically illustrates a flowchart of a method of generating a pending file for a first verification according to an embodiment of the disclosure.
As shown in fig. 8, the first verification is performed on at least one payroll invention fine information according to the first preset condition, and if the first verification passes, a file to be processed is generated, which further includes operations S810 to S850.
In operation S810, if the first verification is not passed, at least one early warning data is generated.
In operation S820, update data is obtained in response to the processing of the at least one early warning data being completed.
In operation S830, an electronic stamp corresponding to the update data is acquired.
In operation S840, it is determined whether the electronic stamp is correct.
In operation S850, if it is determined that the electronic seal is correct, at least one payroll invention fine information is updated according to the update data, and a file to be processed is generated.
And performing a first verification on at least one piece of payroll invention fine information according to a first preset condition, and if the first verification passes, generating a file to be processed, and further comprising an operation S860.
In operation S860, in case it is determined that the electronic seal is incorrect, early warning data is generated.
Specifically, secondary verification is performed on the processing of the early warning data, namely, each processed early warning data is required to be provided with an electronic seal after being uploaded, if the electronic seal is inaccurate, the risk of forging the data exists, and the early warning is required to be performed again; if the electronic seal is accurate, the early warning data (updated data) processed by the enterprise is replaced with the original data corresponding to the data in the payroll statement, and the file to be processed is regenerated. If the electronic seal is absent, an enterprise administrator needs to be contacted to send the electronic seal back and check and upload the electronic seal, and each early warning data must have the electronic check seal to pass the check.
Aiming at the first verification, the method performs early warning on the conditions of excessive sending and multiple sending in payroll details, monitors personnel with security risks in enterprise generation and sending payroll files, and communicates with an enterprise administrator through an electronic approval seal to ensure the property security of the enterprise to the greatest extent by performing early warning on the conditions of excessive sending and multiple sending in payroll details, and personnel with authority to modify newspaper files.
Fig. 9 schematically shows a flow chart of a second verification method according to an embodiment of the disclosure.
As shown in fig. 9, the second verification is performed on the file to be processed according to the second preset condition, and if the second verification passes, the issued file is generated, which includes operations S910 to S960.
In operation S910, the format of the file to be processed is checked.
In operation S920, it is determined whether the format of the file to be processed is correct.
In operation S930, if it is determined that the format of the file to be processed is correct, at least one piece of identity information and account information corresponding to the identity information in the file to be processed are verified based on the database.
In operation S940, it is determined that the identity information is consistent with the account information.
In operation S950, in case it is determined that the identity information is consistent with the account information, a release file is generated
In operation S960, if it is determined that the format of the file to be processed is incorrect or if it is determined that the identity information is inconsistent with the account information, at least one early warning data is generated.
In some embodiments, the second verification verifies the format of the file to be processed. For example, whether the file contains name, identification card number and bank card number information. If there is a miss, the format check in the second check does not pass. After the format check is passed, it is necessary to verify whether the employee corresponds to the account number, so as to avoid the occurrence of a payroll account number error when payrolls are issued.
Fig. 10 schematically illustrates a flow chart of a payroll audit method according to yet another embodiment of the present disclosure.
As shown in fig. 10, the payroll audit of this embodiment further includes operations S1010 to S1040.
In operation S1010, a sum of the released funds in the at least one payroll invention fine information is calculated to obtain a released total value.
In operation S1020, it is determined whether the issued total value is smaller than the balance value of the user.
In case it is determined that the total value of the issuance is smaller than the balance value of the user in operation S1030, payroll issuance is performed according to the issuance file
In operation S1040, if it is determined that the issued total value is equal to or greater than the balance value of the user, at least one early warning data is generated.
In some embodiments, if the sum of all employee payroll (total distribution value) in the newspaper file is smaller than the balance value reserved by the enterprise in the bank, normal payroll distribution can be performed, otherwise payroll distribution cannot be performed, and early warning data of insufficient balance is generated.
Based on the wage issuing auditing method, the invention also provides a wage issuing auditing device. The device will be described in detail below with reference to fig. 11.
FIG. 11 schematically illustrates a block diagram of a payroll audit device in accordance with an embodiment of the present disclosure
As shown in fig. 11, the payroll audit device 1100 of this embodiment includes an acquisition module 1110, a first processing module 1120, and a second processing module 1130.
The obtaining module 1110 is configured to obtain a newspaper file uploaded by a user, where the newspaper file includes at least one payroll invention fine information. In an embodiment, the acquiring module 1110 may be configured to perform the operation S210 described above, which is not described herein.
The first processing module 1120 is configured to perform a first verification on at least one payroll summary information according to a first preset condition, and if the first verification passes, generate a file to be processed, where the first preset condition characterizes payroll issue contents. In an embodiment, the first processing module 1120 may be configured to perform operations S220-S240 described above, which are not described herein.
The second processing module 1130 is configured to perform a second verification on the file to be processed according to a second preset condition, and if the second verification passes, generate the release file, where the second preset condition characterizes the file format. In an embodiment, the second processing module 1130 may be configured to perform operations S250-S270 described above, which are not described herein.
According to an embodiment of the present disclosure, any of the plurality of modules in the acquisition module 1110, the first processing module 1120, and the second processing module 11 may be combined in one module to be implemented, or any of the plurality of modules may be split into a plurality of modules. Alternatively, at least some of the functionality of one or more of the modules may be combined with at least some of the functionality of other modules and implemented in one module. According to embodiments of the present disclosure, at least one of the acquisition module 1110, the first processing module 1120, and the second processing module 1130 may be implemented at least in part as hardware circuitry, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system on a chip, a system on a substrate, a system on a package, an Application Specific Integrated Circuit (ASIC), or may be implemented in hardware or firmware in any other reasonable way of integrating or packaging circuitry, or in any one of or a suitable combination of any of the three. Alternatively, at least one of the acquisition module 1110, the first processing module 1120, and the second processing module 1130 may be at least partially implemented as a computer program module, which when executed, may perform the corresponding functions.
Fig. 12 schematically illustrates a block diagram of an electronic device adapted to implement a payroll auditing method, according to an embodiment of the present disclosure.
As shown in fig. 12, an electronic device 1200 according to an embodiment of the present disclosure includes a processor 1201, which can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 1202 or a program loaded from a storage section 1208 into a Random Access Memory (RAM) 1203. The processor 1201 may include, for example, a general purpose microprocessor (e.g., a CPU), an instruction set processor and/or an associated chipset and/or a special purpose microprocessor (e.g., an Application Specific Integrated Circuit (ASIC)), or the like. Processor 1201 may also include on-board memory for caching purposes. The processor 1201 may include a single processing unit or multiple processing units for performing the different actions of the method flows according to embodiments of the disclosure.
In the RAM1203, various programs and data required for the operation of the electronic apparatus 1200 are stored. The processor 1201, the ROM1202, and the RAM1203 are connected to each other through a bus 1204. The processor 1201 performs various operations of the method flow according to the embodiments of the present disclosure by executing programs in the ROM1202 and/or RAM 1203. Note that the program may be stored in one or more memories other than the ROM1202 and the RAM 1203. The processor 1201 may also perform various operations of the method flow according to embodiments of the present disclosure by executing programs stored in the one or more memories.
According to an embodiment of the disclosure, the electronic device 1200 may also include an input/output (I/O) interface 1205, the input/output (I/O) interface 1205 also being connected to the bus 1204. The electronic device 1200 may also include one or more of the following components connected to the I/O interface 1205: an input section 1206 including a keyboard, a mouse, and the like; an output portion 1207 including a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, a speaker, and the like; a storage section 1208 including a hard disk or the like; and a communication section 1209 including a network interface card such as a LAN card, a modem, or the like. The communication section 1209 performs communication processing via a network such as the internet. The drive 1210 is also connected to the I/O interface 1205 as needed. A removable medium 1211 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is installed as needed on the drive 1210 so that a computer program read out therefrom is installed into the storage section 1208 as needed.
The present disclosure also provides a computer-readable storage medium that may be embodied in the apparatus/device/system described in the above embodiments; or may exist alone without being assembled into the apparatus/device/system. The computer-readable storage medium carries one or more programs which, when executed, implement methods in accordance with embodiments of the present disclosure.
According to embodiments of the present disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium, which may include, for example, but is not limited to: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this disclosure, a computer-readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. For example, according to embodiments of the present disclosure, the computer-readable storage medium may include the ROM1202 and/or the RAM1203 and/or one or more memories other than the ROM1202 and the RAM1203 described above.
Embodiments of the present disclosure also include a computer program product comprising a computer program containing program code for performing the methods shown in the flowcharts. The program code, when executed in a computer system, causes the computer system to implement the item recommendation method provided by embodiments of the present disclosure.
The above-described functions defined in the system/apparatus of the embodiments of the present disclosure are performed when the computer program is executed by the processor 1201. The systems, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the disclosure.
In one embodiment, the computer program may be based on a tangible storage medium such as an optical storage device, a magnetic storage device, or the like. In another embodiment, the computer program can also be transmitted, distributed over a network medium in the form of signals, and downloaded and installed via a communication portion 1209, and/or from a removable medium 1211. The computer program may include program code that may be transmitted using any appropriate network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the foregoing.
In such an embodiment, the computer program can be downloaded and installed from a network via the communication portion 1209, and/or installed from the removable media 1211. The above-described functions defined in the system of the embodiments of the present disclosure are performed when the computer program is executed by the processor 1201. The systems, devices, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the disclosure.
According to embodiments of the present disclosure, program code for performing computer programs provided by embodiments of the present disclosure may be written in any combination of one or more programming languages, and in particular, such computer programs may be implemented in high-level procedural and/or object-oriented programming languages, and/or assembly/machine languages. Programming languages include, but are not limited to, such as Java, c++, python, "C" or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of remote computing devices, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., connected via the Internet using an Internet service provider).
The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
Those skilled in the art will appreciate that the features recited in the various embodiments of the disclosure and/or in the claims may be provided in a variety of combinations and/or combinations, even if such combinations or combinations are not explicitly recited in the disclosure. In particular, the features recited in the various embodiments of the present disclosure and/or the claims may be variously combined and/or combined without departing from the spirit and teachings of the present disclosure. All such combinations and/or combinations fall within the scope of the present disclosure.
The embodiments of the present disclosure are described above. However, these examples are for illustrative purposes only and are not intended to limit the scope of the present disclosure. Although the embodiments are described above separately, this does not mean that the measures in the embodiments cannot be used advantageously in combination. The scope of the disclosure is defined by the appended claims and equivalents thereof. Various alternatives and modifications can be made by those skilled in the art without departing from the scope of the disclosure, and such alternatives and modifications are intended to fall within the scope of the disclosure.

Claims (13)

1. A payroll auditing method, comprising:
obtaining a newspaper file uploaded by a user, wherein the newspaper file comprises at least one wage generation invention fine information;
Performing first verification on the at least one payroll invention fine information according to a first preset condition, and generating a file to be processed if the first verification passes, wherein the first preset condition characterizes payroll issuing content;
and carrying out a second verification on the file to be processed according to a second preset condition, and if the second verification passes, generating a release file, wherein the second preset condition represents a file format.
2. The method of claim 1, wherein the first checking the at least one payroll invention fine information according to the first preset condition, and if the first checking passes, generating a file to be processed, includes:
acquiring the job level of the identity corresponding to each piece of wage generation invention fine information and the wage upper limit preset by the job level;
and comparing the released funds of the identity in each piece of wage generation invention fine information with the wage upper limit corresponding to the identity, and if the released funds are smaller than the wage upper limit, checking for the first time, and generating a file to be processed.
3. The method of claim 1, wherein the first verification is performed on the at least one payroll invention fine information according to a first preset condition, and if the first verification passes, a file to be processed is generated, further comprising:
Acquiring identity information corresponding to each piece of wage generation invention fine information;
traversing the identity information in the at least one piece of payroll invention fine information, determining whether the identity information in the at least one piece of payroll invention fine information is repeated, and if so, generating early warning data.
4. The method of claim 1, wherein the first verification is performed on the at least one payroll invention fine information according to a first preset condition, and if the first verification passes, a file to be processed is generated, further comprising:
acquiring a plurality of historical wage data of identities corresponding to each piece of wage generation invention fine information;
determining a basic credit of the identity according to the plurality of historical wage data;
obtaining a floating value;
determining a release range corresponding to each identity according to the floating value and the basic limit;
judging whether the release funds of each identity are in the release range or not;
if yes, the wage generation invention fine information passes the first verification;
if not, the payroll invention fine information is not passed for the first verification.
5. The method of claim 4, wherein determining the base credit for the identity based on the plurality of historical payroll data comprises:
Calculating the frequency of each historical wage data;
and determining the historical wage data corresponding to the maximum frequency as a basic credit.
6. The method of claim 1, wherein the first verification is performed on the at least one payroll invention fine information according to a first preset condition, and if the first verification passes, a file to be processed is generated, further comprising:
if the first verification is not passed, generating at least one early warning data;
obtaining updated data in response to the completion of the processing of the at least one early warning data;
acquiring an electronic seal corresponding to the updated data;
and under the condition that the electronic seal is determined to be correct, updating the at least one piece of wage generation invention fine information according to the updating data to generate a file to be processed.
7. The method of claim 1, wherein the performing the second verification on the file to be processed according to the second preset condition, and generating the release file if the second verification passes, includes:
checking the format of the file to be processed;
under the condition that the format of the file to be processed is determined to be correct, verifying at least one piece of identity information and account information corresponding to the identity information in the file to be processed based on a database;
And under the condition that the identity information is consistent with the account information, generating a release file.
8. The method of claim 1, the method further comprising:
calculating the sum of the released funds in the at least one payroll invention fine information to obtain a released total value;
and under the condition that the total issuing value is smaller than the balance value of the user, payroll issuing is carried out according to the issuing file.
9. The method of claim 1, wherein the first verification is performed on the at least one payroll invention fine information according to a first preset condition, and if the first verification passes, a file to be processed is generated, further comprising:
acquiring at least one identity information in at least one piece of payroll invention fine information;
acquiring credit information corresponding to the at least one identity information;
and generating early warning data according to the identity information corresponding to the credit score difference in the at least one credit information.
10. A payroll audit device comprising:
the acquisition module is used for acquiring a newspaper file uploaded by a user, wherein the newspaper file comprises at least one piece of wage generation invention fine information;
the first processing module is used for carrying out first verification on the at least one payroll invention fine information according to a first preset condition, and generating a file to be processed if the first verification passes, wherein the first preset condition represents payroll issuing content; and
And the second processing module is used for carrying out second verification on the file to be processed according to a second preset condition, and generating a release file if the second verification passes, wherein the second preset condition represents a file format.
11. An electronic device, comprising:
one or more processors;
storage means for storing one or more programs,
wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the method of any of claims 1-9.
12. A computer readable storage medium having stored thereon executable instructions which, when executed by a processor, cause the processor to perform the method according to any of claims 1 to 9.
13. A computer program product comprising a computer program which, when executed by a processor, implements the method according to any one of claims 1 to 9.
CN202311211527.4A 2023-09-19 2023-09-19 Payroll auditing method, device, equipment, medium and program product Pending CN117273638A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202311211527.4A CN117273638A (en) 2023-09-19 2023-09-19 Payroll auditing method, device, equipment, medium and program product

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202311211527.4A CN117273638A (en) 2023-09-19 2023-09-19 Payroll auditing method, device, equipment, medium and program product

Publications (1)

Publication Number Publication Date
CN117273638A true CN117273638A (en) 2023-12-22

Family

ID=89211648

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202311211527.4A Pending CN117273638A (en) 2023-09-19 2023-09-19 Payroll auditing method, device, equipment, medium and program product

Country Status (1)

Country Link
CN (1) CN117273638A (en)

Similar Documents

Publication Publication Date Title
US11068618B2 (en) Data processing systems for central consent repository and related methods
US11138318B2 (en) Data processing systems for data transfer risk identification and related methods
RU2451337C2 (en) Card-based rule enforcement in program
US8626617B1 (en) Method and system for identifying fixed asset transactions from multiple financial transactions
US20130226798A1 (en) Methods and systems for automating payments utilizing rules and constraints
WO2019041804A1 (en) Personalized checking method and apparatus for claim settlement orders, storage medium, and terminal
US11120162B2 (en) Data processing systems for data testing to confirm data deletion and related methods
US11947708B2 (en) Data processing systems and methods for automatically protecting sensitive data within privacy management systems
US11157654B2 (en) Data processing systems for orphaned data identification and deletion and related methods
US10706379B2 (en) Data processing systems for automatic preparation for remediation and related methods
US20210349955A1 (en) Systems and methods for real estate data collection, normalization, and visualization
WO2019028403A1 (en) Data processing systems for fulfilling data subject access requests and related methods
US10614247B2 (en) Data processing systems for automated classification of personal information from documents and related methods
US11144675B2 (en) Data processing systems and methods for automatically protecting sensitive data within privacy management systems
CN111402045B (en) Account data supervision method and device
CN117273638A (en) Payroll auditing method, device, equipment, medium and program product
US20230306426A1 (en) Systems and methods for automated validation for proprietary security implementations
US11475136B2 (en) Data processing systems for data transfer risk identification and related methods
CN115601157A (en) Quota processing method, device, electronic equipment and computer readable medium
CN115860673A (en) Asset data processing method and device, electronic equipment and storage medium
CN116611825A (en) Cross-border money transfer method, apparatus, device, medium, and program product
CN116563008A (en) Financial information management system based on cloud computing
Mousa Maintaining Data Security in Government Agencies in UK–A Case Study

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