Complete Salary Computation in Excel | Payroll calculation in excel

📍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 in-depth 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 2018-19,
july 2020 salary calculation,
salary income tax calculation 2019-20,