Junior Accountant & MIS Executive (Indore)

Junior Accountant & MIS Executive (Indore)

16 Nov
|
Mecon Chemical Matrix
|
Indore

16 Nov

Mecon Chemical Matrix

Indore

WE ARE HIRING | JUNIOR ACCOUNTANT & MIS EXECUTIVE

Company: Mecon Chemical

Location: Indore, Madhya Pradesh

Mecon Chemical is looking for a detail-oriented, analytical, and result-oriented skilled to join our Finance & Accounts team as a Junior Accountant & MIS Executive.

The ideal candidate should possess strong proficiency in Advanced Microsoft Excel, practical working knowledge of Tally Prime, and the ability to extract, process, analyze, and present financial and business data through structured MIS reports.

The primary focus of this position will be MIS reporting and data analysis, with Tally Prime serving as the key source for extracting accounting and transactional data.

1. Position Details

- Job Title: Junior Accountant & MIS Executive
- Department: Finance & Accounts
- Experience: Minimum 2 Years
- Qualification: Any Graduate
- Job Type: Full-Time
- Vacancies: 2
- Salary: Up to 25,000 per month
- Job Location: Indore, Madhya Pradesh

1. Job Overview

We are seeking a skilled and analytical Junior Accountant & MIS Executive who can independently manage MIS reporting activities and financial data analysis. The selected candidate will primarily be responsible for extracting financial and transactional data from Tally Prime, processing and analyzing the information using Advanced Excel, and preparing daily, weekly, and monthly MIS reports for management review.

The role requires robust expertise in Excel-based reporting, data management, report automation, and financial data interpretation, along with practical knowledge of Tally Prime to ensure accurate data extraction and reporting.

1. Key Roles & Responsibilities

A. MIS Reporting & Data Analysis
1. Extract financial and transactional data from Tally Prime for MIS preparation and

management reporting.
1. Prepare and maintain daily, weekly, and monthly MIS reports as per business

requirements.
1. Develop and maintain structured Excel-based reports, dashboards, and performance

trackers.
1. Prepare sales, purchase, revenue, expense, payment, collection, and outstanding

reports.
1. Consolidate and analyze data extracted from Tally Prime and other relevant business

sources.
1. Prepare comparative and analytical reports to identify business trends, variations, and

performance gaps.
1. Monitor sales transactions, customer outstanding balances, vendor payments, and

collection performance.
1. Ensure accuracy, consistency, and timely submission of all MIS reports.
2. Identify discrepancies in reported data and coordinate with relevant departments for

verification and resolution.
1.



Generate customized MIS reports and provide relevant data insights to management as

required. B. Tally Prime Data Extraction & Reporting
1. Extract relevant accounting and transactional data from Tally Prime for reporting

purposes.
1. Generate and export sales registers, purchase registers, ledger reports, outstanding

reports, and other accounting reports.
1. Retrieve customer-wise, vendor-wise, and transaction-wise data for MIS preparation.
2. Verify extracted data for accuracy and completeness before incorporating it into MIS

reports.
1. Understand Tally Prime reports and accounting data structures to ensure accurate

reporting.
1. Coordinate with the accounts team to obtain and validate the required financial

information. C. Advanced Excel & MIS Management
1. Develop and maintain Excel-based MIS templates and reporting formats.
2. Use advanced Excel functions to process, consolidate, and analyze large volumes of data.
3. Create automated reports and management dashboards to improve reporting efficiency.
4. Maintain master data, reporting databases, and historical MIS records.
5. Streamline reporting processes and improve the accuracy and efficiency of data

management.
1. Present business information in a structured and easy-to-understand format for

management review.
1. Mandatory Technical Skills

A. Tally Prime – Practical Working Knowledge
- Ability to independently navigate and work with Tally Prime.
- Knowledge of generating and exporting sales, purchase, ledger, and outstanding reports.
- Understanding of customer-wise and vendor-wise accounting data.
- Ability to extract transaction-level and summary-level information.
- Familiarity with accounting reports and financial data structures.

B. Advanced Microsoft Excel – Strong Proficiency
- VLOOKUP / XLOOKUP.
- Pivot Tables and Pivot Charts.
- SUMIF / SUMIFS and COUNTIF / COUNTIFS.
- IF, IFERROR, and logical functions.
- INDEX and MATCH.
- Data sorting, filtering, conditional formatting, and data validation.
- Data consolidation and reconciliation.
- Preparation of automated MIS reports and interactive dashboards.
- Ability to handle and analyze large datasets efficiently.

C. MIS Reporting & Analytical Skills
- Experience in preparing daily, weekly,



and monthly MIS reports.
- Knowledge of sales, purchase, expense, collection, and outstanding analysis.
- Ability to perform data validation, reconciliation, and discrepancy identification.
- Preparation of management reports and performance dashboards.
- Strong numerical, analytical, and problem-solving abilities.

1. Candidate Profile & Eligibility Criteria

- B.Com / M.Com / BBA (Finance) or equivalent qualification.
- Minimum 2 years of relevant professional experience in MIS Reporting, MIS

Operations, Accounts MIS, or Financial Data Analysis.
- Practical working knowledge of Tally Prime is mandatory.
- Strong proficiency in Advanced Microsoft Excel is mandatory.
- Previous experience in extracting and analyzing accounting data from Tally Prime.
- Ability to independently prepare, maintain, and manage MIS reports.
- Good understanding of sales, purchases, receivables, payables, and financial

transactions.
- Strong attention to detail and data accuracy.
- Excellent analytical, problem-solving, and organizational skills.
- Ability to manage multiple reporting requirements and meet deadlines.

1. Preferred Industry Experience

Candidates with previous experience in manufacturing, trading, chemical, or industrial organizations will be preferred. Exposure to sales MIS, purchase MIS, inventory reporting, customer outstanding analysis,

vendor reporting, and management dashboards will be an added advantage.

1. Key Role Expectations

The selected candidate will be primarily responsible for managing the complete MIS reporting cycle, from extracting relevant data from Tally Prime to processing, analyzing, and presenting information through Advanced Excel reports. The individual should be capable of independently handling reporting requirements,

maintaining data accuracy, identifying business trends, and providing timely and reliable MIS information to management.

Strong Excel proficiency, practical Tally Prime knowledge, analytical capabilities, and a structured approach to reporting will be essential for success in this position.

1. Compensation

- Monthly Salary: Up to 25,000, depending on relevant experience and skill set.
- Full-time employment.
- Opportunity to work closely with management and contribute to business reporting and

analysis.
1. How to Apply

Interested candidates can share their updated CV through LinkedIn or WhatsApp.

Contact Number: (phone hidden)

Company: Mecon Chemical

Location: Indore, Madhya Pradesh

Know someone who would be a great fit? Tag them or share this opportunity with your network!

📌 Junior Accountant & MIS Executive (Indore)
🏢 Mecon Chemical Matrix
📍 Indore

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: junior accountant & mis executive (indore) / indore

Subscribe to this job alert:

Get the latest job offers by email for: junior accountant & mis executive (indore) / indore