Search for notes by fellow students, in your own course and all over the country.
Browse our notes for titles which look like what you need, you can preview any of the notes via a sample of the contents. After you're happy these are the notes you're after simply pop them into your shopping cart.
Title: Tally Book
Description: If you wants to Know all abut Tally ERP 9 its right place for you ...
Description: If you wants to Know all abut Tally ERP 9 its right place for you ...
Document Preview
Extracts from the notes are below, to see the PDF you'll receive please use the links above
Implementation of Excise for Dealers
in Tally
...
Because Tally must respond
to changing market conditions, it should not be interpreted to be a commitment on the part of Tally, and Tally cannot guarantee the
accuracy of any information presented after the date of publication
...
This document is for informational purposes only
...
Complying with all applicable copyright and other intellectual property laws is the responsibility of the user
...
, are vested exclusively with TALLY SOLUTIONS PRIVATE LIMITED
...
Ltd
...
Except as expressly provided in any written licence agreement from Tally, the furnishing of this document does not give you
any licence to these patents, trademarks, copyrights, or other intellectual property
...
Ltd
...
Tally, Tally 9, Tally9, Tally
...
ERP 9, Shoper, Shoper 9, Shoper POS, Shoper HO, Shoper 9 POS, Shoper 9 HO,
TallyDeveloper, Tally Developer, Tally
...
NET, Tally Development Environment, Tally Extender, Tally Integrator,
Tally Integrated Network, Tally Service Partner, TallyAcademy & Power of Simplicity are either registered trademarks or trademarks of
Tally Solutions Pvt
...
in India and/or other countries
...
Version: Implementation of Excise for Dealers in Tally
...
7/November 2012
Contents
Introduction
Basic Concepts in Excise Duty
...
1
Dealer of Excisable Goods
...
3
Second Stage Dealer
...
3
CENVAT Credit
...
5
Purchases from a Agent of Manufacturer
...
6
Purchases from First Stage Dealer
...
7
Salient Features of Dealer Excise Compliant Tally
...
8
Lesson 1: Enabling Dealer Excise in Tally
...
1 Enabling Excise in Tally
...
9
1
...
1 Create Company
...
1
...
10
1
...
3 Enable VAT
...
1 Sales and Purchase Ledgers
...
2 Duties & Taxes Ledger
...
3 Party Ledgers
...
4 Tariff Classification
...
5 Stock Items
...
6 Creating Excise Voucher Type
...
1 Accounting Excise Opening Stock
...
1 Purchase of Excisable Goods
...
1
...
1
...
1
...
1
...
1
...
1
...
51
Purchases from Agent of a Manufacturer (Consignment Agent)
...
61
Purchase from Manufacturer Depot
...
67
Purchase From Agent of Dealer
...
1
...
76
4
...
8 Purchases from Agent of Importer (Consignment Agent)
...
1
...
83
4
...
10 Selection of Same Item Multiple Times in Excise Purchase
...
2 Sale of Excisable Goods
...
2
...
94
4
...
2 Excise Invoice without Supplier Trader Information
...
2
...
103
4
...
4 Commercial Invoice
...
2
...
111
4
...
6 Sale of Goods Purchased From Agent of Manufacturer
...
2
...
117
4
...
8 Sales of Goods Purchased From Agent of Dealer
...
2
...
123
4
...
10 Sale of Goods Purchased from Agent of Importer (Consignment Agent)
...
2
...
129
4
...
12 Selection of Same Item Multiple Times in Excise Sales
...
3 Customs Clearance
...
3
...
136
4
...
2 Partial Clearance of Imported Goods
...
4 Conditional Pass on of Additional Duty (Imports)
...
5 Duty Charging on Excise Purchases and Sales
...
5
...
152
4
...
2 Charging Duty on Excise Sales
...
1 Sales Returns
...
2 Purchase Returns
...
1 Excise Stock Register
...
2 Excise Purchase Bill Register
...
3 Excise Stock CENVAT Register
...
3
...
173
6
...
2 Excise Stock CENVAT Register - One Item
...
4 Party Wise Duty Extract
...
5 Customs Clearance Register
...
6 Sales and Purchase Extract
...
7 Form RG 23D
...
8 Quarterly Return - Form 2
...
9 E-Returns
...
e, sale in India
...
It is basically an indirect tax on the manufacturer or producer which is passed on to the ultimate
consumer
...
The duty is
commonly referred to as the Basic Excise Duty
...
Basic Concepts in Excise Duty
The following are some of the basic terms related to Excise
...
The basic conditions to be satisfied are,
The goods must be movable
The goods must be marketable i
...
, saleable in the market as such goods
...
Any of the following categories would constitute a registered dealer
Depot of a manufacturer or the premises of the consignment agent of the manufacturer or
any other premises from where the goods are sold on behalf of the manufacturer
First stage dealer of excisable goods
Second stage dealer of excisable goods
Depot of an importer or the premises of the consignment agent of the importer
First stage dealer of imported goods
Second stage dealer of imported goods
Figure 1
...
Registration of Dealers
Every Dealer or Importer issuing CENVATable Invoices should be registered with the jurisdictional
Range Superintendent as per the procedure prescribed in Rule 9 of Central Excise (No
...
The registration is valid only for the premises it is granted
...
The registration numbers are PAN based 15 digit alpha numeric numbers
...
No
...
Central Excise Manufacturers
XM
2
...
, i
...
If there
are more than one factories / dealer's premises / warehouses of such a person holding common
PAN for all such premises, the last three character would be 002, 003 etc
...
Additional duty of Excise leviable under Additional Duties of Excise (Textile and Textile Articles) (AED [T and TA])
...
The National Calamity Contingent duty (NCCD) leviable under Finance Act
...
Additional Duty leviable under Customs Tariff Act
...
Eventually, the manufacturer or producer can utilize the CENVAT credit for payment of duty of
excise on any final product
...
4
Introduction
Purchases from Manufacturer
Figure 1
...
3 Chart showing Purchases from Agent of Manufacturer
Purchases from Importer
Figure 1
...
5 Chart showing Purchases from First Stage Dealer
Purchases from Second Stage Dealer
Figure 1
...
ERP 9
Following are the salient features of the excise module:
Simple and user-friendly
Easy to setup and use
Generates Excise Invoice raised by first and second stage registered dealers to pass on
CENVAT Credit
...
Provides option to print details of Manufacturer/ Supplier and all other relevant particulars
of the corresponding purchase invoice
...
Generates statutory returns and excise related reports as mandated, which are Form 2 and
Stock Register
...
Facilitates various Excise duty parameters like BED, AED (T and TA), AED (GSI), NCCD,
Education Cess and Additional Duty leviable under Customs Tariff Act
...
ERP 9
Tally
...
It minimises the possibility of erroneous data entry and ensures transparency and better levels of compliance with the
statutes
...
ERP 9 for Dealer Excise features to be activated
...
1 Enabling Excise in Tally
...
ERP 9 for Excise features to be activated
...
ERP 9 for a new company Steelage Industries (P)
Ltd
...
Create Company
2
...
Enable VAT
Steelage Industries (P) Ltd
...
1
...
1 Create Company
Go to Gateway of Tally > Alt + F3: Company Info
...
as the Company Name and Address details
Select India in the Statutory Compliance for field
Specify the State, Pin code & Accounts with Inventory details
Specify Financial Year From & Books beginning from date as 1-4-2012
9
Enabling Dealer Excise in Tally
...
Figure 1
...
1
...
2
...
4
...
Go to Gateway of Tally > F11: Features > F3: Statutory & Taxation
Set Enable Excise to Yes
Enable Set/Alter Excise Details to Yes
10
Enabling Dealer Excise in Tally
...
2 F3: Statutory & Taxation Features
Press Enter, to view Excise Registration Details screen
In the Excise Registration Details screen appears as shown
Figure 1
...
ERP 9
1
...
Address, Telephone No and PIN Code: Address, Telephone No
...
If required, it can be altered
...
Excise Details: Under this section provide Excise Details of the unit
...
Registration Type selected will be displayed below the heading - Excise Details to
identify the unit as a manufacturer or a dealer
...
If required, it can be altered
...
Excise Registration (ECC) No
...
g
...
g
...
g
...
To import or
export in India, IEC Code is mandatory
...
4
...
This will help in maintaining the sequence of Excise invoices raised by the dealer
...
12
Enabling Dealer Excise in Tally
...
4 Completed Serial Number Alteration Screen
5
...
Code:
Enter Range Code as 05
Name: Enter Range Name as Whitefield
Address: Enter the Range Address
Division: Enter the code Name and Address of the division under which your company is
registered
...
Code:
Enter Commissionerate Code as 09
Name: Enter Commissionerate Name as Bangalore II
Address: Enter the Commissionerate Address
13
Enabling Dealer Excise in Tally
...
5 Completed Excise Registration Details
6
...
1
...
Set the option Enable Value Added Tax (VAT) to Yes
2
...
Specify the Company VAT Details as shown:
Figure 1
...
ERP 9
4
...
7 Statutory & Taxation Screen
Press Enter to accept
15
Lesson 2: Creation of Masters
Once you have enabled Dealer Excise in Tally
...
Create the following masters in Tally
...
1 Sales and Purchase Ledgers
To create the following Purchases and Sales Ledgers:
Go to Gateway of Tally > Accounts Info
...
5%
Sales
Accounts
Yes
Yes
Sales @ 13
...
5%
Purchase
Accounts
Yes
Yes
Purchase @ 13
...
Create Sales Ledger
Go to Gateway of Tally > Accounts Info
...
2
...
4
...
Enter the name of the sales ledger in the Name field e
...
Sales @ 5%
Select Sales Accounts in the Under field
Set Inventory values are affected to Yes
Set Used in VAT Returns to Yes and press Enter to view VAT/Tax Class Screen
In VAT/Tax Class Screen select Sales @ 5% as VAT/Tax Class
The completed Sales @ 5% ledger is displayed as shown:
Figure 2
...
Press Enter to accept
...
17
Creation of Masters
2
...
> Ledgers > Create
1
...
3
...
5
...
g
...
Figure 2
...
Press Enter to accept
...
5%, Purchase @ 13
...
18
Creation of Masters
2
...
5%
@
Duties
& Taxes
VAT
Input VAT
Input VAT @ 13
...
5%
@
Duties
& Taxes
VAT
Output VAT
Output VAT@12
...
Create Input VAT Ledger
Go to Gateway of Tally > Accounts Info
...
2
...
4
...
6
...
Enter the name of the input VAT ledger in the Name field e
...
Input VAT @ 5%
Select Duties & Taxes in the Under field
In Type of Duty/Tax field select VAT from the List of Type of Duty/Tax
In VAT Sub Type field select Input VAT form the List of VAT Sub Types
In VAT/Tax Class field select Input VAT @ 5%
Set Inventory values are affected to No
Percentage of Calculation and Method of Calculation fields are updated based on the VAT/
Tax Class selected
8
...
Set the Rounding Limit to 1
19
Creation of Masters
The completed Input VAT @ 5% ledger is displayed as shown
...
3 Input VAT @ 5% Ledger Creation Screen
10
...
2
...
> Ledger > Create
1
...
3
...
5
...
7
...
g
...
In Rounding Method field select as Normal Rounding
9
...
4 Output VAT @ 5% Ledger creation
10
...
Similarly, create Input VAT @13
...
5%ledgers
...
In instances, where a particular VAT Class is not applicable, select Not Applicable to avail the flexibility to select the classifications while creating the
Invoice
...
The applicable VAT rate and the basis of calculation for the selected VAT class
will be displayed automatically and the cursor skips the Percentage of Calculation and Method of Calculation field
...
If you select Not Applicable in the Default VAT/Tax class field, the cursor
moves to the Percentage of Calculation field and the Method of Calculation
is manually selected
...
If you select CST in Type of Duty/Tax, you will be prompted to specify the rate
in Percentage of Calculation and the applicable Method of Calculation
...
3 Party Ledgers
Sundry Creditors Ledgers
Ledger
Under
Maintain
balances
bill- by-bill
Set/Alter
Excise
Details
Nature of Purchase
Sterling Steel Industries
Sundry Creditors
Yes
Yes
Manufacturer
Mega Manufacturer
Sundry Creditors
Yes
Yes
Manufacturer
Sterling Steel - Depot
Sundry Creditors
Yes
Yes
Manufacturer Depot
Globus Steel Traders
Sundry Creditors
Yes
Yes
Agent of Manufacturer (Consignment
Agent)
Indus Traders
Sundry Creditors
Yes
Yes
From Agent of Manufacturer
MM Iron & Steel
Sundry Creditors
Yes
Yes
First Stage Dealer
Indus Mega Traders
Sundry Creditors
Yes
Yes
From
Dealer
Excellor Impex (P) Ltd
...
Sundry Creditors Ledger
Go to Gateway of Tally > Accounts Info
...
Enter the name of the sundry creditor ledger in the Name field e
...
Sterling Steel Industries
2
...
4
...
6
...
8
...
5 Sundry Creditor Ledger Creation Screen
9
...
of the customer e
...
AFSDS0058FXD002
Enter the Date of Excise Registration in Date of Registration field e
...
20-June-2002
Enter the Exporter Importer Code if any
...
E
...
Yeshwanthpur I
Enter the Division under which the supplier's company is registered
...
g
...
E
...
Bangalore II
In Default Nature of Purchase field select the option Manufacturer from the nature of
purchase list (the default type of purchases depends upon the status of the supplier,
23
Creation of Masters
whether he is a Manufacturer / First Stage Dealer / Importer / Second Stage Dealer/Agent
of Manufacturer/Purchase from Importer
...
Figure 2
...
In such cases,
Tally
...
24
Creation of Masters
The Sterling Steel Industries Ledger creation screen is displayed as shown
...
7 Manufacturer Ledger Creation Screen
10
...
The Excise Details sub-screen appears for ledgers created under Sundry
Creditors and Sundry Debtors only
...
25
Creation of Masters
2
...
Accordingly, Central Excise Tariff Act 1985 classifies all the goods under 91
chapters and specific code is assigned to each item
...
First 4 digits represent Chapter and heading and next 2 digit represents
sub-heading and the last 2 digit represents sub-sub heading
...
> Tariff Classifications > Create
1
...
g
...
In Used For field select Excise from the list of Tax Type
The
Tariff Classification created with the option Both will be displayed for selection, during the creation of Stock Items on which Excise or VAT is applicable
...
The option VAT or Both will prompt the user to provide details of Schedule
Number and Schedule Serial Number
...
In HSN Code field enter the Tariff Classification Code e
...
72271000
The Harmonized Commodity Description and Coding System (HS) of tariff
nomenclature popularly known as Harmonised System of Nomenclature (HSN),
is an internationally standardized system of names and numbers for classifying
traded products developed and maintained by the World Customs Organization
4
...
26
Creation of Masters
The completed Tariff Classification creation screen appears as shown
Figure 2
...
Press Enter to accept
...
2
...
5%
Iron Bars
Kgs
Iron Bar
Yes
10%
5%
NA
5%
Copper Alloy
Strips
Kgs
Copper
Alloy Strip
Yes
NA
NA
12%
4%
27
Creation of Masters
1
...
> Stock Items > Create
1
...
3
...
Enter the Name of the stock item as Hot Rolled Coils 100mm
Specify the Group as Primary
...
Figure 2
...
Enable Set/Alter Excise Details to Yes and press Enter to view Excise Details screen
6
...
ERP 9 displays Steelage Industries (P) Ltd
...
In Tally
...
When the option Maintain Multiple Godowns/Excise Units is not
enabled in F11: Features > Inventory Features (F2) by default Tally
...
28
Creation of Masters
Reporting UOM: In this screen select the Reporting UOM applicable for the stock item
...
Reporting UOM defined for the stock item will be considered as Unit of Quantity
only for generating E-Returns
...
Set/Alter Duty Details: Set this field to Yes to view the Duty Details screen
...
10 Set/Alter Duty Details
In Duty Details screen
Select
Ad Valorem as the Valuation Type
Select
the Basic Excise Duty in the Type of Duty filed from the List of Excise Duty
classifications
Specify
the Applicable From date - 1-4-2012
Specify
the Rate of Duty as 12%
Method
of Calculation – Assessable Value will be defaulted automatically based on
the Type of Duty selected
...
Select
the Secondary Education Cess as the third duty in the Type of Duty filed from
the List of Excise Duty classifications
...
11 Excise Duty Details Screen
In cases, where Excisable commodity attracts Additional duties of Excise and
Special duties of Excise and so on, the same can be selected as required from the
List of Excise Duty Classifications
...
Accept the Excise Duty Details screen
8
...
In the Rate of VAT (%) field enter the VAT rate as 5%
30
Creation of Masters
The completed Stock item creation screen appears as shown
Figure 2
...
Press Enter to accept
...
2
...
> Stock Items > Create
1
...
3
...
5
...
Enter the Name of the stock item as Iron Bars
Specify the Group as Primary
Define the Units as Kgs
In the Tariff Classification field select Iron Bar from the List of Tariff Classifications
Enable Set/Alter Excise Details to Yes and press Enter to view Excise Details screen
In the Excise Details screen
Excise Unit Name: By default Tally
...
as Excise
Unit Name
...
Set/Alter Duty Details: Set this field to Yes to view the Duty Details screen
In Duty Details screen
Select
Ad Valorem as the Valuation Type
Select
the Basic Excise Duty in the Type of Duty filed from the List of Excise Duty
classifications
31
Creation of Masters
Specify
the Applicable From date - 1-4-2012
Specify
the Rate of Duty as 10%
Method
of Calculation – Assessable Value will be defaulted automatically based on
the Type of Duty selected
...
Select
the Secondary Education Cess as the third duty in the Type of Duty filed from
the List of Excise Duty classifications
...
13 Excise Duty Details Screen
7
...
In the Rate of VAT (%) field enter the VAT rate as 13
...
14 Completed Stock Item Creation Screen
9
...
3
...
> Stock Items > Create
1
...
3
...
Enter the Name of the stock item as Copper Alloy Strips
Specify the Group as Primary
Define the Units as Kgs
In the Tariff Classification field select Copper Alloy Strip from the List of Tariff Classifications
5
...
In the Excise Details screen
Excise Unit Name: By default Tally
...
as Excise
Unit Name
...
Set/Alter Duty Details: Set this field to Yes to view the Duty Details screen
In Duty Details screen
Select
Ad Valorem as the Valuation Type
Select
the Countervailing Duty (CVD) in the Type of Duty filed from the List of Excise
Duty classifications
Specify
the Applicable From date - 1-4-2012
Specify
the Rate of Duty as 12%
33
Creation of Masters
Method
of Calculation – Assessable Value will be defaulted automatically based on
the Type of Duty selected
...
Select
the Secondary Education Cess on CVD as the third duty in the Type of Duty
filed from the List of Excise Duty classifications
...
Specify
the Applicable From date - 1-4-2012
Specify
the Rate of Duty as 4%
Method
of Calculation – On Duty Value will be defaulted automatically based on the
Type of Duty selected
Figure 2
...
Accept the Excise Duty Details screen
8
...
5%
34
Creation of Masters
The completed Stock Item creation screen appears as shown:
Figure 2
...
Press Enter to accept
...
6 Creating Excise Voucher Type
Create the following Excise Voucher Types with the required specifications to record Excise transactions
...
-
-
Excise - Sales
Sales
Yes
Steelage Industries (P) Ltd
...
Tax Invoice
Commercial
Invoice
Ex-Purchase
Return
Debit
Note
Yes
Steelage Industries (P) Ltd
...
No
No
35
Creation of Masters
1
...
> Voucher Types > Create
In the Voucher Type Creation screen,
1
...
2
...
Type the Abbr
...
Select the Method of Voucher Numbering as Automatic
5
...
By default Use Common Narration is set to Yes
7
...
In Default Excise Unit field select Steelage Industries (P) Ltd
...
Figure 2
...
Press Enter to accept
...
Create Excise Sales Voucher Type Creation
In the Voucher Type Creation screen,
1
...
Select the Type of Voucher as Sales from the list of voucher types
3
...
as Ex-Sale
4
...
Set Use Advance Configuration to No
6
...
Set Use for Excise to Yes
8
...
from the List of Excise Units
9
...
Type the Default Print Title as EXCISE INVOICE
11
...
Specify the Declaration, if any
The completed Excise - Sales Voucher Type screen is displayed as shown
...
18 Excise Sales Voucher Type Creation screen
13
...
37
Creation of Masters
3
...
Type the name of the Voucher Type as Commercial Invoice
2
...
Select the Method of Voucher Numbering as Automatic
4
...
By default Use Common Narration is set to Yes
6
...
In Default Excise Unit field select Steelage Industries (P) Ltd
...
Set Print after saving Voucher to Yes
9
...
Set Is Tax Invoice to Yes
11
...
In the Name of Class field, type Commercial Invoice as the Voucher Class
Figure 2
...
Press Enter to view Voucher Type Class screen
14
...
Select End of List in the Exclude these Groups and Include these Groups fields
In Default Accounting Allocations for each Item in Invoice section,
Select
Sales @ 5% from the List of Ledger Accounts under Ledger Name field
Select
Sales @ 5% from the VAT/Tax Class in the VAT/Tax Class field
38
Creation of Masters
Specify
Set
100% in the Percentage field
Override Item Defaults to No
In Additional Accounting Entries to be added in Invoice section,
Select
Output VAT @ 5% from the List of Ledger Accounts in the Ledger Name field
Select
On VAT Rate in Type of Calculation field
Select
the Appropriate Rounding method
The completed Voucher Type Class screen is displayed as shown
...
20 Completed Voucher Type Class Screen
15
...
Figure 2
...
Press Enter to accept
...
39
Lesson 3: Dealer Excise Opening Stock
3
...
e
...
,
Supplier Invoice with date and number
...
Total quantity & value of goods purchased
...
Amount of Excise Duty paid
...
Name of the jurisdictional range / division / commissionerate
...
For this purpose, it is essential to record the above mentioned information in Tally
...
Consider the following example to illustrate the treatment of CENVAT, available on opening stock
of excisable goods
...
Steelage
Industries (P) Ltd
...
Purchased
Rate
Description
(MT)
(Rs
...
& Date
(MT)
2,00,000
155
487 dt
...
No
...
Excise Opening Stock:
Go to Gateway of Tally > Inventory Info
...
> Dealer Excise Opening
Stock
1
...
3
...
In the Supplier Invoice No
...
is displayed as default
In Party’s A/c Name field select Sterling Steel Industries
The Supplier’s Details screen is displayed as shown
...
41
Dealer Excise Opening Stock
Figure 3
...
Accept the Supplier’s Details screen
6
...
Figure 3
...
In the Purchase Ledger field select Purchases @ 5%
8
...
Enter the Purchase Quantity in the field Quantity, i
...
quantity purchased from the supplier
10
...
Amount is calculated and displayed automatically
42
Dealer Excise Opening Stock
Figure 3
...
Press Enter to view Excise Details screen
13
...
field enter the entry number in RG 23D register of the Excise Dealer
...
as 487 (If the Invoice No
...
of the supplier
...
Specify 155 MT as the Excise Opening Stock (the balance unsold stock lying in the
godown as on 31st March)
Press Enter to accept the Assessable Value as Rs
...
500)
The Stock Item Excise details screen is displayed as shown
...
4 Excise Details screen
43
Dealer Excise Opening Stock
The Excise Duty and Education cess amounts are automatically calculated on the basis of configurations defined in the stock item master
...
ERP 9 provides the flexibility to modify the amount of tax
...
The completed Excise Opening Stock voucher is displayed as shown:
Figure 3
...
Press Enter to save
...
Dealer Excise Opening Stock option will be displayed under Excise info
...
ii
...
But, if the books beginning from date is different from the
financial year in the Company master, then, the books beginning from date is
taken as the voucher date
...
ERP 9, by pressing Alt+F2
...
The Excise Opening Stock Voucher is a type of optional voucher and thus will
not affect your books of accounts
...
However, the entries passed under Excise
Opening Stock voucher type will appear in Day Book display
...
In cases where the user maintains data for multiple periods in Tally
...
However, in
cases where the Company’s data is split, the excise opening balances have to
be re-entered with the respective excise details in the Excise Opening Stock
menu
...
The unsold stock of non-excisable stock need not be entered through this
menu
...
Decora Equipments,
Bangalore
Item Description
Qty
...
)
VAT
Hot Rolled Coils 100mm
100
600
5%
The same is accounted for as shown:
Step 1: Create Sales Invoice
Go to Gateway of Tally > Accounting Vouchers > Press F8: Sales
1
...
3
...
In Voucher Type sub screen select Excise–Sales from the List of Types
Press F2 and change date to 03-04-2012
Excise Unit field defaults Steelage Industries (P) Ltd
...
5
...
field displays the Rule 11 invoice Number e
...
SAI\1\12-13
...
In the Party’s A/c Name field select Decora Equipments
7
...
In the Sales Ledger field select Sales @ 5%, in the VAT/Tax Class field Sales @ 5% gets
defaulted
...
Select Hot Rolled Coils 100mm in the Name of the Item field and press Enter to view Supplier Details screen
10
...
6 Suppliers Details Screen
Specify the Quantity Utilised as 100 MT
The Supplier Details screen is displayed as shown
...
7 Supplier Details screen with Quantity
46
Dealer Excise Opening Stock
Select End of List and press Enter to accept the screen
After accounting the excise opening stock through Dealer Excise Opening Stock,
opening stock details have to be updated in Stock Item Master separately
...
To view the statutory details of the transaction set Show Statutory Details to Yes
In the Bill-wise Details screen accept the default bill allocation
...
Figure 3
...
Figure 3
...
Figure 3
...
Figure 3
...
Now, let
us consider the following illustrations to understand, how CENVAT credit is passed to the subsequent dealers
...
1 Purchase of Excisable Goods
Now, let us consider the following scenarios to illustrate Excise Purchase transactions in
Tally
...
1
...
Sterling Steel
Industries (Manufacturer) vide B
...
457
...
Step 1: Setup
In F12: Configure (Purchase Invoice Configure)
Set
the option Use Common Ledger A/c for Item Allocation to Yes
...
1 Purchase Invoice Configuration
51
Transactions
Step 2: Create Purchase Invoice
Go to Gateway of Tally > Accounting Vouchers > F9:Purchase
1
...
3
...
In Voucher Type subscreen select Excise–Purchases from the List of Types
Press F2 and change date to 05-04-2012
Enter 457 in the Supplier Invoice No
...
as selected during voucher Type creation
...
Select Sterling Steel Industries in Party’s A/c Name field
6
...
2 Supplier's Details Sub-screen
Press Enter to accept the screen
7
...
However, you can modify the same depending upon the
nature of purchase
...
3 Excise Purchase Voucher - Nature of Purchase selection
8
...
9
...
Type the Quantity as 400
11
...
12
...
4 Excise Details
53
Transactions
The Basic Excise Duty and Cess amount is automatically calculated on the
Assessable Value (computed based on the Quantity and Rate entered in the
Voucher Creation screen)
...
In such
cases, the Assessable Value is required to be specified as Purchase Cost before
Excise Duty and Cess Amount
...
field (The RG 23D Entry No
...
as 457 and Supplier Invoice Date as 05-04-2012 (The
Supplier Invoice No
...
field (This field represents the display of this particular transaction in the relevant page of RG 23 D Register of the supplier)
Type the Assessable Value as Rs
...
e, 400MT X Rs
...
Figure 4
...
However, in some cases though the excise duty is chargeable at a specified rate, the net burden
on the buyer may be less than the prescribed percentage, in such cases Tally
...
54
Transactions
13
...
14
...
15
...
16
...
17
...
field (The RG 23D Entry No
...
Press Enter to accept the Supplier Invoice No
...
Specify 568 in the PLA/ RG 23D Entry No
...
Type the Assessable Value as 2,70,000 and press Enter
...
Cess Amount is automatically calculated and prefilled
...
6 Completed Excise Details Screen
18
...
26, 405 is defaulted automatically
...
Set Show Statutory Details to Yes to view Statutory Details of the transaction
...
7 Statutory Details Screen
20
...
Enter 457 in the Name field
...
Accept the default Amount allocation and Dr/Cr,
The Bill-wise Details screen is displayed as shown:
Figure 4
...
21
...
56
Transactions
The completed Excise Purchase Invoice is displayed as shown:
Figure 4
...
Press Enter to accept
...
e
...
Under Exclusive method, Excise Duty, Education Cess,
Higher Education Cess & other duties of excise ledgers are created and itemised separately in the Purchase Invoice and as a result the excise amount paid
is available separately in the respective ledgers
...
Whereas, in case of Inclusive method, the
Gross Amount before sales tax is back calculated as the Assessable Value is
determined accordingly
...
e
...
The
applicable Duties of Excise and Cess are calculated in the Excise Details
for subscreen based on the Stock Item predefinition for the purpose of declaration in the Excise Invoice
...
1
...
In this
case Excise Dealer who buys the goods from first consignment agent will be assumed to be
acting as a Agent of Manufacturer (Consignment Agent)
...
Universal Traders sells the goods to Steelage Industries and raises the sales invoice
by marking the Steelage Industries as “Consignment Agent of Principal Manufacturer”
...
Tally
...
Globus Steel
Traders (Agent of Manufacturer) vide B
...
764
...
5%
Invoice
Amount
Engine
Valves 5”
500
600
3,00,000
36,000
720
360
3,37,080
45,506
3,82,586
Go to Gateway of Tally > Accounting Vouchers > F9:Purchase
1
...
3
...
In Voucher Type subscreen select Excise–Purchases from the List of Types
Press F2 and change date to 06-04-2012
Enter 764 in the Supplier Invoice No
...
as selected during voucher Type creation
5
...
The Supplier’s details screen is displayed
Supplier Details are defaulted automatically
Under Manufacturer / Importer Details section
In the Name field select the Manufacturer / Importer from the List of Ledger Accounts
In the Supplier’s Details by using Alt+M key or by clicking on the M: Manual button
in the buttons bar, Manufacturer /Importer details can be entered manually or you
can select the Manufacturer ledger from the List of Ledger Accounts if the Manufacturer ledger is created and available
...
10 Supplier’s Details Screen
Accept the Supplier’s Details screen
7
...
8
...
5% in the Purchase Ledger field, the VAT/Tax Class – Purchases
@ 13
...
Select Engine Valves 5” in the Name of Item field
10
...
Specify the Amount as 3,37,080 and press Enter
12
...
field (The RG 23D Entry No
...
as 764 and Supplier Invoice date as 06-04-2012 is
defaulted from the voucher screen
Specify the RG 23D Entry No
...
3,00,000 in the Assessable Value field (It is the amount on which the Excise
Duty is calculated by the manufacturer)
Under Manufacturer / Importer Invoice Details section
In
Name field select the Manufacturer of the Goods being sold by the Consignment
Agent
...
59
Transactions
In
Invoice Number field mention the invoice number of the Manufacturer under which
the stock item was purchased (by the supplier)
The invoice date field mention the manufacturers sales invoice number
Specify the PLA/RG 23D Entry No
...
Figure 4
...
Accept the Excise Details screen
...
Select Input VAT @ 13
...
45,506 is automatically calculated
and prefilled
15
...
In the Bill-wise Details screen,
Specify the Type of Ref as New Ref
Enter 764 in the Name field
Accept the default Amount allocation and Dr/Cr details
...
Enter the transaction details in the Narration field
...
12 Completed Excise Purchase Invoice
18
...
4
...
3 Purchase From Agent of Manufacturer
From Agent of Manufacturer is a supplier who acts as a commission agent of the manufacturer
...
Tally
...
Example 3:
On 7th April 2012, Steelage Industries purchased the following goods from Indus Traders (Commission Agent) vide B
...
8695
...
Cess
@ 1%
Hot
Rolled
Coils - 100mm
1000
800
800000
96000
1920
960
Total
898880
VAT
Rate
5%
VAT
Amount
Invoice
Amount
44944
9,43,824
61
Transactions
Go to Gateway of Tally > Accounting Vouchers > F9: Purchase
1
...
3
...
5
...
Select Alt + I: Item Invoice if it is in Acct Invoice mode
...
Enter the Supplier Invoice No
...
By default Tally
...
as defined
during voucher type creation
...
Select the Party’s A/c Name from the list of Ledger Accounts e
...
Indus Traders
...
The Supplier’s Details sub-form will appear
...
The details will appear
automatically if they are provided during the Supplier Ledger Creation
...
For this purchase Indus traders is not the manufacturer
...
Specify the details of the manufacturer
...
13 Supplier’s Details
8
...
This field defines the Supplier’s role in selling the product
...
14 Selection of Nature of Purchase
62
Transactions
9
...
VAT/Tax
Class will be defaulted to Purchases @ 5%
10
...
In Quantity field enter 1,000 and enter Rs
...
Press Enter to view
Excise Details screen
12
...
field if entered
...
field enter the PLA number where the reference of duty paid on
the goods sold are entered
...
Enter Rs
...
Figure 4
...
Select Input VAT ledger - Input VAT @ 5% to account the VAT amount
...
16 Completed Purchase Voucher
14
...
4
...
4 Purchase from Manufacturer Depot
Manufacturer Depot is a supplier registered under excise and for all the sales made depot issues
the rule 11 invoice
...
ERP 9 allows to record the excise purchases made from a manufacturer depot and pass on
the CENVAT Credit on Sale of Goods
...
No
...
Item Description
Hot
Rolled
Coils 100mm
Qty
500
Rate
Assess
able
Value
BED @
12%
Educ
Cess
@
2%
Higher
Educ
...
2
...
4
...
Select the Excise - Purchase as the Voucher Type from the list of types
...
Press F2 and enter the date as 9-4-2012
...
as 321 and Date as 9-4-2012
...
ERP 9 displays the Excise Unit as Steelage Industries (P) Ltd
...
6
...
g
...
7
...
Supplier’s Details will include the supplier contact details, Sales Tax Number and the Excise Registration details
...
If the supplier of the
goods is not the manufacturer, specify the details of the manufacturer of the goods in the
Manufacturer / Importer details section
...
Manufacturer is Sterling Steel
industries
...
Figure 4
...
By default the Nature of Purchase will be displayed as Manufacturer Depot as defined in the
party ledger
...
9
...
VAT/Tax
Class will be defaulted to Purchases @ 5%
10
...
In Quantity field enter 500 and in Amount field enter Rs
...
Press Enter to view
Excise Details screen
...
In Excise Details screen
65
Transactions
Under Supplier Invoice Details section,
In
RG 23D Entry No
...
field if
entered
...
field enter the PLA number where the reference of duty paid
on the goods sold are entered
...
Enter Rs
...
Select Sterling Steel Industries from the List of Ledger Accounts
...
In Invoice Number field mention the invoice number of the Manufacturer under which
the stock item was supplied to the Depot)
The invoice date field mention the manufacturers sales invoice number
Specify the PLA/RG 23D Entry No
...
In Assessable Value enter the actual Assessable Value of the stock item
...
Figure 4
...
Select Input VAT ledger - Input VAT @ 5% to account the VAT amount
...
19 Completed Purchase Voucher
Press Enter to accept
...
1
...
MM Iron & Steel,
vide B
...
1707
...
Cess
@ 1%
Total
VAT
Rate
–
288
7500
450
VAT
Amount
Invoice
Amount
144
134832
13
...
2
...
4
...
In Voucher Type subscreen select Excise–Purchases from the List of Types
Press F2 and change date to 10-04-2012
Enter 1707 in the Supplier Invoice No
...
The Manufacturer / Importer details are prefilled automatically
from the ledger master
...
20 Supplier’s Details Screen
Accept the Supplier’s Details screen
...
In the Nature of Purchase field First Stage Dealer is defaulted automatically as defined in the
ledger master
...
Select Engine Valves 5” in the Name of Item field
8
...
Specify the Amount as 1,34,832 and press Enter to view Excise Details screen
10
...
field
Under Supplier Invoice Details section
The
Supplier Invoice No
...
(This field represents the relevant page of RG 23 D Register of the supplier, where the information on this stock item is available)
Enter Rs
...
In Invoice Number field mention the invoice number of the Manufacturer under which
the stock item was purchased (by the supplier)
The Invoice Date field mention the manufacturers sales invoice number
Specify the PLA/RG 23D Entry No
...
In Assessable Value enter the actual Assessable Value of the stock item
Duty Details displays the Duty Amount of both the First Stage Dealer and Manufacturer/
Importer
...
21 Excise Details Screen
The Excise Duty, Education Cess and Secondary Education Cess amounts are automatically
calculated and prefilled
Accept
the Excise Details screen
69
Transactions
In Accounting Details screen, select Purchase @ 13
...
5%
...
22 Accounting Details Screen
11
...
Specify the Quantity as 300 & the Amount as 1,73,175 and press enter to view Excise
Details screen
13
...
field
Under Supplier Invoice Details section
The
Supplier Invoice No
...
(This field represents the relevant page of RG 23 D Register of the supplier, where the information on this stock item is available)
Enter Rs
...
In Invoice Number field mention the invoice number of the Manufacturer under which
the stock item was purchased (by the supplier)
The Invoice Date field mention the manufacturers sales invoice number
70
Transactions
Specify
the PLA/RG 23D Entry No
...
In Assessable Value enter the actual Assessable Value of the stock item
Duty Details displays the Duty Amount of both the First Stage Dealer and Manufacturer/
Importer
...
23 Excise Details Screen for Iron Bar
The
Excise Duty, Education Cess and Additional Education Cess amounts are
automatically calculated and prefilled
Accept the Excise Details screen
14
...
Select Input VAT @ 13
...
Select Input VAT @ 5% ledger and press Enter, the VAT amount is calculated and displayed
automatically
17
...
In the Bill-wise Details screen accept the default bill allocation
...
Enter the transaction details in Narration field
71
Transactions
The completed Excise Purchase Invoice is displayed as shown
...
24 Completed Purchase Voucher - First Stage Dealer
20
...
4
...
6 Purchase From Agent of Dealer
From Agent of Dealer is a supplier who acts as a commission agent of the First Stage Dealer
...
Tally
...
Example 6:
On 11th April 2012, Steelage Industries purchased the following goods from Indus Mega Traders
vide B
...
6254
...
Cess
@ 1%
950
190000
12800
456
228
Total
203484
VAT
Rate
5%
VAT
Amount
Invoice
Amount
10174
2,13,658
72
Transactions
Go to Gateway of Tally > Accounting Vouchers > F9: Purchase
Setup:
In F12: Configure (Purchase Invoice Configuration)
Enable the option Allow Separate Buyer and Consignee Names to Yes
Figure 4
...
2
...
4
...
Select the Excise - Purchase as the Voucher Type from the list of types
...
as 6254 and Date as 11-4-2012
By default, Tally
...
as defined
during voucher type creation
...
Select the Party’s A/c Name from the List of Ledger Accounts e
...
Indus Mega Traders
7
...
73
Transactions
Enter the Dealer Name in Consignee field and enter other details like address, TIN/Sales
Tax No
...
In Supplier field the name of the agent of the Dealer will be displayed along with address
and other related information
...
For this purchase Inland Traders are not the manufacturer
...
Specify the details of the manufacturer
Figure 4
...
By default the Nature of Purchase will be displayed as From Agent of Dealer as defined in
the party ledger
...
9
...
VAT/Tax
Class will be defaulted to Purchases @ 5%
10
...
In Quantity field enter 200 and enter Rs
...
Press Enter to view
Excise Details screen
12
...
field enter the RG 23D entry number of this purchase in your books
...
field if
entered
...
field enter the PLA number where the reference of duty paid
on the goods sold are entered
...
Enter Rs
...
In Invoice no
...
In PLA/RG 23 Entry No
...
27 Excise Details Screen
13
...
28 Completed Purchase Voucher
14
...
4
...
7 Purchases from Importer
While carrying on business a excise dealer may purchase the goods from different type of
suppliers including Importer (one who imported the goods)
...
ERP 9 allows to account the
Purchases form Importer
...
vide B
...
9254
...
Cess
on
CVD
@ 1%
Addi
tion
al
Duty
Total
VAT
Rate
Copper
Alloy
Strips
300
500
150000
18,000
360
180
7200
175740
13
...
2
...
4
...
Select the Excise - Purchase as the Voucher Type from the list of types
...
as 9254 and Date as 11-4-2012
By Default Tally
...
6
...
g
...
7
...
Supplier’s Details will include the supplier contact details, Sales Tax number and the Excise registration details
...
If the supplier of the
goods is not the importer, specify the details of the importer of the goods in the Manufacturer
/ Importer details section
...
By default the Nature of Purchase will be displayed as Purchase from Importer as defined in
the party ledger
...
Figure 4
...
In Purchase Ledger field select Purchases @ 13
...
VAT/
Tax Class will be defaulted to Purchases @ 13
...
10
...
11
...
Press Enter to view Excise Details
screen
...
In Excise Details screen
In RG 23D Entry No field enter the RG 23D entry number of this purchase in your books
...
field if
entered
...
field enter the PLA number where the reference of duty paid
on the goods sold are entered
...
Enter Rs
...
Manufacturer/Importer Invoice Details: In this section specify the Importer Invoice
Details
When the Nature of Purchase - Purchase From Importer is selected in Excise
Details screen Tally
...
Separate Supplier & importer invoice details section will be useful when the sales
are made by the agent of the Importer where we need to enter the invoice details of
Two parties (Importer & Agent of Importer)
...
is the Importer & Supplier of goods to
Steelage Industries (P) Ltd
...
Countervailing
Duty, Education Cess on CVD & Secondary Education Cess on
CVD will be calculated & displayed automatically
...
7200
...
30 Excise Details Screen
13
...
5% to account the VAT amount
...
31 Completed Purchase Voucher
14
...
4
...
8 Purchases from Agent of Importer (Consignment Agent)
If a Registered Excise Dealer receives (Purchases) goods from Consignment Agent where, the
consignment agent has raised the sales bill marking as Consignment Sales Invoice
...
Example: Ziga Traders is an Agent of Importer (Consignment Agent) of Excellor Impex (P)
Ltd
...
Agent of Importer (Consignment Agent) will be registered under excise and issues Rule 11
invoice for the sales made by printing the Title as - Sale by Consignment Agent
...
ERP 9 allows you to account the transactions where the dealer is acting as the Agent of
Importer & Print Rule 11 invoice with the title - Sale by Consignment Agent
...
No
...
Item
Descrip
tion
Qty
Rate
Assess
able
Value
CVD
@ 12%
Educ
Cess
on
CVD
@
2%
Higher
Educ
...
5 %
VAT
Amount
Invoice
Amount
11866
99,736
Go to Gateway of Tally > Accounting Vouchers > F9: Purchase
1
...
3
...
5
...
Select Alt + I: Item Invoice if it is in Acct Invoice mode
Press F2 and enter the date as 12-4-2012
Enter Supplier Invoice No
...
ERP 9 displays Excise Unit as Steelage Industries (P) Ltd as defined during
voucher type creation
...
Select Party’s A/c Name from the list of Ledger Accounts e
...
Ziga Traders
7
...
Supplier’s Details will include supplier contact
details, Sales Tax number and Excise registration details
...
If the supplier of the goods is not the
Importer, specify the details of Importer in Manufacturer / Importer Details section
...
Importer is Excellor Impex (P) Ltd
...
Figure 4
...
By default the Nature of Purchase will be displayed as Agent of Importer (Consignment
Agent) as defined in the party ledger
...
Figure 4
...
In Purchase Ledger field select Purchases @ 13
...
VAT/Tax
Class will be defaulted to Purchases @ 13
...
In Name of Item field select Copper Alloy Strips form List of Excise Stock Items
11
...
Press Enter to view Excise Details
screen
12
...
field if
entered
...
field enter the PLA number where the reference of duty paid
on the goods sold are entered
...
Enter Rs
...
Manufacturer/Importer Invoice Details: Under this section specify manufacturer or
importer invoice details
In
Name field select the Importer from the List of Ledger Accounts
...
This number
represents the transaction details of sales made to the supplier in the relevant page of
PLA Register of manufacturer
...
For Special AED of CVD specify the
additional Duty Amount - Rs
...
Figure 4
...
Select Input VAT ledger - Input VAT @ 13
...
The completed purchase voucher is displayed as shown:
Figure 4
...
Press Enter to accept
...
1
...
On sales
made, this suppliers issues only a commercial invoice and Rule 11 invoice is issued by the
Importer
...
No
...
Item
Descrip
tion
Qty
Rate
Assess
able
Value
CVD
@ 12%
Educ
Cess
on
CVD
@
2%
Higher
Educ
...
5 %
VAT
Amount
Invoice
Amount
3954
33,244
Go to Gateway of Tally > Accounting Vouchers > F9: Purchase
1
...
3
...
5
...
Select Alt + I: Item Invoice if it is in Acct Invoice mode
Press F2 and enter the date as 13-4-2012
Enter Supplier Invoice No
...
ERP 9 displays Excise Unit as Steelage Industries (P) Ltd as defined during
voucher type creation
...
Select Party’s A/c Name from the list of Ledger Accounts e
...
Alpine Traders
7
...
Supplier’s Details will include supplier contact
details, Sales Tax number and Excise registration details
...
If the supplier of the goods is not the
Importer, specify the details of Importer in Manufacturer / Importer Details section
...
Importer is Excellor Impex (P) Ltd
...
Figure 4
...
By default the Nature of Purchase will be displayed as From Agent of Importer as defined in
the party ledger
...
Figure 4
...
In Purchase Ledger field select Purchases @ 13
...
VAT/Tax
Class will be defaulted to Purchases @ 13
...
In Name of Item field select Copper Alloy Strips form List of Excise Stock Items
11
...
Press Enter to view Excise Details screen
12
...
field if
entered
...
field enter the PLA number where the reference of duty paid
on the goods sold are entered
...
Enter Rs
...
Manufacturer/Importer Invoice Details: Under this section specify manufacturer or
importer invoice details
In
Name field select the Importer from the List of Ledger Accounts
...
This number
represents the transaction details of sales made to the supplier in the relevant page of
PLA Register of manufacturer
...
For Additional Duty (Imports) specify the additional Duty Amount - Rs
...
Figure 4
...
Select Input VAT ledger - Input VAT @ 13
...
85
Transactions
The completed purchase voucher is displayed as shown:
Figure 4
...
4
...
10 Selection of Same Item Multiple Times in Excise Purchase
In Dealer Excise Purchase Invoice you can select the same item multiple times
...
ERP 9
allows the user to select the items with different assessable value, different rate of Duty and
even the stock items purchased against different invoices (from manufacturer)
...
9682
Stock Item
Qty
Purchase
Cost
Assessable Value
Rate of
duty%
Manufacturers Invoice against
which the Stock Item is Purchased
Hot Rolled Coils 100mm
1000
1500000
1200000
12
SI/758/11-12, dated 25-3-2012
Hot Rolled Coils 100mm
500
800000
650000
10
SI/968/11-12, dated 30-4-2011
Hot Rolled Coils 100mm
750
1350000
1100000
12
SI/1052/11-12, dated 5-3-2012
Record the Transaction in Excise Purchase Invoice
Go to Gateway of Tally > Accounting Vouchers > F9: Purchase
1
...
86
Transactions
2
...
Enter the Supplier Invoice No
...
By default Tally
...
as defined
during voucher type creation
...
Select the Party’s A/c Name from the list of Ledger Accounts e
...
MM Iron & Steel
6
...
The details will appear automatically if they are provided during the Supplier Ledger Creation
...
Figure 4
...
7
...
This field defines the Supplier’s role in selling the product
...
g
...
Select the Purchase Ledger from the list of ledger accounts
...
g
...
VAT/Tax
Class will be defaulted based on the tax class selected in the ledger
...
Select the Stock Item e
...
Hot Rolled Coils 100mm from the List of Excise Stock Items
10
...
In the Amount filed enter the purchase Cost of Rs
...
In the Excise Details screen
87
Transactions
In RG 23D Entry No
...
E
...
11
In Supplier Invoice Details section
Supplier
Invoice No: by default displays the Invoice No
...
field in the voucher entry screen
...
Supplier Invoice Date: by default displays the voucher date
...
as 4561
...
Enter the Assessable Value – Rs
...
The amount specified in this amount should the amount on which the Excise
Duty is calculated by the manufacturer
...
Invoice Number: Specify the manufacturers Invoice Number as SI/758/11-12
Invoice Date: Specify the manufacturers invoice date as 25-3-2012
RG 23 D Entry No: Enter the RG 23 Entry Number of the Manufacturer 554
Billed Quantity: Enter the actual Billed Quantity sold to the First Stage Dealer
Assessable Value: Enter the actual Assessable Value i
...
12,00,000 of the stock item
Duty Details: Duty Details displays the Duty Amount calculated for, First stage Dealer and
Manufacturer/Importer
...
41 Excise Details Screen
13
...
Enter 500 in Quantity field and Rs
...
In the Excise Details screen
In RG 23D Entry No
...
E
...
12
88
Transactions
In Supplier Invoice Details section
Supplier
Invoice No: By default displays the Invoice No
...
field in the voucher entry screen
...
The Invoice Number is altered in order to identify the Invoice Number for the Stock
Item – Hot Rolled Coils selected as a second line item
...
field will be displayed
...
Specify the RG 23D Entry No
...
This Number represents the suppliers RG 23D
entry no, where the details of the particular transaction is available
...
6,50,000 on which the Excise Duty to be calculated
...
In Manufacturer/Importer Invoice Details section
Invoice
Number: Specify the manufacturers Invoice Number as SI/968/11-12
Invoice Date: Specify the manufacturers invoice date as 30-4-2011
RG 23 D Entry No: Enter the RG 23 Entry Number of the Manufacturer - 965
Billed Quantity: Enter the actual Billed Quantity sold to the First Stage Dealer
Assessable Value: Enter the actual Assessable Value i
...
6,50,000 of the stock item
...
Duty amount will be calculated and displayed based on the rate of duty
specified
...
42 Excise Details Screen
89
Transactions
Hot Rolled Coils 100 mm selected as the second line item, the rate of duty applicable is 10%
...
In Name of Item field select Hot Rolled Coils 100mm again as third line Item
17
...
13,50,000 in Amount field
18
...
field enter your RG 23D entry No
...
details provided in the supplier Invoice No
...
Alter the Invoice Number as 9682-2
...
Even though you alter the Invoice number for the third line item, in all the reports the
Invoice number entered in the Supplier Invoice No
...
Supplier
Invoice Date: by default displays the voucher date
...
- 9650
...
The Quantity of 750 is purchased under the Invoice no- SI/1052/10-11 which is
different from the earlier Invoice Number
...
Enter
the Assessable Value – Rs
...
The amount specified in this amount should the amount on which the Excise
Duty is calculated by the manufacturer
...
e
...
Duty Details: Duty Details displays the Duty Amount calculated for, First Stage Dealer
and Manufacturer/Importer
90
Transactions
...
43 Excise Details Screen
19
...
In Bill-wise Details screen select Type of Ref as New Ref and retain all the other default
details
...
44 Completed Excise - Purchase Invoice
21
...
91
Transactions
Excise Stock Register
Go to Gateway of Tally> Display > Statutory Reports > Excise Reports> Dealer > Excise
Stock Register
...
In all the reports the stock items selected multiple times in a purchase invoice will be displayed
one after another one based on the selection in the purchase Invoice
...
with Date column the Invoice Number as specified in Supplier Invoice No
...
Figure 4
...
2 Sale of Excisable Goods
A dealer of excisable goods (First Stage / Second Stage dealer) is required to issue a invoice as
per Rule 11 of the Central Excise Rules 2002, on sale of excisable goods to registered Excise
dealers/ manufacture, in order to pass the CENVAT Credit to the subsequent dealer/ manufacturer
...
Tally
...
, Commercial Invoice where sale is made to dealers other than manufacturers and
thus duty is not passed
...
Requirements of Excise Invoice
The Registered Location of the dealer is required to issue invoice in the prescribed format containing the following details:
Minimum Three copies of Invoice are required to be prepared and the copies of the invoice
should be marked at the top in the following manner:
Original
copy being marked as Original for Buyer
Duplicate copy being marked as Duplicate for Transporter
Triplicate copy being marked as Triplicate for Assessee
The dealer is required to issue only one invoice in respect of the consignment wherein all
the packages are dispatched in one lot however, in cases where the consignment is dispatched separately either on the same day or different days or loaded on more than one
vehicle, a separate invoice shall be made out for each lot or consignment
...
Name, address and Central Excise Registration number of the registered location issuing
the invoice, name of the jurisdictional range / Division / Commissionerate and company's
Income Tax Number and Sales Tax Registration Number should pre-printed on the Invoice
...
Each CENVAT Invoice issued by the location should bear a printed serial number, beginning from 1st April of the year
...
Records and Invoice generated through computer are also recognized
...
Commissioner
...
are exhausted, a revised intimation may be
sent
...
Commissioner in case he demands
...
The details of software used including a format used for information, is also required to be sent to the Assistant Commissioner
...
ERP 9:
Excise Invoice
Excise Invoice without Supplier Trader Information
Excise Invoice cum Commercial Invoice
Commercial Invoice
Sale of Goods Purchased From Agent of Manufacturer
Sale of Goods Purchased from Manufacturer Depot
Sale of Goods Purchased from Agent of Manufacturer (Consignment Agent)
Sales of Goods purchased from Agent of Dealer
Sale of Goods purchased from Importer
Sale of Goods Purchased from Agent of Importer (Consignment Agent)
Sale of Goods Purchased from Agent of Importer
Selection of Same Item Multiple Times in Excise Sales
Sale of Goods purchased form Multiple Manufacturers/Suppliers
Sale of Goods bought under an excise Purchase invoice at Different Rates
4
...
1 Excise Sales (Excise Invoice)
Example 11:
On 16th April 2012, Steelage Industries sold the following goods to M/s
...
05/04/12
Cold Rolled Coils 64mm
300
850
5%
457 dt
...
In Voucher Type subscreen select Excise–Sales from the List of Types
2
...
In Ref field, enter the reference number of the transaction
...
g
...
The Excise Unit field displays Steelage Industries (P) Ltd
...
5
...
6
...
field displays the Rule 11 invoice Number e
...
SAI\2\12-13
...
Select Decora Equipments in Party’s A/c Name field
8
...
Figure 4
...
Select Sales @ 5% in the Sales Ledger field and the VAT/Tax class appears by default as
Sales @ 5%
10
...
In the Supplier Details screen
95
Transactions
Select the Invoice No
...
47 Supplier Details Subscreen
The List of Purchases displays the list of purchases made for the selected item
from different Suppliers (Manufacturer / First Stage Dealer / Second Stage
Dealer)
...
Specify the Quantity as 250
96
Transactions
Figure 4
...
Specify the Rate as 900
...
13
...
In the Supplier Details screen
Select the Invoice No
...
49 Supplier Details Screen
...
Accept the Suppliers Details
...
Specify the and Rate as 850 (the Amount is calculated and prefilled automatically)
16
...
17
...
In the Bill-wise Details screen, accept the default bill allocations
...
Enter the transaction details in the Narration field
The completed Sales Invoice is displayed as shown
...
50 Completed Excise Sales Invoice Screen
20
...
98
Transactions
Step 2: Print Sales Invoice
The Voucher Printing screen appears as shown since, Print after Saving option is enabled in
Excise Sales Voucher Type, if not enabled press Alt+P from the above screen
...
51 Voucher Printing Screen
Press F12: Configure, to view the Invoice Printing Configuration screen
...
52 Invoice Printing Configuration screen
After configuration accept the Invoice Printing Configuration screen
Press Enter from the Voucher Printing screen to print Excise Invoice under Rule 11 of
Central Excise Rules 2002
99
Transactions
The Print preview of Excise Invoice (from the First Stage Dealer to a second stage dealer) is as
shown:
Figure 4
...
It reveals the Item history (i
...
It also comments on the manufacturer's name, address & Excise details besides recording the
date and time of the removal of goods from the dealer's premises
...
The above-generated Invoice
is required to be authenticated by the authorised signatory in the relevant space provided in the
document
...
2
...
Consider the above example and generate an Excise Invoice without Supplier Trader information
...
54 Invoice Printing Configuration screen
Accept the Invoice Print Configuration screen
Press Enter from the Voucher Printing screen to view print preview of Sales Invoice
101
Transactions
The print preview of Excise Invoice without Supplier information is displayed as shown
...
55 Print Preview of Excise Invoice without Supplier Information
102
Transactions
4
...
3 Excise Invoice cum Commercial Invoice
Tally
...
To print the commercial invoice follow the steps explained in the illustration
...
EMPEE Engineering
...
)
1150
VAT (%)
5%
Supplier Invoice
Number / Date
321dt
...
2
...
4
...
E
...
895/12-13
The Excise Unit field displays Steelage Industries (P) Ltd
...
5
...
6
...
field displays the Rule 11 invoice Number e
...
SAI\3\12-13
...
Select EMPEE Engineering in Party’s A/c Name field
8
...
Select Sales @ 5% in the Sales Ledger field, the VAT/Tax Class field is defaulted automatically as Sales @ 5%
10
...
In the Supplier Details screen
In Supplier Invoice Number / Date field select 321from the List of Purchases
...
In the Rate column Specify 1150 as the rate, the Amount gets pre-filled
13
...
14
...
In the Bill-wise Details screen accept the default bill allocation
...
Enter the transaction details in the Narration field
...
Figure 4
...
Press Enter to accept
...
57 Invoice Printing Configuration screen
Accept the Invoice Printing Configuration screen and press Enter to view the print preview of Commercial Invoice
105
Transactions
The print preview of Commercial Invoice is displayed as shown
...
58 Print Preview of Commercial Invoice
106
Transactions
4
...
4 Commercial Invoice
Where the dealer sells excisable goods to consumers or dealers, who does not have any
proposal to claim CENVAT Credit (or dealer does not intend to pass CENVAT credit to subsequent
dealer (Purchasing Dealer), in such cases the sale of excisable goods is required to be recorded
through a Commercial Invoice
...
Innova Steel Traders
...
)
700
VAT
5%
Supplier Invoice
Number / Date
1707 dt
...
Step 1: Create Sales Invoice
Go to Gateway of Tally > Accounting Vouchers > press F8:Sales
1
...
3
...
5
...
7
...
9
...
E
...
901/12-13
The Excise Unit field displays Steelage Industries (P) Ltd
...
Select Innova Steel Traders in Party’s A/c Name and press Enter
Specify the details of Despatch in the Despatch details sub-screen and press Enter
In the Name of Item field select Iron Bars
In the Supplier Details screen,
Select 1707 in the Supplier Invoice Number / Date column
107
Transactions
Figure 4
...
Specify Rate as 700 and press Enter (the Amount is prefilled automatically)
11
...
12
...
In the Bill-wise Details screen, accept the default Bill Allocations
14
...
108
Transactions
The completed Commercial Invoice is displayed as shown
...
60 Completed Commercial Invoice Screen
15
...
Step 2: Print Commercial Invoice
Press Alt+P the Voucher Printing screen appears (if Print after is saving is set to Yes in
Voucher Type master, Voucher Printing is automatically prompted)
...
61 Voucher Printing screen
Press Enter to Print
...
Figure 4
...
2
...
Example 14:
On 19th April 2012, Steelage Industries sold the following goods to M/s
...
Item Description
Engine Valves - 5”
Qty
110
Rate
(Rs
...
2
...
4
...
E
...
1023/12-13
In Party A/c Name field select Decora Equipments ledger
In Despatch Details screen, enter the despatch details
In Sales Ledger field select Sales @ 5% ledger
...
In Name of Item field select Engine Valves - 5” and press enter to view Supplier Details
screen
6
...
Figure 4
...
Enter 110 in Quantity Utilised field
...
Enter Rs
...
Amount will be calculated and displayed automatically
...
select the out put VAT ledger - Output VAT @ 5% to account VAT on the sale
Completed Sales Voucher appears as shown
...
64 Completed Excise Sales Voucher
10
...
112
Transactions
On accepting the Sales Invoice the Rule 11 Invoice appears as shown
Figure 4
...
2
...
Example 15:
On 20th April 2012, Steelage Industries sold the following goods to M/s
...
Item Description
Hot Rolled Coils 100mm
Qty
100
Rate
(Rs
...
In Party A/c Name field select Decora Equipments ledger
2
...
In Sales Ledger field select Sales @ 5% ledger
...
In Name of Item field select Hot Rolled Coils 100mm and press enter to view Supplier Details
screen
5
...
66 Selection of From Agent of Manufacturer’s Bill
114
Transactions
6
...
7
...
1200 in Rate field
...
8
...
Figure 4
...
Press Enter to accept
...
Figure 4
...
2
...
Example 16:
On 21st April 2012, Steelage Industries sold the following goods to M/s
...
Item Description
Hot Rolled Coils 100mm
Qty
200
Rate
(Rs
...
In Party A/c Name field select Decora Equipments ledger
2
...
In Sales Ledger field select Sales @ 5% ledger
...
In Name of Item field select Hot Rolled Coils 100mm and press enter to view Supplier Details
screen
5
...
Figure 4
...
Enter 200 in Quantity Utilised field
...
Enter Rs
...
Amount will be calculated and displayed automatically
...
select the out put VAT ledger - Output VAT @ 5% to account VAT on the sale
Completed Sales Voucher appears as shown
...
70 Completed Excise Sales Voucher
9
...
118
Transactions
Rule 11 invoice generated for sale of goods purchased from - Manufacturer Depot is displayed
as shown
...
71 Rule 11 Invoice
119
Transactions
4
...
8 Sales of Goods Purchased From Agent of Dealer
In Rule 11 invoice, in Supplier Name and Address box the Name and address of the Consignee
(dealer) on behalf of whom the goods were sold will be printed and not of the Agent of the Dealer
...
Decora Equipments, Bangalore
...
)
1300
VAT
4%
Supplier Invoice
Number / Date
6254 dated 11/04/2012
Record the transaction in Excise - Sales
Go to Gateway of Tally > Accounting Vouchers > F8: Sales (select Excise - Sales)
1
...
In Despatch Details screen, enter the despatch details
3
...
VAT/Tax Class field is defaulted automatically as Sales @ 5%
4
...
In Supplier Details screen, select the purchase bill - IMT/7960 of purchases made From
Agent of Dealer
Figure 4
...
Enter 170 in Quantity Utilised field
...
Enter Rs
...
Amount will be calculated and displayed automatically
...
Select the out put VAT ledger - Output VAT @ 5% to account VAT on the sale
Completed Sales Voucher appears as shown
Figure 4
...
Press Enter to accept
...
74 Print Preview of Rule 11 Invoice
122
Transactions
4
...
9 Sale of Goods purchased from Importer
Print Title of Rule 11 invoice generated for the goods sold which were purchased from Importer
will be First Stage Dealer
...
Decora Equipments,
Bangalore
...
)
800
VAT
13
...
In Party A/c Name field, select Decora Equipments ledger
2
...
In Sales Ledger field select Sales @ 13
...
VAT/Tax Class field is defaulted automatically as Sales @ 13
...
In Name of Item field select Copper Allow Strips and press enter to view Supplier Details
screen
In Supplier Details screen, select the purchase bill - 9254 of purchases made From Agent of
Dealer
Figure 4
...
Enter 130 in Quantity Utilised field
...
Set the option Is Additional Duty Imports (SAD) Not Pass On to Yes as Steelage Industries
does not want to pass the credit
...
76 Additional Duty Imports
7
...
800 in Rate field
...
8
...
5% to account VAT on the sale
Completed Sales Voucher appears as shown
Figure 4
...
Press Enter to accept
...
Figure 4
...
2
...
Example 19:
On 25th April 2012, Steelage Industries sold the following goods to M/s
...
Item Description
Copper Alloy Strips
Qty
50
Rate
(Rs
...
5%
Supplier Invoice
Number / Date
1052 dated 12/04/2012
Record the transaction in Excise - Sales Voucher
Go to Gateway of Tally > Accounting Vouchers > F8: Sales
1
...
2
...
ERP 9 displays Steelage Industries (P) Ltd
...
Select the Party’s A/c Name from the List of ledgers e
...
EMPEE Engineering
4
...
5
...
By default the VAT/Tax Class
selected in the Sales Ledger appears
...
Select the Stock Item - Copper Alloy Strips from the list of excise stock items
...
7
...
g
...
This table lists all
the purchases made for the Stock Item
...
79 Suppliers Details Screen
126
Transactions
8
...
Enter 50
...
Set the option Is Additional Duty Imports (SAD) Pass On to Yes, as Steelage Industries (P)
Ltd
...
Figure 4
...
Enter Rs
...
Amount will be calculated and displayed automatically
...
Select Output VAT ledger to account the VAT on the goods sold
...
81 Completed Excise Sales Voucher
12
...
127
Transactions
On accepting the Sales Invoice the Rule 11 Invoice appears as shown
Figure 4
...
2
...
Example 20:
On 25th April 2012, Steelage Industries sold the following goods to M/s
...
Item Description
Copper Alloy Strips
Qty
20
Rate
(Rs
...
5%
Supplier Invoice
Number / Date
1174 dated 13/04/2012
Record the transaction in Excise - Sales Voucher
Go to Gateway of Tally > Accounting Vouchers > F8: Sales
1
...
2
...
ERP 9 displays Steelage Industries (P) Ltd
...
Select the Party’s A/c Name from the List of ledgers e
...
Decora Equipments
4
...
5
...
By default the VAT/Tax Class
selected in the Sales Ledger appears
...
Select the Stock Item - Copper Alloy Strips from the list of excise stock items
...
7
...
g
...
This table lists all
the purchases made for the Stock Item
...
83 Suppliers Details Screen
8
...
Enter 20
...
Set the option Is Additional Duty Imports (SAD) Pass On to Yes, as Steelage Industries (P)
Ltd
...
Figure 4
...
The Rate per Kg of Copper Alloy Strips gets prefilled in the Rate column
...
Select Output VAT ledger to account the VAT on the goods sold
...
85 Completed Excise Sales Voucher
12
...
130
Transactions
On accepting the Sales Invoice the Rule 11 Invoice appears as shown
Figure 4
...
2
...
Tally
...
In this case, while recording the
sales if the stock item is selected once and all the bills (with different duty per unit) are selected for
the same item, in all the Excise reports the duty per unit will display the average duty of all the bills
selected in the invoice as system cannot decide on displaying the duty appropriately
...
Example 21:
On 26th April 2012, Steelage Industries sold the following goods to M/s
...
Item Description
Qty
Rate
(Rs
...
Select Excise - Sales Voucher type from the list of Voucher Types
...
In Excise Unit field Tally
...
, as selected during
voucher type creation
3
...
g
...
The Buyer’s Details sub-form appears enter Despatch and Order details in corresponding
fields and accept the screen to save
...
Select the Sales Ledger from the list of ledger accounts
...
Select the Stock Item - Hot Rolled Coils 100mm from the list of excise stock items
...
g
...
This table lists all the
purchases made for the Stock Item
...
However, once the goods purchased from a Manufacturer
is selected for Invoicing, only goods purchased from Manufacturer will be displayed
and If goods purchased from a First Stage Dealer is selected, only purchases from
First Stage Dealer will be displayed for selection
...
Upon selecting a Purchase, the cursor moves to Quantity Utilised field
...
Retain 1000 MT as Steelage Industries (P) Ltd
...
Figure 4
...
ERP 9 warns you with a message
...
Tally
...
8
...
Amount will be displayed automatically
...
In Name of Item field select Hot Rolled Coils 100mm again as second line Item
For Hot Rolled Coils 100mm the duty per unit paid for purchase made under bill 9682-1 is
133
...
32
...
In Supplier Details screen select the second 9682-1 & in Quantity field specify 50
133
Transactions
Figure 4
...
Select the applicable Output VAT Ledger, and press Enter, VAT Rate and amount is defaulted
automatically
11
...
Amount will be displayed
automatically
The completed Excise Sales voucher is displayed as shown
Figure 4
...
Press Enter to accept
...
90 Rule 11 Invoice for Multiple Items Selected in the Same Invoice
135
Transactions
4
...
Imported goods will be released from the bonded warehouse only on the payment of Customs
duty
...
Tally
...
4
...
1 Full Clearance of Imported Goods
In practice, depending on the requirement goods imported are cleared from bonded warehouse in
full or partially by paying the customs duty
...
imported Copper Alloy Strips from Excellor Impex
(P) Ltd
...
Item Description
Copper Alloy Strips
Qty (Kgs)
50,000
Rate
150
Assessable Value
75,00,000
Let us consider the below calculation for entering the imports in Tally
...
150)
75,00,000
Customs duty @ 30% (on assessable value)
22,50,000
CVD @ 12% (is calculated on Assessable value + Customs Duty)
11,70,000
Education Cess on CVD @ 2% (calculated on CVD)
23,400
Secondary Education Cess on CVD @ 1% (calculated on CVD)
11,700
Education Cess on Customs Duty @ 2% (calculated on Customs
Duty + CVD + Edu Cess on CVD + Sec Edu Cess on CVD)
69,102
Secondary Education Cess on Customs Duty @ 1% (calculated on
Customs Duty + CVD + Edu Cess on CVD + Sec Edu Cess on CVD)
34,551
Addl Duty on Imports @ 4% (Assessable Value + Customs Duty +
CVD + Edu Cess on CVD + Sed Edu Cess on CVD + Edu Cess on
Customs Duty + Sec Edu Cess on Customs Duty)
4,42,350
Customs Duty, Education Cess on Customs duty and Sec Edu Cess on
Customs duty are not passed on, they will be apportioned to the item cost
...
136
Transactions
Record the Transaction in Purchase Voucher
Setup:
In F11: Features (F2: Inventory Features)
Set the option Use Tracking Numbers (Delivery/Receipts Notes) to Yes
Go to Gateway of Tally > Accounting Vouchers > F9: Purchase
1
...
3
...
5
...
Select Alt + I: Item Invoice if it is in Acct Invoice mode
Press F2 and enter the date as 26-4-2012
Enter the Supplier Invoice No
...
ERP 9 displays the Excise Unit as Steelage Industries (P) Ltd
...
6
...
g
...
7
...
You can create a ledger in your company name with excise details so that you can
select the ledger to avoid repeated entry of details
...
Figure 4
...
Select Imports as the Nature of Purchase
137
Transactions
9
...
VAT/
Tax Class will be defaulted to Imports
10
...
In Tracking Number field select the option Not Applicable if all the goods imported are
cleared at once
...
Select the Godown and specify Quantity as 50,000 and Rate as 150
...
Figure 4
...
In Excise Details screen
In RG 23D Entry No field enter the RG 23D entry number of this purchase in your books
...
field if
entered
...
field enter the PLA number where the reference of duty paid
on the goods sold are entered
...
97,50,000 (Purchase Cost + Customs Duty)
...
Duty Amount will be calculated and displayed automatically
...
Enter Rs
...
ERP9 will not auto calculate the Additional Duty (Imports) amount
...
138
Transactions
Figure 4
...
94 Completed Excise Purchase Voucher
14
...
139
Transactions
On booking the purchase entry for imports based on the invoice received and all the goods
imported are cleared from the customs bonded warehouse stock details will be displayed in Stock
Summary
Go to Gateway of Tally > Stock Summary
Figure 4
...
3
...
In Tally
...
Let us see how to
record the partial clearance of the goods
...
imported Copper Alloy Strips from Excellor Impex
(P) Ltd
...
Item Description
Copper Alloy Strips
Qty (Kgs)
50,000
Rate
150
Assessable Value
75,00,000
On 28th April 2012 Steelage Industries (P) Ltd
...
To record the above transaction
1
...
Record the Imports in Purchase Voucher
3
...
> Voucher Types > Create
In Name field enter the receipt name as Excise - Receipt Note
In Type of Voucher select Receipt Note
...
Set the option Use for Excise to Yes
In Default Excise Unit field select Steelage Industries (P) Ltd
...
96 Excise - Receipt Note Voucher Type
Press Enter accept
...
2
...
4
...
Select the Excise - Purchase as the Voucher Type from the list of types
...
as EI/3652 and Date as 27-4-2012
By default Tally
...
as defined
during voucher type creation
...
Select the Party’s A/c Name from the list of Ledger Accounts e
...
Excellor Impex (P) Ltd
...
In Party Details screen, in Manufacturer /Importer Details section specify your company
details with excise details, since you can declare as Self Importer which is equivalent to Manufacturer
...
To select Party Ledger press Alt + M keys or click on M: Manual button to view the
party list for selection
...
Nature of Purchase will be defaulted to Importer as defined in the party ledger
9
...
VAT/
Tax Class will be defaulted to Imports
...
In Name of Item field select Copper Alloy Strips
11
...
Figure 4
...
Amount will be calculated and displayed
...
98 Item Allocation Screen
12
...
Once the option is set to YES details
displayed in Excise Details screen will be erased indicating separate clearance entry will be
recorded
...
99 Excise Details Screen
143
Transactions
This option will be displayed only when the New Tracking Number is defined/
specified for the transaction
...
Figure 4
...
Press Enter to accept
...
To verify
Go to Gateway of Tally > Stock Summary > select Copper Alloy Strips and press enter till you
reach Stock Voucher report for the month of April
144
Transactions
Observe the purchase made on 27-4-2012 has not affected the books of inventory and the closing
balance has not changed
Figure 4
...
Record Partial Clearance of Imported Goods
The Assessable vale and Duty Details of goods cleared are as shown in the table
...
150)
15,00,000
Customs duty @ 30% (on assessable value)
4,50,000
CVD @ 12% (is calculated on Assessable value + Customs Duty)
2,34,000
Education Cess on CVD @ 2% (calculated on CVD)
4,680
Secondary Education Cess on CVD @ 1% (calculated on CVD)
2,340
Education Cess on Customs Duty @ 2% (calculated on Customs Duty +
CVD + Edu Cess on CVD + Sec Edu Cess on CVD)
13,820
Secondary Education Cess on Customs Duty @ 1% (calculated on
Customs Duty + CVD + Edu Cess on CVD + Sec Edu Cess on CVD)
6,910
Addl Duty on Imports @ 4% (Assessable Value + Customs Duty + CVD
+ Edu Cess on CVD + Sed Edu Cess on CVD + Edu Cess on Customs
Duty + Sec Edu Cess on Customs Duty)
88,470
145
Transactions
Go to Gateway of Tally > Accounting Vouchers > F9: Receipt Note
1
...
3
...
Select the Excise - Receipt Note as the Voucher Type from the list of types
...
ERP 9 displays the Excise Unit as Steelage Industries (P) Ltd
...
5
...
g
...
6
...
7
...
In Purchase Ledger field select Purchase - Imports from the List of Ledger Accounts
...
In Name of Item field select Copper Alloy Strips
10
...
field select bill of entry number against which the goods are cleared from
the boned warehouse
...
Quantity and Rate of the stock Item will
be displayed based on the bill of entry number selected
In Quantity field enter the quantity cleared
...
Amount gets re-calculated
based on the quantity specified
...
102 Item Allocation Screen
11
...
Enter BEN- 2545/10/11
In Invoice/Bill of Entry Date field enter the date of clearance of goods
...
PLA/ RG 23D Entry no
...
In Assessable Value field specify Rs
...
Assessable value to be calculated and manually
...
Enter Rs
...
Tally
...
You have to enter manually
...
103 Excise Details Screen
The completed Excise - Receipt Note is displayed as shown
Figure 4
...
Press Enter to accept
...
Figure 4
...
4 Conditional Pass on of Additional Duty (Imports)
Additional Duty (Imports) paid on Imported goods are some times passed on to the subsequent
dealer and in some cases importer may opt to avail credit/ reimbursement by not passing on the
special additional duty
...
ERP now supports conditional pass on of Additional Duty (Imports)
...
sold Copper Alloy Strips (purchased against the
Bill BEN-2545/12-13) to Decora Equipments by not passing on the Additional Duty (Imports)
...
Select Excise - Sales Voucher type from the list of Voucher Types
...
In Excise Unit field Tally
...
, as selected during
voucher type creation
3
...
g
...
The Buyer’s Details sub-form appears enter Despatch and Order details in corresponding
fields and accept the screen to save
...
Select the Sales Ledger from the list of ledger accounts
...
6
...
On selecting
the item, Supplier Details sub-screen for the item appears
...
Select the appropriate purchase e
...
BEN - 2545/12-13 from the List of Purchases table
...
8
...
Enter 5,000
...
Set the option Is Additional Duty Imports (SAD) Not Pass On to Yes, as Steelage Industries
(P) Ltd
...
Figure 4
...
In Stock Item Allocations screen, Quantity will be defaulted to 5,000
...
450 in
Rate field
...
11
...
Completed Sales Voucher is displayed as shown
Figure 4
...
Press Enter to accept
...
Under Manufacturer/Importer Duty Details, duty details of the goods imported will display the all
the duty details including Additional Duty (Imports) value
...
108 Rule 11 Invoice
151
Transactions
4
...
Under Inclusive method, the value of Excise Duty and other Cess amounts are debited to
Purchase Accounts, i
...
, apportioned to the Purchase Cost
...
Under Exclusive method, Excise Duty, Education Cess, Secondary Education Cess and other
Excise Duty ledgers are created and itemised separately in the Purchase Invoice, as a result of
which, the Excise duty paid values will reflect the balances of these ledgers
...
All the above scenarios explained in this chapter, are accounted using Inclusive Method
...
But, there are dealers who follow Exclusive
method also
...
ERP 9 supports recording of Excise Purchase and Sales Invoice in Exclusive
method
...
5
...
No
...
Item Description
Hot
Rolled
Coils 100mm
Qty
400
Rate
Assess
able
Value
BED @
12%
Educ
Cess
@
2%
Higher
Educ
...
Step 2: Creation of Duty Ledgers
1
...
> Ledgers > Create
1
...
3
...
Enter the Name of the Excise duty ledger you wish to create
...
Select Excise from the Type of Duty/Tax list in the field Type of Duty/Tax
...
6
...
8
...
109 Completed Ledger Creation screen
9
...
153
Transactions
2
...
> Ledgers > Create
1
...
g
...
Select Duties & Taxes as the group name in the Under field
...
Select Excise from the Type of Duty/Tax list in Type of Duty/Tax field
...
In Excise Accounting Code field enter the accounting code of Education Cess - 00380111
5
...
In Percentage of Calculation field enter 2% as the percentage of calculation
7
...
8
...
The completed Education Cess ledger appears as shown:
Figure 2
...
Press Enter to accept the ledger
...
Creating Secondary Education Cess Ledger
To create a Secondary Education Cess Ledger,
Go to Gateway of Tally > Accounts Info
...
Enter the Name of the Secondary and Higher Education Cess ledger you wish to create, for
e
...
, Secondary Education Cess @ 1%
2
...
3
...
4
...
5
...
In Percentage of Calculation field enter 1% as the percentage of calculation
7
...
8
...
111 Secondary Education Cess Ledger
9
...
155
Transactions
Step 3: Create an Excise Purchase Invoice
Go to Gateway of Tally > Accounting Vouchers > F9:Purchase
1
...
3
...
In Voucher Type subscreen select Excise–Purchases from the List of Types
Press F2 and change date to 01-05-2012
Enter 9328 in the Supplier Invoice No
...
as selected during voucher Type creation
...
Select Sterling Steel Industries in Party’s A/c Name field
6
...
In Nature of Purchase field, nature of purchase Manufacturer appears by default based on
the predefinition in the ledger master
...
Select Purchases @ 5% in the Purchase Ledger field, the VAT/Tax Class appears by default
as Purchases @ 5% based on the predefinition in ledger master
...
Select Hot Rolled Coils 100mm in the Name of Item field
10
...
The Excise Details screen is displayed
...
field (The RG 23D Entry No
...
as 9328 and Supplier Invoice Date as 01-05-2012 (The
Supplier Invoice No
...
field (This field represents the display of this particular transaction in the relevant page of RG 23 D Register of the supplier)
Accept the Assessable Value that is prefilled
...
Figure 4
...
12
...
13
...
The duty
amount will be automatically calculated
...
Select Input VAT @ 5% ledger, VAT amount of Rs
...
15
...
16
...
Enter 9328 in the Name field
...
17
...
The completed Excise Purchase Invoice is displayed as shown:
Figure 4
...
Press Enter to accept
...
5
...
In Tally
...
On selection of the duty ledgers in Excise Sales Invoice, the value of Excise Duty \ Cess
ledgers will be displayed based on the Duty \ Cess paid at the time of purchase of Stock Item and
not on the Total Sales Amount
...
Decora Equipments, Bangalore
...
)
1500
VAT
5%
Supplier Invoice
Number / Date
9328 dated 01/05/2012
Record the transaction in Excise - Sales Voucher
Go to Gateway of Tally > Accounting Vouchers > F8: Sales
1
...
2
...
ERP 9 displays Steelage Industries (P) Ltd
...
Select the Party’s A/c Name from the List of ledgers e
...
Decora Equipments
4
...
5
...
By default the VAT/Tax Class
selected in the Sales Ledger appears
...
Select the Stock Item - Hot Rolled Coils 100mm from the list of excise stock items
...
158
Transactions
7
...
g
...
This table lists all
the purchases made for the Stock Item
...
114 Suppliers Details Screen
8
...
Enter 200
...
Specify the Rate per MT of Hot Rolled Coils 100mm as 1500 in the Rate column
...
Select Basic Excise Duty @ 12%, Education Cess and Secondary Cess Ledgers
...
This duty amount will be calculated on the basis of
Excise Purchase voucher recorded as on 1-5-2012 and not as per the sale value
...
Select Output VAT ledger to account the VAT on the goods sold
...
115 Completed Excise Sales Voucher
159
Transactions
12
...
On accepting the Sales Invoice the Rule 11 Invoice appears as shown:
Figure 4
...
In this section, entries for transactions
involving return of excisable goods using Credit Note and Debit Note are examined
...
1 Sales Returns
Example 1:
On 30th April 2012, Decora Equipments returned the following goods to Steelage Industries Pvt
...
supplied on 16-04-2010 vide Bill
...
981\12-13
Item Description
Qty (Mts)
Rate (Rs
...
In Voucher Type sub screen select Ex-Sales Return from the List of Types
2
...
In the Used for field select Goods Sold Returned as the type of VAT Adjustments
Figure 5
...
In the Excise Unit Name field Steelage Industries (P) Ltd
...
Select Decora Equipments in Party's A/c Name and press Enter
6
...
In Sales Ledger field select the applicable sales ledger
...
8
...
The Supplier Details screen displays
Specify the Sales Invoice Number as SAI\2\12-13 and the Sales Invoice date is automatically displayed as 16-04-2012
If
an Excise Book is created in Excise Registration Details of F11: Statutory
and Taxation, then the Serial Number stated in the Excise Sales Invoice
should be specified in the Supplier Details screen of an Excise Credit Note
Voucher (Sales Return)
If
an Excise Book is not created in the Excise Registration Details screen,
then the Excise Sales Invoice number should be specified in the Supplier
Details of the Excise Credit Note Voucher
...
from the List of Purchases
Type the returned quantity as 10 in the Quantity Return column
...
2 Excise Credit Note Voucher - Supplier Details
Accept the Supplier\ Details screen
10
...
11
...
450
12
...
In the Bill-wise Details screen
162
Return of Goods
Select
Agst Ref in the Type of Ref filed
In the Name field select 981/12-13, dated 16-04-2012
Press Enter, the Amount appears by default
...
3 Bill-wise Details Screen
14
...
The completed Excise Sales Returns voucher is displayed as shown
...
4 Completed Excise Sales Returns Voucher
15
...
2 Purchase Returns
Example 2:
On 30th April 2012, M/s
...
, returned the following goods to M/s
...
No
...
05/04/2012)
...
)
551
...
2
...
4
...
6
...
8
...
In Voucher Type sub screen select Ex-Purchase Return from the List of Types
Select Alt + I: Item Invoice, if voucher is in Acct Invoice mode
Press F2 and change date to 30-04-2012
In the Excise Unit Name field Steelage industries (P) Ltd
...
VAT/Tax
Class and Amount is defaulted automatically
...
5 Excise Debit Note - Excise Details screen
The Supplier Invoice Date, Nature of Purchase and the Quantity Purchased are prefilled automatically as 05-04-2012, Manufacturer & 400 MT respectively
Specify the Quantity Return as 15 MT
164
Return of Goods
Press Enter to accept the Assessable Value as Rs
...
e
...
500 [before
Excise Duty])
Figure 5
...
Specify 551
...
Select Input VAT @ 5% ledger and the VAT amount is automatically calculated and prefilled
as 413 - (i
...
, 5% of Rs
...
50)
12
...
In the Bill-wise Details screen
Select Agst Ref in the Type of Ref field
In the Name field select 457 dated 05-10-2012
Accept the default Amount and Dr/Cr allocation
14
...
Figure 5
...
Press Enter to accept
...
166
Lesson 6: Reports
Dealers registered with the Central Excise are required to maintain prescribed registers in the
godown/ store room
...
A dealer registered under Excise Rules are required to submit quarterly returns in prescribed
format and other documents namely, Stock Register (RG 23D) and Form II to the Assessing
Authority within the stipulated time
...
ERP 9, you can generate and print all statutory & excise related forms & reports as
required by a dealer of excisable goods at the end of month or a quarter or annually or at any
point of time
...
ERP 9:
Excise Stock Register
Excise Purchase Bill Register
Excise Stock CENVAT Register
Party Wise Duty Extract
Customs Clearance Register
Sales and Purchase Extract
Form RG 23D
Form 2
E-Return
6
...
It also shows information on the sales transactions, which were sold under Excise Invoice and Commercial Invoice
besides capturing details of the Supplier/ Manufacturer
...
Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Excise
Stock Register
167
Reports
In the Select Excise Unit screen
In Name of Excise Unit field Tally
...
In case where there are more than one dealer unit select the appropriate Excise Unit from
the List of Excise Units for which you want to view the Excise Stock Register
In Name of Tariff field select Hot Rolled Coils from the List of Tariff Classifications
In Name of Item field select Hot Rolled Coils 100mm
Select the appropriate Stock item from the List of Excise Stock Items to view the Excise
Stock Register
The Select Excise Unit screen will be displayed as shown
Figure 6
...
is displayed as shown
Figure 6
...
ERP 9 also allows you view Excise Stock Register in detailed mode, by pressing Alt + F1
Figure 6
...
Press Alt+P to print Excise Stock Register
169
Reports
The print preview of Excise Stock Register is displayed as shown
Figure 6
...
2 Excise Purchase Bill Register
Excise Purchase Bill Register is a Purchase bill wise report displaying the details of purchases
(Receipts) and sales (Issues) of excisable goods in a given period
...
Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Excise
Purchase Bill Register
In the Select Excise Unit screen select Steelage Industries (P) Ltd
...
5 Select Excise Unit
The Excise Purchase Bill Register of Steelage Industries (P) Ltd
...
Figure 6
...
7 Excise Purchase Bill Register - Issues Section
You can further scroll down to view the complete report
...
3 Excise Stock CENVAT Register
Excise Stock CENVAT Register displays the CENVAT details of Goods Purchased
...
To view Excise Stock CENVAT Register,
Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Excise
Stock CENVAT Register
Excise Stock CENVAT Register can be viewed for All Items or One Item
...
3
...
If you have more than one manufacturing unit select the appropriate Excise Unit from the List of Excise Units to view the
pending quantity and CENVAT duty per unit that can be passed on
...
8 Select Excise Unit
The Excise Stock CENVAT Register of Steelage Industries (P) Ltd
...
9 Excise Stock CENVAT Register
173
Reports
Scroll to the right using Right arrow button
Figure 6
...
6
...
2 Excise Stock CENVAT Register - One Item
To view Excise Stock CENVAT Register for All Items
Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Excise
Stock CENVAT Register > One Item
In Select Ledger screen
Name of Excise Unit: In this field select the Excise Unit
...
Name of Group: In this field select the Group to select the ledgers created under the
Group selected
...
g
...
11 Select Excise Unit
The Excise Stock CENVAT Register of Steelage Industries (P) Ltd
...
12 Excise Stock CENVAT Register
175
Reports
6
...
To view Party Wise Duty Extract report
Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Party
Wise Duty Extract
In Select Ledger screen
Name of Excise Unit: In this field select the Excise Unit
...
Name of Group: In this field select the Group to select the ledgers created under the
Group selected
...
g
...
13 Selection of Ledger
The Party Wise Duty Extract report is displayed as shown
Figure 6
...
5 Customs Clearance Register
Customs Clearance Register is a import bill-wise report displaying the details of imports of
Excisable goods having stock pending for Clearance
...
This report captures the information of goods Imported, Cleared from customs warehouse and
stock Pending for clearance
...
15 Customs Clearance Register Menu
1
...
in Name of Excise Unit filed
...
16 Select Excise Unit Screen
177
Reports
The Customs Clearance Register appears as shown
Figure 6
...
One Item - Customs Clearance Register
To view Customs Clearance Register for one items select One Items and press enter to view
Select Excise Unit screen
In Select Excise Unit screen
Select Steelage Industries (P) Ltd
...
Select Copper Alloy Strip
In Name of Item field select Copper Alloy Strips
Figure 6
...
19 Customs Clearance Register – One Item
179
Reports
6
...
Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Sales and
Purchase Extract
In the Sales and Purchase Extract printing screen,
Press Backspace and select the Excise Unit - Steelage Industries (P) Ltd
...
20 Report Printing Configuration Screen
Press
Enter to Print
180
Reports
The print preview of Sales and Purchase Extract of Steelage Industries (P) Ltd
...
Page - 1
Figure 6
...
22 Sales and Purchase Extract
182
Reports
Page 3
Figure 6
...
7 Form RG 23D
The registered dealer issuing invoices for CENVATable goods is required to maintain a stock
account as prescribed in form RG – 23D and record details of consignments received under the
cover of any invoice issued in terms of the provisions of Central Excise Rules, 2002
...
In respect of any consignment, part of which is sold under Centavable invoice, and the other part
under the cover of non-CENVATable invoice, then the details of sales under non-CENVATable
invoices have also to be entered in the prescribed stock register by making a consolidated entry
at the end of the day indication such quantity and invoice numbers
...
183
Reports
The details of excisable goods sold under CENVAT Invoice and the corresponding excise duty
passed to the subsequent dealer / manufacturer, is required to be reported as Duty Passed On in
the Issues column of the Stock Register (formerly RG 23D) and likewise, the details of the
excisable goods sold under Commercial Invoice and the duty to the extent not passed on, is
required to be reported as Duty Not Passed On in the Issues column of the Stock Register,
during the respective financial period
...
Form RG 23D – All Item
Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Form RG
23D
In the Select Excise Unit screen
In Name of Excise Unit field Tally
...
In case where there are more than one dealer unit select the appropriate Excise Unit from
the List of Excise Units for which you want to view the Excise Stock Register
From RG 23D for All Items is displayed as shown
Figure 6
...
It precisely shows Receipts and Issues of Excisable goods alongwith the information on
the duty amount passed, duty amount not passed and the balance of duty including Cess amount
available during the specified period
...
Print RG 23D
Press Alt+P or click on P: Print button to view report printing configuration screen
Figure 6
...
26 Print Preview of Form RG 23D
2
...
ERP 9 displays Steelage Industries (P) Ltd
...
Select Hot Rolled Coils
In Name of Item field select Hot Rolled Coils 100 mm form the List of Excise Stock
Items
...
27 Form RG 23 D – One Item
3
...
This report displays the details
of sales transactions based on the period selected to view the report
...
from the List of Excise Units in Name of Excise Unit
field
In Name of Tariff field select the tariff classification - Hot Rolled Coils
Select Hot Rolled Coils 100mm in Name of Item field
Sales Bill Wise Form RG 23D report appears as shown
187
Reports
Figure 6
...
8 Quarterly Return - Form 2
A first stage dealer or a second stage dealer, as the case may be, is required to submit a return in
the form as specified by notification or by the Board within fifteen days from the close of each
quarter of a year to the Superintendent of Central Excise
...
in Excise Unit filed
specify the From date as 1-4-2012 and To date as 30-6-2012
Specify Place and Date details
188
Reports
Figure 6
...
30 Form 2
190
Reports
Page - 2
Figure 6
...
32 Form 2 - Page 3
As discussed above, Form 2 displays the details of the Stock item with the maximum duty value
...
To view the details of all the stock items
Press F12: configure from the Report Generation screen and set the options Show All
Items, Show Separate Special Excise Duty Column and Show Purchase Reference to
Yes
...
33 F12: Configuration Screen
Accept the configuration screen and press Enter form the Report Generation screen to
view the print preview of Form 2
...
9 E-Returns
The Central Board of Excise and Customs has issued a notification making e-filing mandatory for
assessees with effect form 1-4-2010
...
To assist and manage e-filing, Central Board of Excise & Customs has set up an e-governance
portal – Automation of Central Excise and Service Tax (ACES) [http://aces
...
in]
E-Filling of Dealer Return
Currently, ACES application allows filing Quarterly Return for the Registered Dealers online who
are accessing the ACES site through PCs / Internet Browsers
...
Assessees who are not maintaining the records in computerised system, can down load the Excel
utility and enter the details manually, validate and upload the Excel utility
...
Benefits of using the XML schema is that if user is having huge data
to upload instead of entering manually they can use their application for generating XML schema
...
ERP9
Meeting all the requirements of E-Returns, Tally
...
For generating E-Returns from Tally
...
To generate E-Returns
Go to Gateway of Tally > Display > Excise Reports > Dealer > E-Return
193
Reports
The Exporting Dealer E-Return screen appears as shown
Figure 6
...
ERP 9 allows creating and maintaining accounts of multiple units in a
single company and allows to generate Excise Unit-wise e-returns, Excise Unit field is provided to select the Excise unit for which E-Return to be generated
...
Language: Language is fixed to Restricted (ASCII Only) and the application will not allow
to move the cursor to change the language
Format: Format is fixed to XML (Data Interchange)
...
Hence, the XML (Data Interchange) is defaulted and application does not allow to change
the export format
...
ERP 9 is installed
...
Output File Name: Tally
...
The E-Return Requirement has clearly indicated that the E-Return File Format should - 15
Digit ECC Number_ Month Date Year Hour Minutes Seconds AM/PM
...
xml
194
Reports
Tally
...
But to upload the E-Returns, assessee has to follow the file name structure as
specified under E-Returns Requirement
...
From: In this field enter the period (1-4-2012) from where the return to be generated
...
If the
Assessee generates the returns without or incomplete details, the e-return
generated will show the errors for the missing details
...
By default, Validation option will be set to Yes
...
195
Reports
E- Return Validation screen appears as shown
Figure 6
...
To rectify the error,
select the error type and press Enter
...
Some of the Error Types displaying in the E-Return Validation screen are stated below:
1
...
Example: Unit of Quantity is U for Numbers
...
It even applies to
E-returns
...
ERP 9 Unit of Quantity is termed as Reporting UOM
...
If there are any difference in the Unit of Quantity defined in the item master then the
application will not allow to generate e-returns till such discrepancies are resolved
...
ERP 9, while creating the stock item application gives the option to define
the Base Unit and Reporting UOM
...
In case the base unit defined is different from standard Unit of Quantity user has to
select the correct Reporting UOM for the Stock Item
...
36 Excise Reporting UOM Validation Screen
Excise Reporting UOM Validation screen displays the details of Name of Stock Item, Tariff Name, HSN Code, Units Excise Reporting UOM and Remarks
...
In the above
screen the Reporting UOM is Empty
...
Specify the correct Reporting UOM
...
198
Reports
Figure 6
...
On accepting the Excise
Reporting UOM Validation, E-Return Validation screen will not display the Type of Error No/Invalid Excise Reporting UOM for Stock Item and the corresponding Error Count
...
ERP 9, Excise Reporting UOM can also be updated for
Single
Stock Item: To update Reporting UOM to single stock item Go to Gateway of Tally > Inventory info
...
> Update Excise Info > Reporting UOM
From Reporting UOM user can define the Reporting UOM to stock items in
three ways
i
...
ii
...
iii
...
199
Reports
2
...
38 Tariff/HSN Code Validation Screen
Tariff/HSN Code Validation report displays the details of Name of Tariff, HSN Code and
Remarks
...
In the above
screen the HSN Code defined for the Tariff classification contains 6 digits or HSN Code is
empty where as the HSN Code should of 8 digits
...
Correct the HSN code by specify the correct 8 digit code
...
200
Reports
Figure 6
...
ERP 9 looks only for 8 digits/numbers and ignores the dot or space between
the numbers
Press Enter to accept the Tariff/HSN Code Validation
...
3
...
Validation
To validate the excise registration
Select No/Invalid Excise Registration (ECC) No
...
Validation screen
201
Reports
Figure 6
...
Validation Screen
Party Excise Registration (ECC) No
...
and Remarks
...
In the
above screen the Excise Registration number defined for the party contains special
character, number is more than 15 digits, the registration number format is wrong
...
The
first part denotes 10 character (alpha numeric) Permanent Account Number
issued by Income tax authorities to the concerned person to whom the ECC Number is
allotted
...
Remark will be displayed for all those registration numbers which are more than 15 digits,
contains special characters or space between the numbers
...
202
Reports
Figure 6
...
Validation Screen
Press Enter to accept the Party Excise Registration (ECC) No
...
On accepting
the Party Excise Registration (ECC) No
...
Tally
...
Press Escape from E-Return Validation screen to view Exporting Dealer E-Return
screen
...
42 Exporting Dealer E-Return Screen
204
Reports
Press Enter to export the Return
...
Tally
...
To configure press F12: Configure
from Exporting Dealer E-Return screen to view Configuration screen
...
Enabling the option Show all Items is not mandatory while generating Ereturns
...
If the
commissionerate is specific about the details of all the items purchased under
the Invoice then set this option to YES and generate the E-return
...
If the user generates E-Returns by setting the option Show Excise Duty Amount
Round Off to No, the ACES application will not allow the Assessee to upload the
Returns
...
The exported file will be placed in the Tally
...
205
Reports
Figure 6
...
ERP 9 Folder
206
Reports
Users can verify the correctness of the E-Returns generated from Tally
...
The
Excise department has provided a XSD file using which the xml has to be validated
and then uploaded to the department website
...
XSD specifies how to formally describe
the elements in an XML document
...
There are various tools available on net that can be downloaded for validating an
XML against the XSD file
...
EditiX 2010, Stylus studio, etc
...
To compare the data structure of file generated from Tally
...
xsd file into Tally
...
ERP 9 in any of the XML validation
tools like EditiX 2010, StylusStudio etc
...
xsd file available in Tally
...
207
Title: Tally Book
Description: If you wants to Know all abut Tally ERP 9 its right place for you ...
Description: If you wants to Know all abut Tally ERP 9 its right place for you ...