Friday, 28 June 2013
Thursday, 27 June 2013
Use of IF Command - Spreadsheet
In your day to day activities, start using IF command to get a desired response from number
Syntax
If( Condition, Action if True, Action if false)
Ex: I have a series of line itesm with slno in Column’B’, I want to know if there is any record missing. So I write this command in column ‘c’
=IF(B9=B8+1,"","Record Missing: "&B9-1)
Input function
Output
There could be multiple scenarios that you could use…
Monday, 24 June 2013
Thought for the day_25th June, 2013
THOUGHT FOR THE DAY Don't make your voice loud to make others listen to you…Make your attitude so loud that others want to listen to you 25th June, 2013 |
Sunday, 23 June 2013
Thought for the day_24th June, 2013
THOUGHT FOR THE DAY You need not feel guilty about not being able to keep your life perfectly balanced. Juggling everything is too difficult. All you really need to do is catch it before it hits the floor 24th June, 2013 |
Friday, 21 June 2013
Thursday, 20 June 2013
Structure and validation of PAN
- PAN structure is as follows: AAAAA9999A: First five characters are letters, next 4 numerals, last character letter.
- The first three letters are sequence of alphabets from AAA to zzz
- The fourth character informs about the type of holder of the Card.Each assesse is uniquely
-
- C — Company
- P — Person
- H — HUF(Hindu Undivided Family)
- F — Firm
- A — Association of Persons (AOP)
- T — AOP (Trust)
- B — Body of Individuals (BOI)
- L — Local Authority
- J — Artificial Judicial Person
- G — Government
- The fifth character of the PAN is the first character
- (a) of the surname / last name of the person, in the case of a "Personal" PAN card, where the fourth character is "P" or
- (b) of the name of the Entity/ Trust/ Society/ Organisation in the case of Company/ HUF/ Firm/ AOP/ BOI/ Local Authority/ Artificial Jurdical Person/ Govt, where the fourth character is "C","H","F","A","T","B","L","J","G".
- The last character is a alphabetic check digit.
Tuesday, 18 June 2013
Thought for the day_19th June, 2013
THOUGHT FOR THE DAY By communicating from your perspective you win other's mind. By communicating from other's perspective you win their heart 19th June, 2013 |
Friday, 14 June 2013
Detailed analysis of new TDS Section 194IA
Source : Notification No. 39/2013 dated 31/05/2013 and Finance Act, 2013 -
Amendments in Rules 10A, rule 10AB, rule 10B, rule 10C, rule 10D, rule 10E and Substitution Of Form NO.3CEB - Income-tax Rules, 1962
GOVERNMENT OF INDIA
MINISTRY OF FINANCE
DEPARTMENT OF REVENUE
[CENTRAL BOARD OF DIRECT TAXES]
Notification
New Delhi, the 10th June, 2013
INCOME-TAX
S.O 1491 (E) In exercise of the powers conferred by sub-sections (1) and (2) of section 92C, section 92D and section 92E read with section 295 of the Income-tax Act, 1961 (43 of 1961), the Central Board of Direct Taxes hereby makes the following rules further to amend the Income-tax Rules, 1962, namely:-
1. (1). These rules may be called the Income-tax (Sixth Amendment) Rules, 2013.
(2). They shall be deemed to have come into force with effect from the 1st day of April, 2013.
2. In rule 10A of the Income-tax Rules, 1962 (hereafter referred to as the principal rules), -
(i) for the figures and letter "10B", the figures and letters "10AB" shall be substituted;
(ii) the clause (a) shall be renumbered as clause (ab) and before the clause as so renumbered, the following clauses shall be inserted, namely: -
'(a) "associated enterprise" shall,-
(i) have the same meaning as assigned to it in section 92A; and
(ii) in relation to a specified domestic transaction entered into by an assessee, include ---
(A) the persons referred to in clause (b) of sub-section (2) of section 40A in respect of a transaction referred to in clause (a) of sub-section (2) of the said section;
(B) other units or undertakings or businesses of such assessee in respect of a transaction referred to in section 80A or, as the case may be, subsection (8) of section 80-IA;
(C) any other person referred to in sub-section (10) of section 80-IA in respect of a transaction referred to therein;
(D) other units, undertakings, enterprises or business of such assessee, or other person referred to in sub-section (10) of section 80-IA, as the case may be, in respect of a transaction referred to in section 10AA or the transactions referred to in Chapter VI-A to which the provisions of sub-section (8) or, as the case may be, the provisions of sub-section (10) of section 80-IA are applicable;
3. In rule 10AB of the principal rules, after the words "international transaction", the words "or a specified domestic transaction" shall be inserted.
4. In rule 10B of the principal rules, -
(i) for the words "an international transaction", wherever they occur, the words "an international transaction or a specified domestic transaction" shall be substituted;
(ii) for the words "the international transaction", wherever they occur, the words "the international transaction or the specified domestic transaction" shall be substituted;
(iii) for the words "international transactions", wherever they occur, the words "international transactions or specified domestic transactions" shall be substituted;
(iv) in sub-rule (1), in clause (d), in the proviso, for the words "type of international transaction", the words "type of international transaction or specified domestic transaction" shall be substituted.
(i) in sub-rule (1),-
(a) for the words "particular international transaction", the words "particular international transaction or specified domestic transaction" shall be substituted;
(b) after the words "in relation to the international transaction", the words "or the specified domestic transaction, as the case may be" shall be inserted.
(ii) in sub-rule (2), for the words "the international transaction", wherever they occur, the words "the international transaction or the specified domestic transaction" shall be substituted.
6. In rule 10D of the principal rules, -
(i) for the words "the international transaction", wherever they occur, the words "the international transaction or the specified domestic transaction" shall be substituted;
(ii) for the words "an international transaction", wherever they occur, the words "an international transaction or a specified domestic transaction" shall be substituted;
(iii) in sub-rule (1),-
(a) in clause (b), after the words "with whom international transactions", the words "or specified domestic transactions, as the case may be," shall be inserted;
(b) in clause (d), after the words "international transactions", the words "or specified domestic transactions" shall be inserted;
(c) in clause (f), after the words " the international transactions", the words "or the specified domestic transactions" shall be inserted;
(d) in clause (g),−
(II) after the words "pricing of the international transactions" occurring at the end, the words "or specified domestic transactions, as the case may be" shall be inserted;
(iv) in sub-rule (2), for the words, brackets and figure "Nothing contained in sub-rule (1) shall", the words, brackets and figure "Nothing contained in sub-rule (1), in so far as it relates to an international transaction, shall" shall be substituted;
(v) in sub-rule (3), in clause (e), after the words "international transactions", the words "or the specified domestic transactions, as the case may be" shall be inserted;
(vi) in sub-rule(4), in the proviso, after the words "terms of the international transaction", the words "or the specified domestic transaction, as the case may be" shall be inserted.
7. In rule 10E of the principal rules, after the words "international transaction", the words " or a specified domestic transaction" shall be inserted;
Thursday, 13 June 2013
Thought for the day_14th June, 2013
THOUGHT FOR THE DAY
Always be on the lookout for new ways to do old things, and keep your mind open to using alternative methods and plans of action
14th June, 2013
|
Wednesday, 12 June 2013
Thought for the day_13th June, 2013
THOUGHT FOR THE DAY
Everything in life is valuable and precious only at two times.
First before getting it and Second after losing it. Otherwise the same has no value
13th June, 2013
|
Edit PDF content in Word
Do you know you can open PDF Files in the word document also?
Here is the solution : Open PDFs and edit the content in Word. Edit paragraphs, lists, and tables just like familiar Word documents. Take the content and make it look great.
Download this helpful PDF from the Office site to try in Word or pick a PDF file on your computer. In Word, click File > Open and navigate to the PDF. Click Open to edit the content or read it more comfortably using the new Read Mode.
Tuesday, 11 June 2013
Place of Provision of Services Rules [ Including issues]
Sl. no.
|
Relevant Rule
|
Situations
|
Place of provisions of Service
|
1
|
3
|
On General basis
|
<![if !supportLists]>- <![endif]>Location of service receiver
<![if !supportLists]>- <![endif]>if the location of the service receiver not available in the ordinary course of business - the location of the service provider.
|
2
|
4
|
Performance base services:
| |
a)
|
Services provided in respect of goods that are required to be made physically available by the service receiver to the service provideror to a person acting on behalf of the provider of service
Proviso – when services are provided from a remote location by way of electronic means
|
Location at which services are actually performed by service provider
Location at which the goods are situated at the time of provision of service.
| |
b)
|
Services provided entirely or predominantly, in the ordinary course of business, in the physical presence of an individual, represented either as the service receiver or a person acting on behalf of the receiver
|
Location at which services are actually performed by service provider.
| |
3
|
5
|
Services provided directly related to an Immovable property including
<![if !supportLists]>- <![endif]>services of experts and estate agents,
<![if !supportLists]>- <![endif]>provision of hotel accommodation by a hotel, inn, guest house, club or campsite, by whatever, name called,
<![if !supportLists]>- <![endif]>grant of rights to use immovable property,
<![if !supportLists]>- <![endif]>services for carrying out or co-ordination of construction work, including architects or interior decorators
|
Location of the immovable property located or intended to be located.
|
4
|
6
|
<![if !supportLists]>- <![endif]>Admission and its ancillary services pertaining to events;
<![if !supportLists]>- <![endif]>Organization of events
|
Location where the event is actually held.
|
5
|
7
|
Multiple location based services where one of the location is in taxable territory.
|
Location of taxable territory where the greatest proportion of service is provided.
|
6
|
8
|
Where service provider and receiver are located in the taxable territory
|
Location of the service receiver
|
7
|
9
|
For specified services
<![if !supportLists]>- <![endif]>Services provided by a Banking Company, Financial Institution, Non Banking Financial Company
<![if !supportLists]>- <![endif]>Online information and database access or retrieval services
<![if !supportLists]>- <![endif]>Intermediary services
<![if !supportLists]>- <![endif]>Services consisting of hiring of means of transport, upto a period of one month
|
Location of the service provider
|
8
|
10
|
Goods Transport Services
|
Place of destination of goods.
However, for goods transport agency, the place of provision of service shall be the location of the person liable to pay tax.
|
9
|
11
|
Passenger Transport Services
|
Place where the passenger embarks on the conveyance for a continues journey
|
10
|
12
|
Services provided on a board a conveyance
|
First scheduled point of departure of that conveyance for the journey
|