SQL Payroll Course
Course Objectives
The first and most important goal of payroll system is efficiency. Efficient payroll systems save time and money by ensuring that pay payments go out on time and in the correct amounts each pay period. Once the system is set up, many parts can be automated, to reduce errors and delays.
Course Contents
- How to Setup Company Profile
- Maintain Employee
- Payroll Maintenance
- Maintain Wages
- Maintain Frequency
- Maintain Contribution
- Maintain Allowance
- Maintain Overtime
- Maintain Payment Method
- Process Salary
- Month End Payroll
- Open Payroll
- Open Pending Payroll
- Payroll Report
- SQL Payroll Leave
- Maintenance Leave
- Maintain Leave Type
- Maintain Leave Group
- Leave Application
- Leave Entitlement Processor
- Leave Report
- Setting
- Leave Brought Forward
- Where to key-in PCB Receipt?
- Opening Balance for Employee
- Increment Letter
- Import from Excel
- SQL View
- SQL Bonus in SQL Payroll
- Customize EA form
- Tax Benefit Info
Who should attend
Payroll Clerk, Payroll Manager, Accounts Assistant, Accounts Clerk, Accounts Executives, Accountant, Director, Financial Controller
Learning Outcome
Upon completion of this course, trainee will be able to do:
Malaysian Payroll & Salary Calculation. Auto-calculate EPF, SOCSO, EIS, PCB and HRDF. Integration payroll system with banks and accounting system and send e-payslip to employees.
