(BRA) Setting Up Your System for Electronic Tax Reporting

This chapter provides an overview of account types for electronic tax reporting according to Ato COTEPE 70 of 2006 and discusses how to:

• Set up constants for electronic tax reporting according to Ato COTEPE 70 of 2006.

• Set up constants for electronic tax reporting according to Ato COTEPE 11 of 2007.

• Set up the fiscal city code.

• Set up additional item information for electronic tax reporting according to Ato COTEPE 11 of 2007.

• Set up Imposto sobre Circulação de Mercadorias e Serviços (ICMS) period balance amounts for electronic tax reporting according to Ato COTEPE 11 of 2007.

• Set up Imposto sobre Produtos Industrializados (IPI) balance amounts for electronic tax reporting according to Ato COTEPE 11 of 2007.

• Set processing options for Fiscal Note - Block A (R76B0530) for electronic tax reporting according to Ato COTEPE 70 of 2006.

• Set processing options for Fiscal Note – Block C (R76B0550) for electronic tax reporting according to Ato COTEPE 70 of 2006.

• Set processing options for Fiscal Books Initial Process (R76B570) for electronic tax reporting according to Ato COTEPE 70 of 2006.

• Set processing options for Electronic Reporting - Industrialization Return/Send (R76B0583) for electronic tax reporting according to Ato COTEPE 70 of 2006.

Note. You must also set up user-defined codes (UDCs) to use electronic tax reporting.

See Also

Setting Up UDCs for Electronic Tax Reporting

Understanding Account Types for Electronic Tax Reporting for Ato COTEPE 70 of 2006

The block I registers requires information about the types of general ledger accounts for which you process records. You must set up a category code in the Account Master program (P0901) that lists valid codes used for tax reporting. You must set up these codes for a model business unit. You then specify the model business unit and the category code when you set up constants in the Electronic Reporting Constant Setup program (P76B0515).

The codes that you must include in the category code are:

Setting Up Constants for Electronic Tax Reporting According to Ato COTEPE 70 of 2006

This section provides an overview of constants for electronic tax reporting, lists a prerequisite, and discusses how to set up constants.

Understanding Constants for Electronic Tax Reporting

You use the Electronic Reporting Constant Setup program (P76B0515) to set up by reporting company (legal company) information about the layout, purpose, and bookkeeping for data for which you report information. The system stores the constants information in the Electronic Reporting Constant Setup table (F76B05215) and reads the information when you run the extraction or join block processes for electronic tax reporting.

Prerequisite

Before you begin the tasks in this section, verify that these UDCs are set up:

• Type Code (01/W0)

• Centralized Bookkeeping (76B/CB)

• Code of Purpose (76B/CO)

• Fiscal Code (76B/FC)

• Indicator of Type (76B/TY)

• Code of Layout Reg Government (76B/VL)

• Code of Layout Version (76B/VO)

Forms Used to Set Up Constants for Electronic Tax Reporting

Setting Up Constants

Access the Constant Setup Revisions form.

Block 0

Block H

Block I

Setting Up Constants for Electronic Tax Reporting According to Ato COTEPE 11 of 2007

This section provides an overview of constants for electronic tax reporting for Ato COTEPE 11 of 2007, lists prerequisites, and discusses how to set up constants.

Understanding Constants for Electronic Tax Reporting for Ato COTEPE 11 of 2007

You use the Ato Cotepe 11 Constant Setup program (P76B0715) to set up by legal company (reporting company) information about the layout, purpose, and bookkeeping for data for which you report information. The system stores the constants information in the Ato Cotepe 11 Constant Setup table (F76B0715), and reads the information when you run the extraction or join block processes for electronic tax reporting.

Prerequisites

Before you begin the tasks in this section, verify that these UDCs are set up:

• Type Code (01/W0)

• Activity Code (76B/AC)

• Fiscal Presentation Type (76B/FP)

• Code of Layout Version (76B/VO)

Forms Used to Setup Constants for ATO COTEPE 11 of 2007

Setting Up Constants for Ato COTEPE 11 of 2007

Access the Ato Cotepe Constant Setup Revision form.

Block 0

Block H

Setting Up the Fiscal City Code

This section provides an overview of fiscal city codes and discusses how to associate the fiscal city code with an address book record.

Understanding Fiscal City Codes

Registers 0000, 0010, and 0150 in block 0 require a fiscal city code. You use the Supplemental Data program (P00092) to associate a fiscal city code that exists in the Fiscal Code (76B/FC) UDC table to the address book records for which you report information. Those address book records might include the reporting company, customers, suppliers, and the bookkeeping company.

Note. The task in this section assumes that a value of AB (address book) exists in the Supplemental Data Setup program (P00091).

See Setting Up Supplemental Data.

Form Used to Associate Fiscal City Codes to Address Book Records

Associating the Fiscal City Code with an Address Book Record

Access the General Description Entry form.

To associate a fiscal city code with an address book record:

1. On the Work With Supplemental Data form, enter the address book number in the Address Number field.

2. Click Find.

   The system displays the data types that exist for address book records.

3. Select the record with the data type of $J and click Select.

   The $J data type exists for the fiscal city code.

   Note. If data type $J does not exist in your environment, use the Supplemental Data Setup program to add it.

4. On the General Description Entry form, complete the City Code and Effective Date fields.

Setting Up Additional Item Information for Electronic Tax Reporting According to Ato COTEPE 11 of 2007

This section provides an overview of the additional information that you can add, lists prerequisites, lists the forms used to add or review additional item information, and discusses how to set processing options for Item Master Additional Info (P704101).

Understanding Additional Item Information

Register 0200 of block 0 requires information that is not stored in the item tables of the standard software. You can use the Item Master Additional Info program to add the additional information to the Item Master Add Info table (F704101). The system reads the data in the F704101 table when you run the Ato Cotepe 11 - Block 0 Items program (R76B0701) to populate block 0 registers.

You use category codes to associate the additional information to the items. When you use the Item Master program (P4101) to add or modify programs, the system calls the Item Master Additional Info program if the Localization Country Code field in the User Profile Revisions program (P0092) is set to BR (Brazil). The Item Master Additional Info program includes ten category code fields that you can use to associate additional information to items. However, only category codes 70/C1–70/C5 are used for additional information for Ato COTEPE 11 of 2007 tax reporting.

To report the additional information required for Ato COTEPE 11 of 2007 tax reporting, you must set up and use specific category codes because the Ato Cotepe 11 - Block 0 Items program writes the data from specific fields in the Item Master Additional Info program to specific fields in register 0200.

Note. You must use the Item Master program (P4101) to access the Item Master Additional Info form to add Ato COTEPE 11 information for items for which you have not previously added the Ato COTEPE 11 information. When you access the Work with Additional Info form from the Item Master Additional Info menu option, the system does not access items for which Ato COTEPE 11 information does not exist; you can access only items with existing Ato COTEPE 11 information.

Prerequisites

Before you complete the tasks in this section, verify that:

• The category codes that you use for tax reporting are set up in the 70/C1 – 70/C5 UDC tables.

• Corresponding versions exist for the Item Master (P4101) and the Item Master Additional Info programs.

  When you work with items using the Item Master program, the system uses the processing options from the corresponding version of the Item Master Additional Info program. If you do not set up a corresponding version, the system uses version ZJDE0001. However, Oracle strongly recommends that you set up a specific version for working with additional information for Ato COTEPE 11 of 2007.

Forms Used to Add or Modify Additional Item Information

Setting Processing Options for Item Master Additional Info (P704101)

Processing options enable you to specify default processing values.

General

Use these processing options to specify the UDC tables (category codes) for which the system enables you to select UDC values to associate to items. For example, if you specify 76B in the first product code processing option and specify AC in the first user-defined codes field, the system displays the name of the 76B/AC UDC table (Activity Code) as the title of the first category code column in the forms for the Item Master Additional Info program, and enables you to select values from the 76B/AC UDC table to associate with the item.

Note. When setting up these processing options to report taxes according to Ato COTEPE 11 of 2007, you must specify specific UDC tables, as noted in the glossaries for the first five processing options. Oracle recommends setting up a specific version of the Item Master Additional Info program to use when you add additional item master information to items for Ato COTEPE 11 reporting.

Setting Up the ICMS Period Balance Amounts for Electronic Tax Reporting According to Ato COTEPE 11 of 2007

This section provides an overview of the setup for the ICMS period balance amount and discusses how to set up the ICMS period balance amount.

Understanding the Setup for the ICMS Period Balance Amount

Registers E110 and E210 of block E for tax reporting according to Ato COTEPE 11 for 2007 require that you report information about the ending balances that are carried forward to the next period for ICMS and ICMS substitution tax. For the register E110, you must set up the ICMS tax balances for the state of the legal company. The E210 register includes one register for each state in which a company conducts business, so you must set up the ICMS substitution tax balances for each state for the reporting company.

You use the ICMS Period Balance Maintenance program (P76B0770) to enter for each company/state combination the ending balance for ICMS and ICMS substitution tax. You enter the balances for each period of a fiscal year. The system saves the information that you enter in the ICMS Period Balance Maintenance program to the ICMS Period Balance by State and Company table (F76B0770), and reads this table when you generate block E registers.

Forms Used to Set Up the ICMS Period Balance Amounts

Entering ICMS Period Balance Amounts

Access the ICMS Period Balance Maintenance form.

Setting Up the IPI Period Balance Amounts for Electronic Tax Reporting According to Ato COTEPE 11 of 2007

This section provides an overview of the setup of IPI period balance amounts and discusses how to enter IPI period balance amounts.

Understanding the Setup of IPI Period Balance Amounts

Register E520 of block E for tax reporting according to Ato COTEPE 11 for 2007 requires that you report information about the ending balances that are carried forward to the next period for IPI tax. You use the IPI Period Balance Maintenance program (P76B0771) to add the period balance for the reporting company. The system saves the information that you enter to the IPI Period Balance by Company table (F76B0771), and reads this table when you generate block E registers.

Forms Used to Enter IPI Period Balance Amounts

Entering IPI Period Balance Amounts

Access the IPI Period Balance Maintenance form.

Setting Processing Options for Fiscal Note - Block A Program (R76B0530) for Electronic Tax Reporting According to Ato COTEPE 70 of 2006

Processing options enable you to specify default processing values.

Process

Setting Processing Options for Fiscal Note – Block C (R76B0550) for Electronic Tax Reporting According to Ato COTEPE 70 of 2006

Processing options enable you to specify default processing values.

Process

Setting Processing Options for Fiscal Books Initial Process (R76B0570) for Electronic Tax Reporting According to Ato COTEPE 70 of 2006

Processing options enable you to specify default processing values.

Process

Setting Processing Options for Electronic Reporting - Industrialization Return/Send (R76B0583) for Electronic Tax Reporting According to Ato COTEPE 70 of 2006

Processing options enable you to specify default processing values.

Options