Sumit Kumar
Bangalore
Summary
A competent professional offering over 12+ years' experience of Accounts & Finance, banking, budgeting, and variance analysis. Associated with Adilaxmi E-Commerce Private Limited as Assistant Manager - Accounts & Finance. Exposure in working with cross-functional team, Accounts Receivable, Accounts payable, Tax and Banking teams for costing and project status updates and Financial Statements such as Profit and loss, Cash flow and Balance sheet analysis. Finalizing with managers and preparing the monthly analysis into every month according to relevant data. Advanced MS - Excel (Pivot table, V & X-Lookup, Data Validations, Sumif, Index, Match, Micros & VBA etc.) Interpersonal, analytical & team building skills with proficiency at grasping new concepts quickly and utilizing the same in a productive manner.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Assistant Manager Accounts
Adilaxmi E-Commerce Private Limited
Bangalore
01.2020 - Current
- Managed monthly and annual book closure entries, including revenue recognition and expense provision entries.
- Ensured timely month-end accounting closure and post-month end reporting for all segments, including online portals and offline stores.
- Reviewed and provided guidance to the accounts receivable team, facilitating process improvements.
- Prepared monthly Management Information System (MIS) reports, including Balance Sheets, Profit and Loss statements, Gross Margin analysis, and key performance indicators (KPIs). Also, prepare audit schedules for accounts receivable and accounts payable.
- Monitored General Ledger (GL) controls, maintaining account codes, and the chart of accounts.
- Prepared Actual and Projected Cash Flow reports.
- Prepared a reconciliation of collections from UPI, Card, and CMS transactions across PAN India.
- Conducted quarterly reconciliations with B2B suppliers.
- Maintained routine coordination with various cross-segments, functions, government agencies, and tax consultants.
- Worked as a Power BI developer with proficiency in DAX, Power Query, and and designing interactive dashboards, reports, and visualizations using Power BI and QlikView.
- Collaborated with internal and statutory auditors during audits, ensuring accurate data submission and timely query resolution.
- Analyzed business performance data and forecasted business results for upper management.
Senior Executive
WS Retail Services Private Limited
Bangalore
05.2017 - 12.2019
- Preparation of Accounting Entry for B2B and B2C transactions.
- Preparation of Monthly Purchases & Sales Walk.
- Calculation of marketplace commission charges.
- Preparation of Monthly Schedules for Internal/Statutory Audit.
- Responsible for end-to-end accrual and accounting of revenue for B2B, B2C.
- Revenue GL Reconciliation.
- Collation, Reconciliation.
- Prepared monthly financial reports for senior management review.
- Conducted internal audits of accounts payable, accounts receivable, payroll, and general ledger processes.
- Reconciled bank statements on a regular basis to ensure accuracy of records.
Senior Executive
DHFL Pramerica Life Insurance Company Ltd.
Gurgaon
09.2016 - 04.2017
- Preparation of Actual & Projected Cash Flow and daily basis reported to investment team.
- Fund transfer RTGS/NEFT letter on a daily basis.
- Interfund transfer for all departments.
- Bank reconciliations of 8 bank accounts, in which collections are received, are conducted to ensure that funds are allocated to the correct policy number.
- Weekly/monthly stale check reconciliation.
- Stale check reconciliation is completed on time, and necessary entries are passed in Oracle Books.
- Passing necessary entries in Oracle for intra-company fund transfers, EOD sweeps, and bank charges, and having in-depth knowledge of accounting for timely closure of GL-related activities.
- Realization of daily collections of CMS, credit card, direct deposit, PayTM, and payment gateway.
- Maintaining fund and payment trackers in order to have control over payments.
- Ensure vendor and employee code creation is done within the stipulated TAT.
- Review and analysis of bank charges deducted according to the bank rate card on a monthly basis.
- Ensure all queries related to banking and financial instruments, for both internal and external.
- Maintenance of the bank site and new user ID creation for all banks for smooth operation of the finance department.
- Updating signatories in all banks and maintaining KYC documents.
- Attention to detail, with efficient decision-making ability.
- Maintain accurate and complete documentation, and follow up through completion.
- Drive improvement and automation of current processes to enhance efficiency, accuracy, and control.
Executive
Askme.com (Getit Grocery Private Limited)
Noida
04.2015 - 08.2016
- Preparation of cash flow, collection report on a daily basis, and directly reported to management.
- Prepare bank reconciliations on a daily basis.
- Processing of salary, employee reimbursement, and all statutory payments (Tax, PF, EST, PT, etc.).
- Record all cheque and post payments.ts.
- Order-wise payment reconciliation of all sellers.
- Weekly/Monthly stale cheque reconciliation and their entry passing in books.
- Prepare normal and PDC cheques and ensure their bank clearance dates.
- Preparation documentation of foreign payment forms 15CB, 15CA (A2 Form, and one-time Fema).
- Set up all invoices to match against the purchase order for payment processing.
- Maintain Sodexo/TR record and get amount reconciliation from BRS (Sodexo, Ticket Restaurant), releasing daily basis seller payment of PAN INDIA.
- Maintain the collection report of Cash, Online, Sodexo, and Ticket Restaurant MIS.
- Reconciliation of Petty Cash and Operational Cash.
- Follow up for unidentified COD amount and confirm from branch, and query resolved from bank basis.
- Support in monthly closing activities (directors and Financial Pack).
- Ensured that all computerized aspects of accounts were operating efficiently and effectively to ensure proper fee calculation and billing.
Executive
Accelity BestAtLowest Online Services Private Limited
Delhi
12.2012 - 03.2015
- Handle diversified Account Payable/Receivable and expenses control procedures, including bank and account reconciliation, cash receipts, disbursement, finance charges, billings, invoicing, and preparation of daily bank deposit, debit/credit note.
- Weekly paycheck run as per timesheet and expenses, and reimbursement.
- Month-end reports such as Ageing Report, Customer Balance Reports, Invoice List, and Service Tax Reports.
Account Assistant
R. C. Apparels
Gurgaon
08.2011 - 11.2012
- Bank Reconciliation Statement (BRS), Maintenance Apparels stock register order/style-wise, Preparation sales Invoice, Preparation Vouchers on a daily basis.
- Preparing journal, sales, collection, and contra entry on a daily basis.
- Maintaining record of apparel cutting, stitching, washing, packing, and dispatching to buyer.
Education
M.B.A. - Financial Management
Annamalai University
12.2021
B. Com - Graduation
Deen Dayal Upadhyay Gorakhpur University
12.2011
Intermediate - Commerce
UP Board
12.2008
10th Standard - Science
UP Board
12.2006
Skills
- Budgeting
- Data Analysis
- Variance Analysis
- MIS Reports
- Billing & Invoicing
- Oracle
- SAP FI-CO
- ERP Tally
- ERP Tally Prime
- QlikView
- Tableau
- Power BI
- MS Office
- Advance Excel
- MS Outlook
- MS Access
- Micros
- VBA
Certification
- Business Analytics from Simplilearn
- Diploma in Advance Accounting (CIA+) from the Institute of Computer Accountants.
- IGNLP Certificate in Advanced NLP Leadership & Management.
- Business intelligence with Power BI Desktop.
- Accounting-Financial Accounting Total-Beginners to Advanced.
- Certified eCommerce Management Professional CPD Accredited.
- Transformational Leadership - Leadership Course & Training.
- Data Visualization in Excel: All Excel Charts and Graphs.
Auditing Assignments
- HCL Technologies Ltd.
- L'Oreal India Private Limited.
- Himalayan Natural Mineral Water.
Languages
- English
- Hindi
Personal Information
- Passport Number: S2202182
- Passport Expiry Date: 07/25/28
- Date of Birth: 07/04/92
- Marital Status: Married
Timeline
Assistant Manager Accounts
Adilaxmi E-Commerce Private Limited
01.2020 - Current
Senior Executive
WS Retail Services Private Limited
05.2017 - 12.2019
Senior Executive
DHFL Pramerica Life Insurance Company Ltd.
09.2016 - 04.2017
Executive
Askme.com (Getit Grocery Private Limited)
04.2015 - 08.2016
Executive
Accelity BestAtLowest Online Services Private Limited
12.2012 - 03.2015
Account Assistant
R. C. Apparels
08.2011 - 11.2012
- Business Analytics from Simplilearn
- Diploma in Advance Accounting (CIA+) from the Institute of Computer Accountants.
- IGNLP Certificate in Advanced NLP Leadership & Management.
- Business intelligence with Power BI Desktop.
- Accounting-Financial Accounting Total-Beginners to Advanced.
- Certified eCommerce Management Professional CPD Accredited.
- Transformational Leadership - Leadership Course & Training.
- Data Visualization in Excel: All Excel Charts and Graphs.
M.B.A. - Financial Management
Annamalai University
B. Com - Graduation
Deen Dayal Upadhyay Gorakhpur University
Intermediate - Commerce
UP Board
10th Standard - Science
UP Board
Similar Profiles
DEENRAJ THIRUVENGADAMDEENRAJ THIRUVENGADAM
Fleet Manager at Blinkit Commerce Private LimitedFleet Manager at Blinkit Commerce Private Limited
KARTHIK CHEETURIKARTHIK CHEETURI
Business Manager at Meragi Events E-Commerce Private LimitedBusiness Manager at Meragi Events E-Commerce Private Limited
Yogeshwari RawatYogeshwari Rawat
Category and Catalogue Management at POPBAZZAR ONLINE E-COMMERCE Private LimitedCategory and Catalogue Management at POPBAZZAR ONLINE E-COMMERCE Private Limited