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.
The selection of the calculation code can be done in Other > Select Calculation or by pressing F6.
Report a calculation code for each new processing. It is not necessary following a subsequent numerical ordering.
- 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
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 |
- 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.
Report the start and end date of the payroll period, which will receive information processed in this calculation.
It is possible having the evaluation period from 9/26/1996 to 10/25/1996 and the payroll period from 10/1/1996 to 10/31/1996.
Report the start and end date of the period to be evaluated in this calculation. The period can be 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.
From 8/27/96 to 9/25/96, from 9/26/96 to 10/25/96.
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.
It is possible having the evaluation period from 9/26/1996 to 10/25/1996 and the adjustment period from 9/26/1996 to 9/29/1996. On 10/1/1996, the responsible user changes the adjustment period to: from 9/30/1996 to 10/6/1996. In the days 26, 27, 28 and 29 nobody can perform time adjustments.
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.
- 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.
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").
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).
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.
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).
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).
Define the start and end dates for evaluating the omissions of each calculation code.
Report the month of the period to which this calculation period refers.
Report if this calculation code will be available in the Web Portal for viewing the Hour Bank Balance and the Time Card.
This field will be visible only in the Time and Cafeteria Control module if the client has Web Portal instances.
Report the date when the payment of workers will occur.
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.
Report a sentence to be issued in the payslip for people who have birthday in that month.
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.
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 |
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.
In order to recalculate a competency, the previous one must be obligatorily with the situation "T - Total Calculation". In the case below, the system would recalculate only the 10/2016 competency. The 11/2016 racing would be calculated only when the 10/2016 was like the "T" situation.
| Calculation | Period | Payment | Situation |
|---|---|---|---|
| 11 | 09/2016 | 10/5/2016 | T - Total Calculation |
| 11 | 10/2016 | 11/5/2016 | P - Partial Calculation |
| 11 | 11/2016 | 12/5/2016 | I - Initialized |
It will only be possible to recalculate a competency when the calculation with a later date has the "I - Initialized" situation. In the case below, it would not be possible to perform recalculation of competency 10/2016.
| Calculation | Period | Payment | Situation |
|---|---|---|---|
| 11 | 09/2016 | 10/5/2016 | T - Total Calculation |
| 11 | 10/2016 | 11/5/2016 | P - Partial Calculation |
| 11 | 11/2016 | 12/5/2016 | T - Total Calculation |
In addition, when the situation is equal to "S - Simulated Calculation", the following will not be generated:
- Provision;
- Accounting;
- Difference from Encargos (FGTS, INSS ...).
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.
- 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.
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.
Indicate a sequence code to identify the registering of this exception.
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.
We consider that:
- the calculation type 32 was defined with payment date on 12/14/2017, where we set up an exception for a certain batch of employees, indicating that the payment date of the same is 12/18/2017;
- the employees of this lot were admitted on 12/16/2017, that is, after the original payment date of the calculation type 32.
When calculating this sheet, exception employees will not be considered.
This is because in the main selection made by the system (coverage), the payment date is verified 12/14/2017 and, on this date, employees admitted on 12/16/2017 were not yet active and were disregarded.
Even if there is a calculation exception with payment date of 12/18/2017, the system will not calculate these employees, since they have already been disregarded by the main selection.
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.
Report the start and end date of the payroll period, which will receive information processed in this calculation.
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.
From 8/27/96 to 9/25/96, from 9/26/96 to 10/25/96.
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.
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.
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.
Report if the system must provision the INSS and IT values in the Christmas Bonus Advance.
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:
- The system must consider the Christmas Bonus Advance Averages field, available in the Company information (Companies > Companies).
- 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.
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:
- Even if all workers were treated by this modality of payment of the 13th Advance Salary in 100%, there is an obligation to generate the calculation of Type 32 in the month of December, to make official the discounts of the employee and obtain the tax guides;
- The DARF and GPS tabs will be issued only in Calculation Type 32, for official discount events;
- The basis of calculation and the value of the INSS Previsto will not be recorded in the Contribution History and no collections will be generated;
- The basis of calculation and the amount of the IRRF Previsto will not be recorded in the Source IR Registry and neither will be generated collections;
- The FGTS of this calculation will normally be collected along the monthly sheet of the Payment Competency;
- If the company deducts Judicial Pension on the 13th Salary Advance, the new INSS and IRRF Predicted events must be indicated for deduction (-) from the 13th Pension Base Salary;
- New CLCs should be created for the Accounting of INSS and IRRF Events. These CLC's should not be posted in the Tax accounts, but in the Advance accounts of 13th Salary;
- In the Provisions of the month of the payment of the 13th Salary Advance in 100%, will continue generating only the retirement of the FGTS. The remaining amounts will be written down in the month in which Calculation Type 32 is generated;
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.
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.
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 $ 1,710.05 * 8.00% = 136.80
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
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).
English
Español


