Microsoft provided some very good documentation with hot-fixes of NAV 4.0 SP3 and release it within the hot-fixes. With NAV 2009 and NAV 2009 SP1 no documentation was included and they can be downloaded from Partner Source or Customer Source. That had led me to write a few details on some common functionality so everybody can use them. I will start with Excise Settlement procedure.

Microsoft has included some very useful fields in the 2009 i.e. RG/Service Tax Setoff Date and PLA Setoff Date.

The post assumes that you know how to post sales and purchase invoice with Excise values and also how to make payment in PLA account. In case you need me to explain the procedure, write a comment and I will include in my next blog.

Open the Bank Payment Voucher having the following fields (In case the fields are not available then insert them through Form Designer):

a)      E.C.C. No.

b)      RG/Service Tax Setoff Date

c)       PLA Setoff Date

Select the G/L account where excise payable entries have been posted. Fill the following Fields:

a)      Posting Date : Posting Date of Voucher. In this case I am taking as 05/02/11 (DD/MM/YY).

b)      RG/ServiceTax Set Off Date: Date upto which the RG credit entries and Excise Payable entries have to be taken. Normally it is the last date of the month for which settlement has to be made. In my case it will be 31/01/11 because I am making settlement for the month of Jan 2011.

c)       PLA Setoff Date : Date upto which the PLA entries have to be taken. Indian Excise law allows the company to deposit the excise amount upto 5^th of next month. So in case some PLA amount has been deposited in current month and the amount has to be used for settling the due of last month, then current date needs to be given . In my case I am taking 05/02/11.

d)      E.C.C. No. : ECC no. of location for which excise settlement has to be done. In case we have multiple excisable units then multiple entries needs to be posted. One entry will do the settlement of One Location only.

e)      Account Type : Account Type should be G/L Account.

f)       Account No. : Excise Payable account for the location.

Click on Payments Tab – Tax Payments – Excise

The following Form will be opened. This will show all the entries outstanding for settlement upto the date of RG/Service Tax Setoff Date.

Click on Apply Entries button in the bottom:

 

 Click in Detail Button in the bottom.  This will open the following screen

The left side of the screen shows the components, liability and remaining liability. Remaining Liability will show the unadjusted amount of duty payable.

The screen will have 3 tabs

a)      RG 23 A Part II

b)      RG 23 C Part II

c)       PLA

Each tab will show the available credit in the respective group. 

The first Row in the matrix will be “Credit Available” which will show the credit available under the component.

In case you need to use a input component for settling duty payable under other component like BED in RG 23 A part II to adjust payable under E-cess then relevant rules has to be defined in the setup under “Claim Setoff”.

Now you can fill the values in the component by using various tabs and the remaining liability should become zero for all the components (except when you have service tax credit available which you want to use for settlement).  After filling the screen should look like this:

Note that the remaining Liability has become zero for all the components. 

Now press escape which will bring you to the earlier screen with a difference:

The values of RG 23 A, RG 23 C , PLA has been filled adjacent to Excise Payable.

Again press escape and you will be come on the Bank Payment Voucher screen.  The values will be filled automatically and the voucher will seems to be out of balance

You need not modify anything but simply press post. System will automatically insert the balance account.

That will be it. We are done. You can check the posted entries.

I don’t understand why Microsoft has provided the link of Excise Settlement in the Bank Payment Voucher though the voucher never involves any Bank Account. I normally customize the Journal Voucher Form to include the option.