www.TallyERP9Help.Com

Excise Credit Note [Excise for Manufacturer] in Tally.ERP 9

In Release 4.7 of Tally.ERP 9, a new feature in Excise Credit Note has been provided for accounting Excisable Returned Goods, and to avail the corresponding CENVAT Credit.

A manufacturer registered under Central Excise, will raise an Excise Sales invoice (as per Rule 11) whenever Excisable Goods are removed from the premises or the place of manufacture.

In the normal course of business, customers (buyers) may return the goods because of any of the following reasons:

  • They were not as per their specifications

  • Due to inadequacy of space

  • Due to financial constraints

A manufacturer can avail CENVAT credit on the returned goods; track the return of finished goods and reflect their return in the appropriate Excise reports.

The Rule 16 Register has been provided to capture the details of returned goods and to track goods removed as such and goods that are sent for further processing (manufacturing).

As per the rule, though the goods returned are finished goods, for the limited purpose of availing CENVAT credit, they will be treated as raw material.

If the return is recorded as:

  • Scrap - no input credit can be availed on it. The amount equivalent to CENVAT will be accounted as expense

  • Usable quantity – on the quantity designated as usable, CENVAT credit can be claimed

To get started:

  • Create a new Voucher type  - Excise Credit Note

  • Record the return of goods with the Excise Credit Note

Sale of returned goods can be either:

o   When the returned goods are subjected to Process which does not amount to Manufacture and are Removed As Such

o   When the returned goods are subjected to Process which amounts to Manufacture

 Creating Excise Credit Note Voucher Type

·    To create Excise Credit Note Voucher type,

  1. Go to Gateway of Tally > Accounts Info > Voucher Type > Create

  2. Enter a suitable name for the Voucher type, for e.g., Excise Credit Note


[Img-275]

  1. Select Credit Note in the Type of Voucher field

  2. Set the option Use for Excise to Yes

  3. Select the Default Excise Unit

  4. Accept the Voucher type

Recording the Sales Return of Goods

To account for sales returns,

  1. Go to Gateway of Tally > Accounting Vouchers > Ctrl + F8: Credit Note > Select Excise Credit Note

  2. In the item invoice mode, enter the Date

  3. In the Ref: field; enter the original Sales Invoice number against which the goods have been returned.

Note: This field has been provided for the information to be captured in VAT Returns.

  1. Enter the invoice number and date in the Party Invoice No: and Date fields.

Note: Enter the Voucher number of the Excise Debit Note or any other equivalent document sent with the goods returned in the Party Invoice No: field. If the goods have been returned with the manufacturers’ own invoice, leave this field blank and enter the number in the Invoice Date field in the Item Allocation screen in step 10.

  1. Select Goods Sold Returned in the Used For: field


[Img-276]

  1. Select the Party Ledger in the Party’s A/c Name field

  2. Enter the Receipt, Order and Buyer Details if any

  3. In the Nature of Sales Return field, select the appropriate option.


[Img-277]

  1. Not Applicable: This option can be selected to record a normal or non-excise credit note.

  2. Export: If this option is selected, although there was no liability to pay duty when the goods were exported, duty will have to be paid while recording the return of the goods i.e. while importing the goods. It is necessary to pay Customs Duty, CVD and Additional duty of Imports. Details of CENVAT credit will reflect in row 4, table 8 of the ER 1 Excise Form.

  3. First Stage Dealer: If this option is selected, details of CENVAT credit will reflect in row 3, table 8 of the ER 1 Excise Form.

  4. Manufacturer: If this option is selected, details of CENVAT credit will reflect in row 2, table 8 of the ER 1 Excise Form.

  1. Select the Sales ledger and the applicable VAT/Tax class.

  2. Under Name of Items, select the stock item. The Item Allocation screen will be displayed. In this screen,

  3. Enter the date range within which the original invoice was recorded or leave the field blank, and press Enter to select the invoice from the list of invoices displayed.


[Img-278]

  • The selected original invoice details will be automatically captured in all the fields.


[Img-279]

Note: Pressing Enter without entering the date range will display a list of invoices from which the Original Sales Invoice can be selected.

 

Alternatively, press Ctrl + S or click S: Sales Reg to view the Voucher Register.

 


[Img-280]

 

To select the Voucher against which the goods have been returned, press the Spacebar to select it and press Alt + S or click S: Select.

 


[Img-281]

 

This will capture the details of the original Sales Invoice.

  • Enter the Reason for Rejection. This will be captured in the Rule 16 Register.

  • Enter the returned Quantity. The Rate and Amount will be displayed automatically. According to the state of goods, the number of goods which are usable out of the ones returned can be entered in the Usable Quantity field. The difference will be updated automatically in the Scrap field.


[Img-282]

Note: CENVAT Credit cannot be claimed for the quantity designated as Scrap.

  1. Select the CENVAT ledger predefined with the type of Duty as CENVAT. The Excise Duty Allocation sub-screen will be displayed.


[Img-283]

Note: In case where the duty entered in original invoice was 10% and the duty prevailing at the time of sales returns is 12%, the rate entered in original invoice will be considered here.

  1. The assessable amount, calculated based on the usable quantity and Rate of Duty will be displayed.


[Img-284]

  1. Select the CENVAT Ledgers predefined with the Type of Duty Education Cess. The Excise Duty Allocation sub-screen will be displayed. Press Enter in each field to return to the Voucher entry screen

  1. Select the CENVAT ledger predefined with the Type of Duty Head Secondary Education Cess. The Excise Duty Allocation sub-screen will be displayed. Press Enter in each field to return to the Voucher entry screen

  2. Press Y or Enter to accept the Excise Credit Note.


[Img-285]

Returned goods so recorded will be considered as raw material to avail CENVAT Credit and will not reflect in the Daily Stock Register. Hence the Rule 16 Invoice and RG 23 Part I report have been provided, in which these returned goods will be captured.


[Img-286]


[Img-287]

 

Sale of Goods Returned (No Manufacturing Process Involved) - Removed As Such

In the Excise Sales invoice,

  1. Select the party ledger in Party’s A/c Name field.

  2. Enter required details in the Party Details screen.

  3. Select Removal as Such in the Nature of Removal field as the goods are being sold without subjecting it to manufacturing process


[Img-288]

Note: It is necessary to select the Removal as Such flag to select the goods from the list of Credit Notes recorded for return of goods

  1. Select the Sales Ledger and the VAT/Tax classification

  2. After the Stock Item  is selected, the Item Allocation screen will be displayed

  3. From the list of credit notes displayed for selection choose the relevant Excise Credit Note

Note: Only if the Nature of Removal is chosen as Removal as Such and the stock item is a finished product, the list of credit notes will be displayed for selection.

  1. Based on the selection made, the credit note details will be displayed in the item allocation screen


[Img-289]

  1. Enter the quantity. The Rate and total amount will be automatically calculated and displayed.


[Img-290]

  1. Select the excise duty Ledger predefined with Type of Duty Excise and VAT Ledgers. Press Y or Enter to accept and save.


[Img-291]

  1. The quantity of goods so sold, will be captured in the Rule 11 Invoice and RG 23 part I report.

Sale of Goods Returned after Manufacturing or Re-processing

  1. Go to Gateway of Tally > Inventory Vouchers > F7: Stk Jrnl (Alt+F7) > Select Excise Manufacturing Journal

  2. Click F12: Configure and set the option – Track Excise Credit Note to Yes, to view the list of credit notes and select the required transaction


[Img-292]

  1. Under Source (Consumption) section, select the Stock Item. After selecting Stock Item, the Excise Credit Note Details sub-screen will be displayed. Select the appropriate Credit Note from this list. The quantity will be captured from the Credit Note. This can be changed according to the number of items that will be consumed for manufacture or re-processing.


[Img-293]

  1. Under Destination (Production) select the same stock item and select the Quantity


[Img-294]

  1. Accept the Excise Manufacturing Journal. After the goods undergo a manufacturing process, they will reflect in the Daily Stock Register.

  1. Proceed with sales.

 
 
 
 
Tally.ERP 9 Reference Manual LIBRARY
1.
Installation of Tally.ERP9
2.
Site Licensing of Tally.ERP9
3.
Shortcut Keys in Tally.ERP9
4.
Maintaining Company Data
5.
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
6.
Voucher Entry
7.
Reports in Tally.ERP9
8.
Excise for Dealer
9.
Excise for Manufacturer
10.
Reports [ Excise for Manufacturer]
11.
Excise for Importer
12.
Service Tax in Tally.ERP9
13.
Tax Collected at Source (TCS) in Tally.ERP9
14.
Tax Deducted at Source (TDS) in Tally.ERP9
15.
Value Added Tax (VAT) in Tally.ERP9
16.
Central Sales Tax (CST) in Tally.ERP9
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
Our Portal : www.TallyERP9Book.Com www.IncomeTaxManagement.Com www.Tally9Book.com www.TallyERP9Help.Com
Disclaimer :
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.
The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications