The Institute of Payroll Training and Management, India
The Institute of Payroll Training and Management, India
  • 43
  • 1 698 009
payroll calculation, practices and payroll training | live employee data | free excel add-ins - IPTM
#iptmnoida #payrolltraining #payrollcalculation
payroll calculation, practices and payroll training | live employee data | free excel add-ins - IPTM
Follow this video and you can do live Indian payroll calculation in excel and you can do more than 200+ payroll calculation practices in excel.
You can apply your payroll training knowledge so that practice in excel on live employee data to brush up topics. download free excel add-in provided by IPTM - The Institute of Payroll Training and Management and start payroll practices.
Option 1. Add-ins Download link - forms.gle/fUwQdWQKbVdwa9UW9
Option 2. Write an email with introduction at : iptm.india@gmail.com
Option 3. Direct Link to Download: bit.ly/3GJFFYq
Copy and paste above links in browser directly in case you are facing error.
⌚ Timestamps
00:00 Introduction
03:05 Employee Master Payroll Practice
07:15 Income Tax TDS Calculation Practice
10:00 CTC Calculation Practice
11:45 Payroll Calculation Practice in Excel
17:45 Salary Slip PaySlip Generate in Excel
20:15 PF Provident Fund Calculation Practice
21:50 PF ECR and Challan from Excel
22:45 PTax Professional Tax and LWF Labour welfare Calculation Practice
24:24 Salary Increment Arrear Calculation Practice
26:25 Gratuity and Death Gratuity Calculation Practice
28:06 Bonus Payment Calculation Practice
30:11 how to install Excel add-ins
33:12 Next video
34:00 Thank You
🔔 Channel Subscribe जरूर करे : czcams.com/users/IptmOrgInakumar
_____________________________________________________
☑️Payroll Training Course by IPTM: www.iptm.org.in
☑️New Batch Enquiry: bit.ly/training-enquiry
Payroll Blog: www.payrollpedia.org/
Excel Blog: 99excel.com/home/
Excel Tools: 99excel.com
_____________________________________________________
EQUIPMENT’S & SERVICES I USE:
Laptop: amzn.to/3bE0JDD
Webcam: amzn.to/2LqRkVl
Microphone (Boya): amzn.to/2LtEMMW
4K Ultra HD Smart LED TV: amzn.to/3ssTNPD
Chromakey Green Scree: amzn.to/3sAMbL9
CREATED BY:
Ajit Kumar Yadav (AKumar)
Follow on Instagram: akumar0808
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
Thanks for coming over here.
#iptmnoida #iptmpayroll
WORDS IN VIDEO AS HASHTAG
#payroll #problem #database #employee #master #experience #company #handle #compliances #unlimited #data #free #video #discussion #download #software #install #shortcut #homework #excel #sheet #interview #surcharge #format #joining #advanced #gratuity #month #formula #calculate #senior #punjab #mis #management #information #system #summary #grade #knowledge #taxable #bonus #allocation #overtime #educationcess #marginaltax #calculator #automatic #books #college #university #payslip generator #study #example #incrementpercentage #houserent #metro #nonmetro #payroll institute #payslip #opportunity #pfchallan #increment #function #teachers #institution #resume
payrollcalculation + payrollproblem + employeedatabase + payrollemployee + payrollmaster + payrollexperience + payrollcompany + payrollhandle + payrollcompliances + unlimitedpayroll + employeedata + freeexcelpayroll + payrolltrainingvideo + payrolldiscussion + freedownload + payrollsoftware + addinsinstall + keyboardshortcut + payrollhomework + excelcalculation + excelsheet + payrollinterview + surchargecalculation
#payrollcalculation, #payrollproblem, #employeedatabase, #payrollemployee, #payrollmaster, #payrollexperience, #payrollcompany, #payrollhandle, #payrollcompliances, #unlimitedpayroll, #employeedata, #freeexcelpayroll, #payrolltrainingvideo, #payrolldiscussion, #freedownload, #payrollsoftware, #addinsinstall, #keyboardshortcut, #payrollhomework, #excelcalculation, #excelsheet, #payrollinterview, #surchargecalculation, #payrollformat, #employeejoining, #advancedexcelpayroll, #gratuitycalculation, #payrollmonth, #excelformula, #calculatepayroll, #seniorcitizen, #punjabptax, #misreport, #payrollmanagement, #payrollinformation, #payrollsystem, #payrollsummary, #employeegrade, #payrollknowledge, #taxableincome, #bonuscalculation, #allocationsurplus, #overtimepayment, #educationcesscalculation, #marginaltaxcalculation, #incometaxcalculator, #payrollautomatic, #payrollbooks, #payrollincollege, #payrollinuniversity, #payslipgeneratorautomatic, #payrollstudy, #payrollexample, #employeeincrementpercentage, #employeehouserent, #metrocity, #nonmetrocity, #payrollinstitutenoida, #payslippdf, #payrollopportunity, #pfchallangenerate, #incrementletter, #payrollfunction, #payrollteachers, #payrollinstitution, #payrollresume
zhlédnutí: 9 420

Video

P.TAX Professional Tax Calculation formula in Excel - PTAX(STATE,SALARY) - IPTM Noida
zhlédnutí 16KPřed 3 lety
#iptmnoida #payrolltraining #PayrollPlayer P.TAX Professional Tax Calculation formula in Excel - PTAX(STATE,SALARY) - IPTM Noida In this video, i have explain and give you free download excel vba function to calculate P.Tax Professional Tax in India for all states. Formulas Name: = PTAX(STATE,SALARY) Download Link: payrollpedia.org/ptax-professional-tax-calculation-formula-in-excel-add-ins-free...
how to validate digital signature in pdf file, DSC validation process in TDS form 16 | IPTM
zhlédnutí 750KPřed 3 lety
#iptmnoida #payrolltraining #PayrollPlayer how to validate digital signature in pdf file, DSC validation process in TDS form 16 | IPTM In this video, i have explain how to validate digital signature certificate DSC token in pdf file step by step. ⌚ Timestamps 00:01 Introduction 00:02 digital signature validation steps and process 00:03 Validated digital signature icon 🔔 Channel Subscribe जरूर क...
how to generate PF ECR text file automatic from excel - vba code for EPFO portal | IPTM
zhlédnutí 11KPřed 3 lety
#iptmnoida #payrolltraining #PayrollPlayer how to generate PF ECR text file automatic from excel - vba code for EPFO portal | - IPTM Excel VBA code with ready made process to generate and check monthly PF provident fund ECR (Electronic Challan Report) automatic from Excel in 1 click. Follow the ECR Format as downloaded from Unified portal (PF Website) Fill the all columns e.g. wage, contributio...
how to sign tds form 16 digitally from excel - VBA Code to add digital signature on pdf | - IPTM
zhlédnutí 9KPřed 3 lety
#iptmnoida #payrolltraining #PayrollPlayer how to sign tds form 16 digitally from excel - VBA Code to add digital signature on pdf In this video, explain the excel vba code to signed pdf files from excel, this tutorial will help HR and Payroll guys those are looking a free utility to adding signature to pdf using vba code and without cost. How to digitally signed form 16 from Excel using VBA Co...
How to merge, protect, digital signed and email TDS form 16 to employee from excel vba | - IPTM
zhlédnutí 2,7KPřed 3 lety
#iptmnoida #payrolltraining #PayrollPlayer In this video, explain how to merge, password protect,, digital signature in pdf and send form 16 to your employee. Know more: www.payrollpedia.org/how-to-merge-protect-digital-signed-and-email-tds-form-16-to-employee-from-excel-vba/ 🔔 Channel Subscribe जरूर करे : czcams.com/users/IptmOrgInakumar ☑️Payroll Training Course by IPTM: www.iptm.org.in ☑️New...
how to file salary tds return form 24q for last quarter in excel | annual return for form 16 - IPTM
zhlédnutí 4,8KPřed 3 lety
#iptmnoida #payrolltraining #PayrollPlayer In this video, i have explain how to use excel format to validate and fill salary tds form 24Q for last quarter AY 2021-22. this return will validate automatic from vba code and prepare annual return salary details for generating form 16. last date for filling form 24 is 31 May. Need any help? WhatsApp me: 919654421288 ⌚ Timestamps 00:00 Introduction 0...
Tax on PF (Provident Fund) Employee PF and Employer PF
zhlédnutí 5KPřed 3 lety
#iptmnoida #Payrolltraining #PF Learn taxation on Tax on PF (Provident Fund) Employee PF and Employer PF. 1. Any amount in excess of Rs. 7.50 lakh contributed by the employer to recognised provident fund accounts taken together shall be treated as perquisite in the hands of the employee. it includes, PF, SUPERANNUATION AND NPS. 2. As announced in the Budget 2021, effective from April 2021 onwar...
Salary Increment PDF Letters from mail merge - Increment PDF लेटर कैसे बनाते है - IPTM Noida
zhlédnutí 10KPřed 3 lety
#Increment #Salary #iptmnoida Salary Increment PDF Letters from mail merge - Increment PDF लेटर कैसे बनाते है - IPTM Noida. I will explain below one of the most common practice used in HR - human resource department e.g. Increment Letters Preparation, please follow the all steps. I will refer here following steps and topics: A Excel sheet with 5000 employee's A word file which Increment letter ...
Payslip Sender - How to send payslip via email to employee from excel - IPTM Noida
zhlédnutí 16KPřed 3 lety
#Payroll #Email #Employee #Excel #iptmnoida In this video, I have explain a ready made Excel tool for sending Employee Salary slip over the email, This is called Payslip Sender and learn How to send payslip via email to employee from excel. 🔔 Channel Subscribe जरूर करे : czcams.com/users/IptmOrgInakumar ☑️Payroll Training Course by IPTM: www.iptm.org.in ☑️New Batch Enquiry: bit.ly/training-enqu...
LTA Claim Exemption benefits through GST Bills | Leave Travel Allowance New Rules | IPTM Noida
zhlédnutí 20KPřed 3 lety
LTA Claim Exemption benefits through GST Bills | Leave Travel Allowance New Rules | IPTM Noida. Claiming LTA benefits through GST paid goods and services is new LTA or leave travel concession updates for 2020-21. Due to the Covid-19 pandemic, many people are not in a position to travel with family and, therefore, are unable to claim Leave Travel Allowance (LTA). With a view to let such persons ...
Automatic Attendance Sheet in Excel with Formula in Hindi | How to Make Attendance Register | IPTM
zhlédnutí 2,9KPřed 3 lety
#PayrollTraining #IPTMNOIDA #PAYROLL Learn how to make automatic Attendance Sheet in Excel with Formula in Hindi and How to Make Attendance Register and download it from IPTM bog website www.payrollpedia.org Direct Download Link: www.payrollpedia.org/free-download-attendance-sheet-in-excel-with-formula In this video, I explain ready-made automatic attendance excel sheet register with Excel Form...
How to Convert Excel to PDF VBA | Salary Slip in Excel and Convert in PDF
zhlédnutí 19KPřed 4 lety
#Excel #ExcelVBA #Payrolltraining #iptmnoida In this video, you will learn how to convert Excel sheet in PDF using VBA code. I have linked a Salary slip format with row data of payroll employee and made it dynamic once serial number changed in row number A1. Code and Sheet download link: www.payrollpedia.org/how-to-convert-excel-to-pdf-vba/ Keywords: excel to pdf formula, excel to pdf vba, exce...
salary tds return 24q filing procedure - quarterly tds return for salary: 24q
zhlédnutí 24KPřed 4 lety
#TDS #IPTMNOIDA #PAYROLL Salary tds return 24q filing procedure - Y 2020-21 and how to file TDS return In this video, i m referring a excel vba sheet for 24Q return prepaying, You can download it from below link. Know more: bit.ly/2OcfBvR :::Keywords: How to file salary TDS return Form 24Q | e- Filing TDS Quarterly return via RPU and FVU 26Q, how to file tds return on nsdl site Salary tds calcu...
FVU Validation Errors - Salary TDS Return For 24Q Filing Submission
zhlédnutí 27KPřed 4 lety
FVU Validation Errors - Salary TDS Return For 24Q Filing Submission This is my first video on IPTM channel, I explain in this video about error and their solutions while validating Returns. Voice: Credit: Team IPTM and My Batch Mates ( Poonam ,Versha ,Ekta ,Mahesh ,Juanita ,Mounika ,Saurabh ,Neha ,Devashree ,Sonali ,Parivas ,Ila ,Kavya ,Akshata ,Meenu ,Rajlakshmi ,Nikita ,Kusum ,Shivani ,Sanjan...
Protect multiple pdf files at once with different passwords from Excel automatic | using VBA macro
zhlédnutí 31KPřed 4 lety
Protect multiple pdf files at once with different passwords from Excel automatic | using VBA macro
PF Contribution Reduced to 10% | कॉन्ट्रीब्यूशन में 2 फीसदी कमी | Payroll Training
zhlédnutí 5KPřed 4 lety
PF Contribution Reduced to 10% | कॉन्ट्रीब्यूशन में 2 फीसदी कमी | Payroll Training
Create Individual Increment PDF from Mail Merge | How to Mail Merge in MS Word in Hindi | Excel link
zhlédnutí 45KPřed 4 lety
Create Individual Increment PDF from Mail Merge | How to Mail Merge in MS Word in Hindi | Excel link
Time Saving Excel Trick | Autocorrect in Excel and Outlook | Excel for Payroll | IPTM
zhlédnutí 1,6KPřed 4 lety
Time Saving Excel Trick | Autocorrect in Excel and Outlook | Excel for Payroll | IPTM
HRA - House Rent Allowance Rules in CTC Salary for metro and Non Metro city | Payroll Training
zhlédnutí 8KPřed 4 lety
HRA - House Rent Allowance Rules in CTC Salary for metro and Non Metro city | Payroll Training
Income Tax Slabs | Tax Rates | Calculation for FY 2020-21 | Old vs New | Payroll Training
zhlédnutí 2KPřed 4 lety
Income Tax Slabs | Tax Rates | Calculation for FY 2020-21 | Old vs New | Payroll Training
New Income Tax Slab | Budget 2020 | Payroll Changes | Indian Payroll Training
zhlédnutí 958Před 4 lety
New Income Tax Slab | Budget 2020 | Payroll Changes | Indian Payroll Training
CTC salary breakup calculation excel sheet | Automatic Calculation | cost to company
zhlédnutí 46KPřed 4 lety
CTC salary breakup calculation excel sheet | Automatic Calculation | cost to company
How to Make Payroll Sheet | Salary Processing in Excel | Create Employee CTC Register & Payslip
zhlédnutí 25KPřed 4 lety
How to Make Payroll Sheet | Salary Processing in Excel | Create Employee CTC Register & Payslip
statutory bonus payment calculation excel sheet | Diwali bonus register
zhlédnutí 13KPřed 4 lety
statutory bonus payment calculation excel sheet | Diwali bonus register
How to file salary TDS return Form 24Q | e- Filing TDS Quarterly return via RPU
zhlédnutí 40KPřed 4 lety
How to file salary TDS return Form 24Q | e- Filing TDS Quarterly return via RPU
Professional Tax Class PT, P.Tax in Indian State (AKumar Live Class Video Leaked) April 2019 Batch
zhlédnutí 3,2KPřed 4 lety
Professional Tax Class PT, P.Tax in Indian State (AKumar Live Class Video Leaked) April 2019 Batch
How to make CTC, Payroll, Income Tax and Salary Pay Slip In Excel : 2019 - 2020
zhlédnutí 13KPřed 5 lety
How to make CTC, Payroll, Income Tax and Salary Pay Slip In Excel : 2019 - 2020
Latest Bonus calculation formula excel, How to calculate Diwali bonus (Hindi)
zhlédnutí 41KPřed 5 lety
Latest Bonus calculation formula excel, How to calculate Diwali bonus (Hindi)
Latest income tax calculation 2020-21, how to calculate tax in excel formulas
zhlédnutí 4,3KPřed 5 lety
Latest income tax calculation 2020-21, how to calculate tax in excel formulas