Categories
Payroll

Due Date Compliance Calendar June 2019

Statutory compliances due dates calendar issued by #PayrollPedia for June 2019. Below are list of last dates Act wise: –

Date (by when) Applicable Act Details of Compliance
7st Jun Tax Deposie Monthly deposit tax Contribution
15th Jun TDS Certificate (Form 16) Issue Last date  Income From Salary, Income Tax Act , 1961
15th Jun ESIC Monthly deposit ESIC Contribution
15th Jun PROVIDENT FUND Monthly deposit PF Contribution
20-Jun  Professional Tax KARNATAKA (BANGALORE) [Monthly]
10-Jun  Professional Tax ANDHRA PRADESH (HYDERABAD) [Monthly]
21-Jun  Professional Tax WEST BENGAL (KOLKATA) [Monthly]
30-Jun  Professional Tax MAHARASHTRA  (MUMBAI) [Monthly]
15-Jun  Professional Tax GUJARAT (AHMEDABAD)   [Monthly]
30-Jun  Professional Tax ORISSA  (Monthly)
10-Jun  Professional Tax MADHYA  PRADESH  (INDORE) (Monthly Salary)
30-Jun  Professional Tax GUWAHATI (ASSAM) (Monthly)

 

Categories
Form 16

Part B of Form 16 shall be download from TRACE

Good news for all employers and Payroll professionals!

Recently, Income Tax India (CBDT) systems has amended the rule 31 of Income tax Rules 1962. As per new rule form 16 Part A and Part B (A complete TDS certificate form 16 shall be available from trace website to download and issue to employee.

1st April 2018 on wards, every employer shall issue the form 16 Part B (Annexure) from trace only along with Part A. You can say Now, complete form 16 to be given by income tax only not employer.

But in case, employee are claiming for exemptions under section 10 (Apart form 10(5), 10(10), 10(10A) , 10(10AA) and 10(13A) ) than employer have to fill the form 16 item no. 2f. Complete information given below.

The item nos. 2(t) and 10(k) in Part B (Annexure) of Form 16 required to be filled-in by the deductor manually shall be made available at the bottom of the TRACES generated Form 16 (Part B) and the deductor shall duly fill details, where available, in item numbers 2(t) and lOCk) before furnishing of Part B (Annexure) to the employee. The deductors who opt to uthenticate Part B of Form No. 16 manually will be provided with the download of the Part B of Form No. 16 alongwith these item nos. 2(t) and lOCk) appearing at the bottom of the Form. The deductor shall duly fill details, where applicable, in item numbers 2(t) and 10(k) before furn ishing of Part B (Annexure) to the employee. The deductors who opt to authenticate Part B of Form No. 16 using Digital Signature Certificate (DSC) will be provided with the download of Part B of Form No. 16 without item nos. 2(t) and 10(k) and therefore these details shall be required to be prepared by the employer and issued to the employee, where applicable, before furni shing of Part B to the employee.

Download Notification.

  • Part A of Form 16 shall be download from Trace only.
  • Part B of Form 16 shall be download from Trace only.
  • A Complete form 16 TDS certificate shall be issued by Trace Income tax India only.
  • Employer will update form Part B of Form 16 in case employee are claiming exemption in item no 2(f) of form 16 and any deduction allowed by employer in item no 10(k) o form 16.
  • Part B is mandatory in case employee has submitted PAN to employer and employer has finished in salary return (form 24Q).
  • Authentication or verification of TDS certificate Form 16 both parts downloaded from trace to be done by employer or you can say final issuing correct form 16 tds certificate responsibility of employer only.
  • Employer also will issue form 12BA from own records in case employee is getting perk benefit more than 150000.
  • Manual form 16 part B will not issue from 1st April 2018 onward.

Regards, Kumar Ajit

www.payrollpedia.org

Categories
Excel Formulas & VBA Code Excel VBA Dashboard India Payroll Payroll

Merge Part A and Part B of Form 16 in Excel

Greetings!

I believe, You are searching a free tool which can merge or combine Part A and Part B in 1 PDF in automation process. if yes, you are at right place.

As per Income tax India Form 16 TDS Certificate Part A should be download and convert from Trace website (tdscpc.gov.in) and Employer have to prepare Part B of Form 16. Both Should be Merged in One PDF for digital signature process.

Every Employee or professionals are looking a tools which can help in this process. Three are many software available in market / google search to do the same but they are paid.

But, trust me you can Merge any two more pdfs in 1 pdf in excel sheet without any wasting money in very simple way and fast.

I have developed a Excel sheet which can use N numbers of times and you can merge 2 different folders PDF files in 1 PDF as per your customization.

You can download this sheet from www.99Excel.Com and watch the below video to learn tutorial.

Direct Link to download sheet:
http://99excel.com/download/index.html

Thanks,

Kumar Ajit

Categories
monthly Compliance Calendar

Due Date Compliance Calendar May 2019

Statutory compliances due dates calendar issued by #PayrollPedia for May 2019. Below are list of last dates Act wise: –

Date (by when)

Applicable Act

Details of Compliance

07th MAY

TDS Deposit Last Date

Income Tax Deduction Deposit date

15th MAY

ESIC

Monthly deposit ESIC Contribution

15th MAY

PROVIDENT FUND

Monthly deposit PF Contribution

20th MAY

Professional Tax

KARNATAKA (BANGALORE) [Monthly]

10th MAY

Professional Tax

ANDHRA PRADESH (HYDERABAD) [Monthly]

21st MAY

Professional Tax

WEST BENGAL (KOLKATA) [Monthly]

31st MAY

Professional Tax

MAHARASHTRA (MUMBAI) [Monthly]

15th MAY

Professional Tax

GUJARAT (AHMEDABAD) [Monthly]

31st MAY

Professional Tax

ORISSA (Monthly)

10th MAY

Professional Tax

MADHYA PRADESH (INDORE) (Monthly Salary)

31st MAY

Professional Tax

GUWAHATI (ASSAM) (Monthly)

31st MAY

TDS Last Quarter Return

4th Quarter and Annual Return – TDS

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]
Categories
Labour Welfare Fund Payroll punjab

Revised Labour Welfare Fund Punjab

Click here to download notification

This is to bring to your information that Haryana Government has amended the Punjab Labour Welfare Fund Act in its application to Haryana State. As per the notification from now onwards the contribution in Haryana with effect from March’2019, shall be

Employee = 0.2% of employee salary/wages every month (subject to a limit of Rs.25)

Employer =  Twice the employee contribution. Provided, that the limit specified above shall be indexed annually to the consumer price index beginning from 1st January every year. The notification is attached herewith for reference

Click here to download notification

Categories
Provident Fund (PF)

PF (Provident Fund) on Special Allowances

The Supreme Court has held that special allowances paid by an employer to its employees have to be included in “basic wage” for deduction towards provident fund. Now All Allowances (Not HRA) will be part of PF wages.


However If  Basic Wages and other allowances collectively are more than 15,000/- per month than the employer has an option to limit wages for provident fund contribution to INR 15,000/- per month

This video about to how to calculation of PF on allowances and what amount come to as extra cost on employer side and net pay reduce for employee.

Regards – Team Payroll Pedia