Reports
Human Resources
Payroll Reports
Generate payroll summaries, export payment data, and analyze compensation trends.
Payroll Reports
Generate payroll summaries, export payment data, and analyze compensation trends.
Quick Access
| Role | Navigation | Route |
|---|---|---|
| Employee | HR → Annual Payroll | /hr/my-annual-payrolls |
| HR Admin | HR → Payroll Export | /hr/payroll-exports |
| HR Admin | HR → Line Item Report | /hr/line-item-report |
| HR Admin | HR → Annual Payrolls | /hr/annual-payrolls |
Available Reports
| Report | Purpose | Access Level |
|---|---|---|
| Line Item Report | Detailed payroll breakdown | HR Admin |
| Payroll Export | Bank transfer files | HR Admin |
| Annual Payrolls | Yearly compensation summary | Employee, HR Admin |
| My Annual Payroll | Personal annual summary | Employee |
Line Item Report
Accessing the Report
- Go to HR → Line Item Report (
/hr/line-item-report) - Select payroll period
- Choose department or employee
- Generate detailed breakdown
[Screenshot: line-item-report]
Report Contents
| Section | Information |
|---|---|
| Earnings | All income components |
| Deductions | All deduction components |
| Net Pay | Final payment amount |
| Statutory | EPF, SOCSO, EIS, Tax |
Earnings Line Items
| Item | Description |
|---|---|
| Basic Salary | Base monthly wage |
| Fixed Allowances | Regular allowances |
| Variable Allowances | Performance-based |
| Overtime | OT earnings |
| Special Duty | Special duty pay |
| Bonuses | One-time payments |
| Commission | Sales commission |
| Back Pay | Adjustments |
Deductions Line Items
| Item | Description |
|---|---|
| EPF (Employee) | Provident fund |
| SOCSO | Social security |
| EIS | Employment insurance |
| PCB | Monthly tax |
| Staff Loan | Loan repayment |
| EWA | Earned wage advance |
| Penalties | Attendance penalties |
| Other | Misc deductions |
Using the Report
- Verify payroll accuracy - Check all items before finalizing
- Audit purposes - Detailed breakdown for auditors
- Employee queries - Explain payslip components
- Budget analysis - Understand cost components
Payroll Export
Accessing Export
- Go to HR → Payroll Export (
/hr/payroll-exports) - Select payroll period
- Choose export type
- Generate file
[Screenshot: payroll-export]
Export Types
| Type | Purpose |
|---|---|
| Bank File | For salary disbursement |
| EPF Submission | Provident fund payment |
| SOCSO Submission | Social security payment |
| Tax (PCB) | Monthly tax submission |
| General Export | Full data export |
Bank File Format
Bank files typically include:
- Employee name
- Bank account number
- Bank code
- Payment amount
- Reference number
Format depends on your organization's bank requirements.
Statutory Submissions
For mandatory submissions:
- Generate appropriate export
- Verify employee data
- Submit to relevant authority
- Keep confirmation records
Annual Payroll Report
Accessing the Report
- Go to HR → Annual Payrolls (
/hr/annual-payrolls) - Select year
- Choose employee or department
- View annual summary
[Screenshot: annual-payroll-report]
Report Contents
| Section | Information |
|---|---|
| Monthly Summary | Month-by-month breakdown |
| Annual Totals | Full year totals |
| Tax Summary | Annual tax deductions |
| EPF Summary | Annual EPF contributions |
| Benefits Summary | Total benefits received |
EA Form Data
Annual report provides data for:
- Form EA (annual remuneration statement)
- Tax filing
- Employee annual statements
LHDN Form E Support
If DOCUMENT_LHDN_FORM_E feature is enabled:
- Generates tax form data
- Supports annual tax filing
- Provides required formats
My Annual Payroll (Employee View)
Accessing Your Report
- Go to HR → Annual Payroll (
/hr/my-annual-payrolls) - Select year
- View your annual compensation summary
[Screenshot: my-annual-payroll]
What You Can See
- Total earnings for the year
- Month-by-month breakdown
- Total deductions
- Tax paid (for tax filing)
- EPF contributions
Report Analysis
For HR Administrators
| Analysis | How to Do It |
|---|---|
| Cost by Department | Line item report, group by department |
| OT Costs | Filter line items for OT |
| Benefits Cost | Sum benefit line items |
| Year Comparison | Annual reports, compare years |
Common Metrics
| Metric | Calculation |
|---|---|
| Total Payroll Cost | Sum of all gross pay + employer contributions |
| Average Salary | Total basic / Number of employees |
| OT Percentage | OT pay / Total earnings |
| Benefit Cost Ratio | Benefits / Basic salary |
Payroll Reconciliation
Monthly Reconciliation Steps
- Run Line Item Report
- Verify totals against bank transfers
- Check statutory contributions match
- Reconcile deductions with source records
- Document any discrepancies
Common Reconciliation Items
| Item | Verify Against |
|---|---|
| Net Pay | Bank transfer records |
| EPF | EPF submission confirmation |
| SOCSO | SOCSO submission confirmation |
| Tax | LHDN submission records |
| Loans | Loan management records |
Exporting Data
Export Options
| Format | Best For |
|---|---|
| Excel | Detailed analysis |
| CSV | System imports |
| Formal reports |
Exported Data Includes
- All selected line items
- Summary totals
- Period information
- Employee details
- Calculation basis
Common Questions
Q: How do I get data for year-end tax forms?
- Run Annual Payroll Report
- Select full year
- Export data
- Use for EA form preparation
Q: How do I verify payroll before approval?
- Run Line Item Report
- Check all earnings recorded
- Verify deductions correct
- Compare to previous period
- Review any unusual amounts
Q: Where do I find bank file for salary payment?
- Go to Payroll Export
- Select Bank File type
- Choose your bank's format
- Generate and download
Tips
- Run reports before approval - Always verify payroll data before finalizing
- Compare periods - Check against previous months for anomalies
- Archive exports - Keep copies of all statutory submissions
- Reconcile monthly - Regular reconciliation prevents year-end issues