Accounts and MIS Executive

SMC Global Securities; New Delhi; On-site; INR 300,000 - 450,000; Full time

Job summary

SMC Global Securities in Delhi is seeking an Accounts/MIS professional to maintain financial data in Excel and prepare MIS reports. You will handle Excel-heavy tasks, validation and reconciliation, and assist with basic accounting entries.

Strong Excel skills and attention to detail are essential. The role requires familiarity with accounting principles, data analysis, and coordinating with internal teams to ensure accurate reports.

Qualifications

• Strong working knowledge of MS Excel.
• Proficient in Excel formulas and functions.
• Experience with Pivot Tables.
• Basic understanding of accounting principles.
• Familiar with debit/credit, journal entries, ledger, invoices, and reconciliation.
• Good numerical and analytical skills.
• Attention to detail and accuracy.
• Strong communication and coordination skills.

Responsibilities

• Maintain and update financial and operational data in MS Excel.
• Prepare daily, weekly, and monthly MIS reports.
• Create Pivot Tables and Pivot Charts.
• Perform data validation, reconciliation, and basic data analysis.
• Maintain records of invoices, expenses, payments, receipts, and other accounting documents.
• Assist with basic accounting entries and ledger reconciliation.
• Coordinate with internal teams for required financial/data information.
• Ensure accuracy of reports and maintain proper documentation.
• Perform other accounts and MIS-related tasks as assigned.

Skills

Attention to detail

Analytical skills

Communication

Coordination

Data interpretation

Tools

MS Excel

Pivot Tables

Excel formulas

Job description

Key Responsibilities:

• Maintain and update financial and operational data in MS Excel.


• Prepare daily, weekly, and monthly MIS reports.


• Use Excel formulas such as VLOOKUP/XLOOKUP, SUMIF/SUMIFS, COUNTIF/COUNTIFS, IF, IFERROR, etc.


• Create and maintain Pivot Tables and Pivot Charts.


• Perform data validation, reconciliation, and basic data analysis.


• Maintain records of invoices, expenses, payments, receipts, and other accounting documents.


• Assist with basic accounting entries and ledger reconciliation.


• Coordinate with internal teams for required financial/data information.


• Ensure accuracy of reports and maintain proper documentation.


• Perform other accounts and MIS-related tasks as assigned.

Required Skills & Qualifications:

• Good working knowledge of MS Excel.


• Strong understanding of Excel formulas and functions.


• Good knowledge of Pivot Tables.


• Basic knowledge of Accounting principles.


• Understanding of debit/credit, journal entries, ledger, invoices, and reconciliation.


• Good numerical and analytical skills.


• Attention to detail and accuracy.


• Good communication and coordination skills.