From Agent of Dealer is a supplier who acts as a commission agent of the First Stage Dealer. On sales made this suppliers issues only a commercial invoice and Rule 11 invoice is issued by the Dealer.
Tally.ERP 9 allows to record the excise purchases made from a commission agent of dealer and pass on the CENVAT Credit on Sale of Goods.
Example: On 4-5-2009 ABC Company purchased 5,000 Hot Rolled Coils @ 800 per Kg from Inland Traders who is a commission agent of Globus Steel Industries.
The above items were purchased from - Sterling Steel Industries (Manufacturer). The Assessable value to pay the Excise duty is Rs. 30,00,000)
Go to Gateway of Tally > Accounts Info. > Ledger
Enter the Name of the Supplier in the Name field e.g Inland Traders.
Select Sundry Creditors as the group name in the Under field.
Set Maintain Balances Bill by Bill to Yes and enter the Default Credit Period if any.
Set Inventory Values are affected to No
In the Mailing Details and Tax Information section enter the supplier contact details, Income Tax and the Sales Tax numbers.
Enable Set/Alter Excise Details to Yes to display the Excise Details screen.
In Excise Details screen enter the details as shown below
Press Enter to accept and save
Note: Commission Agent may be registered excise dealer or not. In this case Inland Traders is not a Excise Registered Dealer so the excise registration details are not provided.
Go to Gateway of Tally > Accounting Vouchers > F9: Purchase
Setup:
Set the option Allow Separate Buyer and Consignee Names to Yes
Note: It is must to enable the option Allow separate Buyer and Consignee Name is in F12: Purchase Invoice Configuration to specify the Excise Dealer name & address on behalf of whom the agent is making the sales.
In Excise - Purchase Voucher
Select the 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 4-5-2009
Enter the Supplier Invoice No. as IT/9580 and Date as 4-5-2009
By Default Tally.ERP 9 displays the Excise Unit as ABC Company as defined during voucher type creation.
Select the Party’s A/c Name from the list of Ledger Accounts e.g. Inland Traders
The Supplier’s Details sub-form will appear.
Enter the Dealer Name in Consignee field and enter other details like address, TIN/Sales Tax No., CST Number, Excise Registration Number, Range, Division and Commissionerate.
In Supplier field the name of the agent of the Dealer will be displayed along with address and other related information
In Manufacturer/Importer Details section, select the manufacturer from the goods were purchased by the Excise Dealer. For this purchase Inland 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 From Agent of Dealer 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 5,000 and Rate as 800. Amount will be calculated and displayed. and press Enter to view Excise Details screen
In Excise Details screen
Under Supplier Invoice Details
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 purchased 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 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 the Supplier Invoice Date. If required you can change.
In Supplier RG 23D Entry No. field enter the RG 23D number where the reference of the purchase of the goods is recorded.
Enter the Assessable Value (it is the amount on which the Excise Duty is calculated by the manufacturer) Rs. 30,00,000
Duty Amount will be calculated and displayed automatically.
Under Manufacturer/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 the Party details screen for Manufacturer/ importer will be displayed
PLA/ RG 23 Entry No : Enter the PLA Number of the Manufacturer/ Importer. This number represents the the display of 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 the First Stage Dealer
Assessable Value: Enter the actual Assessable Value of the stock item
Duty Details: Duty Details displays the Duty Amount calculated on the Assessable Value mentioned under Supplier Invoice Details.
Select Input VAT ledger - Input VAT @ 4% to account the VAT amount
The completed purchase voucher is displayed as shown
Press enter to accept.
Note: The purchases From Agent of Dealer will be equivalent to purchase made from First Stage Dealer. The Credit Pass On chain will continue as the buyer will be considered as the Second Stage Dealer.
On selling the goods purchased form From Agent of Dealer in Rule 11 invoice the print title will be Second Stage Dealer
Record the Sales in Excise - Sales as shown
In Excise - Sales Invoice select the party as Decora Equipments
Select the sales ledger
In Name of Item field select Hot Rolled Coils and in Supplier Details screen select the purchase bill of purchases made from Manufacturer Depot and Quantity field enter the quantity sold. Here 2100 Kg is sold.
select the out put 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
Note: In Supplier Name and Address box the Name and address of the Consignee (dealer) on be half of whom the goods were sold will be printed and not of the Agent of the Dealer.