Categories
Payroll Salary Slip

How to Convert Excel to PDF VBA

In this video, you will learn how to convert Excel sheet in PDF using VBA code. I have link a Salary slip format with row data of payroll employee and made it dynamic once serial number change in row number A1.

Copy and paste below code in your Excel VBA place and save your time and money.

Sub Create_PDF()
Dim Foldername, Filename, PDFPath, SR
Foldername = “C:\Users\USERNAME\Desktop\FOLDERNAME” ‘ Change it
For SR = 1 To 2
Sheets(“Pay Slip”).Range(“A1”).Value = SR
Filename = Sheets(“Pay Slip”).Range(“H7”).Value
PDFPath = Foldername & “\” & Filename & “.pdf”
Sheets(“PayRegister”).Visible = False
ActiveWorkbook.ExportAsFixedFormat xlTypePDF, PDFPath, xlQualityStandard, False
Sheets(“PayRegister”).Visible = True
Next SR
MsgBox “Successfully Saved”
End Sub

Categories
Payroll Tax Return (ITR)

How to file income tax return online for AY 2020-21?

Guide to File Income Tax Return (ITR) 1 Online:

Part-A (General Information)

  • Create a profile on the IT department tax filing website i.e. http://incometaxindiaefiling.gov.in
  • Make sure that a functional email id and mobile number to authenticate the profile.
  • Then need to quote the Adhaar number in the form and verify the Adhaar details as well.
  • Select the form applicable in your case. For most individuals, it is ITR 1- SAHAJ.
  • SAHAJ is for individuals having income from salaries, one-house property, and income from other sources such as dividends, interest income, income from winnings, etc.

Part-B (Gross total income)

  • Details of Employer like TAN , Name, Nature& Address of Employer
  • Salary details
  • All the allowances which are exempted
  • All the value of perquisites
  • Net salary
  • Deduction in u/s 16
  • Income chargeable under the head ‘salaries’
  • Gross Rent received
  • Tax paid to local authorities
  • Annual value
  • 30% of the annual value
  • Interest payable on borrowed capital
  • Arrears/unrealized rent less than 30%
  • Deduction u/s 57(iia)

Sum of the entire amount will come under Gross Total Income

Part C – Deductions u/c VI-A and Taxable total income

Here the deduction limit will be as per income tax act

  • 80C,80CCC,80CCD(1),80CCD(1B),80CCD(2),80DD,80DDB,80E,80EE,80EEA,80EEB,80GG,80GGC,80U
  • Value of Total deduction

Total income (Gross Total Income – Deductions U/c VI-A )

Part D – Computation of tax payable (Valuation of Tax Payable)

  • D1 Tax payable on total income
  • D2 Rebate u/s 87A
  • D3 Tax after rebate
  • D4 Cess on D3
  • D5 Total tax and cess
  • D6 Relief u/s 89(1)
  • D7 Interest u/s 234A
  • D8 Interest u/s 234B
  • D9 Interest u/s 234C
  • D10 Fee u/s 234F
  • D11 Total tax, fee, and interest
  • D12 Total tax paid
  • D13 Amount payable
  • D14 Refund
  • Exempt income

Part E – Other Information (banking details)

  1. IFSC Code of the bank
  2. Name of the bank
  3. Account Number

Final Step

  • The return that which is  filed will not be treated valid unless it is verified
  • The taxpayer has to verify and self-attest the form at the last by signing the verification content after entering all the details such as name, parent name and PAN details
  • For physical verification of the return, print the acknowledgment of ITR-V, sign it in blue ink, and send it to the Centralized Processing Centre (Bangalore) within 120 days of filing your return.

Important Terms to Understand In ITR-1 SAHAJ Form for AY 2020-21

  • Revised Return: There is an option of re-file, so if you have made certain mistakes, you can rectify them again. For the FY 2019-20 the taxpayer can furnish the revised return on or before 31 March 2021.
  • Advance Tax: If the tax on other income is above Rs. 10,000 in a year, the assesse is required to calculate and deposit the advance tax. This advance tax is to be paid on a quarterly basis such as on, June, December, September and March.
  • Annexure-less Return: Annexure-less return which means it doesn’t require to affix any documents with the ITR-1 Form.
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.

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.

Call Me: +919654421288 for paid consultant.

Categories
Minimum Wage Payroll punjab

Revised Minimum Wages In Punjab

The Minimum wages in Punjab has been revised with effect from 01.09.2019 The amended rates for all the categories are as below:-

Click here to download notification

PUNJAB SHOPS AND COMMERCIAL ESTABLISHMENTS 
Minimum Wages Rates       
S.NO Categories w.e.f 01/03/2019 w.e.f 01/09/2019  
    Per Day Monthly Per Day Monthly
1 Unskilled 325.53 8451.95 338.05 8776.83
2 Semi-skilled 355.53 9231.95 368.05 9556.83
3 Skilled 390.03 10128.95 402.55 10453.83
4 Highly Skilled 429.73 11160.95 442.25 11485.83

Click here to download notification

Categories
Payroll

Revised Minimum Wages In Delhi

The Minimum wages in Delhi with effect from 01.10.2019 to 22.10.2019 would be as under:

Click here to download notification

Category of workmen Rates notified vide notification dated 03.03.2017 (per month) (Amount in Rs.) Per month) Minimum wages after adding DA & allowed by S.C (Amount in Rs.) (Per month) DA w.e.f 01.04.2019 (per month) (Amount in Rs.) (Per month) Minimum wages after adding D.A w.e.f 01.04.2019 to 30.09.2019 (Amount in Rs.) (Per month) DA w.e.f 01.10.2019 (Amount in Rs.) (Per month) Minimum Wages after adding DA w.e.f 01.10.2019 to 22.10.2019/date of notification (Amount in Rs.) (Per Month) Minimum wages per day (Amount in Rs.)
Unskilled 13,350/- 14,000/- 468/- 14,468/- 338/- 14,806/- 569/-
Semi-Skilled 14,698/- 15,400/- 520/- 15,920/- 364/- 16,284/- 626/-
Skilled 16,182/- 16,962/- 546/- 17,508/- 416/- 17,924/- 689/-
  Clerical and supervisory Staff          
Non Matriculates 14,698/- 15,400/- 520/- 15,920/- 364/- 16,284/- 626/-
Matriculates But not Graduate 16,182/- 16,962/- 546/- 17,508/- 416/- 17,924/- 689/-
Graduate and above 17,604/- 18,462/- 598/- 19,060/- 462/- 19,522/- 751/-

Click here to download notification

Categories
monthly Compliance Calendar Payroll

Compliance Calendar November 2019

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

Date (by when) Applicable Act Details of Compliance
07-Nov-19 TAX DEPOSIT Monthly Deposit Tax Contribution
15-Nov-19 ESIC Monthly Deposit Esic Contribution
15-Nov-19 PROVIDENT FUND Monthly Deposit Pf Contribution
20-Nov-19  PROFESSIONAL TAX Karnataka (Bangalore) [Monthly]
10-Nov-19  PROFESSIONAL TAX Andhra Pradesh (Hyderabad) [Monthly]
21-Nov-19  PROFESSIONAL TAX West Bengal (Kolkata) [Monthly]
30-Nov-19  PROFESSIONAL TAX Maharashtra (Mumbai) [Monthly]
15-Nov-19  PROFESSIONAL TAX Gujarat (Ahmedabad) [Monthly]
30-Nov-19  PROFESSIONAL TAX Orissa (Monthly)
10-Nov-19  PROFESSIONAL TAX Madhya Pradesh (Indore) (Monthly Salary)
30-Nov-19  PROFESSIONAL TAX Guwahati (Assam) (Monthly)
15-Nov-19  PROFESSIONAL TAX JHARKHAND(Annually)
15-Nov-19  PROFESSIONAL TAX BIHAR PT RATES (Annually)
30-Nov-19 LWF Haryana
15-Nov-19 LWF Punjab
15-Nov-19 LWF Chandigarh
Categories
Haryana Minimum Wage Payroll

Revised Minimum Wages Haryana

The Minimum wages in Haryana has been revised with effect from 01st July 2019.The amended rates for all the categories are as below:-

Click here to download notification

HARYANA SHOPS AND ESTABLISHMENT ACT

 

MINIMUM WAGES W.E.F 01/07/2019

 

S.NO

Categories of workers

Qualification and experience

Basic (Rs.)

Dated w.e.f 01.01.2019 minimum wages     A (Rs.)

VDA w.e.f 01.07.2019              B (Rs.)

Total Wages A+B (Rs.)

Per day (Rs.)

 
 

1

Unskilled

–

7600.00

8827.4

196.84

9024.24

347.08

 

2

Semiskilled (A)

–

7980.00

9268.75

206.68

9475.43

364.43

 

Semiskilled (B)

–

8379.00

9732.18

217.01

9949.19

382.66

 

3

Skilled        (A)

–

8797.95

10218.79

227.86

10446.65

401.79

 

Skilled        (B)

–

9237.85

10729.74

239.26

10969.00

421.88

 

4

Highly Skilled

–

9699.74

11266.23

251.22

11517.45

442.97

 

5

Clerical and General Staff

(i) Below Matriculation

7980.00

9268.75

206.68

9475.43

364.43

 

(ii) Matriculation but not Graduate

8379.00

9732.18

217.01

9949.19

382.66

 

(iii) Graduate or above

8797.95

10218.79

227.86

10445.65

401.79

 

(iv) Steno Typist

8379.00

9732.18

217.01

9949.19

382.66

 

(v) Junior Scale Stenographer

8797.95

10218.79

227.86

10446.65

401.79

 

(vi) Senior Scale Stenographer

9237.85

10729.74

239.26

10969.00

421.88

 

(vii) Personal Assistant

9699.74

11266.23

251.22

11517.45

442.97

 

(viii) Private Secretary

10184.73

11829.54

263.78

12093.32

465.12

 

6

Data Entry Operator

–

8797.95

10218.79

227.86

10446.65

401.79

 

7

Driver

Light Vehicle

9237.85

10729.74

239.26

10969.00

421.88

 

Heavy Vehicle

9699.74

11266.23

251.22

11517.45

442.97

 

8

Security Guard

Without Weapon

7980.00

9268.75

206.68

9475.43

364.43

 

With Weapon

9237.85

10729.74

239.26

10969.00

421.88

 

9

Security Inspector/Security Officer/Security Supervisor

As Hon’ble Supreme Court judgment dated 29.04.2019,this category is not to be included in the minimum wages list.

 

10

Safai Karamchari in any employment

As per the High Court order CWP No. 25328 of 2015,in this category minimum wages cannot be notified.

 

Click here to download notification

Categories
Payroll

Revised Minimum Wages Rajasthan

The Minimum wages in Rajasthan has been revised with effect from 01st May 2019.The amended rates for all the categories are as below:-

Click here to download notification

RAJASTHAN Minimum Wages Rates for Shops and Establishment

Effective for the period From 01/05/2019

       

S.NO

Category

Rates of Minimum Wages(In Rupees)

Per Month

Per Day

1

Unskilled

5850/-

225/-

2

Semi Skilled

6162/-

237/-

3

Skilled

6474/-

249/-

4

Highly Skilled

7774/-

299/-

 

Click here to download notification