ICMS-ST complement and restitution process and declaration for RS, SC and SP states

Applies to: Dynamics AX 2012 R3

Introduction


The Brazilian states RS, SP and SC have defined and implemented a new processto calculate and report compensation and restitution of ICMS-ST tax amounts ininternal operations to final consumers when goods are acquired under the Taxsubstitution regime (ICMS-ST). This process is applicable for retailers andnon-retailers companies

As a general rule,  the taxpayershould determine on monthly base the difference between the ICMS-ST amountcalculated in incoming fiscal documents and the ICMS-ST amount calculated inoutgoing fiscal documents to the final consumer. Other exceptions and specificrules may applies depending on the state definition

Thisdifference is named: ICMS-ST adjustment, because this correction couldbe positive (+) or negative (-) and it must be reported in SPED Fiscal or otherrelated tax statements.
image.png

High level example

Purchase - Incoming fiscal document BC ICMS ST = 80,00

                ICMS-ST calculated=> 80,00 * 18% = R$ 14,00

Sales - Outgoing fiscal document Base amount = 90,00

                ICMS-ST effective =90,00 * 18% = R$ 16,20 

 ICMS ST amount to complement= R$ 16,20 (ICMS ST effective) - R$ 14,00 (ICMS ST from purchase) = R$ 2,20(> 0.00)

Or

Purchase - Incoming fiscal document BC ST = 80,00

                ICMS-ST calculated  => 80,00 * 18% = R$ 14,00

 Sales - Outgoing fiscal documentBase amount = 70,00

                ICMS-ST effective=  70,00 * 18% = R$ 12,60 

ICMS ST amount for restitution = R$ 12,60 (ICMS STeffective) - R$ 14,00 (ICMS ST from purchase) = R$-1,40 (< 0.00)


Overview


Sao Paulo state implementation

New tax statement named CAT 1219 was introduced by SP state where thecompanies must submit ICMS-ST tax declaration on a monthly base for taxcomplement and restitution of ICMS-ST amounts.

The statement file is generated based on version 1.1.0 of guidancelayout document.

Scope

The CAT 1218 statement includes the generation of following records:

Record0000 – Statement opening and Taxpayer Identification andParticipant Identification

Number

Field 

Description 

01 

REG 

Fixed text containing "0000" 

02 

PERIODO 

Reporting period

03 

NOME 

Entity business name 

04 

CNPJ 

Registration number of the entity in the CNPJ 

05 

IE 

State Registration of the entity 

06 

COD_NUM 

IBGE code

07 

COD_VER 

Version code of the layout. Filled in manually at the reports run.

08 

COD_FIN 

Code of the purpose of the file, filled in manually at the report run:

Code 

Description 

00 

Regular file Delivery

01 

File delivery required by specific intimation 

02 

File delivery for replacement of previously uploaded file  

Record 0150- PARTICIPANT TABLE 

Onlyparticipants with transactions in period; one record per participant

Number 

Field 

Description 

01 

REG 

Fixed text containing "0150" 

02 

COD_PART 

Identification code of the participant

03 

NOME 

Personal or business name of the participant. 

04 

COD_PAIS 

Country code of the participant

05 

CNPJ 

Participant CNPJ 

06 

CPF 

Participant CPF 

07 

IE 

Participant  State Registration  

08 

COD_MUN 

IBGE  code

Record 0200- ITEM IDENTIFICATION TABLE 

Only itemswith operations in record 1100. One line per item.

 Number 

Field 

Description 

01 

REG 

Fixed text containing "0200" 

02 

COD_ITEM 

Item Code 

03 

DESCR_ITEM 

Description item 

04 

COD_BARRA 

Product bar code

05 

UNID_INV 

Inventory Unit of measurement

06 

COD_NCM 

Fiscal classification code 

07 

ALIQ_ICMS 

ICMS rate applicable to the item in internal operations 

08 

CEST 

Tax Substitution Specifier Code 

Record 1050 – BALANCERECORD 

 Totalamount (initial inventory position and final inventory position) of records1100

One line foreach item of the file.

Informationis fetched from the Presumed taxed balances.

Number 

Field 

Description 

01 

REG 

Fixed text containing "1050" 

02 

COD_ITEM 

Item code according Record 0200 

03 

QTD_INI 

Initial item quantity at the beginning of the period 

04 

ICMS_TOT_INI 

Accumulated initial value of the total of the ICMS supported by the taxpayer, calculated for the item at the beginning of the period 

05 

QTD_FIM 

Final item quantity at the end the period 

06 

ICSM_TOT_FIM 

Accumulated final value of the total of the ICMS supported by the taxpayer, calculated for the item at the end of the period 

Record 1100– BALANCE DELAILS RECORD 

Details of electronic Fiscaldocuments.

Information is fetched from theOutgoing and Incoming tabs of the Presumed taxes form

Number 

Field 

Description 

01 

REG 

Fixed text containing "1100" 

02 

CHV_DOC 

Electronic Fiscal Document ACCESSKEY

03 

DATA 

Fiscal document date 

04 

NUM_ITEM 

Sequential number of item in the  Electronic Fiscal Document 

05 

IND_OPER 

Indicator of operation type: 

0- Input; 

1- Output 

06 

COD_ITEM 

Item code according Record 0200 

07 

CFOP 

Fiscal Code of Operation and Provision 

08 

QTD. 

Item Quantity - no negative values for returns; always positive

09 

ICMS_TOT 

Total value of ICMS supported by taxpayer in incoming fiscal documents

10 

VL_CONFR 

ICMS and ICMS ST value for outgoing fiscal documents

11 

COD_LEGAL 

Code of Legal Framework of the hypothesis of Refund or Complement of ICMS ST 

Described below in the table. 

Code

Hypothesis of Restitution or Complement of ICMS ST 

Observation

Operation where the Restitution or Complement of ICMS ST is applicable in the hypothesis of Item I of Article 269 of the RICMS 

Outgoing Fiscal Document to final consumer - ICMS ST [60]

Operation where the Restitution of ICMS ST is applicable in the hypothesis of Item II of Article 269 of the RICMS 

Outgoing Fiscal Document for inventory decrease CFOP 5.927/others - ICMS CST [90] (Generating fact did not occur)

Operation where the Restitution of ICMS ST is applicable in the hypothesis of Item III of Article 269 of the RICMS 

Outgoing Fiscal Document  - ICMS CST [30] (Exempt or not taxed)

Operation whre the Restitution of ICMS ST is applicable in the hypothesis of Item IV of Article 269 of the RICMS 

Outgoing Fiscal Document to other state - ICMS ST [60] (Interstate)

0

Operation where the Restitution or Complement of ICMS ST is not applicable

Other Outgoing Fiscal Documents  ICMST <> [60] (not classifying for codes 1 to 4)

Rio Grande do Sul (RS)state implementation

Through Decree 54308/2018 of RS this state establishes theprocedure to calculate and report the complement or restitution of ICMS-ST taxamount for those contributors (retailers and non-retailers) who perform activitieswith goods subject to the tax substitution regime (ICMS-ST)

The state has defined two process, one for retail companies and anotheron for non-retail companies.

Scope

The ICMS-ST amount calculated for complement andrestitution are reported in SPED Fiscal ICMS-ST under the record 1900 andrelated adjustment records 1921, 1923 and other ones since the state considerthis process as an sub assessment of ICMS-ST

Non-Retail companies

Records

Level

Description

 Comment

Parameters from RS state

1001

1

 Opening Block 1

 

 When enable Block 1900

1900

2

Indicator of ICMS-ST sub tax assessment

 

 Sub tax assessment indicator and description

1910

3

Booking period

 

 

1920

4

TOTALS amounts

 Summarization from records 1921

 

1921

5

RS001920

The Adjustment transaction that summarizes all ICMS effective amount from:

  • Outgoing fiscal document for final consumer ( CFOP 5*) and
  • CST = 60 and

Tax type = ICMS and or ICMS-ST

Adjustment code of Debit for outgoing fiscal documents

1923

6

1:N records

Details of outgoing fiscal documents by item or consolidated by fiscal document

Consolidate record 1923

1921

5

RS021922

The  Adjustment transaction that summarizes the ICMS-ST amount OR ICMS presumed amount (when ICMS-ST does not exit)  from Incoming fiscal documents with ICMS-ST = 60 and related to the above outgoing fiscal document

Note: Incoming fiscal documents of items reported in record 1921-RS001920 only.

Adjustment code of Credit for outgoing fiscal documents

1923

6

1:N records

Details of incoming fiscal documents by item or consolidated by fiscal document

Consolidate record 1923

1921

4

RS041921 or RS011921

The adjustment transaction of complement or restitution

Adjustment code Complement reverse or Restitution reverse

E220

RS101921

The adjustment transaction created to report in E220

Adjustment code of  Complement E220

E111

RS011021

The adjustment transaction created to report in E111

Adjustment code of  Restitution E111

Retail companies

Records

Level

Description

Comments

Parameters from RS state

1001

1

 Opening Block 1

 

 When enable Block 1900

1900

2

Indicator of ICMS-ST sub tax assessment

 

 Sub tax assessment indicator and description

1910

3

Booking period

 

 

1920

4

TOTALS amounts

 Summarization from records 1921

 

1921

5

RS021921

CREDIT: Adjustment transaction that summarizes the ICMS-ST amount or ICMS amount presumed tax (when doesn't exist ICMS-ST)  from all incoming fiscal documents received in the period (include those that are not used in outgoing and taxation code = 60 (CST)

Received and Approved in the booking period

Adjustment code of credit for incoming fiscal documents

1923

6

1:N records

Details of incoming fiscal documents by item or consolidated by fiscal document

Consolidate record 1923

1921

5

RS021920

Credit from Inventory .The adjustment transaction  to register the inventory credit . This amount is calculated Presumed tax balance form under ICMS-ST tax assessment in relation of inventory opening balance.

Since this adjustment must be reported 3 installments, the field DESCR_COMPL_AJ in record 1921, includes the following text:

"Valor adjudicado nos termos do RICMS, Livro III, art. 25-A, I, nota 05, 1/3"

 

Adjustment code of credit of inventory

1921

5

RS011920

Credit reversal. The adjustment transaction that summarizes the ICMS tax from outgoing fiscal document to non final consumer and taxation code =  60 and/or to final consumer with ICMS = exempt or non taxable taxation code <> 60

 Adjustment code of credit reversal

1921

5

RS001920

Debit: The adjustment transaction that summarizes the outgoing fiscal documents of ICMS effective (CFOP 5*) to final consumer, taxation code  = 60

 

Adjustment code for debit from outgoing fiscal documents

1923

6

1:N records

Details of outgoing fiscal documents by item or consolidated by fiscal document

Consolidate record 1923

1921

5

RS041921

The adjustment transaction of complement or restitution

Adjustment code Complement reverse or Restitution reverse

1926

5

Payment ICMS-ST

Equal to E250. This record is generated  when there is amount to collect and payment exist in ICMS-ST tax assessment (compensation)

 

 

E220

RS101921

The adjustment transaction created to report in E220

Adjustment code of Complement E220

E111

RS011021

The adjustment transaction created to report in E111

Adjustment code of Restitution E111


Santa Catarina (SC) stateimplementation

Through THE SEF Portaria No. 396/2018 thisstate establishes the procedure to calculate and report the complement orrestitution of ICMS-ST tax amount for those contributors (retailers andnon-retailers) who perform activities with goods subject to the tax substitutionregime (ICMS-ST)

Scope

Block 

Description 

Opening, Identification and References

Inventory position

Other information

Structure:

image.png

 

Control and Closing file

The following records are outof scope: 2112 (outgoing fiscal documents generated by ECF) and 2131





More Information


Setup

Navigate to Fiscal books > Setup > Fiscalbooks parameters per state, then select the appropriated state (SP. SCor RS)

Presumed tax

Presumed tax calculationalgorithm: Select the appropriatedmethod to calculate the presumed ICMS-ST tax when outgoing fiscal documents to final and non-final consumerare generated and posted in Dynamics AX. This parameter is used to fulfill the related tags when NFe fiscaldocument model

  • Last purchase: Use information from latest incoming fiscal documentsposted in the period

     

    SPED Presumed taxcalculation algorithm: Select the appropriated method to calculate the presumed ICMS-ST fromICMS-ST tax assessment created in Fiscal Books module.
  • Average: Calculate the average amount from incoming fiscal documents. Thismethod must be selected for SP or SC state
  • Last purchase: Use information from latest incoming fiscal documents posted in theperiod. This method must be selected for RS state

image.png


ICMS-ST sub taxassessment in RS state

In case of RS state since the amounts and details about the calculationof ICMS-ST compensations and restitution are reported in SPED fiscal under therecords 1900 and related. Additional setup configuration is necessary to automaticallycreate the adjustments transactions established by the Decree 54308/2018.


image.png


  • Block 1900: Enables the generation of records of ICMS-ST sub taxassessment detailed in the scope session
  • Sub taxassessment indicator:  Select the available type of indicators toidentify the sub tax assessment
  • Sub taxassessment description: Introducea complementary description of sub tax assessment reported in record 1900 infield (03) DESCR_COMPL_OUT_APUR
  • Journal name: Select the journal used to create and post thecompensation and restitution tax assessment.
  • Credit fromincoming fiscal documents: Select therelated adjustment code the legislation establishes for this type ofadjustment.
  • Debit from outgoingfiscal documents: Select the related adjustment codethe legislation establishes for this type of adjustment
  • Retailcompany: Enable this checkbox if the mainbusiness activity on this state is Retail. Otherwise disable the checkbox.
  • Creditreversal: Select the related adjustment codethe legislation establishes for this type of adjustment
  • Credit ofinventory: Select the related adjustment codethe legislation establishes for this type of adjustment
  • Complement(reverse): Select the related adjustment codethe legislation establishes for this type of adjustment
  • Restitution (reverse): Select the related adjustment code the legislationestablishes for this type of adjustment
  • Complement(E210-E220): Select the related adjustment codethe legislation establishes for this type of adjustment. When this adjustmentbeing created the ICMS-ST tax assessment will be updated as well
  • Restitution(E111): Select the related adjustment codethe legislation establishes for this type of adjustment. When this adjustmentbeing created the ICMS tax assessment will be updated as well, since credit areonly allowed in ICMS tax assessment.
  • Consolidaterecord 1923. Enable this checkbox if you wantto consolidate or report on record 1923 per fiscal document (no itemsdetailed).  The field 08 COD_ITEM will beleaved in blank.

Repro steps


ICMS-ST tax assessment

Before to proceed with the generation of statement for each state, youneed to create a fiscal booking period for the month , the ICMS-ST taxassessment for the related state and then calculate balances if applicable inthe state.

OpenFiscal books >Common >Tax assessment >ICMS-ST andclick Presumed taxes balance.
image.png


The form includes fields that are needed for the reporting purposes:Item code, product description, inventory unit measure, quantities, ICMS andICMS ST taxes and base amounts per inventory unit and their totals.

Inthe Presumed taxes balance form, click Calculate inventory balances.System will calculate the initial Opening balance and the Closingbalance and show the figures per Item number.

image.png


Opening balance calculation function works asfollowing:

  1. Validates whether the presumed taxes balance for previous period exist.If no such balances observed, then starts the calculation; otherwise theprocedure considers the figures from the previous period.
  2. Selects all items in on-hand inventory which have any transactionsbefore the period.
  3. Calculates quantity for every selected item on the first day of theperiod.
  4. Finds last purchase for every item with the ICMS-ST tax transaction.
  5. Using the tax amounts from the last purchase and converting the purchaseunit to the inventory one, calculates ICMS and ICMS-ST amount for the on-handinventory quantity.

Closing balance calculation. Only applicable forSP state

  1. Deletes old presumed taxes balances for the period except the recordswhich are used for the next period (these amounts will be updated; all otheramounts will be recalculated).
  2. Selects all items in on-hand inventory which have any transactions inthe period.
  3. For every item search for the presumed taxes balance in the previousperiods to get quantity for the opening balance, otherwise it would be zero.
  4. Selects all incoming fiscal documents in the period, summarizesICMS/ICMS-ST tax amounts and summarizes items quantities.
  5. Calculates average amount per unit by summarizing the totals of ICMS/ICMS-STamounts of all incoming documents and dividing them by the summarized quantity inthese documents.
  6. Selects all outgoing fiscal documents and summarizes their quantities.Calculates ICMS/ICMS-ST tax amounts using the average amount which wascalculated in step 5.
  7. Calculates closing balance amounts and quantities using the values from theprevious periods and the sums of incoming and outgoing documents from currentperiod. These sums were calculated in step 4 and 6, respectively.

Presumed taxcalculation

Once the Balances are calculated (for the first time), open the Presumedtaxes form and click Calculate presumed tax.

image.png

The form includes fields that are needed for the reporting purposes andeach tab includes the related fiscal documents that are applicable forcompensation and restitution in accordance with the criteria’s established bystate law.

  • Outgoing tab: Fiscal document number, item code, inventory unit measure,quantities, ICMS and ICMS ST tax rates, ICMS and ICMS ST tax and base amountsand calculated presumed taxes.
  • Incoming tab: Fiscal document number and date, item code, inventory unitmeasure, quantities, and ICMS and ICMS ST tax and base amounts.
  • Credit reversal. Only applicable for RS state. Outgoing Fiscal documents tonon-final consumer and taxation code = 60 and/or to final consumer with ICMS =exempt or non-taxable taxation code <> 60

Presumed tax calculation - Average algorithmworks a following:

  1. Selects all lines of all outgoing fiscal documents in the currentperiod.
  2. For every item from these lines selects all lines of all incoming fiscaldocuments with the same item code in the current period. And then calculatesaverage ICMS/ICMS-ST tax amount.
  3. In case of no incoming document in the period, then the correspondingrecord in the presumed taxes balances is taken into consideration.

Note for SP. For Salescomplementary fiscal documents and Purchase order returns the average valuesare not calculated, the values from the original fiscal documents areconsidered only.

Generate adjustments

Use this button for RSstate to generate the related tax adjustment to be reported in SPED Fiscal.

Depending on type ofcompany business (Retail or Non retail), Dynamics AX will generate the related adjustments:

  1. Debit for outgoingfiscal documents
  2. Credit for incomingfiscal documents
  3. Credit from Inventoryposition (opening balance). This tax adjustment will be created once and splitin 3 installments.
  4. Credit Reversal.
  5. Compensation andrestitution (reversal)
  6. Compensation in recordE220
  7. Restitution in recordE111

Note: Once you pressed Generate Adjustment button, there is noway to go back to the initial state. You must reverse manually the adjustmenttransaction created during the execution of this option to report record E220or E111.  The other adjustments relatedto debit, credit, credit for inventory and creditreversal are only created for SPED fiscal purposes. You will not able tosee these transactions since are saved in a temporary table.

Statement generation

SP state

Navigate to Fiscal books>Common>Booking period andon the Tax statements tab click CAT 4218 SP. Thisstatement is also available in ICMS-ST tax assessment for SP state.

  • File name – enter the path where the file should be saved and the name of thetext file.
  • Layout version – select the version.
  • File type – select one of the available options for the type of the file:
    • Regular
    • Specific intimation
    • Substitute

The generated text file should be validated first by using tax authorityapplication and once the file was successfully approved you will be able tosend tax authorities.

RS state

Navigate to Fiscal books>Common>Booking period andon the Tax statements tab click SPED fiscal. Thisstatement is also available in ICMS-ST tax assessment for RS state.

Introduce the regular parameters that are usually introduced to generatethe statement SPED Fiscal. In order to generate the records 1900 and relatedyou must reproduce the following steps:

  1. Create and Sync the related booking period
  2. Sync Inventory if applicable the criteria to take the credit fromopening balance of inventory.
  3. Create or Update the ICMS-ST tax assessment for RS state
  4. Calculate Presumed tax balances (if applicable)
  5. Calculate Presumed tax
  6. Generate adjustments. Click on Generate Adjustment button under Presumedtax form
  7. Complete the remainder activities or steps related to ICMS-ST taxassessment
  8. Then generate SPED Fiscal statement as usual.

SC state

Navigate to Fiscal books>Common>Booking period andon the Tax statements tab click SPED DRCST. This statementis also available in ICMS-ST tax assessment for SC state

  • File name – enter the path where the file should be saved and the name of thetext file.
  • File type – select one of the available options for the type of the file:
    • Regular
    • Substitute

This file is submitted by using webservices and require certificate.Once the return message is received with the result of government validation,the response is saved in the same location where the file was generated.







Hotfix information


How to obtain the Microsoft Dynamics AX updates files

This update is available for manual download andinstallation from the Microsoft Download Center.

SPED Fiscal ICMSIPI - Decree 54.308/18 – RS in  Microsoft Dynamics AX2012 R3

Download update for Microsoft Dynamics AX 2012 R3

 

ICMS-ST complementand Reimbursement  declaration for SPstate - CAT 42/18 in  Microsoft Dynamics AX2012 R3:

Download update for Microsoft Dynamics AX 2012 R3


ICMS-ST complementand Reimbursement  declaration for SC state - DRCST declaration in  Microsoft Dynamics AX2012 R3:

The following additional hotfixes are required for DRCST declaration:


Prerequisites

You must have one of the following products installedto apply this hotfix:

  • Microsoft Dynamics AX 2012 R3

    Restart requirement

    You must restart the Application Object Server (AOS)service after you apply the hotfix.