Need Payroll Sample in Excel or Using Access - income tax.. CiteHR
CiteHR
 
HOME ANSWERED NEW ABOUT LOGIN
Home > Human Resource Section > Talk To Seniors

Need Payroll Sample in Excel or Using Access

suriyaprakashs Started The Discussion:

Hi! Friends i am working in a Small Sized Enterprise, I am using Excel to do my Payroll proccess, I am interested to change the format, can you suggest me a new format please.

Regards,

SURIYA :? :? :? :? :? :?

Hi there You can provide me your details as i am working in this domain only. Gunjan Sahni payroll.etds.solutions@gmail.com

jiguparmar - Contributing Member
Please note that There is no need of any password to use this program.

Read instruction carefully provided with the program before entering you detail..

After reading the instruction if you find any difficulty for entering your data please let me know.

Software Contains:

1-Attendance Register.
2-Payroll Register.
3-Generate Salary Slip.
4-Track Employees' Leave history.
5-Track Income Tax of All Employee.
6-Print out Leave History of Employee.
7-Overtime Monitor.
8-Master Data sheet of All Employees.
9-Leave Calculation sheet.
10-ESI Calculation(Set Your Requirements)
11-P.F Calculation
(Here there are Two Options one is if Basic<=6500 than Basic*12% otherwise 6500*12%
Second is 12% of Basic)
12-Pension Scheme (not more than 541 rs submission)
13-TDS Calculation
14-Annual Salary statement of Employee and Employer
15-Employer Monthly Salary statement
16-Income Tax Calculations
17-Generation of Form No-6 (For ESIC)
18-Generation of Form no-3A (PF)
19-Generation of Form no-6A(PF)

Limitation: You have monitor Leave of employee each month when It goes minius Red indication is glow on that cell so You have to Put it on LWP otherwise minus leave will effect on salary sllip generation.
Requied Attention: Please be vigilant about Auto and Manual mode and P.F Selection.

If You find this is useful for You than Don't miss to drop Thanks...

Download from : Excel Programs-Softwares-Books-Novels

Found This Useful? +Vote Up This Page Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.
COMMUNITY SPONSORS


Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


1
LIKES

5764
VIEWS

2
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login & Explore or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network