Role & responsibilities
MIS Reporting & Data Analysis
Create, update, and maintain daily/weekly/monthly MIS reports for Accounts Payable, payments, and vendor outstanding. Build dashboards for spend analysis, invoice aging, TAT tracking, vendor utilization, and efficiency metrics. Use Excel automation and formula-driven models to reduce manual effort and increase reporting accuracy. Conduct data quality checks, variance analysis, and reconciliation between systems.\ 2.
Advanced Excel (Detailed & Expanded Requirements)
Core Formula Expertise
Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX + MATCH Logical Functions: IF, AND, OR, NOT, IFS Text Functions: LEFT, RIGHT, MID, FIND, LEN, TEXT, CONCAT, TEXTJOIN Date & Time Functions: TODAY, NOW, EOMONTH, EDATE, DATEDIF Math & Statistical Functions: SUMIFS, COUNTIFS, AVERAGEIFS, ROUND, SUBTOTAL Error Handling: IFERROR, ISERROR, ISBLANK
Data Analysis & Automation
Pivot Tables slicers, timeline, grouping, calculated fields Power Query data cleaning, merging queries, combining files, transforming datasets Power Pivot (if used) building data models, relationships, DAX basics Macros / VBA (optional) automating repetitive tasks, button-based workflows
Data Visualization
Creating dynamic charts, graphs, KPI metrics Conditional Formatting for trends, thresholds, exceptions Dashboard creation using slicers, formulas, and pivot elements
Data Cleaning & Validation
Data validation rules Removing duplicates, trimming spaces, correcting text formats Ensuring consistency between multiple datasets 3.
Accounts Payable Operations
Processing invoices, debit/credit notes, employee claims, and vendor payments. Validation of PO vs Non-PO invoices and compliance with internal workflows. Tracking invoice lifecycle from receipt to approval to payment release. Preparing aging analysis, escalation reports, and exception reports. Monthly vendor ledger reconciliation and issue resolution. 4.
H-Lock & Y-Lock Payment Controls
Applying H-Lock (Hold Lock) for invoices with discrepancies or pending approvals. Applying Y-Lock for system-level payment prevention to avoid duplicate or unauthorized payments. Monitoring lock status, reviewing unlock requests, and ensuring audit compliance. Regular validation of lock lists and coordinating with audit & controllers. 5.
Relocation Claims & Payments
Reviewing relocation entitlements as per HR policy (travel, accommodation, shipment, allowances). Validating employee claims, bills, and supporting documents. Coordinating with HR for approvals and with vendors for invoices. Maintaining a relocation MIS tracker for expense planning and budgeting. 6.
Motor Payments & Motor Grade Processing
Processing monthly motor allowance payments based on grade eligibility. Validating insurance, fuel claims, service bills, and vehicle-related reimbursements. Ensuring correct mapping to employee grade and policy eligibility. Preparing monthly motor MIS and expense summaries for finance . 7.
Compliance, Audit & Governance
Maintaining documentation for all AP activities and MIS reports. Supporting internal/external audits with precise data extracts and analysis. Ensuring adherence to financial controls and approval matrix. Maintaining confidentiality and data accuracy at all stages.
