Select Your Language :

Journal Voucher Rounding Adjustments [Excise for Manufacturer] in Tally.ERP 9

While recording Excise Purchase and Sales transactions, at times the assessable value and the resultant Duty values appear in decimals when the option ‘Rounding Method’ is set as‘Not Applicable’ in the ledger masters. Due to this, while making the CENVAT Credit Adjustment entry, even the Adjustment Amount is in decimals.

However, the Central Board of Excise and Customs requires assessees to round off this Amount to the nearest rupee.

That is, if the Adjustment amount is `3762.62, it has to be rounded off to `3763.

For this, a new flag Rounding Adjustments has been provided in Journal Voucher in Tally.ERP 9 from Release 3.7 onwards.  The decimal amount of each Duty/CENVAT ledger can be rounded off using this flag.

To understand this feature let us execute the following steps.

  1. Record an Excise Purchase Invoice

Go to, Gateway of Tally > Accounting Vouchers > Purchase > Excise Purchase

Record an Excise Purchase invoice with the assessable value in Decimals. While recording, ensure that in the CENVAT Ledger Masters, the Rounding Method is set as Not Applicable.

The Excise Purchase Invoice is recorded as shown below:


Press Y to accept the entry.


  1. Record an Excise Sales Invoice

Go to, Gateway of Tally > Accounting Vouchers > Sales > Excise Sales

Record an Excise Sales Invoice with the assessable value in Decimals. While recording, ensure that in the Duty Ledger Masters, the Rounding Method is set as Not Applicable.

The Excise Sales Invoice is recorded as shown below:


Press Y to accept the entry.


  1. Create Duty Rounding Ledger under Indirect Expenses

Go to, Gateway of Tally > Accounts Info.> Ledgers > Create

  • Enter Duty Rounding in the Name field

  • Select the Group as Indirect Expenses in Under field


  • Press Ctrl+A to accept


  1. Record a Journal Entry with flag Rounding Adjustments

Go to, Gateway of Tally > Accounting Vouchers > Journal > select Voucher Class CENVAT Adjustment

  • Enter the voucher date

  • Select the flag Rounding Adjustments

  • Select the Excise Unit

Let us take the example of Basic Excise Duty – 16% ledger, used in the Excise Sales transaction, the amount being `1732.12. After round off the value should be `1732.

  • Select the ledger Basic Excise Duty CENVAT in Debit field

  • In the Excise Duty Allocation screen, select the required bill reference from the List of Pending Tax Bills

  • Enter the amount as `0.12 and press Enter

  • Credit the ledger Duty Rounding with amount as `0.12


  • Press Ctrl+A to accept

Similarly record Journal entries for other Duty/CENVAT ledgers. The ledger amounts appear rounded. Let us check the amounts in Accounts Books > Ledgers.

Go to Gateway of Tally > Display > Accounts Books > Ledgers > Basic Excise Duty – 16%


Observe, the closing balance is now rounded off to `1732.00

Now, while recording a Journal with CENVAT Adjustments flag, and using the Excise Helper option, the values of the CENVAT and Duty ledgers appear rounded.


Note:  To increase the amount of the duty payable ledger, Credit the ledger while recording the above journal entry. Similarly, to increase the CENVAT amount,Debit the CENVAT ledger with the required amount. To reduce the amount, reverse the step. That is, Debit the Duty payable ledger and Credit the CENVAT ledger.

Tally.ERP 9 Reference Manual LIBRARY
Installation of Tally.ERP9
Site Licensing of Tally.ERP9
Shortcut Keys in Tally.ERP9
Maintaining Company Data
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
Voucher Entry
Reports in Tally.ERP9
Excise for Dealer
Excise for Manufacturer
Reports [ Excise for Manufacturer]
Excise for Importer
Service Tax in Tally.ERP9
Tax Collected at Source (TCS) in Tally.ERP9
Tax Deducted at Source (TDS) in Tally.ERP9
Value Added Tax (VAT) in Tally.ERP9
Central Sales Tax (CST) in Tally.ERP9
GST using Tally.ERP9
Disclaimer :
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.
The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications