Month: December 2019

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