Hello Seniors, I joined a startup company where there are less than 20 employees.Kindly help me to prepare a salary breakup. Regards, Archana
From India, Hyderabad

Hi,

Please check if this attachment would be of any help to you. You just have to enter the salary of the employee in the Gross Salary column and also input the number of working days in the Working Days column. The spreadsheet will automatically calculate the Net Salary for you.

Thanks & Regards,
Saritha

From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls Feb 11.xls (83.0 KB, 1815 views)


Hi Saritha,

The Excel sheet is good. Moreover, it depends upon the management as well. In that payroll, there is no calculation for PF contribution.

Hi Archana,

Kindly tell me the nature of the business and the approximate wage range. If wages are less, then there is no need for a complicated process.

Regards

From India, Bangalore

Hi Jeevan,

I agree with you that it differs from company to company and also depends on the management. I actually forgot to add the formula in the PF column, where the calculation wasn't shown.

Anyway, I am attaching it again. Please check.

Regards,
Saritha

From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls Feb 11.xls (83.0 KB, 503 views)


Hi Saritha,

I apologize for bringing up the issue of PF calculation. I am a bit confused about the attendance allowance in both breakdowns and deductions. I believe the allowance should only be included in the breakdowns. If there is no attendance allowance, then there won't be any allowance; however, if there is, then we will provide the allowance.

Moreover, please note that the PT slabs vary from state to state. The PT slabs mentioned are accurate only for Karnataka.

Regards

From India, Bangalore

Dear Archana,

The breakup of salary differs as per the company's discretion. The allowances also vary. Please refer to the salary breakup format provided by our dear friend Saritha and discuss it with the management.

Regards,
Anabayan

From India, Madras

Dear sir, i want to payslip with only basic salary and no one deduction kindly forword the same on my mail id as soon as possible warm regards, manoj parab
From India, Mumbai

Hi Can anyone help me to create Salary Calculator for Start up I only want Basic,HRA,Conv,Special ,PF Thats it.so please share immediately
From India, Delhi

Is it important to deduct tax form pay slip ? if yes then how much we need to deduct in delhi ?
From India, New Delhi

Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.