Setting Up Country Data

This chapter provides an overview of Global Payroll core functionality in Spain and discusses how to:

Click to jump to parent topicUnderstanding Global Payroll Core Functionality in Spain

This section discusses:

Click to jump to top of pageClick to jump to parent topicRetroactivity

Retroactivity is the process of going back in time and recalculating prior calendars because changes were made after the original calculation was run. When retroactive processing occurs for a payee, the system recalculates each element generated for the payee. The difference between these results is the retro delta.

In Global Payroll, there are two methods for calculating retro:

The most common retro method used in Spain is the corrective method. Using this method, you go back and recalculate the elements of the pay run, updating all accumulators, including balance accumulators and calendar period accumulators. The recalculated pay run replaces the previously calculated run. However, the original pay run calculation remains available for auditing and reporting purposes. Rather than forwarding retro deltas to the current calendar as an adjustment, the system sends any adjustment to "Net to be Paid" for the recalculation period for the banking process to be managed.

Note. You can also set up retro with the forwarding method during your implementation, if it fits your company's needs.

Global Payroll for Spain and Retroactivity

Global Payroll for Spain delivers the corrective method as this is the standard (statutory) way to manage retroactivity in Spain.

Note. Define retro overrides on the Retro Process Overrides page.

See Defining Retroactive Processing.

Launching Retroactivity Across Different Tax Years

When the prior period is in a different tax year, your company can't collect the tax due and pay it to Hacienda because the prior year is already closed for tax reporting. This applies to both situations of underpayment and overpayment.

The solution is that, when reporting to Hacienda, deltas of the previous year are considered. The deltas are considered in Model 111 of the current month and in Model 190 for the current year (at the end of the year) as income from a previous tax year. The system calculates the IRPF tax for that delta by applying a fixed percentage (currently at 15 percent), instead of the valid IRPF percentage in the retro period or the current period.

Note. Taxes and social security are calculated differently. Social security calculation is not affected when the retro calculation is across different tax years. The way to calculate retro in this case is the same as the one used in calculating retro in the current year.

Example of Calculating Retroactivity for a Different Tax Year

Let's say that both the calendar period and the fiscal period for your pay entity start on January 1. If the retro starts in a different tax year, the fiscal period determines how the retro of taxes is calculated. The following provides the details for this example:

Note. This table summarizes all the information you'll need for your retro calculation. This table is only a suggestion using the common setup parameters that is delivered with Global Payroll for Spain. You may find that your company's requirements are different and may need to define retro differently during your implementation.

Setup Issue

Requirement

Default retro method

Corrective

Retro process (retro method)

Corrective

Retro process - does is vary?

No

Calendar period starts on:

January 1

Fiscal period starts on:

January 1

Backward limits:

No limits

Forward limits:

Two years after employee termination

Running Corrections in Global Payroll for Spain

The pure retro process calculates from a target calendar, which receives forwarded tax data regarding deltas, and updates the balance accumulators of the recalculated month. You then report the delta from the retro processing for the target calendar through complementary reporting. Thus, if you have already reported social security contributions for a given month and need to recalculate, you use pure retro processing. For example, if a company signs a labor agreement in May but needs to increase salary starting from January 1, then the company must run pure retro processing from January in the May payroll (target calendar). The company then reports the deltas from the retro calculation in a complementary report within the May FAN file.

Corrections, on the other hand, are cases where you need to rerun a finalized payroll but have not yet reported to social security for that month. Corrections enable you to report the delta on the regular monthly reporting rather than through complementary reporting. You are thus correcting a finalized payroll.

With Global Payroll for Spain, you can run corrections by using a specific run type or by using Global Payroll core off-cycle functionality. The Managing Off-Cycle Payments chapter explains both methods in detail.

See Also

Calculating Social Security Benefits

Calculating Taxes

Defining Retroactive Processing

Managing Off-Cycle Payments

Click to jump to top of pageClick to jump to parent topicPayment Keys

In Global Payroll for Spain, you can define payment keys. Options are Company, Contract Number, Department, and Establishment ID. When the payment keys of the current period don't match the payment keys in the retro period, the deltas are managed as a separate gross-to-net calculation in the current calendar period. When a retro is launched that affects more than one calendar period, the deltas that come from each one will be summed only when the payment keys match.

For example, company information is needed for tax reporting purposes. The Agencia Tributaria needs to know in which company the employee is working and being paid from.

So when retro is launched, you may need to report the tax calculation of the deltas related to the prior company. Or you may need to report the tax calculation of the deltas related to the current company. It all depends on which company is declaring the payment to the fiscal territory.

Because the corrective retro method is used in Global Payroll for Spain, deltas are not forwarded into the current period in most cases. However, regarding tax calculation, the income deltas are transferred to the current period. You should review this during implementation and set up according to your organizational requirements.

See Also

Defining the Organizational Structure

Defining Retroactive Processing

Click to jump to top of pageClick to jump to parent topicAccumulators

In Global Payroll for Spain, there are two types of accumulators:

For user-defined accumulators, there are four functional areas that have specific prefixes:

For auto-generated accumulators, there are two functional areas that have specific suffixes:

In Global Payroll for Spain, you'll define accumulators for several earnings and deductions. Accumulators for earnings include those for base salary, seniority pay, mejora voluntaria, complemento absorbible, and extra period payments. Accumulators for deductions include social security deductions.

Customer-Oriented Segment Accumulators

Global Payroll for Spain also delivers a set of customer-oriented segment accumulators. When you define an earning or deduction element, you can assign the element to these accumulators. You will need to decide which accumulators you need to update, based on the following questions:

Depending on your answer to these questions, you need to select the appropriate accumulator. The following tables provide details about the customer-oriented segment accumulators:

Compensation:

Accumulator Name

Description

CLI AC SAL BRUTO

Custom gross salary. Add elements that correspond to an employee's compensation.

CLI AC DEDUCCIONES

Custom deductions. Add elements that correspond to an employee's deductions to the gross salary.

CLI AC DEV ABSRBLE

Custom absorbable earnings. Add elements that are going to be absorbed by the net-to-gross process.

Note. If an element contributes to the gross salary and is also absorbable, it needs to be added to both CLI AC SAL BRUTO and CLI AC DEV ABSRBLE.

Taxes:

Accumulator Name

Description

CLI AC ING DIN FJO

Custom fixed taxable base. Add elements that correspond to basic or regular fixed compensation that pay taxes.

CLI AC ING VR1 S

CLI AC ING VR2 S

CLI AC ING VR3 S

Custom variable taxable base. Add elements that correspond to variable or non-regular variable compensation that pay taxes Select the right accumulator depending on the method that you want to use during estimation of variable compensation as part of the tax base estimation calculation.

CLI AC ING SPC REP

Employee taxable salary in kind. Add elements that correspond to employee in kind salary for which the taxable part is going to be paid by the employee.

CLI AC ING SPC NRE

Taxable in kind salary. Add elements that correspond to employee in kind salary for which the taxable part is going to be paid by the employer.

CLI AC RDTO IRREG

Custom non-regular income. Add elements that correspond to employee compensation accrued later than two years ago.

CLI AC RDTO IRR50

Custom non-regular income 50. Use this accumulator for irregular income affected by 50% reduction.

CLI AC RDTO IRR50D

Custom non-regular income 50D. Use this accumulator for irregular income affected by 50% reduction applying to fiscal territory Navarra.

CLI AC RDTO IRR70

Custom non-regular income 70. Use this accumulator for irregular income affected by 70% reduction.

Note. You can include an earning in just one of these tax accumulators.

Social Security:

Accumulator Name

Description

CLI AC BASE SS D

Social security daily base. Add elements that correspond to basic or regular fixed compensation that contribute to social security bases.

CLI AC BASE SS M

Social security monthly base. Add elements that correspond to compensation other than basic or regular fixed compensation that contribute to social security bases.

Note. An element will be added to either CLI AC BASE SS D or CLI AC BASE SS M, but not to both, for social security purposes.

Other purposes:

Accumulator Name

Description

CLI AC SDIA INDM

Daily Salary for Severance Pay. You can use this accumulator, if you have set it up in the Labor Agreement component, to calculate the severance payment.

CLI AC SDIA PREAV

Daily Salary for Preadvised Days. You can use this accumulator, if have set it up in the Labor Agreement component, to calculate the preadvised days earning/deduction.

CLI AC SDIA TRAM

Daily Salary for Job Litigation Salary. You can use this accumulator, if you have set it up in the Labor Agreement component, to calculate the litigation salary.

See Also

Element Ownership and Maintenance

Setting Up Accumulators

Click to jump to top of pageClick to jump to parent topicSegmentation

In Global Payroll, you can segment elements based on different events or changes. There are two types of segmentation:

Global Payroll for Spain uses element segmentation in most cases. There are many reasons why a slice can occur:

Global Payroll for Spain uses period segmentation for these changes:

Note. Global Payroll for Spain delivers segmentation setup and triggers as sample data. You must decide which changes should trigger segmentation for your company. View the delivered segmentation rules and triggers using pages in Global Payroll in your demo installation.

See Also

Defining Segmentation

Click to jump to top of pageClick to jump to parent topicTriggers

In Global Payroll, triggers are used to detect online changes to data that should result in some type of system action. Examples of common data changes that might use triggers are the hiring of a new payee, a change in pay rate, or a change in job location.

There are three types of triggers, iterative, segmentation, and retro triggers.

Global Payroll for Spain delivers triggers as sample data. Review the delivered triggers and adjust existing triggers or define your own triggers based on your company's needs.

Iterative Triggers

This table lists some iterative triggers delivered with Global Payroll for Spain as sample data:

Record

Trigger Level

Fields With Triggers

Field Values

CNTRCT_DATA_ESP

Record

Not Applicable

Not Applicable

COMPENSATION

Field

COMPRATE

COMP_FREQUENCY

CURRENCY_CD

FTE_INDICATOR

Not Applicable

JOB

Field

ACTION

HIR -- Hire

REH – Rehire

TER – Termination

JOB

Field

COMPANY

Not Applicable

JOB

Field

EMPL_CTG

Not Applicable

JOB

Field

GP_PAYGROUP

Not Applicable

JOB

Field

PAY_SYSTEM_FLG

Not Applicable

JOB

Field

SOC_SEC_RISK_CODE

Not Applicable

JOB_JR

Field

SSN_EMPLOYER

Not Applicable

WKF_CNT_TYPE

Field

CONTRACT_TYPE

CONTRACT

Segmentation Triggers

This table lists some segmentation triggers delivered with Global Payroll for Spain as sample data:

Record

Trigger Level

Fields With Trigger

Field Values

Trigger Event ID

CNTRCT_DATA_ESP

Record

Not Applicable

Not Applicable

CATEGORZN (element segmentation)

COMPENSATION

Field

COMPRATE

CURRENCY_CD

COMP_FREQUENCY

FTE_INDICATOR

Not Applicable

COMPRATE (element segmentation)

GPES_PAYEE_DATA

Field

GPES_TAX_LOCATION

Not Applicable

TAX_LOCTN (element segmentation)

GP_PYE_OVRD

Field

PIN_NUM

RETJ ALIM

RETJ CNYG

RETJ JUDCL

RETJ ALIM ND

RETJ CNYG ND

DIETA EXPTR

PRNCTA EXPTR

NOCTURNIDAD

FESTIVIDAD

INCENTIVOS

TOXICIDAD

PRTCPCN BEN

BECA INVESTN (specific trigger event ID)

PREJUBILACN (specific trigger event ID)

DEV SS PREJ (specific trigger event ID)

GASTOS BECA (specific trigger event ID)

See Segmentation Triggers with Earning and Deduction Assignments.

COMPRATE (element segmentation)

JOB

Field

ACTION

HIR -- Hire

REH – Rehire

TER – Termination

HIRE/TERM (period segmentation)

JOB

Field

COMPANY

Not Applicable

COMPANY (period segmentation)

JOB

Field

EMPL_CTG

Not Applicable

CATEGORZN (element segmentation)

JOB

Field

GP_PAYGROUP

Not Applicable

PAY GROUP (period segmentation)

JOB

Field

PAY_SYSTEM_FLG

Not Applicable

PAY SYSTEM (period segmentation)

JOB

Field

SOC_SEC_RISK_CODE

Not Applicable

RISK CODE (element segmentation)

JOB_JR

Field

SSN_EMPLOYER

Not Applicable

CATEGORZN (element segmentation)

WKF_CNT_TYPE

Field

CONTRACT_TYPE

Not Applicable

CATEGORZN (element segmentation)

Retroactivity Triggers

This table lists some retroactivity triggers delivered with Global Payroll for Spain as sample data:

Record

Trigger Level

Fields With Trigger

Field Values

Trigger Event ID

CNTRCT_DATA_ESP

Record

Not Applicable

Not Applicable

CONTRACT

COMPENSATION

Field

COMPRATE

COMP_FREQUENCY

CURRENCY_CD

FTE_INDICATOR

Not Applicable

COMPENSATION

JOB

Field

ACTION

HIR -- Hire

REH – Rehire

TER – Termination

See Termination Payment Calculation.

JOB DATA

JOB

Field

COMPANY

EMPL_CTG

GP_PAYGROUP

Not Applicable

JOB DATA

JOB

Field

Not Applicable

Not Applicable

JOB DATA

JOB

Field

PAY_SYSTEM_FLG

SOC_SEC_RISK_CODE

Not Applicable

RETRO

JOB_JR

Field

SSN_EMPLOYER

Not Applicable

JOB DATA

Segmentation Triggers with Earning and Deduction Assignments

In Global Payroll you can define segmentation triggers only for effective dated records, with one exception: you can define segmentation triggers for the begin and end dated earning and deduction assignment record GP_PYE_OVRD. This exception enables you to assign an earning or deduction to a payee on the Element Assignment by Payee (GP_ED_PYE) or Payee Assignment by Element (GP_ED_ELEM) components, and segment (and prorate) the element when the assignment begin date comes after the pay period begin date, and/or the assignment end date comes before the period end date.

Global Payroll for Spain has set up the following earnings so that they are automatically segmented and prorated (using the proration factor defined on the earning definition pages) when the assignment period covers only a portion of the pay period:

Element Name

Type

Description

RETJ ALIM

Deduction

Children Support Garnishment

RETJ CNYG

Deduction

Spouse Support Garnishment

RETJ JUDCL

Deduction

Garnishment

RETJ ALIM ND

Deduction

Not Deduced Child Garnishment

RETJ CNYG ND

Deduction

Not Deduced Spouse Garnishment

DIETA EXPTR

Earning

Maintenance Expatriates

PRNCTA EXPTR

Earning

Overnight Stay Expatriates

NOCTURNIDAD

Earning

Nighttime Complement

FESTIVIDAD

Earning

Festivity Complement

INCENTIVOS

Earning

Incentives

TOXICIDAD

Earning

Toxicity/Hazardous Complement

PRTCPCN BEN

Earning

Profit Participations Complement

BECA INVESTN

Earning

Scholarship Holder

PREJUBILACN

Earning

Pre-retired Income

DEV SS PREJ

Earning

Social Security Paid by Employee

GASTOS BECA

Earning

Scholarship Holder Expenses

If you want to set up additional earnings and deductions to trigger segmentation and proration when they are assigned to payees and the assignment period covers only a portion of the pay period, access the Trigger Definitions component and add these elements to the segmentation trigger definition for the GP_PYE_OVRD record.

In the case of deductions or non-basic earnings you also need to specify formula GEN FM SEGMNTCN as a post-process formula and a specify the proration to be used. Global Payroll for Spain delivers GEN PO DIAS SLICE that you can use or modify, or you can create a new one to fit your requirements.

See Also

Setting Up Triggers

Click to jump to top of pageClick to jump to parent topicRounding Rules

When you resolve an element that is a numerical value, you often need to round the resulting value. You'll use rounding rules to do this.

Once you define a rounding rule element, apply it to other elements. The rounding rule can be applied to any component of an earning or deduction, to the resolved amount of an earning or deduction, or within a formula.

The following table describes the delivered rounding rules that Global Payroll for Spain as guidelines:

Rounding Rule

Logic

Delivered System Uses

GEN RR REDONDEO

Rounds to 2 decimals. Rounds upward if the rounding adjustment number is greater than or equal to 5. Rounds downward if the rounding adjustment number is less than 5.

The system uses this rounding rule to round non-monetary amounts.

GEN RR TRUNC 2DEC

Truncates to 2 decimals.

The system uses this rounding rule during tax percentage calculation.

GEN RR LEGAL

Rounds to 2 decimals. Rounds upward if the rounding adjustment number is greater than or equal to 5. Rounds downward if the rounding adjustment number is less than 5.

The system uses this rounding rule to round monetary amounts. Global Payroll for Spain uses it to round Euros.

GEN RR TRUNC 0DEC

Truncates to 0 decimals.

The system uses this rounding rule during preparation of FAN file values.

GEN RR REDOND 4DEC

Rounds to 4 decimals. Rounds upward if the rounding adjustment number is greater than or equal to 5. Rounds downward if the rounding adjustment number is less than 5.

The system uses this rounding rule during vacation entitlement calculation.

GEN RR REDOND 0DEC

Rounds to 0 decimals. Rounds upward if the rounding adjustment number is greater than or equal to 5. Rounds downward if the rounding adjustment number is less than 5.

The system uses this rounding rule when calculating the IRPF percentage.

FNQ RR D VACACIONS

Truncates to 0 decimals.

The system uses this rounding rule when calculating vacation days for terminated employees.

SS RR BASES

Rounds to 2 decimals. Rounds upward if the rounding adjustment number is greater than or equal to 5. Rounds downward if the rounding adjustment number is less than 5.

The system uses this rounding rule when calculating social security bases.

See Also

Calculating Taxes

Calculating Social Security Benefits

Defining Calculation Elements

Click to jump to top of pageClick to jump to parent topicProcess Lists

Global Payroll for Spain delivers the following process lists:

Process List

Calculation Type

ABSENTISMO PR

Absence calculation

GEN PR CAL CORR

Payroll calculation

GEN PR CALC NOM

Payroll calculation

TAX PR CALC IRPF

IRPF percentage calculation

XTR PR PAGA EXTRA

Extra period calculation

Calculate IRPF percentage either as part of the normal payroll (in the GEN PR CALC NOM process list) or as a separate calculation (in the TAX PR CALC IRPF process list).

Click to jump to parent topicSetting Up Statutory Rates

To set up statutory rates, use the Statutory Rates ESP (GPES_STATUTORY) component.

This section provides an overview of statutory rates and discusses how to set up statutory rates.

See Also

Setting Up Statutory Severance Days

Click to jump to top of pageClick to jump to parent topicUnderstanding Statutory Rates

Global Payroll for Spain delivers statutory rates for the following:

These rates and are defined by the government. Global Payroll for Spain delivers and maintains these rates as system data.

Click to jump to top of pageClick to jump to parent topicPage Used to Set Up Statutory Rates

Page Name

Object Name

Navigation

Usage

Statutory Rates

GPES_STATUTORY

Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Addl Rates, Ceilings, Values, Statutory Rates ESP, Statutory Rates

Enter the statutory rates for minimum salary, interest rate for employee loans, and the percentage of minimum salary that is exempt for tax and social security contributions.

Click to jump to top of pageClick to jump to parent topicSetting Up Statutory Rates

Access the Statutory Rates page.

Daily Minimum Salary

Enter the minimum daily wage established by law.

Monthly Minimum Salary

Enter the minimum monthly wage established by law.

IPREM (Daily) (Indice Publico de Renta de Efectos Múltiples)

Enter a value used to calculate the daily wage that is exempt from taxes and social security contributions.

IPREM (Monthly) (Indice Publico de Renta de Efectos Múltiples)

Enter a value used to calculate the monthly wage that is exempt from taxes and social security contributions.

Statutory Interest

Enter the interest rate established by law. You can apply this interest rate or another rate to any employee loan. If you apply a lower rate, the difference is considered salary in kind.

Excess Pct. over IPREM (excess percentage over Indice Publico de Renta de Efectos Múltiples)

Enter the percent used to calculate the exempted amount for the public transportation complement, and for salary in-kind earnings.

See Also

Public Transportation and Distance Complement

Click to jump to parent topicViewing Delivered Elements

Global Payroll for Spain some setup elements that you can customize to fit your business requirements. The following is a list of these setup elements:

Note. You can find more information about these setup elements in the context of their related business processes throughout the chapters of this PeopleBook.

The PeopleSoft system delivers a query that you can run to view the names of all delivered elements designed for Spain. Instructions for running the query are provided in the PeopleSoft Enterprise Global Payroll 9.0 PeopleBook.

See Also

Understanding How to View Delivered Elements