The Institute of Payroll Training and Management, India
The Institute of Payroll Training and Management, India
  • Видео 43
  • Просмотров 1 685 888
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...
Просмотров: 9 308

Видео

P.TAX Professional Tax Calculation formula in Excel - PTAX(STATE,SALARY) - IPTM Noida
Просмотров 16 тыс.3 года назад
#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
Просмотров 742 тыс.3 года назад
#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
Просмотров 11 тыс.3 года назад
#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
Просмотров 9 тыс.3 года назад
#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
Просмотров 2,6 тыс.3 года назад
#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 जरूर करे : ruclips.net/user/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
Просмотров 4,8 тыс.3 года назад
#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
Просмотров 5 тыс.3 года назад
#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
Просмотров 10 тыс.3 года назад
#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
Просмотров 16 тыс.3 года назад
#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 जरूर करे : ruclips.net/user/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
Просмотров 20 тыс.3 года назад
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
Просмотров 2,9 тыс.3 года назад
#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
Просмотров 18 тыс.4 года назад
#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
Просмотров 24 тыс.4 года назад
#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
Просмотров 27 тыс.4 года назад
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
Просмотров 31 тыс.4 года назад
Protect multiple pdf files at once with different passwords from Excel automatic | using VBA macro
PF Contribution Reduced to 10% | कॉन्ट्रीब्यूशन में 2 फीसदी कमी | Payroll Training
Просмотров 5 тыс.4 года назад
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
Просмотров 45 тыс.4 года назад
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
Просмотров 1,6 тыс.4 года назад
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
Просмотров 8 тыс.4 года назад
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
Просмотров 2 тыс.4 года назад
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
Просмотров 9584 года назад
New Income Tax Slab | Budget 2020 | Payroll Changes | Indian Payroll Training
CTC salary breakup calculation excel sheet | Automatic Calculation | cost to company
Просмотров 46 тыс.4 года назад
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
Просмотров 25 тыс.4 года назад
How to Make Payroll Sheet | Salary Processing in Excel | Create Employee CTC Register & Payslip
statutory bonus payment calculation excel sheet | Diwali bonus register
Просмотров 13 тыс.4 года назад
statutory bonus payment calculation excel sheet | Diwali bonus register
How to file salary TDS return Form 24Q | e- Filing TDS Quarterly return via RPU
Просмотров 40 тыс.4 года назад
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
Просмотров 3,2 тыс.4 года назад
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
Просмотров 13 тыс.4 года назад
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)
Просмотров 41 тыс.5 лет назад
Latest Bonus calculation formula excel, How to calculate Diwali bonus (Hindi)
Latest income tax calculation 2020-21, how to calculate tax in excel formulas
Просмотров 4,3 тыс.5 лет назад
Latest income tax calculation 2020-21, how to calculate tax in excel formulas

Комментарии

  • @priyasmagicmoments
    @priyasmagicmoments День назад

    Superb thanks it worked out for me

  • @bimleshkumar3275
    @bimleshkumar3275 4 дня назад

    Name of utility please

  • @hemantaboro5403
    @hemantaboro5403 4 дня назад

    Thank many many From many days i trying to do but finally the real video of your helps me

  • @Eclairfreeman
    @Eclairfreeman 10 дней назад

    Thank you

  • @SabithaCH-sx7xy
    @SabithaCH-sx7xy 14 дней назад

    👍👍❤️

  • @gamingwithkamal999
    @gamingwithkamal999 14 дней назад

    Thank you

  • @mdshahzad3266
    @mdshahzad3266 14 дней назад

    Nahi ho raha

  • @juwelsk1846
    @juwelsk1846 19 дней назад

    Thanks

  • @all_exampapers
    @all_exampapers 22 дня назад

    thnx bro👍working

  • @07bhupeshturkar47
    @07bhupeshturkar47 22 дня назад

    sir hmara caste validity validate nhoi hori

  • @user-ke1fw2hg2f
    @user-ke1fw2hg2f 23 дня назад

    Thanx a lot

  • @sagarjadhav2771
    @sagarjadhav2771 24 дня назад

    Hi sir Please confirm, why HRA is not considered in PF wages at time of Pf deduction

  • @sourabhkamble1599
    @sourabhkamble1599 26 дней назад

    This trick really works. You can try this.

  • @satishteja9480
    @satishteja9480 26 дней назад

    Thank you works perfectly

  • @arvindbhandole9178
    @arvindbhandole9178 28 дней назад

    Tx srji❤

  • @faizyabalam9199
    @faizyabalam9199 29 дней назад

    cant download the excel ad-ins

  • @faizyabalam9199
    @faizyabalam9199 Месяц назад

    New excel me f4 kaam ni kr rha. Uske jgh kon sa use karun?

  • @kailashramolavlogs44228
    @kailashramolavlogs44228 Месяц назад

    Thanks

  • @shallurani1357
    @shallurani1357 Месяц назад

    Sir plz do the same calculation as per Punjab regulations I really need it

  • @harini.v.s3333
    @harini.v.s3333 Месяц назад

    i forgot to click all option under trust option in form 16 and submitted my signature for validation now how can edit and click all options for trusted certificate

  • @SFBLOXGAMING
    @SFBLOXGAMING Месяц назад

    Sir iam working in gold mines they are putting salary Tax for us the tax Called P Tax Arrears so what is the meaning of that so they are putting up the penalty in thousands and lacks Once their deductions the money which we filled tax it will return or not they are telling us you are not linked with adhar card and pan card so that we are putting deductions on you

  • @ISHFAQSIR123
    @ISHFAQSIR123 Месяц назад

    Vedio starts at 2:30

  • @pushpitdevhri1476
    @pushpitdevhri1476 Месяц назад

    Bilkul shi process.. I tried and validated successfully.

  • @sougata_mondal
    @sougata_mondal Месяц назад

    It's working

  • @niharr9581
    @niharr9581 Месяц назад

    How do I download pdf now

  • @kirankumar6526
    @kirankumar6526 Месяц назад

    Is there any limit on company can not cross this Percentage of total ctc/ basic salary as HRA?( Max limit)

  • @offtopics3320
    @offtopics3320 Месяц назад

    But basic should be 50 % of gross , the it will be increased , How it will be managed ???

  • @mohammednazeer280
    @mohammednazeer280 Месяц назад

    "Add to Trusted Certificate " under Trust is disabled. Please tell me how to enable it

  • @user-xt3ij9lj2w
    @user-xt3ij9lj2w Месяц назад

    If uu don't do this is yur adhar card invalid

  • @IRAGDAOBORO-i1r
    @IRAGDAOBORO-i1r Месяц назад

    thankyou so much...

  • @zaffarkhan6853
    @zaffarkhan6853 Месяц назад

    Thanks... very useful

  • @yogendrapatel3622
    @yogendrapatel3622 Месяц назад

    Thank you for your help it's very easy 😊

  • @yakulsharma6315
    @yakulsharma6315 2 месяца назад

    File not supporting in protect mode is occuring while trying to add this xlam file

  • @Mouli_Koripella
    @Mouli_Koripella 2 месяца назад

    How to make the digital signature with tick mark with my name

  • @sarahscreativityhub9954
    @sarahscreativityhub9954 2 месяца назад

    Thank you so much!! ❤ This is the only that worked for me.

  • @HimanshiVerma-dg5vt
    @HimanshiVerma-dg5vt 2 месяца назад

    Ye problem aati kyu hai? Aur ye new PC pe bhi aa rha hai issue. Solution nai mila.

  • @dileepmurthy750
    @dileepmurthy750 2 месяца назад

    Thank you

  • @karanmewar4752
    @karanmewar4752 2 месяца назад

    Mobile me hoti hai kya?

  • @spachi116
    @spachi116 2 месяца назад

    Maine baki teen options select nahi kiya ab ' Add to Trusted Cetificates ...' button greyed hai, reset kaise karu?

  • @prashant6051
    @prashant6051 2 месяца назад

    Thanks Alot Sir

  • @Melzina5
    @Melzina5 2 месяца назад

    Great video. Thanku❤

  • @pampunwani1243
    @pampunwani1243 2 месяца назад

    Very well explained! Thank you.

  • @user-sk2po5gq1d
    @user-sk2po5gq1d 2 месяца назад

    Sir, I am not able to download the files. Please help me with files

  • @shabnamsheikh2945
    @shabnamsheikh2945 2 месяца назад

    Such a Great helpful vdo Thanks

  • @lalitkumarseth3336
    @lalitkumarseth3336 2 месяца назад

    Add to trusted certificate wala option me click nhi ho Raha hai kya kare

  • @user-iw1gh9rm4c
    @user-iw1gh9rm4c 2 месяца назад

    Please send sheet sir

  • @sujit247
    @sujit247 2 месяца назад

    ANEK DHANYABAD

  • @gupta2001
    @gupta2001 2 месяца назад

    Your code sows error guys use this code (Sub SaveAsPDF() Dim i As Long Dim folderPath As String Dim fileName As String Dim docName As String ' Specify the folder where PDF files will be saved folderPath = "C:\Users\Username\Downloads\Mail merge format\" ' Loop through each record in the mail merge For i = 1 To ActiveDocument.MailMerge.DataSource.RecordCount ' Go to the specified record With ActiveDocument.MailMerge .Destination = wdSendToNewDocument .SuppressBlankLines = True With .DataSource .FirstRecord = i .LastRecord = i .ActiveRecord = i ' Extract document name from the first field of the active record docName = .DataFields(1).Value End With .Execute Pause:=False End With ' Generate the filename using the extracted document name fileName = folderPath & docName & ".pdf" ' Save the current document as PDF ActiveDocument.ExportAsFixedFormat OutputFileName:= _ fileName, ExportFormat:=wdExportFormatPDF, _ OpenAfterExport:=False, OptimizeFor:= _ wdExportOptimizeForPrint, Range:=wdExportAllDocument, From:=1, To:=1, _ Item:=wdExportDocumentContent, IncludeDocProps:=True, KeepIRM:=True, _ CreateBookmarks:=wdExportCreateNoBookmarks, DocStructureTags:=True, _ BitmapMissingFonts:=True, UseISO19005_1:=False ' Close the generated document ActiveWindow.Close SaveChanges:=wdDoNotSaveChanges Next i End Sub)

  • @ShreyashMane-kh1qf
    @ShreyashMane-kh1qf 3 месяца назад

    Thanks