1. Localizations for India Implementation Guide
  2. India Reports for Excise Tax

India Reports for Excise Tax

These reports exist for India for excise tax:

Report ID and Report Name

Description

Navigation

Excise Manufacturer - Deferred CENVAT (R75I304)

Run this report to print tax-deferred information. This report also enables you to review the deferred tax amount.

This report reads from the Purchase Order Receiver File table (F43121) and the Purchase Order Receiver Tag table (F75I008).

Reports (G75IEXC7), Excise Manufacturer - Deferred CENVAT

Dealer - RG23D Register (R75I307)

Run this report to review information about the association between purchase receipts and sales orders. The system prints information for the item based on the branch/plant, location, lot number, and tax type.

This report reads from the Purchase Order Receiver Tag table (F75I008), Purchase Order Receiver File (F43121), and the RG23D Register - Issues (F75I385) tables.

RG23D (G75IEXC5H), Dealer - RG23D Register

Annexure 19 (R75I319)

Run this report to print the Annexure- 19 that you must submit to the Central Excise department.

This report reads from the Print ARE -1/ARE -3 Bond register table (F75I344Y).

Reports (G75IEXC7), Annexure 19

Record of Receipts of Inputs under Bond (R75I323)

Run this report to print information about the item receipts for 100 percent export-oriented units and ARE 3 receipts.

This report reads from the Purchase Order Receiver File (F43121), Purchase Order Receiver ARE3 Information (F75I323), and Purchase Order Receiver Tag File (F75I008) tables.

Excise daily processing (G75IEXC1H), Record of Receipts of Inputs under Bond

Print ARE1 Exception Report (R75I344)

Run this report to print the nonstatutory ARE 1 document.

This report reads from the Print ARE-1/ARE-3 Bond Register table (F75I344Y).

Reports (G75IEXC7), Print ARE1 Exception Report

Print ARE1 Bond/LOU Master (R75I344S)

Run this report to review the ARE 1 bond or LOU (letter of understanding) details for an excise unit.

This report reads from the Print ARE-1/ARE-3 Bond Register table (F75I344Y).

Reports (G75IEXC7), Print ARE1 Bond/LOU Master

Print ARE3 Exception Report (R75I345)

Run this report to print the nonstatutory ARE 3 document.

This report reads from the Excise - ARE3 Form Header table (F75I345).

Reports (G75IEXC7), Print ARE3 Exception Report

Print ARE3 CT2/CT3/Annexure (R75I345A)

Run this report to print a consolidated report for all CT2, CT3, or Annexure transactions for ARE 3.

This report reads from the Certificate Master table (F75I345Y).

Reports (G75IEXC7), Print ARE3 CT2/CT3/Annexure

Print Unclaimed CENVAT Report (R75I351S)

Run this report to print a list of purchase order records with unclaimed central value-added tax (CENVAT) for a specific period for the selected business units.

This report reads from the Purchase Order Receiver File (F43121) and Excise - Cross Reference File (F75I304) tables.

Reports (G75IEXC7), print Unclaimed CENVAT Report

Overdue Consignment (R75I352)

Run this report to review the consignments that are older than 180 days.

Note: Consignments older than 180 days are considered as a sale and are liable to tax.

This report reads from the Excise - Consignment/Adjustment Detail File - ItemWise table (F75I312).

Reports (G75IEXC7), Overdue Consignment

Print PLA Form (R75I383)

Run this report to print the Annexure 8 that you must submit to the Central Excise department. This report is a statutory requirement.

This report reads from the Excise - PLA Chapter Wise Transaction File for Yarn Industry (F75I315Y) and Excise - MODVAT / PLA Summary File YARN SPECIFIC (F75I310Y) tables.

Reports (G75IEXC7), Print PLA Form

Record Uncaptured RG-1 From Item Card (R75I387)

Run this report to print the RG1 records in the Item Ledger File table (F4111) that were not included during the RG1 build. This report also prints the reason for the omission of the records.

You must run the RG-1 Build report (R75I380) to upload the RG1 details to the Excise RG1 Transaction table (F75I380) before you run the Record Uncaptured RG-1 From Item Card report (R75I387).

This report reads from the Item Ledger File (F4111), Excise RG1 transaction File (F75I380), and Excise Cross Reference File (F75I304) tables.

Reports (G75IEXC7), Record not captured from RG-1 Item Card

Excise Return Master (R75I390)

Use this program to print any of these reports:

  • ER-1 (monthly)

  • ER-3 (quarterly)

  • ER-5 (annual)

  • ER-6 (monthly)

You set processing options to specify the report and the time period for the report.

This report reads from the Tax Registration Details table (F75I210).

Reports (G75IEXC7), Excise Return Master

Annexure 10 (R75I392)

Run this report to review the purchase order details for raw materials and capital goods.

This report reads from the Excise - MODVAT / PLA Summary (F75I310Y), Excise - RG23A-II Chapter Wise Transaction (F75I313Y), and Excise - RG23C-II Chapter Wise Transaction File (F75I317Y) tables.

Reports (G75IEXC7), Annexure 10

ER-5 (R75I395)

Run this report to print the details of the type and quantity of principal inputs used in the manufacture of the finished goods. This report is printed annually.

You run this report by setting a processing option and running the Excise Master Report program. Use the Batch Versions program to set the processing options for the ER-5 program before you print the report from the Excise Return Master program.

This report reads from the Bill of Material Master File (F3002), Item Cost File (F4105), Work Order Master File (F4801), Work Order Master Tag File (F4801T), Excise - Cross Reference File (F75I304), ER-5 (1) (F75I395A), ER-5 (2) (F75I395B), and ER-5 (temp) (F75I395T) tables.

Reports (G75IEXC7), Excise Return Master

ER-6 (R75I396)

Run this report to print the details of the principal inputs used in the manufacture of the finished goods and the quantity of goods manufactured. This report is printed monthly.

You run this report by setting a processing option and running the Excise Return Master program. Use the Batch Versions program to set the processing options for the ER-6 program before you print the report from the Excise Return Master program.

This report reads from the Bill of Material Master File (F3002), Work Order Parts List (F3111), Item Cost File (F4105), Item Ledger File (F4111), Work Order Master File (F4801), Work Order Master Tag File (F4801T), Excise - Cross Reference File (F75I304), ER-6 - List of Finished goods manufactured (F75I396A), ER-6 (F75I396B), and ER-6 Temp (F75I396T) tables.

Reports (G75IEXC7), Excise Return Master

Print 57F(4) Challan (R75I3906)

Run this report to print the details of raw materials sent to the supplier for processing.

This report reads the details from the Consignment Header table (F75I357), and reads and updates from the Work With Consignment - Ind - 43 table (F75I3901).

Subcontracting process (G75I57F4), Print 57F(4) Challan

Print 57F4 Register (R75I3907)

Run this report to print the material issued to and received from the processor with the consignment number.

This report reads the details from the Work With Consignment - Ind - 43 table (F75I3901).

Subcontracting process (G75I57F4), Print 57F4 Register

Print Sub Contract Challan (R75I3908)

Run this report to display the details of raw materials sent to the supplier for processing.

This report reads the details from the Purchase Order Detail File (F4311) and Consignment Header (F75I357) tables, and reads from and updates the Work With Consignment - Ind - 43 table (F75I3901).

Subcontracting process (G75I57F4), Print Sub Contract Challan