𝟓𝟎 𝐄𝐱𝐜𝐞𝐥 𝐒𝐡𝐨𝐫𝐭𝐜𝐮𝐭𝐬 𝐰𝐢𝐭𝐡 𝐀𝐥𝐭 𝐊𝐞𝐲!👨💼
𝐋𝐞𝐭'𝐬 𝐥𝐞𝐚𝐫𝐧 𝐬𝐨𝐦𝐞 𝐜𝐨𝐨𝐥 𝐀𝐥𝐭 𝐄𝐱𝐜𝐞𝐥 𝐬𝐡𝐨𝐫𝐭𝐜𝐮𝐭𝐬:
1. Alt + A - To go to the Data tab on the Ribbon
2. Alt + A + G + G - Group cells
3. Alt + A + U + U - Ungroup cells
4. Alt + A + W - What if Analysis
5. Alt + A + W + G - Goal Seek
6. Alt + A + V + V - Data Validation
7. Alt + A + M - Remove duplicates
8. Alt + E + S - Paste Special
9. Alt + E + S + F - Paste Special Formulas
10. Alt + E + S + V - Paste Special Values
11. Alt + H - To access the Home tab on the Ribbon
12. Alt + F - To access to the File tab on the Ribbon
13. Alt + P - To access to the Page Layout tab on the Ribbon
14. Alt + JI - To access the Draw tab on the Ribbon
15. Alt + R - To access the Review tab on the Ribbon
16. Alt + Q - To go to the Search bar
17. Alt + N - To access the Insert tab on the Ribbon
18. Alt + N + R - Recommended charts
19. Alt + N + V + T - Creates Pivot Table
20. Alt + N + T - To create Table
21. Alt + N + Q - To Insert Pie chart
22. Alt + N + C1 - To Insert Column or Bar chart
23. Alt + N + N1 - To insert Line or Area Chart
24. Alt + N + I2 - To insert Hyperlink
25. Alt + W - To access the View tab on the Ribbon
26. Alt + W + L - Normal Page View
27. Alt + W + I - Page Break Preview
28. Alt + W + P - Page Layout
29. Alt + W + VG - To show/hide the Gridlines
30. Alt + W + W - To Switch windows
31. Alt + L - To go to the Developer tab
32. Alt + L + R - To Record Macros
33. Alt + L + PM - To View Macros
34. Alt + M - To access to the Formulas tab on the Ribbon
35. Alt + M + D - To Trace Dependents
36. Alt + M + P - To Trace Precedents
37. Alt + M + A - Remove Arrows
38. Alt + M + A + P - To Remove Precedent Arrows
39. Alt + M + A + D - To Remove Dependent Arrows
40. Alt + M + H - To show Formulas
41. Alt + M + U + S - AutoSum
42. Alt + = - Sum Function
43. Alt + M + U + A - Average Function
44. Alt + M + U + C - Count Numbers
45. Alt + M + U + M - Maximum Function
46. Alt + M + U + I - Minimum Function
47. Alt + M + I - Financial Functions
48. Alt + M + L - Logical Functions
49. Alt + M + T - Text Functions
50. Alt + M + O - Lookup and Reference Functions
Contributed by Swathi Reddy🖊️
Bookmark and follow @CAclubindia for more such updates!
21 Deductions a Taxpayers can Claim while Filing Income Tax Returns
1) Section 80C is one of the most popular and favourite sections amongst taxpayers. It allows a maximum deduction of Rs 1.5 lakh every year from the taxpayer's total income.
Some Investment / Expenditure are
Life insurance premium for the policy
ELSS funds
NPS Scheme
ULIP
Tax saving FD
PPF - Public Provident Fund Account
Senior citizen savings scheme
National Savings Certificate
Sukanya Samriddhi Yojana
Certain payments for purchase/construction of residential house property
Tuition fees
Post Office Time Deposit Rules etc
2) Section 80CCD (1B) Investments of up to Rs.50,000 in NPS.
3) Section 80GG – Income Tax Deduction on House Rent Paid
Section 80GG deduction is available for rent paid when HRA is not received.
a. Rent paid minus 10% of adjusted total income
b. Rs 5,000/- per month
c. 25% of adjusted total income
4) Section 80E – Interest on Education Loan
A deduction is allowed to an individual for interest on loans taken for pursuing higher education. This loan may have been taken for the taxpayer, spouse or children or for a student for whom the taxpayer is a legal guardian.
80E deduction is available for a maximum of 8 years (beginning the year in which the interest starts getting repaid) or till the entire interest is repaid, whichever is earlier. There is no restriction on the amount that can be claimed.
5) Section 80D – Deduction on Medical Insurance Premium
Claim a deduction of Rs.25,000 under on insurance for self, spouse and dependent children. An additional deduction for insurance of parents is available up to Rs 25,000, if they are less than 60 years of age. If the parents are aged above 60, the deduction amount is Rs 50,000
In case, both taxpayer and parent(s) are 60 years or above, the maximum deduction available under this section is up to Rs.1 lakh. From FY 2015-16 a cumulative additional deduction of Rs. 5,000 is allowed for preventive health check.
6) Section 80DD – Deduction for Medical Treatment of a Dependent with Disability
Section 80DD deduction is available to a resident individual or a HUF and is available on:
a. Expenditure incurred on medical treatment (including nursing), training and rehabilitation of handicapped dependent relative
b. Payment or deposit to specified scheme for maintenance of handicapped dependent relative.
i. Where disability is 40% or more but less than 80% – a fixed deduction of Rs 75,000.
ii. Where there is a severe disability (disability is 80% or more) – a fixed deduction of Rs 1,25,000.
7) Section 80DDB – Deduction for Specified Diseases
A deduction up to Rs.40,000 is available to a resident individual any expense incurred towards treatment of specified medical diseases or ailments for himself or any of his dependents.
In case the individual on behalf of whom such expenses are incurred is a senior citizen, the individual or HUF taxpayer can claim a deduction up to Rs 1 lakh
8) Section 80U – Deduction for Disabled Individuals
A deduction of Rs.75,000 is available to a resident individual who suffers from a physical disability (including blindness) or mental retardation. In case of severe disability, one can claim a deduction of Rs 1,25,000.
9) Section 80G – Income Tax Benefits Towards Donations for Social Causes
Donations with 100% deduction or 50% deduction depends upon the Trust. Donations above Rs 2000 should be made in any mode other than cash to qualify for an 80G deduction.
10) Section 80GGC – Deduction on Donations By a Person to Political Parties
Deduction under section 80GGC is allowed to an individual taxpayer for any amount contributed to a political party or an electoral trust.
11) Section 80RRB – Deduction on Income via Royalty of a Patent
80RRB Deduction for any income by way of royalty for a patent, registered on or after 1 April 2003 under the Patents Act 1970, shall be available for up to Rs.3 lakh or the income received, whichever is less.
12) Section 80TTB – Interest Income on Deposits for Senior Citizens
Deductions with respect to interest income from deposits held by senior citizens will be allowed. The limit for this deduction is Rs.50,000.
13) Section 80TTA – Interest on Savings Accounts
If you are an individual or a HUF, you may claim a deduction of a maximum Rs 10,000 against interest income from your savings account with a bank, co-operative society, or post office.
14) Section 80EEB - Loan interest paid on purchase of electric vehicle
Interest payable on loan taken by an individual from any financial institution for the purpose of purchase of an electric vehicle subject to certain condition. (Maximum deduction 1,50,000)
15) Section 80IA - 80JJAA - For Certain Business and Assessee
Depending upon certain conditions various deductions are available to the businessman
16) Section 16 i - Standard Deduction
Rs. 50,000 or the amount of salary, whichever is lower
17) Section 16 ii - Entertainment allowance
Actual or at the rate of 1/5th of salary, whichever is less [limited to Rs. 5,000]
18) Section 23/24 -
Municipal taxes on property paid when rent received
19) Section 24 - Interest on borrowed capital
Rs. 30,000/Rs. 2,00,000, subject to specified conditions
20) Section 57 - Any reasonable sum paid by way of commission or remuneration for purpose of realising dividend
Any reasonable sum paid by way of commission or remuneration for the purpose of realising interest on securities
Any other expenditure (not being capital expenditure) expended wholly and exclusively for earning such income
21) Section 57 ii - Family Pension
In the case of family pension, 331/3 per cent of such pension or Rs. 15,000, whichever is less
Remember to read the rules and keep evidence or proof ready before claiming any expenditure. Happy Filing and Hope you can save some Tax
#Tax #IncomeTax #ITRFiling #TaxTwitter
The Sun God has 7 horses to pull his heavenly chariot.
In the Rigveda there are 7 parts of the world, 7 seasons & 7 fortresses
7 basic musical notes
7 pheras in a marriage
7 wonders of the world
And on
7th day of 7th month- Birthday of a top man @msdhoni , #HappyBirthdayDhoni .
For Tax Return Filing you might be needing Mutual Funds Statements
Please find the link for KFintech and CAMS related AMC where you can get your Statements -
Requirements –
1. Registered Email ID
2. PAN
Capital Gains/Loss Statement – AMCs serviced by respective RTAs
https://t.co/z5nxHTIioj
https://t.co/vOntLxMPDE
Consolidated Account Statement (CAS) – Any One Link Will Be Sufficient
https://t.co/Obwlrjuwwi
https://t.co/i3wm2wEdW9
ELSS Statement – AMCs serviced by respective RTAs
https://t.co/no8LwlXo0o
https://t.co/yVlqEbxtdO
Statements will be sent to email address registered for Mutual Fund investments. You need to set a password to open attachment.
Salaried don't claim fake deductions
The Income Tax department has filed two FIRs against 400 Employees and one CA in Jammu and Kashmir in bogus refund cases
It has been alleged in the FIRs 405 persons including a Chartered Accountant who runs a firm from Raj Bagh Srinagar have entered into a conspiracy and defrauded the Central Government exchequer for a sum of Rs.16.72 crore between financial years 2017-18 to 2019-20
In the FIRs addressed to the Senior Superintendent of Police, Crime Branch, Srinagar, the Income Tax Department has described the modus operandi of the accused in minute details and has shared their complete details with the crime branch like names, addresses, PAN, bank accounts and the amounts fraudulently claimed as refunds by filing incorrect Income Tax Returns in a clandestine manner.
It has been alleged that all the culprits have taken more than Rs 4 lakhs as refunds by filing incorrect Income Tax Returns for various years. All 405 persons have been booked under sections 420/468/471 and 120B of the IPC & RPC read with section 66-D of the I.T. Act.
In this digital age, and robust IT infra by department, soon claiming fake deduction will be impossible as system will be strong enough to detect such fake claims
Employees, don't claim fake detection for small refunds, you may have to pay later with interest and a huge penalty
Confused about which Tax Regime to choose? 🤔
🧾Old Regime with Deductions and Exemptions, or
📉New Regime with Lower Slab Rates, but Fewer Exemptions
Don't worry, this🧵will help you Decide Which Regime will be More Beneficial to You and Help you Save the Most Taxes💰