PRIME SPONSOR - FACTOHR - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
Gud evenig all, please let me know what is pay roll and how it works? Thanks Jeet Bhardwaj
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...
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
Payable

Total Earnings
Deductions
Basic D.A

Spl Basic Spl Allowance


Pers. Pay Conveyance
Allowance

Transport City
Allowance Allowance

Cashier H.R.
Allowance Allowance

Education Entertainment
Allowance Allowance

Servant Other
Allowance Allowance

CPF Medical

SA

Reimbursements

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

CPF SA



Total Deductions: Rs.

________________________________________________

Total Earnings Total Deductions

NET PAY

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
PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
Add Reply Start A New Discussion




About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™