Páginas filhas
  • EFDCON - PIS/COFINS Calculation and EFD Contributions File

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

Índice

01. OVERVIEW

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
titleImportant

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).

Image Modified

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
titleImportant

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
iconfalse
titleImportant

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
iconfalse
titleImportant

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
iconfalse
titleImportant

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


Operation with Invoice without Tax Records

...

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.

 

17. CALCULATION OF ICMS PAYABLE EXCLUSION FROM PIS/COFINS CALCULATION BASE

...

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


21. TECHNICAL INFORMATION

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:

·  
  • Integrate tax authorities through standardization and sharing of accounting and tax information, following legal restrictions.
·  
  • Rationalize and unify accessory obligations for taxpayers, establishing only one transfer of different accessory obligations from different tax authorities;

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