This chapter explains how to:
Calculate earnings.
Define salary advances.
Use batch positive input.
Global Payroll for Brazil enables you to make the following calculations:
Base compensation
Bonuses and Premiums
Additional earnings
Overtime
To calculate earnings for the hourly employee, the system uses the following earning elements:
Salary
The amount paid depends upon the employee category and is calculated for the payment period.
The system uses the following elements to calculate salary:
Earning Element |
Description |
SALARIO MENS |
Contains the monthly salary for accumulation monthly rate from Job record. |
SALARIO |
Used to pay salary for monthly employee. |
HORASNORMAIS |
Used to pay labor hours according to a planned work schedule for hourly employees. |
DSR HR NOR |
Used to pay rest day hours according to a planned work schedule. |
Note. Delivered earning elements that include the abbreviation MEN, such as PERIC MEN (hazardous bonus monthly) are used to calculate other earnings or deductions that are based on the monthly amount even though the employee does not receive the entire monthly payment.
Commission
Payment of commissions are required only upon conclusion of the transaction to which they refer. Termination of employment does not halt the payment of a commission. Commissions are payable monthly, or within three months of the settlement agreement. To calculate commissions, the system uses the COMISSAO earning, which is populated by positive input for each employee.
DSR Commission - Regarding Weekly Rest
For commissions corresponding to Sundays and holidays, the system uses the earning DSR COMISS to pay the estimated commission, and the DSR COMMISSAO accumulator and FP FM DSR formula.
Minimum Guaranteed
The minimum guaranteed salary is either defined by the Labor Collective Agreement and the professional category, or by the minimum wage. The difference between the salary earned and the minimum guaranteed salary must be paid by the organization and not compensated in future payments.
Formula FP FM MIN GAR compares the commission with the minimum guaranteed value. If the commission is less than the minimum the system adjusts earning MIN GARANTID with the value needed to reach the minimum.
Cost Allowances and Travel Expenses
Cost allowances and travelling expenses may be granted and will be taxed when they exceed 50% of the salary value.
Earning |
Description |
DIARIAS VIAG |
This earning is used to pay daily amounts in case of trips. Receive days (as units) through Positive Inputs. Formula FP FM DIARIAS checks if the calculated amount is greater than 50% of employee salary. In this case, put zero to this amount and keep the value in variable FP VR DIARIAS>50%. This is a nontaxable earning. |
DIARIAS>50% |
This earning is used to pay daily amounts in case of trips. It receives its value from variable FP VR DIARIAS>50%. This is a taxable earning. |
AJUDA CUSTO |
Earning to pay the cost allowances. This value comes from positive input for each employee. |
Global Payroll for Brazil enables you to create bonuses, replacement bonuses, and position compensation bonuses.
The bonus earning uses the formula FP FM BONUS to calculate its final amount. This formula applies to a percentage based on variable FP VR % BONUS over the employee remuneration and checks the limit value from variable FP VR LIMITE BONUS.
The replacement bonus dummy earning GRAT SUB MEN is populated by positive input for each employee. This element stores the monthly amount and can be used in some accumulators. The earning GRATIF SUBS is used to pay the replacement bonus. This value can be prorated.
The position compensation bonus dummy earning is populated by positive input for each employee. This element stores the monthly amount and can be used in some accumulators. The earning GRATIF FUNC is used to pay the position compensation bonus. This value can be prorated.
The system uses the earning PREMIO to calculate premiums. Its value is determined by positive input for each employee.
Working under risky conditions can merit extra pay. Percentages may vary according to union and collective agreements.
Type of Allowance |
Calculation Formula |
Elements Used |
Additional Allowance for Hazardous Labor |
Calculation Base * 0,30 |
The system calculates these earnings only for employees with hazard levels specified on the Payee Parameters page.
|
Additional Allowance for Unhealthy Labor |
Level 1: Minimum Wage * 0,10 Level 2: Minimum Wage * 0,20 Level 3: Minimum Wage * 0,40 |
The system calculated these earnings only for employees with unhealthy labor levels specified on the Payee Parameters page.
|
Night Shift |
Night Shift Hours * Hour Value * 0,20 |
Earning ADIC NOTURNO (This is a Unit*Rate*Percent earning.)
|
Length of Service |
Annual: Value of Annuity * Years Worked Biennium: Value of Biennial * (Years Worked/2) Quinquennium: Value of Quinquennium * (Years Worked/5) |
There are many ways to calculate the length of service. This payment is optional. The PeopleSoft template includes a quinquennium example.
|
Transfer |
Calculation Base * Percentage of Transfer |
Earning ADIC TRANSF (This is a Base*Percent earning that applies 25% over the accumulator ACUM AD TRANSF.) |
Standby Employee |
Paid on a percentage basis. |
Earning SOBREAVISO (This is a Unit*Rate*Percent earning that receives the units through positive input. The system uses the variable FP VR % SOBREAVISO to apply an hourly rate to the payment 0.) |
The system uses the following allowances to calculate overtime:
Type of Allowance |
Calculation Formula |
Elements Used |
Weekday Overtime |
Monthly Calculation Base / Monthly Base Hours * Quantity of Overtime * 1,50 |
Earnings HORA EX D50%, HORA EX D70%, HORA EXD100%, HORA EX N50%, HORA EX N70%, HORA EXN100% (These earnings are Unit*Rate*Percent earnings. Units are entered through positive input. Rate is defined by the formula FP FM VR HR>HE, which divides the accumulator ACUM HORAS EXT by Standard Hours. Our template uses monthly standard hours. The percent is stored directly in the earning definition.) |
Sunday and Holiday Overtime |
Monthly Calculation Base / Monthly Base Hours * Quantity of Overtime * 2,00 |
|
Salary advance is usually paid at the 10th or 15th of the month. The advance is based on 40% of the monthly salary and the number of days worked during the month. The remainder of the monthly salary (the balance) is then paid on the 5th of the following month.
The monthly salary calculation varies by employee type:
Monthly employees: 40% of minimum wage.
Hourly employees: 40% of a 220 hour month at the hourly minimum wage.
Commission Employees: 40% of average commissions.
The system uses the following information when processing salary advances:
Employee HR information: name, registration, hire date.
Time management information: absences, vacations.
Element Type |
Element Name |
Description |
Process List |
KR PR AD QUINZ |
Process to advance payment. |
Section |
KR SE INIC QUIN |
Initialization section for income tax if it is regime de caixa. |
Section |
KR SE REMUN MEN |
Monthly remuneration calculation of the advanced payment calculation base. |
Section |
KR SE ADIANTAMENTO |
Gets the advanced pay amount. |
Section |
KR SE REC IR |
Calculates the income tax if it is a regime de caixa |
Earning |
ADIANTAMENTO |
Used to make payments. Applies the percent in AD VR % ADTO over the ACUM AD QUINZ. |
Deduction |
DESC ADTO |
In payroll process, this deduction is used to discount the advanced payment. |
Accumulator |
ACUM AD QUINZ |
This is an advanced pay calculation base. |
Variable |
AD VR OPCAO |
Taken from the Payee Parameter page. |
Variable |
AD VR % ADTO |
Accepts the payee override from option in Payee Parameter page. |
If the salary advance and the balance payment are made in the same month, the advance is not subject to any type of tax deduction. The value will be paid in full according to the percentage set forth on the indicated salary. Taxes are deducted from the balance payment made at the end of the month.
If the salary advance and the balance payment are not made in the same month, the company is required to withhold income tax on the advance payment.
See Also
You can use batch positive input to reduce time-consuming data entry in Global Payroll for Brazil. For example, you could enter and trigger bonuses for all of your employees using batch positive input, or you could trigger mass deductions. For example, suppose that an employer has an agreement with a cell phone company to provide half the employee population with a 50 percent discount rate on calls. Instead of entering each of the monthly cell phone invoices (deductions) for each employee, the cell phone company could generate a flat file with a layout that loads this invoice information using a batch process.
This section describes how to load the batch positive input.
Page Name |
Object Name |
Navigation |
Usage |
GPBR_PI_BATCH |
Global Payroll & Absence Mgmt, Absence and Payroll Processing, Prepare Payroll, Manage Pos Input via Batch BRA, Batch Positive Input |
Create batch positive input. |
Access the Batch Positive Input page.
Clear Data |
If you clear this check box, previously loaded data is deleted. If you select this check box, the batch process loads new data into the Positive Input tables for payroll purposes. |
Pay Group |
Enter the pay group for which you want to load batch positive input. |
Calendar ID |
Select the calendar ID for the pay group that you identified in the Pay Group field. |
Action Type |
Select the action to be performed. Choose from the following: Add Do Not Prc (Do Not Process) Override Zero |
Batch Code |
Enter the batch code ID that identifies all of the transactions contained in the flat file. This field enables you to delete information loaded by mistake, because it serves as the identifier of that information. |
Input Directory |
Specify the location of the flat file containing the batch positive input (flat file directory). |
Output Directory |
If the batch process finds errors, it generates a log file containing the errors. Use this field to specify where the system should place the error log (error log directory). |
Flat File Layout for Batch Positive Input
When you create flat files for the batch positive input process, reproduce the following file definition:
Field |
Initial Position |
Length |
EMPID |
1 |
11 |
EMPL_RCD |
12 |
3 |
PIN_NM |
15 |
18 |
GP_UNIT |
33 |
20 |
GP_AMT |
53 |
20 |
GP_RATE |
73 |
20 |
GP_PCT |
93 |
11 |
PC_BASE |
104 |
20 |
DEPTID |
124 |
10 |
JOBCODE |
134 |
6 |
Here's an example:
Field |
Example |
EMPID |
GR0045 |
EMPL_RCD |
0 |
PIN_NM |
COMISIONES |
GP_UNIT |
12.58 |
GP_AMT |
11.36 |
GP_RATE |
10 |
GP_PCT |
1.3 |
PC_BASE |
25.36 |
DEPTID |
KR000 |
JOBCODE |
KR001 |
Note. This flat file definition applies to both earnings and deductions that you load using batch positive input.
See Also