19 Nov
|
SPRS SOLUTIONS
|
Hyderabad
19 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, strong analytical focus, ability to meet tight monthly payroll deadlines, and clear follow-up skills with client teams.
📌 Payroll Mis Executive (Hyderabad)
🏢 SPRS SOLUTIONS
📍 Hyderabad