Wednesday, November 16, 2011

PPF ( Providend Fund)

What is the Public Provident Fund?
PPF is a long-term, government-backed small savings scheme of the Central government started with the objective of providing old age income security to the workers in the unorganised sector and self-employed individuals.

What is the interest rate offered through PPF?

Currently, the interest rate offered through PPF is around 8 per cent, which is compounded annually. Interest is calculated on the lowest balance between the fifth day and last day of the calendar month and is credited to the account on March 31 every year. So to derive the maximum, the deposits should be made between 1st and 5th day of the month.


What is duration of the investment?
People who are interested in liquidity or small-term gains would not be very keen about PPF because the duration for the investment is 15 years.
However, the effective period works out to 16 years i.e., the year of opening the account and adding 15 years to it. The contribution made in the 16th financial year will not earn any interest but one can take advantage of the tax rebate.
The account holder has an option to extend the PPF account for any period in a block of five years after the minimum duration elapses. The account holder can retain the account after maturity for any period without making any further deposits.
The balance in the account will continue to earn interest at normal rate as admissible on PPF account till the account is closed.


What is the minimum and maximum amount of deposit?
The minimum deposit that you can make into a PPF account in a year is Rs 500. The maximum is Rs 70,000.


Who can open a PPF account and where?
A PPF account can be opened by an individual (salaried or non-salaried) on his own behalf or on behalf of a minor of whom he is the guardian or on behalf of a Hindu Undivided Family (HUF) of which he is a member or on behalf of an association of persons or a body of individuals. An individual can open only one account for himself.
A PPF account can be opened with a minimum deposit of Rs 100 at any branch of the State Bank of India  or branches of its associated banks like the State Bank of Mysore or Hyderabad. The account can also be opened at the branches of a few nationalized banks, like the Bank of India, Central Bank of India and Bank of Baroda , and at any head post office or general post office.


What are the tax benefits from PPF?
The amount you invest is eligible for deduction under the Rs 100,000 limit of Section 80C. On maturity, the entire amount including the interest is non-taxable.


Is it possible to withdraw the amount deposited at any time during the tenure?
Yes. You can take a loan on the PPF from the third year of opening your account to the sixth year. So, if the account is opened during the financial year 2009-10, the first loan can be taken during financial year 2011-12 (the financial year is from April 1 to March 31).
The loan amount will be up to a maximum of 25 per cent of the balance in your account at the end of the first financial year. You can make withdrawals during any one year from the sixth year.
You are allowed to withdraw 50 per cent of the balance at the end of the fourth year, preceding the year in which the amount is withdrawn or the end of the preceding year whichever is lower. For e.g., if the account was opened in 2000-01, and the first withdrawal was made during 2006-07, the amount you can withdraw is limited to 50 per cent of the balance as on March 31, 2003, or March 31, 2006, whichever is lower.


What are the differences and similarities between the National Savings Certificate (NSC) and PPF?

National Savings Certificate (NSC)
Public Provident Fund (PPF)
Interest Paid: 8%, compounded half-yearly Interest Paid: 8%, compounded annually
No monthly/yearly payments No monthly/yearly payments
Minimum investment: Rs 100

Maximum investment: No Limit
Minimum investment: Rs 500 (required annually)

Maximum investment: Rs 70,000
Duration of investment: 6 years Duration of investment: 15 years
Can be used as a security for mortgage and other purposes Cannot be used for such purposes
Tax benefit under Section 80 'C' available.

Maximum limit: Rs 100,000
 
Tax benefit under Section 80 'C' available.

Maximum limit: Rs 70,000 (limit of the investment in PPF)
Good medium-term investment option Good long-term investment option

Monday, November 14, 2011

Procedure for e-Payment of Excise & Service Tax

1. To pay Excise Duty and Service Tax online, the assessee has to enter the 15 digit Assessee Code allotted by the department under erstwhile SACER/SAPS or the current application ACES.


2. There will be an online check on the validity of the Assessee Code entered. 

3. If the Assessee code is valid, then corresponding assessee details like name, address, Commissionerate Code etc. as present in the Assessee Code Master will be displayed. 


4. Based on the Assessee Code, the duty / tax i.e. Central Excise duty or Service Tax to be paid will be automatically selected


5.The assessee is required to select the type of duty / tax to be paid by clicking on Select Accounting Codes for Excise or Select Accounting Codes for Service Tax, depending on the type of duty / tax to be paid.

6. At a time the assessee can select up to six Accounting Codes.

7. The assessee should also select the bank through which payment is to be made.
 
8. On submission of data entered, a confirmation screen will be displayed. If the taxpayer confirms the data entered in the screen, it will be directed to the net-banking site of the bank selected.

9 . The taxpayer will login to the net-banking site with the user id/ password, provided by the bank for net-banking purpose, and will enter payment details at the bank site.

 10.On successful payment, a challan counterfoil will be displayed containing CIN, payment details and bank name through which e-payment has been made. This counterfoil is proof of payment made.

ACES- Central excise & Service Tax challans

eFiling Offline Utilities/Schema

Assessees can file their Central Excise and Service Tax Returns using following offline Excel Utilities/XML Schema by downloading the same from this page.
It is advised that the latest Excel Utility may be used every time, for filing Returns, by downloading it from the link given below
Click on the respective Excel Utility/XML Schema hyperlink to download. Please refer the detailed Instructions Sheet embedded within the utility before using the same.


Central Excise
Excel Utilities Last Updated XML Schema Last Updat
Download ER1 Return Excel Utility 01-10-2011
Download XML Schema for ER1 Return
01-10-2011
01-10-2011
01-10-2011
Download ER3 Return Excel Utility 01-10-2011




Download ER4 Return Excel Utility
01-10-2011





Download ER5 Return Excel Utility 01-10-2011





Download ER6 Return Excel Utility 01-10-2011




Download ER8 Return Excel Utility 01-10-2011



Download Dealer Return Excel Utility 01-10-2011 Download XML Schema for Dealer Return

01-10-2011






                                                                             Service Tax
                                     Excel Utilities
Last Update

Download ST3 Return Excel Utility

01-10-2011



Learning Management Software (LMS)
Click on the respective hyperlink to down-load Learning Management Software (LMS) for Assessees, a self learning training software.
- Central Excise
GAR7 Challans
Click on the respective hyperlink to down-load GAR7 Challans.
- Central Excise ( Front || Reverse )
- Service Tax ( Front || Reverse )

GAR7 Challans

GAR7 Challans


Click on the respective hyperlink to down-load GAR7 Challans.
- Central Excise ( Front || Reverse )
- Service Tax ( Front || Reverse )








  

- Central Excise ( Front || Reverse )
- Service Tax ( Front || Reverse )
  

The Vlookup function on Excel

  • The Vlookup function (finding an exact match):



Building the function step by step:
1. Type the following code: =vlookup(
2. Type the address of the cell containing the value that you wish to look for in the table.
3. Type the range of the table to look inside, (or better: Name the table before starting with the function, and type now its name). Remember: don’t include the table’s heading row.
4. Type the column number from which you want to retrieve the result.
5. Type the word FALSE which means: “Please find me exactly the value of the cell mentioned in step 2. (Don’t round it down to the closest match)”.
6. Close the bracket and hit the [Enter] key.

Note: The function will always look for the value mentioned on step 2 only on the first column (the utmost left column) of the table.


Vlookup Examples:
Let’s assume you are using the following Excel worksheet: (You can download it here)
A table with data with a student name to look for

=vlookup(C10,A2:E7,2,FALSE)
In words: Look for the value in cell C10 inside table located at A2:E7, and retrieve me the value on the 2’nd column. Please find me exactly what’s in cell C10.

The value of the above formula will be: 99 (on Dan’s row, the second column).


Copying and replicating the function
If you plan on copying the vlookup function, either by “copy” and “paste” or by dragging it with the fill handle, make sure to set the table’s address with fixed reference (e.g. $A$2:$E$7), but it would be better instead to name the table, as in the following example.

You can name the range A2:E7 by selecting it, and typing the name in the name box.
Let’s assume you named it studentsTable (spaces are not allowed, but you may use underscores).

=vlookup(c10,studentsTable,3,false)
In words: Look for the value in cell C10 inside studentsTable, and retrieve the value from the table’s 3’rd column. Please find me exactly what’s in cell C10.

The value of the above function will be: 45 (on Dan’s row, the value in the third column of the table).


Troubleshoot (advanced usage with more functions)
If the vlookup doesn’t find a match, it will write the following code: #N/A.
You can overcome this code, and set what do display in case it doesn’t find a value by using the IF function with the ISNA() function. Look at the following example:

=if(isna(vlookup(c10,studentsTable,3,false)),”didn’t find any match”, vlookup(c10,studentsTable,3,false))
In words: if the vlookup function gives us the #N/A code, then write “didn’t find any match”, else compute the vlookup function.

Explanation:
The 3 parts of the above IF function are:
1. isna(vlookup(c10,studentsTable,3,false))
2. “didn’t find any match”
3. vlookup(c10,studentsTable,3,false)

The first part is a condition, which says: Does the vlookup function gives us the #N/A code?
If it does, write “didn’t find any match”, otherwise compute the vlookup function.

Tip:
Instead of the part “didn’t find any match”, you can put only double quotation marks “” which will leave the cell empty in case no match is found:
=if(isna(vlookup(c10,studentsTable,3,false)),””, vlookup(c10, studentsTable,3,false))

or let it retrieve the value 0 in case of no match:
=if(isna(vlookup(c10,studentsTable,3,false)),0, vlookup(c10, studentsTable,3,false))



  • The Vlookup function - closest match


Building the function step by step:
This is exactly the same process as building the vlookup with exact match, but with the following difference: Instead of writing FALSE at the end of the function, write TRUE.

Example:
Let’s assume you have the following worksheet, and the table is named “sales_table”:

A table for using vlookup function with closest match

=vlookup(B10,sales_table,2,true)
In words: find me the value of cell B10 inside the first column of sales_table, and retrieve me the value next to it from the table’s second column. If you don’t find the value, relate to the closest smaller value you can find.

Hence, the value 14 doesn’t appear on the first column of the table, so the function will relate to the value 10 which is the closest smaller value, and retrieve the word “medium” from the second column.

If the value of cell B10 was changed to 90, the vlookup would return us the word “Great” (the closest smaller match it finds would be 50).



  • Getting Rid of the Vlookup #N/A Error Code

 

When the vlookup function doesn’t find the value inside the range specified, it will write the #N/A code, meaning “Not Available”.

To get rid of this error code, you can put the vlookup inside an IF function together with the ISNA function in the following format:

=If (isna (vlookup(blabla)) , “”, vlookup(blabla))

In words:
If the vlookup function is N/A, then leave the cell blank, otherwise perform the vlookup function.

(It is recommended that you be familiar with the If Statement before you proceed.)


An Example (taken from the related video):

=If(isna(vlookup(D9,oldList,2,false)),””,vlookup(D9,oldList,2,false))

(Note the double parenthesis after the word “false” in both of its occurrences)

Let’s cut the above function into three parts, and examine them one by one:

First part:
=If(isna(vlookup(D9,oldList,2,false)),
In words:
If the function vlookup(D9,oldList,2,false) gives N/A - (this will happen if it didn’t find the value of cell D9 inside oldList),


Second part:
“”,
In words:
Then leave the cell blank (double quotation marks mean “blank”)

Third part:
vlookup(D9,oldList,2,false))
In words:
Otherwise perform the vlookup as usual.

 

E-filing of Service Tax Returns (ST-3)

E-filing of Service Tax Returns (ST-3) made mandatory for All Assessees wef 01.10.2011 vide Notification No. 43/2011 - Service Tax, dated 25.08.2011 (click here for Notification)

E-filing of Central Excise Returns

E-filing of Central Excise Returns (ER1,ER-2,ER-3,ER-4,ER-5,ER-6, ER-7 & ER-8) made mandatory for All Assessees wef 01.10.2011 vide Notification No. 21/2011 and No. 22/2011 - Central Excise, both dated 14.09.2011 (click here for Notification No. 21/2011)    (click here for Notification No. 22/2011)



here is the link for downloading(ER1,ER-2,ER-3,ER-4,ER-5,ER-6, ER-7 & ER-8) files
(http://www.aces.gov.in/download.jsp)




GAR7 Challans


Click on the respective hyperlink to down-load GAR7 Challans.
- Central Excise ( Front || Reverse )
- Service Tax ( Front || Reverse )
  

Central Excise Bangalore Contact information

Office of the Commissioner of Central Excise
Zone ADDRESS Phone No. Fax No. Email ID
Bangalore - I P.B. No. 5400, Central Revenue Building, Queens Road, Bangalore - 560001. +91-80-2286 4073 +91-80-2286 4170 cexbang@excise.nic.in
Bangalore - II P.B. No. 5400, Central Revenue Building, Queens Road, Bangalore - 560001. +91-80-2286 5331 +91-80-2286 4426 cexbang2@excise.nic.in
Bangalore - III P.B. No. 5400, Central Revenue Building, Queens Road, Bangalore - 560001. +91-80-2286 7733 +91-80-2286 0354 cexbang3@excise.nic.in

Tuesday, November 8, 2011

ELECTRONIC ACCOUNTING SYSTEM IN EXCISE AND SERVICE TAX

Introduction

Central Board of Excise and Customs (CBEC) initiate to receive information and maintain records of tax paid through banks through online upload of challan details is named as EASIEST ( Electronic Accounting System in Excise and Service Tax ).

Data uploaded by banks

CBEC has devised the file formats for uploading data regarding tax payment. Banks are expected to generate and upload tax data as per these formats.

Once the file has been prepared as per the file format, it can be verified for correctness of its structure using the File Validation Utility (FVU) provided by NSDL.

Single copy challan for excise and service tax

From April 2007 onwards assessees should pay tax using the single copy challan, GAR-7 instead of earlier four copies.

Challan status enquiry

Assessees can track online the status of their challans deposited in banks. The status can be tracked on the basis of the Challan Identification Number (CIN) which is stamped on the challan counterfoil by the bank. CIN comprises of seven-digit BSR code of collecting bank branch, challan serial number (upto five digits) and date of tender.

Assessee Code based search

This facility enables the assessee view its details (name, address, location code) as present in the Assessee Master provided by CBEC. Details of assessee codes allotted for service tax and excise can be viewed using this facility.