Reconciliation Specialist

Impact Guru; Mumbai City; On-site; INR 600,000 - 1,000,000; Full time

Job summary

Impact Guru in Mumbai invites a detail-oriented Accounts Reconciliation Specialist to ensure accurate intercompany and vendor reconciliations, bank statements, and gateway accounts.

You will leverage advanced Excel, Tally ERP, and data analysis to identify discrepancies, generate reports, and support audits while collaborating with Finance and Operations. This role offers growth in a fast-paced fintech environment in India.

Qualifications

• Advanced Excel skills including VLOOKUP, INDEX-MATCH, pivot tables and macros.
• Experience with Tally ERP for transaction recording and reconciliations.
• Ability to analyze large data sets and provide actionable insights to resolve issues.
• Strong attention to detail and precision in handling financial data.
• Solid accounting knowledge and understanding of reconciliations and financial reporting.
• Excellent problem-solving and discrepancy-resolution abilities.
• Strong written and verbal communication skills.

Responsibilities

• Account reconciliation of bank, gateway and other accounts to ensure accuracy.
• Data analysis using Excel to identify discrepancies and assist reporting.
• Maintain and update records in Tally ERP for transactions and reconciliations.
• Review discrepancies and provide explanations and solutions for variances.
• Prepare monthly, quarterly, and annual reconciliation reports.
• Collaborate with Finance, Accounts Payable/Receivable and Operations to resolve issues.
• Support audits by providing reconciled data and documentation.
• Suggest process improvements to increase efficiency and enable automation.

Skills

Advanced Excel Skills

Data Analysis

Attention to Detail

Accounting Knowledge

Problem-Solving Skills

Communication

Education

Bachelor's degree in Accounting, Finance, or related field

Tools

Tally ERP

Job description

• Account Reconciliation: Perform timely and accurate reconciliations of bank, payment gateway, andother financial accounts to ensure records are consistent and error-free.


• Data Analysis: Leverage advanced Excel functions (e.g., VLOOKUP, pivot tables, macros) to analyze financial data, identify discrepancies, and assist with reporting.


• Tally Expertise: Maintain and update financial records in Tally ERP, ensuring all transactions are recorded and reconciled appropriately.


• Transaction Review: Regularly review and investigate discrepancies, providing clear explanations and solutions for any variances in accounts.


• Reporting: Prepare monthly, quarterly, and annual reconciliation reports for management review.


• Collaboration: Work closely with other teams, including Finance, Accounts Payable/Receivable, and Operations, to resolve any discrepancies or issues.


• Audit Support: Assist in audit preparation by providing necessary reconciled financial data and supporting documentation.


• Process Improvement: Suggest improvements for enhancing reconciliation processes and increasing efficiency through automation or new tools.

Key Skills & Qualifications:

• Advanced Excel Skills: Proficient in Excel with strong knowledge of formulas (VLOOKUP, INDEX-MATCH), pivot tables, macros, and data manipulation techniques.


• Experience with Tally: Strong working knowledge of Tally ERP software, particularly for transactionrecording and reconciliations.


• Data Analysis: Ability to analyze large data sets, identify trends, and provide actionable insights to resolve issues.


• Attention to Detail: Strong eye for detail and precision in handling financial data.


• Accounting Knowledge: Basic understanding of accounting principles, preferably with experience in managing reconciliations and financial reporting.


• Problem-Solving Skills: Ability to troubleshoot and resolve discrepancies in accounts efficiently.


• Communication: Strong written and verbal communication skills to interact with internal teams and external stakeholders.

Preferred Qualifications:

• Bachelors degree in Accounting, Finance, or related field.


• Previous experience in a reconciliation role in a fast-paced environment.


• Knowledge of other accounting software is a plus.