Mangesh Kolurwar
Pune
Summary
Analytical professional with strong financial modeling skills, accounts receivables, commercial operations, indirect taxation (GST), TDS, and a background in variable compensation management.
Overview
9
9
years of professional experience
Work History
Senior Commission Analyst
EnterpriseDB Software India Private Limited
01.2022 - Current
- Maintain the commission system, including records of Sales representatives, quotas, and commission draws.
- Validate annual commission plans with Finance department for 300+ Sales staff, while ensuring SOX compliance.
- Coordinate employee commission target changes with Human Resources, Finance, Business Operations departments, and Sales staff.
- Monthly Sales Commission Accrual for Global Commission and ASC 606 commission preparation and booking in NetSuite.
- Perform and finalize monthly/quarterly commission calculations globally for Sales Management & Finance review and approval.
- Run monthly commission processes, which include sales and commission adjustments, order/commission splits, transfers, and bonus entries.
- Assist Sales/Finance stakeholders in the reconciliation of sales credits and commissions as required.
- Update Commission system plan changes to facilitate commission performance calculations.
- Calculate monthly and quarterly performance targets, and special bonus payments and keep track of special deals.
- Resolve inquiries regarding commission details, compensation plans, and account alignments.
- Manage roll-off of historical plan payments, implement plan changes, and monitor and maintain plans in the commissions system.
- Prepare monthly/quarterly commission statements; review and submit payroll files for the global payroll.
- Create and provide ad hoc reports to Sales Management and Segment Finance heads.
- Consolidate Protection Requests/Forgiveness and relevant supporting documentation to present to the Sales Management and Segment Finance head.
- Analysis of Cash flow statements.
- Monthly closure of accounts with monthly provisions for Salary, Depreciation, recurring monthly expenses.
Executive-Accounts
Pravin Masalewale
10.2019 - 01.2022
- GST Return filling (GSTR-1, GSTR-3B, GSTR-2A, Reconciliation, GSTR-9)
- Preparing and verifying GSTR2A reconciliation for processing purchase invoices
- TDS Working and Return filling.
- Preparing and maintaining Bank Reconciliation in SAP.
- Prepared daily deposits, processed expense reports, and resolved all daily returned checks.
- Processed daily ACH direct debit transfers for initial insurance premium payments and ACH credit transfers for commissions.
- Performing different tasks that include posting cash/bank receipts, updating cash flow reports, responsible for applying cash/bank receipts to customer accounts using the ERP Database Prepared monthly and quarterly reconciliation and analysis of balance sheet and income statement accounts to ensure precise financial reporting.
- Managed accurate and timely processing of full accounts payable and accounts receivable cycle, prepared monthly accruals, and daily journal entries, and assisted with special accounting projects.
- Composed effective accounting and ad-hoc reports, summarizing financial data for Operations and Senior Management.
- Developed and implemented an Electronic Funds Transfer return process in collaboration with a new SAP platform to improve work productivity.
- Responsible for credit collections on all accounts by contacting the customer by phone, e-mail, and written correspondence.
- Process and issue credit memo after research have been completed.
Accounts Assistant (Commercial-Credit Control)
Nilon’s Enterprises Pvt. Ltd.
02.2016 - 09.2019
- Performed accounts payable and accounts receivable functions, deposits, account reconciliations, bank reconciliations, financial data record keeping, and tax preparation.
- Responsible for credit collections on all accounts by contacting the customer by phone, e-mail, and written correspondence.
- Preparing and maintaining customer account reconciliation schedules using the ERP database to clarify claims and rectification of entries.
- Preparing and maintaining sales reports MTD and YTD.
- Preparing and processing sales invoices in the ERP system as well as in Tally.
- Preparing E-way Bills.
- Increased or reduced customer’s credit limit after research and verification of financial statements
- Compiled and prepared financial statements, management reports, and journal entries.
- Performing different tasks that include posting cash/bank receipts, updating cash flow reports, responsible for applying cash/bank receipts to customer accounts using the ERP Database.
Education
Master of Commerce And Financial Management - Accounting And Finance
RTMNU Nagpur University
Nagpur, India10.2015
Bachelor of Commerce - Accounting And Finance, Economics And Business
RTMNU Nagpur University
Nagpur, India03.2013
Skills
NetSuite, SAP, Microsoft Dynamics NAV, ICM-Varicent, Concert, Salesforce, Spiff and Tally ERP
Skills
◻ Well-developed analytical skills - Skillful at processing data/information, keeping records, tabulation, and Variable compensation management.
◻ Strong background in bookkeeping includes General Ledger, Accounts payable/ receivable, Final Accounts, and reporting.
◻ Continuously updated and thorough working knowledge of accounting principles and practices as well as Income Tax and Indirect Tax laws.
◻ Proven ability to handle multiple, competing priorities effectively.
◻ Effectively gather, analyze, compile, and synthesize data into written reports.
◻ Effective communication skills, excellent Marathi, Hindi & English.
◻ Expertise knowledge in NetSuite, MS Office, Navision ERP, SAP, Oracle, Go-frugal, and Tally ERP.
Timeline
Senior Commission Analyst
EnterpriseDB Software India Private Limited
01.2022 - Current
Executive-Accounts
Pravin Masalewale
10.2019 - 01.2022
Accounts Assistant (Commercial-Credit Control)
Nilon’s Enterprises Pvt. Ltd.
02.2016 - 09.2019
Master of Commerce And Financial Management - Accounting And Finance
RTMNU Nagpur University
Bachelor of Commerce - Accounting And Finance, Economics And Business
RTMNU Nagpur University
Similar Profiles
Juhi UbnareJuhi Ubnare
Senior HR Generalist at EnterpriseDB Software India Pvt LtdSenior HR Generalist at EnterpriseDB Software India Pvt Ltd
Ranjeeta MuleyRanjeeta Muley
AP Manager Global at EnterpriseDB Software India Pvt Ltd.AP Manager Global at EnterpriseDB Software India Pvt Ltd.
Mohan KumarMohan Kumar
HR at Imarticus Learning Private Limited, Imarticus Learning, South India, Josh Software Private LimitedHR at Imarticus Learning Private Limited, Imarticus Learning, South India, Josh Software Private Limited