– Accounts MIS Executive

Job Title: Accounts MIS Executive

Department: Accounts & Finance / MIS

Location: Sector-132 Noida

Employment Type: Full-Time

Experience: 3–6 Years

Qualification: B.Com / M.Com / CA Inter / MBA Finance or equivalent

HR- (phone hidden)

Job Summary

We are looking for an experienced Accounts MIS Executive with strong expertise in MS Excel, Tally, MIS reporting, and accounting operations. The candidate must have prior experience in an Audit/CA firm, with a strong understanding of accounting, reconciliation, audit documentation, and financial reporting.

The ideal candidate should be highly analytical, detail-oriented, and capable of preparing accurate and timely MIS reports for management.

Mandatory Requirements

- Audit Company / CA Firm Experience – MUST
- Tally – MUST
- Strong MS Excel – MUST
- Solid MIS Reporting – MUST
- Good knowledge of accounting and reconciliation.
- Strong analytical and reporting skills.

Key Responsibilities1. Accounts & Accounting Operations
- Handle day-to-day accounting activities and financial transactions.
- Prepare and verify journal, payment, receipt, purchase, and sales entries.
- Maintain customer, vendor, bank, and general ledgers.
- Perform regular ledger and bank reconciliations.
- Assist in monthly and annual closing of accounts.
- Verify invoices, bills, vouchers, and supporting documents.
- Ensure accuracy and completeness of accounting records.

1. MIS Reporting – Strong

- Prepare daily, weekly, and monthly MIS reports for management.
- Prepare sales, purchase, expense, collection, payment, and outstanding reports.
- Prepare customer and vendor ageing reports.
- Prepare monthly financial summaries and performance reports.
- Prepare budget vs. actual and variance reports.
- Consolidate data from different departments and prepare management reports.
- Analyze financial data and highlight major variances and discrepancies.
- Develop and maintain Excel-based MIS dashboards.




- Ensure all MIS reports are accurate and submitted within deadlines.

1. Advanced MS Excel – Mandatory

Strong practical knowledge of MS Excel is mandatory. The candidate should be proficient in:

- VLOOKUP / XLOOKUP
- INDEX-MATCH
- SUMIF / SUMIFS
- COUNTIF / COUNTIFS
- IF / Nested IF
- Pivot Tables
- Pivot Charts
- Conditional Formatting
- Data Validation
- Filters and Sorting
- Data Cleaning and Consolidation
- Advanced Reconciliation
- Ageing Analysis
- MIS Dashboards
- Large-data handling
- Excel-based financial analysis

Power Query knowledge will be an added advantage.

1. Tally – Mandatory

- Strong hands-on knowledge of Tally Prime / Tally ERP.
- Record and verify accounting transactions in Tally.
- Maintain ledgers, vouchers, masters, and accounting records.
- Perform bank and ledger reconciliation.
- Generate accounting reports from Tally.
- Assist in GST, TDS, and other statutory accounting documentation.
- Ensure proper and accurate accounting entries.

1. Audit / CA Firm Experience – Mandatory

Candidates must have prior experience working with an Audit Company / CA Firm.

Responsibilities may include

- Assisting in statutory and internal audit assignments.
- Preparation and verification of audit schedules.
- Ledger scrutiny and reconciliation.
- Vouching and verification of accounting documents.
- Preparation of audit working papers.
- GST and TDS reconciliation.
- Balance sheet and P&L; verification.
- Supporting senior auditors/CA in audit assignments.
- Identifying accounting discrepancies and assisting in corrective actions.
- Preparing financial data and supporting documents for audits.

1. Reconciliation & Analysis





- Perform bank reconciliation and ledger reconciliation.
- Reconcile customer and vendor accounts.
- Identify differences between books, MIS, and supporting records.
- Analyze outstanding receivables and payables.
- Track accounting discrepancies and ensure timely correction.
- Maintain proper documentation for all reconciliations.

1. Statutory & Compliance Support

- Assist in GST and TDS-related data preparation and reconciliation.
- Support statutory audit and tax audit requirements.
- Maintain proper financial and statutory documentation.
- Coordinate with auditors and consultants whenever required.

Required Skills
- Strong accounting fundamentals.
- Excellent MS Excel skills.
- Strong MIS reporting skills.
- Mandatory Tally knowledge.
- Mandatory Audit/CA Firm experience.
- Good knowledge of reconciliation and financial reporting.
- Strong analytical and numerical ability.
- High attention to detail and accuracy.
- Good communication and coordination skills.
- Ability to work under deadlines.

Key Performance Indicators (KPIs)
- Accuracy of MIS reports.
- Timely submission of daily/monthly MIS.
- Accuracy of accounting entries and reconciliations.
- Timely completion of audit-related work.
- Accuracy of Tally records.
- Timely identification and resolution of discrepancies.
- Quality and reliability of management reports.

Preferred Candidate Profile
- 3–6 years of relevant Accounts & MIS experience.
- Previous Audit Company / CA Firm experience is mandatory.
- Strong Tally and Excel knowledge.
- Strong hands-on experience in MIS preparation and financial analysis.
- Candidates who can independently manage Excel-based MIS and accounting reports will be preferred.

Reporting To Finance Manager / Accounts Head

(phone hidden)

Pay: ₹70,000.00 - ₹90,000.00 per month

Benefits

- Cell phone reimbursement
- Life insurance

Experience:
- Microsoft Excel: 5 years (Required)

Work Location: In person

📌 Accounts MIS Executive (Maharishi Nagar)
🏢 Vansh Industries
📍 Maharishi Nagar