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