Categories
Excel VBA Dashboard India Payroll

Income Tax Calculator 2019-20 AY 2020-21 in Excel – Easily

Click here to download income tax calculator in excel slab wise. This sheet have the excel formulas to along with marginal tax relief as per FY 2019-20.

@iptmnoida #iptmindia #excelformulas

Categories
80C Deductions 80DDB Excel VBA Dashboard Gratuity House Rent Allowance (HRA) Human Resource (HR) India Payroll Payroll Provident Fund (PF)

Income tax calculation sheet for the financial year 2019-20 [AY 2020-21] Automated Salary Tax Calculator along 15+ other Features

Click here to download automatic Complete Payroll Calculator in Excel. This Excel Software have includes most likely all part of Payroll Calculation. It’s Includes following Feature:-

  • You can calculate Cost to company CTC Automatic once you put total ctc.
  • You can restructuring of allowances and CTC components as per your need.
  • Income Tax  to be calculate automatic.
  • You can set your investment Declaration / Proofs Planing as per requirement.
  • This sheet will calculate House rent allowance ( HRA Rent Exemption calculation) under section 10(13A) automatic as per your rent paid and selected location.
  • You can customize your structure like add / less : PF (Employees’ Provident Fund), Employment State Insurance ( ESIC), Gratuity, Mediclaim, any other benefit, Bonus, Minwages.
  • You can control to deduct PF on Basic OR PF on Allowances or PF on min wages of PF or you can select No if you are not eligible for pf deduction.
  • You can Se-off loss / income from house property u/s 24(b) as per Income Tax Act.
  • You can add reimbursement components as per bills planing to get more benefit in tax.
  • This sheet will give you Net payment Automatically as per your change.
  • Best part of this software is that, you can generate  your salary pay slip from CTC in one click and change payslip in excel as per needs.
  • We have added logo on slip so that you can change it.
  • You can generate any month salary slip from excel format in one click even you can generate full and final slip.
  • Free download
  • Paid Support Available at :
  • Email: ajityadav121@gmail.com
  • Call/WhatsApp: +91 9654421288

Click here to Download Automated Excel Sheet to calculate cost to company (CTC), Income Tax Calculation for financial year 2019-20 along with all investment planning (Deduction U/C VI-A)  and all Major Exemptions allowed + reimbursement  in Salary.

This sheet will allowed to planning your tax saving, make salary structure as per your choice and know the Net in hand Automatically.

Thanks!

Categories
Minimum Wage tamilnadu

Revised Minimum Wages Tamil Nadu

The Minimum wages in Tamil Nadu has been revised with effect from  1st April’2019.The amended rates for all the categories are as below:-

Click here to download notification

TAMILNADU Minimum Wages Rates for Shops and Establishment

Effective for the period From 01/04/2019

 

Name of the Category

BASIC WAGES

VDA

TOTAL

S.NO

GENERAL CATEGORIES

ZONE A

1

Manager,Sales Manager,Field Officer, Development officer, Office Incharge

5960

3499

9459

2

Assistant Manager, Accountant, Supervisor, Sales Executive, Purchaser, Store Keeper, Agent, Sales Promotion Employees

5548

3499

9047

3

Cashier, Clerk, Typist-cum-clerk, Typist, Stenographer, Salesman, Sales Representative, Auction Bidder, Tradesman, Bill Writer

5507

3499

9006

4

Bill collector, Booking Clerk, Bill Clerk, Godown keeper, Assistant Salesman, Godown Incharge, Accounts Assistant, Receiptionsit, Lineman, Tally Clerk, Security Guard, Weighman, Driver

5457

3499

8956

5

Peon, Watchman, Shop Assistant, Helper, Packer, Attender, Delivery Boy, Messenger, Lift Operator, Shop boy, water boy, sweeper, Gardener, Scavenger

5396

3499

8895

6

General workers in all shops and commerical establishments other than in administration and clerical cadre and who are not covered in any of the above categories

5396

3499

8895

Click here to download notification

Categories
monthly Compliance Calendar

Due dates Compliance Calendar for April 2019

Statutory compliances dues date calendar issued by PayrollPedia for April 2019. Below are list of last dates Act wise:

Date (by when)Applicable ActDetails of Compliance
30th APRTDS Deposit Last DateIncome Tax Deduction On Salary
15th APRESICMonthly deposit ESIC Contribution
15th APRPROVIDENT FUNDMonthly deposit PF Contribution
20th APRProfessional TaxKARNATAKA (BANGALORE) [Monthly]
10th APRProfessional TaxANDHRA PRADESH (HYDERABAD) [Monthly]
21st APRProfessional TaxWEST BENGAL (KOLKATA) [Monthly]
30th APRProfessional TaxMAHARASHTRA  (MUMBAI) [Monthly]
15th APRProfessional TaxGUJARAT (AHMEDABAD)   [Monthly]
30th APRProfessional TaxORISSA  (Monthly)
10th APRProfessional TaxMADHYA  PRADESH  (INDORE) (Monthly Salary)
30th APRProfessional TaxGUWAHATI (ASSAM) (Monthly)
30th APRER1 – EMPLOYMENT EXCHANGEQuarterly Return for Quarter ending 31st March
12th APRLabour Welfare FundPunjab [Payment]
13th APRLabour Welfare FundChandigarh [Payment]