Help Center
Go back to application
Help Center
Go back to application
Getting Started
How to Log In to XandaPayHow to Reset Your Password
Employees
How to Create a New EmployeeHow to Add Emergency ContactsHow to Add Assets How to Add Family InformationHow to Add Bank Accounts (Employee)How to Add DocumentsHow to Add Exemption HoursHow to Manage LoansHow to Add NotesHow to Add Pay DefaultsHow to View and Download Pay HistoryHow to Add Renewal Document How to Add Employee to User Defined Group
Payroll
About the Payroll ModuleHow to Create or Edit PayrollHow to Process a Payroll (Payroll Workflow)
Hours & Rates
Managing Hours Type (Codes)Managing Employee Hours ExemptionsManaging Hours Worked Related Allowance (HWRAL) MappingManaging Service Charge Applicable Hours
Income & Deductions
Loans & E-Payments
Pools
Task
Tax
Time & Attendance
About the Time & Attendance Module
Scheduler
Day End
Day End (Compact)
Reporting
About the Reporting & Analytics Module
Ad Hoc Reports
Human Resources
About the HR Module
Leave
Employee Self Service
About the Employee Self-Service (ESS) Module
Customer Self Service
About the Customer Self-Service Module
Dashboard
My Profile
Sales Orders
Invoices
Payments
Account Statement
POS & Inventory Plus
About POS & Inventory Plus (Coming Soon)
Academic Plus
About the Academics Plus Module (Coming Soon)

Managing Hours Worked Related Allowance (HWRAL) Mapping

Hours Worked Related Allowances (HWRAL) in XandaPay allow payroll administrators to link specific hours worked to an allowance. When processing payroll, the system calculates the allowance based on the total hours mapped and the predefined rate. This ensures accurate payroll calculations without manual input.

Accessing HWRAL Mapping

  1. Log in to XandaPay Enterprise.
  2. Navigate to the Payroll menu.
  3. Expand "Hours & Rates (+)" and click "HWRAL Mappings."
  4. View the existing mappings between allowances and hours codes.

Understanding the HWRAL Mapping List

The displayed list includes:

  • Allowance Code – The allowance linked to the worked hours.
  • Hours Code – The specific worked hours that contribute to the allowance calculation.
  • Active? – Indicates if the mapping is currently applied in payroll processing.

Creating a New HWRAL Mapping

  1. Click New Hours Work Related Allowance Mapping at the top.
  2. In the form that appears:
    • Select the Allowance (e.g., GASHW - Gas Allowance).
    • Choose the Hours code that should be summed for the allowance calculation (e.g., REG - Regular Hours).
    • Check the Active box to enable the mapping.
  3. Click Save to apply the mapping.

Editing an Existing HWRAL Mapping

  1. Locate the mapping in the list.
  2. Click on it to open the details.
  3. Modify the Allowance, Hours, or Active status.
  4. Click Save to update.

Example Scenario: Gas Allowance Calculation

Assume an employee has an allowance for gas (GASHW) with a rate of $10 per hour worked. The following hours are logged:

  • Regular Hours (REG): 40
  • Overtime (OT): 10

If both REG and OT are mapped to the GASHW allowance, XandaPay will calculate the total amount as:

(40+10)×10=50×10=500(40 + 10) \times 10 = 50 \times 10 = 500

Thus, the employee receives $500 as the gas allowance.

Best Practices for HWRAL Mapping

✔ Ensure allowances are correctly set as Hours Worked Related before mapping.
✔ Assign appropriate hour codes to prevent incorrect calculations.
✔ Review mappings periodically to maintain payroll accuracy.
✔ Use clear allowance and hour names for easy identification.

By using HWRAL mapping effectively, payroll teams can automate allowances based on worked hours, reducing manual data entry and ensuring accurate compensation calculations. 🚀

Was this article helpful?

Powered by Product Fruits