Note: This page was translated using automation resources with the purpose of providing content in your language more quickly. Consequently, it may have grammatical errors and similar situations. If the content is not useful in this state, in the page footer you can access the original material in Brazilian Portuguese and also give us opinions on this translation.
Tables / Calculations / Define Calculation

Definition of Calculation

Warning

This documentation has information that applies only to some modules. Contents that have the icon indicate each case, position the mouse over this icon and see the description of the modules.

The opening of types of processing to be calculated is carried out in this item. There are several calculations handled by the system, as: weekly, biweekly, monthly complementary payroll, Christmas Bonus, among other.

The system allows to define calculations for future periods and perform entries in them. In this case, the last calculation performed can be redone as time times it is necessary, but, from the moment there is another calculation, only this last one can be recalculated.

Note

The selection of the calculation code can be done in Other > Select Calculation or by pressing F6.

Calculation Code

Report a calculation code for each new processing. It is not necessary following a subsequent numerical ordering.

Important
  • It is important to remember that the previous calculations be saved, and the codes used to identify them must not be reused.
  • In Personnel Administration, the periods for Transport Vale registered in the Exceptions tab refer exclusively to the calculation and integration of the vouchers in the payroll, do not interfere in the periods considered at the moment of the generation of the vouchers. Thus, at generation time, the system considers exactly the periods defined as input in the models or in the routine of entering passes.

Calculation

Type of Calculation

Report the type of processing that is being registered, and can be:

Type Description
11 Monthly Payroll
12 Complementary Payroll
13 Complement of Bargaining
14 Payment of Bargaining
15 Complementary Rescission
21, 22 and 23 Weekly Payroll
31 Christmas Bonus Advance
32 Full Christmas Bonus
41 and 42 Biweekly Payroll
91 Salary Advance
92 Profit sharing
93 Special
94 Labor Demand
Notes
  • For different types of 11, the user will not be able to perform any activity related to counting hours, such as reading, correctness, and reporting.
  • In calculation type 15, the holiday and 13th salary provisions for the complementary terminations will be generated next to the normal sheet of the payment month.
  • In the Time and Cafeteria Control module, the finality of these other types is to allow integration with the payroll from weekly, biweekly periods and adjustments.

Payroll Period

Report the start and end date of the payroll period, which will receive information processed in this calculation.

Evaluation Period (Time)

Report the start and end date of the period to be evaluated in this calculation. The period can be between 2 and 62 days.

Note

It is not necessary to keep always the same start day, because it can vary according to the company need. It can be useful mainly at the end of the year, when the closing of attendance evaluation is changed.

Start Date of Time Evaluation Period

Report the start date of the period in which the adjustment of occurrences can be done. It is very used in networks, in which the responsible user determines the period, within an evaluation period, in which it is possible doing the adjustments. With this, the users are obligated to do adjustments within the established period.

Note

For previous calculation periods, if the adjustment period is zeroed, the systems allows consultation only for the windows: Adjustments of Workers, Adjustments of Exceptions, Adjustments of Balances, Type Situations.

Vale Valley Transportation

Inform the initial and final period of the calculation.

Notes
  • When the Transportation Voucher evaluation is the same as the payroll, these fields can be left blank (zeroed).
  • In the "Exceptions" tab you can create a different transportation voucher calculation period for a particular location, position, branch, and

Absences Transportation Voucher

Report the start and end period for checking the absences with loss of Transportation Voucher.

Note

In the AP and CP modules, the system verifies the departures that the employee had in the period and if the situation of the withdrawal is marked to lose the right to the transport ticket (Tables> General> Situations, field "Lost Transport").

Calculation of Vouchers

Inform the initial and final period of the Vouchers' calculation.

This field is specifically available when Personnel Administration is integrated with the Benefits module (BS).

Notes

When the Transportation Voucher evaluation period is the same as the payroll, these fields can be left blank (zeroed).
In the Transportation Voucher Exceptions tab, it is possible creating distinct periods for each Transportation Voucher.

Absences Vouchers

Report the start and end period for checking the absences with loss of Transportation Voucher.

This field is specifically available when Personnel Administration is integrated with the Benefits module (BS).

Note

The system checks the absences that the worker had in the period and if the absence situation is indicated to lose the right to the Transportation Voucher (Benefits > Transportation Vouchers > Types, Situations folder).

Calculation of Commissions

Define the start and end dates for evaluating the omissions of each calculation code.

Period

Report the month of the period to which this calculation period refers.

Release Adjustments Portal

Report if this calculation code will be available in the Web Portal for viewing the Hour Bank Balance and the Time Card.

Note

This field will be visible only in the Time and Cafeteria Control module if the client has Web Portal instances.

Payment Date

Report the date when the payment of workers will occur.

Payslip Message

A message can be indicated to be issued in the payslip. However, this data must be foreseen in the payslip model defined in the reports generator.

Birthday Messages

Report a sentence to be issued in the payslip for people who have birthday in that month.

Calculation Note

The information registered in this field is demonstrated in the Calculation Selection (F6) and on the bottom of the main window of the Personnel Management, Benefits and Profit Sharing Plan modules.

Situation of Calculation

Presents the situation of the calculation code, and can be:

Code Description
C Calculation Canceled
I Initialized
T Total Calculation
P Partial Calculation
Y Simulated Calculation
Notes

With this situation the module will issue alert messages when the user is performing another calculation.

When trying to recalculate a calculation, where the situation is different from I - Initialized, the system checks the date of the server; if it is higher than the payment date of the selected calculation, the system blocks the recalculation. The same locking occurs when there is a calculation with payment date superior to the calculation selected, in which the situation of this posterior calculation is different from I - Initialized.

Group of Companies

Allows reporting a code of the Group of Companies which will have the same calculation definition. Thus, all companies that are in the group will have definition automatically inserted with data reported here.

Notes
  • Note that the calculation code must be free in all companies in the group.
  • The group of companies is defined in Companies > Group of Companies.
  • For type calculations 12, 13, 14 and 15, the system does not create the calculations for the other companies in the group, even Code.


View Forum Leaders
If you enter "S - Yes" or leave this field blank, the statement for this calculation will be displayed in the Web Portal and in the Management Panel. If you enter "N - No", the calculation will be hidden.

Notes

  • This setting applies to all levels of users, including Administrator users.
  • This field is only available when the owner owns Portal Web instances, otherwise it will be hidden.

Exceptions

Through this tab, it is possible indicating the Payroll Period, Transportation Voucher Evaluation and Payment Date differentiated for a particular group of workers.

Notes

In personnel administration:

  • The Differentiated Payment Date can directly influence the IRRF calculation base. In the item Taxes> Federal Tax> IR Source / Registry, the Competence and the Payment Date will be based on the data of this folder, when there is information.

In the Control of Point and Canteen:

  • This tab will be enabled only when the Considers Exception Periods in Calculation field from the window Other > Indications, Time tab, is defined as Y - Yes.
  • When integrated with the Personnel Management module, the exceptions must be registered by the Personnel Management module.
    In the Personnel Management module, the Evaluation Period and Adjustment Period fields of this tab will be available only when the Considers Exception Periods in Calculation indication is equal to Y - Yes, in Other > Indications, Time tab, otherwise, these fields are filled out with the calculation default value.

Sequence

Indicate a sequence code to identify the registering of this exception.

Scope

Conforms to the type of exception defined. Indicate the range to be used.

Notes

Use of double quotes

For job, location, and cost covers, you must define them using double quotation marks. Example: Jobs: "1","2","3".

Calculation type "32 - 13º Integral Salary"

The system uses the scope to select the employees that will be processed. In this selection, several histories of the collaborator are verified and, in the calculation type "32 - 13º Integral Salary", the date of search of the histories is the date of payment informed in the calculation. Exceptions are then applied, if they are configured. Such exceptions are not applied at the time of employee selection, as this would compromise routine performance.

Batch
This field will be enabled for edition when the type of exception is 8 - Batch. In it, the batch that will be the exception for calculating the payments must be reported.

Payroll Period

Report the start and end date of the payroll period, which will receive information processed in this calculation.

Evaluation Period (Time)

Report the start and end date of the period to be evaluated in this calculation. The period can have between 2 and 62 days. It is not necessary to keep always the same start day, because it can vary according to the company need. It can be useful mainly at the end of the year, when the closing of attendance evaluation is changed.

Evaluation Period - Beginning

Report the start date of the period in which the adjustment of occurrences can be done. This is very used in networks, where a responsible user
determines the period, within the evaluation period, in which it is possible perform adjustments. With this, the users are obligated to do adjustments within the established period.

Evaluation Period - End

Report the end date of the period in which the adjustment of occurrences can be done. This is very used in networks, where a responsible user
determines the period, within the evaluation period, in which it is possible perform adjustments. With this, the users are obligated to do adjustments within the established period.

Transportation Voucher Calculation

Report the start and end period of the Transportation Voucher evaluation.

Payment Date

Report the date when the payment for workers of the exception will occur.


Message Envelope Record the message that should be listed on the envelopes for the scope in question.

Envelopes

Warning

This documentation applies only to the module: AP.


Scope
According to the type of exception defined, indicate the range that will be used.

Note
For job, location, and cost covers, you must define them using double quotation marks. Example: Jobs: "1","2","3".

Exceptions Vouchers

Warning

This documentation applies only to modules: AP, BS.

The Voucher Exceptions tab will be available specifically when Personnel Administration is integrated with the Benefits module.

For each type of voucher can be indicated periods of calculation and absences different from those indicated in the fields Voucher Calculation and Sponsored links from the Calculation tab.

Christmas Bonus Advance

The Christmas Bonus Advance tab will be enabled only for the Type of Calculation 31 - Christmas Bonus Advance.

Through this option, the company can pay until 100% of Christmas Bonus Advance, in any period of the entitlement year, providing the INSS and IT deductions. The system allows to calculate the Full Christmas Bonus (type of calculation 32) before November, due to the handling of taxes and SEFIP. This routine comes to satisfy the need of clients who want to carry out payment in which month of the year, and can, even, be used to meet the request from some employees only.

It is necessary to adjust some items for that this calculation works.


Christmas Bonus Advance Percentage

Report the percentage corresponding to the Christmas Bonus advance that will be calculated. This value will overlap the percentage reported in the Worker’s Union information.

Provision INSS/IT

Report if the system must provision the INSS and IT values in the Christmas Bonus Advance.

Note

These values will be considered only when calculating the Christmas Bonus Advance; they will not be collected neither accounted as such.

Averages of Christmas Bonus Advance

Report how the system must consider the averages when calculating this Christmas Bonus Advance:

  1. The system must consider the Christmas Bonus Advance Averages field, available in the Company information (Companies > Companies).
  2. The system must pay all the overtime averages, commissions, etc., independent of the indication in the Christmas Bonus Advance Averages field, available in the Company information.
Note

The values referring to the Night Premium, Unhealthy and Hazardousness are paid by the current right, always when the worker is still receiving them. Thus, the indication will be respected only when the average of these values is paid, that is, the worker has such items in the previous financial statements, however it does not receive them anymore.

Calculate
Define for which employees the 13th salary advance must be calculated. The available options are:

1 - All All employees are considered in the calculation 31. The system considers the signaling of the Médias Adto field. 13th salary, in Companies> Companies.
2 - Only marked The system pays all averages of overtime, additional, commissions and so on, regardless of the sign-off of the Médias Adto field. 13th Salary, in Companies> Companies.

Additional Information:

Create and adjust the following events in Tables> Events> Events> Schedule:

Note

Create an event for the INSS discount 13th Earning Wage Predicted:

  • Characteristic: 44D;
  • Rule: 026 - INSS;
  • Type Event: 3 - Discount;
  • Folder Incidents: Inform less (-) in the field "FGTS 13th Salary". In the other fields inform 'N' (*1);
  • Base Folder: Inform all events that are part of calculation 31 (13th Down payment, averages, additional events, etc.), adding (+), with Type 01. Calculation accumulators can not be used (9000 onwards). The events indicated for this base should not have incidence for INSS in their registers;
  • Folder Calculations: Release only for the calculation type 31.

Note

Create an event for the IRRF discount 13th Earning Wage Predicted:

  • Feature: 44E;
  • Rule: 027 - Income Tax;
  • Type Event: 3 - Discount;
  • Folder Incidents: Inform less (-) in the field "FGTS 13th Salary". In the other fields inform 'N' (*1);
  • Base Folder: Inform all events that are part of calculation 31 (13th Down payment, averages, additional events, etc.), adding (+), with Type 01. Insert also the new INSS event 13th Salary Advance Intended, deducting from the base (-), with Type 01. Calculation accumulators can not be used (9000 onwards). The events indicated for this base should not have incidence for IRRF in their registers;
  • Folder Calculations: Release only for the calculation type 31.

Note

Set the 13th Salary Advance Discount Event (Feature 44B), already present in the event table:

  • Base Folder: Insert the new Events of Characteristics 44D and 44E, decreasing (-), with Type 01. This is so that the liquid is correct.

(* 1) Important

The value of the expected INSS and IRRF events must be deducted from the FGTS calculation base of the 13th Salary Advance, as these amounts are not being paid and will not be taken for the next 13th Salary calculations, and the FGTS will be collected on the amount that the employee is receiving. These discounts have the function of reducing the amount to be paid, so that the payment of the 13th Integral Salary does not occur overflow. The 13th Wage Advance Discount event (Feature 44B) always corresponds to the net of the down payment sheet.

Note

If it were not indicated (-) in the field "FGTS 13th Salary", the calculation would be as follows:

Calculation 31 - Advance payment 13th Salary (100%):
(+) 13th Salary Advance = R $ 2,000.00
(-) INSS 13th Salary Advance Intended = R $ 220,00
(-) IRRF 13º Salary Advance Projected = R $ 69,65
Net = R $ 1,710.05
FGTS = R $ 2,000.00 * 8.00% = 160.00 (which corresponds to the total amount of FGTS due).

Calculation 32 - 13th Integral Salary:
(+) 13th Integral Salary = R $ 2,000.00
(-) INSS = R $ 220,00
(-) IRRF = R $ 69.65
(-) Discount Adto 13th Salary = R $ 1,710.05
Net = R $ 0.00
FGTS = R $ 2,000.00 - 1,710.05 = 289.95 * 8.00% = 23.20 (payment in duplicate).

(missing or bad snippet)