Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Complete Salary Computation in Excel | Payroll calculation in excel. That video is uploaded by FinTaxPro at 2021-05-06T06:30:20-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [XHFC1WDMaN4]
| Name | Complete Salary Computation in Excel | Payroll calculation in excel |
| Video Uploader | Video From FinTaxPro |
| Upload Date | This Video Uploaded At 06-05-2021 13:30:20 |
| Video Discription | ๐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 ๐ฉ info@fintaxpro.in ๐9718097735 ๐For Digital Content and collaboration ๐ฉ vivek@fintaxpro.in ๐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, XHFC1WDMaN4 |
| Category | Education |
| Tags | salary calculation in india excel | salary calculation excel sheet | salary calculation sheet excel | salary calculation sheet in excel | salary calculator india excel sheet | salary calculation in excel with formula | payroll calculation formula | payroll calculation in excel sheet | payroll calculation in excel sheet india | payroll salary calculation formula | fintax pro | salary template excel | salary in excel | salary calculation in excel | payroll calculation | salary sheet in excel |
