XimiTech
HRM Mạnh Long Hoa Lư
The HRM Mạnh Long Hoa Lư web app connects Excel payroll imports with electronic payslips by period, HR permissions and a private employee lookup area.
Project type: Internal web app with access permissions · Customers: Công ty TNHH May Mạnh Long Hoa Lư
HRM Mạnh Long Hoa Lư is an internal web app for issuing and viewing payslips at a garment company. The process starts with HR's Excel spreadsheets, turns them into electronic payslips by period and provides an account area where employees can view their own information.
Industry: HR & payroll management web app · Website: hrm.manhlonghoalu.com.vn
The challenge
The project's challenge was connecting an existing payroll process with online payslip distribution. HR needs to manage data by period, while each employee should only see authorised information. Importing, publishing and permissions must work together so one employee's lookup does not expose another employee's data.
The approach
At Mạnh Long Hoa Lư, the starting point was the Excel payroll sheet already used by the HR team. The product needed to connect that familiar work with an individual viewing area for employees. The web app’s value lies in a specific sequence: bringing data into the correct period, issuing payslips and allowing each employee to return to their own information when they need to check it.
Connecting Excel payroll to period-based payslips
Data import begins the publication process, so the structure needs to preserve the relationship between the payroll sheet, its period and each employee record. Treating Excel as merely an uploaded file would leave later viewing without context. Here, the data belongs to a period and a recipient so the electronic payslip retains the business meaning of the original sheet.
For HR, a payroll period is a unit of work to manage and reconcile. For employees, it is the reference they use when returning to an earlier payslip. Organising the same data around these uses keeps import and viewing connected even though the people at either end have different objectives.
Two roles with different working boundaries
HR administrators work with records and publication periods; employees need their own payslips. Functional permissions and account areas express that difference rather than simply changing a screen title. An employee code connects the account to its user, while access rights determine which information that user can open in the system.
With salary information, the access journey is part of the business process. Routes into a payroll period and movement between screens need to retain the current user’s context. This public account describes those roles and the organisation of records; actual accounts, salaries and employee data remain private to the business and are not used as project illustrations.
Designing for returning to a record and checking it
A payslip may be viewed when issued or revisited several periods later to ask about a difference. Period-based retrieval therefore serves a more lasting need than a list of recent notifications. Users need to recognise which payslip and period they are reading before checking details with HR.
The experience centres on small, repeated actions: signing in, choosing a period, opening a payslip and returning to the list. An internal application works well when these steps follow the organisation’s actual work. The meaningful connection is between the source data and the document an employee receives, rather than extra screens unrelated to payroll publication.
Scope of work
- Build an import flow for the Excel payroll format used by HR.
- Organise electronic payslips by period and employee profile in the system.
- Design sign-in and payslip viewing areas using accounts linked to employee IDs.
- Separate permissions for HR administrators and employees using the payslip area.
Delivered outcomes
- Excel imports and payslip publishing connect within one internal application.
- Payslips are organised by period so they can be reopened for comparison.
- Employees have a private payslip area according to their account permissions.
This case study does not publish payroll data, employee records, accounts or images containing real company information.
Behind the project
HRM Mạnh Long Hoa Lư: designing a payslip web app around a real Excel workflow
Moving an HR process online does not mean making everyone change how they work from the outset. HRM Mạnh Long Hoa Lư starts with the company's existing Excel payroll, then connects it to electronic payslip publishing and viewing. The design challenge lies in accuracy, access rights and clarity for employees.