Pivot Table Job Vacancies in Hyderabad

Job Title: Senior AccountantCompany: JSR GROUP SUNCITYLocation: Kothapet, HydAbout Us:JSR GROUP SUNCITY is a leading real estate company seeking an experienced Senior Accountant to join our team. We're looking for a highly skilled professional to manage our financial records, ensure compliance, and provide financial insights to support business growth.Job Summary:We're seeking a Senior Accountant with expertise in MS Excel, V Lookup & H Lookup, Tally, and financial accounting to lead our accounting team. The successful candidate will be responsible for financial reporting, budgeting, and ensuring compliance with accounting standards and regulatory requirements.Key Responsibilities:- Manage financial records, including accounts payable, accounts receivable, and general ledger- Prepare and analyze financial statements, budgets, and forecasts- Expertise in MS Excel Formulas, V Lookup & H Lookup, pivot tables, and data analysis- Proficiency in Tally and other accounting software- Ensure compliance with accounting standards, GST, and other regulatory requirements- Conduct financial analysis and provide insights to support business decisionsRequirements:- Master's degree in Accounting or related field- 2+ years of experience in accounting, preferably in the real estate industry- Excellent knowledge of MS Excel Formulas, Tally, and financial accounting- Strong understanding of accounting standards, GST, and regulatory requirements- Excellent analytical and problem-solving skills- Excellent communication and interpersonal skills

Contact customers to exert every possible effort to secure payment on invalid deductions.Research and resolve customer deductions; coordinate with business partners to resolve contested items, recommend appropriate action for item handling. Either issue credit or contact customer to collect unauthorized deductions. (Off invoice and short payments)Review all deductions taken from customer payments, review remittance information to determine the reason for deduction.Review all documents supporting the customer claims, including purchase order copies, proof of delivery and invoices.Dispute all claims including shortages, pricing deductions, and violations; disputes are completed via web portal or via email.Retrieve data from customer web portals.Contact customers via emails/Calls to resolve pending deductions.Document all actions taken in ERP system so last action taken is readily available.Identify and implement areas for process improvement with will reduce customer deductions.Escalate issues to the supervisor/manager that require intervention/clarification from senior leadership.Research/Resolve customer short ship deduction (Returns, shortages, overages, etc.).Maintain aging reports and perform activities to resolve open receivables.Perform month end close activities and meet accounting close deadlines.Create and analyze weekly reports for internal and audit review.Identify root causes of problems affecting payment of invoices, by analyzing relevant information and clearly communicating and collaborating internally and with customers to resolve root cause issues to prevent a reoccurring.Identify and resolve billing discrepancies (off invoice and short payments)Identify, report, and present trends in a customers deductions.

Responsibilities and Duties:Provide support and maintenance to existing MIS systemGenerate and distribute management report in an accurate and timely mannerDevelop MIS documentation to allow smooth operation and easy system maintenanceProvide recommendation to update current MIS to improve reporting efficiency and consistencyPerforming data analysis for generating reports periodicallyDeveloping MIS system for customer management and internal communicationProvide strong reporting and analytical information support to the management teamGenerate both periodic and ad hoc reports as neededExperience in MISData segregation.Big data handlingAdvance excelShould have experience in Vlookup, Hlookup, pivot tableBar and Graphs creationCreating proper MIS reportMaking PowerPoint presentation.Good CommunicationCo-ordination.