Categories
Linking PAN with Aadhaar

Bulk Aadhar PAN Linking check status service in Excel

Bulk Aadhar PAN Linking check status service in Excel

The Income-tax authorities have mandated PAN of an individual to be linked with Aadhaar. The CBDT in this regards, has inserted a new Rule 114AAA in the Income-tax Rules, 1962 which provides for the “manner of making PAN inoperative”

Non-linking of Aadhaar with PAN by June 30, 2020 will make PAN inoperative for those individuals who are required to intimate Aadhaar (to tax authorities). in case PAN of an employee becomes inoperative, then as per the provisions of Section 206AA of the Income-tax Act, 1961, the deductor (employer/company) is liable to withhold tax on income at the higher of Average rate of tax for the financial year; or 20%

Solution: We can assist in checking the PAN – Aadhaar linking status via income tax website through our Automation technology solution and we provide you status of all employee’s in Excel sheet.

Check bulk PAN linking and Aadhar card linking status on income tax website for for form 24Q.

CALL / WhatsApp + 91 9654421288 / +91 9811793365

link pan card with aadhar check status service
  • Charges: up to 500 Employee = INR 1000
  • Charges: up to 1000 Employee = INR 2000
  • Charges: up to 2000 Employee = INR 4000
  • Charges: up to 3000 Employee = INR 6000
  • Charges: up to 5000 Employee = INR 10000
  • Charges: up to 6000 Employee = INR 12000
  • Charges: up to 8000 Employee = INR 16000
  • Charges: up to 9000 Employee = INR 18000
  • Charges: up to 10000 Employee = INR 20000
  • Charges: up to 15000 Employee = INR 30000

CALL / WhatsApp + 91 9654421288 / +91 9811793365

Categories
India Payroll Payroll

Download Income Tax Calculator in Excel for FY 2020-21 [AY 2021-22] Comparison Old and New Regime

Download Income Tax Calculator in Excel for FY 2020-21 [AY 2021-22] Comparison Old and New Regime.

Excel Tax calculator ready To help taxpayers here is a simple excel based Income Tax Calculator for the financial year 2020–21 (AY 2021-22). The calculator is made using simple excel formulas and functions.

Click here to download Excel Tax Calculator

Categories
India Payroll

New and Old Tax Slab Computation in Excel 2020-21

Income-Tax-Calculation-and-Comparison-2020-21Download
Categories
monthly Compliance Calendar

Due Date Compliances Calendar For March 2020

Statutory compliance’s dues date calendar issued by Payrollpedia for March 2020. Below are list of last dates Act wise:

Date (by when) Applicable Act Details of Compliance
07-Mar-20 TAX DEPOSIT Monthly Deposit Tax Contribution
15-Mar-20 ESIC Monthly deposit ESIC Contribution
15-Mar-20 PROVIDENT FUND Monthly deposit PF Contribution
31-Mar-20 Income Tax Act Last date of Submission Investment proofs Form 12BB
20-Mar-20  PROFESSIONAL TAX KARNATAKA (BANGALORE)
10-Mar-20  PROFESSIONAL TAX ANDHRA PRADESH (HYDERABAD)
21-Mar-20  PROFESSIONAL TAX WEST BENGAL (KOLKATA)
31-Mar-20  PROFESSIONAL TAX MAHARASHTRA  (MUMBAI)
15-Mar-20  PROFESSIONAL TAX GUJARAT (AHMEDABAD)
31-Mar-20  PROFESSIONAL TAX ORISSA
10-Mar-20  PROFESSIONAL TAX MADHYA  PRADESH  (INDORE) (Monthly Salary)
31-Mar-20  PROFESSIONAL TAX GUWAHATI (ASSAM)
31-Mar-20  PROFESSIONAL TAX PUNJAB
31-Mar-20  PROFESSIONAL TAX KERALA  (Half-Yearly)/COCHIN
31-Mar-20  PROFESSIONAL TAX (CHENNAI) [Half – Yearly] 
31-Mar-20  PROFESSIONAL TAX COIMBATORE (TAMIL NADU) [Half – Yearly] 
31-Mar-20  PROFESSIONAL TAX Tenkasi, Tamil Nadu(Half-Yearly)
31-Mar-20  PROFESSIONAL TAX Kancheepuram, Tamil Nadu(Half-Yearly)
31-Mar-20  PROFESSIONAL TAX Hosur, Tamil Nadu(Half-Yearly)
31-Mar-20  PROFESSIONAL TAX Erode , Tamil Nadu(Half-Yearly)
Categories
Linkedin data extract in Excel

Extract data from Linkedin to Excel

Extracting LinkedIn connection data and send unlimited bulk messages to your connections is available in Excel using our VBA based software.

  1. You can send unlimited bulk messages on LinkedIn connections in 1 click from Excel.
  2. You can search and extract connections details in Excel automatic.
  3. You can export your connection details in excel with email and mobile.

99Excel.Com has made a Excel Automation to search and send messages from excel to LinkedIn connection. it very simple and easy to use.



Tage: export linkedin search results to excel 2017

scrape linkedin search results

export linkedin search results to excel

linkedin scraper excel

https://99excel.com/download/

Categories
monthly Compliance Calendar Payroll

Due Date Compliances Calendar For January 2020

Statutory compliance’s dues date calendar issued by Payroll Pedia for January 2020. Below are list of last dates Act wise:

Date (by when) Applicable Act Details of Compliance
07-Jan-20 TAX DEPOSIT Monthly Deposit Tax Contribution
15-Jan-20 ESIC Monthly deposit ESIC Contribution
15-Jan-20 PROVIDENT FUND Monthly deposit PF Contribution
15-Jan-20 Factories Act Yearly Return
15-Jan-20 Factories Act Half Yearly Return
30-Jan-20 Employment Exchange Quarterly Return
30-Jan-20 Contract Labour (R & A) Act Half yearly return by the contractor
31-Jan-20 Esic Annual information about factory/establishment covered
31-Jan-20 S&E Annual Return In Bangalore Yearly Return
31-Jan-20 S&E Annual Return In Chennai Yearly Return
31-Jan-20 S&E Half Yearly Return In Chennai Half Yearly Return
31-Jan-20 Tamil Nadu Industrial Establishment Act (National And Festival Holidays) Rules 1959 In Chennai Yearly Return
31-Jan-20 The Sexual Harassment Of Women At Workplace Annual Return
31-Jan-20 TDS 24Q 3rd Quarter return  Quarter return 
20-Jan-20  PROFESSIONAL TAX Karnataka (Bangalore) [Monthly]
10-Jan-20  PROFESSIONAL TAX Andhra Pradesh (Hyderabad) [Monthly]
21-Jan-20  PROFESSIONAL TAX West Bengal (Kolkata) [Monthly]
31-Jan-20  PROFESSIONAL TAX Maharashtra (Mumbai) [Monthly]
15-Jan-20  PROFESSIONAL TAX Gujarat (Ahmedabad) [Monthly]
31-Jan-20  PROFESSIONAL TAX Orissa (Monthly)
10-Jan-20  PROFESSIONAL TAX Madhya Pradesh (Indore) (Monthly Salary)
31-Jan-20  PROFESSIONAL TAX Guwahati (Assam) (Monthly)
31-Jan-20 LWF Andhra Pradesh
31-Jan-20 LWF Telangana
31-Jan-20 LWF Chattisgarh
31-Jan-20 LWF Goa
15-Jan-20 LWF Gujarat
31-Jan-20 LWF Haryana
15-Jan-20 LWF Karnataka
15-Jan-20 LWF Kerala
31-Jan-20 LWF Madhya Pradesh
15-Jan-20 LWF Maharastra
15-Jan-20 LWF New Delhi
15-Jan-20 LWF Punjab
15-Jan-20 LWF Chandigarh
31-Jan-20 LWF Tamil Nadu
15-Jan-20 LWF West Bengal
Categories
Payroll Salary and CTC Breakup

Salary and CTC Breakup Calculator in Excel Automatic

Download free automatic salary and CTC breakup calculator in Excel.

CTC (cost to company) of an employee OR for all employee’s in a organization is always difficult task. As you know, CTC mean salary breakup should be as India laws.

I have create a VBA based Excel sheet to calculate CTC cost to company salary breakup automatic as per all rules.

What’re Features in this Sheet?

  • You can calculate CTC breakup one by one individually meanwhile you can calculate all employee ( up to 5000) breakup in 1 Click.
  • Reset option for reset all sheet as blank.
  • Employee Type and State name selection required for calculating.
  • This sheet will be calculate Basic, HRA and Special Allowance as per Minimum wages Act as applicable Indian States.
  • User can update minimum wages in Second attached sheet even ever required.
  • Basic Salary and other calculations based on excel formulas which can be changed if required.
  • Bonus will be calculate 20% as per Bonus Payment Act 1965.
  • Gratuity will be calculate as per Gratuity Payment Act 1972.
  • User can change HRA % 50 to 40% in case required.
  • User can rename the other allowances head name if required.

How to CTC Calculation sheet?

  1. Click on Reset button.
  2. Select State and Employee Skill.
  3. Type Annual CTC Amount.
  4. CTC Salary Breakup will be calculate Automatic.

Important:

  • Your Excel Macros should be Enable (Know more)
  • Minimum wages list should be update
  • Change Allowance name, Bonus % as applicable
  • Employee Skill and State name required
  • Click on Calculate button in case you are calculating CTC in bulk.

Download CTC Calculator

Call Me: +919654421288 for paid consultant.

Categories
80C Deductions India Payroll NSC Interest Calculator

NSC Interest Calculator of last 5 years – National Savings Certificate Calculator in Excel for 2019-20

Download NSC Interest Calculator in Excel for deduction under section 80C of Income Tax Act, 1961. Interest earned on NSC purchased of last 5 years is taxable in hand of assesses and it also deductible under section 80C up to limit of section ( currently 80 max. limit is 150000). Click here to download NSC Calculator in Excel.

What is NSC:

National Savings Certificate is a popular mode of small savings investment in India. The NSC rate of interest has been fixed by the government. The NSC (National Saving Certificate) Calculator allows you to calculate the return on your investment when saving using the National Savings Certificate Scheme.

NSC Restrictions

The National Saving Certificate Scheme (NSC) is an excellent investment opportunity but there are some restrictions you should be aware of.

  1. The National Saving Certificate (NSC) scheme has a minimum investment threshold of ₹100.00
  2. National Saving Certificates are issued at a minimum of ₹100.00 certificates though you can also purchase ₹500.00, ₹1,000.00, ₹5,000.00, ₹10,000.00 denomination certificates.
  3. There is no limit on the number of National Saving Certificates that you can buy.

Type of NSC Certificates

There are 3 different types of National Savings Certificate

  1. Single holder Type Certificate: Issued to an individual (the holder) or to an individual on behalf of a minor.
  2. Joint A type Certificate: Issued jointly to two adults. On maturity, the NSC is paid to both of the joint holders
  3. Joint B type Certificate: Issued jointly to two adults in the same way as Joint A type NSC (see above) withe the difference that on maturity, the NSC is paid to one (either one) of the joint holders.
Categories
monthly Compliance Calendar

Due Date Compliances Calendar For December 2019

Statutory compliance’s dues date calendar issued by Payrollpedia for December 2019. Below are list of last dates Act wise:

Date (by when) Applicable Act Details of Compliance
07-Dec-19 TAX DEPOSIT Monthly Deposit Tax Contribution
15-Dec-19 ESIC Monthly Deposit Esic Contribution
15-Dec-19 PROVIDENT FUND Monthly Deposit Pf Contribution
31-Dec-19 MINIMUM WAGES Annual Return Minimum wage Deductions From
30-Dec-19 BONUS ACT Annual Return for the ending financial year
31-Dec-19 NATIONAL & FESTIVAL HOLIDAY ACT Annual Return 
20-Dec-19  PROFESSIONAL TAX Karnataka (Bangalore) [Monthly]
10-Dec-19  PROFESSIONAL TAX Andhra Pradesh (Hyderabad) [Monthly]
21-Dec-19  PROFESSIONAL TAX West Bengal (Kolkata) [Monthly]
31-Dec-19  PROFESSIONAL TAX Maharashtra (Mumbai) [Monthly]
15-Dec-19  PROFESSIONAL TAX Gujarat (Ahmedabad) [Monthly]
31-Dec-19  PROFESSIONAL TAX Orissa (Monthly)
10-Dec-19  PROFESSIONAL TAX Madhya Pradesh (Indore) (Monthly Salary)
31-Dec-19  PROFESSIONAL TAX Guwahati (Assam) (Monthly)
30-Dec-19 LWF Haryana
15-Dec-19 LWF Punjab
15-Dec-19 LWF Chandigarh

Categories
Delhi Minimum Wage

Revised Minimum Wages Delhi

The Minimum wages in Delhi has been revised. The amended rates for all the categories are as below:-

Click here to download notification

DELHI SHOPS AND COMMERCIAL ESTABLISHMENTS 
Rates of Minimum wages 
Schedule of Employment CATEGORY OF WORKERS Minimum rates of Wages in Rupees  
    Per month Per day
       
All Schedule employment Un-skilled  14842/- 571/-
  Semi – skilled 16341/- 629/-
  Skilled  17991/- 692/-
  Clerical and supervisory staff    
  Non matriculates 16341/- 629/-
  Matriculates but not Graduates 17991/- 692/-
  Graduates and above 19572/- 753/-

Click here to download notification