CN112418808A - Artificial intelligent salary accounting automatic extraction method - Google Patents
Artificial intelligent salary accounting automatic extraction method Download PDFInfo
- Publication number
- CN112418808A CN112418808A CN202011376433.9A CN202011376433A CN112418808A CN 112418808 A CN112418808 A CN 112418808A CN 202011376433 A CN202011376433 A CN 202011376433A CN 112418808 A CN112418808 A CN 112418808A
- Authority
- CN
- China
- Prior art keywords
- employee
- identity
- record table
- payroll
- staff
- 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
- 238000000605 extraction Methods 0.000 title description 2
- 238000004080 punching Methods 0.000 claims abstract description 30
- 238000004364 calculation method Methods 0.000 claims abstract description 22
- 238000000034 method Methods 0.000 claims abstract description 17
- 238000013473 artificial intelligence Methods 0.000 claims description 7
- 230000002159 abnormal effect Effects 0.000 claims description 3
- 238000012550 audit Methods 0.000 claims description 3
- 239000013589 supplement Substances 0.000 claims description 3
- 238000010586 diagram Methods 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000004936 stimulating effect Effects 0.000 description 1
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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/105—Human resources
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Operations Research (AREA)
- Economics (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses an artificial intelligent salary accounting automatic lifting method, which comprises a card punching machine, a back-end database, a front-end page and a login port, wherein the card punching machine is fixedly arranged at the entrance of each department of a company, the computer of the company is provided with the login port, and the back-end database comprises: the employee information record list, the employee card punching record list and the wage accounting record list are related through key word wage numbers. According to the artificial intelligent salary accounting automatic calculation method provided by the invention, the visitor identity is set to log in a front-end page, so that staff can know the salary composition of the staff in real time, the deviation from the calculation of the staff is found in time, an undefined place is fed back to the salary accounting staff in time through a complaint project, the exception can be handled in time before the salary is released, and the phenomenon of wrong monthly compensation in the previous month is avoided.
Description
Technical Field
The invention relates to the technical field of compensation calculation, in particular to an artificial intelligent compensation automatic calculation method.
Background
First, salary of employees constitutes the economic source of life of most employees, so that the lives of the employees are guaranteed; secondly, salary of staff forms an important part of production and operation cost of enterprises on one hand, and is one of main means for stimulating labor enthusiasm of the enterprises on the other hand, so that reasonable, scientific and quick salary accounting has positive significance for operation management of the enterprises and members of a harmonious society.
The salary system of the existing company is that when the salary is issued, the staff knows the condition of the salary through a salary sheet, and the staff can calculate the salary privately, when the salary calculated by the staff is different from the actual salary issued, the situation needs to be reflected to the superior leader to wait for the processing result, the result can be compensated in the next month, the processing time is long, and the staff can not be butted with an accountant who checks the salary, so that the processing result is easy to be unsatisfactory, the contradiction between the company and the staff is caused, and the harmonious development of the company is not facilitated.
Disclosure of Invention
The invention aims to solve the defects in the prior art and provides an artificial intelligence compensation automatic calculation method.
In order to achieve the purpose, the invention adopts the following technical scheme:
the utility model provides an artificial intelligence compensation accounting automatic lifting method, includes punched-card machine, back end database, front end page and login port, the quantity of punched-card machine is a plurality of, and a plurality of punched-card machines respectively fixed set up the entrance of fixed setting in each department of company, the login port is all installed to company's computer, the back end database includes: the specific operation method comprises the following steps of:
s1, inputting the information of the new employee into an employee information record table through a login port by the human resource with the identity of a primary administrator, establishing an employee card-punching record table, and simultaneously establishing a tourist account of the new employee;
s2, the employee punches the card daily through the card punch, and attendance data of daily work attendance and work attendance are provided for the back-end database;
s3, the back-end database correspondingly records the working time length and the overtime time length of the employee according to the data transmitted by the card punch in real time;
s4, according to the business trip reimbursement bill of the employee, the accountant enters the front-end page through the login port in the identity of the secondary administrator to change the business trip reimbursement item of the employee;
s5, according to the company welfare policy, the accountant enters the front-end page through the login port by the identity of the secondary administrator, and changes the welfare project of the employee;
s6, enabling the staff to enter a front-end page through a login port in the form of the identity of the visitor, checking the current wage component of the staff, and if the staff has an objection, remarking through a complaint project;
s7, if the complaint project remarks indicate that the wage calculation is wrong, the accountant rechecks the disputed project, reckoning the wage and notifies the audit result to the staff through a mail;
s8, if the complaint project remarks are abnormal in card punching, the human resource personnel call the employee card punching record table of the employee for checking, and the checking result is respectively notified to the accountants and the employees through mails;
the employee card punching record table consists of a name, a job number, a department and a date, the payroll accounting record table consists of a name, a job number, a department, a working duration, an overtime shift, a weekend shift, a legal holiday shift, a business reimbursement, a welfare, a payroll state and a complaint project, and the employee information record table, the employee card punching record table and the payroll accounting record table are associated through a keyword payroll number;
the first-level administrator identity has a read-write right on an employee card punching record table in the back-end database, the second-level administrator identity has a read-write right on a payroll checking table in the back-end database, and the visitor identity has a read right on an employee card punching record table and a payroll checking record table of corresponding identities in the back-end database and a write right on a complaint project in the payroll checking record table.
Preferably, the payroll state item consists of fixed due payroll, work-in-duty payroll, blessing-attendance deduction.
Preferably, the formula for calculating the fixed due payroll is as follows: fixed payroll = fixed payroll/payroll days (payroll days-absence days).
Preferably, the calculation formula of the overtime pay is as follows: overtime pay = fixed pay/21.75/8 + 1.5 + hourly overtime working hours + fixed pay/21.75/8 + 2 + weekend overtime working hours + fixed pay/21.75/8 + 3-statutory holiday overtime working hours.
Preferably, the account number of the tourist identity is the employee's own job number, the initial password of the tourist identity is the last six digits of the employee's own identity number, the initial password of the tourist identity is valid only once, and the password of the tourist identity needs to be changed by oneself after the tourist identity logs in for the first time.
Preferably, the data condition of the employee card punching record table in the back-end database is updated in real time according to the signal fed back by the card puncher in real time and the supplement of human resource personnel.
The invention has the following beneficial effects:
1. according to the artificial intelligent salary accounting automatic calculation method provided by the invention, the visitor identity is set to log in a front-end page, so that staff can know the salary composition of the staff in real time, the deviation from the calculation of the staff is found in time, an undefined place is fed back to the salary accounting staff in time through a complaint project, the exception can be handled in time before the salary is released, and the phenomenon of wrong monthly compensation in the previous month is avoided.
2. The invention provides an artificial intelligent salary accounting automatic lifting method, which is characterized in that a card punch is linked with a back-end database, the back-end database performs initial calculation on salary of a staff by using a simple formula, the pressure of the salary accounting staff can be greatly reduced, the staff is butted with the salary accounting staff through a complaint project, the problem on the salary can be better processed, and the staff is equivalent to one-time salary accounting during calculation, so that the burden of the salary accounting staff is further reduced.
Drawings
FIG. 1 is a schematic structural diagram of an artificial intelligence compensation automatic calculation method according to the present invention;
FIG. 2 is a schematic diagram of a structure of an employee card-punching record table of an artificial intelligence compensation automatic calculation method according to the present invention;
FIG. 3 is a front-end page display of a secondary administrator identity login;
FIG. 4 shows the results of the front-end page when the guest is logged in for identity.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments.
In the description of the present invention, it is to be understood that the terms "upper", "lower", "front", "rear", "left", "right", "top", "bottom", "inner", "outer", and the like, indicate orientations or positional relationships based on the orientations or positional relationships shown in the drawings, are merely for convenience in describing the present invention and simplifying the description, and do not indicate or imply that the device or element being referred to must have a particular orientation, be constructed and operated in a particular orientation, and thus, should not be construed as limiting the present invention.
Referring to fig. 1-4, an artificial intelligence compensation automatic calculation method includes a plurality of card readers, a back-end database, a front-end page and a login port, the card readers are fixedly arranged at the entrances of each department of a company, the login port is installed on the computer of the company, and the back-end database includes: the system comprises an employee information recording table, an employee card punching recording table and a wage accounting recording table, wherein the employee card punching recording table consists of names, wages numbers, departments and dates, the wage accounting recording table consists of names, wages numbers, departments, working hours, duty overtime, duty on holidays, business trips, benefits, wage states and complaint items, and the employee information recording table, the employee card punching recording table and the wage accounting recording table are associated through keywords of wages.
The first-level administrator identity has the right of reading and writing the employee card reading record table in the back-end database, the second-level administrator identity has the right of reading and writing the payroll checking table in the back-end database, and the visitor identity has the right of reading the employee card reading record table and the payroll checking record table of the corresponding identity in the back-end database and the right of writing the complaint item in the payroll checking record table.
The wage state project consists of fixed wage to be issued, work-on wage, blessing and attendance deduction, wherein the calculation formula of the fixed wage to be issued is as follows: fixed due salary = fixed salary/salary days (salary days-absence days), the formula for calculating work-over salary is: overtime pay = fixed pay/21.75/8 + 1.5 + hourly overtime working hours + fixed pay/21.75/8 + 2 + weekend overtime working hours + fixed pay/21.75/8 + 3-statutory holiday overtime working hours.
The account number of the tourist identity is the employee's own job number, the initial password of the tourist identity is the last six digits of the employee's own identity card number, the initial password of the tourist identity is only valid once, the password needs to be changed by oneself after the tourist identity logs in for the first time, and the data condition of the employee card punching record table in the back-end database is updated in real time according to the signal fed back by the card punching machine in real time and the supplement of human resource personnel.
By setting the identity of the tourist to log in the front-end page, the staff can know the wage composition of the staff in real time, find the deviation calculated by the staff in time, and timely feed back the salary accounting staff from an undefined place through a complaint project, so that the abnormality can be timely handled before wage distribution, and the phenomenon of wrong monthly compensation of the previous month is avoided.
The artificial intelligence compensation automatic calculating and extracting method comprises the following specific operation methods:
s1, inputting the information of the new employee into an employee information record table through a login port by the human resource with the identity of a primary administrator, establishing an employee card-punching record table, and simultaneously establishing a tourist account of the new employee;
s2, the employee punches the card daily through the card punch, and attendance data of daily work attendance and work attendance are provided for the back-end database;
s3, the back-end database correspondingly records the working time length and the overtime time length of the employee according to the data transmitted by the card punch in real time;
s4, according to the business trip reimbursement bill of the employee, the accountant enters the front-end page through the login port in the identity of the secondary administrator to change the business trip reimbursement item of the employee;
s5, according to the company welfare policy, the accountant enters the front-end page through the login port by the identity of the secondary administrator, and changes the welfare project of the employee;
s6, enabling the staff to enter a front-end page through a login port in the form of the identity of the visitor, checking the current wage component of the staff, and if the staff has an objection, remarking through a complaint project;
s7, if the complaint project remarks indicate that the wage calculation is wrong, the accountant rechecks the disputed project, reckoning the wage and notifies the audit result to the staff through a mail;
and S8, if the complaint item is noted as abnormal card punching, the human resource personnel call the employee card punching record table of the employee for checking, and the checking result is respectively notified to the accountants and the employees through mails.
Through the linkage that sets up punched-card machine and rear end database, the rear end database utilizes simple formula, carries out the primary calculation to staff's salary, can be very big alleviate salary accounting personnel's pressure, and the staff docks with salary accounting personnel through the project of complaining, the problem on the processing salary that can be better, and when staff's own calculation, be equivalent to the one-time accounting to salary, further alleviateed the burden of accounting personnel that should remunerate.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art should be considered to be within the technical scope of the present invention, and the technical solutions and the inventive concepts thereof according to the present invention should be equivalent or changed within the scope of the present invention.
Claims (6)
1. An artificial intelligence compensation automatic calculation method, including card punching machine, back end database, front end page and login port, its characteristic lies in: the quantity of punched-card machine is a plurality of, and a plurality of punched-card machine are fixed respectively and set up the entrance at each department of company, the login port is all installed to company's computer, the back end database includes: the specific operation method comprises the following steps of:
s1, inputting the information of the new employee into an employee information record table through a login port by the human resource with the identity of a primary administrator, establishing an employee card-punching record table, and simultaneously establishing a tourist account of the new employee;
s2, the employee punches the card daily through the card punch, and attendance data of daily work attendance and work attendance are provided for the back-end database;
s3, the back-end database correspondingly records the working time length and the overtime time length of the employee according to the data transmitted by the card punch in real time;
s4, according to the business trip reimbursement bill of the employee, the accountant enters the front-end page through the login port in the identity of the secondary administrator to change the business trip reimbursement item of the employee;
s5, according to the company welfare policy, the accountant enters the front-end page through the login port by the identity of the secondary administrator, and changes the welfare project of the employee;
s6, enabling the staff to enter a front-end page through a login port in the form of the identity of the visitor, checking the current wage component of the staff, and if the staff has an objection, remarking through a complaint project;
s7, if the complaint project remarks indicate that the wage calculation is wrong, the accountant rechecks the disputed project, reckoning the wage and notifies the audit result to the staff through a mail;
s8, if the complaint project remarks are abnormal in card punching, the human resource personnel call the employee card punching record table of the employee for checking, and the checking result is respectively notified to the accountants and the employees through mails;
the employee card punching record table consists of a name, a job number, a department and a date, the payroll accounting record table consists of a name, a job number, a department, a working duration, an overtime shift, a weekend shift, a legal holiday shift, a business reimbursement, a welfare, a payroll state and a complaint project, and the employee information record table, the employee card punching record table and the payroll accounting record table are associated through a keyword payroll number;
the first-level administrator identity has a read-write right on an employee card punching record table in the back-end database, the second-level administrator identity has a read-write right on a payroll checking table in the back-end database, and the visitor identity has a read right on an employee card punching record table and a payroll checking record table of corresponding identities in the back-end database and a write right on a complaint project in the payroll checking record table.
2. The method of claim 1, wherein the method comprises: the wage state project consists of fixed due wages, work-processing wages, blessing and attendance deduction.
3. The method of claim 2, wherein the method comprises: the fixed due pay calculation formula is as follows: fixed payroll = fixed payroll/payroll days (payroll days-absence days).
4. The method of claim 2, wherein the method comprises: the overtime pay calculation formula is as follows: overtime pay = fixed pay/21.75/8 + 1.5 + hourly overtime working hours + fixed pay/21.75/8 + 2 + weekend overtime working hours + fixed pay/21.75/8 + 3-statutory holiday overtime working hours.
5. The method of claim 1, wherein the method comprises: the account number of the tourist identity is the employee's own job number, the initial password of the tourist identity is the last six digits of the employee's own identity number, the initial password of the tourist identity is valid only once, and the password is required to be changed by oneself after the tourist identity logs in for the first time.
6. The method of claim 1, wherein the method comprises: and the data condition of the employee card punching record table in the back-end database is updated in real time according to the signal fed back by the card punching machine in real time and the supplement of human resource personnel.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011376433.9A CN112418808A (en) | 2020-12-01 | 2020-12-01 | Artificial intelligent salary accounting automatic extraction method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011376433.9A CN112418808A (en) | 2020-12-01 | 2020-12-01 | Artificial intelligent salary accounting automatic extraction method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112418808A true CN112418808A (en) | 2021-02-26 |
Family
ID=74829231
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011376433.9A Pending CN112418808A (en) | 2020-12-01 | 2020-12-01 | Artificial intelligent salary accounting automatic extraction method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112418808A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113516448A (en) * | 2021-06-22 | 2021-10-19 | 汪靖源 | Efficient performance compensation management method |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002073917A (en) * | 2000-08-25 | 2002-03-12 | Business Net Corp:Kk | Wage management system and method and storage medium storing wage management program |
| CN106203936A (en) * | 2016-06-23 | 2016-12-07 | 郭进标 | A kind of Work attendance management system and method |
| CN106845937A (en) * | 2017-01-12 | 2017-06-13 | 安徽大尺度网络传媒有限公司 | A kind of HRMS based on internet |
| CN107622376A (en) * | 2017-08-31 | 2018-01-23 | 成都中建科联网络科技有限公司 | A kind of building trade Human Resources Management Method |
| CN109118180A (en) * | 2018-09-26 | 2019-01-01 | 重庆先特服务外包产业有限公司 | Compensation management system |
-
2020
- 2020-12-01 CN CN202011376433.9A patent/CN112418808A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002073917A (en) * | 2000-08-25 | 2002-03-12 | Business Net Corp:Kk | Wage management system and method and storage medium storing wage management program |
| CN106203936A (en) * | 2016-06-23 | 2016-12-07 | 郭进标 | A kind of Work attendance management system and method |
| CN106845937A (en) * | 2017-01-12 | 2017-06-13 | 安徽大尺度网络传媒有限公司 | A kind of HRMS based on internet |
| CN107622376A (en) * | 2017-08-31 | 2018-01-23 | 成都中建科联网络科技有限公司 | A kind of building trade Human Resources Management Method |
| CN109118180A (en) * | 2018-09-26 | 2019-01-01 | 重庆先特服务外包产业有限公司 | Compensation management system |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113516448A (en) * | 2021-06-22 | 2021-10-19 | 汪靖源 | Efficient performance compensation management method |
| CN113516448B (en) * | 2021-06-22 | 2023-03-21 | 汪靖源 | Performance salary management method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20100100464A1 (en) | A multi-tasked human resources and payroll accounting system | |
| CN105719123A (en) | Performance management method and system within enterprise | |
| US20060010051A1 (en) | Method and system for time sheet reporting | |
| CN102208064A (en) | Administrative collaborative approval system and approval method | |
| CN112102054A (en) | Payroll management method and system in parallel enterprise finance and tax SaaS system | |
| CN113379520A (en) | Enterprise salary calculation system and statistical method thereof | |
| CN115759857A (en) | Attendance management system for human resource management | |
| CN112418808A (en) | Artificial intelligent salary accounting automatic extraction method | |
| CN110889757A (en) | Finance and tax management system | |
| CN114240401A (en) | Salary sending system capable of preventing salary sending errors | |
| CN113642977A (en) | Enterprise human resource comprehensive management and control system and method | |
| CN116308235A (en) | Payroll accounting system and method for factory production | |
| CN116611947A (en) | Financial management audit system based on big data analysis | |
| CN111639915A (en) | Staff data management system | |
| CN110659882A (en) | Human resource comprehensive management big data supervision service system | |
| CN102890795A (en) | System and method for accounting production working hours of workshop | |
| CN111507816A (en) | Finance and tax management system | |
| CN110309222A (en) | Finance information management system | |
| CN107844963A (en) | A kind of automatic system and method for making a report on man-hour | |
| CN114971589A (en) | Salary information processing method, electronic equipment and storage medium | |
| CN113379235A (en) | User real-time data analysis and customized achievement promotion system based on small and medium enterprises | |
| Tkal | The current issues of using of the information systems in accounting | |
| TWM661206U (en) | Early warning system for retiring employees | |
| Phongphan | System development for payroll system Tan Siam Food Limited | |
| CN116796954A (en) | Intelligent management system for engineering project |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20210226 |