CN116091015A - Payroll system, payroll method, electronic device, and storage medium - Google Patents
Payroll system, payroll method, electronic device, and storage medium Download PDFInfo
- Publication number
- CN116091015A CN116091015A CN202310365220.3A CN202310365220A CN116091015A CN 116091015 A CN116091015 A CN 116091015A CN 202310365220 A CN202310365220 A CN 202310365220A CN 116091015 A CN116091015 A CN 116091015A
- Authority
- CN
- China
- Prior art keywords
- information
- wage
- online banking
- uploading
- acquiring
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/105—Human resources
- G06Q10/1057—Benefits or employee welfare, e.g. insurance, holiday or retirement packages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Accounting & Taxation (AREA)
- Theoretical Computer Science (AREA)
- Economics (AREA)
- Marketing (AREA)
- Finance (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The embodiment of the invention discloses a wage issuing system, a wage issuing method, electronic equipment and a storage medium, wherein the wage issuing method comprises the following steps: acquiring an enterprise wage table, and determining wage staff to be sent and corresponding issuing amount information of each wage staff to be sent based on the enterprise wage table; acquiring a corresponding employee information table based on the wage to be sent, and acquiring first list name information based on the employee information table; acquiring a corresponding online banking uploading template based on the online banking type information, and acquiring second column name information based on the online banking uploading template; performing information matching on the first column name information and the second column name information, screening out column names identical to the second column name information from the employee information table based on an information matching result, and filling corresponding contents into an online banking uploading template to obtain an online banking uploading file; and performing wage distribution based on the online banking uploading file. The wage issuing method solves the problems that in the prior art, a plurality of bank online banking uploading files cannot be generated by one key, and staff cannot be allowed to use different bank cards to issue wages.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a payroll system, a payroll method, an electronic device, and a storage medium.
Background
The bank issuing platform only receives the online banking uploading file which is completely the same as the online banking uploading template file format of the bank issuing platform, and when the enterprise wage form is different from the online banking uploading template file format of the bank, the bank issuing platform cannot identify the enterprise wage form and cannot normally issue wages. Therefore, after the enterprise user generates the enterprise payroll, a bank generation list is required to be manufactured again according to the file format requirement of the bank generation platform online banking uploading template, and the list making workload of enterprise staff is increased.
And the existing bank agent platform only allows staff to upload files by using the online banking consistent with the bank agent platform, and when the online banking inconsistent with the bank agent platform is used by the staff to upload files, the bank agent platform cannot identify the online banking upload files and cannot normally send wages.
Disclosure of Invention
The embodiment of the invention aims to provide a wage issuing system, a wage issuing method, electronic equipment and a storage medium, which are used for solving the problem that in the prior art, a plurality of bank online banking uploading files cannot be generated by one key, and staff cannot be allowed to use different bank cards to issue wages.
In order to achieve the above object, an embodiment of the present invention provides a payroll method, which specifically includes:
acquiring an enterprise wage table, and determining wage staff to be sent and corresponding issuing amount information of each wage staff to be sent based on the enterprise wage table;
acquiring a corresponding employee information table based on the employee to be waged, and acquiring first list name information based on the employee information table, wherein the first list name information comprises internet banking type information;
acquiring a corresponding online banking uploading template based on the online banking type information, and acquiring second column name information based on the online banking uploading template;
information matching is carried out on the first column name information and the second column name information to obtain an information matching result, column names which are the same as the second column name information are screened out from the staff information table based on the information matching result, and contents corresponding to the column names and the issued amount information are filled into the online banking uploading template to obtain an online banking uploading file;
and performing wage distribution based on the online banking uploading file.
Based on the technical scheme, the invention can also be improved as follows:
further, the obtaining the enterprise wage table, determining wage staff to be sent and the corresponding issuing amount information of each wage staff to be sent based on the enterprise wage table, includes:
searching whether the online banking type of the staff to be sent is null, and generating error reporting information when the online banking type is null.
Further, the step of obtaining a corresponding employee information table based on the employee to be waged, and obtaining first list name information based on the employee information table, where the first list name information includes internet banking type information, includes:
determining wage card information used by wage staff to be sent at the moment based on a wage table, wherein the wage card information comprises main card information and standby card information;
and determining the internet banking type information based on the wage card information.
Further, the step of performing information matching on the first column name information and the second column name information to obtain an information matching result, screening column names identical to the second column name information from the employee information table based on the information matching result, and filling the contents corresponding to the column names and the issued amount information into the online banking uploading template to obtain an online banking uploading file, includes:
setting the value of the online banking uploading template based on the first column name information and the release amount information so as to acquire second column name information;
and screening out the column names which are the same as the characters of the second column name information from the first column name information, acquiring a first selected column from the enterprise payroll based on the column names, and filling the first selected column into the online banking uploading template.
Further, the payroll issuing based on the online banking uploading file comprises:
the method comprises the steps of obtaining wage issuing information, wherein the wage issuing information comprises online banking types, wage issuing numbers corresponding to the online banking types, first generation of money sending data corresponding to the online banking types and online banking uploading templates corresponding to the online banking types;
and responding to a payment voucher generation request, acquiring a payment voucher template corresponding to the wage issuance information from a preset template library, wherein the payment voucher comprises internet banking type information, wage issuance number information corresponding to the internet banking type, internet banking type generation amount information, wage issuance date information, customer short information, wage month information, user name information and user coding information.
Further, the payroll method further includes:
each line of information of the expense voucher template comprises a plurality of elements, each line of information in the expense voucher template is traversed in sequence, and each element is obtained from the currently traversed target line of information.
Determining element values of all elements in the target line information according to the wage issuing information, and splicing the element values of all elements in the target line information into character string information;
and forming the expense voucher in the PNG picture format according to the character string information corresponding to each line of information.
Further, the payroll method further includes:
and carrying out report processing on the expense vouchers and the online banking uploading files, and carrying out payroll issuing based on the reported online banking uploading files and the expense vouchers.
A payroll system, comprising:
the first acquisition module is used for acquiring an enterprise wage table, and determining wage staff to be sent and corresponding issuing amount information of each wage staff to be sent based on the enterprise wage table;
the second acquisition module is used for acquiring a corresponding employee information table based on the employee to be processed, and acquiring first list name information based on the employee information table, wherein the first list name information comprises internet banking type information;
the third acquisition module is used for acquiring a corresponding online banking uploading template based on the online banking type information and acquiring second column name information based on the online banking uploading template;
the matching module is used for carrying out information matching on the first column name information and the second column name information to obtain an information matching result;
the screening and filling module is used for screening out the column names which are the same as the second column name information from the staff information table based on the information matching result, and filling the content corresponding to the column names and the issued amount information into the online banking uploading template to obtain an online banking uploading file;
and the wage issuing module is used for issuing wages based on the online banking uploading file.
An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of the method when the computer program is executed.
A non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the method.
The embodiment of the invention has the following advantages:
according to the wage issuing method, an enterprise wage list is obtained, and wage to be issued and issuing amount information corresponding to each wage to be issued are determined based on the enterprise wage list; acquiring a corresponding employee information table based on the employee to be waged, and acquiring first list name information based on the employee information table, wherein the first list name information comprises internet banking type information; acquiring a corresponding online banking uploading template based on the online banking type information, and acquiring second column name information based on the online banking uploading template; information matching is carried out on the first column name information and the second column name information to obtain an information matching result, column names which are the same as the second column name information are screened out from the staff information table based on the information matching result, and contents corresponding to the column names and the issued amount information are filled into the online banking uploading template to obtain an online banking uploading file; the wage distribution is carried out based on the online banking uploading files, so that the problem that in the prior art, a plurality of bank online banking uploading files cannot be generated by one key, and staff cannot be allowed to use different bank cards for wage distribution is solved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below. It will be apparent to those skilled in the art from this disclosure that the drawings described below are merely exemplary and that other embodiments may be derived from the drawings provided without undue effort.
The structures, proportions, sizes, etc. shown in the present specification are shown only for the purposes of illustration and description, and are not intended to limit the scope of the invention, which is defined by the claims, but rather by the claims.
FIG. 1 is a flow chart of a payroll method of the present invention;
FIG. 2 is a block diagram of a payroll system of the present invention;
fig. 3 is a schematic diagram of an entity structure of an electronic device according to the present invention.
Wherein the reference numerals are as follows:
the system comprises a first acquisition module 10, a second acquisition module 20, a third acquisition module 30, a matching module 40, a screening and filling module 50, a wage issuing module 60, an electronic device 70, a processor 701, a memory 702 and a bus 703.
Detailed Description
Other advantages and advantages of the present invention will become apparent to those skilled in the art from the following detailed description, which, by way of illustration, is to be read in connection with certain specific embodiments, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Examples
Fig. 1 is a flowchart of an embodiment of a payroll method according to the present invention, and as shown in fig. 1, the payroll method according to the embodiment of the present invention includes the following steps:
s101, acquiring an enterprise wage list, and determining wage staff to be sent and corresponding issuing amount information of each wage staff to be sent based on the enterprise wage list;
specifically, the enterprise payroll includes employee name, issue amount, base payroll, performance payroll, overtime payroll, benefits subsidy, bonuses, deduction payroll, payroll aggregate, and the like;
the bank generation platform only needs to finish the money distribution according to the distribution amount except the names, account numbers and the joint line number information of the payee, and various payroll details related to the distribution amount are not needed, so that the number of items in the online bank uploading template is far smaller than that of the enterprise payroll, and only the to-be-distributed payroll and the corresponding distribution amount information of each to-be-distributed payroll are determined based on the enterprise payroll.
S102, acquiring a corresponding staff information table based on staff to be processed, and acquiring first list name information based on the staff information table, wherein the first list name information comprises internet banking type information;
specifically, whether the number of the online banking types is larger than 1 is judged based on the online banking type information, and when the number of the online banking types is larger than 1, corresponding online banking uploading templates are respectively obtained based on a plurality of the online banking type information.
The employee information table includes: bank payee, employee number, employee contact, bank account number, combination number, identification number, and online banking type;
determining wage card information used by wage staff to be sent at the moment based on a wage table, wherein the wage card information comprises main card information and standby card information;
determining the internet banking type information based on the wage card information, and determining whether wages are received by a to-be-issued wage staff by using a main card or by using a standby card at the moment; different online banking types correspond to different online banking upload templates. Searching whether the online banking type of the staff to be sent is null, and generating error reporting information when the online banking type is null.
S103, acquiring a corresponding online banking uploading template based on the online banking type information, and acquiring second column name information based on the online banking uploading template;
specifically, the online banking types comprise a plurality of different banks, and the different online banking types correspond to online banking uploading templates of different bank generation platforms.
And S104, carrying out information matching on the first column name information and the second column name information to obtain an information matching result, screening out column names which are the same as the second column name information from the staff information table based on the information matching result, and filling the content and the release amount information corresponding to the column names into an online banking uploading template to obtain an online banking uploading file.
Specifically, the column names which are the same as the characters of the second column name information are screened out from the first column name information, a first selected column is obtained from the enterprise payroll based on the column names, and the first selected column is filled into the online banking uploading template;
the employee information list comprises names, bank payees, employee numbers, employee contact information, bank accounts, line numbers, identity card numbers and bank where the accounts are opened; the online banking uploading template comprises a family name, an account number, a line number and an amount;
the enterprise wage list comprises the corresponding issued amount information of each wage staff to be issued;
as shown in table 1, the value setting is performed on the online banking uploading template based on the first column name information, and account numbers, account names, amounts and account opening places in the table head of the online banking uploading template are respectively performed with double-well number value setting, so that the account numbers, the account names, the amounts and the account opening places are converted into # bank account numbers, # bank payee, # and # issuing amounts and # account opening banks, # to obtain second column name information; and screening out the column names which are the same as the characters of the second column name information from the first column name information, acquiring a first selected column from the enterprise payroll based on the column names, and filling the first selected column into the online banking uploading template. And filling contents of a # bank account number#, # bank payee# and a # bank place of opening # in the employee information into the online banking uploading template. And filling the # issuing amount # in the enterprise payroll to the online banking uploading template.
TABLE 1
S105, performing wage distribution based on the online banking uploading file;
specifically, wage issuing information is obtained, wherein the wage issuing information comprises online banking types, wage issuing numbers corresponding to the online banking types, first generation sending amount data corresponding to the online banking types and online banking uploading templates corresponding to the online banking types;
generating a payment voucher in response to a payment voucher generation request, wherein the payment voucher comprises internet banking type information, payroll issue number information corresponding to the internet banking type, internet banking type generation amount information, payroll issue date information, customer abbreviation information, payroll month information, user name information and user coding information.
Each line of information of the expense voucher template comprises a plurality of elements, each line of information in the expense voucher template is traversed in sequence, and each element is obtained from the currently traversed target line of information;
determining element values of all elements in the target line information according to the wage issuing information, and splicing the element values of all elements in the target line information into character string information;
and forming the expense voucher in the PNG picture format according to the character string information corresponding to each line of information.
The expense voucher and the online banking uploading file are synchronously generated, a plurality of online banking uploading files are generated by one key, and meanwhile, each online banking uploading file correspondingly generates an expense voucher.
The system obtains bank payee information, such as: the bank payee WU of the employee WANG, and the name of the employee is WANG WU; and acquiring bank payee information WU WANG.
The online banking type includes several different banks.
Specifically, in one embodiment, when there are two types of online banking, the payroll number (for example, 9) corresponding to the first type of bank is obtained, the payroll number (for example, 5) corresponding to the second type of bank is obtained, the first generation of monetary amount data (for example, 7 ten thousand 6) corresponding to the first type of bank is obtained, and the first generation of monetary amount data (for example, 4 ten thousand 2) corresponding to the second type of bank is obtained.
The wage issuing method comprises the steps of obtaining an enterprise wage table, and determining wage staff to be issued and issuing amount information corresponding to each wage staff to be issued based on the enterprise wage table; acquiring a corresponding employee information table based on the employee to be waged, and acquiring first list name information based on the employee information table, wherein the first list name information comprises internet banking type information; acquiring a corresponding online banking uploading template based on the online banking type information, and acquiring second column name information based on the online banking uploading template; information matching is carried out on the first column name information and the second column name information to obtain an information matching result, column names which are the same as the second column name information are screened out from the staff information table based on the information matching result, and contents corresponding to the column names and the issued amount information are filled into the online banking uploading template to obtain an online banking uploading file; and performing wage distribution based on the online banking uploading file. The method solves the problems that in the prior art, a plurality of bank online banking uploading files cannot be generated by one key, and staff cannot be allowed to use different bank cards to issue wages.
FIG. 2 is a flow chart of an embodiment of the payroll system of the present invention; as shown in fig. 2, the payroll system provided by the embodiment of the invention includes the following steps:
a first obtaining module 10, configured to obtain an enterprise payroll, and determine payroll to be sent and issue amount information corresponding to each payroll to be sent based on the enterprise payroll;
a second obtaining module 20, configured to obtain a corresponding employee information table based on the employee to be waged, and obtain first column name information based on the employee information table, where the first column name information includes internet banking type information;
a third obtaining module 30, configured to obtain a corresponding online banking uploading template based on the online banking type information, and obtain second column name information based on the online banking uploading template;
a matching module 40, configured to match the first column name information with the second column name information to obtain an information matching result;
the screening and filling module 50 is configured to screen out a column name identical to the second column name information from the employee information table based on the information matching result, and fill the content corresponding to the column name and the issued amount information into the online banking uploading template to obtain an online banking uploading file;
and the payroll module 60 is used for carrying out payroll based on the online banking uploading file.
The first acquisition module 10 is further configured to:
searching whether the online banking type of the staff to be sent is null, and generating error reporting information when the online banking type is null.
The second acquisition module 20 is further configured to:
determining wage card information used by wage staff to be sent at the moment based on a wage table, wherein the wage card information comprises main card information and standby card information;
and determining the internet banking type information based on the wage card information.
The screening and filling module 50 is further configured to:
setting the value of the online banking uploading template based on the first column name information to obtain second column name information;
and screening out the column names which are the same as the characters of the second column name information from the first column name information, acquiring a first selected column from the enterprise payroll based on the column names, and filling the first selected column into the online banking uploading template.
The payroll module 60 is also configured to:
the method comprises the steps of obtaining wage issuing information, wherein the wage issuing information comprises online banking types, wage issuing numbers corresponding to the online banking types, first generation of money sending data corresponding to the online banking types and online banking uploading templates corresponding to the online banking types;
and responding to a payment voucher generation request, acquiring a payment voucher template corresponding to the wage issuance information from a preset template library, wherein the payment voucher comprises internet banking type information, wage issuance number information corresponding to the internet banking type, internet banking type generation amount information, wage issuance date information, customer short information, wage month information, user name information and user coding information.
Each line of information of the expense voucher template comprises a plurality of elements, each line of information in the expense voucher template is traversed in sequence, and each element is obtained from the currently traversed target line of information;
determining element values of all elements in the target line information according to the wage issuing information, and splicing the element values of all elements in the target line information into character string information;
and forming the expense voucher in the PNG picture format according to the character string information corresponding to each line of information.
And carrying out report processing on the expense vouchers and the online banking uploading files, and carrying out payroll issuing based on the reported online banking uploading files and the expense vouchers.
According to the wage issuing system, an enterprise wage list is acquired through a first acquisition module 10, and wage to be issued and issuing amount information corresponding to each wage to be issued are determined based on the enterprise wage list; acquiring a corresponding staff information table based on the staff to be waged through a second acquisition module 20, and acquiring first list name information based on the staff information table, wherein the first list name information comprises internet banking type information; acquiring a corresponding online banking uploading template based on the online banking type information through a third acquisition module 30, and acquiring second column name information based on the online banking uploading template; information matching is carried out on the first column name information and the second column name information through a matching module 40 to obtain an information matching result; screening out a column name which is the same as the second column name information from the staff information table based on the information matching result by a screening and filling module 50, and filling the content corresponding to the column name and the issued amount information into the online banking uploading template to obtain an online banking uploading file; payroll is performed by payroll module 60 based on the online banking upload file. The wage issuing method solves the problems that in the prior art, a plurality of bank online banking uploading files cannot be generated by one key, and staff cannot be allowed to use different bank cards to issue wages.
Fig. 3 is a schematic diagram of an entity structure of an electronic device according to an embodiment of the present invention, as shown in fig. 3, an electronic device 70 includes: a processor 701, a memory 702, and a bus 703;
wherein, the processor 701 and the memory 702 complete communication with each other through the bus 703;
the processor 701 is configured to invoke program instructions in the memory 702 to perform the methods provided by the above-described method embodiments, for example, including: acquiring an enterprise wage table, and determining wage staff to be sent and corresponding issuing amount information of each wage staff to be sent based on the enterprise wage table; acquiring a corresponding employee information table based on the employee to be waged, and acquiring first list name information based on the employee information table, wherein the first list name information comprises internet banking type information; acquiring a corresponding online banking uploading template based on the online banking type information, and acquiring second column name information based on the online banking uploading template; information matching is carried out on the first column name information and the second column name information to obtain an information matching result, column names which are the same as the second column name information are screened out from the staff information table based on the information matching result, and contents corresponding to the column names and the issued amount information are filled into the online banking uploading template to obtain an online banking uploading file; and performing wage distribution based on the online banking uploading file.
The present embodiment provides a non-transitory computer readable storage medium storing computer instructions that cause a computer to perform the methods provided by the above-described method embodiments, for example, including: acquiring an enterprise wage table, and determining wage staff to be sent and corresponding issuing amount information of each wage staff to be sent based on the enterprise wage table; acquiring a corresponding employee information table based on the employee to be waged, and acquiring first list name information based on the employee information table, wherein the first list name information comprises internet banking type information; acquiring a corresponding online banking uploading template based on the online banking type information, and acquiring second column name information based on the online banking uploading template; information matching is carried out on the first column name information and the second column name information to obtain an information matching result, column names which are the same as the second column name information are screened out from the staff information table based on the information matching result, and contents corresponding to the column names and the issued amount information are filled into the online banking uploading template to obtain an online banking uploading file; and performing wage distribution based on the online banking uploading file.
Those of ordinary skill in the art will appreciate that: all or part of the steps for implementing the above method embodiments may be implemented by hardware related to program instructions, and the foregoing program may be stored in a computer readable storage medium, where the program, when executed, performs steps including the above method embodiments; and the aforementioned storage medium includes: various storage media such as ROM, RAM, magnetic or optical disks may store program code.
The apparatus embodiments described above are merely illustrative, wherein elements illustrated as separate elements may or may not be physically separate, and elements shown as elements may or may not be physical elements, may be located in one place, or may be distributed over a plurality of network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment. Those of ordinary skill in the art will understand and implement the present invention without undue burden.
From the above description of the embodiments, it will be apparent to those skilled in the art that the embodiments may be implemented by means of software plus necessary general hardware platforms, or of course may be implemented by means of hardware. Based on such understanding, the foregoing technical solution may be embodied essentially or in a part contributing to the prior art in the form of a software product, which may be stored in a computer readable storage medium, such as ROM/RAM, a magnetic disk, an optical disk, etc., including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the embodiments or the methods of some parts of the embodiments.
While the invention has been described in detail in the foregoing general description and specific examples, it will be apparent to those skilled in the art that modifications and improvements can be made thereto. Accordingly, such modifications or improvements may be made without departing from the spirit of the invention and are intended to be within the scope of the invention as claimed.
Claims (10)
1. A payroll method, the method comprising:
acquiring an enterprise wage table, and determining wage staff to be sent and corresponding issuing amount information of each wage staff to be sent based on the enterprise wage table;
acquiring a corresponding employee information table based on the employee to be waged, and acquiring first list name information based on the employee information table, wherein the first list name information comprises internet banking type information;
acquiring a corresponding online banking uploading template based on the online banking type information, and acquiring second column name information based on the online banking uploading template;
information matching is carried out on the first column name information and the second column name information to obtain an information matching result, column names which are the same as the second column name information are screened out from the staff information table based on the information matching result, and contents corresponding to the column names and the issued amount information are filled into the online banking uploading template to obtain an online banking uploading file;
and performing wage distribution based on the online banking uploading file.
2. The payroll method of claim 1, wherein the obtaining a corresponding employee information table based on the payroll employee to be sent, obtaining first list name information based on the employee information table, wherein the first list name information includes internet banking type information, comprises:
searching whether the online banking type of the staff to be sent is null, and generating error reporting information when the online banking type is null.
3. The payroll method of claim 1, wherein the obtaining a corresponding employee information table based on the payroll employee to be sent, obtaining first list name information based on the employee information table, wherein the first list name information includes internet banking type information, comprises:
determining wage card information used by wage staff to be sent at the moment based on a wage table, wherein the wage card information comprises main card information and standby card information;
and determining the internet banking type information based on the wage card information.
4. The payroll issuing method according to claim 1, wherein the step of performing information matching on the first column name information and the second column name information to obtain an information matching result, screening out column names identical to the second column name information from the employee information table based on the information matching result, and filling the contents corresponding to the column names and the issue amount information into the online banking uploading template to obtain an online banking uploading file, includes:
setting the value of the online banking uploading template based on the first column name information and the release amount information so as to acquire second column name information;
and screening out the column names which are the same as the characters of the second column name information from the first column name information, acquiring a first selected column from the enterprise payroll based on the column names, and filling the first selected column into the online banking uploading template.
5. The payroll method as claimed in claim 1, wherein said payroll based on said online banking upload file comprises:
the method comprises the steps of obtaining wage issuing information, wherein the wage issuing information comprises online banking types, wage issuing numbers corresponding to the online banking types, first generation of money sending data corresponding to the online banking types and online banking uploading templates corresponding to the online banking types;
and responding to a payment voucher generation request, acquiring a payment voucher template corresponding to the wage issuance information from a preset template library, wherein the payment voucher comprises internet banking type information, wage issuance number information corresponding to the internet banking type, internet banking type generation amount information, wage issuance date information, customer short information, wage month information, user name information and user coding information.
6. A payroll method as defined in claim 5, further comprising:
each line of information of the expense voucher template comprises a plurality of elements, each line of information in the expense voucher template is traversed in sequence, and each element is obtained from the currently traversed target line of information;
determining element values of all elements in the target line information according to the wage issuing information, and splicing the element values of all elements in the target line information into character string information;
and forming the expense voucher in the PNG picture format according to the character string information corresponding to each line of information.
7. A payroll method as defined in claim 5, further comprising:
and carrying out report processing on the expense vouchers and the online banking uploading files, and carrying out payroll issuing based on the reported online banking uploading files and the expense vouchers.
8. A payroll system, comprising:
the first acquisition module is used for acquiring an enterprise wage table, and determining wage staff to be sent and corresponding issuing amount information of each wage staff to be sent based on the enterprise wage table;
the second acquisition module is used for acquiring a corresponding employee information table based on the employee to be processed, and acquiring first list name information based on the employee information table, wherein the first list name information comprises internet banking type information;
the third acquisition module is used for acquiring a corresponding online banking uploading template based on the online banking type information and acquiring second column name information based on the online banking uploading template;
the matching module is used for carrying out information matching on the first column name information and the second column name information to obtain an information matching result;
the screening and filling module is used for screening out the column names which are the same as the second column name information from the staff information table based on the information matching result, and filling the content corresponding to the column names and the issued amount information into the online banking uploading template to obtain an online banking uploading file;
and the wage issuing module is used for issuing wages based on the online banking uploading file.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the method according to any one of claims 1 to 7 when the computer program is executed.
10. A non-transitory computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method according to any of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310365220.3A CN116091015A (en) | 2023-04-07 | 2023-04-07 | Payroll system, payroll method, electronic device, and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310365220.3A CN116091015A (en) | 2023-04-07 | 2023-04-07 | Payroll system, payroll method, electronic device, and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116091015A true CN116091015A (en) | 2023-05-09 |
Family
ID=86206769
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310365220.3A Pending CN116091015A (en) | 2023-04-07 | 2023-04-07 | Payroll system, payroll method, electronic device, and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116091015A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5819231A (en) * | 1996-05-01 | 1998-10-06 | Electronic Data Systems Corporation | Compensation planning tool and method |
| CN108462758A (en) * | 2018-04-02 | 2018-08-28 | 平安科技（深圳）有限公司 | Bank-corporate express communication means, device, equipment and computer readable storage medium |
| CN108874760A (en) * | 2018-05-23 | 2018-11-23 | 中国平安人寿保险股份有限公司 | Report file generation method, device, computer equipment and storage medium |
| CN114169306A (en) * | 2021-12-13 | 2022-03-11 | 平安养老保险股份有限公司 | Method, device and equipment for generating electronic receipt and readable storage medium |
-
2023
- 2023-04-07 CN CN202310365220.3A patent/CN116091015A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5819231A (en) * | 1996-05-01 | 1998-10-06 | Electronic Data Systems Corporation | Compensation planning tool and method |
| CN108462758A (en) * | 2018-04-02 | 2018-08-28 | 平安科技（深圳）有限公司 | Bank-corporate express communication means, device, equipment and computer readable storage medium |
| CN108874760A (en) * | 2018-05-23 | 2018-11-23 | 中国平安人寿保险股份有限公司 | Report file generation method, device, computer equipment and storage medium |
| CN114169306A (en) * | 2021-12-13 | 2022-03-11 | 平安养老保险股份有限公司 | Method, device and equipment for generating electronic receipt and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8857713B2 (en) | Systems methods and computer program products for encoding and decoding transaction data | |
| US10121208B2 (en) | Thematic repositories for transaction management | |
| US20150363892A1 (en) | Systems methods and computer program products for encoding and decoding tax return data | |
| US11107076B1 (en) | Automatic transaction-based verification of account ownership | |
| CN109447607B (en) | Transaction method and device for unit account | |
| US10592994B1 (en) | Orchestrating electronic signature, payment, and filing of tax returns | |
| CN111028072A (en) | Supply chain financial pre-loan tone data processing method and system | |
| CN114971572A (en) | Data processing method, device, equipment and system | |
| CN100587740C (en) | Tax-control data declaration, checking treatment method of network tax-control system | |
| US20220398573A1 (en) | Machine learning classifier based on category modeling | |
| CN111383086A (en) | Contract payment financial certificate management method and system thereof | |
| US10354303B1 (en) | Verification of rental and mortgage payment history | |
| CN110335133A (en) | Processing method, system, electronic equipment and the storage medium of transaction data | |
| CN110084692A (en) | A kind of bookkeeping methods and device | |
| CN113240503A (en) | Reimbursement invoice management method, device and medium based on intelligent equipment | |
| US10915878B2 (en) | Releasee cash-release tool and methods of use | |
| CN116091015A (en) | Payroll system, payroll method, electronic device, and storage medium | |
| CN116702726A (en) | Tax management system, method, electronic device and storage medium | |
| CN111461798B (en) | Big data-based ticket business processing method, device, medium and equipment for individual user | |
| CN109614607B (en) | Report data processing method, device, computer equipment and storage medium | |
| CN112215693A (en) | Voucher generation method and related device | |
| JP6829980B2 (en) | Accounting server and detailed data acquisition method | |
| WO2021073264A1 (en) | Negotiable instrument information acquisition method and device, computer apparatus, and readable storage medium | |
| CN111767343A (en) | Test data synchronization method and device based on message queue, equipment and medium | |
| CN115456747B (en) | Automatic intelligent account settling method and device for ERP system and storage medium |
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 |