In this session we have discuss about the complete payroll preparation in India. We have also discuss the statutory compliance include in payroll preparation. You will be able to learn below topics after watching this session
Salary Structure of a company
Cost to Company CTC and in Hand Salary
Complete Salary Computation in Excel
EPF calculation and compliance
ESI calculation and compliance
Bonus calculation and compliance
Gratuity calculation and compliance
TDS calculation and compliance

Below are the due dates for industrial compliance
PF payment due date 15th of following month
ESI payment due date 15th of following month
TDS due date 7th of following month
Gratuity payment (to employee) at retirement
Bonus payment(to employee) 30th Sept of following year

Download Salary sheet https://bit.ly/3vQfABL

‍Enroll to our practical course in TDS, ITR & GST Filing
Enrollment Link https://bit.ly/3uENoRn
Create your account
Proceed for payment
After payment you can access your complete course
Get Certificate after course completion

Download FREE payroll app: https://bit.ly/3h29KZT

⏰Time Stamp
0:00 Excel and Payroll preparation
2:34 Salary Sheet Template
5:01 What is Salary Structure?
12:42 Calculation of Basic Salary
16:53 Calculation of HRA
18:03 Calculation of special allowance
20:00 Calculation of Gross Salary
20:20 Calculation Employee PF
27:16 Calculation of Employee ESI
33:36 Calculation of TDS on salary
37:44 Calculation of professional tax
38:41 Calculation of Net Salary
40:04 Calculation of Employer PF
40:52 Calculation of PF Admin expenses
43:26 Calculation of Employer ESI expenses
45:13 Calculation of Gratuity
47:33 Calculation of Bonus
48:55 Bonus Act and Daily Wage Act
58:55 CTC calculation
1:02:42 Outro


For tax consultancy, payroll management and query please contact below
[email protected]
9718097735

For Digital Content and collaboration
[email protected]
8368741773

Cheers Folks
Thanks for Watching :)
Team Fintaxpro
www.fintaxpro.in

Disclaimer Although all provisions, notifications, updates and live demo are analyzed indepth by our team before presenting to public. We hereby provide our point of view only and tax matter are always subject to frequent changes hence advisory is only for the benefit of general public. Hence neither Fintaxpro Advisory LLP nor its designated partner are liable for any consequence arises on the basis of You Tube videos.

#payroll #payroll #ESI #PF #provident #fund #bonus #salary #computation #compliance #gratuity #tds #perquisites #overtime #OT #arrearsalary #advancesalary #increment #incentive #costtocompany #ctc #inhandsalary #inhand #bank #statutory #bonus #HRA #DA #basic #inter #bcom #india

This video will also guide on below topics
Complete Salary Computation in Excel
Payroll calculation excel
In hand Salary
Basic Salary
salary calculation formula,
salary calculation in income tax,
salary calculation in excel,
salary calculation formula in excel sheet,
salary calculation app,
salary calculation after 11th bps,
basic salary calculation,
salary bonus
salary components and calculation,
salary ctc calculation excel,
due drawn salary calculation in excel,
da salary calculation,
per day salary calculation formula,
salary calculation excel,
salary calculation excel sheet,
tds salary calculation excel format,
salary arrear calculation in excel,
excel salary calculation formula,
epf salary calculation,
hourly salary calculation in excel,
e salary,
salary calculation formula in excel,
pf salary calculation,
pf salary calculation formula,
pf calculation on salary in excel,
pf deduction from salary calculation,
salary calculation with pf and esi,
gross salary calculation,
govt salary calculation,
grade pay salary calculation in hindi,
salary gratuity calculation india,
calculation of grade salary,
gross salary calculation in excel,
hr salary calculation,
how to salary calculation in excel,
hra salary calculation,
half pay salary calculation,
hpl salary calculation,
salary calculation in tally,
salary calculation in excel with formula,
salary calculation in ms access,
salary calculation july 2020,
employee salary calculation in java,
july salary calculation,
salary calculation kaise kare,
hpl leave salary calculation,
esi leave salary calculation,
monthly salary calculation,
esi maternity salary calculation,
net salary calculation formula,
salary calculation on excel sheet,
salary calculation percentage,
salary pf calculation,
payroll salary calculation formula,
salary calculation rules,
railway salary calculation,
salary calculation sheet in excel,
salary calculation salary formula,
pay scale salary calculation,
salary scale calculation,
excel sheet salary calculation formula,
salary tax calculation,
salary calculator un,
salary calculation 11th,
tds on salary calculation 201819,
july 2020 salary calculation,
salary income tax calculation 201920,