Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
The state of Rio de Janeiro (RJ) has published Resolution 13/2019. This resolution defines how a Nota fiscal eletrônica (NF-e) should be issued, and how the information should be recorded in the EFD-ICMS/IPI when the following operations are run (Decree No. 27.815/01):
According to the resolution, exonerations are registered as adjustments on fiscal documents and in fiscal books, and should be reported in Sistema Público de Escrituração Digital (SPED) files.
The resolution requirements affect the output of lines E111, E115, C195, C197, and 0460 in SPED Fiscal.
During the synchronization process, two types of adjustment transactions are created in the Imposto Sobre Operações Relativas à Circulação de Mercadorias e Serviços (ICMS) tax assessment when the following conditions are met:
Here are some examples of adjustment transactions that are automatically created in SPED Fiscal:
The adjustment code from table 5.2 generates an E115 record:
|E115|RJ801137|0||
The adjustment code from table 5.3 generates a C197 record:
|C197|RJ90980000|RJ801137|ItemId|0.00|0.00|0.00|0.88|
Note
In this example, the base amount is 3.5, the ICMS percentage is 18, and the Fundo de Combate e Erradicação à Pobreza (FCP) rate is 0.02. Therefore, the amount 0.88 is calculated in the following way:
3.5 ÷ (1 – [0.18 + 0.02]) × (0.18 + 0.02)
The observation code that is assigned to the related item and state of the fiscal document generates C195 and 0460 records:
|C195|<Observation code>|<Observation code description>|
|0460|<Observation code>|<Observation code description>|
To register the credit reversal, create a manual adjustment in the General tax adjustment/benefit/incentive journal, and add the code from table 5.2 to the Description field.
Here is an example of an adjustment transaction that is automatically created in SPED Fiscal:
|E111|RJ18003|RJ801137|<Adjustment amount>|
During the synchronization process, two types of adjustment transactions are created in the ICMS tax assessment when the following conditions are met:
Here are some examples of adjustment transactions that are automatically created in SPED Fiscal:
The adjustment code from table 5.2 generates an E115 record:
|E115|RJ802164|0||
The adjustment code from table 5.3 generates a C197 record:
|C197|RJ90980000|RJ802164|ItemId|0.00|0.00|0.00|0,20|
Note
In this example, the base amount is 3.5, the ICMS percentage is 12, and the percentage reduction is 41.67. Therefore, the amount 0.20 is calculated in the following way:
3.5 × (1 – [0.12 × (1 – 0.4167)]) ÷ (1 – 0.12) – 3.5
The observation code that is assigned to the related item and state of the fiscal document generates C195 and 0460 records:
|C195|<Observation code>|<Observation code description>|
|0460|<Observation code>|<Observation code description>|
Out of scope: The system can't prepare the additional percentage that is required for C197 records.
To register the reversal of credits, create a manual adjustment in the General tax adjustment/benefit/incentive journal, and add the code from table 5.2 to the Description field.
Here is an example of an adjustment transaction that is automatically created in SPED Fiscal:
|E111|RJ018003|RJ805289|<Adjustment amount>|
During the synchronization process, one type of adjustment transaction is created in the ICMS tax assessment when the following conditions are met:
Here is an example of an adjustment transaction that is automatically created in SPED Fiscal:
The adjustment code from table 5.2 generates an E115 record:
|E115|RJ822371|0||
Note
Because there is no code from table 5.3, records C195, C197, and 0460 aren't created.
To register the reversal of credits and debits, create manual adjustments in the General tax adjustment/benefit/incentive journal, and add the code from table 5.2 to the Description field.
Here are some examples of adjustment transactions that are automatically created in SPED Fiscal:
|E111|RJ18003|RJ822371|<Adjustment amount>|
|E111|RJ38003|RJ822371|<Adjustment amount>|
|E111|RJ08006|RJ822371|<Adjustment amount>|
During the synchronization process, two types of adjustment transactions are created in the ICMS tax assessment when the following conditions are met:
Here are some examples of adjustment transactions that are automatically created in SPED Fiscal:
The adjustment code from table 5.2 generates an E115 record:
|E115|RJ818317|0||
The adjustment code from table 5.3 generates a C197 record:
|C197|RJ90980001|RJ818317|ItemId|0.00|0.00|0.00|6585.36|
Note
In this example, the base amount is 30000.00. Therefore, the amount 6585.36 is calculated in the following way:
30000.00 ÷ (1 – 0.18) × 0.18
The observation code that is assigned to the related item and state of the fiscal document generates C195 and 0460 records:
|C195|<Observation code>|<Observation code description>|
|0460|<Observation code>|<Observation code description>|
During the synchronization process, two types of adjustment transactions are created the in ICMS tax assessment when the following conditions are met:
Here are some examples of adjustment transactions that are automatically created in SPED Fiscal:
The adjustment code from table 5.2 generates an E115 record:
|E115|RJ801163|0||
The adjustment code from table 5.3 generates a C197 record:
|C197|RJ90980000|RJ801137|ItemId|0.00|0.00|0.00|20|
Note
In this example, the base amount is 200, the ICMS percentage is 18, and the FCP rate is 0.02. Therefore, the amount 20 is calculated in the following way:
200 ÷ (1 – [0.18 + 0.02]) × (0.18 + 0.02)
The observation code that is assigned to the related item and state of the fiscal document generates C195 and 0460 records:
|C195|<Observation code>|<Observation code description>|
|0460|<Observation code>|<Observation code description>|
To register the reversal of credits, create manual adjustments in the General tax adjustment/benefit/incentive journal, and add the code from table 5.2 to the Description field.
Here is an example of an adjustment transaction that is automatically created in SPED Fiscal:
|E111|RJ18003|RJ801163|<Adjustment amount>|
During the synchronization process, two types of adjustment transactions are created in the ICMS tax assessment when the following conditions are met:
To register the reversal of credits, the system automatically creates adjustments in the General tax adjustment/benefit/incentive journal and relates the journal line to the tax fiscal document.
Here are some examples of adjustment transactions that are automatically created in SPED Fiscal for a sender:
|E115|RJ821231|0||
|C197|RJ40080001|RJ821231|codigoitem|0.00|0.00|<Tax amount>|0.00|
Here are some examples of adjustment transactions that are created automatically in SPED Fiscal for a recipient:
|E115|RJ821231|0||
|C197|RJ10080002|RJ821231|codigoitem|0.00|0.00|<Tax amount>|0.00|
Follow these steps to set up Fiscal books parameters for each state.
These settings help guarantee that you get a correct SPED Fiscal according to the resolution.
These settings are used to automatically generate ICMS adjustment records for a fiscal document line during posting and during the Sync operation.
If the Document adjustment option is set to Yes on the Fiscal books parameters per state page, users can select only a sales tax code that has a fiscal value of 3 on the tax fiscal document line. The taxation code, as it's related to the sales tax code, has a fiscal value of 3, without credit/debit.
Note
For correct posting, the tax fiscal document and the selected sales tax code should have the following calculation settings:
When you post a tax fiscal document where a sales tax code is attached to the line, the system doesn't create a voucher transaction. When you run the Sync operation, the system creates and posts a General tax/adjustment/benefit/incentive journal that is related to the posted tax fiscal document for ICMS transfer to another fiscal establishment. (To run the Sync operation, go to Fiscal books > Common > Booking period, and then select Sync.)
The system fills in data on the journal lines from the posting profile of adjustment code 5.3. It fills in the amount from the tax fiscal document.
Note
Before you use this functionality, set up the benefit code per item/state for ICMS transfer by going to Tax > Setup > Sales tax > Benefit code per Item/ state. According to the resolution, the following adjustment codes should be set up for ICMS transfer:
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Module
Set up taxes in Dynamics 365 Finance - Training
Streamline tax management with automated calculations and compliance in Dynamics 365 Finance to enhance efficiency through ledger postings and sales tax configurations.
Documentation
Acquire and dispose a CIAP fixed asset - Finance | Dynamics 365
Fiscal books can acquire and dispose of fixed assets that are ICMS tax long term return, including a step-by-step process for acquiring CIAP fixed assets.
SPED fiscal ICMS-IPI layout 014 - Finance | Dynamics 365
Learn how to set up and generate SPED fiscal statement layout 014, including outlines on classification of fiscal establishments and incoming fiscal documents.
Set up PIS and COFINS tables (Brazil) - Finance | Dynamics 365
Before the PIS and COFINS tax assessment can be created, you must set up the tables for the credit source and credit type.