TL;DR — Quick Summary

Aspel NOI shows errors calculating Christmas bonus: incorrect proportional amounts, wrong ISR tax, or missing CFDI. Step-by-step fix for each issue.

Christmas Bonus Calculation Errors in Aspel NOI

Aspel NOI is Mexico’s most widely used payroll system, and every December it becomes the setting for one of the most reported problems: aguinaldo (Christmas bonus) calculation errors. These range from incorrect amounts for newly hired employees, to the aguinaldo not appearing in the CFDI, or error messages such as “Error al calcular percepciones extraordinarias” (Error calculating extraordinary perceptions).

This article covers the root cause of each failure and provides the specific solution for each scenario.

The Error

The most frequent symptoms reported by Aspel NOI users when calculating aguinaldo are:

  • Incorrect proportional aguinaldo for employees who started between January and November of the current year.
  • Incorrectly calculated ISR on the aguinaldo: either the entire amount is taxed, or the UMA exemption exceeds the allowed amount.
  • The system does not recognize 30 days even though the company has it configured that way; it only applies the 15-day legal minimum.
  • Employees with mixed salaries (fixed + variable) generate inconsistent amounts when combining perceptions.
  • Error message: Error al calcular percepciones extraordinarias when running the calculation process.
  • Aguinaldo does not appear in the CFDI payroll receipt, or appears with an incorrect SAT key.
  • Difference between calculated and expected amount that does not correspond to any obvious rounding.

Root Cause

1. Incorrect Hire Date

The proportional aguinaldo calculation depends directly on the hire date recorded in the employee catalog. If this date is incorrectly entered (wrong year, inverted dd/mm/yy format, etc.), the system will calculate a different proportion.

2. Aguinaldo Days Not Configured at the Company Level

Aspel NOI references the “Aguinaldo Days” field in company parameters (Configuration > Company > General Parameters). If this field is zero or set to 15 when the company grants 30 days, the calculation will be wrong for all employees.

3. Outdated UMA Table

The ISR exemption on the aguinaldo is calculated based on the UMA (Unit of Measure and Update) value. If the UMA table in Aspel NOI has not been updated with the current year’s value, the exempt amount will be incorrect and the resulting ISR will be wrong.

4. Aguinaldo Concept Misconfigured

The concept must have:

  • SAT Key: 002 (Aguinaldo).
  • Type: Extraordinary Perception.
  • Formula: must include proportional calculation for days worked.

If the concept has a fixed formula without considering proportionality, all employees — including mid-year hires — will receive the full amount.

5. Mixed Salary Without Proper Formula

Employees with fixed and variable salary components require the aguinaldo formula to use the average of variable salary over the last 12 months (or the worked period). Aspel NOI does not do this automatically; it requires a custom concept or manual adjustment.

6. Incorrect Period Type

Aguinaldo must be processed in a period marked as “Extraordinary” or in one where the movement type allows extraordinary perceptions. If aguinaldo is included in an ordinary period without the proper configuration, the Error al calcular percepciones extraordinarias message may appear.

Step-by-Step Solution

Step 1: Verify the Hire Date for Each Affected Employee

  1. Access: Employee Catalog.
  2. Select the employee with the error.
  3. Verify the “Hire Date” field — it must match the first day the employee provided services.
  4. If incorrect, fix and save.

Tip: For a bulk review, use Reports > Employees > General List and export to Excel. Filter by hire date of the current year and compare with employment contracts.

Step 2: Configure Aguinaldo Days in Company Parameters

  1. Access: Configuration → Company → General Parameters.
  2. Locate the “Aguinaldo Days” field.
  3. Enter the correct value:
SituationAguinaldo days
Legal minimum (Federal Labor Law)15
Common company policy30
Companies with higher collective agreements40-90
  1. Save the changes.

Step 3: Update the UMA Table

  1. Access: Configuration → Tables → UMA / UMAS.
  2. Verify the UMA value for the fiscal year matches the value published by INEGI.
    • UMA 2024: $108.57 MXN daily.
    • UMA 2025: $113.14 MXN daily (verify the current value at time of calculation).
  3. The ISR exemption for aguinaldo equals 30 times the daily UMA.
  4. Save and recalculate.

Step 4: Verify the Aguinaldo Concept

  1. Access: Payroll Concepts Catalog.
  2. Locate the aguinaldo concept (search by name or SAT key 002).
  3. Confirm:
    • Perception type: Extraordinary.
    • Taxed: Only the amount exceeding 30 UMAs.
    • Exempt: First 30 UMA days.
    • Proportional formula: DailySalary * AguinaldoDays * (DaysWorked / 365).

Step 5: Calculate the Aguinaldo Period

  1. Access: Processes → Payroll Periods.
  2. Create or select the aguinaldo period (type: Extraordinary).
  3. Access: Processes → Payroll Calculation.
  4. Select the period and check “Recalculate”.
  5. Review the calculation report and verify individual amounts.

Step 6: Generate the Aguinaldo CFDI

  1. Access: Processes → CFDI Stamping.
  2. Select the aguinaldo period.
  3. Verify in the preview that the aguinaldo appears with:
    • SAT Key: 002.
    • Taxed amount and exempt amount correctly broken out.
  4. Generate the XML and download the stamped CFDI.
  5. Validate at: https://verificacfdi.facturaelectronica.sat.gob.mx.

Alternative Solution

Manual Calculation and Direct Entry

If the error persists and aguinaldo must be paid without delay, you can calculate manually in Excel and enter the amount directly:

  1. Proportional aguinaldo formula: Aguinaldo = (Daily Salary × Company Aguinaldo Days) × (Days Worked in Year ÷ 365)

  2. ISR exemption formula 2025: Exempt = 30 × $113.14 = $3,394.20 MXN (using current UMA value)

  3. In Aspel NOI, access the aguinaldo period and in the individual employee capture screen, select the aguinaldo concept and manually enter:

    • Taxed amount: the excess over the exemption.
    • Exempt amount: the first $3,394.20.

  4. Mark the concept as “Manual Entry” so the system does not overwrite it on recalculation.

Note: This is a temporary solution. Fix the underlying configuration for subsequent periods.

Prevention

Before December arrives, apply this checklist:

  • November: Review and correct hire dates for all employees in the catalog.
  • November: Update the UMA table with the current year’s value published by INEGI.
  • November: Verify the “Aguinaldo Days” field in Company Parameters has the correct value.
  • November: Apply the latest Aspel NOI updates (especially fiscal tables).
  • November: Identify employees with mixed salaries and prepare custom formulas or variable average calculations.
  • December (before calculation): Back up the Aspel NOI database before processing aguinaldo.
  • December: Run a test calculation first and compare amounts with manual Excel calculations.
  • “Error stamping the aguinaldo CFDI”: The digital seal certificate (CSD) may be expired, or the PAC may be rejecting the XML due to an error in the SAT concept key.
  • Duplicate aguinaldo in CFDI: If the ordinary December period and the extraordinary aguinaldo period overlap, the amount may appear duplicated. Verify that concepts are not included in both periods.
  • Incorrect annual ISR on aguinaldo in annual declaration: A miscalculated aguinaldo affects the annual ISR calculation. Review the perceptions and withholdings certificate for December.
  • PTU calculated on aguinaldo: Aguinaldo is not part of the PTU (profit sharing) calculation base. If Aspel NOI is including it, verify the concept configuration.

Summary

  • Aguinaldo calculation errors in Aspel NOI have six main causes: incorrect hire date, misconfigured aguinaldo days, outdated UMA table, misconfigured concept, mixed salary without proper formula, and incorrect period type.
  • The legal minimum is 15 aguinaldo days per year worked (Art. 87 LFT); companies may grant more.
  • The ISR exemption equals 30 times the current daily UMA.
  • The aguinaldo CFDI must use SAT key 002 and correctly break out taxed/exempt amounts.
  • Prepare the configuration in November to avoid last-minute errors in December.