Categories
India Payroll

Best Indian Payroll, Taxation & Compliance Training Institute – Verified by AI! 🚀

When searching for the best payroll, taxation, and compliance training institute in India, we all want the most authentic and practical training experience. But with so many options available, how do you know which one truly stands out?

Well, we decided to put AI to the test! 🤖💡

We asked leading AI platforms like ChatGPT, Copilot, and Grok the same question:

👉 “Which is the best Indian Payroll, Taxation & Compliance Training Institute that provides live & practical training?”

And guess what? All of them pointed to one name—IPTM (www.iptm.org.in)! 🎯


🎥 Watch the Proof! AI Recommends IPTM as the Best Payroll Training Institute

We recorded our entire search session, capturing how these advanced AI models all came to the same conclusion. Check out the video below to see AI in action! 🎬👇

📽️ [Embed Your Video Here]


Why IPTM? What Makes It the Best?

💡 Live & Practical Training – Not just theory, but hands-on learning with real-world payroll scenarios.
📚 Expert Faculty – Led by industry professionals with years of experience.
💼 Comprehensive Curriculum – Covers payroll management, taxation laws, compliance, and HR policies.
Industry-Recognized Certification – Enhance your career with a certification trusted by top companies.
🌎 Flexible Learning – Online and offline training options for working professionals and students.

IPTM isn’t just another training institute—it’s a game-changer for anyone looking to master payroll and compliance.


📢 Ready to Level Up Your Payroll Career?

🔥 Join IPTM Today! Visit www.iptm.org.in and start your journey towards payroll expertise.

🎯 Know someone looking for the best payroll training? Share this post and let them see what AI has confirmed! 🚀

Categories
India Payroll

Documents Required for Form 10D and How to Submit Form 10D Pension Form

Form 10D is a crucial document used to claim family pension, and it is an integral part of the pension process for eligible individuals. Family pension is provided to the family members of a deceased employee who was covered under the Employees’ Pension Scheme (EPS) under the Employees’ Provident Fund Organization (EPFO) in India. Form 10D serves as an application for obtaining the family pension.

Below is a comprehensive guide on the documents required for Form 10D and how to submit the form to claim family pension:

Documents Required for Form 10D:

  1. Application Form 10D: This is the main form that needs to be duly filled and signed by the eligible family member(s) who are claiming the family pension. The form collects essential information such as the deceased employee’s details, family member details, and pension details.
  2. Death Certificate: A copy of the death certificate of the employee is required as proof of the demise.
  3. Dependent Family Member Proof: Documents such as marriage certificates, birth certificates, or any other legal proof establishing the relationship between the deceased employee and the family members claiming the pension. This is important to verify the eligibility of the claimants.
  4. Family Member’s Identity Proof: Identity proofs of the family members applying for the family pension, such as Aadhar card, PAN card, or voter ID card.
  5. Bank Account Details: Bank account details, including the bank account number, IFSC code, and the name of the bank branch, are necessary for disbursing the family pension amount.
  6. Canceled Cheque: A canceled cheque from the bank account in which the family pension is to be deposited. This is to ensure accurate fund transfer.
  7. Employee’s EPF Account Details: Details of the employee’s Employees’ Provident Fund (EPF) account, including the Universal Account Number (UAN), are required to verify the employment history.
  8. Nomination Details: If the deceased employee had nominated family members for receiving pension benefits in the event of their demise, these details need to be provided.
  9. Medical Certificate: In cases where the death of the employee is due to illness, a medical certificate may be required to establish the cause of death.

How to Submit Form 10D Pension Form:

  1. Obtain Form 10D: Form 10D can be obtained from the official website of the Employees’ Provident Fund Organization (EPFO) or from your employer’s HR department.
  2. Fill Out the Form: Carefully fill out all the required information in Form 10D. Double-check the details to ensure accuracy.
  3. Attach Documents: Attach all the necessary documents mentioned above, including the death certificate, dependent family member proof, identity proofs, bank account details, canceled cheque, and any other supporting documents.
  4. Submit to EPFO: Submit the filled and signed Form 10D along with the attached documents to the nearest regional EPFO office. Ensure that all required copies of documents are submitted.
  5. Acknowledgment Receipt: The EPFO office will provide an acknowledgment receipt after receiving your application. Keep this receipt safe as it may be required for future reference.
  6. Verification and Processing: The EPFO will verify the documents and information provided. If everything is in order, they will process the application for family pension.
  7. Disbursement of Family Pension: Once the application is approved, the family pension amount will be disbursed to the nominated bank account of the eligible family member(s).

ActionWhat to DoWhat Not to Do
Obtain Form 10DObtain Form 10D from the official EPFO website or your employer’s HR department.Don’t use outdated or unofficial versions of the form.
Fill Out Form 10DFill out the form accurately with complete and correct information.Don’t leave any required fields blank.
Attach Supporting DocumentsAttach required documents such as death certificate, dependent family member proof, identity proofs, bank account details, and canceled cheque.Don’t submit incomplete or unclear photocopies of documents.
Verify Family Member DetailsEnsure that all family member details are correctly mentioned, including their relationship with the deceased employee.Don’t provide incorrect or inaccurate family member information.
Provide Accurate Bank Account DetailsProvide accurate bank account details for pension disbursement, including bank account number, IFSC code, and bank branch name.Don’t provide incorrect or invalid bank account information.
Check Form for AccuracyDouble-check the filled form for accuracy and ensure that all fields are correctly filled.Don’t rush through the form without verifying the information provided.
Submit to Nearest Regional EPFO OfficeSubmit the filled and signed Form 10D along with the attached documents to the nearest regional EPFO office.Don’t submit the form to unauthorized or unofficial entities.
Keep Acknowledgment Receipt SafeSafely keep the acknowledgment receipt provided by the EPFO office upon submission.Don’t lose the acknowledgment receipt, as it may be required for future reference.
Follow Up if No CommunicationIf you don’t receive any communication within a reasonable time, follow up with the EPFO office to inquire about the status of your application.Don’t assume everything is proceeding smoothly without any follow-up.
Verify Current Submission Process and RequirementsRegularly check the official EPFO website or contact the regional EPFO office to verify the current submission process and requirements.Don’t rely solely on outdated information or assumptions about the submission process.
Retain Copies of Submitted DocumentsKeep copies of all submitted documents and forms for your records.Don’t discard any documents after submission; you might need them for reference.
Be Patient During ProcessingBe patient during the processing period, as it may vary based on verification and administrative processes.Don’t rush or panic if you don’t receive an immediate response; processing times can vary.
Notify Changes in Contact InformationIf your contact information changes, notify the EPFO office to ensure proper communication.Don’t forget to update the EPFO office if there are changes to your contact details.

Remember that the information provided here is a general guideline. Always refer to the official EPFO sources and follow their instructions for accurate and up-to-date information.

Important Tips:

  • Ensure that all information provided in Form 10D is accurate and matches the supporting documents.
  • Keep copies of all documents submitted for your records.
  • Follow up with the EPFO office if you don’t receive any communication within a reasonable time frame.
  • It’s advisable to visit the official EPFO website or contact the regional EPFO office to verify the current submission process and requirements, as they may vary over time.

Call to action:

If you are a pensioner, you can download the required forms and certificates from the EPFO website. You can also submit your claim online through the EPFO’s website.

The EPFO has made it easier for pensioners to claim their benefits. With the new procedures, you can easily claim your pension and start receiving your benefits on time.

In addition to the above, here are some other things to keep in mind when submitting your pension claim:

  • All of the documents must be original or certified copies.
  • The documents must be in good condition and should not be damaged or tampered with.
  • The documents must be submitted within 12 months of the date of retirement.

If you have any questions about the pension claim process, you can contact the EPFO helpline at 1800118005.

Q1: What is Form 10D? A1: Form 10D is an application form used to claim family pension by eligible family members of a deceased employee covered under the Employees’ Pension Scheme (EPS) under the Employees’ Provident Fund Organization (EPFO) in India.

Q2: Who is eligible to apply using Form 10D? A2: Family members, including spouses, children, and dependent parents, are eligible to apply for family pension using Form 10D in case of the demise of the EPS-covered employee.

Q3: What documents are required to submit along with Form 10D? A3: The documents required include the filled and signed Form 10D, death certificate of the employee, dependent family member proof (birth/marriage certificates), identity proofs of family members, bank account details, canceled cheque, employee’s EPF account details, and nomination details.

Q4: How can I obtain Form 10D? A4: Form 10D can be obtained from the official website of the Employees’ Provident Fund Organization (EPFO) or from your employer’s HR department.

Q5: How do I fill out Form 10D? A5: Carefully fill out all the required information in Form 10D, including details of the deceased employee, family members, bank account information, and more.

Q6: Can I submit Form 10D online? A6: As of my last update in September 2021, the submission of Form 10D might not be available online. It’s recommended to visit the official EPFO website or contact the regional EPFO office to check the current submission process.

Q7: Where do I submit Form 10D? A7: You need to submit the filled and signed Form 10D along with the attached documents to the nearest regional EPFO office.

Q8: What happens after I submit Form 10D? A8: The EPFO office will verify the submitted documents and information. If everything is accurate and in order, they will process the application for family pension.

Q9: How long does it take for the family pension to be disbursed? A9: The processing time may vary, but once the application is approved, the family pension amount will be disbursed to the nominated bank account of the eligible family member(s).

Q10: What should I do if I don’t receive any communication after submission? A10: If you don’t receive any communication within a reasonable time frame, consider following up with the EPFO office to inquire about the status of your application.

Q11: Can I claim family pension if the deceased employee had nominated me earlier? A11: Yes, if the deceased employee had nominated you for receiving pension benefits in the event of their demise, you can include those nomination details in your Form 10D application.

Download Form 10D and Non-Employment Certificate Form

To help you get started, we’ve made Form 10D and the Non-Employment Certificate Form available for download:

  1. Form 10D: Download Form 10D
  2. Non-Employment Certificate Form: Download Non-Employment Certificate Form

These downloadable forms can assist you in preparing your family pension claim application accurately and efficiently.

Remember that the process and guidelines may change over time, so it’s essential to verify the current information from official sources or contact the relevant authorities for the most accurate and up-to-date guidance.

In conclusion, submitting Form 10D for family pension requires careful attention to detail and accurate documentation. It’s essential to provide all required documents to facilitate the smooth processing of the pension claim. Following the official guidelines and keeping accurate records will ensure a hassle-free process for claiming family pension benefits.

Categories
free payroll sheet India Payroll Salary and CTC Breakup Salary Breakup Calculator Excel

Free Payroll Software in Excel with automatic CTC and tax calculation

Click here to download automatic Complete Payroll Calculator in Excel. This Excel Software includes most likely all part of Payroll Calculation. It’s Includes following Features:-

  • You can calculate Cost to company CTC Automatic once you put total ctc.
  • You can restructure allowances and CTC components as per your need.
  • Income Tax  to be calculate automatic.
  • You can set your investment Declaration or Proofs Planing as per requirement.
  • This sheet will calculate House rent allowance ( HRA Rent Exemption calculation) under section 10(13A) automatic as per your rent paid and selected city.
  • You can customize your structure like add / less : PF (Employees’ Provident Fund), Employment State Insurance ( ESIC), Gratuity, Mediclaim, any other benefit, Bonus, Minwages.
  • You can control to deduct PF on Basic OR PF on Allowances or PF on min wages of PF or you can select No if you are not eligible for pf deduction.
  • You can Se-off loss / income from house property u/s 24(b) as per Income Tax Act.
  • You can add reimbursement components as per bills planing to get more benefit in tax.
  • This sheet will give you Net payment Automatically as per your Inputs.
  • Best part of this software is that, you can generate  your salary pay slip from CTC in one click and change payslip in excel as per needs.
  • We have added logo on slip so that you can change it.
  • You can generate any month salary slip from excel format in one click even you can generate full and final slip.
  • This is Free to download
  • Paid Support Available at :
  • Email: ajityadav121@gmail.com
  • Call/WhatsApp: +91 9654421288

Click here to Download Automated Excel Sheet to calculate cost to company (CTC), Income Tax Calculation for CY financial year along with all investment planning (Deduction U/C VI-A)  and all Major Exemptions allowed + reimbursement  in Salary.

This sheet will allowed to planning your tax saving, make salary structure as per your choice and know the Net in hand Automatically.

Thanks! AKumar

Categories
India Payroll Salary Tax Return (ITR)

salary tds return 24q filing procedure – quarterly tds return for salary: 24q Excel form

In this video, I have explain how to use Excel VBA sheet to fill the qtr return form 24Q.

Suggested you to fill the return from RPU but RPU is heavy and time taking so you can buy this Excel sheet but for this you need to pay Rs. 1000/-.

Call us: +91 8595783766 / 9654421288 / 9312580474

Categories
India Payroll Payroll

Download Income Tax Calculator in Excel for FY 2020-21 [AY 2021-22] Comparison Old and New Regime

Download Income Tax Calculator in Excel for FY 2020-21 [AY 2021-22] Comparison Old and New Regime.

Excel Tax calculator ready To help taxpayers here is a simple excel based Income Tax Calculator for the financial year 202021 (AY 2021-22). The calculator is made using simple excel formulas and functions.

Categories
India Payroll

New and Old Tax Slab Computation in Excel 2020-21

Categories
80C Deductions India Payroll NSC Interest Calculator

NSC Interest Calculator of last 5 years – National Savings Certificate Calculator in Excel for 2019-20

Download NSC Interest Calculator in Excel for deduction under section 80C of Income Tax Act, 1961. Interest earned on NSC purchased of last 5 years is taxable in hand of assesses and it also deductible under section 80C up to limit of section ( currently 80 max. limit is 150000). Click here to download NSC Calculator in Excel.

What is NSC:

National Savings Certificate is a popular mode of small savings investment in India. The NSC rate of interest has been fixed by the government. The NSC (National Saving Certificate) Calculator allows you to calculate the return on your investment when saving using the National Savings Certificate Scheme.

NSC Restrictions

The National Saving Certificate Scheme (NSC) is an excellent investment opportunity but there are some restrictions you should be aware of.

  1. The National Saving Certificate (NSC) scheme has a minimum investment threshold of ₹100.00
  2. National Saving Certificates are issued at a minimum of ₹100.00 certificates though you can also purchase ₹500.00, ₹1,000.00, ₹5,000.00, ₹10,000.00 denomination certificates.
  3. There is no limit on the number of National Saving Certificates that you can buy.

Type of NSC Certificates

There are 3 different types of National Savings Certificate

  1. Single holder Type Certificate: Issued to an individual (the holder) or to an individual on behalf of a minor.
  2. Joint A type Certificate: Issued jointly to two adults. On maturity, the NSC is paid to both of the joint holders
  3. Joint B type Certificate: Issued jointly to two adults in the same way as Joint A type NSC (see above) withe the difference that on maturity, the NSC is paid to one (either one) of the joint holders.
Categories
Excel Formulas & VBA Code Excel VBA Dashboard India Payroll Payroll

Merge Part A and Part B of Form 16 in Excel

Greetings!

I believe, You are searching a free tool which can merge or combine Part A and Part B in 1 PDF in automation process. if yes, you are at right place.

As per Income tax India Form 16 TDS Certificate Part A should be download and convert from Trace website (tdscpc.gov.in) and Employer have to prepare Part B of Form 16. Both Should be Merged in One PDF for digital signature process.

Every Employee or professionals are looking a tools which can help in this process. Three are many software available in market / google search to do the same but they are paid.

But, trust me you can Merge any two more pdfs in 1 pdf in excel sheet without any wasting money in very simple way and fast.

I have developed a Excel sheet which can use N numbers of times and you can merge 2 different folders PDF files in 1 PDF as per your customization.

You can download this sheet from www.99Excel.Com and watch the below video to learn tutorial.

Direct Link to download sheet:
http://99excel.com/download/index.html

Thanks,

Kumar Ajit

Categories
Excel VBA Dashboard India Payroll

Income Tax Calculator 2019-20 AY 2020-21 in Excel – Easily

Click here to download income tax calculator in excel slab wise. This sheet have the excel formulas to along with marginal tax relief as per FY 2019-20.

@iptmnoida #iptmindia #excelformulas

Categories
80C Deductions 80DDB Excel VBA Dashboard Gratuity House Rent Allowance (HRA) Human Resource (HR) India Payroll Payroll Provident Fund (PF)

Income tax calculation sheet for the financial year 2019-20 [AY 2020-21] Automated Salary Tax Calculator along 15+ other Features

Click here to download automatic Complete Payroll Calculator in Excel. This Excel Software have includes most likely all part of Payroll Calculation. It’s Includes following Feature:-

  • You can calculate Cost to company CTC Automatic once you put total ctc.
  • You can restructuring of allowances and CTC components as per your need.
  • Income Tax  to be calculate automatic.
  • You can set your investment Declaration / Proofs Planing as per requirement.
  • This sheet will calculate House rent allowance ( HRA Rent Exemption calculation) under section 10(13A) automatic as per your rent paid and selected location.
  • You can customize your structure like add / less : PF (Employees’ Provident Fund), Employment State Insurance ( ESIC), Gratuity, Mediclaim, any other benefit, Bonus, Minwages.
  • You can control to deduct PF on Basic OR PF on Allowances or PF on min wages of PF or you can select No if you are not eligible for pf deduction.
  • You can Se-off loss / income from house property u/s 24(b) as per Income Tax Act.
  • You can add reimbursement components as per bills planing to get more benefit in tax.
  • This sheet will give you Net payment Automatically as per your change.
  • Best part of this software is that, you can generate  your salary pay slip from CTC in one click and change payslip in excel as per needs.
  • We have added logo on slip so that you can change it.
  • You can generate any month salary slip from excel format in one click even you can generate full and final slip.
  • Free download
  • Paid Support Available at :
  • Email: ajityadav121@gmail.com
  • Call/WhatsApp: +91 9654421288

Click here to Download Automated Excel Sheet to calculate cost to company (CTC), Income Tax Calculation for financial year 2019-20 along with all investment planning (Deduction U/C VI-A)  and all Major Exemptions allowed + reimbursement  in Salary.

This sheet will allowed to planning your tax saving, make salary structure as per your choice and know the Net in hand Automatically.

Thanks!