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. In this case Excise Dealer who buys the goods from first consignment agent will be assumed to be acting as a Agent of Importer (Consignment Agent).
Example: XYZ Traders is an Agent of Importer (Consignment Agent) of Sterling Steel Industries. XYZ Traders sells the goods to ABC Company and raises the sales invoice by marking the ABC Company as "Consignment Agent of Importer".
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.
Tally.ERP 9 allows you to account the transactions where the dealer is acting as the Agent of Importer & print Rule 11 invoice by printing the title as - Sale by Consignment Agent
Example: On 10-5-2012 ABC Company purchased 1500 Kgs Hot Rolled Coils @ 291.20 per Kg from XYZ Traders. XYZ Trader is a Consignment Agent & he has billed ABC Company as "Consignment Agent of Importer"
On 10-5-2009 ABC Company sold 1000 Kgs of Hot Rolled Coils @ 350 per kg to Decora Equipments.
Go to Gateway of Tally > Accounts Info. > Ledger
Enter Name of the Supplier in Name field e.g XYZ Traders.
Select Sundry Creditors as the group name in Under field.
Set Maintain Balances Bill by Bill to Yes and enter Default Credit Period if any.
Set Inventory Values are affected to No.
In Mailing Details and Tax Information section enter supplier contact details, Income Tax and Sales Tax numbers.
Enable Set/Alter Excise Details to Yes to display Excise Details screen.
In Excise Details screen enter the details as shown below
Press Enter to accept and save
Go to Gateway of Tally > Accounting Vouchers > F9: Purchase
Select Excise - Purchase as the Voucher Type from the list of types.
Select Alt + I: Item Invoice if it is in Acct Invoice mode
Press F2 and enter the date as 10-5-2012
Enter Supplier Invoice No. as IT/5675 and Date as 10-5-2012
By Default Tally.ERP 9 displays Excise Unit as ABC Company as defined during voucher type creation.
Select Party’s A/c Name from the list of Ledger Accounts e.g. XYZ Traders
The Supplier’s Details sub-form will appear. Supplier’s Details will include supplier contact details, Sales Tax number and Excise registration details. The details will appear automatically if they are provided during the Supplier Ledger Creation. 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.
For this purchase XYZ traders are not the manufacturer. Manufacturer is Sterling Steel industries. Specify the details of the manufacturer
By default the Nature of Purchase will be displayed as Agent of Importer (Consignment Agent) as defined in the party ledger. This field defines the Supplier’s role in selling the product.
In Purchase Ledger field select Purchases @ 4% from the list of Ledger Accounts. VAT/Tax Class will be defaulted to Purchases @ 4%
In Name of Item field select Hot Rolled Coils form List of Excise Stock Items
In Quantity field enter 1,500 and Rate as 291.20. Amount will be calculated and displayed. Press Enter to view Excise Details screen
In the Excise Details screen,
RG 23D Entry No.: This number represents the display of this particular transaction in the relevant page of RG 23 D Register. Enter the RG 23 D entry number manually in the very first excise purchase voucher. The RG 23 D Entry no in the subsequent excise purchase vouchers are automatically incremental by 1 every time an item is selected in excise purchase invoice.
Note:
1. If an excise Purchase invoice is deleted/ cancelled/ marked as Optional, the RG 23 D Entry no used in it, will not be used in subsequent.
2. If an existing excise purchase transaction is duplicated, the RG 23 D Entry no will remain the same in both, the original and duplicate invoice and will not be incremental.
3. If an excise purchase invoice is inserted between two other excise purchase invoices, then the RG 23 D Entry no allotted for the stock items in the inserted invoice will be the latest in the sequence.
Supplier Invoice Details: Under this section specify the supplier invoice details
Supplier Invoice Number will be captured form the Supplier Invoice No. field if entered. Other wise enter the supplier Invoice number
By default the voucher date is displayed as Supplier Invoice Date
In PLA/ RG 23D Entry no. field enter the PLA number where the reference of duty paid on the goods sold are entered.
Enter Assessable Value (it is the amount on which the Excise Duty is calculated by the manufacturer) on which the Excise Duty is calculated. Enter Rs. 3,20,000
Duty Amount will be calculated and displayed automatically.
Manufacturer/Importer Invoice Details: Under this section specify manufacturer or importer invoice details
Invoice Number: By default the invoice number entered in the Party details screen for Manufacturer/ importer will be displayed
Invoice Date: By default the invoice date entered in Party details screen for Manufacturer/ importer will be displayed
PLA/ RG 23 Entry No: Enter PLA Number of the Manufacturer/ Importer. This number represents the transaction details of sales made to the supplier in the relevant page of PLA Register of manufacturer.
Billed Quantity: Enter the actual Billed Quantity sold to Agent of Importer
Assessable Value: Enter actual Assessable Value of the stock item
Duty Details: Duty Details displays Duty Amount calculated on the Assessable Value mentioned under Supplier Invoice Details.
Select Input VAT ledger to account the VAT paid on the purchases
Completed purchase voucher is displayed as shown
Press Enter to accept
On selling the goods purchased form Agent of Importer (Consignment Agent) in Rule 11 invoice, print title will be Sale by Consignment Agent
Record the Sales in Excise - Sales as shown
In Excise - Sales Invoice select the party as Decora Equipments
Select sales ledger
In Name of Item field select Hot Rolled Coils and in Supplier Details screen select the purchase bill of purchases made from Agent of Manufacturer and Quantity field enter the quantity sold. Here 1000 Kg is sold.
Select output VAT ledger - Output VAT @ 4% to account VAT on the sale
Completed Sales Voucher appears as shown
On Accepting the voucher the Rule 11 invoice generated appears as shown
