Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Gud evenig all, please let me know what is pay roll and how it works? Thanks Jeet Bhardwaj
Pay Roll is the consolidation of emoluments being paid to the employees every month, indicating individually, the basic salary with HRA, other allowances, food and conveyance allowances with deductions for provident funds, TDS and others. The pay roll can be prepared in EXCEL sheet or can be through software solutions also. TALLY accoutning solutions software has pay roll provisions in the progra. There are other players are also available for Pay Roll software solutions.
Request you all to assist me to create Income Tax calculator in Excel. Will be waiting for your suggestions and revert. Thanks in advance. Regards, Vijay
Dear Vijay

pl find a typical salary slip which cover all the items must be concerned with all employees

Sample Salary slip of a Corporate group Company employing 2000 personnel and a turnover of Rs. 2000 crores

ABC CO. LIMITED File no. Name
Division Month P.F.No EPS No. ESI no. Days

Total Earnings
Basic D.A

Spl Basic Spl Allowance

Pers. Pay Conveyance

Transport City
Allowance Allowance

Cashier H.R.
Allowance Allowance

Education Entertainment
Allowance Allowance

Servant Other
Allowance Allowance

CPF Medical



Total: Rs.
P.F V.P.F ESI Proff Tax

L.W.F Advance I.Tax Milk

House Rent Elec P.F Loan PFL Int

Bus Co Loan Co Loan Interest Tel

Canteen Veh loan Veh loan Int Hsg loan

Hsg Loan Int School Club Work. Hsg

Bank loan TV Death fund Others


Total Deductions: Rs.


Total Earnings Total Deductions


Credited into your --------Bank A/c No.----------------

there are seperate software solutions for income tax calculations and assessement and it is not possible to have it done in EXCEL program
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™