Índice
EFD-PIS/COFINS is a digital file established by the Public Digital Bookkeeping System – SPED, for the use of private legal entities to book PIS/PASEP and COFINS tax payments, in non-cumulative and cumulative calculation systems, based on the set of documents and operations that represent the revenues earned, as well as the costs, expenses, charges, and acquisitions that generate credits from non-cumulative taxation.
...
Aviso | ||
---|---|---|
| ||
For bookkeeping purposes, we usually recommend using the values saved in table SE2; however, if you need to return values from the calculation table, handle the process so as to avoid returning duplicated data, given that field _TRIB contains the same information (one for the cumulative system and another for the non-cumulative one). Note: The configuration of the Standard Entries above is for illustrative purposes only. The customer is responsible for their own configurations in accordance with their business rules. |
...
Aviso | ||
---|---|---|
| ||
In the deemed credit calculation, if the need arises to generate a reversal resulting in reduction adjustment, we have the auxiliary registers: FIS0104 PIS and COFINS Reversal Percentages Register and FIS0103 Registration of PIS and COFINS Credits Liable to Reversal. |
Total Credit Deferred in the Period: Here we have credit values deferred in the period.
...
Aviso | ||||
---|---|---|---|---|
| ||||
The revenue code may be filled out automatically, through parameter MV_CDRCEC. For more information on how to use this parameter, access: TUTEDN_TD_REVENUE_CODE_M205_M605. The credits are only used in the period if the field Cred Reserve (CCY_RESCRE) is set to option "No or Blank". |
...
Aviso | ||||
---|---|---|---|---|
| ||||
The information is only saved in tables SFV and SFW if there is a balance to be carried over to the next period. For further information on how to request Refund/Compensation for PIS and COFINS Withholdings, refer to PIS/COFINS Withholding Control |
At the end of the calculation, if the questions for bill generation and bookkeeping are set to YES, then bills payable are saved with the contribution value, and the standard entry for bookkeeping is executed.
...
Revenue code values can be broken down. For further information, refer to bulletin FIS0082_for_PIS_COFINS_Revenue_Code_Rules
PIS Payroll: On this screen, we have the values returned by integration with the GPE module. They are on a separate screen because this PIS value on Payroll cannot be mixed with the calculation value. On this screen, we do not have any value details.
...
The user can perform the calculation in two ways. The first is by grouping all the information and values in the parent company (the one logged) and, in the case of manual adjustment entries, the values of all branches are combined and added to the parent company, thus generating a single calculation containing the values of all branches. To do this, the question Recording Option must be set to "Grouped". In this generation option, adjustments that are manually entered and added to the branches are only disregarded if added to the centralizing parent company view.
The The second way is by performing the calculation by branch distinctly, with each branch having its own calculation. When all values are correct, the calculations of each branch can then be consolidated into a single one in the company view. To do this, you must set the question Recording Option to "Individualized" and log onto the branch to generate the calculations individually. After checking the data, the user must click the option Group Branch -> Parent Company, enter the company in which to consolidate the calculations, then fill out in which calculation period to group them, then select which branches must have their calculations consolidated. Once these data are confirmed, the routine groups the data of all branches selected.
...
The Assets used in the calculation are those registered in the module Fixed Assets and entitled to PIS and COFINS credit.
Aviso | ||||
---|---|---|---|---|
| ||||
Concerning assets added through incoming documents not configured for PIS and COFINS credit calculation, with CST, Calculation Base Code of Credit, Rate, etc.; this information must be complemented in the Asset classification, in the module Fixed Assets, to correctly configure the asset for use in the calculation. |
...
Some data also registered in auxiliary routines in the module Tax Management are used in the calculation, in accordance with the table below:
Routine Name | Program |
---|---|
PIS/ COFINS Exclusions | FISA039 |
PIS/COFINS Deduction | FISA041 |
PIS/COF Credit Adj. | FISA042 |
PIS Credit Contr. | FISA044 |
COFINS Credit Contr. | FISA045 |
PIS Withh. Contr. | FISA216 |
COFINS Withh. Contr. | FISA217 |
Extemporan. Credit | FISA046 |
Opening Inventory | FISA049 |
PIS/COFINS Comp.Res. | FISA050 |
Deferral Preprocessing | FISA054 |
...
In this case, the taxpayer has a process that allows the exclusion of the ICMS payable obtained from the ICMS calculation, which is declared in the family of the E100 record of the Tax SPED. In this case, the PIS and COFINS values are calculated in the invoice without excluding the highlighted ICMS, and will only be excluded from the calculation base when calculating the Contributions EFD considering the ICMS to collect, which is a result of the ICMS calculation.
...
To handle the hypothesis of ICMS Payable exclusion from the EFD Contributions calculation, we have a new question "ICMS Excl. Legal Decision", in which the taxpayer may enter whether they have a legal decision to exclude the ICMS Payable or a legal decision to exclude the Highlighted ICMS, or whether there is no legal decision for ICMS exclusion. Only the option to exclude ICMS Payable affects the calculation base reduction in the EFD Contributions calculation.
...
The revenues are stated below by CST and block:
CST | Revenue Block A | Revenue Block C | Revenue Block D | Revenue Block F | Revenue Total by CST and Block |
---|---|---|---|---|---|
01 | BRL 0.00 | BRL 30,000.00 | BRL 10,000.00 | BRL 10,000.00 | BRL 50,000.00 |
06 | BRL 0.00 | BRL 10,000.00 | BRL 0.00 | BRL 20,000.00 | BRL 30,000.00 |
09 | BRL 10,000.00 | BRL 0.00 | BRL 0.00 | BRL 10,000.00 | BRL 20,000.00 |
Totals | BRL 10,000.00 | BRL 40,000.00 | BRL 10,000.00 | BRL 40,000.00 | BRL 100,000.00 |
In the period, consider an ICMS Payable value equal to BRL 10,000.00.
...
In this hypothesis, the exclusion percentages are obtained through the following formula:
Exclusion Percentage by CST = (Revenue Total by CST of blocks A, C, D, and F) / Revenue Total |
And the exclusion value is obtained through the formula:
ICMS Value * Exclusion Percentage by CST |
For CST 01 the percentage is calculated as follows:
...
In this hypothesis, the exclusion percentages are obtained through the following formula:
Exclusion Percentage by CST = (Revenue Total by CST of blocks C and D) / Total of Revenues Subject to ICMS |
And the exclusion value is obtained through the formula:
ICMS Value * Exclusion Percentage by CST |
For CST 01 the percentage is calculated as follows:
...
BRL 10,000.00 * 0% = BRL 0.00
In this case, the actual exclusion value is only from CST 01 of BRL 8,000.00, as CST 06 and 09 are not taxed.
This means we would have a record of calculation base reduction adjustment with the value BRL 8,000.00 in records M215 and M615, and also record 1050 with values BRL 8,000.00 and BRL 2,000.00 for CST 01 and 06, respectively.
The taxpayer decides which method to follow for excluding the ICMS Payable from the PIS calculation base, through the question "ICMS Payable Exclusion" of EFD Contributions calculation.
...
EFDCON - File Creation Settings
Who is it aimed at | Private legal entities in general and those matched to them by Income Tax laws, which calculates the Contribution for PIS/PASEP and for Social Security Financing Contribution - COFINS based on monthly billing. |
---|---|
Purpose | Among other things, SPED aims to: |
|
To accelerate the identification of tax offenses through improved process controls, faster access to information, and a more effective inspection of operations with data cross-checking and electronic audits. | |
Delivery Term | Monthly |
---|---|
Reach | Domestic |
Application made available by Tax Authority | PVA EFD |
Application version supported by TOTVS® | 2.0.9 |
Where to find it | http://www1.receita.fazenda.gov.br/sped-fiscal-pis-cofins/legislacao.htm |
Tables used | CKR, CKS, CKT, CKU, CKV, CKW, CKX, CKY, CL1, CL2, CL4, CL5, CL6, CL7, CL8, CL9, CLA, SFT, SF3, SF1, SD1, SF2, SD2, SB1, SB5, SF4, SA1, SA2, CDT, CDG, CCE, CCF, CD3, CD4, CD5, CDG, CDN, DT6, SA1, SA2, SAH, SB1, SD1, SD2, SE4, SF2, SF1, SF3, SF4, SFT, SFU, SFX, SFI, SLG, CVB, CDT, CT1, CTT, CCZ, CCY, CCW, SE1, SE2, SED, SFV, SFW, SN1, SNG, CVD, CD6, SB5, CE9 |