Mistakes committed by assessees noticed by CPC

Following are some of the common mistakes that has been identified by the Income Tax Department -CPC 

1. Gender Mismatch
2. Refund claim is more than Rs.25,000/- and the assessee has not filed any balance sheet or profit and loss account.
3. Audit Information not filled up
4. Brought Forward loss has been filled but Carried Forward details are not filled.
5. Wrong business codes in ITR 4S
6. Non filing of gross receipts in P&L Schedule but showing a positive figure during computation of income.

and so on.......

read more at http://220.227.161.86/27063ICAIDTC-ITDCPC.pdf

Family Arrangement

Family arrangement is a transaction between the family members for the benefit of the family. The term family has not been defined under any act, but a vast meaning is provided by the courts by way of judgement. It is an attempt to sink in the differences and settle without the interference of a court or a third party and to maintain the peace and prestige of the family. 

Why Family Arrangement?
Family arrangement is a compromise between the parties where everybody in the said family have a WIN-WIN situation. It saves a lot of time and money, and mainly restores the peace and reputation of a family.




So is it same as Partition of an HUF?
No, Partition of a HUF is different from that of the family arrangement. After a family arrangement the HUF might get partitioned or not, depends upon case to case.


Eg for Family arrangement but not partition of HUF: 
Mr.X is looking after an ancestral property. It was acquired by the government for expansion of road under compulsory acquisition. There is money now in the hands of Mr.X. The family also holds a number of other properties. A family arrangement can be entered into to share the cash received on compulsory acquisition and not to share the other properties. Hence, the HUF still isn't partitioned and holds the other properties. 


Whether family arrangement needs to be registered?
Again this depends from case to case. But one point to be noted is that the family arrangement can be even orally done. Remember the cinemas where the head of the panchayath gives a ruling on distribution of property and all the family member accept. As long as the family arrangement is done is good faith there is no requirement of it being registered.


Does a family arrangement lead to capital gains and in turn is tax needed to be paid to the government?
The term transfer defined in the income tax act does not include family arrangements, logically also there is no transfer of property though there is transfer of ownership. However, these transactions to be called family arrangement needs solid proof. and the transactions needs to be planned properly to save taxes. Ask a CA or a tax practitioner to help you in these cases.


One advice from our team is that if at all you have a family arrangement and get a share in the property by way of cash/cheque, open a bank account in the name of your HUF and deposit it there. Any investments again can be done from the account only to which you will be the karta. This will serve as a tax saving measure to all of you.


Suggestions and Queries welcome.


Contact us at mrpraveen@live.com or post your query on our facebook wall.

Build your own EMI Table in Microsoft Excel

Greetings reader,

This post explains you how to build your own EMI table in Microsoft Excel.

There is a formula in Excel called PMT - It will calculate the EMI payable per month. 

Screenshot 1.1 - Formula "PMT"

In the above screenshot you can see the requirements of the formula PMT

(1) RATE

• It is the rate of interest of the loan. 
• Rate should be per installment. i.e. if installment is payable monthly then rate must be rate per annum / 12 months. If rate of interest per annum is 12% then rate per  month is 1%.

(2) NPER

• Nper refers to the number of installments. 

(3) PV

• Present Value of money or the amount borrowed.

(4) FV

• In an EMI calculation generally the amount at the end of payment of all installments is '0'. If you want some balance to remain at the end of the tenure you need to type in such amount in the FV field.

(5) Type

Value	Explanation
0	Payments are due at the end of the period. (default)
1	Payments are due at the beginning of the period.

The screenshot below is an example by which you can create an EMI Table

The formulas used in the above screenshot are as follows

Hope you can now create your own EMI Table.

Rule of 72

Rule of 72, Rule of 70 & Rule of 69 are a few vedic mathematics techniques used to find out approximately when investment doubles at a given rate of interest.

The Rule of 72/70/69 are applied in the following manner:-
Numerator is always 72/70/69
Denominator is the rate of interest p.a.


But many of the financial wizards find the Rule of 72 most convenient as it can be divided by a number of small numerals like 2,3,4,6,8 & 9


For Example:-

You have a Principle of Rs.10,000.
Rate of Interest = 9% per annum
by applying rule of 72 we get 72/9 = 8 years
Actually it doubles at 8.043 years
so very close.

Further suggested reading about the RULE OF 72 Click on this link

Unique problem with unique TDS Certificate No.

People who have been filing the income tax returns for the AY 2012 - 2013 will all be facing this unique problem with the TDS certificate No.

If you notice in the income tax return we will have to specify the TDS Certificate No. in case of tax deducted at source other than on salary. i.e. in case of Form 16A.

Here we need to enter 8 digits whereas when receiving the Form 16A we get the forms with 6 digits.

The screenshot of the Income tax form and the TDS 16A Certificate is shown below

Picture courtesy: Simpletaxindia.net

Even in the schema for filing income tax return online we will have to specify 8 digits otherwise it shall not allow filing of returns.

So what is the solution for this problem?
Practioners are following this method to solve the problem, but we do not endorse this in our article. They are using 00 before the 6 digits to make it 8 digits.

In case you guys have any other alternatives please share with us.

CARO 2003: Applicability

We have observed that there is a big question on applicability of CARO in the minds of students and professionals esp. for a private company.


So we have decoded the applicability quotient in this article. By reading this I hope you will never forget when to apply CARO and when not to. In case you forget, you always know where to come searching right!!!

"This is what CARO 2003 says about applicability"

The first three clauses are very much self-explanatory and does not have much ambiguity in it. But the problem starts with the (iv) applicability for a private limited company.


Lets break this up further


So for a private limited company --> CARO will not be applicable --> when the following conditions are satisfied.


a) Paid up capital + Reserves are not more than Rs.50 Lakhs 
b) Loan outstanding from bank of financial institution is not more than Rs.25. Lakhs 
c) Turnover does not exceed Rs.5 Crores 


Now arises a question whether all the conditions must be satisfied?


Yes, the clauses are cumulative they have used the word 'and'  & not 'or'.

Hence, ALL THE CONDITIONS MUST BE SATISFIED FOR CLAIMING EXEMPTION
or EVEN IF ONE CONDITION ABOVE IS NOT SATISFIED CARO IS APPLICABLE.

HRA Calculator

   HOUSE RENTAL ALLOWANCE (HRA)

Dependent on the following factors: a)      Place of employment b)      Salary received c)       Rent Paid d)      HRA Received Calculation of HRA is as follows Least of: a)      Actual HRA received b)      50% of the salary (metros: Delhi, Kolkatta, Chennai, Mumbai) 40% of the salary (others) c)       Rent paid in excess of 10% of salary SALARY = BASIC PAY + DEARNESS ALLOWANCE                 Essentials for claiming the HRA Deduction a)      HRA should be a part of the salary b)      Rent must be paid by the employee ·         Rent receipts are required ·         If you are paying any amount to your parents and staying in their house not to worry you can show that as rent as well. (but consider taking an advice before taking this step) ·         If no rent is paid then no deduction