The information, values, calculation formulas, and examples presented in this material are merely illustrative and are intended exclusively for educational and conceptual support.

This data should not be used as a basis for actual accounting without proper validation against current legislation, official regulations, and the guidance of qualified professionals.

It is recommended that each company evaluate its own scenarios, considering the specific rules applicable to its tax regime, operations, and ancillary obligations required by the competent authorities.

01. Practical example


The fields F4_MALQPIS and F4_MALQCOF will no longer exist with the implementation of the project to discontinue fields from the SF4 table. More information can be found in the official documentation: CFGTRIB - Fields that Remain in the TES ( 🚧documentation under construction ) - Microsiga Protheus Line - TDN

Currently, filling in these fields is necessary in scenarios where the N1_ALIQPIS and N1_ALIQCOF fields are expected to be used in the integration between Purchases and Assets, also taking into account the increased values in these fields.

Given this, it became necessary to understand how this functionality will be handled in the Tax Configuration, considering the discontinuation of the aforementioned fields.


For the increased rate and its respective calculated value to be recognized when posting the Inbound Fiscal Invoice, the rate must be applied to the desired NCM, along with the product's origin.

NCM x Product Registration


Registration of the Calculation Basis Rule – Increase


Registration of the Rate Rule – Increase (PIS)


Registration of the Rate Rule – Increase (COF)

Registration of the Calculation Rule - Tax Documents - Increase (PIS)



Registration of the Calculation Rule - Tax Documents - Increase (COF)



Linking the Tax for Increase in the Main PIS Rule 

Note: The tax for the increase is the calculation rule registered for PIS Increase.


Linking the Tax for Increase in the Main COF Rule 

Note: The tax for the increase is the calculation rule registered for COF Increase.




Entry Invoice Inclusion


Increased PIS Value:

  1. Value of the Goods:
    R$ 1,000,000.00
  2. Increased PIS Rate (NCM Registration):
    0.30%
  3. PIS Calculation Base:

1,000,000.00×0.30% = 3,000.00

  1. Increased Auxiliary Index (NCM Registration):
    1%
  2. Increased Value:

3,000.00×1% = 30.00


Increased COF Value:

  1. Value of the Goods:
    R$ 1,000,000.00
  2. Increased PIS Rate (NCM Registration):
    0.10%
  3. PIS Calculation Base:

1,000,000.00×0.10% = 1,000.00

  1. Increased Auxiliary Index (NCM Registration):
    1%
  2. Increased Value:

1,000.00×1% = 10.00