How to Generate Employee Payroll Report in brioHR
This article explains how to generate employee payroll report in brioHR. Learn how to create detailed payroll reports for a specific employee(s) and export them in Excel format for easy access and analysis.
Audience & Scope
Audience: HR Admin & Payroll Managers
Module: Payroll & Reports
Country: Malaysia
Pre-requisites: HR Module Permission for Reports Module and Payroll Manager access for Payroll Centers
Payroll reports provide essential insights into employee compensation and financial management. This article explains how you generate payroll reports for Malaysia employee payroll, providing monthly and yearly data efficiently for each individual in an easy-to-export Excel format.
The report has two tabs:
-
Individual (one employee at a time)
-
Multiple (several employees at once, grouped by payroll centre).
This step-by-step guide simplifies payroll reporting, ensuring accurate and efficient access to essential payroll data.
NOTE:
- [This guide] provides detailed instructions on how to tailor the company payroll report to extract the HRDF amount for each individual employee.
- [This guide] details the process of customizing the company payroll report to extract information regarding employees who have zakat deductions, along with their identification details such as MyKad and Passport numbers.
Steps to Generate Individual Employee Payroll Report
1. Navigate to Analytics > Report Builder

3. By default, you will be under the Individual tab. Select the specific employee and the period you want to generate the report for. You can choose a single month, multiple months, or year.

4. Click Export as Excel to download the individual employee report.
Below is an example of the report in an Excel file.
Steps to Generate a Report for Multiple Employees (Multiple Tab)
Use the Multiple tab to generate a single report covering several employees at once, grouped by payroll centre.
1. On the Employee Payroll report page, click the Multiple tab.
2. Set the following filters:
- Country — select the payroll country (Malaysia).
- Payroll Center — a multi-select list, scoped to the country you selected. Changing the country resets this selection and re-applies the default:
- If only one payroll centre exists, it's auto-selected; if several exist, the first (alphabetically) is preselected; if none exist, the field shows "No payroll center available for {country}".
- Start Month / End Month — defaults to January of the current year through the current month. The selected range cannot exceed 12 months; a longer range is rejected with "Only a 12 month date range is supported."

3. Use the employee multi-select to narrow the report to specific employees. By default, all employees are selected.
NOTE:
-
Only employees with payslips in the selected payroll centers and period appear here.
- Draft payslips are excluded from this report, same as the Individual tab.

4. Employees are grouped by payroll centre, with each employee collapsed into a single row.
5. Click the expand arrow next to an employee's name to reveal their full breakdown — pay items, Total Earnings, statutory deductions, PCB, and Net Pay — across the same monthly columns. If an employee has no value for a given pay item in a given month, it shows as 0.00.
6. Click Expand to fullscreen for a larger view while reviewing.
7. Click Export as Excel to download the report.
FAQ
Q: Can I mix payroll centres from different countries in one Multiple-tab report?
A: No. Payroll centres belong to a single country's statutory setup, so the Payroll Center selector only ever shows centres for the country currently selected — you can't mix Malaysia and Singapore centres in one report.
Owner:
Aqilah
Need Assistance?
If you have any questions or require assistance, please reach out to our support team via live chat or email us at support@briohr.com.