13 Working with the Excise ER1 and ER3 Reports

This chapter contains the following topics:

13.1 Understanding the ER-3 Report

You use the ER-3 program (R75I393) to file the quarterly return of production and removal of goods and other relevant particulars, within 20 days of the close of the quarter to which the return relates. The ER-3 report is quarterly, therefore, it includes the opening and closing balances for a particular item for a specific period. This is displayed in the report in a table format under Details of the Manufacture, Clearance, and Duty Payable in the 3a and 5a locations.


Note:

The JD Edwards EnterpriseOne system does not populate the following rows in the Details of CENVAT Credit Taken and Utilized section of the ER-3 report:
  • Credit utilised for payment of amount in terms of Rule 6 of CENVAT Credit Rules, 2004 (at serial number 11)

  • Credit utilised for other payment (at serial number 12)

You must manually enter data for these rows.


13.2 Entering Consignment Information for Large Taxpayers to Report in the ER-1 Report

This section provides an overview of consignment information for large taxpayers and discusses how to:

  • Set processing options for Work with Excise Reports (P75I390).

  • Enter consignment information for the ER1 report.

13.2.1 Understanding Consignment Information for Large Taxpayers

If you are a large taxpayer, you must submit additional consignment information in the ER1 report if you do not immediately pay duty on consignments when you send goods. You use the ER1 report to submit information about the production and removal of goods, and other relevant information, within ten days after the close of the month. You also include in the ER1 report information about when you received consignment goods back at your location.

You use the Excise Report Details program to enter information about the items that you send to another location for an additional manufacturing process and for which you have not paid duty, and those that you receive back from another location. Enter records for Section 4 for goods that you send. Enter records for Section 5 for goods that you receive.


Note:

You continue to submit the personal ledger account (PLA) and relevant TR6 challans along with the ER1 report.

13.2.1.1 Example of Records

Enter a record in the Excise Report Details program for the total of each item sent to each location. For example, suppose you sent these consignments in December:

  • 100 of item AA to excise unit A1 on December 3

  • 200 of item AA to excise unit A1 on December 20

  • 100 of item BB to excise unit A1 on December 20

  • 200 of item BB to excise unit B1 on December 22

In this example, you would enter a record for:

  • 300 of item AA for excise unit A1

  • 100 of item BB for excise unit A1

  • 200 of item BB for excise unit B1

Because you provide a total of each of the different items sent, you will generally enter the records when you know that all shipments have been sent. Likewise, you enter a total for each item that you received back from each location.

13.2.2 Forms Used to Enter Item Information for the ER1 Report

Form Name Form ID Navigation Usage
Excise Report Details W75I390A Excise Periodic Processing (G75IEXC2H), Excise Report Details. Review and select existing records.
Excise Reports Revision W75I390B On the Work With Excise Reports form, click Add. Enter a record for the total of each item received or sent to another location. Enter records for Section 4 for goods sent. Enter records for Section 5 for goods received.
Review Excise Reports W75I390C On the Work With Excise Reports form, select an existing record. Review the record information, including audit data such as when the record was created and the user ID of the person who created the record. You can modify certain data on the form.

13.2.3 Setting Processing Options for Excise Report Details (P75I390)

Use these processing options to specify the default values that the system displays in the Excise Report Details program.

13.2.3.1 Default

Excise Unit

Specify the address book number of the excise unit for which you want to display or add records.

Address Number

Specify the address number of the recipient or sender of the items for which you pay excise tax. If you enter 4 in the Section processing option, specify address book number of the location to which you ship the goods. If you enter 5 in the Section processing option, specify the address book number of the location that sends the goods to you.


Note:

The tax information for the address book record that you enter here must be set up in the Tax Registration Details program (P75I210).

Calendar Month

Enter the month in which you sent or received goods for which you need to report the additional item information.

Year - Model

Enter the year in which you sent or received goods for which you need to report the additional item information.

Section

Specify the section of the report for which you report additional item information. Values are:

4: Clearance Detail of inter-unit transfer of Intermediate goods section

5: Receipt Details of Intermediate goods received section

13.2.4 Entering Item Information for the ER-1 Report

Access the Excise Reports Revision form.

Section

Enter 4 if you want to enter information for the Clearance details of inter-unit transfer section. Enter 5 if you want to enter information for the Receipt details of intermediate goods section.

You must enter either 4 or 5; any other value causes the system to issue an error message.

The system prints information that you add to the section that you specify when you run the ER1 Report Print program (R75I391).

2nd Item Number

Enter the item number of the goods for which you enter data.

Chapter Number

Enter the chapter number for the item. The number that you enter must exist in the Chapter Number Set Up table (F75I016).

Excise Unit

Enter the excise unit for which you create the record. The excise unit must be set up in the JD Edwards EnterpriseOne Address Book system with a search type of EXU (excise unit).

Address number of the Recipient Unit

Specify the address book number of the recipient of the goods that you moved. The system displays this field if the value in the Section field is 4.

The tax information for the address book record that you enter here must be set up in the Tax Registration Details program (P75I210).

Address number of Sender Premises

Specify the address number of the location that sends items to you. The system displays this field if the value in the Section field is 5.


Note:

The tax information for the address book record that you enter here must be set up in the Tax Registration Details program (P75I210).

Month

Enter the month of the transaction. The month of the transaction and the month of the ER1 report should be the same.

Model Year

Enter the year of the transaction. The year of the transaction and the year of the ER1 report should be the same.

UM (unit of measure)

Enter the unit of measure for the item you are adding.

Trans QTY (quantity transferred)

Enter the quantity of the item shipped or received.

13.3 Generating the ER-1 Report

This section provides an overview of the ER-1 report, lists a prerequisite, and discusses how to:

  • Run the ER-1 Report Print program.

  • Set processing options for ER-1 Report Print (R75I391).

13.3.1 Understanding the ER-1 Report

You use the ER-1 Report Print program (R75I391) to print the details of the duty paid on excisable goods, CENVAT credit claimed, and interest payments for the business units. The ER-1 report is a monthly report. The statutory requirement requires every assessee to submit a monthly return of the production and removal of goods and other relevant particulars to the Superintendent of Central Excise within a particular period. As per the notification number 15/2008 of Central Excise, the government requires you to print opening stock at the start of the month in the ER 1 report.

The ER-1 Report Print program displays the opening and closing balances for a particular item for a specific period in the section Details of the Manufacture, Clearance and Duty Payable, in the 3a and 5a locations.

(Release 9.1 Update) The ER-1 Report Print program displays the opening balance, credit taken on imported input goods, and credit taken on imported capital goods for CVD, CVD Cess, and CVD HCess under Section 8 of the report. The system displays the CVD amounts by adding them to the corresponding balances under CENVAT column, CVD Cess amounts by adding them to the corresponding balances under the Cess on Excisable Goods column, and CVD HCess amounts by adding them to the corresponding balances under the Secondary and Higher Education Cess column under Section 8 of the report.


Note:

The JD Edwards EnterpriseOne system does not populate the following rows in the Details of CENVAT Credit Taken and Utilized section of the ER 1 report:
  • Credit utilised for payment of amount in terms of Rule 6 of CENVAT Credit Rules, 2004 (at serial number 13)

  • Credit utilised for other payment (at serial number 14)

You must manually enter data for these rows.


13.3.2 Running the ER-1 Report Print Program

Use one of these navigations:

  • Select Reports (G75IEXC7), ER-1 Report Print.

  • Select Reports (G75IEXC7), Excise Return Master.

    Before you run the Excise Return Master program (R75I390) to print the ER-1 report, you must set the processing options for the Excise Return Master program to include the ER-1 report, and set the processing options for the ER-1 Report Print program.

13.3.3 Setting Processing Options for ER-1 Report Print (R75I391)

Processing options enable you to specify default processing for programs and reports.

13.3.3.1 Defaults

Excise Unit

Specify the address number of the Excise unit.

Input Month

Specify the month for which the system processes excise return records.

Year

Specify the year for which the system processes excise return records.

Show Excise CESS and HCESS

Specify if the report shows excisable goods and taxable services for CESS and for HCESS separately or in the same column.

1: Summarizes CESS and HCESS values in the same column. In this case, the report displays two columns: CESS and HCESS on Excisable Goods, and CESS and HCESS taxable services.

Blank: the report displays excise CESS and HCESS in separate columns. In this case, the report displays four columns: Education CESS on Excisable Goods, Education CESS on taxable services, Secondary and Higher Education CESS on Excisable Goods, and Secondary and Higher Education CESS on taxable services.

13.3.3.2 Tax Type

1. Basic Excise Duty

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

2. Special Excise Duty

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

3. Additional Excise Duty

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

4. Education CESS on Excisable Goods

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

5. Secondary Higher Education CESS on Excisable goods

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

6. Service Tax

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

7. Education CESS on Service Tax

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

8. Secondary Higher Education CESS on Service Tax

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

9. Counter Vailing Duty

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

10. Counter Vailing Duty Cess

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

11. Counter Vailing Duty Hcess

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

13.3.3.3 Item Type

1. Raw Materials

Specify the code that you use as the item type for raw materials.

2. Capital Goods

Specify the code that you use as the item type for capital goods.

3. Personal Ledger Account

Specify the code that you use as the item type for the PLA.

13.4 Generating the ER-3 Report

This section provides an overview of the ER-3 report and discusses how to:

  • Run the ER-3 program.

  • Set processing options for ER-3 report (R75I393).

13.4.1 Understanding the ER-3 Report

You run the ER3 report to print the details about duty paid on excisable goods, CENVAT credit claimed, and interest payments for the business unit. You print this report quarterly. Some of the sections in this report are different from the sections in the ER1 report. The ER3 report reads from the Excise - RG-1 - Transaction File (F75I380), Tax Registration Details (F75I210), and Excise - MODVAT / PLA Summary (F75I310Y) tables.

(Release 9.1 Update) The ER-3 report displays the opening balance, credit taken on imported input goods, and credit taken on imported capital goods for CVD, CVD Cess, and CVD HCess under Section 6 of the report. The system displays the CVD amounts by adding them to the corresponding balances under CENVAT column, CVD Cess amounts by adding them to the corresponding balances under the Cess on Excisable Goods column, and CVD HCess amounts by adding them to the corresponding balances under the Secondary and Higher Education Cess column under Section 6 of the report.

13.4.2 Running the ER-3 Program

Use one of these navigations:

  • Select Reports (G75IEXC7), ER-3.

  • Select Reports (G75IEXC7), Excise Return Master.

Before you run the Excise Return Master report (R75I390) to print the ER3 report, you must set the processing options for the Excise Return Master program to include the ER3 report, and set the processing options for the ER3 report (R75I393).

13.4.3 Setting Processing Options for ER3 (R75I393)

Processing options enable you to specify default processing for programs and reports.

13.4.3.1 Defaults

Excise Unit

Specify the address number of the Excise unit.

Input Month

Specify a numerical value for the quarter. Values are:

1: April - June

2: July - September

3: October - December

4: January - March

Year

Specify the year for which the system processes excise return records.

Show Excise CESS and HCESS

Specify if the report shows excisable goods and taxable services for CESS and for HCESS separately or in the same column.

1: Summarizes CESS and HCESS values in the same column. In this case, the report displays two columns: CESS and HCESS on Excisable Goods, and CESS and HCESS taxable services.

Blank: the report displays excise CESS and HCESS in separate columns. In this case, the report displays four columns: Education CESS on Excisable Goods, Education CESS on taxable services, Secondary and Higher Education CESS on Excisable Goods, and Secondary and Higher Education CESS on taxable services.

13.4.3.2 Tax Type

1. Basic Excise Duty

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

2. Special Excise Duty

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

3. Additional Excise Duty

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

4. Education CESS on Excisable Goods

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

5. Secondary Higher Education CESS on Excisable goods

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

6. Service Tax

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

7. Education CESS on Service Tax

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

8. Secondary Higher Education CESS on Service Tax

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

9. Counter Vailing Duty

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

10. Counter Vailing Duty Cess

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

11. Counter Vailing Duty Hcess

Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.

13.4.3.3 Item Type

1. Raw Materials

Specify the code that you use as the item type for raw materials.

2. Capital Goods

Specify the code that you use as the item type for capital goods.

3. Personal Ledger Account

Specify the code that you use as the item type for the PLA.