20 Nov
|
SPRS SOLUTIONS
|
Hyderabad
20 Nov
SPRS SOLUTIONS
Hyderabad
We are looking for a detail-oriented Payroll MIS Executive to manage our end-to-end salary sheet preparation. You will receive monthly attendance/paysheet files in Excel from our clients, validate and standardize the data against internal master records, and prepare accurate, audit-ready salary sheets for final disbursement.
Key Responsibilities
Client Paysheet Consolidation: Collect, review, and standardize monthly Excel paysheets and attendance approvals received across multiple client accounts.
Data Validation & Verification: Cross-check client-submitted paysheets against our active employee master database (verifying new joiners, exits, employee IDs, payable days, overtime, and incentives) to flag discrepancies early.
Salary Sheet Preparation: Prepare comprehensive monthly salary sheets by calculating payable days, Loss of Pay (LOP), overtime (OT), incentives, arrears, and advances based on approved CTC structures.
Statutory & Net Pay Computation: Accurately compute statutory deductions (PF, ESIC, PT, LWF) and net payable salaries, while maintaining updated KYC, bank, UAN, and ESIC records.
Discrepancy & Hold Management: Follow up with client SPOCs and internal account coordinators to resolve missing inputs or data mismatches, manage salary holds/releases, and prepare Full & Final (F&F;)
settlement sheets.
MIS & Payout Reporting: Generate monthly payroll summary reports, client-wise variance trackers, and bank transfer upload sheets within strict monthly payout cut-offs.
Data Security: Maintain strict version control, backup discipline, and confidentiality across all client paysheets and employee banking records.
Qualifications & Skills
Education: Bachelors degree in Commerce, Finance, Business Administration, or a related field (B.Com / BBA / MBA preferred).
Experience: 1–3 years of hands-on experience in Payroll MIS, Salary Sheet Preparation, or HR Operations (experience in manpower/contract staffing agencies is a robust plus).
Technical Proficiency:
Advanced MS Excel: Strong mastery of XLOOKUP/VLOOKUP, INDEX-MATCH, nested formulas, Pivot Tables, and cleaning multi-format client Excel files.
Domain Knowledge: Practical working knowledge of Indian salary components (Basic, HRA, Gross, Net) and statutory compliance calculations (PF, ESIC, PT, LWF).
Core Competencies: Zero-error approach to numbers, robust analytical focus, ability to meet tight monthly payroll deadlines, and explicit follow-up skills with client teams.
📌 Payroll Mis Executive Hyderabad
🏢 SPRS SOLUTIONS
📍 Hyderabad