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