Recording Excise Sales (Inclusive of Tax) (Excise for Manufacturer)

Excise sales transactions can be recorded with all required statutory details.

On this page:

Activating sales inclusive of tax in the stock item

Recording sales transaction inclusive of tax

On 07 April, 2015 ABC Company made a cash sale of two Oval Eyeglasses, model T1234. The sale value inclusive of cash was Rs.  6550.

To activate sales inclusive of tax in the stock item

1.    Click F12: Configure in the stock item master.

2.    Enable the option Allow inclusive of tax for stock items.

3.    Press Ctrl+A.

4.    Enable the option Is Inclusive of Duties and Taxes.

The stock item master appears as shown below:

To record the sales transaction inclusive of tax

1.    Go to Gateway of Tally > Accounting Vouchers > F8: Sales.

2.    Select ABC Company as the Tax Unit. The Excise Book Name and the Rule 11 Serial No are displayed automatically.

3.    Select Cash in the field Party's A/c Name.

4.    Select the Sales ledger.

5.    Select the stock item from the List of Stock Items.

6.    Enter the Godown and Quantity of stock item in the  Item Allocations screen.

7.    Enter the Rate (Inclusive of Tax).

Note: Enable the option Provide support for inclusive of tax for stock item rate to display Rate (Inclusive of Tax) as a column in the Item Allocations screen. This column will be displayed in the sales invoice screen too.

The rate of the stock item and amount get pre-filled in the Item Allocations screen. Note that using the rate inclusive of tax that has been entered, the sale value of the stock item has been back calculated.

8.    Press Enter.

9.    Select the Excise Duty ledger and Output VAT ledger.

10.  Click A: Tax Analysis to view the calculation of duties.

Based on the duty rates defined, excise duty and VAT have been calculated.

11.  Press Esc.

The completed sales transaction appears as below:

12.  Press Enter to save.