Complete Salary Computation in Excel | Payroll calculation in excel скачать в хорошем качестве

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,